1-30-07

1-30-07, originally uploaded by brunoj.

Long (ish) exposure, handheld. BW’d after the fact.

1-30-07

1-30-07, originally uploaded by brunoj.

 

1-30-07

1-30-07, originally uploaded by brunoj.

Low aperature on aperature priority. BW’d after in iPhoto + slight exposure compensation.

Howto reset wordpress passwords

 Through MySQL Command Line

   1. Get an MD5 hash of your password.
          * Visit MD5 Hasher (http://bfl.rctek.com/tools/?tool=hasher), or...
          * Create a key with Python. or...
          * On Unix: echo -n  | md5sum
   2. "mysql -u root -p" (log in to MySQL)
   3. enter your mysql password
   4. "use (name-of-database)" (select WordPress database)
   5. "show tables;" (you're looking for a table name with "users" at the end)
   6. "SELECT ID, user_login, user_pass FROM (name-of-table-you-found)" (this gives you an idea of what's going on inside)
   7. "UPDATE (name-of-table-you-found) SET user_pass="(MD5-string-you-made)" WHERE ID = (id#-of-account-you-are-reseting-password-for)" (actually changes the password)
   8. "SELECT ID, user_login, user_pass FROM (name-of-table-you-found)" (confirm that it was changed)
   9. (type Control-D, to exit mysql client)

SATA vs. old disk benchmark

SATA disk:
Version  1.03       ------Sequential Output------ --Sequential Input- --Random-
                    -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks--
Machine        Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP  /sec %CP
calamity         4G 34884  73 39605  16 17365   4 29497  49 45563   4 101.1   0
                    ------Sequential Create------ --------Random Create--------
                    -Create-- --Read--- -Delete-- -Create-- --Read--- -Delete--
              files  /sec %CP  /sec %CP  /sec %CP  /sec %CP  /sec %CP  /sec %CP
                 16  2717  98 +++++ +++ +++++ +++  2827  98 +++++ +++  9157  95
calamity,4G,34884,73,39605,16,17365,4,29497,49,45563,4,101.1,0,16,2717,98,+++++,+++,+++++,+++,2827,98,+++++,+++,9157,95

OLD disk:
Version  1.03       ------Sequential Output------ --Sequential Input- --Random-
                    -Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks--
Machine        Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP  /sec %CP
calamity         4G 22080  45 23172   8 11832   2 34181  56 35083   3 157.1   0
                    ------Sequential Create------ --------Random Create--------
                    -Create-- --Read--- -Delete-- -Create-- --Read--- -Delete--
              files  /sec %CP  /sec %CP  /sec %CP  /sec %CP  /sec %CP  /sec %CP
                 16  2699  99 +++++ +++ +++++ +++  2246  99 +++++ +++ 10735  99
calamity,4G,22080,45,23172,8,11832,2,34181,56,35083,3,157.1,0,16,2699,99,+++++,+++,+++++,+++,2246,99,+++++,+++,10735,99

Howto create a binary MySQL backup


1. mysql database files are stored in /var/lib/mysql/
2. just copy to and fro, while the mysql server is not busy
3. if moving database files from one server or disk to another, just
create the database first, (an empty one) with the same name and user
permissions, and then copy the database files from step 1.


Howto create a MySQL database


root@calamity:/Sites/bbd# mysqladmin password [root_password]
root@calamity:/Sites/bbd# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 101 to server version: 5.0.24a-Debian_9-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> CREATE DATABASE [dbase_name];
Query OK, 1 row affected (0.02 sec)
mysql> GRANT ALL PRIVILEGES ON [dbase_name].* TO [dbase_user]@localhost
-> IDENTIFIED BY [password];
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> EXIT
Bye


Howto install SATA disk on calamity


1. plug SATA disk into SATA RAID 1 connector
2. set BIOS to disable SATA BOOT ROM
3. set BIOS to enable Promise Controller
4. set Promise operating mode to IDE (not RAID)
5. set hard disk BOOT order so SATA disk is first
6. done

notes:
1. linux (or grub) thinks SATA disk is /dev/sda
2. linux (or grub) thinks this should be hd1, instead of hd0
3. it only loads if you set it to be hd0 when booting via grub
4. windows XP doesn't see the SATA disk on install (unsolved)


Howto show labels in LaTeX

\usepackage{showkeys}

1-30-07

1-30-07, originally uploaded by brunoj.