[one-users] Fwd: Error trying to CREATE HOST Error inserting Host Share in DB

Sebastian Neg neg.sebastian at gmail.com
Mon Apr 18 02:23:57 PDT 2011 

Yes it works:
[oneadmin at root ~]$ ssh oneadmin at localhost
Last login: Thu Apr 14 16:45:46 2011 from localhost.localhost

2011/4/15 Carlos Martín Sánchez <cmartin at opennebula.org>

> Hi Sebastian,
>
> Could you check that oneadmin can ssh passwordless to localhost?
>
>
> --
> Carlos Martín, MSc
> Project Major Contributor
> OpenNebula - The Open Source Toolkit for Cloud Computing
> www.OpenNebula.org <http://www.opennebula.org/> | cmartin at opennebula.org
>
>
> 2011/4/14 Sebastian Neg <neg.sebastian at gmail.com>
>
>> Hi Carlos,
>> I fixed the problem with the installation of rack (version 1.2.0) instead
>> of 1.2.2 and i can crete onehost.
>> But the problem now that the status of the host remains unchanged.
>>
>> [oneadmin at root ~]$ onehost list
>>   ID NAME              CLUSTER  RVM   TCPU   FCPU   ACPU    TMEM    FMEM
>> STAT
>>    1 localhost         default    0      0      0    100      0K      0K
>> on
>>
>> Here is the "oned.log"
>> Monitoring host localhost (1)
>> Thu Apr 14 13:45:28 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:45:32 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:45:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:45:38 2011 [ReM][D]: ImagePoolInfo method invoked
>> Thu Apr 14 13:45:45 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:45:50 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:45:50 2011 [ReM][D]: ClusterPoolInfo method invoked
>> Thu Apr 14 13:45:50 2011 [ReM][D]: VirtualNetworkPoolInfo method invoked
>> Thu Apr 14 13:45:50 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:45:50 2011 [ReM][D]: UserPoolInfo method invoked
>> Thu Apr 14 13:45:50 2011 [ReM][D]: ImagePoolInfo method invoked
>> Thu Apr 14 13:45:58 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:45:59 2011 [ReM][D]: HostInfo method invoked
>> Thu Apr 14 13:46:02 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:46:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:46:08 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:46:08 2011 [ReM][D]: ClusterPoolInfo method invoked
>> Thu Apr 14 13:46:28 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:46:32 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:46:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:46:58 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:47:02 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:47:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:47:28 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:47:31 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:47:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:47:50 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:47:54 2011 [ReM][D]: ClusterPoolInfo method invoked
>> Thu Apr 14 13:47:58 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:47:58 2011 [ReM][D]: VirtualNetworkPoolInfo method invoked
>> Thu Apr 14 13:48:01 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:48:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:48:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:48:04 2011 [ReM][D]: UserPoolInfo method invoked
>> Thu Apr 14 13:48:06 2011 [ReM][D]: ImagePoolInfo method invoked
>> Thu Apr 14 13:48:28 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:48:32 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:48:32 2011 [VMM][I]: --Mark--
>> Thu Apr 14 13:48:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:48:58 2011 [InM][I]: --Mark--
>> Thu Apr 14 13:48:58 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:49:02 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:49:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:49:28 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:49:32 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:49:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:49:35 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:49:50 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:49:58 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:49:58 2011 [ReM][D]: ClusterPoolInfo method invoked
>> Thu Apr 14 13:50:02 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:50:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:50:06 2011 [ReM][D]: VirtualNetworkPoolInfo method invoked
>> Thu Apr 14 13:50:14 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:50:18 2011 [ReM][D]: UserPoolInfo method invoked
>> Thu Apr 14 13:50:22 2011 [ReM][D]: ImagePoolInfo method invoked
>> Thu Apr 14 13:50:28 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:50:32 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:50:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:50:58 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:51:01 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:51:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:51:28 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:51:31 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:51:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:51:50 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:51:58 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:52:02 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:52:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:52:02 2011 [ReM][D]: ClusterPoolInfo method invoked
>> Thu Apr 14 13:52:14 2011 [ReM][D]: VirtualNetworkPoolInfo method invoked
>> Thu Apr 14 13:52:26 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:52:28 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:52:31 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:52:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:52:32 2011 [ReM][D]: UserPoolInfo method invoked
>> Thu Apr 14 13:52:38 2011 [ReM][D]: ImagePoolInfo method invoked
>> Thu Apr 14 13:52:58 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:53:02 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:53:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:53:28 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:53:32 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:53:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:53:50 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:53:58 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:54:01 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:54:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:54:06 2011 [ReM][D]: ClusterPoolInfo method invoked
>> Thu Apr 14 13:54:22 2011 [ReM][D]: VirtualNetworkPoolInfo method invoked
>> Thu Apr 14 13:54:28 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:54:31 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:54:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:54:38 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:54:46 2011 [ReM][D]: UserPoolInfo method invoked
>> Thu Apr 14 13:54:54 2011 [ReM][D]: ImagePoolInfo method invoked
>> Thu Apr 14 13:54:58 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:55:02 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:55:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:55:28 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:55:31 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:55:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:55:50 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:55:58 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:56:02 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:56:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:56:10 2011 [ReM][D]: ClusterPoolInfo method invoked
>> Thu Apr 14 13:56:28 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:56:30 2011 [ReM][D]: VirtualNetworkPoolInfo method invoked
>> Thu Apr 14 13:56:32 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:56:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:56:50 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:56:58 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:57:00 2011 [ReM][D]: UserPoolInfo method invoked
>> Thu Apr 14 13:57:02 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:57:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:57:10 2011 [ReM][D]: ImagePoolInfo method invoked
>> Thu Apr 14 13:57:28 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:57:32 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:57:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:57:50 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:57:58 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:58:01 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:58:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:58:14 2011 [ReM][D]: ClusterPoolInfo method invoked
>> Thu Apr 14 13:58:28 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:58:31 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:58:32 2011 [VMM][I]: --Mark--
>> Thu Apr 14 13:58:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:58:38 2011 [ReM][D]: VirtualNetworkPoolInfo method invoked
>> Thu Apr 14 13:58:58 2011 [InM][I]: --Mark--
>> Thu Apr 14 13:58:58 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:59:02 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:59:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:59:02 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>> Thu Apr 14 13:59:14 2011 [ReM][D]: UserPoolInfo method invoked
>> Thu Apr 14 13:59:26 2011 [ReM][D]: ImagePoolInfo method invoked
>> Thu Apr 14 13:59:28 2011 [InM][I]: Monitoring host localhost (1)
>> Thu Apr 14 13:59:32 2011 [ReM][D]: HostPoolInfo method invoked
>> Thu Apr 14 13:59:32 2011 [ReM][D]: VirtualMachinePoolInfo method invoked
>>
>>
>>
>> 2011/4/14 Carlos Martín Sánchez <cmartin at opennebula.org>
>>
>>> Hi Sebastian,
>>>
>>> Any other error messages? What about the bootstrapping section of the
>>> log?
>>> Try that sqlite3 command (assuming you have sqlite set in your oned.conf)
>>> in /var/lib/one; or $ONE_LOCATION/var if you installed it in self-contained
>>> mode. That's where you'll find the one.db file.
>>>
>>> On a side note, if you are using localhost as front-end and Host then you
>>> can use the tm_nfs drivers, since the FS is shared.
>>>
>>>
>>> Regards,
>>> Carlos.
>>>
>>> --
>>> Carlos Martín, MSc
>>> Project Major Contributor
>>> OpenNebula - The Open Source Toolkit for Cloud Computing
>>> www.OpenNebula.org <http://www.opennebula.org/> | cmartin at opennebula.org
>>>
>>>
>>> 2011/4/14 Sebastian Neg <neg.sebastian at gmail.com>
>>>
>>>> Hi,
>>>> I installed Opennebula 2.2 and it works fine.
>>>> but when i want to create a host, i get this error:
>>>>
>>>> [oneadmin at root ~]$ onehost create localhost im_kvm vmm_kvm tm_ssh
>>>> Error: [HostAllocate] Error trying to CREATE HOST Error inserting Host
>>>> in DB.
>>>>
>>>> When i try to run this command "sqlite3 one.db ".schema"", i got
>>>> nothing:
>>>> [oneadmin at root ~]$ sqlite3 one.db ".schema"
>>>> [oneadmin at root ~]$
>>>>
>>>> Note: I installed the front-end and the cluster in one machine.
>>>>
>>>>
>>>>
>>>> 2011/4/1 Carlos Martín Sánchez <cmartin at opennebula.org>
>>>>
>>>>> Hi Vivek,
>>>>>
>>>>> You are installing OpenNebula 2.0, right?
>>>>>
>>>>> Could you check if there is any error message in oned.log right after
>>>>> this message?
>>>>> [ONE][I]: Bootstraping OpenNebula database.
>>>>>
>>>>>
>>>>> It may be also helpful if you could send the output of
>>>>> $ sqlite3 one.db ".schema"
>>>>>
>>>>>
>>>>> Regards,
>>>>> Carlos
>>>>> --
>>>>> Carlos Martín, MSc
>>>>> Project Major Contributor
>>>>> OpenNebula - The Open Source Toolkit for Cloud Computing
>>>>> www.OpenNebula.org <http://www.opennebula.org/> | cmartin at opennebula
>>>>> .org
>>>>>
>>>>>
>>>>> On 31 March 2011 16:02, Vivek Shrivastava <shrivastava.vivex at gmail.com
>>>>> > wrote:
>>>>>
>>>>>>
>>>>>>
>>>>>> Hello all,
>>>>>>
>>>>>> I've installed opennebula with the help of express installation, while
>>>>>> creating node I'm getting the problem:-
>>>>>>
>>>>>>
>>>>>> oneadmin at oneadmin-desktop:~/Downloads$ onehost create node01 im_kvm
>>>>>> vmm_kvm tm_ssh
>>>>>> Error: [HostAllocate] Error trying to CREATE HOST Error inserting Host
>>>>>> Share in DB.
>>>>>>
>>>>>> (1)  I made /etc/one chmod 777, so that install.sh can run easily, is
>>>>>> this the problem?
>>>>>>
>>>>>> (2) What should I do to solve above problem?
>>>>>>
>>>>>> (3) if I want to use kvm with ssh in cluster nodes, is that necessary
>>>>>> to configure nfs (in node-install script) ?
>>>>>>
>>>>>> (4)  in oned.log I got this error:-
>>>>>>
>>>>>> SQL command was: INSERT INTO host_shares (hid,disk_usage, mem_usage,
>>>>>> cpu_usage,max_disk,   max_mem,   max_cpu,free_disk,  free_mem,
>>>>>> free_cpu,used_disk,  used_mem,  used_cpu,running_vms) VALUES
>>>>>> (0,0,0,0,0,0,0,0,0,0,0,0,0,0), error: table host_shares has no column named
>>>>>> free_disk
>>>>>>
>>>>>> What should I do?
>>>>>>
>>>>>>
>>>>>> Thanks in advance.
>>>>>> --
>>>>>> Regards,
>>>>>>
>>>>>> Vivek Shrivastava
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> Users mailing list
>>>>>> Users at lists.opennebula.org
>>>>>> http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
>>>>>>
>>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Users mailing list
>>>>> Users at lists.opennebula.org
>>>>> http://lists.opennebula.org/listinfo.cgi/users-opennebula.org
>>>>>
>>>>>
>>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opennebula.org/pipermail/users-opennebula.org/attachments/20110418/f5bd80f5/attachment-0002.htm>

More information about the Users mailing list