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 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.
Bernd Adamowicz
2011-Nov-30 08:53 UTC
AW: [Puppet Users] storeconfgs not initializing database
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: puppet-users@googlegroups.com [mailto:puppet-users@googlegroups.com] Im
Auftrag von Darin Perusich
Gesendet: Dienstag, 29. November 2011 22:49
An: puppet-users@googlegroups.com
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 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.
--
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.
Darin Perusich
2011-Nov-30 13:44 UTC
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 < Bernd.Adamowicz@esailors.de> 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:* puppet-users@googlegroups.com [mailto:puppet-users@googlegroups.com] > *Im Auftrag von *Darin Perusich > *Gesendet:* Dienstag, 29. November 2011 22:49 > *An:* puppet-users@googlegroups.com > *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 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.**** > > -- > 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. >-- 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.
Bernd Adamowicz
2011-Nov-30 15:12 UTC
AW: [Puppet Users] storeconfgs not initializing database
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: puppet-users@googlegroups.com [mailto:puppet-users@googlegroups.com] Im
Auftrag von Darin Perusich
Gesendet: Mittwoch, 30. November 2011 14:44
An: puppet-users@googlegroups.com
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
<Bernd.Adamowicz@esailors.de<mailto:Bernd.Adamowicz@esailors.de>>
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: puppet-users@googlegroups.com<mailto:puppet-users@googlegroups.com>
[mailto:puppet-users@googlegroups.com<mailto:puppet-users@googlegroups.com>]
Im Auftrag von Darin Perusich
Gesendet: Dienstag, 29. November 2011 22:49
An: puppet-users@googlegroups.com<mailto:puppet-users@googlegroups.com>
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
puppet-users@googlegroups.com<mailto:puppet-users@googlegroups.com>.
To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com<mailto:puppet-users%2Bunsubscribe@googlegroups.com>.
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
puppet-users@googlegroups.com<mailto:puppet-users@googlegroups.com>.
To unsubscribe from this group, send email to
puppet-users+unsubscribe@googlegroups.com<mailto:puppet-users%2Bunsubscribe@googlegroups.com>.
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 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.
--
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.
Darin Perusich
2011-Nov-30 15:13 UTC
Re: [Puppet Users] storeconfgs not initializing database
Ok, I''ve resolved this. The reason puppet wasn''t able to make the database connections, any database for that matter, was the rubygem-activerecord package wasn''t installed. I figured this out by switching back to puppetmasterd and running with "--debug --no-daemonize --verbose" and seeing the message "ActiveRecord 2.1 or later required for StoreConfigs" in the output. Running puppet via Passenger really didn''t provide any useful logs. FYI...I getting this packages from this, and Passenger, from the OBS devel:/languages:/ruby:/extensions repository. http://download.opensuse.org/repositories/devel:/languages:/ruby:/extensions/openSUSE_11.3/ Thanks! -- Later, Darin On Wed, Nov 30, 2011 at 8:44 AM, Darin Perusich <darin@darins.net> wrote:> 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 < > Bernd.Adamowicz@esailors.de> 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:* puppet-users@googlegroups.com [mailto: >> puppet-users@googlegroups.com] *Im Auftrag von *Darin Perusich >> *Gesendet:* Dienstag, 29. November 2011 22:49 >> *An:* puppet-users@googlegroups.com >> *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 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.**** >> >> -- >> 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. >> > >-- 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.