[FIX] phpmyadmin some feature/controluser

[pandabb]

I got this error on my new install and i just clicked "FIND OUT WHY" then there's a link create phpmyadmin database i clicked that and the storage error is gone or got fixed.

Do i still need to follow the guide on this thread, or this is good already?

[jonn]

@skurudo

Can you check if your pma__userconfig table is deleting the usernames when the db is deleted from the vestacp control panel, seems even though the user db is deleted this table still has the data.

[musicmouse]

Tried this on Ubuntu 15.10 with Vesta 0.9.8 while having the error

Warning in ./libraries/Util.class.php#516
file_exists(): open_basedir restriction in effect. File(doc/html/index.html) is not within the allowed path(s): (/usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/php-gettext)

It did nothing to repair the error.

Neither did it run correctly. After creating pma-ubuntu.sh it gets an error trying to change its rights with chmod.

[SANDY2005]

How to fix this problem, please get a detailed tutorial for this.

[Teo]

Hi, I ran the command for Centos 6:

Code: Select all

curl -O -k https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-centos.sh && chmod +x pma-centos.sh && ./pma-centos.sh

but i still get the error:

The phpMyAdmin configuration storage is not completely configured, some extended features have been deactivated. Find out why.
Or alternately go to 'Operations' tab of any database to set it up there.

what i have to do more?
Thanks

[TopeZ]

Can this be done from a SuperUser or does this absolutely have to be done from root?

Unfortunately my host only provides me a SU "customer" to my dedicated box... I ran the script but I got access denied errors root@localhost but I confirmed the password for root worked for phpmyadmin prior.

Now after running the script I'm unable to login to my phpmyadmin under root and my password has not been changed at /usr/local/vesta/conf/mysql.conf

I'm running Ubuntu.

[TopeZ]

I was able to reset my mysql password by running this in SSH: "sudo dpkg-reconfigure mysql-server-5.5"

However still having the phpmyadmin some feature/controluser errors and I ran the script again and root@localhost access denied again... :(

Code: Select all

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y                                                      ES)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y                                                      ES)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y                                                      ES)
Download tables for our mysql server
--2016-03-12 14:03:41--  https://raw.githubusercontent.com/skurudo/phpmyadmin-fi                                                      xer/master/create_tables.sql
Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 23.235.40.133
Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|23.235.40.13                                                      3|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 11912 (12K) [text/plain]
Saving to: ‘create_tables.sql’

100%[======================================>] 11,912      --.-K/s   in 0s

2016-03-12 14:03:41 (280 MB/s) - ‘create_tables.sql’ saved [11912/11912]

Download via wget
--2016-03-12 14:03:41--  https://raw.githubusercontent.com/skurudo/phpmyadmin-fi                                                      xer/master/create_tables.sql
Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 23.235.40.133
Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|23.235.40.13                                                      3|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 11912 (12K) [text/plain]
Saving to: ‘create_tables.sql.1’

100%[======================================>] 11,912      --.-K/s   in 0s

2016-03-12 14:03:41 (249 MB/s) - ‘create_tables.sql.1’ saved [11912/11912]

Download via curl
  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100 11912  100 11912    0     0   184k      0 --:--:-- --:--:-- --:--:--  187k
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: Y                                                      ES)
Delete temp files

[skurudo]

EDIT: Solved, I hadn't saved my new password properly in this file: /root/.my.cnf

Nice!

[skurudo]

Do i still need to follow the guide on this thread, or this is good already?

Patch good enough, if you ask me ;-)

[skurudo]

It did nothing to repair the error.
Neither did it run correctly. After creating pma-ubuntu.sh it gets an error trying to change its rights with chmod.

Ubuntu? Don't forget about sudo.

Do you have correct password in .my.cnf ?

Code: Select all

Warning in ./libraries/Util.class.php#516
file_exists(): open_basedir restriction in effect. File(doc/html/index.html) is not within the allowed path(s): (/usr/share/phpmyadmin/:/etc/phpmyadmin/:/var/lib/phpmyadmin/:/usr/share/php/php-gettext)

This patch don't fix everything on your server. You quoted open_basedir prob -> fix path in apache2 - conf.d - phpmyadmin.conf