We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on Vesta 2.0 and expect to release it by the end of 2024. Read more about it: https://vestacp.com/docs/vesta-2-development
[FIX] phpmyadmin some feature/controluser
Re: [FIX] phpmyadmin some feature/controluser
Error in CentOS 7.2 and PMA 2.4.6:
ERROR 1396 (HY000) at line 1: Operation DROP USER failed for 'pma'@'localhost'
ERROR 1396 (HY000) at line 1: Operation DROP USER failed for 'pma'@'localhost'
Re: [FIX] phpmyadmin some feature/controluser
edica, rbrownell,
sorry guys, didn't find solution yet ;-(
sorry guys, didn't find solution yet ;-(
Re: [FIX] phpmyadmin some feature/controluser
It's pretty normal if you don't have pma user in mysql.edica wrote: ERROR 1396 (HY000) at line 1: Operation DROP USER failed for 'pma'@'localhost'
The script is made in such a way that it is possible to run it several times without problems
Re: [FIX] phpmyadmin some feature/controluser
Is still a valid solution for the latest vesta?
why is this solution not merged to the final release?
Keep the good work !!!!!
FedeKrum
why is this solution not merged to the final release?
Keep the good work !!!!!
FedeKrum
Re: [FIX] phpmyadmin some feature/controluser
Yes, it's pretty valid.fedekrum wrote:Is still a valid solution for the latest vesta?
why is this solution not merged to the final release?
Hm... we plan to merge this solution for new installations in 0.9.8-18.
Re: [FIX] phpmyadmin some feature/controluser
Hi guys.
I tried the script, but it's not working in Vesta 0.9.8-17 + Centos 7 + phpMyAdmin 4.6.6. I still have the " 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." error.
I'll be happy to test any new patch.
EDIT:
Apparently now is OK. The problem was persisting in a already existing database used before applying the patch, the new ones seems to work fine. Then, in the old database, I went to the operations tab and clicked on fixing it. Sorted.
Thank you guys!
I tried the script, but it's not working in Vesta 0.9.8-17 + Centos 7 + phpMyAdmin 4.6.6. I still have the " 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." error.
Code: Select all
[root@mail ~]# curl -O -k https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma.sh && chmod +x pma.sh && ./pma.sh
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 1511 100 1511 0 0 5665 0 --:--:-- --:--:-- --:--:-- 5659
--2017-01-27 12:08:36-- https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-centos.sh
Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 151.101.36.133
Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|151.101.36.133|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 5076 (5.0K) [text/plain]
Saving to: ‘pma-centos.sh’
100%[======================================>] 5,076 --.-K/s in 0s
2017-01-27 12:08:36 (45.6 MB/s) - ‘pma-centos.sh’ saved [5076/5076]
Phpmyadmin fixes for configuration storage and some extended features
................
Let's do it
............
..........
.........
........
......
Generate password for PMA (pma.txt)
PMA Password = xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Download tables for our mysql server
--2017-01-27 12:08:36-- https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/create_tables.sql
Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 151.101.120.133
Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|151.101.120.133|: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 0.006s
2017-01-27 12:08:36 (1.98 MB/s) - ‘create_tables.sql’ saved [11912/11912]
Download via wget
--2017-01-27 12:08:36-- https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/create_tables.sql
Resolving raw.githubusercontent.com (raw.githubusercontent.com)... 151.101.120.133
Connecting to raw.githubusercontent.com (raw.githubusercontent.com)|151.101.120.133|: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 0.006s
2017-01-27 12:08:36 (1.90 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 66717 0 --:--:-- --:--:-- --:--:-- 66921
Delete temp files
EDIT:
Apparently now is OK. The problem was persisting in a already existing database used before applying the patch, the new ones seems to work fine. Then, in the old database, I went to the operations tab and clicked on fixing it. Sorted.
Thank you guys!
Re: [FIX] phpmyadmin some feature/controluser
Nice to hear.realjumy wrote: Apparently now is OK. The problem was persisting in a already existing database used before applying the patch, the new ones seems to work fine. Then, in the old database, I went to the operations tab and clicked on fixing it. Sorted.
Thank you for report! ;-)
Re: [FIX] phpmyadmin some feature/controluser
Пробую на Ubuntu перейти. При установке фикса на ubuntu-16.04.2-server-amd64, возникает следующая "ошибка":
Нет прав. Хотя выполняю sudo...
Code: Select all
chmod: changing permissions of 'pma-ubuntu.sh': Operation not permitted
Re: [FIX] phpmyadmin some feature/controluser
Русский топик не здесь, тама | Russian topic not here, theresag-sag wrote:Пробую на Ubuntu перейти. При установке фикса на ubuntu-16.04.2-server-amd64, возникает следующая "ошибка":Нет прав. Хотя выполняю sudo...Code: Select all
chmod: changing permissions of 'pma-ubuntu.sh': Operation not permitted
-> viewtopic.php?f=32&t=10306
MORE SUDO, MOAR
Code: Select all
sudo wget --no-check-certificate https://raw.githubusercontent.com/skurudo/phpmyadmin-fixer/master/pma-ubuntu.sh && sudo chmod +x pma-ubuntu.sh && sudo ./pma-ubuntu.sh
Re: [FIX] phpmyadmin some feature/controluser
I just tried running this on Centos 6.4 64bit, and unfortunately it does not fix the errors.
I also followed this tutorial -> viewtopic.php?t=9724#p35092 and i didnt have to do anything because everything was already in place/configured.
Any suggestions?
EDIT:
I fixed the blowfish error by giving the phpMyadmin folder with relevant permissions:
However, i still cant get rid of the 'Configuration of pmadb… not OK' error.
I also followed this tutorial -> viewtopic.php?t=9724#p35092 and i didnt have to do anything because everything was already in place/configured.
Any suggestions?
EDIT:
I fixed the blowfish error by giving the phpMyadmin folder with relevant permissions:
Code: Select all
chown -R root /etc/phpMyAdmin/
chmod -R 775 /etc/phpMyAdmin/