Hey, I''m trying to use the simple ssh known host example in the puppet wiki to get exported resources working...but somehow it fails. I''d say my problem is similar to this one: http://groups.google.com/group/puppet-users/browse_thread/thread/ec35aa873f81b759/0ac29daa7aacd86c?lnk=gst&q=exported+resources#0ac29daa7aacd86c But that one was nearly one year ago and seemed to be fixed... I''m using Version 0.25.4 on OpenSuse 11.1 and I run into the same problems...I have entries in "fact_names". "fact_values" and "hosts" but the other tables like "resources" are empty. Puppetmasterd reports: debug: Scope(Class[allgemein::knownhost]): Collected 1 Sshkey resource in 0.00 seconds debug: Scope(Class[allgemein::knownhost]): Collected 0 Sshkey resources in 0.00 seconds debug: Scope(Class[allgemein::knownhost]): Collected 0 Sshkey resources in 0.00 seconds I followed step by step the manual to configure stored configs, etc... I use mysql as database and this are the packages I installed via repository: libmysqlclient_r15-5.0.67-12.16.1 libmysqlclient15-5.0.67-12.16.1 mysql-client-5.0.67-12.16.1 mysql-5.0.67-12.16.1 ruby-mysql-2.7.4-1.101 I''m rather new to puppet so I can''t tell that in previous versions exported resources worked for me. When i ran puppetmaster in debug mode I also saw this warning: "This method is deprecated and will be removed on the next release. Use ''publish'' instead" But I can''t tell where that comes from...Maybe the message shows up because I''m using the ssh::auth module? I appreciate any help christian -- 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 puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
christian
2010-Mar-26 09:57 UTC
[Puppet Users] Re: Exported resources doesn''t seem to work
After giving this some rest, today i started the puppetqd daemon in
debug mode and it with every puppetrun i get this messages:
info: Connecting to mysql database: puppet
err: Could not save queued catalog for keto-
puppetweb.backyard.wlwonline.de: Access denied for user
''puppet''@''localhost'' (using password: YES)
notice: Processing queued catalog for keto-
puppetweb.backyard.wlwonline.de in 0.00 seconds
info: Loaded queued catalog in 0.07 seconds
So this seems to be a permission problem and not a bug...
But I can''t really figure out why access is denied.
I granted all privileges on the puppet db with: grant all privileges
on puppet.* to puppet@localhost identified by ''password'';
When I log into the database with mysql -u puppet -p there are no
permission problems. In mysql.db I can see that user puppet has all
privileges except grant on the db puppet...
During a puppetrun the mysql query log shows this:
100326 10:47:53 19 Connect puppet@localhost on puppet
19 Query SET SQL_AUTO_IS_NULL=0
19 Statistics
19 Query SELECT * FROM `hosts` WHERE
(`hosts`.`name` = ''keto-puppetdns.backyard.wlwonline.de'')
LIMIT 1
19 Query SELECT * FROM `fact_values` WHERE
(`fact_values`.host_id = 1)
-- snip -- more SELECT and INSERT INTO
`fact_values` follow
19 Query SELECT * FROM `hosts` WHERE
(`hosts`.`name` = ''keto-puppetdns.backyard.wlwonline.de'')
LIMIT 1
19 Query SELECT * FROM `resources` WHERE
(host_id != 1 AND (exported=1 AND restype=''Sshkey''))
19 Query SELECT * FROM `hosts` WHERE
(`hosts`.`name` = ''keto-puppetdns.backyard.wlwonline.de'')
LIMIT 1
19 Query SELECT * FROM `resources` WHERE
(host_id != 1 AND (exported=1 AND restype=''Sshkey''))
19 Query SELECT * FROM `hosts` WHERE
(`hosts`.`name` = ''keto-puppetdns.backyard.wlwonline.de'')
LIMIT 1
19 Query SELECT * FROM `resources` WHERE
(host_id != 1 AND (exported=1 AND restype=''Sshkey''))
20 Connect Access denied for user
''puppet''@''localhost'' (using password: YES)
Does someone see the possible mistake on my side?
Thanks in advance,
christian
On 23 Mrz., 14:04, christian <christ...@cust.in>
wrote:> Hey,
>
> I''m trying to use the simple ssh known host example in the puppet
wiki
> to getexportedresources working...but somehow it fails.
> I''d say my problem is similar to this
one:http://groups.google.com/group/puppet-users/browse_thread/thread/ec35...
>
> But that one was nearly one year ago and seemed to be fixed...
>
> I''m using Version 0.25.4 on OpenSuse 11.1 and I run into the same
> problems...I have entries in "fact_names".
"fact_values" and "hosts"
> but the other tables like "resources" are empty.
> Puppetmasterd reports:
> debug: Scope(Class[allgemein::knownhost]): Collected 1 Sshkey resource
> in 0.00 seconds
> debug: Scope(Class[allgemein::knownhost]): Collected 0 Sshkey
> resources in 0.00 seconds
> debug: Scope(Class[allgemein::knownhost]): Collected 0 Sshkey
> resources in 0.00 seconds
>
> I followed step by step the manual to configure stored configs, etc...
> I use mysql as database and this are the packages I installed via
> repository:
> libmysqlclient_r15-5.0.67-12.16.1
> libmysqlclient15-5.0.67-12.16.1
> mysql-client-5.0.67-12.16.1
> mysql-5.0.67-12.16.1
> ruby-mysql-2.7.4-1.101
>
> I''m rather new to puppet so I can''t tell that in previous
versionsexportedresources worked for me.
>
> When i ran puppetmaster in debug mode I also saw this warning: "This
> method is deprecated and will be removed on the next release. Use
> ''publish'' instead"
> But I can''t tell where that comes from...Maybe the message shows
up
> because I''m using the ssh::auth module?
>
> I appreciate any help
> christian
--
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
puppet-users+unsubscribe@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/puppet-users?hl=en.
christian
2010-Mar-26 10:29 UTC
[Puppet Users] Re: Exported resources doesn''t seem to work
Well, nice monologue I''m having here :D But the problem seems to be solved....I changed the password for puppet to just "puppet", updated puppet.conf and restarted the master, now everything works fine. Before this the pw containd capital letters and numbers. Is it possible that puppet can''t handle such strings? On 26 Mrz., 10:57, christian <christ...@cust.in> wrote:> After giving this some rest, today i started the puppetqd daemon in > debug mode and it with every puppetrun i get this messages: > > info: Connecting to mysql database: puppet > err: Could not save queued catalog for keto- > puppetweb.backyard.wlwonline.de: Access denied for user > ''puppet''@''localhost'' (using password: YES) > notice: Processing queued catalog for keto- > puppetweb.backyard.wlwonline.de in 0.00 seconds > info: Loaded queued catalog in 0.07 seconds > > So this seems to be a permission problem and not a bug... > But I can''t really figure out why access is denied. > > I granted all privileges on the puppet db with: grant all privileges > on puppet.* to puppet@localhost identified by ''password''; > When I log into the database with mysql -u puppet -p there are no > permission problems. In mysql.db I can see that user puppet has all > privileges except grant on the db puppet... > > During a puppetrun the mysql query log shows this: > > 100326 10:47:53 19 Connect puppet@localhost on puppet > 19 Query SET SQL_AUTO_IS_NULL=0 > 19 Statistics > 19 Query SELECT * FROM `hosts` WHERE > (`hosts`.`name` = ''keto-puppetdns.backyard.wlwonline.de'') LIMIT 1 > 19 Query SELECT * FROM `fact_values` WHERE > (`fact_values`.host_id = 1) > -- snip -- more SELECT and INSERT INTO > `fact_values` follow > 19 Query SELECT * FROM `hosts` WHERE > (`hosts`.`name` = ''keto-puppetdns.backyard.wlwonline.de'') LIMIT 1 > 19 Query SELECT * FROM `resources` WHERE > (host_id != 1 AND (exported=1 AND restype=''Sshkey'')) > 19 Query SELECT * FROM `hosts` WHERE > (`hosts`.`name` = ''keto-puppetdns.backyard.wlwonline.de'') LIMIT 1 > 19 Query SELECT * FROM `resources` WHERE > (host_id != 1 AND (exported=1 AND restype=''Sshkey'')) > 19 Query SELECT * FROM `hosts` WHERE > (`hosts`.`name` = ''keto-puppetdns.backyard.wlwonline.de'') LIMIT 1 > 19 Query SELECT * FROM `resources` WHERE > (host_id != 1 AND (exported=1 AND restype=''Sshkey'')) > 20 Connect Access denied for user > ''puppet''@''localhost'' (using password: YES) > > Does someone see the possible mistake on my side? > > Thanks in advance, > christian > > On 23 Mrz., 14:04, christian <christ...@cust.in> wrote: > > > Hey, > > > I''m trying to use the simple ssh known host example in the puppet wiki > > to getexportedresources working...but somehow it fails. > > I''d say my problem is similar to this one:http://groups.google.com/group/puppet-users/browse_thread/thread/ec35... > > > But that one was nearly one year ago and seemed to be fixed... > > > I''m using Version 0.25.4 on OpenSuse 11.1 and I run into the same > > problems...I have entries in "fact_names". "fact_values" and "hosts" > > but the other tables like "resources" are empty. > > Puppetmasterd reports: > > debug: Scope(Class[allgemein::knownhost]): Collected 1 Sshkey resource > > in 0.00 seconds > > debug: Scope(Class[allgemein::knownhost]): Collected 0 Sshkey > > resources in 0.00 seconds > > debug: Scope(Class[allgemein::knownhost]): Collected 0 Sshkey > > resources in 0.00 seconds > > > I followed step by step the manual to configure stored configs, etc... > > I use mysql as database and this are the packages I installed via > > repository: > > libmysqlclient_r15-5.0.67-12.16.1 > > libmysqlclient15-5.0.67-12.16.1 > > mysql-client-5.0.67-12.16.1 > > mysql-5.0.67-12.16.1 > > ruby-mysql-2.7.4-1.101 > > > I''m rather new to puppet so I can''t tell that in previous versionsexportedresources worked for me. > > > When i ran puppetmaster in debug mode I also saw this warning: "This > > method is deprecated and will be removed on the next release. Use > > ''publish'' instead" > > But I can''t tell where that comes from...Maybe the message shows up > > because I''m using the ssh::auth module? > > > I appreciate any help > > christian-- 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 puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
Peter Meier
2010-Mar-26 10:40 UTC
Re: [Puppet Users] Re: Exported resources doesn''t seem to work
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1> Well, nice monologue I''m having here :D > > But the problem seems to be solved....I changed the password for > puppet to just "puppet", updated puppet.conf and restarted the master, > now everything works fine. > Before this the pw containd capital letters and numbers. Is it > possible that puppet can''t handle such strings?No, I use a password generated with `pwgen 32`. So the problem have to be buried somewhere else. cheers pete. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkusjwYACgkQbwltcAfKi38diQCffA9x3QFX70snnOObB/Wq8yvD DtsAnjAD2CHEUuNoiu+yuteTAVLgI4zA =/QkS -----END PGP SIGNATURE----- -- 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 puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.