| 1 |
< |
### RPM external mysql-deployment 0.0.1 |
| 1 |
> |
### RPM external mysql-deployment 0.0.3 |
| 2 |
|
|
| 3 |
< |
Source: /tmp/mysql-deployment.sh |
| 3 |
> |
Source: mysql-deployment.sh |
| 4 |
|
Requires: mysql |
| 5 |
|
# Let's fake the fact that we have perl (DBI) so that rpm does not complain. |
| 6 |
|
Provides: mysql-deployment.sh |
| 7 |
|
|
| 8 |
|
%prep |
| 9 |
< |
cat << \EOF > /tmp/mysql-deployment.sh |
| 9 |
> |
mkdir -p %{i}/bin |
| 10 |
> |
cat << \EOF > %{i}/bin/mysql-deployment.sh |
| 11 |
|
#!/bin/bash |
| 12 |
|
set -e |
| 13 |
|
|
| 33 |
|
if [ ! -z ${pid} ]; then |
| 34 |
|
echo "CMS MySQL server is already running ..." |
| 35 |
|
else |
| 36 |
< |
echo "+++ Installing CMS MySQL accounts and DBs ..." |
| 36 |
< |
$MYSQL_ROOT/bin/mysql_install_db --datadir=$MYSQL_PATH --port=$MYSQL_PORT --socket=$MYSQL_SOCK |
| 36 |
> |
# may use --skip-networking for pure local MySQL |
| 37 |
|
|
| 38 |
< |
echo "+++ Start up CMS MySQL daemon on port ${MYSQL_PORT} ..." |
| 39 |
< |
$MYSQL_ROOT/bin/mysqld_safe --datadir=$MYSQL_PATH --port=$MYSQL_PORT \ |
| 40 |
< |
--socket=$MYSQL_SOCK --log-error=$MYSQL_ERR --skip-networking --pid-file=$MYSQL_PID & |
| 41 |
< |
sleep 10 |
| 42 |
< |
|
| 43 |
< |
# create CMS MySQL root account |
| 44 |
< |
echo "+++ Creating MySQL default root account ..." |
| 45 |
< |
$MYSQL_ROOT/bin/mysqladmin --port=$MYSQL_PORT --socket=$MYSQL_SOCK -u root password "cms" |
| 46 |
< |
# $MYSQL_ROOT/bin/mysqladmin --port=$MYSQL_PORT --socket=$MYSQL_SOCK -u root -h `hostname` password "cms" |
| 47 |
< |
|
| 48 |
< |
# create CMS MySQL DBS account |
| 49 |
< |
echo "+++ Creating MySQL default dbs account ..." |
| 50 |
< |
$MYSQL_ROOT/bin/mysql --socket=$MYSQL_SOCK -uroot -pcms mysql -e "CREATE USER dbs@localhost IDENTIFIED BY 'cmsdbs'" |
| 51 |
< |
$MYSQL_ROOT/bin/mysql --socket=$MYSQL_SOCK -uroot -pcms mysql -e "UPDATE user set Select_priv='Y',Insert_priv='Y',Update_priv='Y',Delete_priv='Y',Create_priv='Y',Drop_priv='Y',References_priv='Y',Index_priv='Y',Alter_priv='Y',Create_tmp_table_priv='Y',Lock_tables_priv='Y',Execute_priv='Y',Create_view_priv='Y',Show_view_priv='Y',Create_routine_priv='Y',Alter_routine_priv='Y' where User='dbs';" |
| 38 |
> |
if [ ! -d $MYSQL_ROOT/mysqldb/mysql ]; then |
| 39 |
> |
echo "+++ Installing CMS MySQL accounts and DBs ..." |
| 40 |
> |
$MYSQL_ROOT/bin/mysql_install_db --datadir=$MYSQL_PATH --port=$MYSQL_PORT --socket=$MYSQL_SOCK |
| 41 |
> |
|
| 42 |
> |
echo "+++ Start up CMS MySQL daemon on port ${MYSQL_PORT} ..." |
| 43 |
> |
$MYSQL_ROOT/bin/mysqld_safe --datadir=$MYSQL_PATH --port=$MYSQL_PORT \ |
| 44 |
> |
--socket=$MYSQL_SOCK --log-error=$MYSQL_ERR --pid-file=$MYSQL_PID & |
| 45 |
> |
|
| 46 |
> |
sleep 10 |
| 47 |
> |
# create CMS MySQL root account |
| 48 |
> |
echo "+++ Creating MySQL default root account ..." |
| 49 |
> |
echo "+++ Account for localhost" |
| 50 |
> |
$MYSQL_ROOT/bin/mysqladmin --port=$MYSQL_PORT --socket=$MYSQL_SOCK -u root password "cms" |
| 51 |
> |
echo "+++ Account for `hostname`" |
| 52 |
> |
$MYSQL_ROOT/bin/mysqladmin --port=$MYSQL_PORT --socket=$MYSQL_SOCK -u root -h `hostname` password "cms" |
| 53 |
> |
|
| 54 |
> |
# create CMS MySQL DBS account |
| 55 |
> |
echo "+++ Creating MySQL default dbs account ..." |
| 56 |
> |
$MYSQL_ROOT/bin/mysql --socket=$MYSQL_SOCK -uroot -pcms mysql -e "CREATE USER dbs@localhost IDENTIFIED BY 'cmsdbs'" |
| 57 |
> |
$MYSQL_ROOT/bin/mysql --socket=$MYSQL_SOCK -uroot -pcms mysql -e "UPDATE user set Select_priv='Y',Insert_priv='Y',Update_priv='Y',Delete_priv='Y',Create_priv='Y',Drop_priv='Y',References_priv='Y',Index_priv='Y',Alter_priv='Y',Create_tmp_table_priv='Y',Lock_tables_priv='Y',Execute_priv='Y',Create_view_priv='Y',Show_view_priv='Y',Create_routine_priv='Y',Alter_routine_priv='Y' where User='dbs';" |
| 58 |
> |
else |
| 59 |
> |
echo "+++ Start up CMS MySQL daemon on port ${MYSQL_PORT} ..." |
| 60 |
> |
$MYSQL_ROOT/bin/mysqld_safe --datadir=$MYSQL_PATH --port=$MYSQL_PORT \ |
| 61 |
> |
--socket=$MYSQL_SOCK --log-error=$MYSQL_ERR --pid-file=$MYSQL_PID & |
| 62 |
> |
sleep 10 |
| 63 |
> |
fi |
| 64 |
|
fi |
| 65 |
|
|
| 66 |
|
EOF |
| 67 |
< |
chmod a+x /tmp/mysql-deployment.sh |
| 56 |
< |
mkdir -p %{i}/bin |
| 67 |
> |
chmod a+x %{i}/bin/mysql-deployment.sh |
| 68 |
|
|
| 69 |
|
%build |
| 70 |
|
|
| 71 |
|
%install |
| 72 |
< |
cp /tmp/mysql-deployment.sh %{i}/bin |
| 73 |
< |
cp /tmp/mysql-deployment.sh $RPM_SOURCE_DIR |
| 72 |
> |
#cp /tmp/mysql-deployment.sh %{i}/bin |
| 73 |
> |
#cp %{i}/mysql-deployment.sh $RPM_SOURCE_DIR |
| 74 |
|
|
| 75 |
|
%post |
| 76 |
|
%{relocateConfig}/bin/mysql-deployment.sh |
