Installation and Configuration
39
no
vd
ocx
(e
n)
13
Ma
y 20
09
Creating a PlateSpin Orchestrate User for the PostgreSQL Database
Next, set up a PostgreSQL user to own the audit database schema before you run the server
configuration script or the GUI Configuration Wizard.
1
On the database host machine, use the following commands to log in as
root
at the database
host machine:
su - postgres
psql
2
At the
psql
prompt on the database host, use the following command to create an audit
database schema user, for example:
postgres=# create user zos password 'zos';
CREATE ROLE
NOTE:
Single quotes surrounding the password are required.
3
Enter the
\q
command at the
psql
prompt to exit the database.
Configuring the PlateSpin Orchestrate Audit Database on a Separate Host
The easiest way to configure the audit database is to do so when you configure the PlateSpin
Orchestrate Server. Use the following procedure to configure the database.
NOTE:
The questions presented in the text-based config script are shown here, but the questions
presented in the graphical Configuration Wizard are similar.
1
After you have installed the PlateSpin Orchestrate packages you want, run the configuration
(either the config script or the graphical Configuration Wizard) until you see the following
question:
Enable Auditing (y/n) [no]:
2
Enter
yes
to answer this question. The following question displays:
Configure Audit DB (y/n) [no]:
3
Enter
yes
to answer this question. The following question displays:
Jdbc URL [jdbc:postgresql://localhost/]:
4
Enter the URL of the server where PostgreSQL is running, then press Enter.
jdbc:postgresql://
IP_address_of_database_server
/
This is a standard JDBC* URL because this is a Java server that JDBC for the interface
database. The URL must be properly formed, with a slash and without a database name at the
end. We do not recommend using “localhost” as the URL.
The following prompt is displayed:
DB Admin Username:
5
Specify the PostgreSQL database administrator username, then press Enter.
This is the same username that was created when PostgreSQL was installed. In most instances,
the username is
postgres
.
The following prompt is displayed:
DB Admin Password:
Summary of Contents for PLATESPIN ORCHESTRATE 2.0.2
Page 4: ...4 PlateSpin Orchestrate 2 0 Installation and Configuration Guide novdocx en 13 May 2009...
Page 20: ...20 PlateSpin Orchestrate 2 0 Installation and Configuration Guide novdocx en 13 May 2009...
Page 98: ...98 PlateSpin Orchestrate 2 0 Installation and Configuration Guide novdocx en 13 May 2009...
Page 130: ...130 PlateSpin Orchestrate 2 0 Installation and Configuration Guide novdocx en 13 May 2009...