Hello
I'm using AVP, but I can not finish assimilating the concept. I try to input messages, according to their DID. Once it enters an INVITE message treatment with alias_db for its user, but I want some AVP for each DID.
I can think of three cases. The first I have no very clear if possible and if it were, I think is not optimal.
1)
Given the configuration of the module: modparam("avpops","avp_url","mysql://user:passwd@host/database")
Had thought if I can use regular expressions to get the "prs" in the database (DID_IN, DID_DEST, etc).
USR_PREFERENCES table:
| id | uuid | username | domain | attribute | type | value | modified | | 1 | XXX | user1 | dmn.tld | 571XXX_IN | 1 | XXX | | | 2 | XXX | user2 | dmn.tld | 571XXX_DEST | 1 | XXX | |
2)
Maybe better to use the module configuration schemes:
modparam("avpops","db_scheme","scheme1:uuid_col=uid;value_col=job;value_type=string;table=emp") modparam("avpops","db_scheme","scheme2:username_col=user;domain_col=domain;value_col=email;table=users")
3)
Or use avp_db_query() function.
Can anyone guide me? I'm pretty lost :-S. The first case, I know if possible and possibly more difficult to maintain. Thanks very much.
Best regards Anto