Bug #809

onedb does not work password with special characters.

Added by Shi Jin 8 months ago. Updated 8 months ago.

Status:Closed Start date:09/15/2011
Priority:Normal Due date:
Assignee:Carlos Martín % Done:

0%
Category:-
Target version:Release 3.0
Resolution:wontfix Affected Version:OpenNebula 3.0
Story points-
Velocity based estimate-

Description

Hi there,

My mysql database password contains and #. When I tried to run "onedb history" command to upgrade from one-3beta1 to beta2, it failed indicating password confusion caused by and #.
After I changed my password to one without @ or #, the onedb commands work as expected.
It would be good to fix this since the oned command does not have a problem with these special characters at all.
I guess this is because they use different ruby database backends, sequel from gem vs ruby-mysql.
Not sure if you can fix it at the onedb command level or have to go upstream to sequel.
Still, it would be nice to be consistent.

Thanks.

Shi

History

#1
Updated by Shi Jin 8 months ago

you can see that even my post is messed up with the special characters.

The special characters I mentioned above are

@ and #

#2
Updated by Carlos Martín 8 months ago

  • Assignee set to Carlos Martín
  • Target version set to Release 3.0

#3
Updated by Carlos Martín 8 months ago

The onedb command relies on the sequel gem, and I don't see any easy way to solve this from our code.

I'd say it is reasonable to leave this bug as a known issue, since the workaround is quite easy.
To change the oneadmin's password, the set password statement can be used:

$ mysql -u oneadmin -p

mysql> SET PASSWORD = PASSWORD('newpass');

#4
Updated by Shi Jin 8 months ago

Yes, this is exactly what I expected.
It is interesting to me though that the core OpenNebula does not have this problem since it is using ruby-mysql.
Also, I think a different ruby mysql engine is used for the oZone part.
I am curious what is the cause of using 3 different mysql interface within a single project.

#5
Updated by Carlos Martín 8 months ago

  • Status changed from New to Closed
  • Resolution set to wontfix
  • Affected Version set to OpenNebula 3.0

Also available in: Atom PDF