On 10/24/05, Matthew Lenz <[EMAIL PROTECTED]> wrote:
>
> for the search engines.
>
> I did find that DBD::Informix 2005.2 does not play well with Debian
> Sarge's 1.46-6 dbi package. I had to install DBI 1.48 to get it
> (DBD::Informix 2005.2) to compile.
>
> On Fri, 2005-10-21 at 13:49 -0500, Matt
For those of you that use MySQL, this should be
welcome news, that version 5.0.x is now
officially stable, at 5.0.15.
Speaking just personally, the recommended minimum
versions of certain database products to use with
my upcoming rewritten database access modules are
the following; they are
Matthew Dougerty [mailto:[EMAIL PROTECTED] wrote:
>
> I'm assuming that those characters are part of the text. I assume the
> last
> text field is:
> 'H4vgmf+OJsT99kCfQuIpALY7k9k=')<*>;'
>
> This way the SQL statement ends like:
> 'H4vgmf+OJsT99kCfQuIpALY7k9k=')<*>;')
>
> The interpreter does
I'm assuming that those characters are part of the text. I assume the last
text field is:
'H4vgmf+OJsT99kCfQuIpALY7k9k=')<*>;'
This way the SQL statement ends like:
'H4vgmf+OJsT99kCfQuIpALY7k9k=')<*>;')
The interpreter doesn't know which ') to stop at.
matt.
On Mon, 24 Oct 2005 16:59:17 -040
The problem, as a couple people have already pointed out, is the semicolon.
(There is no problem with newlines or single quotes here.) The semicolon
after a statement is SQL*PLUS syntax. It is not valid in DBD::Oracle.
Ronald
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMA
Syslog-ng is writing those sql insert statements for us, we just pick them
up, make a sha1, base64 encode that and then sign it with a digital
certificate and insert the whole thing into Oracle.
-Original Message-
From: Chris Sarnowski [mailto:[EMAIL PROTECTED]
Sent: Monday, October 24,
You seem to have a single quote in the text.
You might want to use $dbh->quote($_) instead of qq.
Matt Dougherty
On Mon, 24 Oct 2005 13:01:14 -0500, Ward.P.Fontenot wrote
> I have the following sql insert statement in a file:
>
> INSERT INTO message(FULLDATE,HOSTNAME,FACILITY,PRIORITY,MESSAGE,
Paul,
It seems you must have some program or script that converts
the syslog info into a SQL statement. I'd recommend moving this
processing into your DBI script, i.e.
$insert_statement = $dbh->prepare(
q/INSERT INTO message
(FULLDATE,HOSTNAME,FACILITY,PRIORITY,MESSAGE,SHA1)
VALUES(?, ?, ?, ?, ?
Hello,
when rereading my own mail, I must correct. This sets only the current
transaction into read only and not the connection.
And it fails if the current transaction was already writing.
Tuesday, October 18, 2005, 4:59:12 PM, I wrote:
WP> Tuesday, October 18, 2005, 2:18:56 PM, you wrote:
TB>>
This runs as a CRON job loading syslog data into Oracle so SQL*Plus is not a
good answer. Thanks for help though.
-Original Message-
From: Reidy, Ron [mailto:[EMAIL PROTECTED]
Sent: Monday, October 24, 2005 11:08 AM
To: Fontenot, Ward P.; dbi-users@perl.org
Subject: RE: Newline inserted?
If your file has a '\n' in it, it cannot possibly be an issue with DBI
or Oracle v anything.
Are you processing individual SQL statements (does your file contain SQL
insert statements)? If so, DBI is not your best bet to do this. I
would rethink this and:
a. Use SQL*Plus to load the file:
sqlp
I think you need to remove the semicolon at the end of the line.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 24, 2005 2:01 PM
> To: dbi-users@perl.org
> Subject: Newline inserted?
>
>
> I have the following sql insert statement in a
I have the following sql insert statement in a file:
INSERT INTO message(FULLDATE,HOSTNAME,FACILITY,PRIORITY,MESSAGE,SHA1)
VALUES('2005-Oct-18 11:53:21','pkitest.wellsfargo.com','auth
','info','su(pam_unix)[3638]: session opened for user oracle by
root(uid=0)','H4vgmf+OJsT99kCfQuIpALY7k9k=');
Whe
for the search engines.
I did find that DBD::Informix 2005.2 does not play well with Debian
Sarge's 1.46-6 dbi package. I had to install DBI 1.48 to get it
(DBD::Informix 2005.2) to compile.
On Fri, 2005-10-21 at 13:49 -0500, Matthew Lenz wrote:
> never mind, found the setting. DBD_INFORMIX_NO_E
14 matches
Mail list logo
