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:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2008 3:18 PM To: Ali Jawad Cc: [email protected] Subject: Re: [OpenSER-Users] Acc Modules + Extra paramters On Wednesday 18 June 2008, Ali Jawad wrote: > > modparam("acc", "db_url", > > "mysql://openser:[EMAIL PROTECTED]/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 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. _______________________________________________ Users mailing list [email protected] http://lists.openser.org/cgi-bin/mailman/listinfo/users
