19 Jun
2008
19 Jun
'08
11:13 a.m.
Hi Henning
As per your example everything worked great. However I noticed that the
missed calls statement reads
CREATE TABLE `missed calls` (
Whereas the acc module default missed call table name is 'missed_calls'
not 'missed calls' this caused me some problems I don't know if this is
a typo or not, I just thought of letting you know.
Thanks for your efforts.
-----Original Message-----
From: Henning Westerholt [mailto:henning.westerholt@1und1.de]
Sent: Wednesday, June 18, 2008 3:18 PM
To: Ali Jawad
Cc: users(a)lists.openser.org
Subject: Re: [OpenSER-Users] Acc Modules + Extra paramters
On Wednesday 18 June 2008, Ali Jawad wrote:
the
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 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
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.