[SR-Users] UAC "credential" username, password and realm from DB

[Yuriy Gorlichenko]

Hello. I suceesfully authenticate some accounts of providers from UAc using
DB.

When I try to Call to any provider it responds me 407 or 401 reply.

To Send to It new INVITE with auth Creditans I use UAC_AUTH() with
configured modparams:

modparam("uac","credential","username:domain:password")
modparam("uac","auth_realm_avp","$avp(i:10)")
modparam("uac","auth_username_avp","$avp(i:11)")
modparam("uac","auth_password_avp","$avp(i:12)")

I think that avp`s used to get varibles from DB, but at test it is not
write.

So my question- how to get this varibles from DB (uacreg table)

Thanks

[Daniel-Constantin Mierla]

Hello,

see avpops or sqlops for how to load values from database and access
them in config file via variables.

Cheers,
Daniel

Post by Yuriy Gorlichenko
Hello. I suceesfully authenticate some accounts of providers from UAc
using DB.
When I try to Call to any provider it responds me 407 or 401 reply.
To Send to It new INVITE with auth Creditans I use UAC_AUTH() with
modparam("uac","credential","username:domain:password")
modparam("uac","auth_realm_avp","$avp(i:10)")
modparam("uac","auth_username_avp","$avp(i:11)")
modparam("uac","auth_password_avp","$avp(i:12)")
I think that avp`s used to get varibles from DB, but at test it is not
write.
So my question- how to get this varibles from DB (uacreg table)
Thanks
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

[Yuriy Gorlichenko]

I don know how to do one thing:

As I understand I need to set values for variables

modparam("uac","auth_realm_avp","$avp(i:10)")
modparam("uac","auth_username_avp","$avp(i:11)")
modparam("uac","auth_password_avp","$avp(i:12)")

Am I right?

If I get query results with password and realm through sqlops, how can I
send it to modparam("uac","credential","username:domain:password")

Must I use something like:

$avp(i:12)=$avp(my_query_result_password)
$avp(i:10)=$avp(my_query_result_realm)
$avp(i:11)=$avp(my_query_result_username)

?

Post by Daniel-Constantin Mierla
Hello,
see avpops or sqlops for how to load values from database and access them
in config file via variables.
Cheers,
Daniel
Hello. I suceesfully authenticate some accounts of providers from UAc
using DB.
When I try to Call to any provider it responds me 407 or 401 reply.
To Send to It new INVITE with auth Creditans I use UAC_AUTH() with
modparam("uac","credential","username:domain:password")
modparam("uac","auth_realm_avp","$avp(i:10)")
modparam("uac","auth_username_avp","$avp(i:11)")
modparam("uac","auth_password_avp","$avp(i:12)")
I think that avp`s used to get varibles from DB, but at test it is not
write.
So my question- how to get this varibles from DB (uacreg table)
Thanks
_______________________________________________
--
Daniel-Constantin Mierlahttp://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Next Kamailio Advanced Trainings 2014 - http://www.asipto.com
Sep 22-25, Berlin, Germany ::: Oct 15-17, San Francisco, USA
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users