通话记录报告怎么存mysql_在opensips中记录通话记录

#### ACCounting module

loadmodule "acc.so"

/* account triggers (flags) */

modparam("acc", "db_flag", 1)

modparam("acc", "db_missed_flag", 2)

modparam("acc", "cdr_flag", 1)

modparam("acc", "db_url",

"mysql://opensips:[email protected]/opensips") # CUSTOMIZE ME

modparam("acc", "db_extra", "from_uri=$fu; to_uri=$tu")

...

if (has_totag())

{

# sequential request withing a dialog should

# take the path determined by record-routing

if (loose_route())

{

if (is_method("BYE"))

{

setflag(1); # do accounting ...

setflag(3); # ... even if the transaction fails            }

else if (is_method("INVITE"))

{

# even if in most of the cases is useless, do RR for

# re-INVITEs also, as some buggy clients do change route set

# during the dialog.

record_route();

}

if (check_route_param("nat=yes"))

{

setflag(10);

}

# route it out to whatever destination was set by loose_route()

# in $du (destination URI).

route(1);

}

...

# account only INVITEs

if (is_method("INVITE"))

{

# create dialog with timeout

if ( !create_dialog("B"))

{

send_reply("500","Internal Server Error");

exit;

}

setflag(1); # do accounting    }