# HG changeset patch
# User Pascal Bellard <pascal.bellard@slitaz.org>
# Date 1228313446 0
# Node ID f00979b9a2bad00f3d2d1e237da5b130e5e2ecaa
# Parent  1143af92f66a95821e6547192c72efdfa54562e7
Asterisk: update mysql config

diff -r 1143af92f66a -r f00979b9a2ba asterisk/receipt
--- a/asterisk/receipt	Tue Dec 02 14:48:36 2008 +0000
+++ b/asterisk/receipt	Wed Dec 03 14:10:46 2008 +0000
@@ -34,6 +34,37 @@
 	for i in $fs/etc/asterisk/*.sample; do
 		mv $i ${i%.sample}
 	done
+	cp -a stuff/* $fs
+}
+
+# Rules to configure package
+setup_rules()
+{
+	case "$2" in
+	mysql_host)
+		sed -i "s|^hostname=.*|hostname=$3|" $1/etc/asterisk/cdr_mysql.conf
+		sed -i "s|^dbhost=.*|dbhost=$3|" $1/etc/asterisk/res_mysqlconf
+		;;
+	mysql_user)
+		sed -i "s|^user=.*|user=$3|" $1/etc/asterisk/cdr_mysql.conf
+		sed -i "s|^dbuser=.*|dbuser=$3|" $1/etc/asterisk/res_mysqlconf
+		;;
+	mysql_password)
+		sed -i "s|^password=.*|password=$3|" $1/etc/asterisk/cdr_mysql.conf
+		sed -i "s|^dbpass=.*|dbpass=$3|" $1/etc/asterisk/res_mysqlconf
+		;;
+	mysql_database)
+		sed -i "s|^dbname=.*|dbname=$3|" $1/etc/asterisk/res_mysqlconf \
+						 $1/etc/asterisk/cdr_mysql.conf
+		;;
+	*)	cat <<EOT
+mysql_host	hostname or ip of mysql server
+mysql_user	username to connect to mysql server
+mysql_password	password to connect to mysql server
+mysql_database	database used by asterisk
+EOT
+		;;
+	esac
 }
 
 # Pre and post install commands for Tazpkg.
diff -r 1143af92f66a -r f00979b9a2ba asterisk/stuff/etc/asterisk/cdr_mysql.conf
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/asterisk/stuff/etc/asterisk/cdr_mysql.conf	Wed Dec 03 14:10:46 2008 +0000
@@ -0,0 +1,21 @@
+;
+; Note - if the database server is hosted on the same machine as the
+; asterisk server, you can achieve a local Unix socket connection by
+; setting hostname=localhost
+;
+; port and sock are both optional parameters.  If hostname is specified
+; and is not "localhost", then cdr_mysql will attempt to connect to the
+; port specified or use the default port.  If hostname is not specified
+; or if hostname is "localhost", then cdr_mysql will attempt to connect
+; to the socket file specified by sock or otherwise use the default socket
+; file.
+;
+[global]
+hostname=127.0.0.1
+dbname=asterisk
+table=cdr
+password= 
+user=root
+port=3306
+sock=/var/run/mysqld/mysqld.sock
+;userfield=1
diff -r 1143af92f66a -r f00979b9a2ba asterisk/stuff/etc/asterisk/res_mysql.conf
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/asterisk/stuff/etc/asterisk/res_mysql.conf	Wed Dec 03 14:10:46 2008 +0000
@@ -0,0 +1,15 @@
+;
+; Sample configuration for res_config_mysql.c
+;
+; The value of dbhost may be either a hostname or an IP address.
+; If dbhost is commented out or the string "localhost", a connection
+; to the local host is assumed and dbsock is used instead of TCP/IP
+; to connect to the server.
+;
+[general]
+dbhost=127.0.0.1
+dbname=asterisk
+dbuser=root
+dbpass= 
+dbport=3306
+dbsock=/var/run/mysqld/mysql.sock