Open network access for mysql on ubuntu server

Error message came out when I try to access new vps server : $ mysql -ubox-p -h box.rasyid.net Enter password: ERROR 2003 (HY000): Can’t connect to MySQL server on ‘box.rasyid.net’ (61) Edit my.cf file : # nano /etc/mysql/my.cnf find this line : bind-address           = 127.0.0.1 add # in the front into #bind-address           = 127.0.0.1 save …

More

Create tar.gz in OpenSolaris

I need to make backup for our public_html directory using tar command I used to use : tar cvzf  filename.tar.gz directory_name It work in linux or bsd but I have different situation with OpenSolaris : # uname -a SunOS TGLxxxxxxx 5.11 snv_86 i86pc i386 i86xpv # tar cvzf public_html.tar.gz public_html tar: z: unknown function modifier …

More

How to change proxy information on ubuntu server

New motherboard has come and I ask my friend to install Ubuntu Hardy 8.0.4.3 . Everything is fine except proxy section when I try to apt-get update. # apt-get update Err http://security.ubuntu.com hardy-security Release.gpg Could not resolve ‘172.88.1.3;3128′ Err http://security.ubuntu.com hardy-security/main Translation-en_US Could not resolve ‘172.88.1.3;3128′ Err http://security.ubuntu.com hardy-security/restricted Translation-en_US Could not resolve ‘172.88.1.3;3128′ Err …

More

How to change timezone on ubuntu

One of my friend server must get reconfigure its clock each time, specially when the server get reboot after lamp problem. Until he realized the timezone is different. Here’s quick way to change it : # dpkg-reconfigure tzdata Current default timezone: ‘Asia/Jakarta’ Local time is now:      Sat Oct  3 13:02:53 WIT 2009. Universal Time is …

More

How to extend / renew flickr pro account

My wife flickr account pro almost expire, it will expire on October 2009. Since she stay at my mother in law house with our newly born child she ask me to renew her account on flickr. I thought the process is quite clear but I’ll post it for some people that might have difficult on …

More

Howto install Aptana studio with php support

I’m old fashion student who use phpcoder as tool for coding php until my friend suggest aptana editor with php support. When everything configured properly I’ll have php interpreter for immediate debug purpose and I think it’s suitable for new php user I decide to give this software a try and here it goes. Install …

More

WARNING: Found /var/db/mysql/my.cnf

MySQL 5.4 beta already hit freebsd ports and I eager to try it after read a lot of review. Everyhing seem OK until I want to start the server. # /usr/local/etc/rc.d/mysql-server restart mysql not running? (check /var/db/mysql/proxy2.host.com.pid) hmmm, perhaps I can try mysqld_safe # /usr/local/bin/mysqld_safe & [1] 87164 proxy2# WARNING: Found /var/db/mysql/my.cnf Datadir is deprecated …

More

How to Setting ntp client in Mikrotik

RouterBoard have special behavior, that’s my observation after install MT in hard disk and then bought RB433AH. In RB433AH time setting automatically to January 1970 every time its get restart. Till I use ntp (network time protocol) client in MT. The step to set ntp client in MT : 1. Click ‘System’ -> NTP Client. …

More

Setting up RouterBoard RB433 AH

New Mikrotik RB has arrived, its RB433AH wireless indoor. As I never use mikrotik before it’s time to configure it for first use : 1. Download neigbour viewer for windows from mikrotik. 2. Unzip the files using winzip or winrar. Double click to launch neighbour viewer At first time IP address will display 0.0.0.0 it …

More

Install AnsavAnti Virus in Ubuntu Server

Playing around with anti virus lead me to ansav, a free anti virus that convince me to give it a chance for our linux server. Installation process is simple as 123 : 1. Download core engine and update from here. 2. Install ansav. dpkg -i ansav-linux-i386.deb 3. Move latest update to /etc/ansav mv dbs.anv /etc/ansav/ …

More

Detect conflicker in our LAN

Another conflicker variant force us to behave like paranoid. Any tool that might help us to detect it get more attention, specially when it’s free Detect from Windows machine : Download detector from Florian Roth, click here. Save and extract to any folder, I choose C. Make sure to run it from comman line : …

More

Install OpenNMS on FreeBSD

Download # cd /usr/ports/net-mgmt # wget -c http://www.geeklan.co.uk/files/opennms/opennms-164-freebsd-port.tgz –2009-05-15 03:17:40–  http://www.geeklan.co.uk/files/opennms/opennms-164-freebsd-port.tgz Resolving www.geeklan.co.uk… 93.97.185.103 Connecting to www.geeklan.co.uk|93.97.185.103|:80… connected. HTTP request sent, awaiting response… 200 OK Length: 15093 (15K) [application/x-tar] Saving to: `opennms-164-freebsd-port.tgz’ 100%[=====================================================================================================>] 15,093      5.23K/s   in 2.8s 2009-05-15 03:17:45 (5.23 KB/s) – `opennms-164-freebsd-port.tgz’ saved [15093/15093] Extract and delete # tar xvzf opennms-164-freebsd-port.tgz && rm opennms-164-freebsd-port.tgz …

More

Read chm file in opensuse

zypper camo into rescue when I need to read chm file in opensuse : # zypper install chmsee Reading installed packages… The following NEW packages are going to be installed: chmsee chmlib Overall download size: 136.0 K. After the operation, additional 295.0 K will be used. Continue? [YES/no]: y Downloading package chmlib-0.39-101.9.i586 (1/2), 30.0 K …

More

/usr/local/sbin/mysqlblasy.pl Can’t locate Archive/Zip.pm in @INC

# /usr/local/sbin/mysqlblasy.pl Can’t locate Archive/Zip.pm in @INC (@INC contains: /usr/local/lib/perl5/5.8.9/ BSDPAN /usr/local/lib/perl5/site_perl/5.8.9/mach /usr/local/lib/perl5/site_perl/5.8.9 /usr/local/lib/perl5/5.8.9/mach /usr/local/lib/perl5/5.8.9 .) at /usr/local/sbin/mysqlblasy.pl line 1340. BEGIN failed–compilation aborted at /usr/local/sbin/mysqlblasy.pl line 1340. # cd /usr/ports/archivers/p5-Archive-Zip # make install # rehash # /usr/local/sbin/mysqlblasy.pl Can’t locate IO/Compress/Base/Common.pm in @INC (@INC contains: /usr/local/lib/perl5/5.8.9/BSDPAN /usr/local/lib/perl5/site_perl/5.8.9/mach /usr/local/lib/perl5/site_perl/5.8.9 /usr/local/lib/perl5/5.8.9/mach /usr/local/lib/perl5/5.8.9 .) at /usr/local/lib/perl5/site_perl/5.8.9/Compress/Zlib.pm line 11. BEGIN …

More