search for: host_id

...ll exists in the puppetmaster''s database). I fixed the problem by going in to the database and deleting all the rows I could find that related to the absent host, but I''m wondering if there''s a better way to handle this situation. FYI, the SQL commands I ran were: SET @host_id = ... DELETE FROM fact_values WHERE host_id=@host_id; DELETE FROM param_values WHERE resource_id IN ( SELECT id FROM resources WHERE host_id=@host_id ); DELETE FROM resource_tags WHERE resource_id IN ( SELECT id FROM resources WHERE host_id=@host_id ); DELETE FROM resources WHERE host_id=@h...

...orkshop being held in a specific convention. For example, Matz may host an "Introduction to Ruby" workshop in RubyConf. And _why may host a the same workshop in RailsConf. This operates through the join-model convention_workshops, which has the following rows: convention_id, workshop_id, host_id, start_time. It belongs_to :convention, :workshop, and :host. Associations make it very easy to select by one association. If I want to get the start_time of all workshops held on RubyConf Matz, I just find RubyConf''s model instance and call #convention_workshops.collect{|cw| cw.star_time...

...ls(:default).id - end - - def test_create - num_hosts = Host.count - - post :create, :host => {} - - assert_response :redirect - assert_redirected_to :controller => 'dashboard' - - assert_equal num_hosts, Host.count - end - - def test_edit - get :edit, :id => @host_id - - assert_response :redirect - assert_redirected_to :action => 'show', :id => @host_id - - assert_not_nil assigns(:host) - assert assigns(:host).valid? - end - - def test_update - post :update, :id => @host_id - assert_response :redirect - assert_redirected_...

Hello :-) How can the default omega URL be prettified? http://<host_ID>/cgi-bin/omega is working fine, giving us all omega's default CGI parameters. Now we want multiple databases which could be accessed using http://<host_ID>/cgi-bin/omega?DB=<index_ID> but this is starting to get messy. It will get messier when we start to customise templates wi...

...(-) diff --git a/src/db-omatic/db_omatic.rb b/src/db-omatic/db_omatic.rb index b3d5e73..1091333 100755 --- a/src/db-omatic/db_omatic.rb +++ b/src/db-omatic/db_omatic.rb @@ -113,6 +113,15 @@ class DbOmatic < Qpid::Qmf::Console end end + def set_vm_stopped(db_vm) + db_vm.host_id = nil + db_vm.memory_used = nil + db_vm.num_vcpus_used = nil + db_vm.needs_restart = nil + db_vm.vnc_port = nil + db_vm.state = Vm::STATE_STOPPED + end + def update_domain_state(domain, state_override = nil) vm = Vm.find(:first, :conditions =>...

Hello, When I kick off SVN1992 with storeconfigs=yes, I get the following error: err: Could not store configs: SQLite3::SQLException: SQL logic error or missing database: INSERT INTO resources ("exported", "line", "title", "host_id", "restype", "source_file_id") VALUES(NULL, 23, ''svnpkgadd-emacs-nox-etc'', NULL, NULL, NULL) The database does exist, and when I attempt to execute the SQL statement from sqlite3 I get: # sqlite3 clientconfigs.sqlite3 SQLite version 3.3.6 Enter ".he...

redux patchset permitting a vm to be associated with multiple networks and vice-versa. updated patchset so as to be applicable against current oVirt server HEAD these patches may be applied in any order, they all need to be pushed together

This patchset contains changes to the ovirt server frontend, backend, and tests components, permitting vms to be associated with multiple networks and vice versa. Also included are two patches which are required for the frontend bits; a patch adding collapsable sections to the vm form, which in itself depends on the second patch that provides default values for the cpu and memory vm table fields

...from hosts table. Affected rows: "; $result = $dbh->do(''delete from hosts where name = \''$1\''''); print "$result\n"; print "Delete from resources. Affected rows: "; $result = $dbh->do(''delete from resources where host_id not in (select id from hosts)''); print "$result\n"; print "Delete from fact_values, Affected rows: "; $result = $dbh->do(''delete from fact_values where host_id not in (select id from hosts)''); print "$result\n"; print "...

Hi Daniel, I got a question about lock manager, if I enable 'sanlock' in qemu.conf and uncomment 'auto_disk_leases = 1' in qemu-sanlock.conf then restart libvirtd service, libvirtd will be dead, I know I should also uncomment 'host_id = 1' in qemu-sanlock.conf, because I enable 'auto_disk_leases'. The question is the libvirtd must die due to a error users configuration? or could we give some warning information instead of libvirtd die? Thanks & Regards, Alex

...file was enough (and a lot simplier), as those hosts don't need to do anything but to setup a revert port forwarding rule, and are bound to a very limited shell. My (now useless) /home/host_controler/.ssh/authorized_keys file (build on a cron run) was like : command="limited_shell.sh --host_id=XXX1 $SSH_ORIGINAL_COMMAND" ssh-rsa pubkey of host 1" command="limited_shell.sh --host_id=XXX2 $SSH_ORIGINAL_COMMAND" ssh-rsa pubkey of host 2" command="limited_shell.sh --host_id=XXX3 $SSH_ORIGINAL_COMMAND" ssh-rsa pubkey of host 3" ... Thank you very muc...

...plugin: # rpm -qa | egrep "libvirt-0|sanlock-[01]" libvirt-lock-sanlock-0.9.4-23.el6_2.4.x86_64 sanlock-1.8-2.el6.x86_64 libvirt-0.9.4-23.el6_2.4.x86_64 # egrep -v "^#|^$" /etc/libvirt/qemu-sanlock.conf auto_disk_leases = 1 disk_lease_dir = "/var/lib/libvirt/sanlock" host_id = 4 # mount | grep sanlock /dev/mapper/kvm--shared-sanlock on /var/lib/libvirt/sanlock type gfs2 (rw,noatime,hostdata=jid=0) # cat /etc/sysconfig/sanlock SANLOCKOPTS="-R 1 -o 30" I increased the sanlock io_timeout to 30 seconds (default = 10), because the sanlock dir is on a GFS2 volum...

...belongs_to :network + has_many :ip_addresses, :dependent => :destroy # FIXME bondings_nics table should just be replaced with @@ -33,24 +36,31 @@ class Nic < ActiveRecord::Base validates_format_of :mac, :with => %r{^([0-9a-fA-F]{2}([:-]|$)){6}$} - validates_presence_of :host_id, - :message => 'A host must be specified.' + # nic must be assigned to network if associated w/ a vm + validates_presence_of :network_id, + :unless => Proc.new { |nic| nic.vm.nil? } + + # nic must be associated w/ a vm if assigned to a vlan + validates_presence_of :vm_id, +...

...an.id.dvag.com/ plugins: Could not intern from pson: Paths must be fully qualified err: Could not retrieve catalog from remote server: Error 400 on SERVER: PGError : ERROR: invalid byte sequence for encoding "UTF8": 0xe46973 : INSERT INTO "fact_values" ("value", "host_id", "created_at", "fact_name_id", " updated_at") VALUES (''Mitteleuropõische Zeit '', 88, ''2012-02-16 15:13:29.29309 9'', 28, ''2012-02-16 15:13:29.293099'') RETURNING "id" warning: Not using cache on fail...

Ok, I searched but couldn''t find anything and I even tried the RoR IRC channel with no help. I get this error: uninitialized constant Airport I used this code which I got from the RoR site. helper :sorting def list @sorter = SortingHelper::Sorter.new self, %w(icao host_id name), @params[''sort''], @params[''order''], ''icao'', ''ASC'' @pages = Paginator.new self, Airport.count, 10, @params[''page''] @airports = Airport.find_all nil, @sorter.to_sql, @pages.current.to_sql r...

...ample: 1) I run my test client, and its facts go into the DB: mysql> select n.name,v.* from fact_names n, fact_values v where n.id=v.fact_name_id and name = ''kernel''; +--------+----+-------+--------------+---------+---------------------+ | name | id | value | fact_name_id | host_id | updated_at | +--------+----+-------+--------------+---------+---------------------+ | kernel | 53 | Linux | 87 | 1 | 2008-01-04 10:31:14 | +--------+----+-------+--------------+---------+---------------------+ 2) Leaving puppetmasterd running, I remove this fact from the...

