From 391406c85d86dc931f3fdb2483a14d0f1e7e6355 Mon Sep 17 00:00:00 2001
From: Fabian Affolter <fabian@bernewireless.net>
Date: Tue, 9 Nov 2010 00:15:43 +0100
Subject: doc: Massive update

---
 doc/appendix/files/mysql.txt | 63 ++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 63 insertions(+)
 create mode 100644 doc/appendix/files/mysql.txt

(limited to 'doc/appendix/files/mysql.txt')

diff --git a/doc/appendix/files/mysql.txt b/doc/appendix/files/mysql.txt
new file mode 100644
index 000000000..ae4a1450b
--- /dev/null
+++ b/doc/appendix/files/mysql.txt
@@ -0,0 +1,63 @@
+.. -*- mode: rst -*-
+
+.. _getting_started-mysql:
+
+.. Author: Patrick Ruckstuhl
+
+Mysql example
+=============
+
+I had some time ago to continue with putting my configuration into 
+Bcfg2 and maybe this helps someone else.
+
+I added a new bundle:
+
+.. code-block:: xml
+
+    <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:
+
+.. code-block:: sh
+
+    #!/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 (manually) create a 
+user in the database that has enough permissions and add the 
+login information in a file yourself. This file looks like this:
+
+.. code-block:: sh
+
+    [client]
+    host     = localhost
+    user     = debian-sys-maint
+    password = XXXXXXXXXX
+
+The ``users.sql`` looks like this:
+
+.. code-block:: sh
+
+    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;
+
-- 
cgit v1.2.3-1-g7c22