Hi Alex

Thanks to your pointers above, I am able to login into a custom table insert queries as needed. However, I am not sure how to define the correct variables, what I am doing now is the following :

sql_query("cb", "insert into registrations (`user`,`agent`,`type`,`ip`,`unique`,`auth`) VALUES('test','VOS','IN','8.8.8.8', 'someID' , 'register wrong ') ", "ra");

sql_result_free("ra");

How do I get the variables for username,agent and IP.

Thanks

On Wed, Sep 5, 2012 at 3:25 PM, Alex Balashov <abalashov@evaristesys.com> wrote:

Sure, just pull it out with the $ua or $hdr(User-Agent) PVs.

On 09/05/2012 07:53 AM, Ali Jawad wrote:

Hi Alex
Sounds good, thanks for the input so far, anyway I can add the useragent
to the entry ?
Regards

On Wed, Sep 5, 2012 at 2:49 PM, Alex Balashov <abalashov@evaristesys.com
<mailto:abalashov@evaristesys.com>> wrote:

Hi Ali,

On 09/05/2012 07:18 AM, Ali Jawad wrote:

Is it possible to store user logon/logout dates + user agent used. I
know that the info is in the location table but it is not
persistent,
and I am using the accounting table to store calls. But I am not
sure
there is a way to store logon/logout/user agent.

By "logon" and "logout" I assume you are referring to registration,
not something else.

You can capture a REGISTER request in the main request route and
call a SQL operation via 'sqlops' to store that timestamp ($Ts)
wherever you want.

There is no such thing as an "unregistration", technically, just a
REGISTER request with an ;expires=0 parameter in the Contact header,
or an Expires: 0 header. If you look for those parameters in your
processing of the REGISTER request, e.g.

if((is_present_hf("Expires") && $hdr(Expires) == "0") ||
$hdr(Contact) =~ "expires=0")

you can store those times, too.

-- Alex

--
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
Tel: +1-678-954-0670
Fax: +1-404-961-1892
Web: http://www.evaristesys.com/, http://www.alexbalashov.com/

_________________________________________________

SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org <mailto:sr-users@lists.sip-router.org>
http://lists.sip-router.org/__cgi-bin/mailman/listinfo/sr-__users
<http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users>

--
*Ali Jawad
*
*Information Systems Manager

CISSP - ITIL V3 - RHCE - VCP - C|EH - CCNA - MCSA
*
*Splendor Telecom (www.splendor.net <http://www.splendor.net/>)

Beirut, Lebanon
Phone: +9611373725/ext 116
FAX: +9611375554

*

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

--
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
Tel: +1-678-954-0670
Fax: +1-404-961-1892
Web: http://www.evaristesys.com/, http://www.alexbalashov.com/

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users