CDR to Oracle Database

Has anyone actually got this working?
Can you let me know the details?
:smile:

[quote=“mjmarrio”]Has anyone actually got this working?
Can you let me know the details?
:smile:[/quote]

We just did. Try this:

  1. If you plan to use the CDR radius of 1.4, you need to include the following flag when running the “configure”:

    ./configure --with-radius=/usr/local

Without it, the installation will go through, and you may even see cdr_radius.so there and loaded successfully. But it will not work! … Unless you include the above flag. … Asterisk/Digium should really provide this information somehow :frowning:(

  1. After the “configure”, “make” and “make install”, if you get an error similar to the following:

WARNING[21369]: loader.c:362 load_dynamic_module: Error loading module ‘cdr_radius.so’: libradiusclient-ng.so.2: cannot open shared object file: No such file or directory [Jan 26 13:25:23]
WARNING[21369]: loader.c:607 load_resource: Module ‘cdr_radius.so’ could not be loaded.

Be sure to include the lib path (typically /usr/local/lib) in your 

/etc/ld.so.conf if it’s not already there. Then run “ldconfig -v” from being the root use.

  1. If you get the following error message:

[Jan 26 23:08:44] NOTICE[15189]: cdr_radius.c:258 load_module: Cannot load
radiusclient-ng configuration file /etc/radiusclient-ng/radiusclient.conf.

It's because the path /etc/radiusclient-ng/radiusclient.conf is hard coded in cdr_radius.c  (really don't know why). Yet the standard location upon standard installation of radiusclient-ng 

has the file at /usr/local/etc/radiusclient-ng/radiusclient.conf

Therefore, depending where the radiusclien-ng is installed, you may need to create a link using the following command (by replacing the first part to whereever your path is):

ln -s /usr/local/etc/radiusclient-ng/radiusclient.conf /etc/radiusclient-ng/radiusclient.conf

  1. Once you are able to successfully get the cdr_radius to work, you need to include into the dictionary of radiusclient and the RADIUS server — the SIP attributes, and the digium attributes in the file located at /usr/src/asterisk-1.4.0/contrib/dictionary.digium
    You need to, however, pay attention on the format for dictionaries. Case in point: the dictionary of my RADIUS uses a format different from that in the dictionary.digium file

Hope this helps!

You might be interested in connecting Asterisk AGI with Oracle like databases. Please visit the following URL:
forums.digium.com/viewtopic.php? … ght=oracle