buy tb500

Archive for June, 2011

Sorry, you are out of ips to assign as nameservers

Friday, June 17th, 2011

Sorry, you are out of ips to assign as nameservers
If you see the error above, you need to manually add it from the server in order to assign the IP address for the
nameserver.
vi /etc/nameserverips
Edit the line as below:
111.222.333.444=ns1.abc.com
111.222.333.444=ns2.abc.com

How to check the version of ImageMagick

Friday, June 17th, 2011

In you want to check the version of ImageMagick, simply ssh to the server and run the command below:
# convert -version
You will get the answer like below:
Version: ImageMagick 6.2.8 10/20/10 Q16 file:/usr/share/Imag
Copyright: Copyright (C) 1999-2006 ImageMagick Studio LLC

How to Increase MaxClients in Plesk

Friday, June 17th, 2011

If you see the error below:
[Tue May 24 18:17:16 2011] [error] server reached MaxClients setting, consider raising the MaxClients setting
You need to increase the value for MaxClients and ServerLimit in /etc/httpd/conf.d/swtune.conf
After that remember to restart apache service by using the command below:
# service httpd restart

How to restart Tomcat service in cPanel server

Friday, June 17th, 2011

In order to restart Tomcat service, you need to:
# cd /usr/local/jakarta/tomcat/bin/
After that, you firstly stop the service:
# ./shutdown.sh
Now you may restart it by using the command below:
# ./startup.sh
If you see the result as below, then the Tomcat already running:
root@server [/usr/local/jakarta/tomcat/bin]# ./startup.sh
Using CATALINA_BASE: /usr/local/jakarta/tomcat
Using CATALINA_HOME: /usr/local/jakarta/tomcat
Using CATALINA_TMPDIR: /usr/local/jakarta/tomcat/temp
Using JRE_HOME: /usr/local/jdk
Using CLASSPATH: /usr/local/jakarta/tomcat/bin/bootstrap.jar

Install Horde in Plesk server using SSH

Friday, June 17th, 2011

You may follow the steps below to install Horde webmail:
# cd /usr/local/psa/admin/bin
After that run the autoinstaller:
# ./autoinstaller –select-release-current –install-component horde
Please wait until the command finish install.

How to fix if MySQL cannot telnet from outside the server

Friday, June 17th, 2011

If you unable to telnet to the port 3306 which is for MySQL from outside the server, firstly you need to check the
firewall. You need to make sure the firewall already allow port 3306.
If the firewall already allow the port, another thing to do is to comment the line below in my.cnf file:
[mysqld] #bindaddress=
127.0.0.1
After that you need to restart the MySQL service for it’s to take effect by using the command below:
root@server [/var/lib/mysql]# service mysql restart
Shutting down MySQL. … SUCCESS!
Starting MySQL. SUCCESS!

Table ‘mysql.servers’ doesn’t exist

Friday, June 17th, 2011

If you see the error above when try to add or delete the database from your control panel, kindly follow the steps
below to fix it:
[root@server ]# mysql_fix_privilege_tables –user=admin
–password=<admin pass> –verbose
You will see the output as below:
This script updates all the mysql privilege tables to be usable by
the current version of MySQL
You can safely ignore all ‘Duplicate column’ and ‘Unknown column’ errors
because these just mean that your tables are already up to date.
This script is safe to run even if your tables are already up to date!
ERROR 1060 (42S21) at line 132: Duplicate column name ‘File_priv’
ERROR 1060 (42S21) at line 138: Duplicate column name ‘Grant_priv’
ERROR 1060 (42S21) at line 139: Duplicate column name ‘Grant_priv’
ERROR 1060 (42S21) at line 140: Duplicate column name ‘Grant_priv’
ERROR 1060 (42S21) at line 151: Duplicate column name ‘ssl_type’
ERROR 1061 (42000) at line 161: Duplicate key name ‘Grantor’
ERROR 1054 (42S22) at line 188: Unknown column ‘Type’ in ‘columns_priv’
ERROR 1060 (42S21) at line 210: Duplicate column name ‘type’
ERROR 1060 (42S21) at line 220: Duplicate column name ‘Show_db_priv’
ERROR 1060 (42S21) at line 237: Duplicate column name ‘max_questions’ ERROR
1060 (42S21) at line 247: Duplicate column name ‘Create_tmp_table_priv’
ERROR 1060 (42S21) at line 250: Duplicate column name ‘Create_tmp_table_priv’
ERROR 1060 (42S21) at line 375: Duplicate column name ‘Create_view_priv’
ERROR 1060 (42S21) at line 378: Duplicate column name ‘Create_view_priv’
ERROR 1060 (42S21) at line 387: Duplicate column name ‘Show_view_priv’
ERROR 1060 (42S21) at line 390: Duplicate column name ‘Show_view_priv’
ERROR 1060 (42S21) at line 410: Duplicate column name ‘Create_routine_priv’
ERROR 1060 (42S21) at line 413: Duplicate column name ‘Create_routine_priv’
ERROR 1060 (42S21) at line 422: Duplicate column name ‘Alter_routine_priv’
ERROR 1060 (42S21) at line 425: Duplicate column name ‘Alter_routine_priv’
ERROR 1060 (42S21) at line 431: Duplicate column name ‘Execute_priv’
ERROR 1060 (42S21) at line 434: Duplicate column name ‘Execute_priv’
ERROR 1054 (42S22) at line 603: Unknown column ‘Event_priv’ in ‘where clause’
ERROR 1060 (42S21) at line 619: Duplicate column name ‘sql_mode’
ERROR 1060 (42S21) at line 658: Duplicate column name ‘originator’
ERROR 1060 (42S21) at line 662: Duplicate column name ‘time_zone’
ERROR 1060 (42S21) at line 665: Duplicate column name ‘character_set_client’
ERROR 1060 (42S21) at line 671: Duplicate column name ‘collation_connection’
ERROR 1060 (42S21) at line 677: Duplicate column name ‘db_collation’
ERROR 1060 (42S21) at line 683: Duplicate column name ‘body_utf8’
ERROR 1054 (42S22) at line 693: Unknown column ‘Trigger_priv’ in ‘where clause’ done
Now you should able to add or delete the database.

Reconfigure vhost in Plesk server

Friday, June 17th, 2011

Sometimes you might have the issue whereby the website going haywire and not viewable. We can solve the issue
by reconfiguring again vhost for the domain by using the steps below:
Open command prompt and hit:
cd %plesk_bin%
After that:
websrvmng.exe –reconfigure-vhost –vhost-name=domain.com
You need to wait for a while for it to finish.

Website requsted for username and password

Friday, June 17th, 2011

Sometimes we face the website requested for username and password when we did some changes in Plesk CP.
To solve the issue follow the steps below:
RDC to the server and then:
cd %plesk_bin%
Hit the command below:
websrvmng.exe –update-anon-password –domain-name=domain.com

How to telnet

Friday, June 17th, 2011

Telnet is one of the way to verify whether the port is open either in your localhost or remote server. To telnet, follow
the steps below:
Open the command prompt.
Enter the command below in command prompt:
telnet IP_address/domain port_number
For example:
telnet 111.222.333.444 26
You should able to get the result as below:
220-xxx.xxx.xxx ESMTP Exim 4.69 #1 Mon, 13 Jun 2011 21:20:45 +0800
220-We do not authorize the use of this system to transport unsolicited,
220 and/or bulk e-mail.
421 xxx.xxx.xxx: SMTP command timeout – closing connection