[Freeswitch-users] mod_cdr MySQL

Mindaugas Kezys mkezys at gmail.com
Tue Mar 27 01:58:09 PDT 2007


Trying to use mod_cdr with MySQL database. MySQL is installed. Created
user/db/table, configured mod_sql.conf.xml:

<configuration name="mod_cdr.conf" description="CDR Configuration">
    <param name="path" value="/tmp/pddcdr"/>
    <!-- <param name="chanvars" value="username,accountcode"/> -->
    <!-- <param name="chanvars_fixed" value="foo"/> -->
    <param name="path" value="/tmp/csvcdr"/>
    <param name="size_limit" value="25"/>
    <!-- <param name="chanvars_fixed" value="username"/> -->
    <!-- <param name="chanvars_supp" value="*"/> -->
    <!-- <param name="repeat_fixed_in_supp" value="0"/> -->
    <param name="hostname" value=""/>
    <param name="username" value="fs"/>
    <param name="password" value="fs"/>
    <param name="dbname" value="fs"/>
    <!-- This following line logs username as a varchar, and The_Kow as a
tiny -->
    <!-- <param name="chanvars_fixed" value="username=s,The_Kow=t"/> -->
    <!-- If you do not want to log any and all chanvars to the chanvar
table, comment the next 2 lines out -->
    <param name="chanvars_supp" value="*"/>
    <param name="chanvars_supp_repeat_fixed" value="0"/>

When starting Freeswitch I see:

mod_cdr.cpp:147 switch_module_runtime() mod_cdr made it to runtime.  Wee!

modcdr_show_available shows:

API CALL [modcdr_show_available()] output:
The following mod_cdr logging backends are currently avaible for use
(providing you configure them):
MysqlCDR - The MySQL 4.1+ CDR logger using prepared statements
SqliteCDR - The sqlite3 cdr logging backend
XmlCDR - The rough implementation of XML CDR logger
CsvCDR - The simple comma separated values CDR logger
PddCDR - Perl Data Dumper CDR logger

modcdr_show_active returns:
API CALL [modcdr_show_active()] output:
The following mod_cdr logging backends are currently marked as active:

That's it. Empty set. Why? How to enable MysqlCDR? Or CsvCDR?

Thank you for your help.

Mindaugas Kezys

More information about the FreeSWITCH-users mailing list