search for: fact_value

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...

...#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...

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...

...;'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...

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...

...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 "...

...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...

...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...

...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...

...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...

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

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

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,

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

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