[BlueOnyx:09597] mysql password for the GUI

[Gerald Waugh]

I can login to mysql in a shell, phpMyAdmin works in the GUI

I have tried everything imaginable, but the GUI still indicates
MySQL connection cannot be established. Check settings.

Tried resetting password in the GUI, see below, appears to work but
still get the error

Feb 12 15:53:40 sv2 cced(smd)[6411]: client 6:[48:6395]: SET 1 . mysql
"oldpass" "=" "-1" "newpass" "=" "password" "mysqluser" "=" "root"
"changepass" "=" "1329083620"
Feb 12 15:53:40 sv2 cced(smd)[6411]: client 6:[48:6395]: SET succeeded

Feb 12 15:53:40 sv2 cced(smd)[6415]: client 6:[48:6395]: SET 33
"sql_rootpassword" "=" "password" "sql_host" "=" "localhost" "timestamp"
"=" "1329083620" "savechanges" "=" "1329083620" "sql_port" "=" "3306"
"sql_root" "=" "root"

Feb 12 15:53:40 sv2 cced(smd)[6415]: client 6:[48:6395]: SET succeeded

Feb 12 15:53:45 sv2 cced(smd)[6421]: client 6:[48:6397]: SET 1 . mysql
"dumpsize" "=" "- n/a -" "dumpdate" "=" "- n/a -" "enabled" "=" "1"

Feb 12 15:53:45 sv2 cced(smd)[6421]: client 6:[48:6397]: SET succeeded

[Gerald Waugh]

Post by Gerald Waugh
I can login to mysql in a shell, phpMyAdmin works in the GUI
I have tried everything imaginable, but the GUI still indicates
MySQL connection cannot be established. Check settings.
Tried resetting password in the GUI, see below, appears to work but
still get the error
Feb 12 15:53:40 sv2 cced(smd)[6411]: client 6:[48:6395]: SET 1 . mysql
"oldpass" "=" "-1" "newpass" "=" "password" "mysqluser" "=" "root"
"changepass" "=" "1329083620"
Feb 12 15:53:40 sv2 cced(smd)[6411]: client 6:[48:6395]: SET succeeded
Feb 12 15:53:40 sv2 cced(smd)[6415]: client 6:[48:6395]: SET 33
"sql_rootpassword" "=" "password" "sql_host" "=" "localhost" "timestamp"
"=" "1329083620" "savechanges" "=" "1329083620" "sql_port" "=" "3306"
"sql_root" "=" "root"
Feb 12 15:53:40 sv2 cced(smd)[6415]: client 6:[48:6395]: SET succeeded
Feb 12 15:53:45 sv2 cced(smd)[6421]: client 6:[48:6397]: SET 1 . mysql
"dumpsize" "=" "- n/a -" "dumpdate" "=" "- n/a -" "enabled" "=" "1"
Feb 12 15:53:45 sv2 cced(smd)[6421]: client 6:[48:6397]: SET succeeded

this does not look good?

[***@sv2 ~]# /usr/sausalito/bin/cceclient
100 CSCP/0.80
200 READY
find system
301 UNKNOWN CLASS system
401 FAIL

[Gerald Waugh]

Post by Gerald Waugh

Post by Gerald Waugh
I can login to mysql in a shell, phpMyAdmin works in the GUI
I have tried everything imaginable, but the GUI still indicates
MySQL connection cannot be established. Check settings.
Tried resetting password in the GUI, see below, appears to work but
still get the error
Feb 12 15:53:40 sv2 cced(smd)[6411]: client 6:[48:6395]: SET 1 . mysql
"oldpass" "=" "-1" "newpass" "=" "password" "mysqluser" "=" "root"
"changepass" "=" "1329083620"
Feb 12 15:53:40 sv2 cced(smd)[6411]: client 6:[48:6395]: SET succeeded
Feb 12 15:53:40 sv2 cced(smd)[6415]: client 6:[48:6395]: SET 33
"sql_rootpassword" "=" "password" "sql_host" "=" "localhost" "timestamp"
"=" "1329083620" "savechanges" "=" "1329083620" "sql_port" "=" "3306"
"sql_root" "=" "root"
Feb 12 15:53:40 sv2 cced(smd)[6415]: client 6:[48:6395]: SET succeeded
Feb 12 15:53:45 sv2 cced(smd)[6421]: client 6:[48:6397]: SET 1 . mysql
"dumpsize" "=" "- n/a -" "dumpdate" "=" "- n/a -" "enabled" "=" "1"
Feb 12 15:53:45 sv2 cced(smd)[6421]: client 6:[48:6397]: SET succeeded

