Koozali.org: home of the SME Server

Obsolete Releases => SME VoIP (Asterisk, SAIL etc) => Topic started by: chris burnat on June 14, 2010, 10:15:14 AM

Title: [SOLVED] CDR not working for SAIL 2.5 on SME7.5
Post by: chris burnat on June 14, 2010, 10:15:14 AM

Hello Selintra,
Installed asterisk from rpms on sme 7.5 fully updated + sail 2.5.   Most things are working, but CDR is not working.  Are you aware of any issues with latest rpms:

Asterisk Installed packages:
=============================================================================
 Package                 Arch       Version          Repository        Size
=============================================================================
 asterisk-addons14       i386       1:1.4.11-26.el4  atrpms            462 k
 asterisk14              i386       1:1.4.31-91.el4  atrpms            3.4 M
 dahdi-linux             i386       2.3.0-68.el4     atrpms            2.4 M
 dahdi-linux-kmdl-2.6.9-89.0.25.EL  i686       2.3.0-68.el4     atrpms            616 k
 dahdi-tools             i386       1:2.3.0-66.el4   atrpms            232 k
 libpri                  i386       1:1.4.10.2-25.el4  atrpms            5.1 k
Installing for dependencies:
 alsa-lib                i386       1.0.6-5.RHEL4    base              302 k
 asterisk-core-sounds-en-gsm  noarch     1.4.19-61        atrpms            1.8 M
 asterisk-moh-opsound-wav  noarch     2.03-56          atrpms             15 M
 libgcrypt               i386       1.2.0-3          base              153 k
 libgpg-error            i386       1.0-1            base               45 k
 libgsm1                 i386       1.0.13-2.el4     atrpms             22 k
 libiksemel3             i386       1.4-2_2.el4      atrpms             27 k
 libogg                  i386       2:1.1.2-1        base               16 k
 libpri1                 i386       1:1.4.10.2-25.el4  atrpms             66 k
 libradiusclient-ng2     i386       0.5.6-0.el4      atrpms             26 k
 libtonezone2            i386       1:2.3.0-66.el4   atrpms             13 k
 libvorbis               i386       1:1.1.0-3.el4_8.3  updates           187 k
 speex                   i386       1.2-0.11.rc1.el4  atrpms             93 k
 unixODBC                i386       2.2.11-1.RHEL4.1  base              829 k

Sark installed packages:
=============================================================================
 Package                 Arch       Version          Repository        Size
=============================================================================
perl-File-ReadBackwards.noarch 0:1.04-1.2.el4.rf
sail                    noarch     2.5.1-10         sail-2.5.1-10.noarch.rpm  5.0 M
Installing for dependencies:
 nmap                    i386       2:3.70-1         base              486 k
 perl-Bit-Vector         i386       6.3-3            base              130 k
 perl-Date-Calc          i386       5.3-9            base              209 k
 sox                     i386       12.17.5-3        base              253 k
 tftp-server             i386       0.39-3.el4       base               26 k
 xinetd                  i386       2:2.3.13-4.5.el4  base              128 k

Test:
sail25*CLI> module show like cdr_addon_mysql
Module                         Description                              Use Count
cdr_addon_mysql.so             MySQL CDR Backend                        0         
1 modules loaded

sail25*CLI> cdr status
CDR logging: enabled
CDR mode: simple
CDR output unanswered calls: no
CDR registered backend: cdr-custom
CDR registered backend: csv
CDR registered backend: cdr_manager

and:

files cdr_addon_mysql.so and app_addon_sql_mysql.so are in the /usr/lib/asterisk/modules directory .
CDR is not showing any calls.
I got the system ready, can do some testing for you.
Regards
chris

Title: Re: CDR not working for SAIL 2.5 on SME7.5
Post by: SARK devs on June 15, 2010, 11:54:31 AM

Hi Chris

We have no known problems with SQL CDR creation.  It isn't really anything to do with SAIL (other than turning it on and off in Globals - and you won't even be able to do that in V3.0)

Check that cdr_addon_mysql.so exists in /usr/lib/asterisk/modules.

Check that the database entities have been created.  In mysql you should find database asterisk with only one table called cdr.

Also, check /etc/asterisk/cdr_mysql.conf it should contain

Code: [Select]

[global]
hostname=localhost
dbname=asterisk
password=aster1sk
user=asterisk
That's all you can change.  If these above are all set but you still aren't getting SQL CDRs then I think you may need to speak to Digium.

Best

Jeff

Title: [SOLVED] Re: CDR not working for SAIL 2.5 on SME7.5
Post by: chris burnat on June 16, 2010, 08:20:15 AM

Hello Jeff,
Thanks for information.
OK, its working...
Done nothing, except that at around 19:00 last night, I stopped and restarted Sail from the PCI panel.
Next thing I know, CDR is recording all calls.  I verified this in a manner, just installed another test box, and got exactly same result.
Funny stuff...
No complaints.
Cheers
chris