Versions Compared

Version Old Version 14 New Version 15
Changes made by

Chris Welford

Chris Welford

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Platform

Create the database user

Oracle:

This command will prompt for the name of the user to be created.

Code Block
sqlplus SYS/SYSPassword@SID as SYSDBA @schema/oracle/install/create_user


Sql Server:

Before creating the database, ensure that default collation is Latin1_General_CI_AS:

Code Block
SELECT SERVERPROPERTY('collation');
SELECT DATABASEPROPERTYEX('phixflow', 'Collation'); USE master; GO IF DB_ID (N'MyOptionsTest') IS NOT NULL DROP DATABASE MyOptionsTest; GO CREATE DATABASE MyOptionsTest COLLATE Latin1_General_100_CS_AS_SC; GO --Verify the collation setting. SELECT name, collation_name FROM sys.databases WHERE name = N'MyOptionsTest'; GO
This command requires the user, the password, the login and the database to be provided as parameters
If it is not, please talk to the database administrator to get this updated to the required collation (see also Install MS SQL Server).
This command creates a local (SQL Server) login, a user with required user mappings, sets the password for the login and creates the database.
 Code Block
sqlcmd -S localhost\myservice -i schema/sql_server/install/create_database_and_user.sql -v dbName="phixflow" dbLogin="phixflow" dbUser="phixflow" dbPassword="mypass"

MariaDB:
 Anchor
mariaDBexampleDBcreateCommand
mariaDBexampleDBcreateCommand
Connect to the database as root (or an administrator):
 Code Block
mysql --user=<myrootuser> --password
Create the user, supplying the name of the database, the user and the password in the commands below:
 Code Block
create database phixflow CHARACTER SET = 'utf8' COLLATE = 'utf8_bin';
grant all privileges on phixflow.* to '<myuser>'@'%' identified by '<mypass>';
exit

...
 Code Block
cd $RELEASE/phixflow-x.y.z-yyyymmdd/install

OracleSQL Server:
 Note
If a database, with login details, was provided (i.e. you did not perform the step above for creating the login, user and database), please check that the database has the correct collation:
 Code Block
SELECT DATABASEPROPERTYEX('DBNAME', 'Collation');
E.g.
 Code Block
SELECT DATABASEPROPERTYEX('phixflow', 'Collation');

Then run the command:
 Code Block
java -jar bin/installer.jar -url="jdbc:oracle:thin:@localhost:1521:sqlserver://myhost\myserver;databaseName=phixflow" -user=myuser -pass=mypass -install -customer="Your Customer Name"
Oracle (> 12c with PDB containers)MariaDB:
 Code Block
java -jar bin/installer.jar -url="jdbc:oracle:thin:@hostname:1521mariadb://localhost/phixflow" -user=myuser<myuser> -pass=mypass<mypass> -install -customer="Your Customer Name"
SQL Server:
...
Oracle:
 Code Block
java -jar bin/installer.jar -url="jdbc:sqlserver://myhost\myserver;databaseName=:oracle:thin:@localhost:1521:phixflow" -user=myuser -pass=mypass -install -customer="Your Customer Name"
MariaDBOracle (> 12c with PDB containers):
 Code Block
java -jar bin/installer.jar -url="jdbc:oracle:thin:mariadb@hostname://localhost1521/phixflow" -user=<myuser>myuser -pass=<mypass>mypass -install -customer="Your Customer Name"
...