this does not look good?
100 CSCP/0.80
200 READY
find system
301 UNKNOWN CLASS system
401 FAIL

should be "find System"

find System
104 OBJECT 1
201 OK
get 1.mysql
102 DATA NAMESPACE = "mysql"
102 DATA oldpass = "passwd"
102 DATA username = "root"
102 DATA dump = "1329084857"
102 DATA CLASSVER = "1.2"
102 DATA delete = ""
102 DATA newpass = "passwd"
102 DATA mysqluser = "root"
102 DATA onoff = "1329086877"
102 DATA password = ""
102 DATA dumpsize = "2k"
102 DATA changepass = "1329086486"
102 DATA dumpdate = "Feb 12 2012 - 4:14 pm"
102 DATA enabled = "1"
201 OK

So that all looks OK, but still get the error
passwd above is the actual password I set the root password to.
MySQL connection cannot be established. Check settings.

[Dudi Goldenberg]

Hi,

Post by Gerald Waugh
I can login to mysql in a shell, phpMyAdmin works in the GUI
I have tried everything imaginable, but the GUI still indicates
MySQL connection cannot be established. Check settings.
Tried resetting password in the GUI, see below, appears to work but
still get the error

Is the mysql GUI set for localhost/3306?

The fact that mysql login works from phpmyadmin & the shell is encouraging...

I'd check what addresses mysql actually listens on via netstat, and verify the lo is up and running.

This smells like a localhost thingie.

Regards,

D.

[Michael Stauber]

Hi Gerald,

Post by Gerald Waugh
I can login to mysql in a shell, phpMyAdmin works in the GUI
I have tried everything imaginable, but the GUI still indicates
MySQL connection cannot be established. Check settings.

BlueOnyx stores the MySQL "root" password in the class named "MySQL". Not in
the subclass "mysql" of "System".

[***@sol ~]# /usr/sausalito/bin/cceclient
100 CSCP/0.80
200 READY

find MySQL
104 OBJECT 30
201 OK

get 30
102 DATA NAMESPACE = ""
102 DATA sql_rootpassword = "the_password"
102 DATA CLASSVER = "1.0"
102 DATA sql_host = "localhost"
102 DATA timestamp = "1322331581"
102 DATA CLASS = "MySQL"
102 DATA savechanges = "1322331581"
102 DATA sql_port = "3306"
102 DATA OID = "30"
102 DATA sql_root = "root"
201 OK

Like Dudi said: If the password is correct and it doesn't work for the GUI,
then access from "localhost" to MySQL may not be working. This could be
because MySQL is either not configured to listen on localhost, or maybe
someone removed the privileges for "***@localhost". Typically there are two
"root" users for MySQL configured. One for "***@localhost" (user root
connecting from localhost) and "root@*" (root connecting from anywhere else).

If the localhost "root" user of MySQL has been removed, it can be added again
this way:

http://www.solarspeed.net/otrs/public.pl?Action=PublicFAQZoom;ItemID=26

[Gerald Waugh]

Post by Michael Stauber
Hi Gerald,

Post by Gerald Waugh
I can login to mysql in a shell, phpMyAdmin works in the GUI
I have tried everything imaginable, but the GUI still indicates
MySQL connection cannot be established. Check settings.

BlueOnyx stores the MySQL "root" password in the class named "MySQL". Not in
the subclass "mysql" of "System".
100 CSCP/0.80
200 READY
find MySQL
104 OBJECT 30
201 OK
get 30
102 DATA NAMESPACE = ""
102 DATA sql_rootpassword = "the_password"
102 DATA CLASSVER = "1.0"
102 DATA sql_host = "localhost"
102 DATA timestamp = "1322331581"
102 DATA CLASS = "MySQL"
102 DATA savechanges = "1322331581"
102 DATA sql_port = "3306"
102 DATA OID = "30"
102 DATA sql_root = "root"
201 OK
Like Dudi said: If the password is correct and it doesn't work for the GUI,
then access from "localhost" to MySQL may not be working. This could be
because MySQL is either not configured to listen on localhost, or maybe
If the localhost "root" user of MySQL has been removed, it can be added again
http://www.solarspeed.net/otrs/public.pl?Action=PublicFAQZoom;ItemID=26

[***@sv2 ~]# /usr/sausalito/bin/cceclient
100 CSCP/0.80
200 READY
find MySQL
104 OBJECT 33
201 OK
get 33
102 DATA NAMESPACE = ""
102 DATA sql_rootpassword = "passwd"
102 DATA CLASSVER = "1.0"
102 DATA sql_host = "localhost"
102 DATA timestamp = "1329106764"
102 DATA CLASS = "MySQL"
102 DATA savechanges = "1329106764"
102 DATA sql_port = "3306"
102 DATA OID = "33"
102 DATA sql_root = "root"
201 OK

