Versions Compared

Old Version 18

changes.mady.by.user Chris Welford

Saved on

compared with

New Version 19

changes.mady.by.user Dominic Sandhu

Saved on

Key

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

...

Creating the database user is heavily dependent on the database platform, and will often have to be varied to meet local requirements regarding naming and security. These example commands will be adequate for basic installations.

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:

Start a session the database:

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;
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
languagexml
<property name="url">
	<value>jdbc:oracle:thin:@[SERVER IP ADDRESS]:1521:[SID<value>[CONNECTION STRING]</value>
</property>
<property name="username">
	<value>[USERNAME]</value>
</property>
<property name="password">
	<value>[PASSWORD]</value>
</property>

See Database URLs for how to specify URLs for the various database platforms supported by PhixFlow.

...