Creating Self-signed SSL Certificate for your webserver (e.g. Apache2, Lighttpd, and NGINX) :
openssl req -new -x509 -keyout /etc/lighttpd/selfcert.pem -out /etc/lighttpd/selfcert.pem -days 365 -nodes

Filed under: tips | Post a comment

Whoa.. quite long title. Anyway, this trick is given by Rolly Maulana Awangga on <a href=”http://groups.google.com/group/id-ubuntu/browse_thread/thread/659b7d331fdc22ce”>ubuntu-id</a>, so the credit goes to him. I’m just archiving it for usage in the future.
The point is:
1. Insert your WiFi driver installation CD.
2. Browse into the driver folder.
3. Find driver file (the one with .INF extension) and install it […]

Filed under: tips, Windows driver ubuntu ndiswrapper wifi | Post a comment

Stop the mysql service and start it without grant table so that we can go in without password.
# invoke-rc.d mysql stop
# /usr/bin/mysqld_safe –skip-grant-tables &
# mysql –user=root mysql
mysql> update user set Password=PASSWORD(’new-password-here‘) WHERE User=’root’;
mysql> flush privileges;
mysql> quit;
# fg
Then press Ctrl+C to stop MySQL and start again as normal service:
# invoke-rc.d mysql start

Filed under: tips, mysql password recovery | Post a comment

This is how we do it, we disable extended insert.
mysqldump -nt –compatible=ansi,postgresql –complete-insert=TRUE –extended-insert=FALSE –compact –default-character-set=UTF8 -u $DB_USER -p$DB_PASS $DB_NAME $TABLE

Filed under: tips, dbms, mysql, postgresql | Post a comment

Tips berikut ini diberikan oleh Sir Bats (Pak Sabri) di forum ubuntu-id. All credits for him.
–
Yang pengen open-office nya start lebih cepat dari microsoft office :
http://www.zolved.com/synapse/view_content/28209/How_to_make_OpenOffi…

intinya :

buka openoffice (writer/calc)
klik Tools>options> Pilih OpenOffice.org > memory

ganti angka undo step dari default 100 ke 20 / 25 / 30 saya pikir
angka 10 masih masuk akal, kita tidak akan […]

Filed under: tips, openoffice, tips | 1 Comment