[BlueOnyx:04296] Re: MySQL/phpmyadmin error

[Don Teague]

That shows me my current user/pass to mysql ... connection via command
line has always worked.

Many, many attempts to change the password in the GUI have failed.

On Sat, Apr 17, 2010 at 11:43 PM, Greg Kuhnert
<greg.kuhnert at theanchoragesylvania.com> wrote:
> I have seen something like this once before recently. In the other case,
> BX got out of sync with mysql after a mysql database restore. To check
> the details in the BX database, follow the steps below:
>
> Step 1. Login to CCE
> /usr/sausalito/bin/cceclient
>
> Step 2: Find the system object - "find system"
> 100 CSCP/0.80
> 200 READY
> find System
> 104 OBJECT 3
> 201 OK
>
> In the line above we got the object # 3 for the system object.
>
> Step 3: Now - lets get mysql settings. The get command below will need
> to have the same object number you found above for the system object.
>
> get 3.mysql
> 102 DATA NAMESPACE = "mysql"
> 102 DATA oldpass = "myoldpassword"
> 102 DATA username = "root"
> 102 DATA dump = ""
> 102 DATA CLASSVER = "1.2"
> 102 DATA delete = ""
> 102 DATA newpass = "mynewpassword"
> 102 DATA mysqluser = "root"
> 102 DATA onoff = "1260254639"
> 102 DATA password = ""
> 102 DATA dumpsize = "- n/a -"
> 102 DATA changepass = "1267708176"
> 102 DATA dumpdate = "- n/a -"
> 102 DATA enabled = "1"
> 201 OK
> bye
> 202 GOODBYE
>
> Step 4: Try to connect to mysql with the settings found in the database
> above. Use the username found in the mysqluser field, and try using the
> password found in "newpass". If it works, I am puzzled .... but if it
> doesnt work, you've found your culprit. Just do a password change in the
> gui, and all will be fixed.
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at blueonyx.it
> http://www.blueonyx.it/mailman/listinfo/blueonyx
>