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
What is Database Logging and how does it work?
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?
Why do I get the error "ORA-06413: Connection not open" when connecting to an Oracle Database from Windows Netprobe?
How can I resolve the error ORA-08177: can't serialize access for this transaction

See more

Self help

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

June 30, 2017 23:29

Yes. There are scripts for MySQL, Oracle, 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

Comments

0 comments

Please sign in to leave a comment.