[Kamailio-Users] wildcard in avp_db_load with db_schema

[Daniel-Constantin Mierla]

Hello,

On 07/29/08 18:58, Andreas Granig wrote:
> Nevermind, I just changed the column name from "call_id" to the standard 
> name "uuid" and load the AVPs with
>
> 	avp_db_load("$ci", "*/my_table");
>
> to get rid of the db_schema thing.
>
> Andreas
>
> Andreas Granig wrote:
>   
>> Hi,
>>
>> For loading all AVPs from "normal" avp tables, I can use something like 
>> this:
>>
>> 	avp_db_load("$fu/domain", "*/domain_preferences");
>>
>> But when I want to use a db schema to load AVPs belonging for example to 
>> a call_id for some sort of dialog tracking, it fails to start with the 
>> following error message:
>>
>> "ERROR:avpops:parse_avp_db: inconsistent usage of DB scheme without 
>> complet specification of AVP name"
>>
>> My config looks like that:
>>
>> 	modparam("avpops","db_scheme",
>> 	"my_schema:table=some_table;uuid_col=call_id;value_col=value")
>> 	...
>> 	avp_db_load("$ci", "*/$my_schema");
>>
>> If I put something like "$avp(i:10)" instead of the "*", it works, but 
>> then I just get this specific AVP instead of all of them.
>>
>> Any idea if this is supposed to work, and if so, how?
>>
>>     
this happens because in this case there is no way to specify the name of 
the AVP, schema provides only the relation between key columns and value 
column, but there is no column holding the name of the avp. I will add a 
note in the docs, but svn seems down now.

Cheers,
Daniel

-- 
Daniel-Constantin Mierla
http://www.asipto.com