Why is Database Logging not working ?
How do I fix the error WARN: DBLogger::updateCellLogValueFailed Failed to lookup dataitem '<XPath>', log success state may be invalid?
How To Solve The Error - "ct_connect(): protocol specific layer: internal Client Library error: There is a tds login error. The installed encryption handler returned a status that was not CS_SUCCEED"
Connecting to MySQL and MariaDB from a 32-bit Solaris Gateway
Gateway database logging, performance and .dat dump files
Does the var_ref value in Database Logging have a maximum limit?
The Database Logging Gateway plugin
My Geneos data is stored in Oracle, but the indexes do not reduce when I delete data?
How can I resolve the error ORA-08177: can't serialize access for this transaction
What is the format of the timestamp column in ITRS Geneos database?

See more

Self help

FAQ

["FAQ"]

Are there scripts available for creating the tables that Geneos requires in a database?

March 03, 2021 03:33
Updated

Yes. There are scripts for MySQL, Oracle, PostgreSQL, SQL Server and Sybase.

The scripts can be located in the Gateway binary folder:

<Gateway_binary_folder>/resources/database/<database>/

e.g.

/home/user/binaries/gateway/prod/resources/databases/oracle

The scripts are:
- schema-1.X.sql for creating the schema
- update-1.X.sql for updating an existing schema

Tags:

Comments

0 comments

Please sign in to leave a comment.