[FIX] phpmyadmin some feature/controluser

[edica]

Error in CentOS 7.2 and PMA 2.4.6:

ERROR 1396 (HY000) at line 1: Operation DROP USER failed for 'pma'@'localhost'

[skurudo]

edica, rbrownell,
sorry guys, didn't find solution yet ;-(

[skurudo]

ERROR 1396 (HY000) at line 1: Operation DROP USER failed for 'pma'@'localhost'

It's pretty normal if you don't have pma user in mysql.
The script is made in such a way that it is possible to run it several times without problems

[fedekrum]

Is still a valid solution for the latest vesta?
why is this solution not merged to the final release?

Keep the good work !!!!!
FedeKrum

[skurudo]

Is still a valid solution for the latest vesta?
why is this solution not merged to the final release?

Yes, it's pretty valid.
Hm... we plan to merge this solution for new installations in 0.9.8-18.

[realjumy]

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.

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

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!

[skurudo]

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.

Nice to hear.
Thank you for report! ;-)

[sag-sag]

Пробую на Ubuntu перейти. При установке фикса на ubuntu-16.04.2-server-amd64, возникает следующая "ошибка":

Code: Select all

chmod: changing permissions of 'pma-ubuntu.sh': Operation not permitted

Нет прав. Хотя выполняю sudo...

[skurudo]

Пробую на Ubuntu перейти. При установке фикса на ubuntu-16.04.2-server-amd64, возникает следующая "ошибка":

Code: Select all

chmod: changing permissions of 'pma-ubuntu.sh': Operation not permitted

Нет прав. Хотя выполняю sudo...

Русский топик не здесь, тама | Russian topic not here, there
-> 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

[patstan]

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:

Code: Select all

chown -R root /etc/phpMyAdmin/
chmod -R 775 /etc/phpMyAdmin/

However, i still cant get rid of the 'Configuration of pmadb… not OK' error.