[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