See below for creating the Validation Authority database in the DBMS of your choice.

The syntax of the below commands assumes a Linux operating system. Running these commands on a Windows machine may require a different syntax – for example, evaluating the <var> variables with the %<var>% syntax.

Creating the database on Oracle 

Run the certstatus_ initial_schema.sql and metadata_initial_schema.sql scripts to create the database objects on Oracle.

sqlplus "$USERNAME/$PASSWORD@tcp://$HOSTNAME/$DBNAME" @./certstatus_initial_schema.sql
sqlplus "$USERNAME/$PASSWORD@tcp://$HOSTNAME/$DBNAME" @./metadata_initial_schema.sql

Run the create_users.sql script to create the database users on Oracle.

sqlplus "$USERNAME/$PASSWORD@tcp://$HOSTNAME/$DBNAME" @./create_users.sql $USERNAME $STATUSFEEDER_DB_USER $STATUSFEEDER_DB_PASSWORD $OCSPRESPONDER_DB_USER $OCSPRESPONDER_DB_PASSWORD

Creating the database on PostgreSQL 

Run the certstatus_initial_schema.sql and metadata_initial_schema.sql scripts to create the database objects on PostgreSQL.

PGPASSWORD=$PASSWORD psql -d $DBNAME -U $USERNAME -h $HOSTNAME -v "ON_ERROR_STOP=1" -f ./certstatus_initial_schema.sql
PGPASSWORD=$PASSWORD psql -d $DBNAME -U $USERNAME -h $HOSTNAME -v "ON_ERROR_STOP=1" -f ./metadata_initial_schema.sql

Run the create_users.sql script to create the database users on PostgreSQL.

PGPASSWORD=$PASSWORD psql -d $DBNAME -U $USERNAME -h $HOSTNAME \
-v STATUSFEEDER_DB_USER=$STATUSFEEDER_DB_USER \
-v OCSPRESPONDER_DB_USER=$OCSPRESPONDER_DB_USER \
-v STATUSFEEDER_DB_PASSWORD=$STATUSFEEDER_DB_PASSWORD \
-v OCSPRESPONDER_DB_PASSWORD=$OCSPRESPONDER_DB_PASSWORD \
-v "ON_ERROR_STOP=1" -f ./create_users.sql

Creating the database on SQL Server 

Run the certstatus_ initial_schema.sql and metadata_initial_schema.sql scripts to create the database objects on SQL Server.

sqlcmd -S "$HOSTNAME" -U "$USERNAME" -P $PASSWORD -v DBNAME="$DBNAME" -i ./certstatus_initial_schema.sql
sqlcmd -S "$HOSTNAME" -U "$USERNAME" -P $PASSWORD -v DBNAME="$DBNAME" -i ./metadata_initial_schema.sql

Run the create_users.sql script to create the database users on SQL Server.

sqlcmd \
-S "$HOSTNAME" -U "$USERNAME" -P $PASSWORD \
-v STATUSFEEDER_DB_USER="$STATUSFEEDER_DB_USER" \
-v OCSPRESPONDER_DB_USER="$OCSPRESPONDER_DB_USER" \
-v STATUSFEEDER_DB_PASSWORD="$STATUSFEEDER_DB_PASSWORD" \
-v OCSPRESPONDER_DB_PASSWORD="$OCSPRESPONDER_DB_PASSWORD" \
-v DBNAME="$DBNAME" \
-i ./create_users.sql