Author Archives: Dave

iser target login

MySQL ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal

mysql> create user test identified by password '12345';
ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number

You can resolve this by following the steps listed below.

mysql> select password('12345');
+-------------------------+
| password('123456') |
+-------------------------+
| 2ff898e158cd0311        |
+-------------------------+
1 row in set (0.00 sec)

mysql> create user test identified by password ’2ff898e158cd0311′;
Query OK, 0 rows affected (0.00 sec)

Mysql Remote Access

The VDI is unavailable.

List all VDIs

Forget all VDIs of the VM that cannot start.

Rescan SR, and the true VDIs will be displayed. Reattach these to the VM and then restart.

ndd list tcp variables

ndd /dev/tcp ?

TCP Tuning IPoIB OmniOS

ndd -set /dev/tcp tcp_recv_hiwat 262144
ndd -set /dev/tcp tcp_xmit_hiwat 262144
ndd -set /dev/tcp tcp_max_buf 4194304

Execute script on boot

don’t forget to set the correct permissions on your script, i like 4755 for these types of scripts

ZFS Destroy Snapshot

ZFS Snapshot

ZFS Send Incremental Snapshot