buy tb-500

How to fix if MySQL cannot telnet from outside the server

June 17th, 2011 by ayad

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

June 17th, 2011 by ayad

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

June 17th, 2011 by ayad

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

June 17th, 2011 by ayad

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

June 17th, 2011 by ayad

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

Cannot lock Container

June 8th, 2011 by ayad

check lock file and remove PID :

vi /vz/lock/434.lk
ps aux | grep vz //check vzquota is running , kill the process

References

http://kmaiti.blogspot.com/2010/05/cannot-lock-container.html

http://kb.parallels.com/655

Mail Server Configuration Restore: mchk.exe (domains missing from smartermail)

June 5th, 2011 by ayad

his command checks and restores the missing mail configuration data for all domains, and, if errors are found in the existing domain settings, reconfigures them:

In order to run the command you need to go to RUN in start then run this %plesk_bin%

then go to command prompt and CD :/ to that directory

then run the command

mchk.exe –all-domains –fix=local

The command will take time to restore all the domains in smartermail

Thank you.

Know WHM/Cpanel Logs in details

June 4th, 2011 by ayad

cPanel/WHM Initial Installation Errors:
Location : /var/log/cpanel*install*
Description : These log files contain cPanel installation logs & should be referenced first for any issues resulting from new cPanel installations..

————————————————————————————————————————————————–

Cpanel/WHM Accounting Logs:
Location : /var/cpanel/accounting.log
Description : Contains a list of accounting functions performed through WHM, including account removal and creation..

————————————————————————————————————————————————–

Cpanel/WHM Service Status Logs:
Location : /var/log/chkservd.log
Description :The service monitoring demon (chkservd) logs all service checks here. Failed service are represented with a [-] and active services are represented by [+].

————————————————————————————————————————————————–

cPanel error logs:
Location : /usr/local/cpanel/logs/error_log
Description : cPanel logs any error it incurs here. This should be checked when you encounter errors or strange behavior in cPanel/WHM…

————————————————————————————————————————————————–

cPanel License Error Logs:
Location : /usr/local/cpanel/logs/license_log
Description : All license update attempts are logged here. If you run into any errors related to license when logging in, check here.

————————————————————————————————————————————————–

Stats Daemon Logs:
Location : /usr/local/cpanel/logs/stats_log
Description : The stats daemon (cpanellogd) logs the output from all stats generators (Awstats, Webalizer, Analog) here.

————————————————————————————————————————————————–

Client Information, Requested URL Logs:
Location : /usr/local/cpanel/logs/access_log
Description : General information related to access cPanel requests is logged here.

————————————————————————————————————————————————–

cPanel/WHM Update Logs:
Location : /var/cpanel/updatelogs/update-[TIMESTAMP].log
Description : Contains all output from each cPanel update [upcp]. It’s named with the timestamp at which the upcp process was initiated..

————————————————————————————————————————————————–

Bandwidth Logs:
Location : /var/cpanel/bandwidth
Description : Files contain a list of the bandwidth history for each account. Each named after their respective user.

————————————————————————————————————————————————–

Tailwatchd [New]:
Location : /usr/local/cpanel/logs/tailwatchd_log
Description : Logs for daemon configuired under tailwatchd ie. cPBandwd, Eximstats, Antirelayd.

————————————————————————————————————————————————–

————————————————————————————————————————————————–

Apache Logs:.

General Error and Auditing Logs:
Location : /usr/local/apache/logs/error_log
Description : All exceptions caught by httpd along with standard error output from CGI applications are logged here..
The first place you should look when httpd crashes or you incur errors when accessing website.

————————————————————————————————————————————————–

Apache SuExec Logs:
Location : /usr/local/apache/logs/suexec_log
Description : Auditing information reported by suexec each time a CGI application is executed. Useful for debugging internal server errors, with no relevant information being reported to the Apache error_log, check here for potential suexec policy violations…

————————————————————————————————————————————————–

Domain Access Logs:
Location : /usr/local/apache/domlogs/domain.com
Description : General access log file for each domain configured with cPanel.

————————————————————————————————————————————————–

Apache Access Logs:
Location : /usr/local/apache/logs/access_log
Description : Complete web server access log records all requests processed by the server.

————————————————————————————————————————————————–

————————————————————————————————————————————————–

Exim Logs :.

Message Reception and Delivery:
Location : /var/log/exim_mainlog or /var/log/exim/mainlog
Description : Receives an entry every time a message is received or delivered.

————————————————————————————————————————————————–

Exim ACLs/Policies based RejectLog :
Location : /var/log/exim_rejectlog
Description : An entry is written to this log every time a message is rejected based on either ACLs or other policies eg: aliases configured to :fail

————————————————————————————————————————————————–

