Kamran Ahmad
2005-Feb-01 10:13 UTC
[Asterisk-Users] how to add extension to mysql database
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@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