[INUG-Users] Omnibus nco_gate vs. MySQL on Linux, can it be done?

trefalgar at realitybytes.net trefalgar at realitybytes.net
Tue Apr 1 10:51:23 EDT 2008 

The official IBMuse products do not support MySQL. Try using looper,  
it works pretty well as a gateway.

Jacob

Quoting Christian Hirth <pipe2null at gmail.com>:

> Hi inug,
>
>
>
> I know there has been a lot said about nco_gate and MySQL, but now   
> after spending some hours browsing the archive, I am still pretty   
> much lost on whether it can be done or not, so!!!!
>
>
>
> I have a redhat server running MySQL 4.1.16 and want my nco_gate   
> v.7.0.1.16 to transport alerts.status, alerts.journal data into the   
> MySQL server, can it be done?
>
>
>
> Below I have attached my odbc.ini and the nco_gate.conf file
>
>
>
> I keep getting the error that, the datasource is not working!   
> Although I can connect to the db using the same user from same   
> source host via mysql prompt…
>
>
>
> [root at dogbert etc]# nco_gate -name MYSQL_GATE -debug
>
> Netcool/OMNIbus SMP Gateway Server - Version 7
>
> Copyright (C) 1994,2003, Micromuse Inc.
>
> Log file is: /opt/netcool/omnibus/log/MYSQL_GATE.log
>
> Server 'MYSQL_GATE' initialised.
>
> Loading configuration ...
>
> Error: Failed to add writer at line 123
>
> Error loading config file '/opt/netcool/omnibus/etc/MYSQL_GATE.conf'.
>
>
>
>
>
> ODBC.INI
>
> [ODBC Data Sources]
>
> DB2=DataDirect 4.1 DB2 Wire Protocol Driver
>
> INFORMIX=DataDirect 4.1 Informix
>
> MSSQL=DataDirect 4.1 SQL Server Wire Protocol
>
> SYBASE=DataDirect 4.1 Sybase Wire Protocol
>
> ORACLE=DataDirect 4.1 Oracle Wire Protocol
>
> MYSQL=MyODBC 2.50 MySQL
>
>
>
> [REPORTER]
>
> Driver=/usr/lib/libmyodbc.so
>
> Setup=/usr/lib/libodbcmyS.so
>
> Database=REPORTER
>
> FileUsage=1
>
> CPTimeout=
>
> CPReuse=
>
> Trace=1
>
> TraceFile=$OMNIHOME/log/myodbc.log
>
>
>
>
>
> MYSQL_GATE.conf
>
> #START READER NCOMS_READ CONNECT TO BINGO USING FILTER EXCLUDE;
>
> START READER BINGO_READER CONNECT TO BINGO;
>
>
>
> #
>
> # Start up the writer
>
> #
>
> START WRITER MYSQL_WRITER
>
> (
>
>         INI_FILE = '/opt/odbc/system_odbc.ini',
>
>         TYPE = ODBC,
>
>         REVISION = 1,
>
>         MODULE_REVISION = 2,
>
>         DATA_SOURCE = REPORTER,
>
>         SOURCE_SERVER = 'BINGO',
>
>
>
>         USERNAME = 'root',
>
>         PASSWORD = '1qaz',
>
>
>
>         STATUS_TABLE_MAP = STATUS_MAP,
>
>         DETAILS_TABLE_MAP = DETAILS_MAP,
>
>         JOURNAL_TABLE_MAP = JOURNAL_MAP,
>
>
>
>         STATUS_TABLE = 'REPORTER.REPORTER_STATUS',
>
>         DETAILS_TABLE = 'REPORTER.REPORTER_DETAILS',
>
>         JOURNAL_TABLE = 'REPORTER.REPORTER_JOURNAL',
>
>
>
>         FORWARD_INSERTS = TRUE,
>
>         FORWARD_UPDATES = TRUE,
>
>         FORWARD_DELETES = FALSE
>
>
>
> );
>
>
>
> #
>
> # Add a route from the reader to the writer so the info gets passed
>
> #
>
> ADD ROUTE FROM BINGO_READER TO MYSQL_WRITER;
>
>
>
>
>
> [root at dogbert etc]# cat ../log/MYSQL_GATE.log
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Server initialised.
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: Reader 'BINGO_READER':   
> Flush time is set to '0'.
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: Reader 'BINGO_READER':   
> Journal flush time is set to '0'.
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: Making the connection...
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: Connection established.
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: IDUC connection established.
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: Reader 'BINGO_READER':   
> Connected to primary ObjectServer.
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: Store and forward is enabled.
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: ODBC config file:   
> '/opt/odbc/system_odbc.ini'
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: Store file:   
> '/opt/netcool/omnibus/var/MYSQL_GATE_REPORTER.store'
>
> Apr  1 09:35:29 2008: MYSQL_GATE :ODBC writer 'MYSQL_WRITER' using   
> table 'REPORTER.REPORTER_STATUS' for status data.
>
> Apr  1 09:35:29 2008: MYSQL_GATE :ODBC writer 'MYSQL_WRITER' using   
> table 'REPORTER.REPORTER_JOURNAL' for journal data.
>
> Apr  1 09:35:29 2008: MYSQL_GATE :ODBC writer 'MYSQL_WRITER' using   
> table 'REPORTER.REPORTER_DETAILS' for details data.
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: Fwd historic alerts.journal  
>  entries is disabled.
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: Fwd historic alerts.details  
>  entries disabled.
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: Making the connection...
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: Connection established.
>
> Apr  1 09:35:29 2008: MYSQL_GATE :ODBC Writer: Starting ODBC Module   
> - [/opt/netcool/omnibus/bin/linux2x86/nco_odbc_rwmodule REPORTER   
> root 1qaz].
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: ODBC Writer: Starting   
> Reader/Writer Module   
> '/opt/netcool/omnibus/bin/linux2x86/nco_odbc_rwmodule' in write mode.
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: ODBC Writer: Base name of   
> constructed module log filename [MYSQL_GATE_%s_WRITE.log].
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Error: ODBC Writer: Nothing on the  
>  pipe to read.
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Error: ODBC Writer: Failed to read  
>  the Reader/Writer modules status ready response.
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Error: ODBC Writer: Reader/Writer   
> Module '/opt/netcool/omnibus/bin/linux2x86/nco_odbc_rwmodule' launch  
>  failed. Check Reader/Writer modules log file in $OMNIHOME/log.
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Error: ODBC Writer: Failed to   
> start the writer module.
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Error: Failed to launch ODBC Writer module.
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Error: Connect failed for writer   
> 'MYSQL_WRITER'
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: Server Shutdown requested   
> at non-interrupt level.
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: Server shutdown thread has   
> been awoken.
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: Signal Handler: SIGCHLD   
> signal received.
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Server shutting down due to   
> SRV_STOP event ...
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: RouteMgrStop()
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: WriteMgrStop()
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: ReadMgrStop()
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: Reader thread   
> 'BINGO_READER' - stopping.
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: Reader thread   
> 'BINGO_READER' - stopped.
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: MapMgrStop()
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: FilterMgrStop()
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: ResyncMgrStop()
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: XRefCacheStop()
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: LookupStop()
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: LockMgrStop()
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: LicenseStop()
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Checking in license feature "nco_gate".
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: ClockStop()
>
> Apr  1 09:35:29 2008: MYSQL_GATE :Debug: Signal Handler: SIGCHLD   
> signal received.
>
> Apr  1 09:35:30 2008: MYSQL_GATE :Debug: Stop() COMPLETE
>
>
>
>
>
> [root at dogbert etc]# cat ../log/MYSQL_GATE_ODBC_RW_WRITE.log
>
> Successful redirect of stderr to log file.
>
>
>
> ODBC Read/Write Module - Version 7
>
> Release ID: 7.0.1.16
>
>
>
> Compile Date: Mon Sep 27 11:39:23 BST 2004 on itchy (Linux   
> 2.4.18-19.7.xsmp #1 SMP Thu Dec 12 07:56:58 EST 2002)
>
>
>
> Run Status: [/opt/netcool/omnibus/bin/linux2x86/nco_odbc_rwmodule]   
> started at Tue Apr  1 09:35:29 2008.
>
> Apr 01 09:35:29 2008:[DEBUG]: ODBC Module using value 60 for reconnect time
>
> Apr 01 09:35:29 2008:[DEBUG]: In ODBCInit
>
> Apr 01 09:35:29 2008:[DEBUG]: At end of ODBCInit
>
> Apr 01 09:35:29 2008:[DEBUG]: ODBC Writer: License file name =[IVJA.LIC]
>
> Apr 01 09:35:29 2008:[DEBUG]: In ODBCConnect
>
> Apr 01 09:35:29 2008:[DEBUG]: at end of ODBCConnect
>
> Apr 01 09:35:29 2008:[DEBUG]: Retrieving ODBC error message
>
> Apr 01 09:35:29 2008:[DEBUG]: Got error code, it is [100] and   
> sqlState is [￿￿￿G]
>
> Apr 01 09:35:29 2008:[ERROR]: SQL_NO_DATA_FOUND
>
> Apr 01 09:35:29 2008:[ERROR]: Unknown ODBC connection error for ODBC writer.
>
> .
>
> Apr 01 09:35:29 2008:[ERROR]: Failed to connect to the data source   
> [REPORTER]. Check your data source configuration.
>
> Apr 01 09:35:29 2008:[DEBUG]: in ODBCDisconnect, disconnected flag=[0]
>
> Apr 01 09:35:29 2008:[DEBUG]: At end of ODBCDisconnect, disconnected flag=[1]
>
> Run Status: [/opt/netcool/omnibus/bin/linux2x86/nco_odbc_rwmodule]   
> stopped at Tue Apr  1 09:35:29 2008.
>
>
>
>
>
>
>
> _______________________________________________
> Sent by the netcoolusers.org "users" mailing list
> Post: users at netcoolusers.org
> Unsubscribe: users-unsubscribe at netcoolusers.org
> Search: http://netcoolusers.org/Search
>

More information about the Users mailing list