I'm running on Redhat 6 and want to use the im_dbi module to read a log table form Oracle.
I understand the general configuration elements because I can get it all towork with PostgreSQL but I can't seem to get the configuration correct for Oracle. I always get the error Error - ORA-12154: TNS:could not resolve the connect identifier specified Code: 12154 2019-04-25 13:16:23 ERROR im_dbi couldn't connect to the database, check the im_dbi Options. Connect::Unable to login to the database. My config is <Input db2in> Module im_dbi Driver oracle PollInterval 1.0 Option hostname "csogen1d.uvic.ca:1521/GEN1D" Option host "myhostname" Option port "1521" Option dbname"GEN1D" Option username "dbuser" Option password "dbpassword" SQL select TABLE_ID as id , DATES, LOGGER_LEVEL, APP_NAME, MESSAGE from mytable <Exec> $SyslogFacility = 'local5'; $SourceName = $APP_NAME; $Hostname = "myhostname"; $Message = $MESSAGE"; </Exec> </Input> Has anyone worked with the im_dbi (or om_dbi) to an Oracle Database before? Evan. _______________________________________________ nxlog-ce-users mailing list nxlog-ce-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nxlog-ce-users
