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
Why does gateway crash after DB logging connection is lost?
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?
On the net probe why am I getting the error "ORA-06413: Connection not open" on 64-bit Windows when connecting to an Oracle Database?

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.