[one-users] Version 3.2.0 + MySQL problems

Mon Mar 5 02:36:56 PST 2012

Hello Lehel,

if it's not critical to you to have mysql support as you said in your
email, you can always create a symlink where the target is somewhere
outside of the NFS export, like /var/tmp/one.db and pointing to
/var/lib/one/one.db:

ln -s /var/tmp/one.db /var/lib/one/one.db

After that OpenNebula will work correctly with a SQLite backend.

If this doesn't fix your problems, try logging in as oneadmin and check
that you can write and execute under /var/lib/one/

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/979ba03b/attachment-0003.htm>