Re: [syslog-ng] unable to conect database with syslog-NG

3 Oct 2010

      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

From: syslog-ng-bounces@lists.balabit.hu
[mailto:syslog-ng-bounces@lists.balabit.hu] On Behalf Of PATRICK HEMMER
Sent: Thursday, September 30, 2010 5:37 PM
To: Syslog-ng users' and developers' mailing list
Subject: Re: [syslog-ng] unable to conect database with syslog-NG

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>
<mailto: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