How to update phpmyadmin? Topic is solved

[pandabb]

Hello guys, how to update phpmyadmin ?
I see a notification A newer version of phpMyAdmin is available and you should consider upgrading. The newest version is 4.5.4, released on 2016-01-28.

Changelog for the update:
https://www.phpmyadmin.net/files/4.5.4/

Thank You

P.S

I also updated my php from 5.4 to 5.6.17 , the long characters or id below , is it normal?

Code: Select all

Apache/2.4.6 (CentOS) OpenSSL/1.0.1e-fips mod_fcgid/2.3.9 PHP/5.6.17
Database client version: libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: 3c688b6bbc30d36af3ac34fdd4b7b5b787fe5555 $ 
PHP extension: mysqli Documentation
PHP version: 5.6.17

[skurudo]

- download https://www.phpmyadmin.net/downloads/
- extract in temp folder
- make backup /usr/share/phpMyAdmin
- copy from your temp folder to /usr/share/phpMyAdmin
- check permissions

And you can add patch - viewtopic.php?f=14&t=10307

[pandabb]

Thank you.

What is the permision of the folder phpMyadmin, should it be root:root?

Second, ive succesfully updated phpmyAdmin but i encountered blowfish error again, i checked the config at /etc/phpmyadmin/config.inc.php blowfish key already exist.

Then i checked the folder /user/share/phpMyAdmin there's a file called sample.config.inc
I renamed that to config.inc.php and added blowfish key, then it works.

Did i do the right thing ? Because it's supposed to read the file to /etc/PhpMyadmin now its reading it from /user/share/phpMyAdmin now /etc/phpMyAdmin/config.inc.php is useless because its not being read.

Thanks!

[skurudo]

What is the permision of the folder phpMyadmin, should it be root:root?

Yep.

Code: Select all

-rw-r--r--   1 root root 

Second, ive succesfully updated phpmyAdmin but i encountered blowfish error again, i checked the config at /etc/phpmyadmin/config.inc.php blowfish key already exist. Then i checked the folder /user/share/phpMyAdmin there's a file called sample.config.inc I renamed that to config.inc.php and added blowfish key, then it works. Did i do the right thing ?

4.5.x version have this blowfish stange behavior.
In older version I don't remember this.
You did right.

Because it's supposed to read the file to /etc/PhpMyadmin now its reading it from /user/share/phpMyAdmin now /etc/phpMyAdmin/config.inc.php is useless because its not being read.

Perhaps there is a difference between installing from the package and from the website. I think it's not so important. In ideal world in /etc/phpmyadmin should be simlynk to /usr/share/phpmyadmin, but there's no such thing. ;-)

[pandabb]

Thanks for the confirmation, and yes i read that some package have different location for config. I also applied the patch and copied the pma password to the new config and its working well.

[tkramer]

Thanks @skurudo!
Still works!! I upgraded to version 4.7.8 on Debian9.3 and PHP7.2 without problems!!

[skurudo]

It's nice to hear @tkramer ;-)

[servraid]

- download https://www.phpmyadmin.net/downloads/
- extract in temp folder
- make backup /usr/share/phpMyAdmin
- copy from your temp folder to /usr/share/phpMyAdmin
- check permissions

And you can add patch - viewtopic.php?f=14&t=10307

There is couple of issues with these instructions you gave :
1. the setup for vestcp using phpmyadmin is different the config.php file is located in etc/phpmyadmin https://vestacp.com/docs/#config-log-lo ... ian-ubuntu
so you need to copy this file to your usr/share/phpmyadmin folder
2. there is no TempDir location in the vesta config.php phpmyadmin

Vestacp setup phpmyadmin differently including even the way it's spelled. phpmyadmin not phpMyAdmin


updated instruction would be great thanks!