Salı, Temmuz 29, 2008

Mambo Change

administrator/components/com_content/admin.content.php
line 195 is changed according to sayings on the page
http://forum.mamboserver.com/showthread.php?t=65497

old: . "\n FROM , #__content AS c, #__categories AS cc, #__sections AS s"

new: . "\n FROM #__categories AS cc, #__sections AS s, #__content AS c "
Now com_content is working

Cuma, Temmuz 25, 2008

Change locale

Too simple
export LC_CTYPE=ISO-8859-9

Perşembe, Temmuz 17, 2008

I love this game

Mysql to mysql backup through secured mysql connection between two ends.
The situation is this:
I have two mysql servers behind two modems. Only port 22 is open on modems.
Ports 3306 are open on both servers. First port forward on the server which is going to be backed up by
ssh -L 23306:127.0.0.1:3306 user@remoteserver(backupserver)
Then
mysqldump -t -u localuser -p db | mysql -v --host=127.0.0.1 --port=23306 -u remoteuser -p -C db
makes the magic.
By mysqldump we dump the mysqlserver which is going to be backed up. And point it to the local (forwarded) port 23306 and everything is written to the remote host.
Wow.
BTW, to connect to backup server from local we need this
mysql --host=127.0.0.1 --port=23306
thing.

Çarşamba, Temmuz 09, 2008

Incognito

Incognito is a live cd which makes you invisible on the web.
It uses tor to make you anonym.
It has even virtualisation support.
Take a look at here
http://www.browseanonymouslyanywhere.com/incognito/index.php

DSL (Embedded)

DamnSmallLinux is a cool stuff. It is very small and efficient.
You can put it on a cd (ofcourse), usb flash or even a floppy disk.
It has virtual images to be used with virtualisation.
It even works from *inside* Windows with a magic(QEMU).
http://www.damnsmalllinux.org/

Nfs cdrom share

It is nice to share cd/dvdroms by nfs especially when installing a distro to a non-cdromed box.
From OpenBSD faq:
<br />/mnt/cdrom -alldirs -ro -network=10.0.0 -mask=255.255.255.0<br /></pre>Remember: If you make changes to /etc/exports while NFS is already running, you need to make mountd aware of this! Just HUP mountd and the changes will take affect.  <blockquote><pre># <b>kill -HUP `cat /var/run/mountd.pid`</b><br /><br />http://www.openbsd.org/faq/faq6.html<br />

Perşembe, Temmuz 03, 2008

Burn cd image to a dvd

Sounds strange but useful sometimes.

growisofs -dvd-compat -Z /dev/dvd=cdimage.iso

That's it.