[OpenSER-Users] Acc Modules + Extra paramters

Henning Westerholt henning.westerholt at 1und1.de
Wed Jun 18 14:17:34 CEST 2008


On Wednesday 18 June 2008, Ali Jawad wrote:
> > modparam("acc", "db_url",
> > "mysql://openser:123456@87.236.144.12/openser")
> >
> > modparam("acc", "acc_from_tag_column", "from_tag")
> >
> > modparam("acc", "acc_to_tag_column", "to_tag")
> >
> > modparam("acc", "db_flag", 2)
>
> The call is added to the acc table. However I need to get the URI and
> RURI to be inserted in the database as well..so I used the example in
> the module howto modparam("acc",
> "db_extra","7846=$hdr(Content-type);7847=$avp(s:email)"
> When I do add this line to the config nothing is logged anymore into the
> db. Another thing that I was wondering about is how does openser know in
> which column to add that db_extra data ?
>
> The error I get when using the avp db_extra is
>
> Jun 18 12:57:23 [24162] ERROR:mysql:db_mysql_submit_query: driver error:
> Unknown column 'ct' in 'field list'
> Jun 18 12:57:23 [24162] ERROR:mysql:db_mysql_insert: error while
> submitting query
> Jun 18 12:57:23 [24162] ERROR:acc:acc_db_request: failed to insert into
> database
> Jun 18 12:57:23 [24162] DBG:tm:cleanup_uac_timers: RETR/FR timers reset

Hi Ali,

the acc module can't insert the data because the 'ct' column you specified in 
the db_extra parameter (original mail) is not available in your add table.

As i said, you need to create the columns in the acc table for all db_extra 
informations you want to log. Take a look at 
http://devel.openser.org/svn/trunk/examples/acc-mysql.cfg for an DB setup and 
the belonging db_extra configuration to get an idea.

Henning




More information about the Users mailing list