h2databasetcpserver
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
h2databasetcpserver [2016/03/06 19:26] – [H2DatabaseTCPServer] pela | h2databasetcpserver [2018/11/03 02:59] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 12: | Line 12: | ||
The readonly values displayed at the top shows the outcome of the configuration. | The readonly values displayed at the top shows the outcome of the configuration. | ||
- | * **TCP ConnectionString** shows the internal address to the database server, for example // | + | * **TCP ConnectionString** shows the internal address to the database server, for example // |
* **TCP Status** shows the status of the database server, for example //Running, remotes can connect// | * **TCP Status** shows the status of the database server, for example //Running, remotes can connect// | ||
- | * **WEB ConnectionString** shows the address to the web console. Depending on the **WEB public** setting this value may show localhost:8082 (not public) | + | * **WEB ConnectionString** shows the address to the web console. Depending on the **WEB public** setting this value may show as http:// |
- | * **WEB Status**shows the status of the web console, for example //Running, remotes can connect// | + | * **WEB Status** shows the status of the web console, for example //Running, remotes can connect// |
Note, the web connection string may show https for public access but you may still not be able to access the console. This is because the home item can't know if the SSL is enabled or not. If so, access the web console using http and preferably change via preferences to use SSL (Use encrypted SSL (HTTPS) connections). | Note, the web connection string may show https for public access but you may still not be able to access the console. This is because the home item can't know if the SSL is enabled or not. If so, access the web console using http and preferably change via preferences to use SSL (Use encrypted SSL (HTTPS) connections). | ||
+ | |||
===== Functions ===== | ===== Functions ===== | ||
* Start and Stop TCP Service is for the H2 Database server itself. | * Start and Stop TCP Service is for the H2 Database server itself. | ||
Line 35: | Line 36: | ||
//Note: You may have to stop and start the service(s) if you change any of the settings.// | //Note: You may have to stop and start the service(s) if you change any of the settings.// | ||
- | ===== Configure global logging to the database ===== | + | ====== Configure global logging to the database |
- | Following these steps will enable global logging of all value items to the database. The database named **nhs_values** will be created with a user named **sa** and the password will be set to **SuperSecretPa$$w0rd**. | + | Following these steps will enable global logging of all value items to the database. |
- | | + | In this example the database will be named **nhs_values** and created with a user named **sa** and the password will be set to **SuperSecretPa$$w0rd**. |
- | | + | |
- | | + | - Go to the Settings page and enter a GlobalLogger value as **jdbc: |
+ | | ||
+ | | ||
The Log view will display additional information about the logging activity. | The Log view will display additional information about the logging activity. | ||
Note! Always use a hard to guess password if you intend to have the Web console public. | Note! Always use a hard to guess password if you intend to have the Web console public. | ||
+ | |||
+ | The **jdbc: | ||
===== Change user and password ===== | ===== Change user and password ===== | ||
(Un)fortunately it is not easy to change the user name and password. | (Un)fortunately it is not easy to change the user name and password. | ||
Line 56: | Line 61: | ||
- The import will start and it can take some time before all values have been imported. | - The import will start and it can take some time before all values have been imported. | ||
- View and periodically refresh the Log page for progress of the import. | - View and periodically refresh the Log page for progress of the import. | ||
+ | |||
+ | ====== View graphs ====== | ||
+ | When you want to view graphs of the logged data, click the **View graph...** link for home items. | ||
+ | |||
+ | Please note that the database server will cache the result on successive views. This means that the first view will take slightly longer but successive views will be faster. This is in any case several times faster than reading the logs from the text files. | ||
==== See also ==== | ==== See also ==== | ||
http:// | http:// |
h2databasetcpserver.txt · Last modified: 2018/11/03 02:59 by 127.0.0.1