Re: [Users] New engine install on remote DB fails uuid-ossp extension is not loaded
On Aug 15, 2012, at 3:50 AM, Alex Lourie wrote: Hi Ian You're right in that superuser privileges are required to make this work. But it would rarely happen that remote DB admin would give you a user with super privileges. The solution we've come up with is this: 1. Use (or tell remote DB admin to do so) the psql command to load the extension functions to template1 DB on remote DB server: psql -U postgres -d template1 -f /usr/share/pgsql/contrib/uuid-ossp.sql 2. Now, all newly created databases will include extension functions. template1 is a special DB in postgres. In fact, when you create a new DB, it is actually copied from template1 with a new name. This way, we can still work with the user that has no superuser privileges in the remote DB server. Thanks for your reply. Though, to be fair, a DB admin might also object to including the uuid-ossp extension functions by default on the template DB. That said, it's certainly preferred over full superuser privs :) Cheers, Ian ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] New engine install on remote DB fails uuid-ossp extension is not loaded
On Aug 14, 2012, at 12:58 PM, Yair Zaslavsky wrote: On 08/14/2012 07:12 PM, Ian Levesque wrote: Hello, I'm trying to install oVirt 3.1, using an external postgres db running on RHEL6 (postgresql-server-8.4.12-1.el6_2.x86_64). I'm getting the following error during engine-setup: Error: uuid-ossp extension is not loaded into the DB. Verify with the DB admin that uuid-ossp extension is loaded into newly created databases and rerun the setup. The database log indicates: ERROR: function uuid_generate_v1() does not exist at character 8 HINT: No function matches the given name and argument types. You might need to add explicit type casts. STATEMENT: SELECT uuid_generate_v1(); I did some searching, and it appeared that I might need to add some postgres-contrib functions: psql -U postgres -d engine -f /usr/share/pgsql/contrib/uuid-ossp.sql Unfortunately, it appears that the install script wants to create a temporary database and expects these functions to exist on its newly-created temp DB, not an already-existing database. Indeed this step is required for postgresql 8.4.x (you have to install this script). I did not encounter an issue with this script. I ran psql -U postgres -d engine -f /usr/share/pgsql/contrib/uuid-ossp.sql And the script execution went smoothly (this scripts runs instructions of create or replace function so it is re-entrant). Can you please elaborate more on the error you're getting? Here's what the install log tells me: 2012-08-14 11:56:12::INFO::engine_validators::425::root:: Successfully created temp database on server cmcd-web. 2012-08-14 11:56:12::INFO::engine_validators::443::root:: Checking that uuid extension is loaded by default on the remote server 2012-08-14 11:56:12::DEBUG::common_utils::350::root:: running sql query 'SELECT uuid_generate_v1();' on db server: 'cmcd-web'. 2012-08-14 11:56:12::DEBUG::common_utils::286::root:: cmd = /usr/bin/psql -h cmcd-web -p 5432 -U ovirt -d ovirt_engine_test -c SELECT uuid_generate_v1(); 2012-08-14 11:56:12::DEBUG::common_utils::291::root:: output = 2012-08-14 11:56:12::DEBUG::common_utils::292::root:: stderr = ERROR: function uuid_generate_v1() does not exist So, the installer is trying to create a database ovirt_engine_test and succeeding. But until you run `psql -U postgres -d database_name -f /usr/share/pgsql/contrib/uuid-ossp.sql`, the function uuid_generate_v1() won't be available. Therefore, the temporary database the installer is using to determine compatibility fails. Ian ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
[Users] Virtual disk locked and I can't start/alter the VM
Hi, I tried to export a VM image, and it apparently succeeded: 2012-Aug-06, 17:00:25 Vm varanus was exported successfully to glusternfs-export But now the VM Virtual Disk is labeled as locked and I can't start or even remove and re-import the VM. Any clues how this can be resolved? Running ovirt-engine-3.1.0-3.11.el6.noarch Thanks! Ian ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] Import pre-configured storage domain
On Jul 18, 2012, at 3:38 PM, Rami Vaknin wrote: What's the procedure for importing a previously-conifgured NFS storage domain? I reinstalled the ovirt-engine recently and wondered what the process is for keeping my preexisting VMs. Do you mean to NFS-based ISO/Export storage domain or NFS Data domain? NFS Data domain can not be imported, only ISO/Export domains can, and if the later is the case - you probably have chosen ISO instead of Export in the UI's drop-down list or vice versa. Sorry I wasn't clear - I'm trying to import a data domain, where all one's VMs are stored. It just occurred to me that the Import Domain only gives me the option to import an Export domain. I'm not sure what an Export domain's purpose is, but it's not the default location of VMs. So… is there really no way to re-introduce one's preconfigured VMs to a new ovirt install? Best regards, Ian ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] Can't add an NFS storage domain
On Jun 13, 2012, at 1:41 AM, Yair Zaslavsky wrote: On 06/13/2012 07:41 AM, Haim Ateya wrote: TypeError: %d format: a number is required, not str Hi Ian, You seem to run into a bug in our advanced NFS options capability. in order to workaround this issue, please use 'Auto Negotiate' option for now, that shall work. you can track this issue in: https://bugzilla.redhat.com/show_bug.cgi?id=831469 Thanks, Haim I would like to add on Haim's words , that the fix for this bug was already merged up stream, if you have the ability to compile oVirt on your own , you can have the fix right now. Hi Haim, Yair - I patched storageServer.py using the diff referenced in the commit; it solved this problem. Thanks! Ian ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
[Users] Can't add an NFS storage domain
Hi, I just did a clean install of ovirt version 3.1 on CentOS 6.2 (dreyou build @ http://www.dreyou.org/ovirt/). When I attempt to add storage (Data/NFS), the web GUI hangs and the storage is not added. The engine log reports: Class Name: org.ovirt.engine.core.vdsbroker.vdsbroker.ServerConnectionStatusReturnForXmlRpc mStatusList Null mStatus Class Name: org.ovirt.engine.core.vdsbroker.vdsbroker.StatusForXmlRpc mCode 451 mMessage Error storage server connection: (domType=1, spUUID=----, conList=[{'port': '', 'connection': 'cmcd-db-vip.in.hwlab:/vmstore', 'iqn': '', 'portal': '', 'user': '', 'protocol_version': '3', 'password': '**', 'id': '500d06d3-00f7-4d8f-b42b-eabd6a394be7'}],) The vdsm.log on the host I'm using (also CentOS 6.2, vdsm-4.9.6-0.274.git937a4b7) says: Thread-3810::ERROR::2012-06-12 14:58:19,879::task::853::TaskManager.Task::(_setError) Task=`c514ffd1-2777-44ae-9b77-06a9fb51f41e`::Unexpected error Traceback (most recent call last): File /usr/share/vdsm/storage/task.py, line 861, in _run return fn(*args, **kargs) File /usr/share/vdsm/logUtils.py, line 38, in wrapper res = f(*args, **kwargs) File /usr/share/vdsm/storage/hsm.py, line 1926, in connectStorageServer conObj = storageServer.ConnectionFactory.createConnection(conInfo) File /usr/share/vdsm/storage/storageServer.py, line 533, in createConnection return ctor(**params) File /usr/share/vdsm/storage/storageServer.py, line 244, in __init__ options.append(vers=%d % version) TypeError: %d format: a number is required, not str More context is available here: http://d.pr/n/dA5K+ Thanks for any insight. Ian ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] Default storage pool won't activate after reboot
On May 11, 2012, at 3:09 PM, Ian Levesque wrote: On May 9, 2012, at 4:02 PM, Haim Ateya wrote: - please access your NFS storage - change dir to export directory - /vmstore/ovirt - cat the following e12a0f53-ee72-44bc-ad26-93f9b4613c6c/dom_md/metadata CLASS=Data DESCRIPTION=glusternfs IOOPTIMEOUTSEC=10 LEASERETRIES=3 LEASETIMESEC=60 LOCKPOLICY= LOCKRENEWALINTERVALSEC=5 MASTER_VERSION=1 POOL_DESCRIPTION=Default POOL_DOMAINS=82503778-db5d-4ad3-a863-b5484b2a08a1:Active,e12a0f53-ee72-44bc-ad26-93f9b4613c6c:Active POOL_SPM_ID=3 POOL_SPM_LVER=5 POOL_UUID=af5bcc86-898a-11e1-9632-003048c85226 REMOTE_PATH=cmcd-db-vip.in.hwlab:/vmstore/ovirt ROLE=Master SDUUID=e12a0f53-ee72-44bc-ad26-93f9b4613c6c TYPE=NFS VERSION=0 _SHA_CKSUM=c193c6426fd840770124c2b1db81c6138337f2ef the params sent by the manager connecting host to pool fits to what written in metadata, hence, normally, vdsm shouldn't fail. however, could please run the following: - mount command (on host) - if 'cmcd-db-vip.in.hwlab:/vmstore/ovirt' exists, umount it. - restart vdsmd service - try active pool again (from manager) just want to make sure there is no caching issue. please attach logs (vdsm only) after you perform the above. I'm not even seeing the storage domain being passed to the node. I assume this is because the storage domain is inactive but I can't seem to figure out why, or what I need to do to reactivate it. The log (vdsm_log.txt) is attached, but it contains no mention of the storage domain. Also attached (vdsm_log_ref.txt) is a snippet of log that includes /rhev/data-center/mnt/cmcd-db-vip.in.hwlab:_vmstore_ovirt in the mount list. Is there any further troubleshooting I can do before giving up on this? Thanks, Ian ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] Default storage pool won't activate after reboot
On May 9, 2012, at 8:54 PM, Shu Ming wrote: the params sent by the manager connecting host to pool fits to what written in metadata, hence, normally, vdsm shouldn't fail. however, could please run the following: - mount command (on host) - if 'cmcd-db-vip.in.hwlab:/vmstore/ovirt' exists, umount it. - restart vdsmd service - try active pool again (from manager) just want to make sure there is no caching issue. please attach logs (vdsm only) after you perform the above. Also, I would like to know the rw attribute of cmcd-db-vip.in.hwlab:/vmstore/ovirt The node isn't mounting this NFS export at all. Prior to this issue, it was being mounted read-write and I was successfully running a test VM. Best, Ian ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
[Users] Default storage pool won't activate after reboot
Hello, Since a recent reboot, my default data storage pool has been inactive and attempts to activate it fail. Installed RPMs: vdsm-4.9.6-0.150.git63061a9.el6.x86_64 ovirt-engine-3.1.0_0001-1.8.el6.x86_64 Relevant-looking output in the vdsm.log file (more @ http://pastebin.com/raw.php?i=cYaFLPEF): Thread-68465::ERROR::2012-05-09 14:05:00,491::task::853::TaskManager.Task::(_setError) Task=`937d1fa9-4636-42f1-a6cb-c4cc56b9f2fd`::Unexpected error Traceback (most recent call last): File /usr/share/vdsm/storage/task.py, line 861, in _run return fn(*args, **kargs) File /usr/share/vdsm/logUtils.py, line 38, in wrapper res = f(*args, **kwargs) File /usr/share/vdsm/storage/hsm.py, line 526, in getSpmStatus pool = self.getPool(spUUID) File /usr/share/vdsm/storage/hsm.py, line 263, in getPool raise se.StoragePoolUnknown(spUUID) StoragePoolUnknown: Unknown pool id, pool not connected: ('af5bcc86-898a-11e1-9632-003048c85226',) Thread-68465::DEBUG::2012-05-09 14:05:00,491::task::872::TaskManager.Task::(_run) Task=`937d1fa9-4636-42f1-a6cb-c4cc56b9f2fd`::Task._run: 937d1fa9-4636-42f1-a6cb-c4cc56b9f2fd ('af5bcc86-898a-11e1-9632-003048c85226',) {} failed - stopping task The share /is/ mounted on the node: # mount | grep cmcd-db-vip cmcd-db-vip.in.hwlab:/vmstore/ovirt on /rhev/data-center/mnt/cmcd-db-vip.in.hwlab:_vmstore_ovirt type nfs (rw,soft,nosharecache,timeo=600,retrans=6,nfsvers=3,addr=10.0.10.13) # ls -l /rhev/data-center/mnt/cmcd-db-vip.in.hwlab:_vmstore_ovirt/ total 0 drwxr-xr-x 5 vdsm kvm 45 Apr 13 12:23 4ddb9dce-1ede-459a-9b9f-52b035622517 drwxr-xr-x 5 vdsm kvm 45 Apr 12 16:17 4ea29e75-ab27-4bc9-bc46-1740d07f4cba drwxr-xr-x 5 vdsm kvm 45 Apr 19 11:40 e12a0f53-ee72-44bc-ad26-93f9b4613c6c The closest google turns up is a thread from March, in which there was some mention of a change in the way metadata is read. Might be a red herring, but here's that thread: http://lists.ovirt.org/pipermail/users/2012-March/001423.html Thanks for any insight! Ian ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] Default storage pool won't activate after reboot
On May 9, 2012, at 2:40 PM, Jacob Wyatt wrote: StoragePoolUnknown: Unknown pool id, pool not connected: ('af5bcc86-898a-11e1-9632-003048c85226',) I'm new to oVirt myself but I thought that the top level directory name was the UUID of the storage pool. In that case the UUID it lists (af5bcc86-898a-11e1-9632-003048c85226) isn't there. Have you looked directly on the storage machine itself? Perhaps the node can't see that directory due to permission issues? Hi Jacob - thanks for the response. The thought crossed my mind as well but I'm not sure if that UUID should indeed directly correspond to a directory. I haven't poked around the storage pools before. If that's the case, I do wonder what happened to my pool, and also what those other directories are... Best, Ian ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] Default storage pool won't activate after reboot
On May 9, 2012, at 2:59 PM, Haim Ateya wrote: Hi Ian, would it be possible for you to attach both ovirt-engine (manager) vdsm logs (host) so can investigate further? Sure -- you can download a zip of both logs here: http://cl.ly/1h3u322S3f1Y1W0p1T3E/logs.zip Thanks, Ian ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] Default storage pool won't activate after reboot
On May 9, 2012, at 3:34 PM, Haim Ateya wrote: what kind of storage are you using ? NFS or local-domain ? NFS (gluster in the backend). This worked fine until the recent reboot. - please access your NFS storage - change dir to export directory - /vmstore/ovirt - cat the following e12a0f53-ee72-44bc-ad26-93f9b4613c6c/dom_md/metadata CLASS=Data DESCRIPTION=glusternfs IOOPTIMEOUTSEC=10 LEASERETRIES=3 LEASETIMESEC=60 LOCKPOLICY= LOCKRENEWALINTERVALSEC=5 MASTER_VERSION=1 POOL_DESCRIPTION=Default POOL_DOMAINS=82503778-db5d-4ad3-a863-b5484b2a08a1:Active,e12a0f53-ee72-44bc-ad26-93f9b4613c6c:Active POOL_SPM_ID=3 POOL_SPM_LVER=5 POOL_UUID=af5bcc86-898a-11e1-9632-003048c85226 REMOTE_PATH=cmcd-db-vip.in.hwlab:/vmstore/ovirt ROLE=Master SDUUID=e12a0f53-ee72-44bc-ad26-93f9b4613c6c TYPE=NFS VERSION=0 _SHA_CKSUM=c193c6426fd840770124c2b1db81c6138337f2ef Best, Ian ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] high availability via fencing
So, what I see is that port was sent twice , once as empty and then the port=22 is sent as part of the options string. Can you please remove the port from the options field and put it in the port field. If this works , this is an engine core bug... I believe that it is such a bug, since the options field come up as empty in vdsm. I tried entering a Port, Slot and plug=1 in options. I also checked Secure. It indeed appears that the engine isn't passing the options along. I also find it odd that a required field (plug) isn't available via a form field. Is that just a side effect? I can file a bug -- does it belong in ovirt-engine-core? Here's the vdsm and engine log output when I click Test: == ../ovirt-engine/engine.log == 2012-04-25 12:18:50,302 INFO [org.ovirt.engine.core.bll.FencingExecutor] (http--0.0.0.0-8443-4) Executing Status Power Management command, Proxy Host:heilig, Agent:apc, Target Host:, Management IP:134.174.x.x, User:ovirt, Options:port=22,plug=1,secure=true,slot=1 2012-04-25 12:18:50,305 INFO [org.ovirt.engine.core.vdsbroker.vdsbroker.FenceVdsVDSCommand] (http--0.0.0.0-8443-4) START, FenceVdsVDSCommand(vdsId = 6de5e3fa-8a33-11e1-b3f9-003048c85226, targetVdsId = 60087c5e-8a3b-11e1-b15d-003048c85226, action = Status, ip = 134.174.x.x, port = , type = apc, user = ovirt, password = **, options = 'port=22,plug=1,secure=true,slot=1'), log id: 56a240f9 == vdsm.log == Thread-52872::DEBUG::2012-04-25 12:18:50,311::API::954::vds::(fenceNode) fenceNode(addr=134.174.x.x,port=,agent=apc,user=ovirt,passwd=,action=status,secure=,options=) Thread-52872::DEBUG::2012-04-25 12:18:50,348::API::980::vds::(fenceNode) rc 1 in agent=fence_apc ipaddr=134.174.x.x login=ovirt option=status passwd= out err Failed: You have to enter plug number Please use '-h' for usage Thread-52873::DEBUG::2012-04-25 12:18:50,356::API::954::vds::(fenceNode) fenceNode(addr=134.174.x.x,port=,agent=apc,user=ovirt,passwd=,action=status,secure=,options=) Thread-52873::DEBUG::2012-04-25 12:18:50,392::API::980::vds::(fenceNode) rc 1 in agent=fence_apc ipaddr=134.174.x.x login=ovirt option=status passwd= out err Failed: You have to enter plug number Please use '-h' for usage Thanks, Ian ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [Users] high availability via fencing
2012-04-20 11:32:44,696 INFO [org.ovirt.engine.core.vdsbroker.vdsbroker.FenceVdsVDSCommand] (http--0.0.0.0-8443-5) FINISH, FenceVdsVDSCommand, return: Test Failed, Host Status is: unknown. The fence-agent script reported the following error: Failed: You have to enter plug number Please use '-h' for usage I've tried to add port=1 to the Options field but that seems to have no effect. Any ideas? Is there any way to configure a dumb power management / fencing configuration for testing? If you still have the problem, can you please put also the vdsm log (look for fenceNode ) Thanks Hi Eli, Here is the relevant output, though I don't think it'll be much more help: Thread-1818::DEBUG::2012-04-24 12:17:59,804::API::954::vds::(fenceNode) fenceNode(addr=134.174.x.x,port=,agent=apc,user=ovirt,passwd=,action=status,secure=,options=) Thread-1818::DEBUG::2012-04-24 12:17:59,841::API::980::vds::(fenceNode) rc 1 in agent=fence_apc ipaddr=134.174.x.x login=ovirt option=status passwd= out err Failed: You have to enter plug number Please use '-h' for usage Thanks, Ian ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
[Users] high availability via fencing
Hello, I'm testing ovirt for potential deployment and one of the metrics for its success relies on the high availability feature. In my research on this feature, I found scattered documentation indicating that fencing is a prerequisite. On my test hardware, I don't have any LOM/IPMI but I see that APC managed PDUs are supported, which I do have. The problem is when I try to configure Power Management to use the apc type, I get this error: Test Failed, Host Status is: unknown. The fence-agent script reported the following error: Failed: You have to enter plug number Please use '-h' for usage ovirt-engine/engine.log tells me: 2012-04-20 11:32:44,595 INFO [org.ovirt.engine.core.bll.FencingExecutor] (http--0.0.0.0-8443-5) Executing Status Power Management command, Proxy Host:heilig, Agent:apc, Target Host:, Management IP:134.174.x.x, User:ovirt, Options:port=22,secure=true,slot=1 2012-04-20 11:32:44,598 INFO [org.ovirt.engine.core.vdsbroker.vdsbroker.FenceVdsVDSCommand] (http--0.0.0.0-8443-5) START, FenceVdsVDSCommand(vdsId = 6de5e3fa-8a33-11e1-b3f9-003048c85226, targetVdsId = 60087c5e-8a3b-11e1-b15d-003048c85226, action = Status, ip = 134.174.x.x, port = , type = apc, user = ovirt, password = **, options = 'port=22,secure=true,slot=1'), log id: 57f86a56 2012-04-20 11:32:44,696 INFO [org.ovirt.engine.core.vdsbroker.vdsbroker.FenceVdsVDSCommand] (http--0.0.0.0-8443-5) FINISH, FenceVdsVDSCommand, return: Test Failed, Host Status is: unknown. The fence-agent script reported the following error: Failed: You have to enter plug number Please use '-h' for usage I've tried to add port=1 to the Options field but that seems to have no effect. Any ideas? Is there any way to configure a dumb power management / fencing configuration for testing? Cheers, Ian ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
[Users] ovirt-node trying to use NFS4
Hi, I'm in the early stages of testing an ovirt install, using the official ovirt engine packages + F16. I configured a storage domain to connect to our gluster storage via NFS (pity we can't use gluster natively yet). On the engine server, I added Nfsvers=3 to /etc/nfsmount.conf as instructed here: http://www.ovirt.org/wiki/Troubleshooting_NFS_Storage_Issues I then installed a host via ovirt-node (2.3.0-1) and successfully added the host, but it refuses to connect to our storage domain because it's attempting to mount via NFS4. When I add Nfsvers=3 to /etc/nfsmount.conf on the host, it comes to life. Of course, that will be reset after a reboot. So what are my options here, other than not use ovirt-node? AFAIK, gluster doesn't export NFS4, let alone have options to disable it. And I don't see any way to add nfs mount options when defining a storage domain... Thanks for any pointers, Ian ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users