Perşembe, Nisan 29, 2010

Mysql Backup Restore

I think it would be only possible to restore data correctly when restoring my mysql backup file, after converting it to ISO8859-1 from UTF-8 by the following command
iconv -f UTF-8 -t ISO8859-1 backup.sql.

Salı, Nisan 27, 2010

Windows 7 NFS Services

Finally Windows 7 Ultimate and/or Enterprise releases have NFS clients prebuild. To use them you must enable them by enabling windows' programs. After enabling, you can mount a nfs share using a simple mount command as you do when mapping drives   like
mount -o [options] \\ComputerNameorIP[:]\Share DriveName:\
No more looking for third party nfs clients/servers.

Perşembe, Nisan 22, 2010

Solaris 10 AMP (SAMP)

Newly installed Solaris 10 on Virtualbox. There are some ways to install AMP on it like using www.blastwave.org's packages or using CoolStack packages. I chose the latter and downloaded files from CoolTools website at sunsource.net. Following the instructions it installed files into /opt/coolstack folder. Apache and php workes like a charm without any configuration or edit. But for mysql there is some little config to do. After installation user and group mysql should be added. Because there comes no database at first, mysql_install_db script should be run. Also my.cnf file need to be added to /opt/coolstack/mysql_32bit/ folder. After those running mysql.server start command initiates the mysql daemon.

Salı, Nisan 20, 2010

Kubuntu FreeNx Sound and Network

Recently I needed to use Nx with my oildu Kubuntu machine.I struggled with many problems to succeed. First of I recognised that Kubuntu network configuration fails (unconfigured) when I dont login to my account and get an X login. I have had network configuration manually edited to files /etc/network/interfaces and /etc/resolv.conf. But I used  know that the manual settings at /etc/network/insterfaces is not considered by the network-manager rather network-manager uses its settings. Because newtwork-manager doesnt start without logging in to X, I was not able to connect to my machine in any way at network. The first major problem. To resolve this I removed network-manager and installed "wicd" instead.Put the appropiate settings to wicd configuration and rebooted the computer.Voila, my machine got connected to the network (I guess it still  uses the wicd settings not the ones at those two files under /etc, but anyway). Now the second problem. OK i installed the freenx by usind freenx-ppa team's repo.But when I  connect to  machine and try to listen to music there is no sound even I check a setting at nxclient like "Add multimedia support". I researched and saw that it needs Esd (Esound) xine plugin. I firstly installed some packages like "pulseaudio-esound-compat" but no help. Then I found a package "libxine1-all-plugins" and installed. Finally choosing this device at Amarok's settings I got the sound from my remote machine. Lots of research and try gave me the sound :))