We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
[FIX] phpmyadmin some feature/controluser
Re: [FIX] phpmyadmin some feature/controluser
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?
Do i still need to follow the guide on this thread, or this is good already?
Re: [FIX] phpmyadmin some feature/controluser
@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.
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.
-
- Posts: 10
- Joined: Thu Feb 25, 2016 1:00 pm
Re: [FIX] phpmyadmin some feature/controluser
Tried this on Ubuntu 15.10 with Vesta 0.9.8 while having the error
Neither did it run correctly. After creating pma-ubuntu.sh it gets an error trying to change its rights with chmod.
It did nothing to repair 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)
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
How to fix this problem, please get a detailed tutorial for this.
Re: [FIX] phpmyadmin some feature/controluser
Hi, I ran the command for Centos 6:
but i still get the error:
Thanks
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
what i have to do more?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.
Thanks
Re: [FIX] phpmyadmin some feature/controluser
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.
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
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... :(
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
Nice!neiklot wrote: EDIT: Solved, I hadn't saved my new password properly in this file: /root/.my.cnf
Re: [FIX] phpmyadmin some feature/controluser
Patch good enough, if you ask me ;-)pandabb wrote:Do i still need to follow the guide on this thread, or this is good already?
Re: [FIX] phpmyadmin some feature/controluser
Ubuntu? Don't forget about sudo.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.
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)