...d + def update_nic + alert = svc_update_nic(params[:id], params[:nic], params[:ip_address]) + render :json => { :object => "nic", :success => true, :alert => alert} + end ########################## Bonding related actions - def new_bonding - unless params[:host_id] - flash[:notice] = "Host is required." - redirect_to :controller => 'dashboard' - end - - @host = Host.find(params[:host_id]) - - # FIXME when bonding_nics table is removed, and - # bondings_id column added to nics table, simplify - # (select where bon...

...-based front end for Rails for my system integrator and developer colleagues to use to easily view and search our Puppet configs via a Rails app. I set up the SQLite storage option on the server and the puppet tables are being populated in /var/puppet/state/, but foreign keys for everything except host_id in resources are not being set. Is this expected behaviour with version 0.22.1? Makes the data in the DB much less useful without the parent child relationships :p. Using Rails 1.2.1 on the puppet master server. Regards, Max

Hi, I''m upgrading from 23.2 to the latest and have "dbmigrate = true" in my config. When I try to run puppetd, I''m getting: Could not migrate database: SQLite3::SQLException: no such table: schema_info: SELECT version FROM schema_info I''m perfectly blowing away my old db (by deleting /var/lib/puppet/ state/clientconfigs.sqlite3 ?), but I haven''t

...+id+ diff --git a/src/db-omatic/db_omatic.rb b/src/db-omatic/db_omatic.rb index b3d5e73..155ff5e 100755 --- a/src/db-omatic/db_omatic.rb +++ b/src/db-omatic/db_omatic.rb @@ -113,6 +113,15 @@ class DbOmatic < Qpid::Qmf::Console end end + def set_vm_stopped(db_vm) + db_vm.host_id = nil + db_vm.memory_used = nil + db_vm.num_vcpus_used = nil + db_vm.needs_restart = nil + db_vm.vnc_port = nil + db_vm.state = Vm::STATE_STOPPED + end + def update_domain_state(domain, state_override = nil) vm = Vm.find(:first, :conditions =>...