|Installation of myPMS||Useful resources|
Web server setup
Once you have a working web server with PHP and MySQL installed, ensure everything works by placing a file named "phpinfo.php" in your web server DocumentRoot with the contents:
<?php phpinfo(); ?>
Access this page in a web browser like so: http://YourServerName/phpinfo.php
If you don't get a page with the PHP configuration, there is something wrong. Stop here and correct it before continuing any further.
If you got the PHP information page, now you can setup a virtual host on your web server. Here is an example using Apache:
NameVirtualHost *:80 <VirtualHost *:80> DocumentRoot /usr/local/apache/htdocs/mypms ServerName mypms.yourdomain.com ServerAlias mypms ErrorLog logs/mypms-error_log CustomLog logs/mypms-access_log common </VirtualHost>
You can modify any of the names or paths for the VirtualHost as you wish.
Make sure your web server recognizes the "index.php" start page. If you are using Apache, look for a line like this in your httpd.conf file:
DirectoryIndex index.html index.php index.htm
Now, you are ready to start the installation of myPMS.
First, extract the gzipped tar file you downloaded in your DocumentRoot with the command:
# gzip -dc mypms.tar.gz | tar xf -
Note: the extract will create a directory named "mypms". Next, go into the directory where you extracted the tar file and you will create the MySQL database and tables needed for the application with the command:
# mysql -u root -p < mypms.sql
If you are not familiar with MySQL administration, get phpMyAdmin. A link is provided on the right of this page.
Finally, as a last step, insure the files in your myPMS DocumentRoot are readable by the user your web server runs as. If you are running a flavour of UNIX on your web server and the web server runs as the user "nobody", issue these commands:
# chown -R nobody myPMS_DocumentRoot # chmod -R 755 myPMS_DocumentRoot
Note: replace myPMS_DocumentRoot with your real DocumentRoot directory name.
You are now ready to test myPMS. In a web browser, type the name of the ServerName in the VirtualHost you created for myPMS. In my case, it would be: http://mypms.yourdomain.com.
When prompted for a username and password, either enter the MYSQL root user account information, or the information of the account you created specifically for this application.
Begin entering your password information !
If at this point you cannot get things working, back track to ensure you did not miss any important steps. If you believe you did everything properly but things just don't work, send an email to us with as much detail as possible.
If you decide you want to use SSL for this application, go ahead but you are on your own to setup the certificate and complete the web server setup. Please do not contact us for help on this. There are plenty of helpful sites on the Internet explaining how to do this anyhow.
Apache web server
PHP scripting language web site
MySQL database web site
MySQL database backup script
MySQL database restore script
phpMyAdmin MySQL administration application
Like any data, make sure you have backups in case of a failure. Minimally, I suggest you run a MySQL database dump daily.
For Unix servers, a link is provided above which has a mysqldump script and another on how to restore your MySQL database in case of failure.