Page 3 of 9

Re: [FIX] phpmyadmin some feature/controluser

Posted: Mon Feb 08, 2016 6:06 pm
by 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?

Re: [FIX] phpmyadmin some feature/controluser

Posted: Fri Feb 12, 2016 3:08 am
by 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.

Re: [FIX] phpmyadmin some feature/controluser

Posted: Fri Feb 26, 2016 7:00 pm
by 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.

Re: [FIX] phpmyadmin some feature/controluser

Posted: Thu Mar 10, 2016 6:18 am
by SANDY2005
How to fix this problem, please get a detailed tutorial for this.

Re: [FIX] phpmyadmin some feature/controluser

Posted: Thu Mar 10, 2016 10:23 am
by 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

Re: [FIX] phpmyadmin some feature/controluser

Posted: Sat Mar 12, 2016 7:56 pm
by 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.

Re: [FIX] phpmyadmin some feature/controluser

Posted: Sat Mar 12, 2016 8:06 pm
by 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

Re: [FIX] phpmyadmin some feature/controluser

Posted: Mon Apr 18, 2016 6:26 pm
by skurudo
neiklot wrote: EDIT: Solved, I hadn't saved my new password properly in this file: /root/.my.cnf
Nice!

Re: [FIX] phpmyadmin some feature/controluser

Posted: Mon Apr 18, 2016 6:29 pm
by skurudo
pandabb wrote:Do i still need to follow the guide on this thread, or this is good already?
Patch good enough, if you ask me ;-)

Re: [FIX] phpmyadmin some feature/controluser

Posted: Mon Apr 18, 2016 6:32 pm
by skurudo
musicmouse wrote: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