#! /bin/sh
#
# Copyright (C) 2005 Nexedi SARL and Contributors. All Rights Reserved.
#
# This script is used to set up MySQL and Zope for ERP5 Live CD.

cd /var/lib
tar zxpvf /usr/share/erp5cdtool/mysql.tgz
chown -R mysql.mysql mysql
tar zxpvf /usr/share/erp5cdtool/zope.tgz
chown -R zope.zope zope

/etc/init.d/mysql-max start
zopectl adduser zope zope
/etc/init.d/zope start

mysql <<EOF
CREATE DATABASE erp5;
CREATE DATABASE cmf_activity;
GRANT ALL PRIVILEGES ON erp5.* TO 'erp5'@'localhost' IDENTIFIED BY 'erp5';
GRANT ALL PRIVILEGES ON cmf_activity.* TO 'erp5'@'localhost' IDENTIFIED BY 'erp5';
EOF