Database and user not created (Puppetlabs mysql module)
Moteo
I am new to Puppet and try to make some simple "automation things".
I have succeed with apache2, ssh modules, but have problems with
Puppetlabs mysql module.
It installs mysql server, changes/creates admin user password, but
does not create database and user.
I cannot find anything wrong in logs (--debug --verbose). I see that
manifests is read, but no db/user in mysql.
There is all my node config:
include openssh
include apache
include php
php::module { "mysql": }
include mysql
class { 'mysql::server':
config_hash => { root_password => "xxxx"}
}
mysql::db { 'mydb1':
user => 'user1',
password => 'xxxxx1',
host => 'localhost',
grant => ['all'],
}
apache::virtualhost { "s1.test.com": }
apache::virtualhost { "s2.test.com": }
What I have missed?
Thank You
Moteo
Moteo Air
still no tiny step forward :(
From puppet agent log:
moteo@myHOST:~$ sudo puppet agent --no-daemonize --onetime --debug
--verbose | grep ysql
debug: /Stage[main]//Node[myHOST]/Php::Module[mysql]/Package[php-mysql]/notify:
subscribes to Service[apache]
debug: /Stage[main]/Mysql::Config/File[/root/.my.cnf]/require:
requires Package[mysql-server]
debug: /Stage[main]/Mysql::Config/File[/root/.my.cnf]/notify:
subscribes to Exec[mysqld-restart]
debug: /Stage[main]/Mysql::Config/File[/etc/mysql/my.cnf]/require:
requires Package[mysql-server]
debug: /Stage[main]/Mysql::Config/File[/etc/mysql/my.cnf]/notify:
subscribes to Exec[mysqld-restart]
debug: /Stage[main]//Node[myHOST]/Mysql::Db[mydb1]/Database_user[mydbuser@localhost]/require:
requires Database[mydb1]
debug: /Stage[main]/Mysql::Server/Package[mysql-server]/notify:
subscribes to Service[mysqld]
debug: /Stage[main]/Mysql::Config/Exec[set_mysql_rootpw]/require:
requires Package[mysql-server]
debug: /Stage[main]/Mysql::Config/Exec[set_mysql_rootpw]/require:
requires Service[mysqld]
debug: /Stage[main]/Mysql::Config/Exec[set_mysql_rootpw]/before:
requires File[/root/.my.cnf]
debug: /Stage[main]/Mysql::Config/Exec[set_mysql_rootpw]/notify:
subscribes to Exec[mysqld-restart]
debug: /Stage[main]//Node[myHOST]/Mysql::Db[mydb1]/Database_grant[mydbuser@localhost/mydb1]/require:
requires Database_user[mydbuser@localhost]
debug: /Stage[main]//Node[myHOST]/Mysql::Db[mydb1]/Database[mydb1]/require:
requires Class[Mysql::Server]
debug: /Stage[main]/Mysql::Config/File[/etc/mysql]/require: requires
Package[mysql-server]
debug: /Stage[main]/Mysql::Config/File[/etc/mysql]/notify: subscribes
to Exec[mysqld-restart]
debug: /Stage[main]/Mysql::Config/File[/etc/mysql/my.cnf]:
Autorequiring File[/etc/mysql]
debug: Service[mysqld](provider=debian): Executing '/etc/init.d/mysql status'
debug: Exec[set_mysql_rootpw](provider=posix): Executing check
'mysqladmin -u root -pXXXXXXX status > /dev/null'
debug: Executing 'mysqladmin -u root -pXXXXXXX status > /dev/null'
There is: "requires Database[mydb1]" and "requires
Database_user[mydbuser@localhost]", but user and database aren't
created.
And no errors also... Very strange... Can be anything Ubuntu specific?
Thank You
Moteo
2012/3/12 Moteo <mote...@gmail.com>:
> --
> You received this message because you are subscribed to the Google Groups "Puppet Users" group.
> To post to this group, send email to puppet...@googlegroups.com.
> To unsubscribe from this group, send email to puppet-users...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
>
Adam Heinz
using github.com/camptocamp/puppet-mysql for over a year without much
trouble.
Moteo Air
Thank You Adam.
2012/3/14 Adam Heinz <a...@metricwise.net>:
> I don't know anything about that particular module, but I have been
> using github.com/camptocamp/puppet-mysql for over a year without much
> trouble.
>
Luca Spiller
On Thursday, 15 March 2012 10:51:04 UTC, Moteo wrote:
I will try this module.Thank You Adam.
2012/3/14 Adam Heinz <a...@metricwise.net>:
> I don't know anything about that particular module, but I have been
> using github.com/camptocamp/puppet-mysql for over a year without much
> trouble.
>
> --
> You received this message because you are subscribed to the Google Groups "Puppet Users" group.
> To post to this group, send email to puppet...@googlegroups.com.
> To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com.
Moteo Air
sadly I left "nice puppet" way for a while for Mysql management and
did everything manuallly :(
Best regards
M.
2012/3/28 Luca Spiller <lu...@stackednotion.com>:
> Moteo, did you get this issue resolved?
>
> I've used the Puppetlabs MySql module in the past, but I'm now getting these
> issues setting up a new machine with Ubuntu 11.10. I've used the same Puppet
> scripts on other Ubuntu 11.10 machines previously with no issues.
>
> On Thursday, 15 March 2012 10:51:04 UTC, Moteo wrote:
>>
>> I will try this module.
>>
>> Thank You Adam.
>>
>> 2012/3/14 Adam Heinz <a...@metricwise.net>:
>> > I don't know anything about that particular module, but I have been
>> > using github.com/camptocamp/puppet-mysql for over a year without much
>> > trouble.
>> >
>> > --
>> > You received this message because you are subscribed to the Google
>> > Groups "Puppet Users" group.
>> > To post to this group, send email to puppet...@googlegroups.com.
>> > To unsubscribe from this group, send email to
>> > puppet-users...@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 view this discussion on the web visit
> https://groups.google.com/d/msg/puppet-users/-/ZwavJYd6jwMJ.
>
> To post to this group, send email to puppet...@googlegroups.com.
> To unsubscribe from this group, send email to
> puppet-users...@googlegroups.com.
Piotr Usewicz
Pete Brown
> I think you have to enable pluginssync option in the [main] section in
> puppet.conf
So unless you have disabled it it should work.
> email to puppet-users...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.