<DIV>Hi,</DIV>
<DIV>The output of execute command, as flollows:</DIV>
<DIV> </DIV>
<DIV>[oneadmin@vm-master~]$ sqlite3 /opt/nebula/ONE_2.2/var/one.db<BR>SQLite version 3.5.9<BR>Enter ".help" for instructions<BR>sqlite> .tables<BR>backup history image_pool user_pool <BR>backupdisk host_pool leases vm_pool <BR>cluster_pool host_shares network_pool<BR>sqlite> select * from user_pool where oid=0;<BR>0|oneadmin|7bc8559a8fe509e680562b85c337f170956fcb06|1<BR>sqlite> .schema<BR>CREATE TABLE backup (oid INTEGER,vid INTEGER,bk_dir TEXT,state INTEGER,stime INTEGER,etime INTEGER,PRIMARY KEY(oid));<BR>CREATE TABLE backupdisk (oid INTEGER,vid INTEGER,dk_name TEXT,dk_dir TEXT,state INTEGER,PRIMARY KEY(oid));<BR>CREATE TABLE cluster_pool (oid INTEGER PRIMARY KEY, cluster_name VARCHAR(128), UNIQUE(cluster_name) );<BR>CREATE TABLE history (vid INTEGER,seq INTEGER,host_name TEXT,vm_dir TEXT,hid INTEGER,vm_mad TEXT,tm_mad TEXT,stime INTEGER,etime INTEGER,pstime INTEGER,petime INTEGER,rstime INTEGER,retime INTEGER,estime INTEGER,eetime INTEGER,reason INTEGER,PRIMARY KEY(vid,seq));<BR>CREATE TABLE host_pool (oid INTEGER PRIMARY KEY,host_name VARCHAR(256), state INTEGER,im_mad VARCHAR(128),vm_mad VARCHAR(128),tm_mad VARCHAR(128),last_mon_time INTEGER, cluster VARCHAR(128), template TEXT, UNIQUE(host_name));<BR>CREATE TABLE host_shares(hid INTEGER PRIMARY KEY,disk_usage INTEGER, mem_usage INTEGER, cpu_usage INTEGER,max_disk INTEGER, max_mem INTEGER, max_cpu INTEGER,free_disk INTEGER, free_mem INTEGER, free_cpu INTEGER,used_disk INTEGER, used_mem INTEGER, used_cpu INTEGER,running_vms INTEGER);<BR>CREATE TABLE image_pool (oid INTEGER PRIMARY KEY, uid INTEGER, name VARCHAR(128), type INTEGER, public INTEGER, persistent INTEGER, regtime INTEGER, source TEXT, state INTEGER, running_vms INTEGER, template TEXT, UNIQUE(name) );<BR>CREATE TABLE leases (oid INTEGER, ip BIGINT, mac_prefix BIGINT, mac_suffix BIGINT,vid INTEGER, used INTEGER, PRIMARY KEY(oid,ip));<BR>CREATE TABLE network_pool (oid INTEGER PRIMARY KEY, uid INTEGER, name VARCHAR(256), type INTEGER, bridge TEXT, public INTEGER, template TEXT, UNIQUE(name));<BR>CREATE TABLE user_pool (oid INTEGER PRIMARY KEY, user_name VARCHAR(256), password TEXT,enabled INTEGER, UNIQUE(user_name));<BR>CREATE TABLE vm_pool (oid INTEGER PRIMARY KEY,uid INTEGER,name TEXT,last_poll INTEGER, state INTEGER,lcm_state INTEGER,stime INTEGER,etime INTEGER,deploy_id TEXT,memory INTEGER,cpu INTEGER,net_tx INTEGER,net_rx INTEGER, last_seq INTEGER, template TEXT);<BR>sqlite> </DIV>
<DIV><includetail>
<DIV><BR></DIV>
<DIV><BR></DIV>
<DIV style="PADDING-BOTTOM: 2px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; FONT-FAMILY: Arial Narrow; FONT-SIZE: 12px; PADDING-TOP: 2px">------------------ 原始邮件 ------------------</DIV>
<DIV style="PADDING-BOTTOM: 8px; PADDING-LEFT: 8px; PADDING-RIGHT: 8px; BACKGROUND: #efefef; FONT-SIZE: 12px; PADDING-TOP: 8px">
<DIV><B>发件人:</B> "Carlos Martín Sánch"<cmartin@opennebula.org>;</DIV>
<DIV><B>发送时间:</B> 2012年7月23日(星期一) 晚上6:17</DIV>
<DIV><B>收件人:</B> "David"<david1228@foxmail.com>; <WBR></DIV>
<DIV><B>抄送:</B> "users"<users@lists.opennebula.org>; <WBR></DIV>
<DIV><B>主题:</B> Re: [one-users] problem with upgrading OpenNebula DB</DIV></DIV>
<DIV><BR></DIV>Hi,
<DIV><BR></DIV>
<DIV>Can you please paste the output of 'sqlite3 <SPAN style="BACKGROUND-COLOR: rgb(255,255,255); FONT-FAMILY: arial, sans-serif; COLOR: rgb(34,34,34); FONT-SIZE: 13px">/opt/nebula/ONE_2.2/var/one.db ".schema"' ?</SPAN></DIV>
<DIV><FONT color=#222222 face="arial, sans-serif"><BR></FONT></DIV>
<DIV><FONT color=#222222 face="arial, sans-serif">Regards</FONT></DIV>
<DIV>--<BR>Carlos Martín, MSc<BR>Project Engineer<BR>OpenNebula - The Open-source Solution for Data Center Virtualization
<DIV><SPAN style="BORDER-COLLAPSE: collapse; FONT-FAMILY: arial, sans-serif; COLOR: rgb(136,136,136); FONT-SIZE: 13px"><A href="http://www.opennebula.org/" target=_blank>www.OpenNebula.org</A> | <A href="mailto:cmartin@opennebula.org" target=_blank>cmartin@opennebula.org</A> | <A href="http://twitter.com/opennebula" target=_blank>@OpenNebula</A></SPAN><SPAN style="BORDER-COLLAPSE: collapse; FONT-FAMILY: arial, sans-serif; COLOR: rgb(136,136,136); FONT-SIZE: 13px"><A style="COLOR: rgb(42,93,176)" href="mailto:cmartin@opennebula.org" target=_blank></A></SPAN></DIV><BR><BR><BR>
<DIV class=gmail_quote>On Mon, Jul 23, 2012 at 11:48 AM, David <SPAN dir=ltr><<A href="mailto:david1228@foxmail.com" target=_blank>david1228@foxmail.com</A>></SPAN> wrote:<BR>
<BLOCKQUOTE style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class=gmail_quote>
<DIV>
<DIV>
<P>Hi,</P>
<P>While upgrading openNebula2.2(sqlite DB) to 3.2.1(mysql DB) ：</P>
<P>$ onedb upgrade -v --sqlite /opt/nebula/ONE_2.2/var/one.db</P>
<P>I found a fault:"Database schema does not look to be created by OpenNebula: table user_pool is missing or empty."can you tell me how to solve it? thank you!</P>
<P>gem -v: 1.8.10</P>
<P>ruby -v : ruby 1.9.2p290 (2011-07-09 revision 32553) [x86_64-linux] </P>
<P>Regards！</P></DIV></DIV><BR>_______________________________________________<BR>Users mailing list<BR><A href="mailto:Users@lists.opennebula.org">Users@lists.opennebula.org</A><BR><A href="http://lists.opennebula.org/listinfo.cgi/users-opennebula.org" target=_blank>http://lists.opennebula.org/listinfo.cgi/users-opennebula.org</A><BR><BR></BLOCKQUOTE></DIV><BR></DIV>
<DIV></DIV></includetail></DIV>