Database Service - Revision history

Kenric at 06:08, 16 December 2022

2022-12-16T06:08:25Z

← Older revision		Revision as of 06:08, 16 December 2022
Line 24:		Line 24:
	Once the service is running, a "target" indicator will appear in the right-hand column - clicking this will display a debug console to allow you to monitor service activity:		Once the service is running, a "target" indicator will appear in the right-hand column - clicking this will display a debug console to allow you to monitor service activity:
	[[File:PRS Database Console.png\|none\|thumb]]		[[File:PRS Database Console.png\|none\|thumb]]
	Since this log is reset when the debug console is closed, a full log can be found in a log file which is saved to the "Local System" service account's AppData folder. ~~On 64-bit Windows, this~~ can be found under "C:\Windows\~~SysWOW64~~\config\systemprofile\AppData\Roaming\PRSServer\PRSDatabase" folder as a ".log" file.		Since this log is reset when the debug console is closed, a full log can be found in a log file which is saved to the "Local System" service account's AppData folder. This can be found under "C:\Windows\System32\config\systemprofile\AppData\Roaming\PRSServer\PRSDatabase" folder as a ".log" file.

Kenric at 08:23, 21 June 2022

2022-06-21T08:23:14Z

← Older revision		Revision as of 08:23, 21 June 2022
Line 24:		Line 24:
	Once the service is running, a "target" indicator will appear in the right-hand column - clicking this will display a debug console to allow you to monitor service activity:		Once the service is running, a "target" indicator will appear in the right-hand column - clicking this will display a debug console to allow you to monitor service activity:
	[[File:PRS Database Console.png\|none\|thumb]]		[[File:PRS Database Console.png\|none\|thumb]]
	Since this log is reset when the debug console is closed, a full log can be found in a log file which is saved to the "Local System" service account's AppData folder. On 64-bit Windows, this can be found under ~~the~~ "C:\Windows\SysWOW64\config\systemprofile\AppData\Roaming\PRSServer\PRSDatabase" folder as a ".log" file.		Since this log is reset when the debug console is closed, a full log can be found in a log file which is saved to the "Local System" service account's AppData folder. On 64-bit Windows, this can be found under "C:\Windows\SysWOW64\config\systemprofile\AppData\Roaming\PRSServer\PRSDatabase" folder as a ".log" file.

Kenric at 08:22, 21 June 2022

2022-06-21T08:22:42Z

← Older revision		Revision as of 08:22, 21 June 2022
Line 25:		Line 25:
	[[File:PRS Database Console.png\|none\|thumb]]		[[File:PRS Database Console.png\|none\|thumb]]
	Since this log is reset when the debug console is closed, a full log can be found in a log file which is saved to the "Local System" service account's AppData folder. On 64-bit Windows, this can be found under the "C:\Windows\SysWOW64\config\systemprofile\AppData\Roaming\PRSServer\PRSDatabase" folder as a ".log" file.		Since this log is reset when the debug console is closed, a full log can be found in a log file which is saved to the "Local System" service account's AppData folder. On 64-bit Windows, this can be found under the "C:\Windows\SysWOW64\config\systemprofile\AppData\Roaming\PRSServer\PRSDatabase" folder as a ".log" file.


	Once the service is successfully running, you can move on to adding and configuring additional services as required:		Once the service is successfully running, you can move on to adding and configuring additional services as required:

Kenric at 08:22, 21 June 2022

2022-06-21T08:22:17Z

← Older revision		Revision as of 08:22, 21 June 2022
Line 24:		Line 24:
	Once the service is running, a "target" indicator will appear in the right-hand column - clicking this will display a debug console to allow you to monitor service activity:		Once the service is running, a "target" indicator will appear in the right-hand column - clicking this will display a debug console to allow you to monitor service activity:
	[[File:PRS Database Console.png\|none\|thumb]]		[[File:PRS Database Console.png\|none\|thumb]]
	~~This~~ log file is saved to the "Local System" service account's AppData folder~~, which on~~ 64-bit Windows can be found in the "C:\Windows\SysWOW64\config\systemprofile\AppData\Roaming\PRSServer\PRSDatabase" folder as a ".log" file.		Since this log is reset when the debug console is closed, a full log can be found in a log file which is saved to the "Local System" service account's AppData folder. On 64-bit Windows, this can be found under the "C:\Windows\SysWOW64\config\systemprofile\AppData\Roaming\PRSServer\PRSDatabase" folder as a ".log" file.

	Once the service is successfully running, you can move on to adding and configuring additional services as required:		Once the service is successfully running, you can move on to adding and configuring additional services as required:

Kenric at 08:20, 21 June 2022

2022-06-21T08:20:18Z

← Older revision		Revision as of 08:20, 21 June 2022
Line 24:		Line 24:
	Once the service is running, a "target" indicator will appear in the right-hand column - clicking this will display a debug console to allow you to monitor service activity:		Once the service is running, a "target" indicator will appear in the right-hand column - clicking this will display a debug console to allow you to monitor service activity:
	[[File:PRS Database Console.png\|none\|thumb]]		[[File:PRS Database Console.png\|none\|thumb]]
			This log file is saved to the "Local System" service account's AppData folder, which on 64-bit Windows can be found in the "C:\Windows\SysWOW64\config\systemprofile\AppData\Roaming\PRSServer\PRSDatabase" folder as a ".log" file.

	Once the service is successfully running, you can move on to adding and configuring additional services as required:		Once the service is successfully running, you can move on to adding and configuring additional services as required:

