...
| Code Block | ||
|---|---|---|
| ||
mysql -u root -pPASSWORD -e "CREATE DATABASE openaudit;" mysql -u root -pPASSWORD -e "CREATE USER openaudit@localhost IDENTIFIED BY 'openauditpassword';" mysql -u root -pPASSWORD -e "GRANT ALL PRIVILEGES ON openaudit.* TO openaudit@localhost IDENTIFIED BY 'openauditpassword';" mysql -u root -pPASSWORD -e "FLUSH PRIVILEGES;" |
- Insert the database schema
| Code Block | ||
|---|---|---|
| ||
mysql -u root -pPASSWORD openaudit < /usr/local/open-audit/other/openaudit_mysql.sql |
...
- Setup configuration items
...
- to ensure Open-AudIT can find Open-AudIT Enterprise to display the icon links in the header of Open-AudIT.
...
- As before, replace
PASSWORDwith the database password that you just set.
| Code Block | ||
|---|---|---|
| ||
mysql -u root -popenauditrootuserpasswordpPASSWORD -e "USE openaudit; DELETE FROM oa_config WHERE config_name = 'maps_url'; INSERT INTO oa_config (config_name, config_value, config_editable, config_description) VALUES ('maps_url', 'http://IPADDRESS/omk/oae/map', 'y', 'The web server address of Maps for Open-AudIT Enterprise.');" mysql -u root -popenauditrootuserpasswordpPASSWORD -e "USE openaudit; DELETE FROM oa_config WHERE config_name = 'oae_url'; INSERT INTO oa_config (config_name, config_value, config_editable, config_description) VALUES ('oae_url', 'http://IPADDRESS/omk/oae', 'y', 'The web server address of Open-AudIT Enterprise.');" |
Note: If Open-AudIT and Open-AudIT Enterprise are installed on different servers then you'll need to change the maps_url and oae_url into absolute ones that contain the IP address.
Test the Website
You should now be able to access the web page at http://IPADDRESS/index.php Assuming you can, proceed to the next section.
...