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

Max Mühlbronner mm at 42com.com
Wed Jun 15 12:35:39 CEST 2011


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
> 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/3f3dfd9d/attachment.htm>


More information about the Users mailing list