Difference between revisions of "HelloWhiznium"

From
Jump to: navigation, search
Line 64: Line 64:
 
In the executable directory, run
 
In the executable directory, run
  
sqlite3 DbsHlwz.sql
+
sqlite3 DbsHlwz.sql<br>
sqlite3> .read ${WHIZROOT}/srcrep/hlwz/_ini/dbshlwz/CreateDbsHlwzLite.sql
+
sqlite3> .read ${WHIZROOT}/srcrep/hlwz/_ini/dbshlwz/CreateDbsHlwzLite.sql<br>
sqlite3> .quit
+
sqlite3> .quit<br>
  
 
As within sqlite3 the shell variable ${WHIZROOT} is unknown, you'll need to expand it manually.
 
As within sqlite3 the shell variable ${WHIZROOT} is unknown, you'll need to expand it manually.

Revision as of 10:33, 24 August 2019

Building HelloWhiznium


Running HelloWhiznium for the first time

The executable directory for the HelloWhiznium combined engine Hlwzcmbd is ${WHIZROOT}/bin/hlwzcmbd.

Copy the preferences file PrefHlwzcmbd.xml from ${WHIZROOT[_CCH]}/srcrep/hlzw/_ini/hlwzcmbd_<machine> to the executable directory.

Perform some required customizations:

<StgHlwzAppsrv>

<Si sref="port"> application server port of choice, e.g. 13100 </Si>
<Si sref="https"> true if you would like to use secure communication (see below) </Si>

</StgHlwzAppsrv>
<StgHlwzcmbd>

<Si sref="jobprcn"> number of job processor threads, should be at least 2 and otherwise match the number of cores </Si>
...

</StgHlwzcmbd>


<StgHlwzDatabase>

<Si sref="srefIxDbsVDbstype">my</Si>
...
<Si sref="dbsname">DbsHlwz</Si>
<Si sref="username">mpsitech</Si>
<Si sref="password">asdf1234</Si>
<Si sref="ip">127.0.0.1</Si>
<Si sref="port">3306</Si>

</StgHlwzDatabase>

- or -

<StgHlwzDatabase>

<Si sref="srefIxDbsVDbstype">lite</Si>
<Si sref="dbspath">$WHIZROOT/bin/hlwzcmbd/DbsHlwz.sql</Si>
...

</StgHlwzDatabase>


<StgHlwzPath>

<Si sref="acvpath"> $WHIZROOT/acv/hlwz </Si>
...
<Si sref="tmppath"> $WHIZROOT/tmp/hlwz </Si>
<Si sref="webpath"> $WHIZROOT/web/apphlwz </Si>
...

</StgHlwzPath>


If you would like to use HTTPS for the application server, you need to create a private/public key pair, e.g. using OpenSSL. In the executable directory, run:

openssl req -x509 -newkey rsa:4096 -keyout server.key -out server.pem -days 365

Set up the database:

MySQL database

sudo mysql -p < ${WHIZROOT}/srcrep/hlwz/_ini/dbshlwz/CreateDbsHlwzMy.sql

The two 'CREATE USER ...' lines need to be commented out in case the user already exists.

SQLite database

In the executable directory, run

sqlite3 DbsHlwz.sql
sqlite3> .read ${WHIZROOT}/srcrep/hlwz/_ini/dbshlwz/CreateDbsHlwzLite.sql
sqlite3> .quit

As within sqlite3 the shell variable ${WHIZROOT} is unknown, you'll need to expand it manually.