Category: Uncategorized

Comp3113_Hui-Zhao_101159615_Analysis-on-cryptography-for-cyber-security.docx

Project_Winter_2020-COMP3121_GBC_101159615_HuiZhao

Comp3113_Project_Testing-of-fundamental-Sguil-operations

Ref:

https://blog.securityonion.net/2011/01/introduction-to-sguil-and-squert-part-1.html

GPU acceleration enabled

Model	Part Number	Base Clock (GHz)	Pricing
Core i9-10900K	CM8070104282844	3.7	$562
Core i9-10900KF	CM8070104282846	3.7	$532
Core i9-10900	CM8070104282624	2.8	$506
Core i9-10900T	CM8070104282624	1.9	$506
Core i9-10900F	CM8070104282625	2.8	$476
Core i7-10700K	CM8070104282436	3.8	$436
Core i7-10700KF	CM8070104282437	3.8	$405
Core i7-10700	CM8070104282327	2.9	$376
Core i7-10700T	CM8070104282215	2.0	$376
Core i7-10700F	CM8070104282329	2.9	$346
Core i5-10600K	CM8070104282134	4.1	$296
Core i5-10600KF	CM8070104282136	4.1	$266
Core i5-10600	CM8070104290312	3.3	$250
Core i5-10600T	CM8070104290410	2.4	$250
Core i5-10500	CM8070104290511	3.1	$226
Core i5-10500T	CM8070104290606	2.3	$226
Core i5-10400	CM8070104290715	2.9	$215
Core i5-10400T	CM8070104290806	2.0	$215
Core i5-10400F	CM8070104290716	2.9	$185
Core i3-10320	CM8070104291009	3.8	$184
Core i3-10300	CM8070104291109	3.7	$171
Core i3-10300T	CM8070104291212	3.0	$171
Core i3-10100	CM8070104291317	3.6	$147
Core i3-10100T	CM8070104291412	3.0	$147
Pentium G6600	CM8070104291510	4.2	$105
Pentium G6500	CM8070104291610	4.1	$93
Pentium G6500T	CM8070104291707	3.5	$93
Pentium G6400	CM8070104291810	4.0	$81
Pentium G6400T	CM8070104291907	3.4	$81
Celeron G5920	CM8070104292010	3.5	$68
Celeron G5900	CM8070104292110	3.4	$56
Celeron G5900T	CM8070104292207	3.2	$56

works:

1.Camera

2.iMessage

3.FaceTime

not works:

1.Find my device

2.AppleMap

3.gpu acceleration

https://drive.google.com/file/d/1HIzrKZ_e_URDptgwwJXL0TPsk74Xt5ig/view?usp=sharing

Data types

MySQL

There’s a shitload of data types, really, just go look at the official documentation and bask in the glory of MySQL redundancy (j/k).

SQLite

Very few, reassuring and simple data types. Basically text, numbers, and “whatever” (blob). Again, go look at the official documentation.

Database connection

MySQL

$GLOBALS["dbcon"]=@mysqli_connect($dbhost, $dbuser, $dbpass);
if (mysqli_error($GLOBALS["dbcon"])) die("errore connessione db");
@mysqli_select_db($GLOBALS["dbcon"],$dbname);
if (mysqli_error($GLOBALS["dbcon"])) die("errore connessione db");
@mysqli_set_charset($GLOBALS["dbcon"],'utf8');
if (mysqli_error($GLOBALS["dbcon"])) die("errore connessione db");

SQLite

$db = new SQLite3(dirname(__FILE__)."/DB/db.sqlite");
$db->busyTimeout(5000);
// WAL mode has better control over concurrency.
// Source: https://www.sqlite.org/wal.html
$db->exec('PRAGMA journal_mode = wal;');
$db->exec('PRAGMA synchronous=NORMAL;');

(last couple of rows are only useful if you plan to have some -little- write-concurrency, otherwise don’t use them)

Very important thing to know: if you are writing code for a local-running application, SQLite connections will not “time out” as there’s no server to wait for your input, just a file on the disk (or memory, even!)

Queries

MySQL

$results=mysqli_query($GLOBALS["dbcon"],$query);

SQLite

$db->exec($query);

when you don’t expect results, so for INSERT, UPDATE or DELETE

$results=$db->query($query);

when you expect multiple results, or several fields in a row

$value=$db->singleQuery($query);

when you want returned a single-value result, for example when the query is something like SELECT timestamp FROM records WHERE id=$number LIMIT 1 (for this, with MySQL, you should parse the results with mysqli_fetch_array or similar, and then select the first value with [0])

Fetch results

MySQL

$row=mysqli_fetch_array($results);

when you want both associative and indexed arrays,

$row=mysqli_fetch_assoc($results);

when you only need associative arrays, and

$row=mysqli_fetch_row($results);

if you want only indexed arrays.

SQLite

In parallel with above:

$row=$results->fetchArray();

$row=$results->fetchArray(SQLITE3_ASSOC);

$row=$results->fetchArray(SQLITE3_NUM);

Speed considerations

If you don’t need associative arrays, you should always go for indexed arrays, since both in MySQL and SQLite they are fetched significantly faster; also, even if by very little, fetching only associative arrays is still faster then having both associative and indexed fetched together (and you’re not going to need those both anyway).

Escaping

MySQL

mysqli_real_escape_string($GLOBALS["dbcon"],$string);

SQLite

SQLite3::escapeString($string);

this function is not binary safe though at the time of writing (hasn’t been for a while from what I understand…)

Database functions

Just converting the PHP functions won’t be sufficient for most.

Think about time functions for examples, or DEFAULT values, or NULLing a NOT NULL timestamp column to have it automatically assigned to CURRENT_TIMESTAMP, these things are not present in SQLite.

MySQL

DEFAULT CURRENT_TIMESTAMP

NOW(), YEAR(), TIMEDIFF(), and another shitload of functions.

SQLite

DEFAULT (Datetime('now','localtime'))

Several variations on the strftime() functions, of which the Datetime() above is an example.

Again, go look at the official documentation, as what you see above is my own translation for my own purposes, and you will find both in official sources and in the vast world of StackOverflow a plethora of readings and interpretations.

sudo nano +85 /usr/local/bin/virtualenvwrapper.sh

VIRTUALENVWRAPPER_ENV_BIN_DIR="usr/lib/bin" 
Change to:
VIRTUALENVWRAPPER_ENV_BIN_DIR="bin"