Unexpected or Fatal Errors:
Location : /var/log/exim_paniclog
Description : Logs any entries exim doesn’t know how to handle. It’s generally a really bad thing when log entries are being written here, and they should be properly investigated..

————————————————————————————————————————————————–

IMAP/POP/SpamAssassin General Logging and Errors:
Location : /var/log/maillog & /var/log/messages
Description : The IMAP, POP, and SpamAssassin services all log here. This includes all general logging information (login attempts, transactions, spam scoring), along with fatal errors.

————————————————————————————————————————————————–

————————————————————————————————————————————————–

FTP Logs:

FTP Logins and General Errors:
Location : /var/log/messages
Description : General information and login attempts are logged here..

————————————————————————————————————————————————–

FTP Transactions logging:
Location : /var/log/xferlog or /var/log/messages
Description : Is a symbolic link in most cases to /usr/local/apache/domlogs/ftpxferlog, which contains a history of the transactions made by FTP users…

————————————————————————————————————————————————–

————————————————————————————————————————————————–

MySQL Logs:.

MySQL General Information and Errors :
Location : /var/lib/mysql/$(hostname).err
Description : This path could vary, but is generally located in /var/lib/mysql. Could also be located at /var/log/mysqld.log

————————————————————————————————————————————————–

————————————————————————————————————————————————–

Security Logs:

Authentication attempts:
Location : /var/log/secure
Description : Logs all daemons which requires PAM Authentication.

————————————————————————————————————————————————–

Authentication attempts:
Location : /var/log/secure
Description : Logs all daemons which requires PAM Authentication.

————————————————————————————————————————————————–

Tracking all Logins and Logouts:
Location : /var/log/wtmp
Description : The wtmp file records all logins and logouts.

————————————————————————————————————————————————–

Last Logins:
Location : /var/log/lastlog
Description : Database times of previous user logins. The lastlog file is a database which contains info on the last login of each user.

————————————————————————————————————————————————–

WebDav or WebDisk Log :
Location : /usr/local/cpanel/logs/cpdavd_error_log
Description : The cpdavd daemon is “WebDav” (better known as “WebDisk”) which was introduced in cPanel 11 to allow users to mount their home directory on their personal computer, always having access to the files and content…

————————————————————————————————————————————————–

Cphulkd Logs:
Location : /usr/local/cpanel/logs/cphulkd_errors.log
Description : cPHulk Brute Force Protection prevents malicious forces from trying to access your server’s services by guessing the login password for that service….
It blacklists IPs that it thinks are trying to run a brute force attack.

————————————————————————————————————————————————–

Failure Logging:
Location : /var/log/faillog
Description : Faillog formats the contents of the failure log from /var/log/faillog database. It also can be used for maintains failure counters and limits. Run faillog without arguments display only list of user faillog records who have ever had a login failure.

————————————————————————————————————————————————–

Startup/Boot, Kernel & Hardware error messages :
Location : /var/log/dmesg
Description : dmesg is a “window” into the kernels ring-buffer. It’s a message buffer of the kernel. The content of this file is referred to by the dmesg command. It shows bootlog and the hardware errors..

————————————————————————————————————————————————–

————————————————————————————————————————————————–

Tomcat Logs:

General Startup, Shutdown & Error Logs:
Location : /usr/local/jakarta/tomcat/logs/catalina.err and /usr/local/jakarta/tomcat/logs/catalina.out
Description : Logs for Tomcat and all tomcat based applications…

————————————————————————————————————————————————–

THANK YOU

————————————————————————————————————————————————–

How to move an addon domain from one cPanel to another

June 4th, 2011 by ayad
  1. Download the content of your addon domain to your local PC.
  2. Backup any associated database(s).
  3. Create a subfolder inside the new cPanel’s public_html folder.
  4. Upload the content of your addon domain to this new folder.
  5. Restore the database backup(s) into the new cPanel.
  6. If the old cPanel and new cPanel are on the same server, go back to the old cPanel and remove the addon domain from under the Addon Domains icon. (You do not need to delete the original content or original databases.)
  7. Go to the new cPanel and click the Addon Domains icon. Enter the addon domain name where it says “New Domain Name”.
  8. For the “Document Root” you must enter /public_html/subfolder/ (replace ‘subfolder’ with the name you chose in step 3). Fill out the remainder of the form and click the Add Domain button.
  9. If the old cPanel and new cPanel are on different servers, then you will need to update your addon domain name’s nameservers (or other DNS records).

Warning: Cannot modify header information – headers already sent by (output started at /home/rayg1/public_html/dogtraining/wp-content/plugins/tubepress/classes/net/php/pear/HTTP/Request2/Adapter.class.php:297) in /home/rayg1/public_html/dogtraining/wp-includes/pluggable.php on line 865

May 28th, 2011 by ayad

The solution is just delete this plugin  ” tubepress”

i have applied the solution my self and fixed the issue.

Thank you.