[one-users] Version 3.2.0 + MySQL problems

Mon Mar 5 02:27:57 PST 2012

Hello Robert,

After reading Lehel's email (CC) I've noticed that the openSUSE package
doesn't have support for mysql. Is there any possibility that this could be
added for the next update?

Since it's not a bug, but a request, I haven't been able to find where to
place this request in build.opensuse.org.

I'd be happy to help adding the mysql support.

Regards,
Jaime

On Sat, Mar 3, 2012 at 5:17 PM, biro lehel <lehel.biro at yahoo.com> wrote:

> Hello,
>
> I have an issue about using OpenNebula with MySQL. I have downloaded and
> installed version 3.2.0 using YaST on an openSUSE machine. The root of all
> my problems was when trying to log in the main Sunstone window, (with
> oneadmin user and password), i got the following error: "OpenNebula is not
> running". So I checked if the daemon was running (it was), and then I
> digged deeper into it, and found out that is probably a database issue. I
> have followed the instructions at [1], although it is probably a problem
> that I've only made the necessary changes in oned.conf AFTER running
> first-time the oned daemon. Now, at my one.db file (I wanted to check what
> password is set for oneadmin user) it says that:
>
> "It is an SQLite file created using other tools", and I can't open it.
> Also, running oned start (when the backend at oned.conf is set to MySQL)
> results in the following:
>
>
> ~> oned start
> ~> #Aborting oned, MySQL support not compiled!
>
> (although I CAN run onevm list, which is kinda odd to me.)
>
>
> IMPORTANT NOTE: I only wanted to use MySQL as backend because I use my
> (only) host machine as the NFS server (sharing /var/lib/one), and the
> front-end acts as the NFS client, and the documentation said that using
> SQLite in this case can cause problems. My question: is it such a very
> important matter, that I wont be able to work with my host as the NFS
> server + SQLite as the backend? I'm using OpenNebula only on a small
> infrastructure, for a faculty research project.
>
>
> oned.log contains the following:
>
> Sat Mar 3 18:08:35 2012 [ONE][I]: Log level:3
> [0=ERROR,1=WARNING,2=INFO,3=DEBUG]
> Sat Mar 3 18:08:56 2012 [ReM][D]: HostPoolInfo method invoked
> Sat Mar 3 18:08:56 2012 [ReM][D]: VirtualMachinePoolInfo method invoked
> Sat Mar 3 18:08:56 2012 [ReM][D]: AclInfo method invoked
> Sat Mar 3 18:09:26 2012 [ReM][D]: HostPoolInfo method invoked
> Sat Mar 3 18:09:26 2012 [ReM][D]: VirtualMachinePoolInfo method invoked
> Sat Mar 3 18:09:26 2012 [ReM][D]: AclInfo method invoked
> Sat Mar 3 18:09:56 2012 [ReM][D]: HostPoolInfo method invoked
> Sat Mar 3 18:09:56 2012 [ReM][D]: VirtualMachinePoolInfo method invoked
> Sat Mar 3 18:09:56 2012 [ReM][D]: AclInfo method invoked
> Sat Mar 3 18:09:58 2012 [InM][I]: --Mark--
> Sat Mar 3 18:09:58 2012 [VMM][I]: --Mark--
> Sat Mar 3 18:10:18 2012 [ReM][D]: UserPoolInfo method invoked
> Sat Mar 3 18:10:18 2012 [AuM][D]: Message received: LOG I 6 Command
> execution fail: /var/lib/one/remotes/auth/server_cipher/authenticate
> 'serveradmin' '33f166cddc4d8f9ffe2102cea013ff23a286bc58'
> ukbtkaYnnWypvN2hqaDZgb4qLOVbPVRjak9+onOYBXNlgi3SJWOPbbH1lYKz7hG8
>
> Sat Mar 3 18:10:18 2012 [AuM][I]: Command execution fail:
> /var/lib/one/remotes/auth/server_cipher/authenticate 'serveradmin'
> '33f166cddc4d8f9ffe2102cea013ff23a286bc58'
> ukbtkaYnnWypvN2hqaDZgb4qLOVbPVRjak9+onOYBXNlgi3SJWOPbbH1lYKz7hG8
> Sat Mar 3 18:10:18 2012 [AuM][D]: Message received: LOG I 6 sh:
> /var/lib/one/remotes/auth/server_cipher/authenticate: Permission denied
>
> Sat Mar 3 18:10:18 2012 [AuM][I]: sh:
> /var/lib/one/remotes/auth/server_cipher/authenticate: Permission denied
> Sat Mar 3 18:10:18 2012 [AuM][D]: Message received: LOG I 6 ExitCode: 126
>
> Sat Mar 3 18:10:18 2012 [AuM][I]: ExitCode: 126
> Sat Mar 3 18:10:18 2012 [AuM][D]: Message received: AUTHENTICATE FAILURE 6
> -
>
> Sat Mar 3 18:10:18 2012 [AuM][E]: Auth Error:
> Sat Mar 3 18:10:18 2012 [ReM][E]: [UserPoolInfo] User couldn't be
> authenticated, aborting call.
> Sat Mar 3 18:10:19 2012 [ReM][D]: UserPoolInfo method invoked
> Sat Mar 3 18:10:20 2012 [AuM][D]: Message received: LOG I 7 Command
> execution fail: /var/lib/one/remotes/auth/server_cipher/authenticate
> 'serveradmin' '33f166cddc4d8f9ffe2102cea013ff23a286bc58'
> ukbtkaYnnWypvN2hqaDZgb4qLOVbPVRjak9+onOYBXNlgi3SJWOPbbH1lYKz7hG8
>
> Sat Mar 3 18:10:20 2012 [AuM][I]: Command execution fail:
> /var/lib/one/remotes/auth/server_cipher/authenticate 'serveradmin'
> '33f166cddc4d8f9ffe2102cea013ff23a286bc58'
> ukbtkaYnnWypvN2hqaDZgb4qLOVbPVRjak9+onOYBXNlgi3SJWOPbbH1lYKz7hG8
> Sat Mar 3 18:10:20 2012 [AuM][D]: Message received: LOG I 7 sh:
> /var/lib/one/remotes/auth/server_cipher/authenticate: Permission denied
>
> Sat Mar 3 18:10:20 2012 [AuM][I]: sh:
> /var/lib/one/remotes/auth/server_cipher/authenticate: Permission denied
> Sat Mar 3 18:10:20 2012 [AuM][D]: Message received: LOG I 7 ExitCode: 126
>
> Sat Mar 3 18:10:20 2012 [AuM][I]: ExitCode: 126
> Sat Mar 3 18:10:20 2012 [AuM][D]: Message received: AUTHENTICATE FAILURE 7
> -
>
> Sat Mar 3 18:10:20 2012 [AuM][E]: Auth Error:
> Sat Mar 3 18:10:20 2012 [ReM][E]: [UserPoolInfo] User couldn't be
> authenticated, aborting call.
>
> I'm new to OpenNebula, so any help is much appreciated.
>
> Thank you
>
> [1] http://opennebula.org/documentation:rel3.2:mysql
>
> _______________________________________________
> Users mailing list
> Users at lists.opennebula.org
> http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
>
>

-- 
Jaime Melis
Project Engineer
OpenNebula - The Open Source Toolkit for Cloud Computing
www.OpenNebula.org | jmelis at opennebula.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20120305/34d742bb/attachment-0003.htm>