...
Code Block |
---|
cd $RELEASE/phixflow-x.y.z-yyyymmdd/install |
Oracle:
Code Block |
---|
java -jar bin/installer.jar -url="jdbc:oracle:thin:@hostname@localhost:1521:phixflow |
...
" -user=myuser -pass=mypass -install -customer="Your Customer Name" |
SQL Server:
Code Block |
---|
jdbc:oracle:thin:@hostname:1521/phixflow |
Info |
---|
The only difference between the connection strings is to use a '/' instead of':' before [SID], so that [SID] is treated as a SERVICE name rather than an SID. This is due to Oracle 12c introducing pluggable databases (PDB's). |
SQL Server:
Code Block |
---|
java -jar bin/installer.jar -url="jdbc:sqlserver://hostnamemyhost\myservicemyserver;databaseNamedatabase=phixflow" -user=myuser -pass=mypass -install -customer="Your Customer Name" |
MySQL:
Code Block |
---|
java -jar bin/installer.jar -url="jdbc:mysql://hostnamelocalhost/phixflow" -user=myuser -pass=mypass -install -customer="Your Customer Name" |
Further information on the installer
...
Code Block | ||
---|---|---|
| ||
<property name="url"> <value>[CONNECTION STRING]</value> </property> <property name="username"> <value>[USERNAME]</value> </property> <property name="password"> <value>[PASSWORD]</value> </property> |
Connection Strings
...
See also Database URLs for how to specify connection string URLs for the various database platforms supported by PhixFlow.
Once you have created the database and/or database user, run the Installer to create the database tables and initial data.
The customer name in the commands below must exactly match the customer name used by PhixFlow Support to generate licence files. This argument (–customer="Your Customer Name") is optional, but without a valid customer name and matching licence key you will not be able to run any tasks in PhixFlow.
Code Block |
---|
cd $RELEASE/phixflow-x.y.z-yyyymmdd/install |
...