[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