Re: [Users] How to log the username of caller and callee to acc table?

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