puppetlabs-mysql is an official module to manage mysql using Puppet.
puppetlabs-mysql is an official module to manage mysql using Puppet.
Useful Links
Related Tags:
Questions tagged [puppetlabs-mysql]
16 questions
4
votes
1 answer
vagrant puppetlabs-mysql Mysql_grant failed
I want to use vagrant, and I defined the following puppet file:
http://pastebin.com/GfJK1ziS
When vagrant tries to install the modules everything works as expected. But when it tries to configure mysql, it always get this error:
Error: Validation…
Ceryni
- 371
- 1
- 5
- 18
3
votes
1 answer
How to install mySQL 5.6.23 using puppetlabs-mysql
Environment :
Vagrant (VirtualBox)
Ubuntu 14
Puppet
-Puppetlabs-mysql (https://github.com/puppetlabs/puppetlabs-mysql)
Problem:
Using puppetlabs-mysql (Version 3.6.1) I am trying to install mySQL 5.6.23 but it seems to be installing 5.5.4.
I tried…
Beenish Khan
- 1,571
- 10
- 18
2
votes
1 answer
Puppet mysql replication
I'm trying to configure mysql replication using Puppetlabs-mysql module with this code
class core {
class { '::mysql::server':
root_password => '*23AE809DDACAF96AF0FD78ED04B6A265E05AA257',
remove_default_accounts => true,
…
Valentine
- 31
- 2
1
vote
0 answers
Puppetlabs MySQL unable to install previous build of MySQL
Using puppet module puppetlabs/mysql we faced with issue when we can’t select to install MySQL build (8.0.19-1ubuntu18.04) different from the Latest or its build number (for today latest is 8.0.20-1ubuntu18.04)
Requested packages are present in…
HoLmS
- 31
- 3
1
vote
1 answer
Setting up a three tier environment in puppet
These are my files:
Nodes.pp file
site.pp file
I need to setup the infrastructure in the diagram, and I would like to use Puppet Automation in order to do so. I would need to,
Create 4 VMs, one for DB, 1 web server, 1 load balancer, 1 master
Set…
Vijayboopathy Elangovan
- 61
- 1
- 6
1
vote
1 answer
Set mysql root password on Puppet
I have downloaded puppetlabs-mysql module in its latest version (3.30) and I can not define root password. My OS is Ubuntu 14.04.2 LTS
When I try to run:
class {'::mysql::server':
remove_default_accounts => true,
create_root_user =>…
José Augustinho
- 110
- 1
- 10
1
vote
1 answer
Using puppet classes in modules
I'm still fairly new to puppet, and am now at the point where I want to use classes with parameters in my custom modules.
I have a module called tsvpuppet, and I want it to act as a wrapper to the mysql module
with standard paramters (maybe later on…
Matt
- 153
- 2
- 8
1
vote
1 answer
puppetlabs-mysq (v3.0.0): temporary user
we have a puppet setup that basically works like this:
Create user "puppetdeploy"
Grant access to all tables for user "puppetdeploy"
Runs scripts that creates and updates databases from .sql files, using 'puppetdeploy'
Revoke all access to user…
kjetil
- 23
- 4
1
vote
1 answer
puppetlabs_mysql fails to import two sql scripts given as an array to the db class
This is so good but I would like to ask if the sql parameter to import sql scripts can receive an array as argument that is get two .sql file or more and still execute successfully, have tried to give it an array but it joins everything to one so…
Gideon Maina
- 849
- 10
- 25
1
vote
1 answer
How to use vagrant in development and how to use shared folders?
I (a struggling newbie in vagrant) have done setup a vagrant environment for development. i have been provided with vagrant file
Vagrant.configure("2") do |config|
config.vm.box = 'precise64'
config.vm.box_url =…
dipak1296
- 349
- 2
- 3
- 16
1
vote
1 answer
Import a dump.sql into mysql database with puppetlabs-mysql
Using puppet as a Vagrant provider and the puppetlabs-mysql module (2.2.3) I'm not able to import a sql dump on a db with root user and no password.
This is the puppet code I'm using:
class { '::mysql::server': }
mysql::db { 'foo':
user =>…
a--m
- 4,716
- 1
- 39
- 59
0
votes
2 answers
Puppet MySQL disable root user login without password
I have been over several threads for issues related to puppetlabs-mysql module in last few hours to get a workaround on my issue.
MySQL installation on my agent node with this module is enabling the root user login without any password. But I see…
Vineeth Vijayan
- 15
- 5
0
votes
1 answer
PuppetLabs MYSQL drop database
How do you remove a Puppetlabs MYSQL database using this module?
I have tried using the name of the database and ensure => 'absent' but with no luck.
Can someone please tell me what I am doing wrong?
P.S: I am able to create DBs using this module.
Sergiu
- 2,928
- 3
- 27
- 37
0
votes
0 answers
Provision Vagrant machine with mysql Puppet module
I am trying to provision a Vagrant machine using this puppet module.
The Hello world is simple, its something like this:
class { '::mysql::server':
root_password => 'strongpassword',
remove_default_accounts => true
}
But my main…
Gepser Hoil
- 3,998
- 4
- 24
- 34
0
votes
1 answer
Using Puppetlabs-mysql to allow more than one host
I am using Puppet v3.4.3 and Puppetlabs-mysql module v2.3.1 ( https://forge.puppetlabs.com/puppetlabs/mysql) to create database and I need to allow hosts localhost and % to use it. Both Puppet master and client run on Ubuntu-14.04 servers.
I use…
Madoc Comadrin
- 498
- 1
- 12
- 27