[one-users] Version 3.2.0 + MySQL problems

[biro lehel]

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: 

p, li { white-space: pre-wrap; }

"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

        
            
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20120303/6940a71d/attachment-0001.htm>