On Tuesday 17 June 2008, Ali Jawad wrote: Hi Ali, please don't post your question again without adding any new informations. Keep in mind that the support in this channel is done voluntary, so sometimes it needs a little bit more time to get an answer. Cheers, Henning

Hi Henning Sorry for any inconvenience I might have caused if I do use 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 Thanks for anyhelp -----Original Message----- From: Henning Westerholt [mailto:henning.westerholt@1und1.de] Sent: Wednesday, June 18, 2008 1:26 PM To: users(a)lists.openser.org Cc: Ali Jawad Subject: Re: [OpenSER-Users] Acc Modules + Extra paramters On Tuesday 17 June 2008, Ali Jawad wrote: > Does anyone have a working example of > > modparam("acc", "diameter_extra", > "7846=$hdr(Content-type);7847=$avp(s:email)") > > In my setup I do have > > > #modparam("acc", "db_extra", "ct=$hdr(Content-type); > email=$avp(s:email)") > > I am getting the from and to data in the MySQL acc table. However I do > need to save the URI and RURI as well. I tried with the example above > but it stopped the logging to the database. Hi Ali, do you get an error message in the server logs? In order to be able to insert the extra accounting stuff in the DB you need to create the appropriate columns too. Take a look at examples/acc-mysql.cfg for an example. Perhaps you can try first to use syslog ACC, as this is the easiest to setup. If this work for all your extra accounting, try to swith to the DB, and see if it continues to work. Cheers, Henning -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

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 in error: into 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.

Hi I am glad I could be of any use in this project, even for a tiny issue like this one. TC -----Original Message----- From: Henning Westerholt [mailto:henning.westerholt@1und1.de] Sent: Tuesday, June 24, 2008 1:48 PM To: Ali Jawad Cc: users(a)lists.openser.org Subject: Re: [OpenSER-Users] Acc Modules + Extra paramters On Thursday 19 June 2008, Ali Jawad wrote: the 'missed_calls' is Hi Ali, thank you for the report, i'll fix this. Henning -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.