• Unzip the archived distribution to your webserver's document root. Or
• If you don't have direct access to your document root or use hosting service, then transfer the extracted directory to your web server's document root using FTP or WinSCP.
• Copy /config/config.dist.php to /config/config.php and adjust the settings for your environment.
• Important! The web server must have write access (0770) to /your-phpScheduleIt/tpl_c and /your-phpScheduleIt/tpl (want to know why?)
  • If using an FTP client, check read/write/execute for Owner and Group on /tpl, /tpl_c, and /uploads

• To configure the application, you can open /config/config.php and alter any settings accordingly. The admin email address can be set in the phpScheduleIt/config/config.php file of setting $conf['settings']['admin.email'].
  When later register an account with admin email address the user will be given admin privilege.
• In addition, to allow resource image uploads, the web-server must also have read/write access to your configurable uploads directory of $conf['settings']['image.upload.directory'] in the config.php.
• By default, phpScheduleIt uses standard username/password for user authentication. Alternatively, you can use LDAP authentication.
  See the plugins section of the application help page for more details.

• The automated database setup only supports MySQL at this time. To run the automated database setup, navigate to the /Web/install directory in a web browser and follow the on-screen instructions.
• Note: Some may see directory permission issues displayed on the page. The web server must have write access to /your-phpScheduleIt/tpl_c and /your-phpScheduleIt/tpl. If you cannot provide the required permission. Contact your web server administrator or hosting service to resolve or run the manual install.

On a remote host with no database creation privileges

If you are installing phpScheduleIt on a remote host, please follow these steps. These steps assume you are using cPanel and have the ability to create databases via the cPanel tool and phpMyAdmin.

Adding the database and user

• Select the MySQL Databases tool
• Add a new user with username and password of your choice. This will be the database user and database password set in your phpScheduleIt config file. Please be aware that some hosts will prefix your database user name.
• Create a new database with whatever name you choose. This will be the name of the database in your phpScheduleIt config file. 'phpScheduleIt2' is the recommended database name. Please be aware that some hosts will prefix your database name.
• Associate the new user with the new database, giving the user permission to SELECT, CREATE, UPDATE, INSERT and DELETE. Click the 'Add User to Db' button.

Creating tables

• Open phpMyAdmin.
• Click on the database name that you just created in the left panel.
• Click the SQL tab at the top of the page.
• Import "/database_schema/create-schema.sql" to phpscheduleit2 (or whatever database name was used in the creation process)
• Import "/database_schema/create-data.sql" to phpscheduleit2 (or whatever database name was used in the creation process)

If you have database creation privileges in MySQL

• Open "/database_schema/full-install.sql" and edit the database name and username/password to match your config.php database values
• Run or import "/database_schema/full-install.sql"
• Optionally - run/import "/database_schema/testdata-utf8.sql" to phpscheduleit2 (sample application data will be created with 2 users: admin/password and user/password). These users are available for testing your installation.

Recommended

The recommended approach is to backup your current phpScheduleIt files, then upload the new files to the that same location. This prevents any old files from interfering with new ones.

After the new files are uploaded, copy your old config/config.php file to the config directory in the new version. Then run /Web/install/configure.php to bring your config file up to date.

If you have any uploaded resource images you will need to copy them from their old location to the new one.

Alternative

An alternative upgrade approach is to overwrite the current phpScheduleIt files with the new ones. If doing this, you must delete the contents of /tpl_c. This approach will not allow you to roll back and will not clear out any obsolete files.

Database

After the application files have been upgraded you will need to upgrade the database.

Automatically

The automatic database upgrade is exactly the same as the automatic database install. Please follow the instructions in the Automatic Database Setup section above.

Manually