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