Page 2 of 2
Re: Database Error Connection & Timing Out Issues?
Posted: Fri Oct 14, 2016 1:09 pm
by JRobinsonOnline
Guys instead of looking into the dark hole - partly because I'm very limited on this type of stuff and everyone's time os important....
I created a new domain > and attempted to create a DB via my VestaCP. This was not possible I was getting "error connection" issues right from the VestaCP UI. I proceeded via SSH > sudo /etc/init.d/mysqld stop > sudo mysqld_safe --skip-grant-tables & > came back to VestaCP and was able to create the DB.
By the way this is the only way I can log into myPHPAdmin via the VestaCP UI as well....
Once I use the sudo /etc/init.d/mysqld stop > sudo /etc/init.d/mysqld start out of safe mode!!!!!!
The issue comes back. I've confirmed the DB/User/Passwords so I'm clueless as to what the heck is going on???
Re: Database Error Connection & Timing Out Issues?
Posted: Fri Oct 14, 2016 4:48 pm
by mehargags
Ok JRobinsonOnline,
Let me start over... and please try to be as descriptive as you can:
Your Server Specs: RAM / Cores / Storage Space and
who is your provider (
important)
1. How many sites and DBs you have in total ? Are these wordpress ?
2. You said "only one site has problem connecting DB", do the other sites use a DB or are they static ones ?
3. do you have Swap On ? paste result for
4.
5. if it reports ariadb errors, Delete ariadb logs/control file from /var/lib/mysql
6. # optimise and Repair all DBs
mysqlcheck --all-databases -o
mysqlcheck --all-databases --auto-repair
mysqlcheck --all-databases --analyze
after all this
7. # Clean MySQL logs
Code: Select all
> /var/log/auth.log
> /var/log/mysql/error.log
> /var/log/mysql.log
> /var/log/mysql.err
Now access your problem site... and observe errors posted there in the tail.
---------------
Send your observations and we'll try to find the culprit
Re: Database Error Connection & Timing Out Issues?
Posted: Fri Oct 14, 2016 8:23 pm
by JRobinsonOnline
mehargags wrote:Ok JRobinsonOnline,
Let me start over... and please try to be as descriptive as you can:
Your Server Specs: RAM / Cores / Storage Space and
who is your provider (
important)
1. How many sites and DBs you have in total ? Are these wordpress ?
2. You said "only one site has problem connecting DB", do the other sites use a DB or are they static ones ?
3. do you have Swap On ? paste result for
4.
5. if it reports ariadb errors, Delete ariadb logs/control file from /var/lib/mysql
6. # optimise and Repair all DBs
mysqlcheck --all-databases -o
mysqlcheck --all-databases --auto-repair
mysqlcheck --all-databases --analyze
after all this
7. # Clean MySQL logs
Code: Select all
> /var/log/auth.log
> /var/log/mysql/error.log
> /var/log/mysql.log
> /var/log/mysql.err
Now access your problem site... and observe errors posted there in the tail.
---------------
Send your observations and we'll try to find the culprit
@mehargags here's what I did:
Ram: 3GB / Cores: 4 / Storage: 115GB / Provider: RamNode
1. 8 Sites (some with files others are just domains) - 3 of those are using Wordpress/Databases
2. (2) of out the 3 WP sites continue to operate “meaning I can visit them via URL” the (1) in question only is visible when I am in Mysql Safe Mode - tables granted
3. When I log in via SSH root and use command “swapon -s” I get the following…
Filename - Type - Size - Used - Priority
/dev/null partition 524288 76680 -1
Moving forward using command mysql I get an ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
As a result I stop/start mysql in safe mode using sudo /etc/init.d/mysqld stop and sudo mysqld_safe --skip-grant-tables &
Only then I am able to run the following…
4. Using command “dmesg | grep mysql” I get no response
5. No response, no errors
6.
http://empme.org/mysqlcheck%20--all-dat ... alyze.html
http://empme.org/mysqlcheck%20--all-dat ... epair.html
http://empme.org/mysqlcheck%20--all-databases%20-o.html
7. Unless I stay in mysql safemode I get:
-bash: /var/log/auth.log: Permission denied
-bash: /var/log/mysql/error.log: No such file or directory
-bash: /var/log/mysql.log: Permission denied
-bash: /var/log/mysql.err: Permission denied
8. tail: cannot open `/var/log/mysql/error.log' for reading: No such file or directory
tail: no files remaining
I am at a total lost man...Thanks for helping
Re: Database Error Connection & Timing Out Issues?
Posted: Wed May 10, 2017 4:55 am
by blueberry
Hi, not sure if i can start a new thread, but decided to post here, cos it appears i might have a similar issue. I was trying to upload a 6mb mysql database via Phpmyadmin, it keeps loading forever. These files have been edited, apache, mysql all restarted and rebooted several times.
Server is Core 2 Duo, 4gb Memory, Setup on Local Network, Dynamic DNS/ Dynamic IP all setup properly. FTP upload was fast and working good.
Can anyone kindly advice what else can be done?
-------
sudo nano /usr/share/phpmyadmin/libraries/config.default.php
$cfg['ExecTimeLimit'] = 0;
edited php.ini and verified via phpinfo file, all settings updated. Phpmyadmin import filesize was also reflected correctly.
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 300
max_input_time = 540
memory_limit = 1000M
sudo nano /etc/mysql/my.cnf
max_allowed_packet = 512M
wait_timeout=600
Re: Database Error Connection & Timing Out Issues?
Posted: Wed May 10, 2017 6:17 pm
by mehargags
blueberry
pls mention your OS and Version.
If ubuntu, most probably phpmyadmin bug. You can try updating the PHPMyAdmin to latest.
Re: Database Error Connection & Timing Out Issues?
Posted: Thu May 11, 2017 12:38 am
by blueberry
hi, thank you for your reply. Sorry, OS is ubuntu 16.04 lts server edition, phpmyadmin version is 4.5. I will try updating phpmyadmin in a while.
Re: Database Error Connection & Timing Out Issues?
Posted: Sat May 13, 2017 10:51 am
by blueberry
Thanks, so far i tried updating to the latest from the repo, Phpmyadmin 4.6.6, seems better and ok now.
Re: Database Error Connection & Timing Out Issues?
Posted: Sun May 14, 2017 6:00 am
by mehargags
Glad...
Pls mark your thread resolved
Re: Database Error Connection & Timing Out Issues?
Posted: Sun May 14, 2017 9:50 am
by blueberry
Hi, im not sure how to mark as closed. I'm not the original thread poster.