Vesta Control Panel - Forum

Posted: **Wed Oct 26, 2016 12:46 pm**

Error in CentOS 7.2 and PMA 2.4.6:

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

Posted: **Fri Oct 28, 2016 7:16 am**

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

Posted: **Fri Oct 28, 2016 7:17 am**

edica wrote: 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

Posted: **Thu Dec 08, 2016 5:18 am**

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

Keep the good work !!!!!
FedeKrum

Posted: **Fri Dec 09, 2016 7:15 pm**

fedekrum wrote: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.

Posted: **Fri Jan 27, 2017 11:20 am**

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!

Posted: **Sat Jan 28, 2017 9:39 pm**

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.

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

Posted: **Wed Apr 05, 2017 12:15 pm**

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

Code: Select all

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

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

Posted: **Wed Apr 05, 2017 3:06 pm**

sag-sag wrote:Пробую на 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

Posted: **Wed May 31, 2017 10:07 am**

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.

Vesta Control Panel - Forum

[FIX] phpmyadmin some feature/controluser

Re: [FIX] phpmyadmin some feature/controluser

Re: [FIX] phpmyadmin some feature/controluser

Re: [FIX] phpmyadmin some feature/controluser

Re: [FIX] phpmyadmin some feature/controluser

Re: [FIX] phpmyadmin some feature/controluser

Re: [FIX] phpmyadmin some feature/controluser

Re: [FIX] phpmyadmin some feature/controluser

Re: [FIX] phpmyadmin some feature/controluser

Re: [FIX] phpmyadmin some feature/controluser

Re: [FIX] phpmyadmin some feature/controluser