All passwords are the same as I put in the GUI and we can login to mysql
in a shell session. I did note that a vsite could not be deleted until
we turned off mysql for the site.

[***@sv2 ~]# netstat -tupan | grep 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 5420/mysqld

So all this looks OK?

[Gerald Waugh]

Post by Gerald Waugh

Post by Michael Stauber
Hi Gerald,

Post by Gerald Waugh
I can login to mysql in a shell, phpMyAdmin works in the GUI
I have tried everything imaginable, but the GUI still indicates
MySQL connection cannot be established. Check settings.

BlueOnyx stores the MySQL "root" password in the class named "MySQL". Not in
the subclass "mysql" of "System".
100 CSCP/0.80
200 READY
find MySQL
104 OBJECT 30
201 OK
get 30
102 DATA NAMESPACE = ""
102 DATA sql_rootpassword = "the_password"
102 DATA CLASSVER = "1.0"
102 DATA sql_host = "localhost"
102 DATA timestamp = "1322331581"
102 DATA CLASS = "MySQL"
102 DATA savechanges = "1322331581"
102 DATA sql_port = "3306"
102 DATA OID = "30"
102 DATA sql_root = "root"
201 OK
Like Dudi said: If the password is correct and it doesn't work for the GUI,
then access from "localhost" to MySQL may not be working. This could be
because MySQL is either not configured to listen on localhost, or maybe
If the localhost "root" user of MySQL has been removed, it can be added again
http://www.solarspeed.net/otrs/public.pl?Action=PublicFAQZoom;ItemID=26

100 CSCP/0.80
200 READY
find MySQL
104 OBJECT 33
201 OK
get 33
102 DATA NAMESPACE = ""
102 DATA sql_rootpassword = "passwd"
102 DATA CLASSVER = "1.0"
102 DATA sql_host = "localhost"
102 DATA timestamp = "1329106764"
102 DATA CLASS = "MySQL"
102 DATA savechanges = "1329106764"
102 DATA sql_port = "3306"
102 DATA OID = "33"
102 DATA sql_root = "root"
201 OK
All passwords are the same as I put in the GUI and we can login to mysql
in a shell session. I did note that a vsite could not be deleted until
we turned off mysql for the site.
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 5420/mysqld
So all this looks OK?

I believe this indicates that this is the localhost root logging in

[***@sv2 ~]# mysql -uroot -pbad-pass
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)

[***@sv2 ~]# mysql -uroot -pgood-pass
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.1.61 Source distribution
......
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql>

I sure hate to reload this server ..... lot of sites....

[Dudi Goldenberg]

Post by Gerald Waugh
All passwords are the same as I put in the GUI and we can login to mysql
in a shell session. I did note that a vsite could not be deleted until
we turned off mysql for the site.
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 5420/mysqld
So all this looks OK?

Looks fine to me...

You can verify both mysql root accts via phpmyadmin - just to make sure that Michael's note is checked.

Regards,

D.

[Gerald Waugh]

Post by Dudi Goldenberg

Post by Gerald Waugh
All passwords are the same as I put in the GUI and we can login to mysql
in a shell session. I did note that a vsite could not be deleted until
we turned off mysql for the site.
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 5420/mysqld
So all this looks OK?

Looks fine to me...
You can verify both mysql root accts via phpmyadmin - just to make sure that Michael's note is checked.

thanks for the response. I also see taht swatch thinks all is OK

Feb 13 06:00:02 sv2 cced(smd)[13741]: client 0:[0:13737]: SET 19 .
mysql lastChange = 1329134402 currentState = G currentMessage =
"[[base-mysql.amStatusOK]]"

[Michael Stauber]

Hi Gerald,

Post by Gerald Waugh
I also see taht swatch thinks all is OK
Feb 13 06:00:02 sv2 cced(smd)[13741]: client 0:[0:13737]: SET 19 .
mysql lastChange = 1329134402 currentState = G currentMessage =
"[[base-mysql.amStatusOK]]"

Yeah, but Swatch only checks if MySQL is running. It doesn't verify the
connection status.

I've also seen your other messages. I think I have an idea what the problem
might be, Gerald. Does your MySQL password contain a quotation mark or double
quotation mark? I.e. something like this:

