Hi,
I try to integrate an oracle-connection into my Exim and get very
strange failures.
Solaris 10 x86
Exim-4.69
Oracle-Client 10.2.0
ORACLE_HOME set to
/opt/app/oracle/product/10.2.0/client_1
+++++++++++
Exim version 4.69 #12 built 10-Jun-2008 17:09:50
Copyright (c) University of Cambridge 2006
Probably GDBM (compatibility mode)
Support for: OpenSSL Content_Scanning Old_Demime
Lookups: lsearch wildlsearch nwildlsearch iplsearch dbm dbmnz ldap
ldapdn ldapm oracle
Authenticators:
Routers: accept dnslookup ipliteral manualroute queryprogram redirect
Transports: appendfile/maildir autoreply pipe smtp
Fixed never_users: 0
Size of off_t: 8
Configuration file is /etc/exim/exim.test
++++++++++++
Config:
# ORACLE
hide oracle_servers = ora2000/ora2000/exim_gl/xxxxxxx
GREYLIST_TEST = select 2 from dual
warn set acl_m2 = ${lookup oracle{"GREYLIST_TEST"}{$value}{0}}
This config is just for testing - without any database-intelligence...
The result is crazy:
10:21:19 27795 ORACLE query: "select 2 from dual"
10:21:19 27795 ORACLE new connection: host=ora2000 database=ora2000
user=exim_gl
10:21:20 27795 ORACLE query failed: ORA-00900: Ungultige SQL-Anweisung
10:21:20 27795
10:21:20 27795 lookup deferred: ORACLE query failed: ORA-00900:
Ungultige SQL-Anweisung
But this is a valid query, tested in sqlplus:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select 2 from dual;
2
----------
2
Look like a problem in the exim-oracle-part....
Any ideas?
please inform if you need more informations....
Cheers
Christian
--
Christian Kuehn
eMail: christian@???
