Adminer

Adminer is a fully featured database management tool written in PHP. Adminer is an alternative to phpMyAdmin where we can manage content in MySQL, SQLite, Oracle, PostgreSQL databases effectively.

Adminer Features

> Basic functions : Add/remove/modify the databases and tables
> Modify database objects (views, triggers, procedures, user permissions, variables, processes etc.)
> Execute SQL commands from a text field or a file.
> Import and export databases and tables.
> Export database, data, structure, views, routines to SQL or CSV. Continue reading…

Outgoing mail issue in Qmail using configured SMTP routes

If you are facing issue with outgoing mail service in Linux-Qmail server, where all the outgoing emails OR emails to any specific domain are getting stuck in the remote queue, have a try with the below solution .

Issue :

Outgoing mails getting queued in remote queue with below error in the server mail log (/usr/local/psa/var/log/maillog) :

==========
delivery 24075 : deferral: Sorry,_I_wasn’t_able_to_establish_an_SMTP_connection._(#4.4.1)/
qmail: xxxxxx.xxxxxxx status: local 0/10 remote 0/20
==========
Continue reading…

Plesk update error/auto-installer error

If you are getting the below error while updating the Plesk versions or installing the microupdates , have a try with the mentioned solution :

—-
ERROR: Unable to download the MD5 sum for the new Parallels Installer binary.
Not all packages were installed.
Please, contact product technical support.
—-

Solution :
—–
Remove cache from /var/cache/parallels_installer/ and start auto-installer again.
—–

If you require help, contact SupportPRO Server Admin

Server not running properly? Get A FREE Server Checkup By Expert Server Admins - $125 Value

FTP connectivity problem

If you are getting following error while directory listing, follow the solution provided below :

———-
ftp> ls
227 Entering Passive Mode (108,61,169,245,167,161).
ftp: connect: No route to host
———-

Solution :

1. Edit /etc/sysconfig/iptables-config and add this line:

IPTABLES_MODULES=”ip_conntrack_ftp”

2. Save it and restart iptables.

That’s because passive mode use non standard ports to communicate, so you need to keep track of the ftp connections and iptables will allow them when necessary.

Another solution is specify the passive ports that will be used on FTP server configuration, then open those specific ports on firewall.

If you require help, contact SupportPRO Server Admin

Server not running properly? Get A FREE Server Checkup By Expert Server Admins - $125 Value