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