Portal Home > Knowledgebase > Articles Database > dedicated server problem
dedicated server problem
Posted by cenii, 07-11-2016, 12:01 PM |
i have installed on my server Wordpress and now i have about 1k users online and when i want to add new post i get this error Error establishing a database connection
This either means that the username and password information in your wp-config.php file is incorrect or we cant contact the database server at localhost. This could mean your hosts database server is down.
Are you sure you have the correct username and password?
Are you sure that you have typed the correct hostname?
Are you sure that the database server is running?
server info
8x4GB Kingston 4GB DDR3 1Rx8
2GHz Intel Xeon-SandyBridge (E5-2650-OctoCore)
Max Speed:1000 Mbps
|
Posted by TMS - JoseQ, 07-11-2016, 12:12 PM |
If the site is loading, your database is running.
You probably just need to update your user/pass in the config file.
|
Posted by cenii, 07-11-2016, 12:22 PM |
no sometimes i get Error establishing a database connection
|
Posted by TMS - JoseQ, 07-11-2016, 12:27 PM |
If the error is inconsistent, then you may be maxing out your database connections. You can see that with 'show processlist' while connected to mysql. You may need to raise the limit in the my.cnf file.
|
Posted by astutiumRob, 07-11-2016, 12:33 PM |
It's likely the DB is "to busy" at those times - try tweaking the config of MySQL etc and looking at your logs
|
Posted by cenii, 07-11-2016, 12:35 PM |
how can i do this i have whm&cPanel installed
|
Posted by TMS - JoseQ, 07-11-2016, 12:36 PM |
I believe they have a file manager so that you can edit /etc/my.cnf.
Otherwise you will need to ssh into the server and edit that file with vi,pico or any other text editor.
|
Posted by artetatu, 07-11-2016, 12:42 PM |
your DB too busy, you have to optimize your server,
what panel do you use? web server? batabase engine?
server load? memory usage?
|
Posted by cenii, 07-11-2016, 01:03 PM |
now i ****ed up i tried to upgrade to MariaDB and now im getting this error
XID rwyuk9) “/usr/sbin/mysqld” reported error code “1” when it ended. at /usr/local/cpanel/Cpanel/ChildErrorStringifier.pm line 143.
Cpanel::ChildErrorStringifier::die_if_error(Cpanel:afeRun::Object=HASH(0x66b15a8)) called at /usr/local/cpanel/Cpanel/SafeRun/Object.pm line 340
Cpanel:afeRun::Object::new_or_die("Cpanel:afeRun::Object", "program", "/usr/sbin/mysqld", "args", ARRAY(0x2243b38)) called at /usr/local/cpanel/Cpanel/MysqlUtils/Version.pm line 161
Cpanel::MysqlUtils::Version::current_mysql_version() called at whostmgr/bin/whostmgr.pl line 6945
main::mysqlupgrade() called at whostmgr/bin/whostmgr.pl line 860
|
Posted by WPCYCLE, 07-11-2016, 04:58 PM |
Is this server unmanaged?
1. Since you have cpanel;
In WHM locate cpanel support. Send them a ticket about the issue. It may take a few hours, but they're pretty good at fixing things back to a working state, especially if the issue was created within cPanel
2. Get Support!!!
If this server is unmanaged, either ask your provider if they also offer paid support, or look for a server management team or person that can take care of the server for you. not only will they be on-hand to fix such issues...they will go over your server to make sure it's running properly and secured.
In terms of the database losing connection issue...your my.cnf needs to be adjusted, which it may not have been since you've had this server. It can be done through SSH and an editor. But before this can be done, you now need to have the system fixed so you can get the databases back online.
|
Posted by SenseiSteve, 07-12-2016, 02:45 PM |
Unfortunately, you got yourself into a bit of a mess yesterday. Just wondering how things are today? Are your databases back online?
|
Posted by 24x7srvsupport, 07-12-2016, 02:55 PM |
It seems that things are messed up...I hope you are having your database backup. Also, I'll recommend you to contact server management/support companies and optimize your MYSQL database.
|
Add to Favourites Print this Article
Also Read