Changes between Version 2 and Version 3 of AnnotatedExamples

Timestamp:

10/06/06 06:26:52 (17 years ago)

Author:

dclark

Comment:

Added mysql example from recent mailing list email

AnnotatedExamples

@@ +1 @@
+= Annotated Examples =
+
 == ntp example ==
+
+Author: Jason Pepas 
 
 Here is a series of example configurations for bcfg2, each introducing another layer of functionality.  
@@ -115 +119 @@
 nothing else), the bcfg2 client can be run with a -b <bundle name>
 option that will only update entries in the specified bundle.
+
+== mysql example ==
+
+Author: Patrick Ruckstuhl
+
+I had some time ago to continue with putting my configuration into
+bcfg2 and maybe this helps someone else.
+
+I added a new bundle:
+{{{
+<Bundle name="mysql-server" version="3.0">
+   <ConfigFile name="/root/bcfg2-install/mysql/users.sh"/>
+   <ConfigFile name="/root/bcfg2-install/mysql/users.sql"/>
+   <PostInstall name="/root/bcfg2-install/mysql/users.sh"/>
+   <Package name="mysql-server-4.1"/>
+   <Service name="mysql"/>
+</Bundle>
+}}}
+
+The `users.sh` script looks like this:
+{{{
+#!/bin/sh
+
+mysql --defaults-extra-file=/etc/mysql/debian.cnf mysql \
+    < /root/bcfg2-install/mysql/users.sql
+}}}
+
+On debian there is a user account in `/etc/mysql/debian.cnf` automatically created, but you could also create such a file yourself, with contents like:
+{{{
+[client]
+host     = localhost
+user     = debian-sys-maint
+password = XXXXXXXXXX
+}}}
+
+The `users.sql` looks like this:
+{{{
+DELETE FROM db;
+INSERT INTO db VALUES ('localhost', 'phpmyadmin', 'pma', 'Y', 'Y',
+'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
+
+DELETE FROM user WHERE User <> 'debian-sys-maint';
+INSERT INTO user VALUES ('localhost', 'root', 'XXXXXXXXXXX', 'Y', 'Y',
+'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y',
+'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0);
+INSERT INTO user VALUES ('localhost', 'pma', '', 'N', 'N', 'N', 'N',
+'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N',
+'N', 'N', 'N', '', '', '', '', 0, 0, 0);
+
+FLUSH PRIVILEGES;
+}}}