Re: [one-users] Version 3.2.0 + MySQL problems

2012-03-05 Thread Jaime Melis
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.b...@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]: 

Re: [one-users] Version 3.2.0 + MySQL problems

2012-03-05 Thread Jaime Melis
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.b...@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 

Re: [one-users] Version 3.2.0 + MySQL problems

2012-03-05 Thread biro lehel
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 jme...@opennebula.org wrote:

From: Jaime Melis jme...@opennebula.org
Subject: Re: [one-users] Version 3.2.0 + MySQL problems
To: biro lehel lehel.b...@yahoo.com
Cc: users@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.b...@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