- \n
- \u00a0 Working Mysql Server<\/li>\n
- \u00a0 Working Apache server<\/li>\n
- \u00a0 PHP 4.3 or higher<\/li>\n
- \u00a0 PEAR::DB<\/li>\n<\/ul>\n
1) INITIAL SETUP<\/b><\/h3>\n
Download the latest phpscheduleit software form http:\/\/www.bookedscheduler.com\/<\/a><\/b>\/
\nTransfer the file to your Apache server using winscp or some other file transfer method<\/p>\nextract the booked-2.x.x.zip on the web root<\/p>\n
#mkdir \/var\/www\/html\/booked
\n#cp booked-2.x.x.zip\u00a0<\/b>\/var\/www\/html\/booked<\/b>\/
\n#cd \/var\/www\/html\/booked<\/b>\/
\n#unzip booked-2.x.x.zip<\/b><\/b><\/p>\nChange the web directory ownership if required<\/p>\n
#chown -R apache.apache *<\/b><\/p>\n
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<\/p>\n
#cp config\/config.new.php config\/config.php<\/b><\/p>\n
2) APACHE CONFIGURATION:<\/b><\/h4>\n
Edit apache httpd.conf and add the following alias
\n#vim \/etc\/httpd\/conf\/httpd.conf<\/b>
Alias \/booked “\/var\/www\/html\/booked”<\/b>
#service httpd restart<\/b><\/p>\n3) CREATE DATABASE :<\/b><\/h4>\n
Create a Database. On the mysql server
\n#mysql -u root -p ( enter the mysql root password)
\nmysql> create database booked;
\nmysql> grant all privileges on booked.* to schedule_user@localhost identified by ‘mypassword’;\u00a0 \/ <\/b><\/p>\nIf Apache server is different, replace localhost with your apache server ip<\/p>\n
mysql> FLUSH PRIVILEGES;
\nmysql>show databases;
\nmysql> exit <\/b><\/p>\n4) EDIT CONFIG FILE:<\/b><\/h4>\n
Edit the config.php file and modify the required changes.<\/p>\n
Most importantly, make sure that the ‘weburi’, ‘dbType’, ‘dbUser’, ‘dbPass’ and ‘dbName’ settings are correct<\/p>\n
If the database not running localy, replace localhost with yourmysql serverip
\n$conf[‘db’][‘hostSpec’] = ‘localhost’;<\/b>
\nAlso 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)<\/p>\n$conf[‘db’][‘dbUser’] = ‘schedule_user’;
\n$conf[‘db’][‘dbPass’] = ‘mypassword’;
\n$conf[‘db’][‘dbName’] = ‘booked<\/b>‘;<\/b><\/p>\nVerify 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<\/p>\n
5.A)AUTOMATIC INSTALLATION<\/b><\/h4>\n
a) Simply run the install script by navigating your browser to http:\/\/yourwebsite.com\/booked\/install\/<\/b>.<\/p>\n
You will be asked for your database password.<\/p>\n
Note that you do not need to log in as root, but the user needs to have permission to create and drop databases.<\/p>\n
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.<\/p>\n
<\/p>\n
![\"Booked](\"https:\/\/www.melberi.com\/linuxadmin\/wp-content\/uploads\/sites\/3\/2010\/08\/phpscheduleit.jpg\" "\\"Booked")
<\/div>\n<\/p>\n
![\"booked\"](\"https:\/\/www.melberi.com\/linuxadmin\/wp-content\/uploads\/sites\/3\/2010\/08\/phpscheduleit2.jpg\" "\\"booked\\"")
<\/div>\n<\/p>\n
![\"AUTOMATIC](\"https:\/\/www.melberi.com\/linuxadmin\/wp-content\/uploads\/sites\/3\/2010\/08\/phpscheduleit3.jpg\" "\\"AUTOMATIC")
<\/div>\n<\/p>\n
5.B) MANUAL SETUP:<\/b><\/h4>\n
<\/p>\n
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.<\/p>\n
#mysql -u root -p < %path to directory%\/install\/setup.sql
\n#mysql -u root -p < \/var\/www\/html\/booked\/install\/setup.sql<\/b><\/p>\n6) DELETE THE ‘INSTALL’ DIRECTORY.\u00a0<\/b><\/h4>\n
This is a critical step. If the directory is left, then anyone is open to destroy your newly created database.
\nNow you can start using the application.<\/p>\nhttp:\/\/yourwebsite.com\/booked<\/b><\/p>\n
![\"AUTOMATIC](\"https:\/\/www.melberi.com\/linuxadmin\/wp-content\/uploads\/sites\/3\/2010\/08\/phpscheduleit4.jpg\" "\\"AUTOMATIC")
<\/div>\n<\/p>\n
RELATED POST:
\nLDPA AUTH<\/b><\/p>\n","protected":false},"excerpt":{"rendered":"Booked Scheduler (formerly phpScheduleIt) Step by Step installation procedure REQUIREMENTS \u00a0 Working Mysql Server \u00a0 Working Apache server \u00a0 PHP 4.3 or higher \u00a0 PEAR::DB 1) INITIAL SETUP Download the… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":297,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[106,93],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/posts\/120"}],"collection":[{"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/comments?post=120"}],"version-history":[{"count":7,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/posts\/120\/revisions"}],"predecessor-version":[{"id":468,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/posts\/120\/revisions\/468"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/media\/297"}],"wp:attachment":[{"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/media?parent=120"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/categories?post=120"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.melberi.com\/linuxadmin\/wp-json\/wp\/v2\/tags?post=120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}