[one-users] Version 3.2.0 + MySQL problems

biro lehel lehel.biro at yahoo.com
Mon Mar 5 07:59:15 PST 2012


Hello Jaime,

Thank you very much for your answer. I performed your suggestions, and changed back the DB backend to SQLite (also, checked the executing permissions you have mentioned).

However, my initial problem still exists. I can't log on with oneadmin's user and password to the main Sunstone interface (I get the "OpenNebula is not running" error each time, written in red above the log-in box, although oned daemon is started). I checked one.db , to see what password is set for oneadmin, but I couldn't find any password field.

Any suggestions what should I do?

I attach the contents of oned.log (I just noticed that error related to port 2633, it's the first time it appears here):

Mon Mar  5 17:54:44 2012 [ONE][I]: Log level:3 [0=ERROR,1=WARNING,2=INFO,3=DEBUG]
Mon Mar  5 17:54:44 2012 [ONE][I]: Checking database version.
Mon Mar  5 17:54:44 2012 [VMM][I]: Starting Virtual Machine Manager...
Mon Mar  5 17:54:44 2012 [VMM][I]: Virtual Machine Manager started.
Mon Mar  5 17:54:44 2012 [LCM][I]: Starting Life-cycle Manager...
Mon Mar  5 17:54:44 2012 [LCM][I]: Life-cycle Manager started.
Mon Mar  5 17:54:44 2012 [InM][I]: Starting Information Manager...
Mon Mar  5 17:54:44 2012 [InM][I]: Information Manager started.
Mon Mar  5 17:54:44 2012 [TrM][I]: Starting Transfer Manager...
Mon Mar  5 17:54:44 2012 [TrM][I]: Transfer Manager started.
Mon Mar  5 17:54:44 2012 [DiM][I]: Starting Dispatch Manager...
Mon Mar  5 17:54:44 2012 [DiM][I]: Dispatch Manager started.
Mon Mar  5 17:54:44 2012 [HKM][I]: Starting Hook Manager...
Mon Mar  5 17:54:44 2012 [HKM][I]: Hook Manager started.
Mon Mar  5 17:54:44 2012 [AuM][I]: Starting Auth Manager...
Mon Mar  5 17:54:44 2012 [AuM][I]: Authorization Manager started.
Mon Mar  5 17:54:44 2012 [ImM][I]: Starting Image Manager...
Mon Mar  5 17:54:44 2012 [ImM][I]: Image Manager started.
Mon Mar  5 17:54:44 2012 [ReM][I]: Starting Request Manager...
Mon Mar  5 17:54:44 2012 [ReM][E]: Can not bind to port 2633 : Address already in use
Mon Mar  5 17:54:46 2012 [ReM][D]: HostPoolInfo method invoked
Mon Mar  5 17:54:47 2012 [ReM][D]: VirtualMachinePoolInfo method invoked
Mon Mar  5 17:54:47 2012 [ReM][D]: AclInfo method invoked
Mon Mar  5 17:54:53 2012 [ReM][D]: UserPoolInfo method invoked
Mon Mar  5 17:54:53 2012 [AuM][D]: Message received: LOG I 9 Command execution fail: /var/lib/one/remotes/auth/server_cipher/authenticate 'serveradmin' '33f166cddc4d8f9ffe2102cea013ff23a286bc58' ukbtkaYnnWypvN2hqaDZgTY3Fq4cD5iJZ+6B6Xie1WXlXrbZS7XwYD4bj52XHzI4

Mon Mar  5 17:54:53 2012 [AuM][I]: Command execution fail: /var/lib/one/remotes/auth/server_cipher/authenticate 'serveradmin' '33f166cddc4d8f9ffe2102cea013ff23a286bc58' ukbtkaYnnWypvN2hqaDZgTY3Fq4cD5iJZ+6B6Xie1WXlXrbZS7XwYD4bj52XHzI4
Mon Mar  5 17:54:53 2012 [AuM][D]: Message received: LOG I 9 sh: /var/lib/one/remotes/auth/server_cipher/authenticate: Permission denied

Mon Mar  5 17:54:53 2012 [AuM][I]: sh: /var/lib/one/remotes/auth/server_cipher/authenticate: Permission denied
Mon Mar  5 17:54:53 2012 [AuM][D]: Message received: LOG I 9 ExitCode: 126

Mon Mar  5 17:54:53 2012 [AuM][I]: ExitCode: 126
Mon Mar  5 17:54:53 2012 [AuM][D]: Message received: AUTHENTICATE FAILURE 9 -

Mon Mar  5 17:54:53 2012 [AuM][E]: Auth Error: 
Mon Mar  5 17:54:53 2012 [ReM][E]: [UserPoolInfo] User couldn't be authenticated, aborting call.

--- On Mon, 3/5/12, Jaime Melis <jmelis at opennebula.org> wrote:

From: Jaime Melis <jmelis at opennebula.org>
Subject: Re: [one-users] Version 3.2.0 + MySQL problems
To: "biro lehel" <lehel.biro at yahoo.com>
Cc: users at lists.opennebula.org
Date: Monday, March 5, 2012, 12:36 PM

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


More information about the Users mailing list