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 pup...@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     pup...@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-us...@googlegroups.com.
To unsubscribe from this group, send email to 
puppet-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/puppet-users?hl=en.

Reply via email to