Misc Server Apps

Qmail commands and logs in Plesk Linux server

plesk logo

Plesk uses Qmail as mail server on a Linux server. Here are some useful commands related to Qmail mail server. Hope you find them informative and helpful ! 🙂 1) Start Qmail service service qmail startservice qmail start 2) Stop Qmail service service qmail stopservice qmail stop 3) Status of Qmail service service qmail statusservice qmail status 4) Qmail log …

Read More »

[How To] Update or Change MySQL database timezone

mysql logo

Sometimes you need to change the timezone used by MySQL database for some  specific applications or globally. The below steps will guide you to change the MySQL time zone: 1) Check time_zone* tables in mysql database. If it is empty then insert Zone Info data using following command  mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root …

Read More »

[How To] Change or update Apache time zone

apache logo

If websites are hosted on shared servers and timezone is different, one may demand to change the timezone for his/her website. In this case, there is no need to change the timezone on the server. We can change the timezone for the particular website using following methods. The Apache time zone can be updated in two ways: 1) Using PHP …

Read More »

Plesk error Table ‘mysql.servers’ doesn’t exist

mysql logo

If  you are using Plesk and MySQL you may get a error while adding a MySQL database user to a database as Error: Connection to the database server has failed: Table ‘mysql.servers’ doesn’t exist     To fix this error, SSH  the server as a root user. Execute the command [[email protected] ~]# mysql_fix_privilege_tables --user=admin --password=<admin password> --verbose On executing the …

Read More »