Just to avoid misunderstandings: You wrote: "but it's failing to create the database". Be sure that *you* have created the database before! Puppet will do the initial setup of the tables but it expects to have the database in place. So you need to do something like that:
01 [root@bob ~]# mysql -u root -p 02 Enter password: 03 Welcome to the MySQL monitor. Commands end with ; or \g. 04 ... 05 mysql> create database puppet; 06 Query OK, 1 row affected (0.00 sec) 07 08 mysql> grant all privileges on puppet.* to puppet@localhost identified by 'xxx'; 09 Query OK, 0 rows affected (0.00 sec) 10 11 mysql> Maybe that's the reason. Bernd Von: [email protected] [mailto:[email protected]] Im Auftrag von Darin Perusich Gesendet: Mittwoch, 30. November 2011 14:44 An: [email protected] Betreff: Re: [Puppet Users] storeconfgs not initializing database Hi Bernd, I've tried with and without dbsocket being set but it has no affect. -- Later, Darin On Wed, Nov 30, 2011 at 3:53 AM, Bernd Adamowicz <[email protected]<mailto:[email protected]>> wrote: Did you try uncommenting the 'dbsocket' line? Maybe you should check where the 'mysql.sock' file is actually located - it might not be default. For me this works pretty good: [master] user = puppet group = puppet reports = puppet_dashboard storeconfigs = true dbadapter = mysql dbuser = puppet dbpassword = xxx dbserver = localhost dbsocket = /var/lib/mysql/mysql.sock Bernd Von: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] Im Auftrag von Darin Perusich Gesendet: Dienstag, 29. November 2011 22:49 An: [email protected]<mailto:[email protected]> Betreff: [Puppet Users] storeconfgs not initializing database Hello, I'm attempting to setup puppet 2.7.6 to use the storeconfigs but it's failing to create the database and I'm not seeing any error or messages in the logs related to initializing the database. I'm using mysql and have created the user/role and the database and I'm able to connect successfully on both localhost and remotely. I'm running the dashboard on the same system and it's able to connect to it's db without issue. When I run lsof against the master process it hasn't loaded the ruby mysql library, which I can see when I lsof the dashboard process. Any thoughts? System: OpenSUSE 11.3 puppet 2.7.6 apache2 + passenger-3.0.9 [master] # required for Apache with Passenger (aka mod_rails) ssl_client_header = SSL_CLIENT_S_DN ssl_client_verify_header = SSL_CLIENT_VERIFY #dbmigrate = true dbadapter = mysql dbname = puppet dbuser = puppet dbpassword = password #dbsocket = /var/run/mysql/mysql.sock dbserver = localhost storeconfigs = true -- Later, Darin -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to [email protected]<mailto:[email protected]>. To unsubscribe from this group, send email to [email protected]<mailto:puppet-users%[email protected]>. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en. -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to [email protected]<mailto:[email protected]>. To unsubscribe from this group, send email to [email protected]<mailto:puppet-users%[email protected]>. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en. -- You received this message because you are subscribed to the Google Groups "Puppet Users" 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-users?hl=en. -- You received this message because you are subscribed to the Google Groups "Puppet Users" 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-users?hl=en.