Pass"word
Pass'word
Pass`word
Pass´word

If so, that potentially could be a problem as the constructors that set the
password or which delete sites could then run into problems escaping the
password string when it tries to use the password.

If that is the case, reset the password to something else without the
quotation marks, ticks or backticks.

[Gerald Waugh]

Post by Michael Stauber
Hi Gerald,

Post by Gerald Waugh
I also see taht swatch thinks all is OK
Feb 13 06:00:02 sv2 cced(smd)[13741]: client 0:[0:13737]: SET 19 .
mysql lastChange = 1329134402 currentState = G currentMessage =
"[[base-mysql.amStatusOK]]"

Yeah, but Swatch only checks if MySQL is running. It doesn't verify the
connection status.
I've also seen your other messages. I think I have an idea what the problem
might be, Gerald. Does your MySQL password contain a quotation mark or double
Pass"word
Pass'word
Pass`word
Pass´word
If so, that potentially could be a problem as the constructors that set the
password or which delete sites could then run into problems escaping the
password string when it tries to use the password.
If that is the case, reset the password to something else without the
quotation marks, ticks or backticks.

Thanks for the response.
No password is letters and numbers no other characters

[Michael Stauber]

Hi Gerald,

Post by Gerald Waugh
password is letters and numbers no other characters

I see. Sorry, am running out of ideas then. :-/

Please send me the login details and the MySQL password offlist and I'll fix
it for you.

[Wisja.net]

Hi Gerald (or Michael if he's still online),

I have the same problem. Do you recall if Michael was able to solve the problem with
the MySQL password? If not, did you do a reinstall? If he did, do you know how?

With kind regards,

Wisja

Post by Gerald Waugh

Post by Michael Stauber
Hi Gerald,

Post by Gerald Waugh
I also see taht swatch thinks all is OK
Feb 13 06:00:02 sv2 cced(smd)[13741]: client 0:[0:13737]: SET 19 .
mysql lastChange = 1329134402 currentState = G currentMessage =
"[[base-mysql.amStatusOK]]"

Yeah, but Swatch only checks if MySQL is running. It doesn't verify the
connection status.
I've also seen your other messages. I think I have an idea what the problem
might be, Gerald. Does your MySQL password contain a quotation mark or double
Pass"word
Pass'word
Pass`word
Pass´word
If so, that potentially could be a problem as the constructors that set the
password or which delete sites could then run into problems escaping the
password string when it tries to use the password.
If that is the case, reset the password to something else without the
quotation marks, ticks or backticks.

Thanks for the response.
No password is letters and numbers no other characters
--
Gerald
_______________________________________________
Blueonyx mailing list
http://mail.blueonyx.it/mailman/listinfo/blueonyx

[Wisja.net]

Fixed it myself (with the help op this webpage :
http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html)

Wisja

Post by Wisja.net
Hi Gerald (or Michael if he's still online),
I have the same problem. Do you recall if Michael was able to solve the
problem with the MySQL password? If not, did you do a reinstall? If he did, do
you know how?
With kind regards,
Wisja

Post by Gerald Waugh

Post by Michael Stauber
Hi Gerald,

Post by Gerald Waugh
I also see taht swatch thinks all is OK
Feb 13 06:00:02 sv2 cced(smd)[13741]: client 0:[0:13737]: SET 19 .
mysql lastChange = 1329134402 currentState = G currentMessage =
"[[base-mysql.amStatusOK]]"

Yeah, but Swatch only checks if MySQL is running. It doesn't verify the
connection status.
I've also seen your other messages. I think I have an idea what the problem
might be, Gerald. Does your MySQL password contain a quotation mark or double
Pass"word
Pass'word
Pass`word
Pass´word
If so, that potentially could be a problem as the constructors that set the
password or which delete sites could then run into problems escaping the
password string when it tries to use the password.
If that is the case, reset the password to something else without the
quotation marks, ticks or backticks.

Thanks for the response.
No password is letters and numbers no other characters
--
Gerald
_______________________________________________
Blueonyx mailing list
http://mail.blueonyx.it/mailman/listinfo/blueonyx

_______________________________________________
Blueonyx mailing list
http://mail.blueonyx.it/mailman/listinfo/blueonyx

[Chris Gebhardt - VIRTBIZ Internet]

Post by Wisja.net
Hi Gerald (or Michael if he's still online),
I have the same problem. Do you recall if Michael was able to solve the problem with
the MySQL password? If not, did you do a reinstall? If he did, do you know how?
With kind regards,
Wisja

There's a quick & easy tutorial on resetting a forgotten MySQL root
password here:
http://www.solarspeed.net/otrs/public.pl?Action=PublicFAQZoom;ItemID=27