Difference between revisions of "HelloWhiznium"
| Line 16: | Line 16: | ||
Set up the database: | Set up the database: | ||
| − | MySQL | + | MySQL database |
sudo mysql -p < ${WHIZROOT}/srcrep/hlwz/_ini/dbshlwz/CreateDbsHlwzMy.sql | sudo mysql -p < ${WHIZROOT}/srcrep/hlwz/_ini/dbshlwz/CreateDbsHlwzMy.sql | ||
| − | The 'CREATE USER ...' | + | The two 'CREATE USER ...' line needs 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 | ||
Revision as of 10:08, 24 August 2019
Building HelloWhiznium
Running HelloWhiznium for the first time
Copy the preferences file from ... to ... .
If you would like to use HTTPS server, you need to create a private/public key pair, e.g. using OpenSSL. In the executable directory, run
and rename the generated files
mv ... server.pem mv ... server.key
Set up the database:
MySQL database
sudo mysql -p < ${WHIZROOT}/srcrep/hlwz/_ini/dbshlwz/CreateDbsHlwzMy.sql
The two 'CREATE USER ...' line needs 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
