[Puppet Users] puppetlabs-mysql module still doesn't properly support $datadir?

[Matt W]

It seems like this has been an issue in the past 
(https://github.com/puppetlabs/puppetlabs-mysql/issues/228, 
https://groups.google.com/forum/#!searchin/puppet-users/mysql/puppet-users/mkQygmpa610/bXIslE9EG4cJ),
 
but I'm not sure its fixed yet. Can anyone show me some demonstration 
puppet code that will install MySQL and configure it to use /mnt/mysql 
instead of /var/lib/mysql? Nothing I seem to try works -- the MySQL daemon 
continues to start up and use /var/lib/mysql. 

The simplest thing that should have worked, I think, is:

node foo {
   file { '/mnt/mysql':
 ensure = directory,
 owner = 'mysql',
 group  = 'mysql',
 notify = Class['mysql::server::service'];
   }
   class { '::mysql::server':
 override_options = {
   'mysqld' = { 'datadir' = '/mnt/mysql', },
 },
 require  = File[$datadir];
   }
   mysql::db { 'foo': }
 }


This did create the /mnt/mysql directory, but mysqld still started up using 
/var/lib/mysql... even though my.cnf clearly pointed to /mnt/mysql.

Ideas?

-- 
You received this message because you are subscribed to the Google Groups 
Puppet Users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to puppet-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/puppet-users/cd589484-8306-4f31-aa25-f138fc59584e%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Puppet Users] puppetlabs-mysql module

[treydock]

You can supply values to override those defined in /etc/my.cnf by adding files 
to /etc/mysql/conf.d.  The module makes the overrides possible with the default 
configuration in my.cnf, I believe the IncludeDir line.  Using phone so 
difficult to reference. 

- Trey

-- 
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/-/D98HPPDdiLEJ.
To post to this group, send email to puppet-users@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.

[Puppet Users] puppetlabs-mysql module

[Darin Perusich]

Hello All,

I'm never really sure whether to email the maintainers for modules or
the list so I figure posting to the list is a good place to start;-)

So I've started testing out the puppetlabs-mysql module today and I
like what I'm seeing but have a few questions/critiques/concerns
regarding the types/providers. I'm finding the names, database,
database_user, and database_grant rather generic. Unless there are
plans to merge mysql, postgresql, etc, into a single database module
shouldn't they be a bit more specific like mysql_db, mysql_user, and
mysql_grant?

Also, what about supplying my.cnf instead of creating from a template
which is the default action? I see you can use mysql::server::config,
which I haven't tried yet, to add additional params but I'm thinking
that could lead to a rather large/unwieldy manifest given the vast
number of options available.

Nice work and I hope to see my pull request for SuSE support accepted soon;-)

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