LVOware - free password management web application

Home || Documentation || Download || Terms of Use || Privacy ||

Installation of myPMS

Useful resources

Prerequisites

A web server with PHP module. I suggest Apache.
If you want to run this application over SSL, ensure you have the SSL module compiled into your web server as well.
MySQL database. Make sure the MySQL client compiled into the PHP module used by your web server is at the same version.
Download myPMS from here.

Information on how to install, configure and test the prerequisites can be found at the resource sites to the right of this page.

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

myPMS setup

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

Notes:

Enter the password when prompted for the MySQL root user.
For the application login, you do not have to use the MySQL root user account, you can create another one if you wish. This user must have select, insert, update and delete permissions on the mypms database tables. Additionally, you can create several users in MySQL for access to this application.

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.

Testing myPMS

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.

Important information

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.