Automate PHPBB Bulletin Board install via script

[jaysunn]

Guys,
At my job we offer phpbb as a free forum if the client is interested. Well to my surprise I was getting asked to install phpbb bulletin boards like 5 a day. This started to become repetitive. So I wrote a script to perform my duties. This script will expand the files create the correct permissions. Create the database in mysql server and prepare the files. I am sure this can be modified for all mysql web based applications.

And I am sure that this is a sloppy poor attempt at script for experienced script writers. However I am learning fast.


You will execute this from the shell prompt using the clients name as the 1 argument. It has been working great for me....................

Stipulation!!!
You will need the phpbb.zip file in this location:

/export/home/phpuser/phpbb/install_files/

[root@forums1 bin]# ./create_phpbb_site.sh clientname

PHP Code:

#!/bin/bash

# jralph@job.com
# March 24, 2009 
# script to create nesessary directory structure for phpbb sites.

clientname=$1

if [ -e $clientname ] ;
then
  echo "Please give client name" ;
  exit;
fi

# change to correct directory
cd /export/home/phpuser/phpbb/install_files/

# copy the install zip to target directory.
cp phpBB-3.0.4.zip ../

# backup one directory step.
cd ..

# unzip the archive
unzip phpBB-3.0.4.zip

# Move to client folder.
mv phpBB3 $clientname

# Remove the install archive
rm -f phpBB-3.0.4.zip

#change ownership to our correct permissions
chown phpuser:ftpusers -R /export/home/phpuser/phpbb/$clientname/
chown nobody:ftpusers /export/home/phpuser/phpbb/$clientname/config.php

# Change permissions with chmod.
chmod -R 775 /export/home/phpuser/phpbb/$clientname/

# Change directories again
cd /export/home/phpuser/phpbb/$clientname/

# again change ownerships to all necessary files.
chown -R nobody:ftpusers files/
chown -R nobody:ftpusers store/
chown -R nobody:ftpusers styles/
chown -R nobody:ftpusers images/
chown -R nobody:ftpusers cache/

#create database and add schema privileges.
mysql -u root -p'sqlpassword' -e"create database  phpbb_$clientname"
mysql -u root -p'sqlpassword' -e"GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON phpbb_$clientname.* TO phpuser@'%' " 


Now just create the apache document root or vhost and proceed with the install. Or any other web servers docroot.

Hope you all can use this. And As I said. Experts, go easy on me.

Jaysunn

[rockdalinux]

Nice script. Can you modify it a bit:
Store all path in vars

clientname="$1"
wwr="/export/home/phpuser/phpbb"
path="$wwr/$clientname"

Now you can just use $path. What if /export/home/phpuser/phpbb changed on other servers?

# Change directories again
cd /export/home/phpuser/phpbb/$clientname/

# again change ownerships to all necessary files.
chown -R nobody:ftpusers files/
chown -R nobody:ftpusers store/
chown -R nobody:ftpusers styles/
chown -R nobody:ftpusers images/
chown -R nobody:ftpusers cache/

can be

chown -R nobody:ftpusers  $path/{files,store,styles,images,cache}

may be shorter..

chown -R nobody:ftpusers  $path/

remember small is beautiful and fast.. i hope i went easy on you..i no expert here though

[jaysunn]

chown -R nobody:ftpusers $path/{files,store,styles,images,cache}

@rockdalinux,

Sweet work on the curly braces. I know that this kind of usage has tremendous power. However I am still trying to grasp it.

Thanks for the insight.

Jaysunn

[vamsi]

wow..this is cool !!
thanks !

[vamsi]

sorry for double posting..but when I execute this
I get Please give client name
there's no input field..
btw running on Ubuntu

edit
after having a look at this.
here is the code I have written

PHP Code:

#!/bin/bash
read -p "Enter the user name : " name
mkdir $name
cd $name
wget http://mydesiredurlhere/app.zip
unzip app.zip
rm app.zip
cd app 
chmod 777 uploads
chmod 777 temp
/etc/init.d/apache2 restart
/etc/init.d/mysqld restart
echo "all done , enjoy :D " ; 


wow ..I am loving this ..very handy for some automation , so I am learning

[jaysunn]

Hi Vamsi,

Are you using the snippet from my script up above?

clientname=$1

if [ -e $clientname ] ;
then
  echo "Please give client name" ;
  exit;
fi

This is a test to make sure that you use a clientname for a variable.

You need to run the script as follows:

Prompt>./script clientname

What the if statement does is check for the $1 or command line variable. If not there. It replies "Please give client name"

Hope this makes sense.

Jaysunn