[Asterisk-Users] how to add extension to mysql database

Kamran Ahmad p_kami at yahoo.com
Tue Feb 1 10:13:05 MST 2005


i want to know how we can add extension to mysql
database. i am using asterisk_addons and i have
checked that mysql database is connected with asterisk
here is trace

----------------------------------------------------
 [skipping app_intercom.so]
 [codec_ilbc.so] => (iLBC/PCM16 (signed linear) Codec
Translator)
 [app_txtcidname.so] => (TXTCIDName)
Asterisk Event Logger restarted
Asterisk Ready.
*CLI> database get kamran 4222
Value: 3000
*CLI> cdr mysql status
Connected to asteriskcdrdb at localhost, port 3306 with
username asteriskuser for 2 minutes, 0 seconds.
  Wrote 0 records since last restart.
*CLI>

-------------------------------------------------------

and i have added extension to my extension_table

mysql> select * from extensions_table;
+----+---------+-------+----------+------+--------------+
| id | context | exten | priority | app  | appdata    
 |
+----+---------+-------+----------+------+--------------+
|  1 | test    | 3000  |        1 | Dial |
SIP/${EXTEN} |
+----+---------+-------+----------+------+--------------+
1 row in set (0.00 sec)

 
mysql> select * from sip_buddies;
+----------+------+-------------+----------+-----------+----------+-------------+---------+-----------+----------+----------+------------+---------+---------------+---------------+----------+----------+---------+-----------+------+--------+------+-------------+------+---------+-------------+------------+----------------+--------+--------+----------+-------+----------+------------+---------+
| uniqueid | name | accountcode | amaflags | callgroup
| callerid | canreinvite | context | defaultip |
dtmfmode | fromuser | fromdomain | host    |
incominglimit | outgoinglimit | insecure | language |
mailbox | md5secret | nat  | permit | deny |
pickupgroup | port | qualify | restrictcid |
rtptimeout | rtpholdtimeout | secret | type   |
username | allow | disallow | regseconds | ipaddr  |
+----------+------+-------------+----------+-----------+----------+-------------+---------+-----------+----------+----------+------------+---------+---------------+---------------+----------+----------+---------+-----------+------+--------+------+-------------+------+---------+-------------+------------+----------------+--------+--------+----------+-------+----------+------------+---------+
|        1 | 3000 | NULL        | NULL     | NULL     
| kamran   |             | test    | NULL      | INFO 
   | NULL     | NULL       | dynamic | NULL          |
NULL          | NULL     | en       |         |       
   | no   | NULL   | NULL | NULL        | 5060 |      
  | NULL | 60         | NULL           | kamran |
friend | 3000     | alaw  |          | 1105743045 |
0.0.0.0 |
+----------+------+-------------+----------+-----------+----------+-------------+---------+-----------+----------+----------+------------+---------+---------------+---------------+----------+----------+---------+-----------+------+--------+------+-------------+------+---------+-------------+------------+----------------+--------+--------+----------+-------+----------+------------+---------+

------------------------------------------------------

but when i try to make a call to 3000 it is answering
with 403 forbiden. can any one tell me what is problem
is there any problem in connection with mysql or any
problem in  mysql tables

thanks
kamran


		
__________________________________ 
Do you Yahoo!? 
Read only the mail you want - Yahoo! Mail SpamGuard. 
http://promotions.yahoo.com/new_mail 



More information about the asterisk-users mailing list