[BlueOnyx:24770] BlueOnyx 5208R SQL settings error

Thomas Petersen thomas at nsd.dk
Wed Feb 10 15:04:40 -05 2021


My old BlueOnyx 5208R has a issue.

I can login thru cli mysql -p 
I can set the username and password under "web applications" / "Setup SQL" status : MySQL connection possible with this settings
I can login to phpmyadmin  as root and password
cceclient shows the correct username and password that also woks in the above

but if I try to enter the same username and password in "Network Services" / "MySQL" I get status: MySQL connection cannot be established. Check settings. 
This means that I can not change anything on virtual sites if SQL is enabled, I then get " MySQL connection cannot be established. Please check the settings under 'Network Services' / 'MySQL Config' first. Also see if MySQL is running." 
Also "Automatic Backup" does not work.

I have tried  - Admserver restarted, and finaly server restarted - no change

Messagelog show this when I enter password : 

Feb 10 20:57:06 web05 cced(smd)[9224]: client 5:[49:6714]: SET  1 . mysql "oldpass" "=" "" "username" "=" "root" "newpass" "=" "" "onoff" "=" "1612987026" "password" "=" xxx "changepass" "=" "1612987026" "enabled" "=" "1"
Feb 10 20:57:07 web05 cced(smd)[9224]: client 5:[49:6714]: SET succeeded
Feb 10 20:57:07 web05 cced(smd)[9224]: client 5:[49:6714]: SET  32 "sql_rootpassword" "=" "MyCorrectPassword" "sql_host" "=" "127.0.0.1" "timestamp" "=" "1612987027" "savechanges" "=" "1612987027" "sql_port" "=" "3306" "sql_root" "=" "root"
Feb 10 20:57:07 web05 cced(smd)[9224]: client 5:[49:6714]: SET succeeded
Feb 10 20:57:07 web05 cced(smd)[9268]: client 5:[49:6716]: SET  1 . mysql "dumpsize" "=" "0mb" "dumpdate" "=" "Feb 10 2021 - 2:19 pm" "enabled" "=" "1"
Feb 10 20:57:07 web05 cced(smd)[9268]: client 5:[49:6716]: SET succeeded
Feb 10 20:57:07 web05 cced(smd)[9272]: client [0:9271] has admin rights

And still I get "connection cannot be established".... I am lost for idees 

Regards
Thomas Petersen






More information about the Blueonyx mailing list