Issue #3923 has been updated by Cory Stoker.
Hello:
I might be able to reproduce this bug. Currently I am trying to get queueing
support to work with our puppet installation and it seems to be working except
that the values in the hosts table are not correct for "ip" or "environment".
They seem to be replaced with the values for the system that runs puppetqd.
Here is my setup:
OS: Scientific Linux 6.2
Ruby version: 1.8.7.352-4.el6_2
Puppet version: 2.7.12-1.el6
Facter version: 1.6.6-1.el6
MySQL server version: 5.1.61-1.el6_2
Active_record gem version: 3.0.11
Stompserver gem version: 0.9.9 (also tried RabbitMQ server 2.8.1-1)
Puppet.conf configuration snippet for puppetmaster:
queue_type = stomp
queue_source = stomp://localhost:61613
dbadapter = mysql
dbuser = puppet
dbpassword = XXXXXX
dbserver = XXXXXXX
dbname = puppet_storeconfigs
dbconnections = 200
storeconfigs = true
async_storeconfigs = true
facts_terminus = inventory_active_record
Here is the results for my hosts table:
mysql> select * from hosts;
| id | name | ip | environment |
last_compile | last_freshcheck | last_report | updated_at |
source_file_id | created_at |
+----+-----------------------------------+--------------+-------------+---------------------+-----------------+-------------+-----------
----------+----------------+---------------------+
| 1 | 00-1a-4d-88-0c-36.ap001.nakika.tv | 10.138.83.25 | production |
2012-04-03 23:21:02 | NULL | NULL | 2012-04-03 23:21:03 |
NULL | 2012-04-03 21:30:19 |
| 2 | 6c-62-6d-8d-8f-45.ap001.nakika.tv | 10.138.83.25 | production |
2012-04-03 23:22:31 | NULL | NULL | 2012-04-03 23:22:32 |
NULL | 2012-04-03 21:34:11 |
| 3 | 6c-62-6d-7a-88-4d.ap001.nakika.tv | 10.138.83.25 | production |
2012-04-03 23:21:36 | NULL | NULL | 2012-04-03 23:21:38 |
NULL | 2012-04-03 22:20:06 |
+----+-----------------------------------+--------------+-------------+---------------------+-----------------+-------------+-----------
----------+----------------+---------------------+
3 rows in set (0.00 sec)
The IP and the environment listed are the Puppetmaster's and not the actual
hosts. Let me know if you need anything from me. I have verified that this
does not happen unless I use async storeconfigs.
----------------------------------------
Bug #3923: Activemq + puppetqd + mysql single ip in hosts table
https://projects.puppetlabs.com/issues/3923#change-59526
Author: Joshua Baldock
Status: Rejected
Priority: High
Assignee:
Category: queuing
Target version:
Affected Puppet version: 0.25.4
Keywords: devtriage
Branch:
I have configured puppet-0.25.4 on RHEL5 with storeconfigs using mysql.
I recently setup storeconfigs with queuing using activemq and puppetqd. Since
running queuing the hosts table in the mysql DB is updating every host record
with the ip of the puppetmaster and not the hosts actual ip addresses.
Here is a snippet from puppet.conf puppetmaster
[main]
queue_type = stomp
queue_source = stomp://localhost:61613
dbadapter = mysql
dbname = puppet
dbuser = puppet
dbpassword = puppet
dbserver = localhost
dbsocket = /var/lib/mysql/mysql.sock
--
You have received this notification because you have either subscribed to it,
or are involved in it.
To change your notification preferences, please click here:
http://projects.puppetlabs.com/my/account
--
You received this message because you are subscribed to the Google Groups
"Puppet Bugs" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/puppet-bugs?hl=en.
