Hi,

 

I am using Enterprise Linux 5 update 5 (32 bit) and I can see these below RPM in CD itself but not libdbi-dbd-oracle. I am doing googling from a week but don’t see the specified libdbi-dbd-oracle driver/source/RPM. Please provide the same.

 

I am using libdbi-0.8.1-2.1.i386.rpm

libdbi-dbd-mysql-0.8.1a-1.2.2.i386.rpm

libdbi-devel-0.8.1-2.1.i386.rpm

libdbi-drivers-0.8.1a-1.2.2.i386.rpm

 

After a long research I can see 64 bit from libdbi-dbd-oracle using the link below but I need 32 bit version. Please help me.

 

 

http://www.users.fh-salzburg.ac.at/~asartori/aconet/syslog-ng/RPMS/

 

Thanks

Anis

 

0968-99826412

 

 

 

You need libdbi-dbd-oracle

-Patrick

Sent: Thu Sep 30 2010 02:50:18 GMT-0600 (Mountain Daylight Time)
From: Anisur Rehman(IT) <Rehman@bankmuscat.com>
To: syslog-ng@lists.balabit.hu
Subject: [syslog-ng] unable to conect database with syslog-NG

Hi,

Presently I have these below issues on syslog-ng open source version.

I have installed SYSLOG-NG version 3.x on Linux RHEL 4.x and it is

working fine and able to send log to text file. Now I like to send the

message to oracle database. 

[oracle@wkwasl02 etc]$ cat syslog-ng.conf

@version: 3.0

options{

};

source gateway {

unix-stream("/dev/log");

internal();

udp(ip(0.0.0.0)port(514));

};

source tcpgateway {

unix-stream("/dev/log");

internal ();

tcp(ip(0.0.0.0)port(514) max_connections(1000));

};

destination localhost {

file("/var/log/syslog-ng.all");

};

destination tcplocalhost {

file("/var/log/tcpsyslog-ng.all");

};

destination d_mysql {

pipe("/opt/syslog-ng/var/mysql.pipe"

template("INSERT INTO logs (host, facility, priority, level, tag, date,

time, program, msg) VALUES ('$HOST', '$FACILITY', '$PRORITY', '$LEVEL',

'$TAG', '$YEAR-$MONTH-$DAY', '$HOUR:$MIN:$SEC', '$PROGRAM', '$MSG');\n")

template-escape(yes));

};

destination d_oracle {pipe("/dev/ora.pipe"template("exec syslog.log (

'$HOST', '$FACILITY', '$PRIORITY', '$SEVERITY', '$TAG', to_date('$MONTH

$DAY

$HOUR:$MIN:$SEC', 'mm dd hh24:mi:ss'), '$PROGRAM',

substr('$MSG',1,511));\n

COMMIT;\n")template-escape(yes)); };

destination d_sql {

sql(type(oracle)

username("syslog") password("syslog")

database("syslogNG")

table("msgs_${R_YEAR}${R_MONTH}${R_DAY}")

columns("datetime varchar(16)", "host varchar(32)", "program

varchar(32)", "pid varchar(8)", "message varchar2")

values("$R_DATE", "$HOST", "$PROGRAM", "$PID", "$MSGONLY")

indexes("datetime", "host", "program", "pid", "message"));

};

log {

    source(gateway);destination(localhost);

};

log {

    source(tcpgateway);destination(tcplocalhost);

};

log {

source(tcpgateway);destination(d_mysql);destination(d_oracle);destinatio

n(d_sql);

};

[oracle@wkwasl02 etc]$

[root@wkwasl02 ~]# tail -f /var/log/tcpsyslog-ng.all

Sep 29 11:20:01 wkwasl02 syslog-ng[32139]: No such DBI driver;

type='oracle'

Thanks

Anisur Rehman

Oman,muscat

0968-99826412

______________________________________________________________________________

Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng

Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng

FAQ: http://www.campin.net/syslog-ng/faq.html