Unable To Connect Or Authenticate To The ZPanel Database

May be you have using unmanaged or self managed vps or dedicated server for your hosting service. Because, many self managed servers are controlling by ZPanel. ZPanel is a free web hosting cantrol for all. If you are using ZPanel on your server and you feel any problems with your ZPanel or Server. Then you can feel free to contact with us for any time. We will fix your ZPanel or server problems. Also you can cantact with us for any tips or informations about web development.
Unable to connect or authenticate to the ZPanel database
Now we shared a problem solution with your ZPanel. Have you problem with youe ZPanel to login or access to ZPanel Control Panel? Oky, It's time to fix your ZPanel login or access problem by your self. We will help you by sharring some valuable information about this problem. But, it need to do by your self to fix your ZPanel problem. Are you showing a Critical Error: [0100] message like this.
Critical Error: [0100] - Unable to connect or authenticate to the ZPanel database (zpanel_core).
We advice that you contact the server administrator to ensure that the database server is online and that the correct connection parameter are being used.
Most of the time this problem created for exceeding ram maximum usage. You should maintain your RAM usage under 80% as maximum. Do not exceeding ram maximum usage like 90% Or overall 100%. If you want to speed up your server your should maintain your RAM usage under 60%-70%. When your RAM usage will be 90% Or overall 100%. When you have no RAM space to spend for using ZPanel. Therefore you feel a problem like Critical Error: [0100] on your Zpanel. So how to fix this problem if that created for exceeding ram usage?

How to fix exceeding ram usage to fix ZPanel problem

Check Ram Usage By SSH
To check your ram usage of your server you need to use following command on SSH.
free -m
By using this command you can show you ram usage details. If you show your server ram cached very high. Then you can clear your ram cache by using following commands.
Clear Up Ram By SSH
  • Clear Page Cache
sync; echo 1 > /proc/sys/vm/drop_caches
  • Clear dentries and inodes
sync; echo 2 > /proc/sys/vm/drop_caches
  • Clear dentries and inodes
sync; echo 3 > /proc/sys/vm/drop_caches
If you feel any problem to clear up your server ram. Then you need to restart/reboot your server. To restart/reboot your server by ssh you can use following command.
Reboot Your Server By SSH
If you have any problem to restart/reboot your server by ssh. So you should restart your server from your Hosting Control Panel.
If your server ram was cleared. After that be sure that many free space avaliable on your server ram. Your server should be 512 MB free space. Your total ram should be at least 1GB to using better server and ZPanel. Now try to enter your ZPanel Control Panel using your server IP inside your web browser.
If this problem was not soloved yet. Please check your mysql service is running on your server.

How to fix mysql service to fix ZPanel problem

Check Mysql Service Status By SSH
Now check your mysql service is running or stop/waiting. To check your mysql service status use following command on ssh.
service mysql status
  • If you show mysql status like “mysql start/running, process 415”. That means your mysql service is ok and it's running now.
  • If you show mysql status like “mysql stop/waiting”. That means your mysql service is not ok and it's not running now.
So how you can fix your mysql service problem? If your mysql service status is stop/waiting. Now try to start or restart your mysql service by using following commands on ssh.
  • Start Mysql Service
service mysql start
  • Stop Mysql Service
service mysql stop
  • Restart Mysql Service
service mysql restart
  • Check Mysql Service Status
service mysql status
After that your mysql service will be start/running. If your mysql service running then your ZPanel problem solved. If you have any problem to start/running your mysql service. Please feel free to send a feedback to us. We will help you to solve your mysql service problem. You can also contact with web developer to fix your mysql service problem. We have shared some valuable information to fix your mysql service problem. In this time you need to backup your FTP data and MySql data. Now try following ways to backup your FTP and MySql storage in your computer.

How to backup your FTP and MySql Database

If your can't login or access to your ZPanel Control Panel. So you can't backup your FTP and MySql data from ZPanel. Please try following steps to backup your data.
Step 1: Download And Install FileZila On Your Computer.

To download FileZilla For Your Windows 32/64bit, Mac OS X and Linux. Click the following “Click Here To Download FileZilla” button. Then your will got a tutorial about how to download FileZilla. You will got also a tutorial about how to use FileZilla.

Step 2: Download Your File Or Directory Using FileZilla.
Login into your FTP Or SFTP with FileZilla.

Now you should browse currect ftp directory where is your file or folder. Now press “Right Click” on your file or folder which you want to download. Then click on “Download” option. After that download geting started which you queued for download. You can see status about your download in under the transfer queue option screen.

