4 Nov
2005
4 Nov
'05
7:18 a.m.
On Fri, 04 Nov 2005 13:43:46 +0200, Daniel-Constantin Mierla wrote
On 11/04/05 09:10, Greger V. Teigre wrote:
But note that, since not all the AVP commands work with db schemes (store,
delete), it's either work with the usr_preferences table, ONE other table (set
with columns via modparams), or work with more limited functionality.
Brett,
I have never used avpairs with sql (I use radius), but I believe the
avp_db_load statement should be removed alltogether. The
avps_column_str instructs the auth module to load the value in the
callscope column ON SUCCESSFUL AUTHENTICATION, i.e. when the user is
authenticated, the avp is already loaded and ready to be used.
There are other
common cases when you need to load an avp without
authentication, for example a set of gateways to deliver the
requests to - these are not user specific. Also, avp_db_load()
offers a more powerful interface to database, allowing to load data
from any table, regardless the table does not have the structure of
usr_preferences table.