vipin
October 2, 2014, 8:27pm
1
Hi,
I have recentely downgrade sql server from percona 5.6 to mysql 5.5 , After downgrade the following errors appears in my interworx control panel.
======
InterWorx Error Report
DETAIL:
FILE: /usr/local/interworx/include/drivers/other/SIM.php
LINE: 111
MESSAGE:
Undefined variable: services
STACK TRACE:
----- DEBUG STACKTRACE BEGIN -----
/usr/local/interworx/include/drivers/other/SIM.php errorHandler (111)
/usr/local/interworx/include/drivers/other/SIM.php getServiceStatus (138)
/usr/local/interworx/include/Form/NW/Mysql/AutoRestart.php getInfo (48)
/usr/local/interworx/include/Form.php _initialize (1328)
/usr/local/interworx/include/Ctrl/Nodeworx/Mysql.php getInstance (80)
/usr/local/interworx/include/IWorx/Method.php indexAction (142)
/usr/local/interworx/include/FrontController.php invoke (422)
/usr/local/interworx/include/FrontController.php _invokeMethodAndPlugins (399)
/usr/local/interworx/include/FrontController.php _invokeAction (156)
/usr/local/interworx/include/FrontController.php _route (105)
/usr/local/interworx/html/index.php route (37)
----- DEBUG STACKTRACE END -----
Please see the attachment
Any one please help me to sort out this issue
Is percona 5.5 and 5.6 compatable with interworx ?
d2d4j
October 2, 2014, 9:20pm
2
Hi vipin
Please see your first post.
Perconna works lovely with IW, as it’s just a tweaked MySQL
I believe your issue all relates to quotas but I could be wrong sorry.
We use perconna
Many thanks
John
vipin
October 3, 2014, 1:22am
3
Hi John,
Thank you john.
I had solved it by reinstalling System Integrity Monitor (SIM) .This is not the same server which I mentioned in my first post.
I have just upgraded installed MySQL Ver 5.6 and PHP Ver 5.5 but most of the sites are showing database connection errrors like :
=====
Using mysqli: Failed to connect to MySQL: ()
Using PDO: Error!: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client
=====
I have updated all the database users pasword to new v5 hash format and sites started working , But Unfortunately I cannot manage MySQL server or phpmyadmin from IW control panel any more
d2d4j
October 3, 2014, 1:29am
4
Hi vipin
Many thanks, and sorry I didn’t realise sorry. Also, on tapatalk, the screen is so small and my eyesight is failing
Please see this post which will explain and allow you to correct.
Briefly, it is because IW cp uses old v4 MySQL for its own use only.
I hope that helps
Many thanks
John
http://forums.interworx.com/showpost.php?p=25446