Kamran Ahmad
2005-Feb-03 03:40 UTC
[Asterisk-Users] 403 Forbidden when registering sip user database on backend
i am getting 403 Forbidden message from asterisk when
it try to register my user agent. i am basically
useing mysql through ODBC. i hvae checked ODBC
connecteion with
'ODBC Show' command.
------------------------------------------------------
*CLI> odbc show
Name: mysql1
DSN: asteriskdsn
Connected: yes
*CLI>
------------------------------------------------------
and user is added to sip_buddies table.
------------------------------------------------------
mysql> update sip_buddies set auth='plaintext';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
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 |
auth |
+----------+------+-------------+----------+-----------+----------+-------------+---------+-----------+----------+----------+------------+---------+---------------+---------------+----------+----------+---------+-----------+------+--------+------+-------------+------+---------+-------------+------------+----------------+--------+--------+----------+-------+----------+------------+--------+-----------+
| 1 | 3000 | NULL | NULL | NULL
| kamran | n | test | NULL | info | NULL
| NULL | dynamic | NULL | NULL |
y | en | | | no |
NULL | NULL | NULL | 5060 | | NULL
| 60 | NULL | | friend | 3000
| alaw | | 1105743045 | | plaintext |
+----------+------+-------------+----------+-----------+----------+-------------+---------+-----------+----------+----------+------------+---------+---------------+---------------+----------+----------+---------+-----------+------+--------+------+-------------+------+---------+-------------+------------+----------------+--------+--------+----------+-------+----------+------------+--------+-----------+
1 row in set (0.00 sec)
------------------------------------------------------
i have added values to extconfig.conf
------------------------------------------------------
[settings]
queues.conf =>
odbc,asteriskcdrdb,ast_config
sip.conf => odbc,asteriskcdrdb,sip_buddies
------------------------------------------------------
what is the problem with my asterisk
i think table is not binded with sip.conf. because
when i add user to sip.conf it is registring the user
and when i remove it from sip.conf it is giving 403
frobidden
can any one solve this issue
thanks
__________________________________
Do you Yahoo!?
Meet the all-new My Yahoo! - Try it today!
http://my.yahoo.com
Matthew Boehm
2005-Feb-03 07:26 UTC
[Asterisk-Users] 403 Forbidden when registering sip user databaseon backend
Your problem is that you are binding 'sip.conf' to a non-conf table. Replace sip.conf with sipfriends -Matthew ----- Original Message ----- From: "Kamran Ahmad" <p_kami@yahoo.com> To: <asterisk-users@lists.digium.com> Sent: Thursday, February 03, 2005 4:40 AM Subject: [Asterisk-Users] 403 Forbidden when registering sip user databaseon backend> i am getting 403 Forbidden message from asterisk when > it try to register my user agent. i am basically > useing mysql through ODBC. i hvae checked ODBC > connecteion with > 'ODBC Show' command. > ------------------------------------------------------ > *CLI> odbc show > Name: mysql1 > DSN: asteriskdsn > Connected: yes > *CLI> > ------------------------------------------------------ > and user is added to sip_buddies table. > ------------------------------------------------------ > mysql> update sip_buddies set auth='plaintext'; > Query OK, 1 row affected (0.00 sec) > Rows matched: 1 Changed: 1 Warnings: 0 > > 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 | > auth | >+----------+------+-------------+----------+-----------+----------+--------- ----+---------+-----------+----------+----------+------------+---------+---- -----------+---------------+----------+----------+---------+-----------+---- --+--------+------+-------------+------+---------+-------------+------------ +----------------+--------+--------+----------+-------+----------+---------- --+--------+-----------+> | 1 | 3000 | NULL | NULL | NULL > | kamran | n | test | NULL | info | NULL > | NULL | dynamic | NULL | NULL | > y | en | | | no | > NULL | NULL | NULL | 5060 | | NULL > | 60 | NULL | | friend | 3000 > | alaw | | 1105743045 | | plaintext | >+----------+------+-------------+----------+-----------+----------+--------- ----+---------+-----------+----------+----------+------------+---------+---- -----------+---------------+----------+----------+---------+-----------+---- --+--------+------+-------------+------+---------+-------------+------------ +----------------+--------+--------+----------+-------+----------+---------- --+--------+-----------+> 1 row in set (0.00 sec) > ------------------------------------------------------ > > > i have added values to extconfig.conf > ------------------------------------------------------ > [settings] > > queues.conf => > odbc,asteriskcdrdb,ast_config > sip.conf => odbc,asteriskcdrdb,sip_buddies > > > ------------------------------------------------------ > what is the problem with my asterisk > i think table is not binded with sip.conf. because > when i add user to sip.conf it is registring the user > and when i remove it from sip.conf it is giving 403 > frobidden > > can any one solve this issue > > thanks > > > > __________________________________ > Do you Yahoo!? > Meet the all-new My Yahoo! - Try it today! > http://my.yahoo.com > > > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users