Forwarded to devs Database error

[sanel_]

TITLE:

Database error​

PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE:

OS: ‪CentOS Linux 7.6.1810 (Core)‬
Product: Plesk Onyx 17.9.13
Checked at April 15, 2019 03:35 AM.​

PROBLEM DESCRIPTION:

After the Plesk updated automatically, I am having this issue and can't open the phpmyadmin.
Here is the error message.

Error
SQL query: Edit


SELECT `comment`
FROM `phpmyadmin_ElDyAsM2cyqd`.`pma_column_info`
WHERE db_name = 'admin_radio'
AND table_name = ''
AND column_name = '(db_comment)'



MySQL said:

#1142 - SELECT command denied to user 'pma_an74dfqKsx9p'@'localhost' for table 'pma_column_info'​

STEPS TO REPRODUCE:

Clicking on phpMyAdmin under databases.​

ACTUAL RESULT:

Error
SQL query: Edit


SELECT `comment`
FROM `phpmyadmin_ElDyAsM2cyqd`.`pma_column_info`
WHERE db_name = 'admin_radio'
AND table_name = ''
AND column_name = '(db_comment)'



MySQL said:

#1142 - SELECT command denied to user 'pma_an74dfqKsx9p'@'localhost' for table 'pma_column_info'​

EXPECTED RESULT:

Update with fix.​

ANY ADDITIONAL INFORMATION:

​

YOUR EXPECTATIONS FROM PLESK SERVICE TEAM:

Help with sorting out​

 

[IgorG]

Please update pictures in your post.

 

[sanel_]

I have attached screen shot of the problem. When I logged in and like usually click on Databases and then clicked on the phpMyAdmin on a specific database, I get this error. This just started after plesk updated, it was working fine.

What's wrong with it?

 

[IgorG]

The additional information is required

1. Does any error occur when you tries to access phpMyAdmin via Tools & Settings > Database servers?
2. The output of the command below:

# rpm -qa | grep phpmyadmin

 

[sanel_]

[root@balkanmp3 ~]# rpm -qa | grep phpmyadmin
psa-phpmyadmin-4.8.5-1centos.7.190403.1351.noarch
[root@balkanmp3 ~]#

It's still saying the same, same error like in the picture I showed you.
Everything works regarding the websites, but I can't access the database to edit anything via phpMyAdmin.
It happened after the last update.

 

[IgorG]

Most probably the issue occurs because of the mismatch between user login credentials stored in the phpMyAdmin configuration and the database.
To fix the issue it is required to reinstall phpMyAdmin with the steps below:

1. Remove the phpMyAdmin with the command:

# rpm -e --nodeps psa-phpmyadmin

2. Download and install latest PhpMyAdmin by executing the command:

# rpm -Uvh http://autoinstall.plesk.com/PSA_17...yadmin-4.8.5-1centos.7.190403.1351.noarch.rpm

3. Log out from Plesk
4. Log into Plesk

 

[sanel_]

Just to add an update to this thread, I have fixed the issue but it isn't just reinstalling the phpMyAdmin with this.

To fix it, this is what I have done as there was no tmp and tmp/session folders.

1. Remove the phpMyAdmin with the command:

# rpm -e --nodeps psa-phpmyadmin

2. Download and install latest PhpMyAdmin by executing the command:

# rpm -Uvh http://autoinstall.plesk.com/PSA_17...yadmin-4.8.5-1centos.7.190403.1351.noarch.rpm

mkdir /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp
mkdir /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp/session
chmod 777 /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp
chmod 777 /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp/session

Done.

 

[rjga]

Just to add an update to this thread, I have fixed the issue but it isn't just reinstalling the phpMyAdmin with this.

To fix it, this is what I have done as there was no tmp and tmp/session folders.

1. Remove the phpMyAdmin with the command:

# rpm -e --nodeps psa-phpmyadmin

2. Download and install latest PhpMyAdmin by executing the command:

# rpm -Uvh http://autoinstall.plesk.com/PSA_17...yadmin-4.8.5-1centos.7.190403.1351.noarch.rpm

mkdir /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp
mkdir /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp/session
chmod 777 /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp
chmod 777 /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp/session

Done.

Is there an update for Plesk Obsidian 18.0.20?
For instance the link here no longer works: http://autoinstall.plesk.com/PSA_17...yadmin-4.8.5-1centos.7.190403.1351.noarch.rpm

 

[Nelson Design Collective]

