[Users] Database AVP

[Klaus Darilion]

Douglas Garstang wrote:
> Can someone post/link to some examples of how to use avp module to write/read data to/from MySQL tables?
> The openser.org docs are reeeeealy bad.

(old 1.0.0 AVP syntax)

The AVP alias cansipuri hold the canoncial SIP URI (after 
lookup("aliases"). We use this as uri identifier to laod from the DB.

We load the AVP from voicemail_extension in the alias AVP 
nums_id_extensions.

This fetches the voicemail extension for a certain user from DB.



# load voicemail extension for local destination
avp_db_load("$cansipuri/uri","$nums_id_extension/voicemail_extension");


I did this long time ago, thus I can not remember each detail.
regards
klaus


  SELECT * from voicemail_extension;
        username   |        domain         |  value  | type |attribute
------------------+-----------------------+---------+------+-----------
  klaus.darilion   | xxxx.at43.at          | 1234567 |    2 | 105
  john.public      | xxxx.at43.at          | 1234568 |    2 | 105