...
Change the owner and group of the release package to tomcat:cviewphixflow:
chown phixflow-x.y.z-yyymmdd.zip tomcat:cviewphixflow
Switch to the tomcat user (makes sure that login scripts are run. The syntax for this may vary between operating systems:
...
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:
...
.
...
...
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="cview" dbLogin="cview" dbUser="cview" 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 cview;
grant all privileges on cview.* 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:oracle:thin:@localhost:1521:cviewphixflow" -user=myuser -pass=mypass -install -customer="Your Customer Name" |
...
Code Block |
---|
java -jar bin/installer.jar -url="jdbc:sqlserver://myhost\myserver;database=cviewphixflow" -user=myuser -pass=mypass -install -customer="Your Customer Name" |
...
Code Block |
---|
java -jar bin/installer.jar -url="jdbc:mysql://localhost/cviewphixflow" -user=myuser -pass=mypass -install -customer="Your Customer Name" |
...