Abid Saleem
2008-Aug-04 12:57 UTC
[asterisk-users] Asterisk Realtime with MySQL Registration Failed
Hi Everyone, I have configured Asterisk with MySQL with realtime using sip_buddies and extensions tables. Everything is ok and connection to mySql DB is fine when I type the command "realtime mysql status" on Ast CLI. I have one entry into sip_buddies table as below. | id | name | accountcode | amaflags | callgroup | callerid | canreinvite | context | defaultip | dtmfmode | fromuser | fromdomain | fullcontact | host | insecure | language | mailbox | md5secret | nat | deny | permit | mask | pickupgroup | port | qualify | restrictcid | rtptimeout | rtpholdtimeout | secret | type | username | disallow | allow | musiconhold | regseconds | ipaddr | regexten | cancallforward | setvar |+----+------+-------------+----------+-----------+----------+-------------+---------+-----------+----------+----------+------------+-------------+---------+----------+----------+---------+-----------+-----+------+--------+------+-------------+------+---------+-------------+------------+----------------+--------+--------+----------+----------+-------------------------+-------------+------------+--------+----------+----------------+--------+| 1 | Abid | NULL | NULL | NULL | NULL | no | default | NULL | rfc2833 | NULL | NULL | NULL | dynamic | NULL | NULL | NULL | NULL | yes | no | all | NULL | NULL | yes | NULL | NULL | NULL | NULL | 1504 | friend | 1504 | all | g729;ilbc;gsm;ulaw;alaw | NULL | 0 | | | yes | | When I try to register the softphone eyebeam on my PC to Asterisk, I get the following Error. Aug 4 15:02:30 NOTICE[17050]: chan_sip.c:11291 handle_request_register: Registration from '"1504"<sip:1504 at 10.168.20.13>' failed for '10.168.20.211' - ACL error (permit/deny) I have tried a lot of things but no luck. Another thing is that I have tried using the same fields in sip.conf file and it works fine. So it seems something wrong with account stored in MySql only. Please help me. Thanks in Advanced. Abid Saleem Product Engineer VoIP Solutions Comcerto Bahrain W.L.L _________________________________________________________________ Discover the new Windows Vista http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20080804/40007d33/attachment.htm
Alex Balashov
2008-Aug-04 13:19 UTC
[asterisk-users] Asterisk Realtime with MySQL Registration Failed
Abid Saleem wrote:> Aug 4 15:02:30 NOTICE[17050]: chan_sip.c:11291 handle_request_register: > Registration from '"1504"<sip:1504 at 10.168.20.13>' failed for > '10.168.20.211' - ACL error (permit/deny)Sounds like Asterisk thinks the corresponding SIP peer does not actually exist. -- Alex Balashov Evariste Systems Web : http://www.evaristesys.com/ Tel : (+1) (678) 954-0670 Direct : (+1) (678) 954-0671 Mobile : (+1) (706) 338-8599
Tilghman Lesher
2008-Aug-04 15:15 UTC
[asterisk-users] Asterisk Realtime with MySQL Registration Failed
On Monday 04 August 2008 07:57:46 Abid Saleem wrote:> | id | name | accountcode | amaflags | callgroup | callerid | canreinvite | > | context | defaultip | dtmfmode | fromuser | fromdomain | fullcontact | > | host ? ?| insecure | language | mailbox | md5secret | nat | deny | permit > | | mask | pickupgroup | port | qualify | restrictcid | rtptimeout | > | rtpholdtimeout | secret | type ? | username | disallow | allow ? ? ? ? ? > | ? ? ? ? | musiconhold | regseconds | ipaddr | regexten | cancallforward | > | setvar > | |+----+------+-------------+----------+-----------+----------+----------- > |--+---------+-----------+----------+----------+------------+-------------+ > |---------+----------+----------+---------+-----------+-----+------+------- > |-+------+-------------+------+---------+-------------+------------+------- > |---------+--------+--------+----------+----------+------------------------ > |-+-------------+------------+--------+----------+----------------+-------- > |+| ?1 | Abid | NULL ? ? ? ?| NULL ? ? | NULL ? ? ?| NULL ? ? | no ? ? ? ? > | ?| default | NULL ? ? ?| rfc2833 ?| NULL ? ? | NULL ? ? ? | NULL ? ? ? ?| > | dynamic | NULL ? ? | NULL ? ? | NULL ? ?| NULL ? ? ?| yes | no ? | all ? > | ?| NULL | NULL ? ? ? ?| yes ?| NULL ? ?| NULL ? ? ? ?| NULL ? ? ? | NULL > | ? ? ? ? ? | 1504 ? | friend | 1504 ? ? | all ? ? ?| > | g729;ilbc;gsm;ulaw;alaw | NULL ? ? ? ?| ? ? ? ? ?0 | ? ? ? ?| ? ? ? ? ?| > | yes ? ? ? ? ? ?| ? ? ? ?|You have deny=no, and permit=all, which are invalid values for permit and deny. Please set both of these fields to NULL. -- Tilghman
Abid Saleem
2008-Aug-05 08:49 UTC
[asterisk-users] Asterisk Realtime with MySQL Registration Failed
Dear Mr. Tilghman, Thank you for your attention. Actually it was NULL before when it was not working. I changed it to deny=no and permit=all after that thinking it could be the problem. Now I have changed it back to NULL using "update sip_buddies set deny=NULL, permit=NULL where id=1". You can see the table below now. +----+------+-------------+----------+-----------+----------+-------------+---------+-----------+----------+----------+------------+-------------+---------+----------+----------+---------+-----------+-----+------+--------+------+-------------+------+---------+-------------+------------+----------------+--------+--------+----------+----------+-------------------------+-------------+------------+--------+----------+----------------+--------+| id | name | accountcode | amaflags | callgroup | callerid | canreinvite | context | defaultip | dtmfmode | fromuser | fromdomain | fullcontact | host | insecure | language | mailbox | md5secret | nat | deny | permit | mask | pickupgroup | port | qualify | restrictcid | rtptimeout | rtpholdtimeout | secret | type | username | disallow | allow | musiconhold | regseconds | ipaddr | regexten | cancallforward | setvar |+----+------+-------------+----------+-----------+----------+-------------+---------+-----------+----------+----------+------------+-------------+---------+----------+----------+---------+-----------+-----+------+--------+------+-------------+------+---------+-------------+------------+----------------+--------+--------+----------+----------+-------------------------+-------------+------------+--------+----------+----------------+--------+| 1 | Abid | NULL | NULL | NULL | NULL | no | default | NULL | rfc2833 | NULL | NULL | NULL | dynamic | NULL | NULL | NULL | NULL | yes | NULL | NULL | NULL | NULL | yes | NULL | NULL | NULL | NULL | 1504 | friend | 1504 | all | g729;ilbc;gsm;ulaw;alaw | NULL | 0 | | | yes | |+----+------+-------------+----------+-----------+----------+-------------+---------+-----------+----------+----------+------------+-------------+---------+----------+----------+---------+-----------+-----+------+--------+------+-------------+------+---------+-------------+------------+----------------+--------+--------+----------+----------+-------------------------+-------------+------------+--------+----------+----------------+--------+But it still has the same problem. Any further suggessions. Thanks. Abid Saleem> From: tilghman at mail.jeffandtilghman.com> To: asterisk-users at lists.digium.com> Date: Mon, 4 Aug 2008 10:15:06 -0500> Subject: Re: [asterisk-users] Asterisk Realtime with MySQL Registration Failed> > On Monday 04 August 2008 07:57:46 Abid Saleem wrote:> > | id | name | accountcode | amaflags | callgroup | callerid | canreinvite |> > | context | defaultip | dtmfmode | fromuser | fromdomain | fullcontact |> > | host | insecure | language | mailbox | md5secret | nat | deny | permit> > | | mask | pickupgroup | port | qualify | restrictcid | rtptimeout |> > | rtpholdtimeout | secret | type | username | disallow | allow > > | | musiconhold | regseconds | ipaddr | regexten | cancallforward |> > | setvar> > | |+----+------+-------------+----------+-----------+----------+-----------> > |--+---------+-----------+----------+----------+------------+-------------+> > |---------+----------+----------+---------+-----------+-----+------+-------> > |-+------+-------------+------+---------+-------------+------------+-------> > |---------+--------+--------+----------+----------+------------------------> > |-+-------------+------------+--------+----------+----------------+--------> > |+| 1 | Abid | NULL | NULL | NULL | NULL | no > > | | default | NULL | rfc2833 | NULL | NULL | NULL |> > | dynamic | NULL | NULL | NULL | NULL | yes | no | all > > | | NULL | NULL | yes | NULL | NULL | NULL | NULL> > | | 1504 | friend | 1504 | all |> > | g729;ilbc;gsm;ulaw;alaw | NULL | 0 | | |> > | yes | |> > You have deny=no, and permit=all, which are invalid values for permit> and deny. Please set both of these fields to NULL.> > -- > Tilghman> > _______________________________________________> -- Bandwidth and Colocation Provided by http://www.api-digital.com --> > AstriCon 2008 - September 22 - 25 Phoenix, Arizona> Register Now: http://www.astricon.net> > asterisk-users mailing list> To UNSUBSCRIBE or update options visit:> http://lists.digium.com/mailman/listinfo/asterisk-users_________________________________________________________________ News, entertainment and everything you care about at Live.com. Get it now! http://www.live.com/getstarted.aspx -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20080805/7603d2c3/attachment.htm