If you want to cancel your download. So you can cancel your download in transfer queue option. This cancellation done by press  “Right Click” on transfer queue option and click on “Stop And Remove All” option. You can also pause your download by unmark Process option. This process option is show on transfer queue option.

Look up where is your public_html and mysql database location in ftp.
public_html directory location
In public_html directory your can download your website all contents.
mysql database directory location
In mysql directory you can see directory name like your mysql database. Suppose  your database name is zadmin_google. So you will see a directory name like zadmin_google in mysql directory. Now you need to download each database directory which you want to backup.

When downloading completed please follow other steps.
Step 3: Reinstall Your Server OS

Reinstall your server os which you like to using for your server. This server os reinstallation will be available on your Web hosting providers Control Panel.
Step 4: Install ZPanel On Your Server

Now you need to install ZPanel on your server. If you are using Ubuntu OS 12.04 Or 14.04. So we have shared an article about how you can install ZPanel on your server.

Install ZPanel On Ubuntu Server 12.04 Or 14.04

If you want to install ZPanel on Ubuntu Server. So need to read this article “How To Install ZPanel 10.1.1 On Ubuntu Server 12.04 Or 14.04”. You can read this article to install ZPanel on your Ubnutu OS Server.
Step 5: Add your domain name in ZPanel Domains option
You should add all of your domain names on ZPanel which you want using on this server. Be mindful when you added domain names on ZPanel. You should be careful to add domain names on ZPanel.
Step 6: Create mysql database and username on ZPanel
You should create all mysql database and username on ZPanel which you want to using on this server. Be mindful when you creating mysql database and username on ZPanel. You should be careful to create database and username on ZPanel.
Step 5: Upload File Or Directory Which You Have Downloaded
Login into your FTP Or SFTP with FileZilla.

Now you should browse currect ftp directory where your want to upload. Now browse your computer folders in local directory tree option in FileZilla. This local directory tree option is show in left side of FileZilla Client Software screen. When you have browsed in currect folder from your computer using local directory option. Then press “Right Click” on currect item which you want to upload. Now click on Upload option to start upload queue. You can see status about your download in under the transfer queue option screen.

If you want to cancel your upload. So you can cancel your upload in transfer queue option. This cancellation done by press  “Right Click” on transfer queue option and click on “Stop And Remove All” option. You can also pause your download by unmark Process option. This process option is show on transfer queue option.

Upload public_html File Or Directory
You need to upload each domain data files or directory in each domain root directory in public_html.
Do not delete each domain root directory from public_html if you are uploading domain file or directory with domain root directory as root user.
Upload mysql database files on mysql database directory
You need to upload all database files on each directory like /var/lib/mysql/Your Database Directory.
Do not delete each mysql database directory from /var/lib/mysql when you are uploading mysql database files on mysql database directory. You should just upload each mysql database files on each mysql database directory.

ZPanel Database Problem Solved

If you have reading this article and complete all steps about problem solving. So your ZPanel access or ZPanel database (zpanel_core) problem have to be solved. If you have any problem to understand about this problem solving. You can feel free to cantact with us. We try to solve your ZPanel Or Server problems as soon. You can aslo submit your comment about your problems in under comment box.

