[FIX] phpmyadmin some feature/controluser

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
pandabb
Posts: 192
Joined: Sat Aug 08, 2015 3:03 am

Re: [FIX] phpmyadmin some feature/controluser

Postby pandabb » Mon Feb 08, 2016 6:06 pm

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
Posts: 72
Joined: Sun Jun 08, 2014 12:18 pm

Re: [FIX] phpmyadmin some feature/controluser

Postby jonn » Fri Feb 12, 2016 3:08 am

@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
Posts: 4
Joined: Thu Feb 25, 2016 1:00 pm

Re: [FIX] phpmyadmin some feature/controluser

Postby musicmouse » Fri Feb 26, 2016 7:00 pm

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
Posts: 1
Joined: Thu Mar 10, 2016 6:17 am

Re: [FIX] phpmyadmin some feature/controluser

Postby SANDY2005 » Thu Mar 10, 2016 6:18 am

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

Teo
Posts: 73
Joined: Mon May 11, 2015 9:17 am

Re: [FIX] phpmyadmin some feature/controluser

Postby Teo » Thu Mar 10, 2016 10:23 am

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
Posts: 16
Joined: Mon Nov 03, 2014 11:50 pm

Re: [FIX] phpmyadmin some feature/controluser

Postby TopeZ » Sat Mar 12, 2016 7:56 pm

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
Posts: 16
Joined: Mon Nov 03, 2014 11:50 pm

Re: [FIX] phpmyadmin some feature/controluser

Postby TopeZ » Sat Mar 12, 2016 8:06 pm

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
VestaCP Team
Posts: 7798
Joined: Fri Dec 26, 2014 2:23 pm
Location: Moscow
Contact:

Re: [FIX] phpmyadmin some feature/controluser

Postby skurudo » Mon Apr 18, 2016 6:26 pm

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


Nice!
-> DigitalOcean competition - please, support us
-> fix for phpmyadmin - nice and sweet now

skurudo
VestaCP Team
Posts: 7798
Joined: Fri Dec 26, 2014 2:23 pm
Location: Moscow
Contact:

Re: [FIX] phpmyadmin some feature/controluser

Postby skurudo » Mon Apr 18, 2016 6:29 pm

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 ;-)
-> DigitalOcean competition - please, support us
-> fix for phpmyadmin - nice and sweet now

skurudo
VestaCP Team
Posts: 7798
Joined: Fri Dec 26, 2014 2:23 pm
Location: Moscow
Contact:

Re: [FIX] phpmyadmin some feature/controluser

Postby skurudo » Mon Apr 18, 2016 6:32 pm

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
-> DigitalOcean competition - please, support us
-> fix for phpmyadmin - nice and sweet now


Return to “Database Server”



Who is online

Users browsing this forum: No registered users and 4 guests