[FIX] phpmyadmin some feature/controluser

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
edica
Posts: 101
Joined: Tue May 26, 2015 7:31 pm

Re: [FIX] phpmyadmin some feature/controluser

Postby edica » 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'

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

Re: [FIX] phpmyadmin some feature/controluser

Postby skurudo » Fri Oct 28, 2016 7:16 am

edica, rbrownell,
sorry guys, didn't find solution yet ;-(
-> 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 » 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
-> DigitalOcean competition - please, support us
-> fix for phpmyadmin - nice and sweet now

fedekrum
Posts: 31
Joined: Mon May 12, 2014 7:45 pm
Location: Argentina

Re: [FIX] phpmyadmin some feature/controluser

Postby fedekrum » 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

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

Re: [FIX] phpmyadmin some feature/controluser

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

realjumy
Posts: 10
Joined: Sun Jul 06, 2014 12:51 pm

Re: [FIX] phpmyadmin some feature/controluser

Postby realjumy » 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!

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

Re: [FIX] phpmyadmin some feature/controluser

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

sag-sag
Posts: 157
Joined: Sun Feb 15, 2015 7:00 pm
Contact:

Re: [FIX] phpmyadmin some feature/controluser

Postby sag-sag » 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...

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

Re: [FIX] phpmyadmin some feature/controluser

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

patstan
Posts: 114
Joined: Wed Jul 30, 2014 10:53 am

Re: [FIX] phpmyadmin some feature/controluser

Postby patstan » 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.


Return to “Database Server”



Who is online

Users browsing this forum: Yahoo [Bot] and 3 guests

cron