Thanks for reading! If you like this article. Please share this article on social networks.
Tags: 10.0 0.2 login; 10.1 0.1 login; 5.7 1; 5.7 1 relay access denied; 5.7 1 smtp; 530 5.5 1; 530 5.5 1 authentication required; 550 5.7 1 relay access denied; 550 5.7 1 relaying denied; 550 site chmod command failed; 554 5.7 1; 554 5.7 1 delivery not authorized; 554 5.7 1 error; 554 5.7 1 error need authentication from; 554 5.7 1 outlook; 554 5.7 1 relay access denied; 554 5.7 1 relay access denied postfix; 554 5.7 1 service unavailable; 554 blocked; 554 delivery error; 554 denied; 554 email; 554 error; 554 relay access denied; 554 smtp; a email or an email; access denied; access denied error; access denied meaning; agax antivirus; ajenti demo; ajenti plugins; an auth plugin is required to fetch a token; anymail; auth in main server; authenticate to; authenticate to the zpanel database; bind digitalocean; bind9 digitalocean; bluehost login webmail; cannot safely connect to server; daemon mailer; destiny item manager firefox; diagnostic code smtp 554 5.7 1 relay access denied; digital ocean bind; digitalocean community; digitalocean dns ttl; digitalocean webmail; do i have any emails; dovecot auth; dovecot sasl; dovecot smtp; download roundcube; download xampp; download xampp 1.7 1; e mail client; em mail client; email 5.7 1; email 554; email 554 5.7 1; email base; email error 554; email relay; error 554; error 554 5.7 1; fatal no sasl authentication mechanisms; feenix database; foxy utils; freenas plugins list; hmailserver webmail; hover webmail; how to install roundcube; how to install zpanel on ubuntu 14.04 digitalocean; how to set up webmail; how to setup a email; how to setup roundcube; http 10.0 0.2 login; http localhost security xamppsecurity php; install email program; install phpmyadmin mac; install vestacp; install zpanel; iredmail smtp; jps citrix; just host webmail; just host webmail login; list of email clients; localhost security xamppsecurity php; login bluehost webmail; loops back to myself; lotus notes rtss; mac mail client; mac os 10.6 5; mac os x 10.6 5; mac os x server download; mac server setup; mail 554; mail client; mail daemon; mail delivery subsystem spam; mail delivery system mailer daemon; mail delivery system spam; mail error 554; mail for loops back to myself; mail scanner; mail setup assistant; mailer daemon; mailer daemon message; mailer daemon spam; mailer deamon; mailscanner; mediatemple webmail; mercury webmail; mydestination postfix; mysql string length; no sasl authentication mechanisms; online mail client; os x 10.6 5; outlook 554 5.7 1; outlook relay access denied; php ssh2_connect; phpmyadmin; pop3 email client; postfix access; postfix authentication; postfix connection refused; postfix dovecot sasl; postfix error log; postfix mail relay; postfix mydestination; postfix relay access denied; postfix sasl; postfix smtp authentication; postfix smtp authentication ubuntu; postfix smtp relay; postfix virtual_alias_maps; postfix windows; reason 554 5.7 1; relay access denied; relay access denied 554 5.7 1; relay access denied outlook; relay access denied postfix; relay access denied smtp; relaying denied; response 554; return code 554; roundcube config; roundcube demo; roundcube download; roundcube email; roundcube email login; roundcube email server; roundcube imap; roundcube login; roundcube login page; roundcube mail; roundcube mail login; roundcube mail server; roundcube outgoing mail server; roundcube server; roundcube server settings; roundcube serveriai; roundcube setup; roundcube smtp; roundcube smtp authentication; roundcube smtp server; roundcube smtp server does not support authentication; roundcube smtp server settings; roundcube web; roundcube webmail; roundcube webmail app; roundcube webmail inbox; roundcube webmail login; roundcube webmail login email; roundcube webmail login page; roundcubemail; roundcubemail login; rtss lotus notes; said 554 5.7 1; sasl authentication; sasl authentication failed; sasl login authentication failed; sasl login authentication failed authentication failure; sasl plain authentication failed; secure email client; sentora ssl; sentora ssl module; server 554; server error 554; server error 554 5.7 1; server error 554 5.7 1 relay access denied; server responded 553 5.7 1; server responded 554 5.7 1; set email; setup roundcube; sftp connection reset by peer; simple email client; smtp 5.7 1; smtp 554; smtp 554 5.7 1; smtp 554 denied; smtp error 554; smtp relay access denied; snow leopard server download; space engineers access denied; ssh2_auth_password; ssh2_connect; ssh2_connect php; ssl sentora; status 5.7 1; string length mysql; telnet smtp auth; the server responded 554 5.7 1; the server response was 5.7 1; top email clients; unable to connect; unable to connect to the database; unable to connect to the database server; undelivered mail returned to sender spam; up webmail; upgrade phpmyadmin; vestacp; vestacp install; web based email client; web email client; web setup; webmail bluehost login; webmail cube; webmail justhost; webmail login bluehost; webmail login roundcube; webmail on; webmail one and one; webmail roundcube; webmail roundcube login; webmail roundcube login page; webmail your server; webmail yourserver; webset; what does relay access denied mean in outlook; what is an email client; what is email client; what is mailer daemon; what is zpanel; what to do if an app keeps crashing; which of the following is an installed email client; while receiving the initial server greeting; wordpress access denied; www 10.0 0.2; xampp 1.7 2; xampp control panel download; xampp latest version; zpanel; zpanel default login; zpanel demo; zpanel forum; zpanel install ubuntu; zpanel login; zpanel ssl; zpanel tutorial; zpanel ubuntu 14.04; zpanel webmail; zpanelcp

No comments: