New System Setup

decubitisannouncerΔιαχείριση Δεδομένων

27 Νοε 2012 (πριν από 4 χρόνια και 8 μήνες)

424 εμφανίσεις

Professional
Using a PostgreSQL Database
Introduction
PostgreSQL is an SQL-based database that may be used for systems with higher performance needs. In most
cases, the default CyberAudit-Web database handles operations with satisfactory performance. Larger numbers
of locks and keys, higher levels of activity, or larger volumes of audit trail data may necessitate the use of
PostgreSQL. This document describes the necessary steps to either set up a new system using PostgreSQL, or
to convert an existing system.
Computers should have a minimum of 2GB of RAM to run CyberAudit-Web Professional with PostgreSQL.
New System Setup - Windows Computers
Follow these steps to set up a new system with a PostgreSQL database:
1. Install the CyberAudit-Web Professional software from the disk but do not launch it. If performing a
server installation, stop the Tomcat service prior to registering CyberAudit-Web. If the desktop system
has already been started, stop the CyberAudit-Web service using the right-click menu on its system tray
icon (
).
2. Install PostgreSQL from the “Advanced” section of the CyberAudit-Web Professional installation disk.
The computer must be restarted after installation.
3. Using a text editor such as WordPad, open the “pro.properties” file.

The default location of this file for a standard (desktop) installation is:
C:\Program Files\Videx\CyberAudit-Web Professional Desktop\jetty\webapps

The default location of this file for a server installation is:
C:\Program Files\Videx\CyberAudit-Web Professional Server\tomcat\webapps
4. Change the database type, host, user, and password properties to reflect the following:
database.type=POSTGRES
#The IP address of the database server
database.host=localhost
#The database user name
database.user=videx
#The database password
database.pswd=aq12ws
5. Start CyberAudit-Web Professional. This will also start the CyberAudit-Web Professional web service.
On server version installations, stop and restart Tomcat.
6. Register the software according to the instructions found in the “CyberAudit-Web Professional
Installation and Troubleshooting Guide.”
New System Setup - Macintosh Computers
Follow these steps to set up a new system (requires Version 1.1.24 or higher) with a PostgreSQL database:
1. Install CyberAudit-Web Professional, but do not log in to it.
2. Adjust the kernel memory settings. Open the Terminal application. If the user account does not
have administrator rights, issue the command “su <account>”, where <account> is the name of an
administrator account. Provide the password for the administrator account when prompted.

Issue the following command to open the appropriate file:

sudo /Applications/TextEdit.app/Contents/MacOS/TextEdit /etc/sysctl.conf
Lines that begin with a “#” character are comments. The final seven commented lines in the file contain
the memory settings recommended by Videx. If these settings are not specified earlier in the file,
remove the “#” from the beginning of each line, save the file, and quit the TextEdit application. If these
settings are already specified in the file, it is up to the individual user to determine the best settings for
their system. A good rule of thumb is to keep the complete set of either the existing settings or the Videx
settings, which reserves more memory.
Ensure that the sysctl.conf file has the correct permissions and ownership. Issue these commands:

sudo chmod 644 /etc/sysctl.conf
sudo chown root:wheel /etc/systcl.conf
Reboot the computer for the new memory settings to take effect.
3. Stop the CyberAudit-Web Professional web server (Tomcat) in the System Preferences.
4. Install PostgreSQL from the CyberAudit-Web Professional disk.
5. When prompted, create a password for the database superuser. This example will use
“postgres321abc,” which is the default for a Videx installation.

6. Click the “Next” button, accepting all the default options, until the final Setup screen appears.

7. Uncheck the box labeled “Launch Stack Builder at exit?” and click the “Finish” button.
8. Open Applications and launch “SQL Shell (psql)” from the “PostgreSQL 8.3” folder.

Press the “return” key four times to accept the default values for the server connection and enter the
password for the “postgres” superuser when prompted.
At the “postgres=#” prompt, enter the following command:

CREATE ROLE videx WITH INHERIT LOGIN CREATEDB CREATEROLE PASSWORD ‘aq12ws’;
The reply after the command should be “CREATE ROLE.” Type “\q” to exit the shell.

9. Open the Terminal application. If the user account does not have administrator rights, issue the
command “su <account>”, where <account> is the name of an administrator account. Provide the
password for the administrator account when prompted.
10. Issue the following commands:

cd /Library/Tomcat/webapps
sudo /Applications/TextEdit.app/Contents/MacOS/TextEdit ./pro.properties
11. Change the database type, host, user, and password properties to reflect the following:

database.type=POSTGRES

#The IP address of the database server
database.host=localhost

#The database user name
database.user=videx

#The database password
database.pswd=aq12ws
database.type=POSTGRES
#The IP address of the database server
database.host=localhost
#The database user name
database.user=videx
#The database password
database.pswd=aq12ws
12. Save the changes and quit the TextEdit application.
13. Issue the following command:

sudo chown _www:staff ./pro.properties
14. Install the Videx Postgres Enabler from the installation disk.
15. Start Tomcat from the System Preferences pane.
16. Click the “Log In” button to launch CyberAudit-Web Professional.

17. Register the software according to the instructions found in the “CyberAudit-Web Professional
Installation and Troubleshooting Guide.”
Converting an Existing System to PostgreSQL
To convert an existing system (requires Version 1.1.24 or higher) to PostgreSQL, follow these steps:
1. Create a backup file by selecting the “Backup” option from the “System” menu in CyberAudit-Web
Professional.
2. Follow the PostgreSQL installation steps detailed above (Steps 2-6 for Windows installations, Steps 2-17
for Macintosh installations).
3. When prompted to choose a source for the database, select the option “Restore a CyberAudit-Web
Professional backup.”
4. Specify the backup file created in Step 1.
GCO 2579