puppetlabs_mysql fails to import two sql scripts given as an array to the db class

Question

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 that

      mysql::db{...
        sql => ["/tmp/1.sql","/tmp/2.sql",]
        ....
       }

it assumes the above to be

           /tmp/1.sql/tmp/2.sql

which is wrong is not possible .... is there a way for the puppetlabs mysql module to have two sql scripts imported at a go

score 3 · Accepted Answer · answered Sep 21 '14 at 09:58

3

No, you can't do it with mysql::db, either you concat the sql files yourself beforehand or run the exec that mysql::db runs

  exec{ "${dbname}-import":
    command     => "/usr/bin/mysql ${dbname} < ${sql}",
    logoutput   => true,
    environment => "HOME=${::root_home}",
    refreshonly => $refresh,
    require     => Mysql_grant["${user}@${host}/${table}"],
    subscribe   => Mysql_database[$dbname],
  }

answered Sep 21 '14 at 09:58

csanchez

1,623
11
20

That, or send a patch upstream to add the desired capability. – Felix Frank Sep 21 '14 at 14:09
Could you give an example to demonstrate this Thank you – Gideon Maina Sep 22 '14 at 06:58
that's what I posted, just replace the variables with your values – csanchez Sep 22 '14 at 16:32

puppetlabs_mysql fails to import two sql scripts given as an array to the db class

1 Answers1