UNSUBSCRIBE On Thu, 25 Apr 2019 at 21:25, Evan Rempel <erem...@uvic.ca> wrote:
> > 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 >
_______________________________________________ nxlog-ce-users mailing list nxlog-ce-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nxlog-ce-users
