{"id":455,"date":"2011-05-31T18:43:25","date_gmt":"2011-05-31T16:43:25","guid":{"rendered":""},"modified":"2018-11-01T01:05:38","modified_gmt":"2018-11-01T00:05:38","slug":"asterisk-18-instalation-and-configuration-odbc-and-dahdi-modules-debian-lenny","status":"publish","type":"post","link":"https:\/\/nil.uniza.sk\/en\/asterisk-18-instalation-and-configuration-odbc-and-dahdi-modules-debian-lenny\/","title":{"rendered":"Asterisk 1.8 instalation and configuration with ODBC and DAHDI modules on Debian (lenny)"},"content":{"rendered":"
This guide describes installation of Asterisk 1.8.4 with ODBC module for MySQL support and DAHDI module for timer clock support. The timer clock is needed by some applications such as MeetMe which provides conferences.<\/div>\n
 <\/div>\n
First of all, we make sure that the packages are up to date:<\/div>\n
\r\napt-get update<\/pre>\n
Then we install MySQL server and client libraries:<\/div>\n
\r\napt-get install mysql-server libmysqlclient-dev<\/pre>\n
We install ODBC as the database interface and also the ODBC libraries:<\/div>\n
\r\napt-get install unixodbc-dev libmyodbc<\/pre>\n
Additional components are required if we want to use MeetMe  application. We have to install additional drivers for the timer clock  support:<\/div>\n
\r\napt-get install libncurses-dev linux-headers-$(uname -r)<\/pre>\n
If we are doing the installation on a clean system we will need additional packages for compilation:<\/div>\n
\r\napt-get install gcc g++ make<\/pre>\n
Then we create the directory for Asterisk and download DAHDI package there. After that we unpack the package and compile it:<\/div>\n
\r\nmkdir \/usr\/src\/asterisk\r\ncd \/usr\/src\/asterisk\r\nwget http:\/\/downloads.digium.com\/pub\/telephony\/dahdi-linux-complete\/dahdi-linux-complete-current.tar.gz\r\ntar zxvf dahdi-linux-complete-current.tar.gz\r\ncd dahdi-linux-complete-2.4.1.2+2.4.1\r\nmake all\r\nmake install\r\nmake config<\/pre>\n
We load the dahdi module into Linux core after the compilation process:<\/div>\n
\r\nmodprobe dahdi_dummy<\/pre>\n
Then install additional library which is needed during the  compilation process of Asterisk. Otherwise the configure script will end  up with error:<\/div>\n
\r\napt-get install libxml12-dev<\/pre>\n
We download and unpack Asterisk and run the configure script which will check the system for needed requirements:<\/div>\n
\r\ncd \/usr\/local\/src\r\nwget http:\/\/downloads.asterisk.org\/pub\/telephony\/asterisk\/asterisk-1.8.4.tar.gz\r\ntar xvfz asterisk-1.8.4.tar.gz\r\ncd asterisk-1.8.4\r\n.\/configure<\/pre>\n
We need to find out what is the current version of Asterisk  1.8.x.x, because Asterisk is still in development. We must download the  appropriate version (just change the path for wget).<\/div>\n
Then we run the menuselect and select which modules to compile. It  is necessary to maximize the window to at least 80×27 characters.  Otherwise the menuselect will not run and end up with error.<\/div>\n
\r\nmake menuselect<\/pre>\n
Here we check the desired packages, language etc. In our particular case we need to go into the Voicemail Build Options <\/i>menu  and choose the ODBC_STORAGE option submitting it by spacebar. Then we  leave the menu by hitting the ESC key and we save the changes by hitting  S key. Now it is possible to compile and install Asterisk.<\/div>\n
\r\nmake\r\nmake install\r\n<\/pre>\n
It is reccomended to run following commands for creation of default  configuration files and for starting Asterisk after the boot:<\/div>\n
\r\nmake samples\r\nmake config<\/pre>\n
After the installation process we need to configure on which  IP adress and port will the Asterisk listen. This is done in  configuration file \/etc\/asterisk\/sip.conf<\/i> in section [general]<\/i>. We uncomment the row and write the appropriate adress and port.<\/div>\n
\r\nudpbindaddr=192.168.0.1:5060 ; IP address to bind UDP listen socket to (0.0.0.0 binds to all)<\/pre>\n
 <\/div>\n
Then we create the Asterisk database, grant permissions for this  databse and create tables. Don’t forget to change the asterisk password  in GRANT command.<\/div>\n
\r\nCREATE DATABASE asterisk;\r\n\r\nUSE asterisk;\r\n\r\nGRANT ALL ON asterisk.* TO asterisk@localhost IDENTIFIED BY 'asterisk_password';\r\n\r\nCREATE<\/span> TABLE<\/span> `sipusers`<\/span> (<\/span>\r\n`id`<\/span> int(<\/span>11<\/span>)<\/span> NOT<\/span> NULL<\/span> AUTO_INCREMENT<\/span>,<\/span>\r\n`name`<\/span> varchar(<\/span>80<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> ''<\/span>,<\/span>\r\n`host`<\/span> varchar(<\/span>31<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> ''<\/span>,<\/span>\r\n`nat`<\/span> varchar(<\/span>5<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> 'no'<\/span>,<\/span>\r\n`type`<\/span> enum(<\/span>'user'<\/span>,<\/span>'peer'<\/span>,<\/span>'friend'<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> 'friend'<\/span>,<\/span>\r\n`accountcode`<\/span> varchar(<\/span>20<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`amaflags`<\/span> varchar(<\/span>13<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`call-limit`<\/span> smallint(<\/span>5<\/span>)<\/span> UNSIGNED<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`callgroup`<\/span> varchar(<\/span>10<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`callerid`<\/span> varchar(<\/span>80<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`cancallforward`<\/span> char(<\/span>3<\/span>)<\/span> DEFAULT<\/span> 'yes'<\/span>,<\/span>\r\n`canreinvite`<\/span> char(<\/span>3<\/span>)<\/span> DEFAULT<\/span> 'yes'<\/span>,<\/span>\r\n`context`<\/span> varchar(<\/span>80<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`defaultip`<\/span> varchar(<\/span>15<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`dtmfmode`<\/span> varchar(<\/span>7<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`fromuser`<\/span> varchar(<\/span>80<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`fromdomain`<\/span> varchar(<\/span>80<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`insecure`<\/span> varchar(<\/span>4<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`language`<\/span> char(<\/span>2<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`mailbox`<\/span> varchar(<\/span>50<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`md5secret`<\/span> varchar(<\/span>80<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`deny`<\/span> varchar(<\/span>95<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`permit`<\/span> varchar(<\/span>95<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`mask`<\/span> varchar(<\/span>95<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`musiconhold`<\/span> varchar(<\/span>100<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`pickupgroup`<\/span> varchar(<\/span>10<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`qualify`<\/span> char(<\/span>3<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`regexten`<\/span> varchar(<\/span>80<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`restrictcid`<\/span> char(<\/span>3<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`rtptimeout`<\/span> char(<\/span>3<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`rtpholdtimeout`<\/span> char(<\/span>3<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`secret`<\/span> varchar(<\/span>80<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`setvar`<\/span> varchar(<\/span>100<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`disallow`<\/span> varchar(<\/span>100<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`allow`<\/span> varchar(<\/span>100<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`fullcontact`<\/span> varchar(<\/span>80<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> ''<\/span>,<\/span>\r\n`ipaddr`<\/span> varchar(<\/span>15<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> ''<\/span>,<\/span>\r\n`port`<\/span> mediumint(<\/span>5<\/span>)<\/span> UNSIGNED<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> '0'<\/span>,<\/span>\r\n`regserver`<\/span> varchar(<\/span>100<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`regseconds`<\/span> int(<\/span>11<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> '0'<\/span>,<\/span>\r\n`lastms`<\/span> int(<\/span>11<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> '0'<\/span>,<\/span>\r\n`username`<\/span> varchar(<\/span>80<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> ''<\/span>,<\/span>\r\n`defaultuser`<\/span> varchar(<\/span>80<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> ''<\/span>,<\/span>\r\n`subscribecontext`<\/span> varchar(<\/span>80<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`useragent`<\/span> varchar(<\/span>20<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`sippasswd`<\/span> varchar(<\/span>80<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\nPRIMARY<\/span> KEY<\/span>  (<\/span>`id`<\/span>)<\/span>,<\/span>\r\nUNIQUE<\/span> KEY<\/span> `name_uk`<\/span> (<\/span>`name`<\/span>)<\/span>\r\n)<\/span>;\r\n \r\nCREATE<\/span> TABLE<\/span> `sipregs`<\/span> (<\/span>\r\n`id`<\/span> int(<\/span>11<\/span>)<\/span> NOT<\/span> NULL<\/span> AUTO_INCREMENT<\/span>,<\/span>\r\n`name`<\/span> varchar(<\/span>80<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> ''<\/span>,<\/span>\r\n`fullcontact`<\/span> varchar(<\/span>80<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> ''<\/span>,<\/span>\r\n`ipaddr`<\/span> varchar(<\/span>15<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> ''<\/span>,<\/span>\r\n`port`<\/span> mediumint(<\/span>5<\/span>)<\/span> UNSIGNED<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> '0'<\/span>,<\/span>\r\n`username`<\/span> varchar(<\/span>80<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> ''<\/span>,<\/span>\r\n`regserver`<\/span> varchar(<\/span>100<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`regseconds`<\/span> int(<\/span>11<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> '0'<\/span>,<\/span>\r\nPRIMARY<\/span> KEY<\/span>  (<\/span>`id`<\/span>)<\/span>,<\/span>\r\nUNIQUE<\/span> KEY<\/span> `name`<\/span> (<\/span>`name`<\/span>)<\/span>\r\n)<\/span>;\r\n \r\nCREATE<\/span> TABLE<\/span> IF<\/span> NOT<\/span> EXISTS<\/span> `voiceboxes`<\/span> (<\/span>\r\n`uniqueid`<\/span> int(<\/span>4<\/span>)<\/span> NOT<\/span> NULL<\/span> AUTO_INCREMENT<\/span>,<\/span>\r\n`customer_id`<\/span> varchar(<\/span>10<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`context`<\/span> varchar(<\/span>10<\/span>)<\/span> NOT<\/span> NULL<\/span>,<\/span>\r\n`mailbox`<\/span> varchar(<\/span>10<\/span>)<\/span> NOT<\/span> NULL<\/span>,<\/span>\r\n`password`<\/span> varchar(<\/span>12<\/span>)<\/span> NOT<\/span> NULL<\/span>,<\/span>\r\n`fullname`<\/span> varchar(<\/span>150<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`email`<\/span> varchar(<\/span>50<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`pager`<\/span> varchar(<\/span>50<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`tz`<\/span> varchar(<\/span>10<\/span>)<\/span> DEFAULT<\/span> 'central'<\/span>,<\/span>\r\n`attach`<\/span> enum(<\/span>'yes'<\/span>,<\/span>'no'<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> 'yes'<\/span>,<\/span>\r\n`saycid`<\/span> enum(<\/span>'yes'<\/span>,<\/span>'no'<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> 'yes'<\/span>,<\/span>\r\n`dialout`<\/span> varchar(<\/span>10<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`callback`<\/span> varchar(<\/span>10<\/span>)<\/span> DEFAULT<\/span> NULL<\/span>,<\/span>\r\n`review`<\/span> enum(<\/span>'yes'<\/span>,<\/span>'no'<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> 'no'<\/span>,<\/span>\r\n`operator`<\/span> enum(<\/span>'yes'<\/span>,<\/span>'no'<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> 'no'<\/span>,<\/span>\r\n`envelope`<\/span> enum(<\/span>'yes'<\/span>,<\/span>'no'<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> 'no'<\/span>,<\/span>\r\n`sayduration`<\/span> enum(<\/span>'yes'<\/span>,<\/span>'no'<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> 'no'<\/span>,<\/span>\r\n`saydurationm`<\/span> tinyint(<\/span>4<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> '1'<\/span>,<\/span>\r\n`sendvoicemail`<\/span> enum(<\/span>'yes'<\/span>,<\/span>'no'<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> 'no'<\/span>,<\/span>\r\n`delete`<\/span> enum(<\/span>'yes'<\/span>,<\/span>'no'<\/span>)<\/span> NULL<\/span> DEFAULT<\/span> 'no'<\/span>,<\/span>\r\n`nextaftercmd`<\/span> enum(<\/span>'yes'<\/span>,<\/span>'no'<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> 'yes'<\/span>,<\/span>\r\n`forcename`<\/span> enum(<\/span>'yes'<\/span>,<\/span>'no'<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> 'no'<\/span>,<\/span>\r\n`forcegreetings`<\/span> enum(<\/span>'yes'<\/span>,<\/span>'no'<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> 'no'<\/span>,<\/span>\r\n`hidefromdir`<\/span> enum(<\/span>'yes'<\/span>,<\/span>'no'<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> 'yes'<\/span>,<\/span>\r\n`stamp`<\/span> timestamp NOT<\/span> NULL<\/span> DEFAULT<\/span> CURRENT_TIMESTAMP ON<\/span> UPDATE<\/span> CURRENT_TIMESTAMP,<\/span>\r\nPRIMARY<\/span> KEY<\/span>  (<\/span>`uniqueid`<\/span>)<\/span>,<\/span>\r\nKEY<\/span> `mailbox_context`<\/span> (<\/span>`mailbox`<\/span>,<\/span>`context`<\/span>)<\/span>\r\n)<\/span>;\r\n \r\nCREATE<\/span> TABLE<\/span> `voicemessages`<\/span> (<\/span>\r\n`id`<\/span> int(<\/span>11<\/span>)<\/span> NOT<\/span> NULL<\/span> AUTO_INCREMENT<\/span>,<\/span>\r\n`msgnum`<\/span> int(<\/span>11<\/span>)<\/span> NOT<\/span> NULL<\/span> DEFAULT<\/span> '0'<\/span>,<\/span>\r\n`dir`<\/span> varchar(<\/span>80<\/span>)<\/span> DEFAULT<\/span> ''<\/span>,<\/span>\r\n`context`<\/span> varchar(<\/span>80<\/span>)<\/span> DEFAULT<\/span> ''<\/span>,<\/span>\r\n`macrocontext`<\/span> varchar(<\/span>80<\/span>)<\/span> DEFAULT<\/span> ''<\/span>,<\/span>\r\n`callerid`<\/span> varchar(<\/span>40<\/span>)<\/span> DEFAULT<\/span> ''<\/span>,<\/span>\r\n`origtime`<\/span> varchar(<\/span>40<\/span>)<\/span> DEFAULT<\/span> ''<\/span>,<\/span>\r\n`duration`<\/span> varchar(<\/span>20<\/span>)<\/span> DEFAULT<\/span> ''<\/span>,<\/span>\r\n`mailboxuser`<\/span> varchar(<\/span>80<\/span>)<\/span> DEFAULT<\/span> ''<\/span>,<\/span>\r\n`mailboxcontext`<\/span> varchar(<\/span>80<\/span>)<\/span> DEFAULT<\/span> ''<\/span>,<\/span>\r\n`recording`<\/span> longblob,<\/span>\r\n`flag`<\/span> varchar(<\/span>128<\/span>)<\/span> DEFAULT<\/span> ''<\/span>,<\/span>\r\nPRIMARY<\/span> KEY<\/span>  (<\/span>`id`<\/span>)<\/span>,<\/span>\r\nKEY<\/span> `dir`<\/span> (<\/span>`dir`<\/span>)<\/span>\r\n)<\/span>;<\/pre>\n
Sipuser table is a standard table for storing user profiles and  their passwords for authentication. Sipregs table is used for location database purposes. Tables voiceboxes and voicemessages are needed by  voicemail service.<\/div>\n
 <\/div>\n
Then we edit the configuration file for ODBC \/etc\/odbcinst.ini<\/i> :<\/div>\n
\r\n[MySQL]\r\nDescription = MySQL driver\r\nDriver = \/usr\/lib\/odbc\/libmyodbc.so\r\nSetup = \/usr\/lib\/odbc\/libodbcmyS.so\r\nCPTimeout =\r\nCPReuse =\r\nUsageCount = 1<\/pre>\n
And we add following rows into \/etc\/odbc.ini<\/i> file:<\/div>\n
\r\n[MySQL-asterisk]\r\nDescription = MySQL Asterisk database\r\nTrace = Off\r\nTraceFile = stderr\r\nDriver = MySQL\r\nSERVER = localhost\r\nUSER = asterisk\r\nPASSWORD = asterisk_password\r\nPORT = 3306\r\nDATABASE = asterisk<\/pre>\n
In configuration file for Asterisk \/etc\/asterisk\/res_odbc.conf<\/i>, we need to uncomment the appropriate rows and add the following:<\/div>\n
\r\n[asterisk]\r\nenabled => yes\r\ndsn => MySQL-asterisk\r\nusername => asterisk\r\npassword => asterisk_password\r\npre-connect => yes\r\n<\/pre>\n
Then we add following rows for users, location database and voicemail to the \/etc\/asterisk\/extconfig.conf<\/i> file:<\/div>\n
\r\nsipusers => odbc,asterisk,sipusers\r\nsippeers => odbc,asterisk,sipusers\r\nsipregs => odbc,asterisk,sipregs\r\nvoicemail => odbc,asterisk,voiceboxes\r\n<\/pre>\n
The last step is to add users to the databse. For our purposes we add users 101, 102 a 103 to the database and to create voicemail accounts for them. The passwords for authentication are 101, 102, 103 and the passwords for voicemail are 1234. We can also add more new users in such a manner.<\/div>\n
\r\nmysql -r -p\r\nuse asterisk\r\n
INSERT<\/span> INTO<\/span> sipusers (<\/span>name,<\/span> username,<\/span> host,<\/span> sippasswd,<\/span> fromuser,<\/span> fromdomain,<\/span> mailbox)<\/span>\r\n  VALUES<\/span> (<\/span>'101'<\/span>,<\/span> '101'<\/span>,<\/span> 'dynamic'<\/span>,<\/span> '101'<\/span>,<\/span> '101'<\/span>,<\/span> 'yourdomain.com'<\/span>,<\/span> '101'<\/span>)<\/span>;\r\nINSERT<\/span> INTO<\/span> sipusers (<\/span>name,<\/span> username,<\/span> host,<\/span> sippasswd,<\/span> fromuser,<\/span> fromdomain,<\/span> mailbox)<\/span>\r\n  VALUES<\/span> (<\/span>'102'<\/span>,<\/span> '102'<\/span>,<\/span> 'dynamic'<\/span>,<\/span> '102'<\/span>,<\/span> '102'<\/span>,<\/span> '<\/span>yourdomain.com<\/span>'<\/span>,<\/span> '102'<\/span>)<\/span>;\r\nINSERT<\/span> INTO<\/span> sipusers (<\/span>name,<\/span> username,<\/span> host,<\/span> sippasswd,<\/span> fromuser,<\/span> fromdomain,<\/span> mailbox)<\/span>\r\n  VALUES<\/span> (<\/span>'103'<\/span>,<\/span> '103'<\/span>,<\/span> 'dynamic'<\/span>,<\/span> '103'<\/span>,<\/span> '103'<\/span>,<\/span> '<\/span>yourdomain.com<\/span>'<\/span>,<\/span> '103'<\/span>)<\/span>;\r\n \r\nINSERT<\/span> INTO<\/span> sipregs(<\/span>name)<\/span> VALUES<\/span>(<\/span>'101'<\/span>)<\/span>;\r\nINSERT<\/span> INTO<\/span> sipregs(<\/span>name)<\/span> VALUES<\/span>(<\/span>'102'<\/span>)<\/span>;\r\nINSERT<\/span> INTO<\/span> sipregs(<\/span>name)<\/span> VALUES<\/span>(<\/span>'103'<\/span>)<\/span>;\r\n \r\nINSERT<\/span> INTO<\/span> voiceboxes(<\/span>customer_id,<\/span> context,<\/span> mailbox,<\/span> password)<\/span> VALUES<\/span> (<\/span>'101'<\/span>,<\/span> 'default'<\/span>,<\/span> '101'<\/span>,<\/span> '1234'<\/span>)<\/span>;\r\nINSERT<\/span> INTO<\/span> voiceboxes(<\/span>customer_id,<\/span> context,<\/span> mailbox,<\/span> password)<\/span> VALUES<\/span> (<\/span>'102'<\/span>,<\/span> 'default'<\/span>,<\/span> '102'<\/span>,<\/span> '1234'<\/span>)<\/span>;\r\nINSERT<\/span> INTO<\/span> voiceboxes(<\/span>customer_id,<\/span> context,<\/span> mailbox,<\/span> password)<\/span> VALUES<\/span> (<\/span>'103'<\/span>,<\/span> 'default'<\/span>,<\/span> '103'<\/span>,<\/span> '1234'<\/span>)<\/span>;<\/pre>\n
Finally, we can run Asterisk after these steps.<\/p>","protected":false},"excerpt":{"rendered":"
This guide describes installation of Asterisk 1.8.4 with  ODBC module for MySQL support and DAHDI module for timer clock support.  The timer clock is needed by some applications such as MeetMe which  provides conferences.<\/div>\n
 <\/div>\n
First of all, we make sure that the packages are up to date:<\/div>\n
\r\napt-get update<\/pre>\n
Then we install MySQL server and client libraries:<\/div>\n
\r\napt-get install mysql-server libmysqlclient-dev<\/pre>\n
We install ODBC as the database interface and also the ODBC libraries:<\/div>\n
","protected":false},"author":450,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[777],"tags":[],"class_list":["post-455","post","type-post","status-publish","format-standard","hentry","category-asterisk-en"],"taxonomy_info":{"category":[{"value":777,"label":"Asterisk"}]},"featured_image_src_large":false,"author_info":{"display_name":"","author_link":"https:\/\/nil.uniza.sk\/en\/author\/"},"comment_info":3,"category_info":[{"term_id":777,"name":"Asterisk","slug":"asterisk-en","term_group":0,"term_taxonomy_id":775,"taxonomy":"category","description":"","parent":771,"count":3,"filter":"raw","cat_ID":777,"category_count":3,"category_description":"","cat_name":"Asterisk","category_nicename":"asterisk-en","category_parent":771}],"tag_info":false,"_links":{"self":[{"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/posts\/455","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/users\/450"}],"replies":[{"embeddable":true,"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/comments?post=455"}],"version-history":[{"count":0,"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/posts\/455\/revisions"}],"wp:attachment":[{"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/media?parent=455"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/categories?post=455"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/tags?post=455"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}