Versions Compared

Old Version 5

changes.mady.by.user Chris Welford

Saved on

compared with

New Version Current

changes.mady.by.user Fiona Sargeant (Unlicensed)

Saved on

Key

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

Introduction

The schema installation has 4 main steps, regardless of platform:

...

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

Create the database user

If you are  Database Administrator (DBA) and no database / login have previously been set up, you should use the following commands to create a new database / user.

...

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:

This command requires the user, the password, the login and the database to be provided as parameters.

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"


MySQL: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


Populate the Database

Once you have created the database and/or database user, run the Installer to create the database tables and initial data.

...

Code Block
java -jar bin/installer.jar -url="jdbc:sqlserver://myhost\myserver;databaseName=phixflow" -user=myuser -pass=mypass -install -customer="Your Customer Name"

MySQLMariaDB:

Code Block
java -jar bin/installer.jar -url="jdbc:mysqlmariadb://localhost/phixflow" -user=<myuser> -pass=<mypass> -install -customer="Your Customer Name"

...