Prs at 13:49, 21 May 2022

2022-05-21T13:49:43Z

← Older revision		Revision as of 13:49, 21 May 2022
Line 26:		Line 26:
	Once the service is successfully running, you can move on to adding and configuring additional services as required:		Once the service is successfully running, you can move on to adding and configuring additional services as required:

	* Add an [[Auto Discovery Service]] to allow client workstations to automatically find and connect to this database		* Add an [[AutoDiscovery Service\|Auto Discovery Service]] to allow client workstations to automatically find and connect to this database
	*Add a [[GPS Gateway Service]] to capture incoming GPS data from Digital Matter IoT devices		*Add a [[GPS Gateway Service]] to capture incoming GPS data from Digital Matter IoT devices
	*Add a [[Scheduler Service]] to perform regular actions on you database		*Add a [[Scheduling Service\|Scheduler Service]] to perform regular actions on you database
	*		*

Prs at 13:47, 21 May 2022

2022-05-21T13:47:05Z

← Older revision		Revision as of 13:47, 21 May 2022
Line 26:		Line 26:
	Once the service is successfully running, you can move on to adding and configuring additional services as required:		Once the service is successfully running, you can move on to adding and configuring additional services as required:

	* Add an Auto Discovery Service		* Add an [[Auto Discovery Service]] to allow client workstations to automatically find and connect to this database
			*Add a [[GPS Gateway Service]] to capture incoming GPS data from Digital Matter IoT devices
			*Add a [[Scheduler Service]] to perform regular actions on you database
	*		*

Prs at 13:44, 21 May 2022

2022-05-21T13:44:37Z

← Older revision		Revision as of 13:44, 21 May 2022
Line 24:		Line 24:
	Once the service is running, a "target" indicator will appear in the right-hand column - clicking this will display a debug console to allow you to monitor service activity:		Once the service is running, a "target" indicator will appear in the right-hand column - clicking this will display a debug console to allow you to monitor service activity:
	[[File:PRS Database Console.png\|none\|thumb]]		[[File:PRS Database Console.png\|none\|thumb]]
	Once the service is successfully running, you can move on to adding and configuring additional services as required.		Once the service is successfully running, you can move on to adding and configuring additional services as required:

			* Add an Auto Discovery Service
			*

Prs: Created page with "thumb The PRS database service is the engine room of PRS, providing access to one or more PRS databases. In most cases, only one main database is required - however, there may be circumstances (for instance, multiple divisions or companies using the same infrastructure) where more than one database service may be running at the same time. To add a database service, click the "Add Service" button at the bottom righ..."

2022-05-21T13:42:47Z

Created page with "none|thumb The PRS database service is the engine room of PRS, providing access to one or more PRS databases. In most cases, only one main database is required - however, there may be circumstances (for instance, multiple divisions or companies using the same infrastructure) where more than one database service may be running at the same time. To add a database service, click the "Add Service" button at the bottom righ..."

New page

[[File:PRS Database Service Account Settings.png|none|thumb]]
The PRS database service is the engine room of PRS, providing access to one or more PRS databases. In most cases, only one main database is required - however, there may be circumstances (for instance, multiple divisions or companies using the same infrastructure) where more than one database service may be running at the same time.

To add a database service, click the "Add Service" button at the bottom right of the screen, and select "Database":
[[File:PRS Add Database.png|none|thumb]]
The Database Properties screen will appear, allowing you to customise the service as required:
[[File:PRS Database Service General Settings.png|none|thumb]]

* The "Name" field provides a description of the database, which can be automatically provided to clients if the AutoDiscovery Service is enabled

* The "File Name" filed indicates the location of the (not-yet-created) database itself - click the "Select" button at the right to choose a location and file name for the database. If you have an existing database file, you can select this here to use the existing data - it will not be overwritten or erased.
* The "Port" field indicates the TCP port that the database service will listen on for client requests. This port should be configured to allow traffic through any firewalls you may have installed.

To ensure that the service can be validly installed on your system, click on the "Account" tab, and enter the Domain, User name and Password for an account that has privileges to install services on your system:
[[File:PRS Database Server Account Details.png|none|thumb]]
(If you are using a local account, use "." as the Domain Name)

At this point you should see the Database Service appear in the list of available services:
[[File:PRS Database Service Status.png|none|thumb]]
The "Disk" image at the left indicates that this service is a Database.

The "Pause" image indicates that the service currently stopped - click this will start the service, after which the image will change to a "tick":
[[File:PRS Database Service - Running.png|none|thumb]]
Once the service is running, a "target" indicator will appear in the right-hand column - clicking this will display a debug console to allow you to monitor service activity:
[[File:PRS Database Console.png|none|thumb]]
Once the service is successfully running, you can move on to adding and configuring additional services as required.