[OpenSIPS-Users] How to extract passwords from the subscriber table?

[Max Mühlbronner]

Hello,


the avp_db_query needs a db/connection to query.

But what kind of db is the "internal" db , how did you add the users?

If i remember correctly adding users via opensipsctl does always write 
to a database (which is configured in opensipsctlrc file)? If there is 
no connection how did you add the users? But maybe i am missing something?



Best Regards

Max M.

Am 15.06.2011 13:07, schrieb Tiberiu Breana:
> I know that, but how can I connect to the subscriber table (the 
> default "user list")? It's not a mysql db.
> I don't have a persistent database configured right now. Do I need to 
> configure one if I want to use avp_db_query?
>
> Thanks.
>
> On 15 June 2011 13:35, Max Mühlbronner <mm at 42com.com 
> <mailto:mm at 42com.com>> wrote:
>
>     Hello,
>
>     the avpops is missing the db connection / db_url modparam.
>
>     http://www.opensips.org/html/docs/modules/devel/avpops.html#id249134
>
>     modparam("avpops","db_url","mysql://user:passwd@host/database")
>
>
>
>     Best Regards
>
>
>     Max M.
>
>
>     Am 14.06.2011 17:02, schrieb Tiberiu Breana:
>>     Hello.
>>
>>     I want to use some custom RADIUS authentication requests with
>>     radius_send_auth, but it seems this can't work without sending
>>     the user's password.
>>     I'm trying to extract user passwords from the subscriber table
>>     using the example from the avpops manual:
>>
>>     avp_db_query("select password from subscriber where
>>     username='$tu'", "$avp(i:678)");
>>
>>     But I get this error:
>>
>>     ERROR:avpops:fixup_db_query_avp: no db url defined to be used by
>>     this function
>>     ERROR:core:fix_actions: fixing failed (code=-6) at cfg line 308
>>     ERROR:core:main: failed to fix configuration with err code -6
>>
>>     I guess I need to add a db_url ID to the query's parameters, but
>>     I don't know what the subscriber table's ID is. What is it? Or,
>>     how can I set it?
>>     Is there a simpler way to obtain a user's password and put it in
>>     a variable?
>>
>>
>>     Regards,
>>     Tiberiu
>>
>>
>>     _______________________________________________
>>     Users mailing list
>>     Users at lists.opensips.org  <mailto:Users at lists.opensips.org>
>>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>     _______________________________________________
>     Users mailing list
>     Users at lists.opensips.org <mailto:Users at lists.opensips.org>
>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20110615/bc75160d/attachment.htm>