All, I get this whenever trying to dial to a peer when the peer
registered to another server. I'm basically trying to use realtime to
check for the peer and dial it.
Mar 24 09:16:47 VERBOSE[4527]: -- Executing Dial("SIP/brak-f69f",
"IAX2/brak-test/107") in new stack
Mar 24 09:16:47 DEBUG[4527]: MySQL RealTime: Retrieve SQL: SELECT * FROM
sip_users WHERE name = 'brak-test'
Mar 24 09:16:47 DEBUG[4527]: MySQL RealTime: Everything is fine.
Mar 24 09:16:47 NOTICE[4527]: Unable to create channel of type 'IAX2'
(cause 3)
Mar 24 09:16:47 VERBOSE[4527]: == Everyone is busy/congested at this
time (1:0/1/0)
Mar 24 09:16:47 DEBUG[4527]: Exiting with DIALSTATUS=CONGESTION.
When I query mysql manually I see this (using the exact same command
that mysql realtime did). Looks fine to me, wheres the problem at?? can
I debug anymore somehow? Thanks
mysql> SELECT * FROM sip_users WHERE name = 'brak-test'
-> ;
+----+-----------+-------------+----------+-----------+----------+------
-------+----------+-------------+-----------+----------+----------+-----
-------+---------+----------+---------+-----+-------------+------+------
---+-------------+------------+----------------+-----------+--------+---
--------+----------+----------------+------------+---------------+------
----------+
| id | name | accountcode | amaflags | callgroup | callerid |
canreinvite | context | peercontext | defaultip | dtmfmode | fromuser |
fromdomain | host | insecure | mailbox | nat | pickupgroup | port |
qualify | restrictcid | rtptimeout | rtpholdtimeout | secret | type
| username | disallow | allow | regseconds | ipaddr |
cancallforward |
+----+-----------+-------------+----------+-----------+----------+------
-------+----------+-------------+-----------+----------+----------+-----
-------+---------+----------+---------+-----+-------------+------+------
---+-------------+------------+----------------+-----------+--------+---
--------+----------+----------------+------------+---------------+------
----------+
| 3 | brak-test | NULL | NULL | NULL | NULL | no
| outbound | incoming | NULL | NULL | NULL | NULL
| dynamic | NULL | NULL | 0 | NULL | 4569 | NULL |
NULL | NULL | NULL | brak-test | friend | blah
| all | ulaw;alaw;g729 | 1111673371 | 206.80.xxx.xxx | yes
|
+----+-----------+-------------+----------+-----------+----------+------
-------+----------+-------------+-----------+----------+----------+-----
-------+---------+----------+---------+-----+-------------+------+------
---+-------------+------------+----------------+-----------+--------+---
--------+----------+----------------+------------+---------------+------
----------+
Matt Schulte wrote:> Mar 24 09:16:47 NOTICE[4527]: Unable to create channel of type 'IAX2'(cause 3) Doesn't seem like a RealTime issue to me. Did you add that user into the flatfile and test that way? -Matthew
Flatfile meaning iax.conf? Yes.. -----Original Message----- From: Matthew Boehm [mailto:mboehm@cytelcom.com] Sent: Thursday, March 24, 2005 8:49 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Realtime mysql problem? Matt Schulte wrote:> Mar 24 09:16:47 NOTICE[4527]: Unable to create channel of type 'IAX2'(cause 3) Doesn't seem like a RealTime issue to me. Did you add that user into the flatfile and test that way? -Matthew _______________________________________________ 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
Matt Schulte wrote:> Flatfile meaning iax.conf? Yes..Sounds like a data problem to me. Paste your iaxpeers/iaxusers table schema and iax.conf section that is relevant to the phone. -Matthew
+----+-----------+-------------+----------+-----------+----------+------ -------+---------------+------------- Here goes it's going to be messy :-) I followed the directions off the wiki. This *should* work just fine right? I built the table according to the directions, every field is varchar though, could that be a problem? Thanks again, Matt +-----------+----------+----------+------------+---------+----------+--- ------+-----+-------------+--------+---------+-------------+------------ +----------------+-----------+--------+-----------+----------+---------- ------+------------+---------------+----------------+ | id | name | accountcode | amaflags | callgroup | callerid | canreinvite | context | peercontext | defaultip | dtmfmode | fromuser | fromdomain | host | insecure | mailbox | nat | pickupgroup | port | qualify | restrictcid | rtptimeout | rtpholdtimeout | secret | type | username | disallow | allow | regseconds | ipaddr | cancallforward | +----+-----------+-------------+----------+-----------+----------+------ -------+---------------+-------------+-----------+----------+----------+ ------------+---------+----------+---------+-----+-------------+-------- +---------+-------------+------------+----------------+-----------+----- ---+-----------+----------+----------------+------------+--------------- +----------------+ | 3 | brak-test | [NULL] | [NULL] | [NULL] | [NULL] | no | outbound | incoming | [NULL] | [NULL] | [NULL] | [NULL] | dynamic | [NULL] | [NULL] | 0 | [NULL] | 4569 | [NULL] | [NULL] | [NULL] | [NULL] | blah | friend | brak-test | all | ulaw;alaw;g729 | 1112015162 | 206.80.254.254| yes | +----+-----------+-------------+----------+-----------+----------+------ -------+---------------+-------------+-----------+----------+----------+ ------------+---------+----------+---------+-----+-------------+-------- +---------+-------------+------------+----------------+-----------+----- ---+-----------+----------+----------------+------------+--------------- +----------------+ Matt Schulte wrote:> Flatfile meaning iax.conf? Yes..Sounds like a data problem to me. Paste your iaxpeers/iaxusers table schema and iax.conf section that is relevant to the phone. -Matthew _______________________________________________ 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
Ok, that was straight from the wiki. Still does not work, I tried it from the iax.conf, etc files and it works just fine. I even tried terminating/placing calls on the same server with realtime and it works fine. Is realtime broken? Is there anything else I can test with? Thanks, Matt -----Original Message----- From: Matthew Boehm [mailto:mboehm@cytelcom.com] Sent: Monday, March 28, 2005 8:46 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Realtime mysql problem? Matt Schulte wrote:> +----+-----------+-------------+----------+-----------+----------+---- > +----+-----------+-------------+----------+-----------+----------+-- > -------+---------------+------------- > Here goes it's going to be messy :-) I followed the directions off the> wiki. This *should* work just fine right? I built the table according > to the directions, every field is varchar though, could that be a > problem?The value of "nat" should be "no" or "yes", not 0 (zero). Try that and reload everything. -Matthew _______________________________________________ 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
Matt Schulte wrote:> Ok, that was straight from the wiki. Still does not work, I tried it > from the iax.conf, etc files and it works just fine. I even tried > terminating/placing calls on the same server with realtime and it > works fine. Is realtime broken? Is there anything else I can test > with?Hrm. Have you tried "realtime load iaxpeers 622" ? That command should confirm that the info is indeeded being read via RealTime. Do you have RealTime cache turned on/off? You might try turning it off/on (for the sake of trying something else). -Matthew
I did that and it's finding the peer correctly, here's my extconfig.conf by the way. All the sip/iax users are using the same table, per the wiki. [settings] iaxusers => mysql,asterisk,sip_users iaxpeers => mysql,asterisk,sip_users sipusers => mysql,asterisk,sip_users sippeers => mysql,asterisk,sip_users How do you toggle the realtime "cache"? If there were too many fields in the table, could you foresee this being a problem? ie iax users have peercontext and auth. I was going to try odbc to see if that changes the outcome but it's a pain in the a$$ (imho) to get on Fedora.. Will let you know unless you have any other ideas.. Thanks much for your help. Matt -----Original Message----- From: Matthew Boehm [mailto:mboehm@cytelcom.com] Sent: Tuesday, March 29, 2005 9:50 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Realtime mysql problem? Matt Schulte wrote:> Ok, that was straight from the wiki. Still does not work, I tried it > from the iax.conf, etc files and it works just fine. I even tried > terminating/placing calls on the same server with realtime and it > works fine. Is realtime broken? Is there anything else I can test > with?Hrm. Have you tried "realtime load iaxpeers 622" ? That command should confirm that the info is indeeded being read via RealTime. Do you have RealTime cache turned on/off? You might try turning it off/on (for the sake of trying something else). -Matthew _______________________________________________ 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
Sorry for the delay, do you have any clue when realtime will get added to stable? I never did get this working but before I go too much further I'd like to run production on a stable version.. I'll try out SIP today and let you know, the reason I'm using IAX is because everything SIP we do is through SER. Not to mention since realtime doesn't support qualify= and NAT mode must be manually set, it's kind of pointless to use Asterisk for SIP. :-)> Just for curiosity sake, have you tried any SIP RealTime stuff?Perhaps this is an IAX problem? I remember > helping a guy a few weeks ago get his SIP RealTime working. This is the first IAX I've dealt with. And I have > no IAX stuff to test with. -----Original Message----- From: Matthew Boehm [mailto:mboehm@cytelcom.com] Sent: Wednesday, March 30, 2005 9:03 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Realtime mysql problem? Matt Schulte wrote:> How do you toggle the realtime "cache"?Check in the configs/iax.conf.sample file of a recent CVS download and it should be in there.> If there were too many fields > in the table, could you foresee this being a problem?No, because I have lots of extra company specific fields in my sip_users table that asterisk doesn't use at all and I've had no problems.> ie iax users have peercontext and auth.Just for curiosity sake, have you tried any SIP RealTime stuff? Perhaps this is an IAX problem? I remember helping a guy a few weeks ago get his SIP RealTime working. This is the first IAX I've dealt with. And I have no IAX stuff to test with. -Matthew _______________________________________________ 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
Well, I made several posts. Basically realtime works fine on the system you register to, if you try to contact that peer from another Ast server (running realtime), it does a SELECT query and all finds the peer and continues to say "Unable to contact peer" as if the user doesn't exist. I even went as far as packet sniffing and noticed it doesn't ever go out on port 4569 or anything. Again, I've made several posts about this before for full details. :-) Thanks, Matt -----Original Message----- From: Wojciech Tryc [mailto:wojtek@tryc.ca] Sent: Monday, April 04, 2005 8:26 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Realtime mysql problem? What is your problem with IAX in realtime? I have it working (finally). Wojtek ----- Original Message ----- From: "Matt Schulte" <mschulte@netlogic.net> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users@lists.digium.com> Sent: Monday, April 04, 2005 9:01 AM Subject: RE: [Asterisk-Users] Realtime mysql problem? Sorry for the delay, do you have any clue when realtime will get added to stable? I never did get this working but before I go too much further I'd like to run production on a stable version.. I'll try out SIP today and let you know, the reason I'm using IAX is because everything SIP we do is through SER. Not to mention since realtime doesn't support qualify= and NAT mode must be manually set, it's kind of pointless to use Asterisk for SIP. :-)> Just for curiosity sake, have you tried any SIP RealTime stuff?Perhaps this is an IAX problem? I remember > helping a guy a few weeks ago get his SIP RealTime working. This is the first IAX I've dealt with. And I have > no IAX stuff to test with. -----Original Message----- From: Matthew Boehm [mailto:mboehm@cytelcom.com] Sent: Wednesday, March 30, 2005 9:03 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Realtime mysql problem? Matt Schulte wrote:> How do you toggle the realtime "cache"?Check in the configs/iax.conf.sample file of a recent CVS download and it should be in there.> If there were too many fields > in the table, could you foresee this being a problem?No, because I have lots of extra company specific fields in my sip_users table that asterisk doesn't use at all and I've had no problems.> ie iax users have peercontext and auth.Just for curiosity sake, have you tried any SIP RealTime stuff? Perhaps this is an IAX problem? I remember helping a guy a few weeks ago get his SIP RealTime working. This is the first IAX I've dealt with. And I have no IAX stuff to test with. -Matthew _______________________________________________ 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 _______________________________________________ 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 _______________________________________________ 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
>> do you have any clue when realtime will get added to stable?> It won't.why not?>> Not to mention since >> realtime doesn't support qualify= and NAT mode must be manually set,> Have you been using RTC? (RealTime Cache) It fixes the NAT/MWIproblem. I haven't tried this yet because of my other issue, is RTC on by default?
> Now, this has been answered many, many, many times...in fact..Ibelieve Olle answered this in his "Welcome to Asterisk" post he sent out over the weekend. AAHH my bad, I should have asked *when* it will go stable.. ;-)
Matt Schulte wrote:> > > > > > >> Now, this has been answered many, many, many times...in fact..I >> >> >believe Olle answered this in his "Welcome to Asterisk" post he sent out >over the weekend. > > >Hmm, into my mailbox it did not come, ...
Ok, rtcachefriends=yes seemed to have fixed my problem(s). With both SIP and IAX2, now the question is why isn't this enabled by default? There must be a "downside" to using this feature, even though it pulls from mysql regardless if it's cached or not. thoughts? Thanks for your help though, this has seemed to address the issue :-) Matt -----Original Message----- From: Matthew Boehm [mailto:mboehm@cytelcom.com] Sent: Monday, April 04, 2005 10:59 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Realtime mysql problem? Matt Schulte wrote:>> Now, this has been answered many, many, many times...in fact..I > believe Olle answered this in his "Welcome to Asterisk" post he sent > out over the weekend. > > AAHH my bad, I should have asked *when* it will go stable.. ;-)When it will go stable is anybodys guess, including the developers. Again like Olle said, the developers will soon create a 1.1 code freeze which will be tested out the a$$ and only bug fixes will be introduced into the 1.1.* branch. Then after (hopefully*) a month of extremely regirous testing of the 1.1.* branch, 1.2 will be released. -Matthew *I say 'hopefully' because I've played many MMORPGS where "large updates" were introduced and had the update remained on the test server for another month, many of the bugs that were discovered could have been fixed before releasing bugy updates to the general public. _______________________________________________ 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
Ok, thanks again. Just to wrap up (for the list), rtcachefriends must be enabled for all your backup ast servers if you want to reach them from realtime.. Can't wait for this mod to hit the next major stable, we'll be all over it! :-) Matt -----Original Message----- From: mboehm@cytelcom.com [mailto:mboehm@cytelcom.com] Sent: Tuesday, April 05, 2005 1:26 PM To: Matt Schulte Subject: RE: [Asterisk-Users] Realtime mysql problem? Quoting Matt Schulte <mschulte@netlogic.net>:> Ok, > > rtcachefriends=yes seemed to have fixed my problem(s). With both SIP > and IAX2, now the question is why isn't this enabled by default? There> must be a "downside" to using this feature, even though it pulls from > mysql regardless if it's cached or not. thoughts? Thanks for your help> though, this has seemed to address the issue :-)The "downside" is that when using the cache you use some memory. When using non-cache everything is read from database all the time. When using cache, the first time a SIP UA registers, its info gets saved into the same linkd-list that static sip.conf users are in. I guess that really isn't a downside cause then future lookups would be faster..hmm..don't think there really is a downside. The reason it isn't on by default is because it is a new feature that needs to be more tested. -Matthew ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.