homer15's picture
homer15 - Tue, 2009/08/18 - 02:30

 on each turnkey appliance i use, i've noticed that the mysql root password is never the one i set in the installation.  i don't know what it is, but it's not any of the passwords listed on the info pages for the appliance.  i've just gotten used to resetting the password through the command line and flushing the permissions.  i wasn't sure if this is just happening to me (probably not), or if you guys were even aware of the problem.

Forum: 
Support
Alon Swartz's picture

Alon Swartz - Thu, 2009/08/20 - 09:01

This sounds like an awful bug, but with all of our testing prior to releasing the appliances setting the mysql root password seems to work. Are you sure you are not confusing the system root password with the mysql root password?

What appliance(s) + version did you test?
Did you install via the boot prompt or the live system?

I'll take another look to see if I can confirm the bug. Could you submit a bug report on the bug tracker.

Has anyone else come across this issue?

homer15's picture

homer15 - Thu, 2009/08/20 - 19:10

 i just did a quick test with all the mysql appliances i have.  

turnkey-lamp-2009.02-hardy-x86.iso

turnkey-mediawiki-2009.03-hardy-x86.iso

turnkey-phpbb-2009.03-hardy-x86.iso

turnkey-wordpress-2009.03-hardy-x86.iso

 

i installed all of these from the boot menu.  with a simple password of "turnkey" it works fine.  with a complex password like "p@$Sw0rD", it allows me to login to webmin but it says "Login failed : Incorrect administration username or password" for accessing mysql server.  

i'll open a bug report for this right now.

Liraz Siri's picture

Liraz Siri - Sun, 2009/08/23 - 11:46
Looking at the di-live script that sets the MySQL password I think I know what's wrong: the SQL update command is being passed through to the mysql cli command through the shell, which interpolates certain characters in the password as a variable name "MY$PASS". The fix is easy, just escape the characters (e.g., mkarg() function in commands Python library)
Alon Swartz's picture

Alon Swartz - Thu, 2009/09/03 - 22:35
This issue has been fixed and will be included in all appliance releases from now on.
For more information, refer to the bug report.
ebrandt's picture

ebrandt - Sun, 2009/09/06 - 17:23

I was banging my head thinking I was doing something wrong.  I too am having this problem.  With the LAMP and Joomla appliances.  I am new to Linux and I was just about to build my own Ubuntu JeOS LAMP appliance because I could not get these to work.  I'm not sure what is meant by (e.g., mkarg() function in commands Python library).  Can you please explain.

Alon Swartz's picture

Alon Swartz - Sun, 2009/09/06 - 17:36
See the bug report for more information (ie. the bug has been fixed and the fix will be included in all upcoming appliances).

In the meanwhile, just use a password for mysql/postgres that does not include special characters just as "$" (you can change the password later ofcourse).

Add new comment