1.2.1. OpenSER Modules

The following modules must be loaded before this module:

• Optionally a database module

1.2.2. External Libraries or Applications

The following libraries or applications must be installed before running OpenSER with this module loaded:

• None

1.3.1. avp_url (string)

DB URL for database connection.

This parameter is optional, it's default value being NULL.

...
modparam("avpops","avp_url","mysql://user:passwd@host/database")
...
				

1.3.2. avp_table (string)

DB table to be used.

This parameter is optional, it's default value being NULL.

...
modparam("avpops","avp_table","avptable")
...
				

1.3.3. avp_aliases (string)

Contains a multiple definition of aliases for AVP names.

This parameter is optional.

...
modparam("avpops","avp_aliases","uuid=I:660;email=s:email_addr;fwd=i:753")
...
				

1.3.4. use_domain (integer)

If the domain part of the an URI should be used for identifying an AVP in DB operations.

Default value is "0 (no)".

...
modparam("avpops","use_domain","1")
...
				

1.3.5. uuid_column (string)

Name of column containing the uuid (unique user id).

Default value is "uuid".

...
modparam("avpops","uuid_column","uuid")
...
				

1.3.6. username_column (string)

Name of column containing the username.

Default value is "username".

...
modparam("avpops","username_column","username")
...
				

1.3.7. domain_column (string)

Name of column containing the domain name.

Default value is "domain".

...
modparam("avpops","domain_column","domain")
...
				

1.3.8. attribute_column (string)

Name of column containing the attribute name (AVP name).

Default value is "attribute".

...
modparam("avpops","attribute_column","attribute")
...
				

1.3.9. value_column (string)

Name of column containing the AVP value.

Default value is "value".

...
modparam("avpops","value_column","value")
...
				

1.3.10. type_column (string)

Name of column containing the AVP type.

Default value is "type".

...
modparam("avpops","type_column","type")
...
				

1.3.11. db_scheme (string)

Definition of a DB schemeto be used for non-standard access to Database information.

Default value is "NULL".

...
modparam("avpops","db_scheme",
"scheme1:table=subscriber;uuid_column=uuid;value_column=first_name")
...
				

1.4.1. avp_db_load(source,name)

Loads from DB into memory the AVPs corresponding to the given source.

Meaning of the parameters is as follows:

• source - what info is used for identifying the AVPs. Parameter syntax:

  • source = (sip_uri)['/'('username'|'domain')]) | (avp_alias) | str_value

  • sip_uri = '$from' | '$to' | '$ruri'

• name - which AVPs will be loaded from DB into memory. Parameter syntax is:

  • name = avp_spec['/'(table_name|'$'db_scheme)]

  • avp_spec = ''|'s:'|'i:'|avp_name|avp_alias

...
avp_db_load("$from","i:678");
avp_db_load("$ruri/domain","i:/domain_preferences");
avp_db_load("$uuid","s:404fwd/fwd_table");
avp_db_load("$ruri","i:123/$some_scheme");
...
				

1.4.2. avp_db_store(source,name)

Stores to DB the AVPs corresponding to the given source.

The meaning and usage of the parameters are identical as for avp_db_load(source,name) function. Please refer to its description.

...
avp_db_store("$to","i:678");
avp_db_store("$ruri/username","$email");
...
				

1.4.3. avp_db_delete(source,name)

Deletes from DB the AVPs corresponding to the given source.

The meaning and usage of the parameters are identical as for avp_db_load(source,name) function. Please refer to its description.

...
avp_db_delete("$to","i:678");
avp_db_delete("$ruri/username","$email");
avp_db_delete("$uuid","s:404fwd/fwd_table");
...
				

1.4.4. avp_write(value,name)

The function writes some value (given) or some information from the SIP message into a new AVP.

Meaning of the parameters is as follows:

• value - the value to be written into the AVP. Parameter syntax:

  • value = (variable) | (fix_value)

  • variable = '$src_ip' | (sip_uri)['/'('username'|'domain')])

  • sip_uri = '$from' | '$to' | '$ruri'

  • fix_value = 'i:'integer | 's:'string | string

• name - the name of the new written AVP. Parameter syntax is:

  • name = avp_name | avp_alias

...
avp_write("$to","i:678");
avp_write("$ruri/username","$email");
avp_write("$src_ip","s:ip");
avp_write("i:333","i:6");
...
				

1.4.5. avp_delete(name)

Deletes from memory the AVPs with name or, if empty, all AVPs.

Meaning of the parameters is as follows:

• name - which AVPs will be deleted from memory. Parameter syntax is:

  • name = (''|'s:'|'i:'|avp_name|avp_alias)['/'flag]

  • flag = 'g'|'G'

...
avp_delete("i:678/g");
avp_delete("$email");
avp_delete("i:");
avp_delete("");
...
				

1.4.6. avp_pushto(destination,name)

Pushes the value of AVP(s) into the SIP message.

Meaning of the parameters is as follows:

• destination - as what will be the AVP value pushed into SIP message. Parameter syntax:

  • destination = ruri_dst | hdr_dst

  • ruri_dst = '$ruri'['/'('username'|'domain')]

  • hdr_dst = '$hdr_name'['/'('request'|'reply')]

• name - which AVP(s) should be pushed into the SIP message. Parameter syntax is:

  • name = ( avp_name | avp_alias )['/'flags]

  • flags = 'g'

...
avp_pushto("$ruri","i:678");
avp_pushto("$ruri/domain","s:backup_domains/g");
avp_pushto("$Email/reply","s:email");
avp_pushto("$Foo","$bar/g");
...
				

1.4.7. avp_check(name,op_value)

Checks the value of the AVP(s) against an operator and value.

Meaning of the parameters is as follows:

• name - which AVP(s) should be checked. Parameter syntax is:

  • name = ( avp_name | avp_alias )

• op_value - define the operator, the value and flags for checking. Parameter syntax is:

  • op_value = operator '/' value ['/'flags]

  • operator = 'eq' | 'lt' | 'gt' | 're'

  • value = variable | fix_value

  • variable = '$from'|'$ruri'|'$from'|'$src_ip'|avp_alias

  • fix_value = 'i:'integer | 's:'string | string

  • flags = 'g' | 'G' | 'i' | 'I'

...
avp_check("i:678", "lt/i:345/g");
avp_check("s:person","eq/$from/I");
avp_check("s:foo","gt/$bar/g");
avp_check("s:foo","re/sip:.*@bar.net/g");
...
				

1.4.8. avp_print()

Prints the list with all the AVPs from memory. This is only a helper/debug function.

...
avp_print();
...