Page 1 of 1

phpMyAdmin error code 500 and MySQL errors

Posted: Sun Apr 05, 2015 4:07 pm
by vlahonick
Hi all,

first post in the forum and before typing my questions below I would like to congratulate the Vesta Team for the great job they have done so far. Also many thanks to everybody (admins, moderators & users) that make this forum a huge solving problem tank. Keep up the good work people!

To the problem now... I installed Vesta to an Ubuntu Server 14.04.2 LTS and I have some serious problems with phpMyAdmin (version: 4:4.0.10-1).

1. The links in the left panel are not "clickable" like in this post ... +databases but the solution proposed there (changing the user's privileges) didn't work for me.

2. When I click the Settings in phpmyadmin, error 500 appears but with no obvious (to me) reason. I checked the status monitor and the mysql error.log but no luck. I found a post in the forum (in russian) and with google translator I figure out what they were talking about but as far as i understood the error wasn't solved. This is the post ... ree+browse if anybody wants to take a look.

3. When I go to phpmyadmin > Status > All status variables (or any Status "sub-link") every other link becomes unclickable... After refreshing the page I can click any link but if I click a Status sub-link the error repeats.

What I tried so far:
a. Restarting and rebooting apache, nginx, vesta and the server itself many times had no effect.
b. Changing the privileges for the root to USAGE didn't solve problem 2.
c. Remove, purge and re-installing phpmyadmin had some serious side effects. Removing phpmyadmin somehow (even choosing to keep the configuration so no database deletion accident occures) made roundcube unusable as well while re-installing made vesta give me a 404 page not found in
d. I also changed the permissions for config-db.php_ file in /etc/phpmyadmin as suggested in the russian post at problem 2 and I even copy config-db.php_ to config-db.php and tried again but no luck.
e. I used the dpkg-reconfigure -plow phpmyadmin command but every time after completing the wizard I had to retry without apparent reason. Anyone after the retry the web server restarts itself and then I cannot even login in phpMyAdmin at all, it gives me an error: #1045 Cannot log in to the MySQL server - Connection for controluser as defined in your configuration failed. Now when I try to modify anything in any database via vesta I get in vesta "Editing Database → Error: Connection failed"

In my attempt to keep this post as small and readable as possible I will give you some links with my screenshots and my logs instead of posting them directly here and making this post even bigger.
>> Link with my screenshots: (comments by me on the right of every image to help you understand the problem)
>> Link with my full /var/log/mysql/error.log until the moment I type this lines:
>> Link with every red log from phpMyAdmin > Status > All status variables:

PS: In a quick vesta installation on ubuntu 12.04 I had none of the problems above.

Thanks in advance for any help!

Re: phpMyAdmin error code 500 and MySQL errors

Posted: Sat Dec 19, 2015 9:34 am
by sebastiaands
Hi Vlahonick,

I have exactly the same issue. I have been messing around for quite some time, but I can't find much information about this. Did you already solved the issue?



Re: phpMyAdmin error code 500 and MySQL errors

Posted: Sun Dec 27, 2015 11:49 am
by vlahonick
Unfortunately, I did not solve the problem and I did not find what cause it. I had to make a clean Ubuntu 14.04 install in my VPS, purge apache2 that was installed along with the VPS and then install Vesta. This way Vesta installed apache for itself but I do not think that this was what caused the problem.

Anyway, nowdays I do not even use phpmyadmin anymore since is more like a security hole in a VPS even though there are a few tricks to make it more secure.

If you just needed phpmyadmin to add/remove/backup dbs you could use mysql cli. Is not that hard and there are only a few commands to learn/use for that. Also, a good alternative might be (especially the superlight English only version). I use adminer in my localhost for add/remove/backup dbs and works like a charm. But again, if you want more functionality stick with PMA and perform a clean install.

Re: phpMyAdmin error code 500 and MySQL errors

Posted: Fri Jan 15, 2016 9:06 pm
by skurudo
FIX for phpmyadmin some feature/controluser