Charles,
glad to help - all the changes between the versions are documented on the web site. See: http://www.openser.org/dokuwiki/doku.php/install:1.1.x-to-1.2.x
regards, bogdan
Charles Wang wrote:
Dear Bogdan,
Thank you for your important information. It helps me to solve my problems. I add four fields to DB and use db_extra to insert them.
modparam("acc", "db_extra", "from_uri=$fu ; sip_from=$hdr(From) ; to_uri=$tu ; sip_to=$hdr(To)")
Best regards, Charles
2007/5/18, Bogdan-Andrei Iancu <bogdan@voice-system.ro mailto:bogdan@voice-system.ro>:
Hi Charles, in openser 1.2 only a few mandatory info about the SIP transaction are accounted. If you want something more, use the the extra accounting. For, example, for db, to get the from uri, so: modparam("acc","db_extra","from_uri=$fu ; sip_from=$hdr(From)") Note, you need to create the new columns in the acc table. See http://www.openser.org/docs/modules/1.2.x/acc.html#ACC-EXTRA-ID regards, bogdan Charles Wang wrote: > Hi all, > > I ever used SER and I know it will save the From information such as > 101@192.168.11.200 <mailto:101@192.168.11.200> <mailto:101@192.168.11.200 <mailto:101@192.168.11.200>> to sip_from or from_uri > in its acc table. > But in my openser, I also setup the acc module. Where is my caller info? > > I can find a lot of number such as "2806655523" in my from_tag. > I wanna store the caller and callee info in my acc table when I make > an internal call or an external call. > > Can anybody kind to help me to solve it? or give me some tips please. > PS: I got this openser.cfg from http://www.sipwise.com/wizard <http://www.sipwise.com/wizard>. > > Best regards, > Charles
--
Best Regards Charles
Dear Bogdan,
Thank you for your tips. It is very wonderful messages for me.
I still have a question about acc tables(CDR). The sip methods INVITE and BYE will be recorded into acc when I make a call and hang up. Is there any good idea to merge them into one record for billing issue? I study the acc and mysql module, but I don't know which is the best way to change the INSERT SQL command to UPDATE SQL command.
Can you give me some tips?
Best regards, Charles
2007/5/18, Bogdan-Andrei Iancu bogdan@voice-system.ro:
Charles,
glad to help - all the changes between the versions are documented on the web site. See: http://www.openser.org/dokuwiki/doku.php/install:1.1.x-to-1.2.x
regards, bogdan
Hi Charles,
trying to merge the INVITEs and BYEs at openser level will increase the complexity of the ACC module logic. The design bases on the simple concept of logging START/STOP records that can be merged/process afterwards, via a separate app as you need/like.
Regards, Bogdan
Charles Wang wrote:
Dear Bogdan,
Thank you for your tips. It is very wonderful messages for me.
I still have a question about acc tables(CDR). The sip methods INVITE and BYE will be recorded into acc when I make a call and hang up. Is there any good idea to merge them into one record for billing issue? I study the acc and mysql module, but I don't know which is the best way to change the INSERT SQL command to UPDATE SQL command.
Can you give me some tips?
Best regards, Charles
2007/5/18, Bogdan-Andrei Iancu <bogdan@voice-system.ro mailto:bogdan@voice-system.ro>:
Charles, glad to help - all the changes between the versions are documented on the web site. See: http://www.openser.org/dokuwiki/doku.php/install:1.1.x-to-1.2.x regards, bogdan