Booked Scheduler (formerly phpScheduleIt) Step by Step installation procedure
- Working Mysql Server
- Working Apache server
- PHP 4.3 or higher
1) INITIAL SETUP
Download the latest phpscheduleit software form http://www.bookedscheduler.com//
Transfer the file to your Apache server using winscp or some other file transfer method
extract the booked-2.x.x.zip on the web root
#cp booked-2.x.x.zip /var/www/html/booked/
Change the web directory ownership if required
#chown -R apache.apache *
Rename config/config.new.php to config/config.php and edit the file to be sure it is correct for your web server set up
#cp config/config.new.php config/config.php
2) APACHE CONFIGURATION:
Edit apache httpd.conf and add the following alias
Alias /booked “/var/www/html/booked”
#service httpd restart
3) CREATE DATABASE :
Create a Database. On the mysql server
#mysql -u root -p ( enter the mysql root password)
mysql> create database booked;
mysql> grant all privileges on booked.* to schedule_user@localhost identified by ‘mypassword’; /
If Apache server is different, replace localhost with your apache server ip
mysql> FLUSH PRIVILEGES;
4) EDIT CONFIG FILE:
Edit the config.php file and modify the required changes.
Most importantly, make sure that the ‘weburi’, ‘dbType’, ‘dbUser’, ‘dbPass’ and ‘dbName’ settings are correct
If the database not running localy, replace localhost with yourmysql serverip
$conf[‘db’][‘hostSpec’] = ‘localhost’;
Also you have to mention your database name ,username, password which you have created above ( Otherwise defailt values will be taken and DB Error will occure: insufficient permissions)
$conf[‘db’][‘dbUser’] = ‘schedule_user’;
$conf[‘db’][‘dbPass’] = ‘mypassword’;
$conf[‘db’][‘dbName’] = ‘booked‘;
Verify that the PEAR DB package, a PEAR supported database and PHP version 4.2.0 or greater are installed and properly configured on the destination server. If not, download and install at least these versions
a) Simply run the install script by navigating your browser to http://yourwebsite.com/booked/install/.
You will be asked for your database password.
Note that you do not need to log in as root, but the user needs to have permission to create and drop databases.
b) You will receive a confirmation or rejection notice about each command being executed. If everything goes well, you will receive a final notice that the installation was successful.
5.B) MANUAL SETUP:
The initial database must be set up. There is an included setup file for this. To execute the setup file in mysql, navigate to the MySQL executable directory (usually /usr/local/mysql/bin) and at the shell prompt type the following.
#mysql -u root -p < %path to directory%/install/setup.sql
#mysql -u root -p < /var/www/html/booked/install/setup.sql
6) DELETE THE ‘INSTALL’ DIRECTORY.
This is a critical step. If the directory is left, then anyone is open to destroy your newly created database.
Now you can start using the application.