If you have already created the OpenClinic database when installing an older version, follow these steps:
- Go to the install PHP script.
In the section Install a SQL File, choose the right file in
- If does not exist a correct upgrade file, skip to step 7 of next section.
Install a web server such as Apache that can execute cgi applications.
If you are running Linux, your Apache server should be packaged with your Linux installation and will start when you start Linux.
Install the MySQL database from MySQL web site.
If you are running Linux, MySQL should be packaged with your Linux installation and will start when you start Linux.
Get familiar with logging into MySQL with your admin account within a DOS prompt window. You can use the following command sequence as a test.
C:\>c:\mysql\bin\mysql -u root -p mysql Enter password: ********* Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: x.xx.xx Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> show databases; +--------------+ | Database | +--------------+ | mysql | | test | +--------------+ 2 rows in set (0.00 sec) mysql> exit Bye C:\>
Create an openclinic database. To do this, log into MySQL with your admin account and run the following SQL command.
mysql> create database openclinic;
To check to make sure the openclinic database was created properly run the following command.
mysql> show databases; +--------------+ | Database | +--------------+ | mysql | | openclinic | | test | +--------------+ 3 rows in set (0.00 sec)
Create an openclinic database user. To do this login to MySQL under the admin userid and run the following SQL command, substituting openclinic_user and openclinic_password with the userid and password of your choice.
mysql> grant all privileges on openclinic.* to openclinic_user@localhost -> identified by 'openclinic_password' with grant option;
Verify your openclinic database and user by logging into the new MySQL database under the new user.
C:\>C:\mysql\bin\mysql -u openclinic_user -popenclinic_password openclinic
- Copy the openclinic directory and all of its contents into your web server's htdocs root or any subdirectory within the htdocs root.
database_constants.phpfile (located in the
openclinic/config/directory) with the text editor of your choice. Change username and password to match the new MySQL user and password that you created in the previous steps.
- Create the openclinic database tables. To do this run the install PHP script.
testsdirectories writtable for Apache user to allow upload files.
Access your new clinic system. Enter
adminfor both, the login and password whenever you are prompted to sign on. You can change the admin password from the Admin » Users.