I am using kamailio 5.3. 

Ovidiu Sas, i will try this tomorrow today is bit late. Maybe it could work.

David Villasmil , i know i can use SQLOPS but i was thinking of easier method of doing this.
By successful REGISTER i mean save only REGISTER attempt that authenticated correctly at SIP server and in 200 OK a binding was returned.
Same if the binding is later removed i would like remove it from database. I need this because when i run REGISTER over kamailio to destination SIP server i see all register from same IP.
I need to be able to check what was the real source IP of client REGISTER.

Regards,
Tomasz

czw., 14 lis 2019 o 23:33 Ovidiu Sas <osas@voipembedded.com> napisał(a):

Try to use save() when you process the 200 ok reply for REGISTER in
the reply route.

Regards,
Ovidiu Sas

On Thu, Nov 14, 2019 at 3:40 PM Voip support <voipexpert0@gmail.com> wrote:
>
> I setup kamailio to forward REGISTER packets using dispatcher to two servers main and backup.
>
> The routing logic is quite simple i use the dispatcher probing mechanism to detect if my main dispatcher set id (one server) is active or inactive once it detect a failure all packets are sent to secondary SIP server to achieve High Availability.
>
> I am looking for module or a way to save into kamailio database client information such as IP address, register username (from FROM header), digest username (authorization username), call-id for successful registration.
>
> I tried to use registrar module but once i used function save("location") the client was registered on kamailio and packets was not forwarded to main/secondary SIP server (like dispatcher stopped working, the destination did not override).
>
> REGISTER is sent to SIP URI of kamailio.
>
> Please let me know if you have any idea how to make this data update in database (insert an entry on fresh successfull REGISTER, delete on expired or removed binding).
>
> Best regards,
> Tomasz
>
> _______________________________________________
> Kamailio (SER) - Users Mailing List
> sr-users@lists.kamailio.org
> https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users



--
VoIP Embedded, Inc.
http://www.voipembedded.com

_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users