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

[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> 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 listUsers at lists.opensips.orghttp://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/b81f212f/attachment.htm>