asterisk users - May 2004 - Asterisk not loading data into table using cdr_odbc

Hi

I have problems trying to load asterisk call data into the cdr table using
cdr_odbc config.

My unixODBC is properly configured and it's working fine (able to connect,
load data, query tables, etc.).
unixodbc is configured to use easysoft Oracle ODBC library.
Table cdr was created following instructions in asterisk wiki site.
My /etc/asterisk/cdr_odbc.conf is configured as follow:

[global]
dsn=oracle
username=asterisk
password=manager
;loguniqueid=yes  I don't use uniqueid !


I noticed that /usr/lib/asterisk/modules/cdr_odbc.so library is missing so I
can't include it in modules.conf under /etc/asterisk

I tried to compile cdr_odbc.c but failed with a lot of errors!

A config exemples is highly appreciated or any other help.

Other infos: Using Linux RED HAT 9 with glibc 2.3.2-5, gcc 3.2.2-5
----------------
my odbc.ini file:
----------------
[oracle]
Description             = oracle
Driver          = oracle
Database                = asterisk
User            = system
Password                = asterisk
ENABLE_USER_CATALOG             = 1
ENABLE_SYNONYMS         = 1
METADATA_ID             METADATA_DONT_CHANGE_CASE              
OCI_ATTR_PREFETCH_ROWS          OCI_ATTR_PREFETCH_MEMORY               
DBI_LONG_SIZE           DATA_TYPE_MAP           REPORT_LONGS            = 1
NO_LOBS         ------------------
my odbcinstall.ini
------------------
[oracle]
Description             = oracle
Driver          = /usr/local/easysoft/oracle/libesoracle.so
Setup           = /usr/local/easysoft/oracle/libesoraclesetup.so
FileUsage               = 1
CPTimeout               CPReuse         =

That means your unixodbc header files aren't in the right place.  Try to
modify cdr/Makefile

This is what we do in the Makefile to tell if unixODBC is installed.

MODS+=$(shell if [ -f "/usr/include/odbcinst.h" ]; then echo
"cdr_odbc.so";
fi)
MODS+=$(shell if [ -f "/usr/local/include/odbcinst.h" ]; then echo
"cdr_odbc.so"; fi)


Or you can add this right below the MODS=cdr_csv.so:

MODS+=cdr_odbc.so

AND PRAY it works.

bkw

> -----Original Message-----
> From: asterisk-users-admin@lists.digium.com [mailto:asterisk-users-
> admin@lists.digium.com] On Behalf Of Mourad Ben Othman
> Sent: Wednesday, May 12, 2004 9:27 AM
> To: asterisk-users@lists.digium.com
> Subject: [Asterisk-Users] Asterisk not loading data into table using
> cdr_odbc
>
> Hi
>
> I have problems trying to load asterisk call data into the cdr table using
> cdr_odbc config.
>
> My unixODBC is properly configured and it's working fine (able to
connect,
> load data, query tables, etc.).
> unixodbc is configured to use easysoft Oracle ODBC library.
> Table cdr was created following instructions in asterisk wiki site.
> My /etc/asterisk/cdr_odbc.conf is configured as follow:
>
> [global]
> dsn=oracle
> username=asterisk
> password=manager
> ;loguniqueid=yes  I don't use uniqueid !
>
>
> I noticed that /usr/lib/asterisk/modules/cdr_odbc.so library is missing so
> I
> can't include it in modules.conf under /etc/asterisk
>
> I tried to compile cdr_odbc.c but failed with a lot of errors!
>
> A config exemples is highly appreciated or any other help.
>
> Other infos: Using Linux RED HAT 9 with glibc 2.3.2-5, gcc 3.2.2-5
> ----------------
> my odbc.ini file:
> ----------------
> [oracle]
> Description             = oracle
> Driver          = oracle
> Database                = asterisk
> User            = system
> Password                = asterisk
> ENABLE_USER_CATALOG             = 1
> ENABLE_SYNONYMS         = 1
> METADATA_ID             > METADATA_DONT_CHANGE_CASE               >
OCI_ATTR_PREFETCH_ROWS          > OCI_ATTR_PREFETCH_MEMORY               
> DBI_LONG_SIZE           > DATA_TYPE_MAP           > REPORT_LONGS     
= 1
> NO_LOBS         > ------------------
> my odbcinstall.ini
> ------------------
> [oracle]
> Description             = oracle
> Driver          = /usr/local/easysoft/oracle/libesoracle.so
> Setup           = /usr/local/easysoft/oracle/libesoraclesetup.so
> FileUsage               = 1
> CPTimeout               > CPReuse         >
>
>
>
>
>
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users