@rjga you likely don't need to uninstall and reinstall phpMyAdmin, @sanel_ was on the right track.

All you should have to do is:

mkdir /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp
mkdir /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp/session
chmod 777 /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp
chmod 777 /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp/session

And log out and back into Plesk. That worked for me on Plesk Obsidian 18.0.20 when we just experienced this issue ourselves. Best of luck!

 

[rjga]

@rjga you likely don't need to uninstall and reinstall phpMyAdmin, @sanel_ was on the right track.

All you should have to do is:

mkdir /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp
mkdir /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp/session
chmod 777 /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp
chmod 777 /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp/session

And log out and back into Plesk. That worked for me on Plesk Obsidian 18.0.20 when we just experienced this issue ourselves. Best of luck!

@Nelson Design Collective - Thank you! That did it for me. I appreciated!!

 

[Tavy]

@rjga you likely don't need to uninstall and reinstall phpMyAdmin, @sanel_ was on the right track.

All you should have to do is:

mkdir /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp
mkdir /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp/session
chmod 777 /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp
chmod 777 /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp/session

And log out and back into Plesk. That worked for me on Plesk Obsidian 18.0.20 when we just experienced this issue ourselves. Best of luck!

Perfect, worked for :
Plesk Obsidian
Version 18.0.20,

 

[HansMobron]

@rjga you likely don't need to uninstall and reinstall phpMyAdmin, @sanel_ was on the right track.

All you should have to do is:

mkdir /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp
mkdir /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp/session
chmod 777 /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp
chmod 777 /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp/session

And log out and back into Plesk. That worked for me on Plesk Obsidian 18.0.20 when we just experienced this issue ourselves. Best of luck!

Great work a +10

 

[Jax]

@rjga you likely don't need to uninstall and reinstall phpMyAdmin, @sanel_ was on the right track.

All you should have to do is:

mkdir /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp
mkdir /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp/session
chmod 777 /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp
chmod 777 /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp/session

And log out and back into Plesk. That worked for me on Plesk Obsidian 18.0.20 when we just experienced this issue ourselves. Best of luck!

Thanks Nelson, this worked for me too!
Can anyone confirm if giving 777 permissions to these folders is ok?

 

[Nelson Design Collective]

@Jax excellent question and good to be think along those lines.

Those directories should be outside of the publicly accessible web paths, so they should be okay.

You can try more restrictive permissions like 700 for just owner access, or 755 for just owner write, just make sure those directories are chowned to the user your plesk/apache runs under. If you do try more restrictive permissions, please post back your findings and any tips you glean along the way. best of luck!

(you'll have to log out and back into plesk inbetween changing and trying.)

 

[Jax]

@Jax excellent question and good to be think along those lines.

Those directories should be outside of the publicly accessible web paths, so they should be okay.

You can try more restrictive permissions like 700 for just owner access, or 755 for just owner write, just make sure those directories are chowned to the user your plesk/apache runs under. If you do try more restrictive permissions, please post back your findings and any tips you glean along the way. best of luck!

(you'll have to log out and back into plesk inbetween changing and trying.)

Sure, thanks for the advice, I will post back what worked!

Sent from my Pixel 2 XL using Tapatalk

 

[Tavy]

Today i get back this error. i fixed again with @Nelson Design Collective suggestion, only set chmod 777 worked.

server:~# mkdir /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp
mkdir: cannot create directory ‘/usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp’: File exists
server:~# mkdir /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp/session
mkdir: cannot create directory ‘/usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp/session’: File exists
server:~# chmod 777 /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp
server:~# chmod 777 /usr/local/psa/admin/htdocs/domains/databases/phpMyAdmin/tmp/session

some of this directors lost 777 chmod, so i suggest to start investigate from this, and error come back after update !

 

[Jax]

Hi team,

Strange enough, I received another update in Plesk and
I get the message when I try to run phpmyadmin again...

It worked when I applied @Nelson Design Collective fix, however now it's not accessing phpmyadmin again and I get this error.

Anyone knows what the problem is please?

To solve it, I deleted the folder and file suggested by Nelson and re-created them + permissions.

It works again!

Error
SQL query: Edit


SELECT `comment`
FROM `phpmyadmin_pAvse_U2KIfl`.`pma_column_info`
WHERE db_name = 'small'
AND table_name = ''
AND column_name = '(db_comment)'



MySQL said:

#1142 - SELECT command denied to user 'pma_uDSV0WhsV'@'localhost' for table 'pma_column_info'