[Freeswitch-users] mod_cdr MySQL

[Mindaugas Kezys]

Hello,

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">
  <pddcdr>
    <param name="path" value="/tmp/pddcdr"/>
    <!-- <param name="chanvars" value="username,accountcode"/> -->
    <!-- <param name="chanvars_fixed" value="foo"/> -->
  </pddcdr>
  <csvcdr>
    <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"/> -->
  </csvcdr>
  <mysqlcdr>
    <param name="hostname" value="127.0.0.1"/>
    <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"/>
  </mysqlcdr>
</configuration>


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.


Regards/Pagarbiai,
Mindaugas Kezys
http://www.kolmisoft.com