6.1.1.11. DB() - put (dialplan function) - NEW
1. DB() - this function allows you to retrieve or store a value in the Asterisk’s database.
In this tutorial we will show you how to store a value in the Asterisk database and how this function will replace the old DBput application.
NOTE:Information about the Asterisk functions could be obtained by typing the show functions command.
Information about a particular function could be obtained by typing the show function <function name> on the Asterisk CLI command.
NOTE: In Asterisk versions 1.2 and up there are several applications which are mark as deprecated and which are no longer supported.
These applications will now become functions and these functions will be used in combination with the Set application.
You have to know that their functionality will be the same, but with a different syntax.
The DB() function is one of those functions which will replace the old applications. In this tutorial we will show you its syntax and possible usage.
Check out the old syntax of the DBput application here
Syntax:
List of the possible options
Purpose and usage
Prerequisites
Asterisk PBX configurations
iax.conf Configurations
extensions.conf Configurations
2. Screenshots of what you could see on the CLI of the Asterisk PBX
3. Additional information
4. Uploaded files
5. Similar dialplan functions
In this tutorial we will show you how to store a value in the Asterisk database and how this function will replace the old DBput application.
NOTE:Information about the Asterisk functions could be obtained by typing the show functions command.
Information about a particular function could be obtained by typing the show function <function name> on the Asterisk CLI command.
NOTE: In Asterisk versions 1.2 and up there are several applications which are mark as deprecated and which are no longer supported.
These applications will now become functions and these functions will be used in combination with the Set application.
You have to know that their functionality will be the same, but with a different syntax.
The DB() function is one of those functions which will replace the old applications. In this tutorial we will show you its syntax and possible usage.
Check out the old syntax of the DBput application here
Syntax:
Set(DB(family/key)=value)
List of the possible options
value - The value, which you want to set in the database
family/key - in which family/key the value to be retrieved.
family/key - in which family/key the value to be retrieved.
Purpose and usage
This function will allow you to store a value in the Asterisk’s database. This function has absolutely the same effect as the CLI command - database put <familiy> <key> <value>.
However, it gives you more flexibility, because you could manage the Asterisk’s database in your extensions.conf file.
Below, we will give you an example.
However, it gives you more flexibility, because you could manage the Asterisk’s database in your extensions.conf file.
Below, we will give you an example.
Prerequisites
To use this application you need a working Asterisk PBX with registered users in iax.conf, sip.conf or mgcp.conf(It depends on which protocol you would like to use) and made extensions. We are using Asterisk version1.2.1.
To see how the application works we recommend you to use our IAX softphone Idefisk. You could download it from here. Please also read our tutorial to learn how to configure it to work with Asterisk PBX.
To see how the application works we recommend you to use our IAX softphone Idefisk. You could download it from here. Please also read our tutorial to learn how to configure it to work with Asterisk PBX.
Asterisk PBX configurations
iax.conf Configurations
We need to create one user in the iax.conf file. This is because we are going to use the IAX2 protocol. If you want to use other protocol, such as SIP or MGCP, you have to do the configurations below respectively in sip.conf or mgcp.conf.
So, we have registered the user user1
Type=friend means that this user can make and receive calls. Host=dynamic means that the IP is not static but dynamic through a DHCP server. Allow=all means that the line which this user will use, could support all audio codecs. Context=test - this shows that this user is working with the extensions in this context of the configuration file extensions.conf.
Type=friend means that this user can make and receive calls. Host=dynamic means that the IP is not static but dynamic through a DHCP server. Allow=all means that the line which this user will use, could support all audio codecs. Context=test - this shows that this user is working with the extensions in this context of the configuration file extensions.conf.
extensions.conf Configurations
Now lets take a look at the extensions.conf file.
On the picture above you could see our extensions.conf file.
In this example, when somebody dials 100, the call will be answered by the Answer application.
The next executed extension will be the one which contains the Set application. As arguments in its brackets we have set the following - DB(data/test)=122.
DB is the name of the function.
Then we have data, which will be the family in the Asterisk’s database and test, which will be the key.
122 is the value.
NOTE: The function DB is case sensitive. You always have to write it in your dialplans with capital letters.
You can verify that the command is executed correctly, by entering the command database show on the CLI of your Asterisk PBX system.
In this example, when somebody dials 100, the call will be answered by the Answer application.
The next executed extension will be the one which contains the Set application. As arguments in its brackets we have set the following - DB(data/test)=122.
DB is the name of the function.
Then we have data, which will be the family in the Asterisk’s database and test, which will be the key.
122 is the value.
NOTE: The function DB is case sensitive. You always have to write it in your dialplans with capital letters.
You can verify that the command is executed correctly, by entering the command database show on the CLI of your Asterisk PBX system.
In order to be sure that the Asterisk PBX will hang up the line, when the conversation is over, it is a good idea to use the Hangup application.
2. Screenshots of what you could see on the CLI of the Asterisk PBX
3. Additional information
For more information about extensions.conf you can check here.
For more information about iax.conf you can check here.
This application is tested with our IAX softphone Idefisk. You can download it from here. For more information about this softphone please read our tutorial.
If you would like to test this application with the SIP channel you can read our tutorials about the SIP Softphones to learn how to configure them to work with Asterisk PBX
More information about the Set application could be found here
For more information about iax.conf you can check here.
This application is tested with our IAX softphone Idefisk. You can download it from here. For more information about this softphone please read our tutorial.
If you would like to test this application with the SIP channel you can read our tutorials about the SIP Softphones to learn how to configure them to work with Asterisk PBX
More information about the Set application could be found here
4. Uploaded files
5. Similar dialplan functions
| Add Comment |
Latest Headlines:
-
T.38 faxing with Zoiper 2.15 is now easier than ever
section: voip software
-
Asterisk 1.4.21 Released
section: Asterisk
-
Asterisk 1.4.20 Released
section: Asterisk
-
Asterisk 1.4.20-rc2 Released
section: Asterisk
-
Asterisk 1.4.20-rc1 Now Available
section: Asterisk
- News Archives (older news)
Latest Tutorials:
-
VMAuthenticate (dialplan application)
added 01/Mar/2008 15:57
-
Siptronic ST-530
added 06/Nov/2007 17:57
-
Siemens C455 IP hardphone
added 05/Nov/2007 10:24
-
Zoiper
added 22/Oct/2007 17:53
-
Grandstream GXP-2020
added 15/Oct/2007 18:17
Latest Comments:
-
I have download X-LITE but strangely , w...
tutorial: X-Lite - SIP softphone
-
Hello i can receive a call from outside ...
tutorial: X-Lite - SIP softphone
-
Hello, we are Howking Technology Co. Ltd...
section: technology
-
msneyi açmak istiyorum...
tutorial: Microsoft Windows Messenger 5.1
-
i just install X lit and i dont know how...
tutorial: X-Lite - SIP softphone