[Asterisk-Users] Asterisk not loading data into table using cdr_odbc

[brian]

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 at lists.digium.com [mailto:asterisk-users-
> admin at lists.digium.com] On Behalf Of Mourad Ben Othman
> Sent: Wednesday, May 12, 2004 9:27 AM
> To: asterisk-users at 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 at 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