search for: fact_value

Displaying 15 results from an estimated 15 matches for "fact_value".

Did you mean: face_value
2007 Jul 18
1
fact_values of puppetmaster database
Hi all, we had notified that table ''fact_values'' of puppetmaster database is not updating when a fact value changes (for example we have updated some puppet clients version to 0.23 and fact_value of database is still the old version 0.22.4) it is a bug? misconfiguration? we are using ''storeconfigs = true'' with MySQL...
2008 Feb 11
9
Storeconfigs purge Perl
...#39;'$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 "Delete from param_values, Affected rows: "; $result = $dbh->do(''delete from param_values whe...
2008 Oct 04
1
Error in INSERT when using stored configs
Hello, I''m having some trouble getting stored configs to work properly with SQLite. During each run, the puppet master is reporting the following error: err: Could not store configs: SQLite3::SQLException: fact_values.value may not be NULL: INSERT INTO fact_values ("updated_at",3 18:41:56'', NULL, 3, 18) I''m using Puppet 0.24.4 with Rails 1.2.6 and SQLite 3.3.6. Can anybody point me in the right direction here? Thanks.k --~--~---------~--~----~------------~-------~--~----~ You rec...
2008 Jan 04
3
Facts not being updated when using storeconfigs
...;'ve got it working to the point where my clients'' facts are being populated in the database[*] but updates don''t seem to happen unless I restart puppetmasterd. For example: 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 | Li...
2007 Dec 18
5
resource collection error
I''m seeing these in my logs on my puppetmaster: puppetmasterd[4111]: Could not store configs: SQLite3::SQLException: SQL logic error or missing database: DELETE FROM fact_values WHERE "id" = 8 currently this is 0.24.0 relect from some previously collected resource that wasn''t cleaned up? upgrade issue? nothing to worry about? that''s the only message I''m getting and storeconfigs seem to be working otherwise. -- stickm@gmail.co...
2012 Feb 16
5
Puppet on Windows
...ot retrieve file metadata for puppet://foreman.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 "...
2008 Jul 09
1
Deleting an exported resource
...er''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=@host_id; DELETE FROM hosts WHE...
2012 Jul 20
2
Lookup another node's hiera data - fqdn hierarchy
...automatically configure the backup server to grab those locations. This attempt may work, but it doesn''t ''feel'' right to me by overriding the fqdn fact. /etc/puppet/modules/test $ cat manifests/hiera_lookup.pp class test::hiera_lookup { $nodes = foreman(''fact_values'', ''fact = fqdn'') if $nodes { create_resources(''test::hiera_lookup::get_data'', $nodes) } } define test::hiera_lookup::get_data ( $fqdn ) { $data = hiera("backuppc_db_dumps", false) if $data { notify { $data: } } } Is there a...
2009 Dec 08
5
Cleaning Out Stored Configs
...to do when nodes go away, or change considerably. If we get rid of a server then all it''s stored config is still present in the database, as well as it''s nagios and munin configurations. We created a script that iterates through the database deleting associated lines from hosts/fact_values/resources/resource_tags/param_values tables cleaning out information for old hosts, but then doing a puppet run on say our Munin or Nagios doesn''t seem to fix things, Puppet doesn''t seem to notice that the extra Nagios or virtual configurations we''re using for Munin have...
2010 Aug 02
1
wrong facts going into storeconfigs, 0.25+2.6
...9;'m re-posting this because I''m not sure that it got through the first time. If someone could at least echo back that this is reaching the list, I''d appreciate it. (I''m new to the list.) Sometimes (with variable frequency) storeconfigs stores the wrong data in the fact_values table. This has the end result that exported resources, when collected, have invalid configuration. The most recent example: the "hostname" fact for one of our nodes got, in stead, the value that should have gone in the "processorcount" fact. The had the end result that the...
2007 Feb 08
16
exported ressources
Hello, i wanted to know if we can use exported ressrouces to do things like this: - for all nodes tagged as xxx create on the node yyy a file which content is a template where we can have each hostname , or create one file per nodes matching exemple /etc/hosts.allow sshd: host1 sshd: host2 ... or /etc/backuppc/host1 /etc/backuppc/host2 ... from the docs it seems i can collect only ALL
2008 Mar 29
10
create new clientconfigs database
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
2008 Feb 15
17
centralized or decentralized puppet infrastructure
Hi All, In my companies environment, we have multiple sites in multiple geographic locations, sometimes with high latency between the sites. I''m trying to come up with a solution that could provide puppet infrastructure to all sites nodes. ----a few assumptions--- - puppet manifest / configuration is fetched from a centralized version control system. - store db is needed (ssh keys,
2012 Jun 04
15
mysql or postgresql
Hi! Which database would you recommend to use mysql or postgresql for puppet? Estimated number of nodes 30000, they send reports every 30 minutes. Thanks -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to
2011 Sep 21
11
Software inventory
Howdy, Before I go about writing one myself, anyone out there written a software inventory module/fact for gathering a list of all installed rpms/debs on a system? Got a few ideas floating around in my head, but wanted to see if/what other folks have done .. -- I''ve seen things you people wouldn''t believe. Attack ships on fire off the shoulder of Orion. I watched C-beams