Topic: SME 9 Upgrade php/mysql

[igloosys]

hi all,

i have went through a lot of posting and howto and finally found this link on how to upgrade php using REMI.
http://wiki.contribs.org/Upgrade_php/mysql

Everything was working but when login to phpmyadmin. i get a bunch of error messages. its a open_basedir restriction. should i be concern? is this a bug?
Read about open_basedir is from http://wiki.contribs.org/PHP
But i think it doesn't really apply for my issue

[root@hydra ~]# php -v
PHP 5.5.24 (cli) (built: Apr 16 2015 06:33:00)
Copyright (c) 1997-2015 The PHP Group
Zend Engine v2.5.0, Copyright (c) 1998-2015 Zend Technologies
[root@hydra ~]#

[root@hydra ~]# rpm -qa phpMyAdmin*
phpMyAdmin-4.4.4-1.el6.remi.noarch
[root@hydra ~]#


Warning in ./libraries/Util.class.php#516
 file_exists(): open_basedir restriction in effect. File(doc/html/index.html) is not within the allowed path(s): (/usr/share/php:/usr/share/phpMyAdmin:/etc/phpMyAdmin:/var/lib/phpMyAdmin:/tmp)

Backtrace

./libraries/Util.class.php#516: file_exists(string 'doc/html/index.html')
./libraries/Util.class.php#540: PMA_Util::getDocuLink(
string 'faq',
string 'faq7-2',
)
./libraries/display_select_lang.lib.php#59: PMA_Util::showDocu(
string 'faq',
string 'faq7-2',
)
./index.php#231: PMA_getLanguageSelectorHtml()

[DanB35]

You'd be better off reverting your PHP upgrade and using software collections (http://wiki.contribs.org/PHP_Software_Collections) to install the newer version.  PHP doesn't do a great job of maintaining backward compatibility, even from one minor release to the next.

[Stefano]

I agree with DanB35..

you're likely messing your server..

[igloosys]

i have reinstalled SME 9 and following which i also installed phpmyadmin
then installed the default phpmyadmin (http://wiki.contribs.org/PHPMyAdmin)
managed to login to phpmyadmin without any problems

subsequently, i have done the installation for using (http://wiki.contribs.org/PHP_Software_Collections)

but after the installation ... i cannot see phpmyadmin anymore.

on another machine, with no php software collections, i didnt encounter such issues. i am also not able to find anyone facing the same issue.

[root@hydra ~]# rpm -qa mysql*
mysql-server-5.1.73-3.el6_5.x86_64
mysql-libs-5.1.73-3.el6_5.x86_64
mysql-5.1.73-3.el6_5.x86_64
[root@hydra ~]#

[root@hydra ~]# rpm -qa *phpmy*
smeserver-phpmyadmin-4.0.10.2-2.el6.sme.noarch
[root@hydra ~]#

[Stefano]

you should take a look at /var/log/httpd/ log files

and, please, report your issue in bugzilla, thank you

[igloosys]

just an update.

I tried to look up the logs, but is this all I had.

"GET /phpmyadmin/ HTTP/1.1" 200 445 "-" "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/4

when I hit the collation error, specifically #1273 - Unknown collation: 'utf8mb4_general_ci'

I realised I was in vpn and phpmyadmin was not opened to external access for security reasons. thinking what the heck. might as well try it... I opened phpmyadmin for external excess and strangely, the error was not there. suspect it was my pc likely having strange issues.

did further research and found this
http://stackoverflow.com/questions/21190523/phpmysql-error-1273-1273-unknown-collation-utf8mb4-general-ci

as the phpmyadmin versions where different, I only decided to try to disconnect, reboot, clear cache in chrome and IE and try to connect again, this time round, both vpn and external was working. so its ok now.

hope this helps if someone hit a similar issue.