Al Olese
2006-Jul-01 15:57 UTC
[Instantrails-users] Connection problems to DB using password
Hello, I am using InstantRails 1.3a and I am having trouble. If I try to enable passwords in database.yml for the mysql account, I get a "Before updating scaffolding from new db schema, try creating a table for your model" message if I try to do a simple script/generate scaffold command. I get the same message if I use a bogus password, but if I disable the password (and do the same in mysql of course) things work as normal again... any ideas? I can use the standard mysql client to access the database when the password is set so there is nothing wrong with the privileges. _________________________________________________________________ MSN Spaces http://spaces.msn.com/?mkt=nb-no Vis hvem du er og hva du vil
David Morton
2006-Jul-01 16:13 UTC
[Instantrails-users] Connection problems to DB using password
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Al Olese wrote:> Hello, I am using InstantRails 1.3a and I am having trouble. If I try to > enable passwords in database.yml for the mysql account, I get a "Before > updating scaffolding from new db schema, try creating a table for your > model" message if I try to do a simple script/generate scaffold command. I > get the same message if I use a bogus password, but if I disable the > password (and do the same in mysql of course) things work as normal again... > any ideas? > > I can use the standard mysql client to access the database when the password > is set so there is nothing wrong with the privileges.If this is the same person I was talking to on IRC, another possibly important clue was this error message: [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run" - -- David Morton Maia Mailguard - http://www.maiamailguard.com Morton Software Design and Consulting - http://www.dgrmm.net -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD4DBQFEpp9DUy30ODPkzl0RAuFzAKDHds9b7X+6fLVM/+JBUUEKQ5JflACYuZFd OQNi7QDHTPYhWn0rVQp27A==xptn -----END PGP SIGNATURE-----
David Morton
2006-Jul-02 21:39 UTC
[Instantrails-users] Connection problems to DB using password
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Al Olese wrote:> Hello, I am using InstantRails 1.3a and I am having trouble. If I try to > enable passwords in database.yml for the mysql account, I get a "Before > updating scaffolding from new db schema, try creating a table for your > model" message if I try to do a simple script/generate scaffold command. I > get the same message if I use a bogus password, but if I disable the > password (and do the same in mysql of course) things work as normal again... > any ideas? > > I can use the standard mysql client to access the database when the password > is set so there is nothing wrong with the privileges.Ok, now that I have a windows box running again.... :) How did you go about changing the password? That error message about "mysql.user table is not updated to new password format" is the problem. I think you said you had mysql 4? what steps did you take to change the password in mysql? - -- David Morton Maia Mailguard - http://www.maiamailguard.com Morton Software Design and Consulting - http://www.dgrmm.net -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2.2 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEqD0DUy30ODPkzl0RAnhKAKCRMIKkxE0BTDcbfW2BO3Xb4MycSACfbvcT Nu1T3USsgXMBMBwuXX8TJVg=vsXh -----END PGP SIGNATURE-----