[asterisk-bugs] [Asterisk 0010584]: Can not register with server from sip.conf if domain name or IP is not in real time db

[noreply at bugs.digium.com]

A NOTE has been added to this issue. 
====================================================================== 
http://bugs.digium.com/view.php?id=10584 
====================================================================== 
Reported By:                Dovid
Assigned To:                
====================================================================== 
Project:                    Asterisk
Issue ID:                   10584
Category:                   PBX/pbx_realtime
Reproducibility:            always
Severity:                   major
Priority:                   normal
Status:                     new
Asterisk Version:            1.4.6 
SVN Branch (only for SVN checkouts, not tarball releases): N/A  
SVN Revision (number only!):  
Disclaimer on File?:        N/A 
Request Review:              
====================================================================== 
Date Submitted:             08-28-2007 13:58 CDT
Last Modified:              08-28-2007 14:00 CDT
====================================================================== 
Summary:                    Can not register with server from sip.conf if domain
name or IP is not in real time db
Description: 
I am having a problem which I can replicate on 1.4.6 but I never have the
problem on 1.2.24. (or on any 1.2.X for that matter).

When trying to register with another server (in this case SER) if I am
using real time asterisk queries the asterisk real time for the host name
(or IP depending on how I wrote my register statement in sip.conf).

For instance if I use register => 1234:1234 at myprovider.com then you see
asterisk looking for myhost.com in the mysql db. It should not because it
is just a registration statement. If I put the rest of the information in
to the asterisk real time db then I have no issue.

One thing I will add is that as long as I have an entry in my real time
for myprovider.com it will work for multiple registrations. Meaning that if
under the name myprovider.com I have sip user name 1234 and password 1234
and I have in sip.conf

register => 1234:1234 at myprovider.com
register => 4444:4444.myprovider.com
register => 6666:6666.myprovider.com

all of the above registrations will work as long as I have an entry for
myprovider.com in my realtime db


====================================================================== 

---------------------------------------------------------------------- 
 Dovid - 08-28-07 14:00  
---------------------------------------------------------------------- 
Not all the following made it so I am resubmitting it:


If I have the domain in the db then I get:
MySQL RealTime: Retrieve SQL: SELECT * FROM sip_users WHERE name =
'myprovider.com'

MySQL RealTime: Retrieve SQL: SELECT * FROM sip_users WHERE name =
'my_cid_num'
    -- Executing [device at sip-incoming:1] Dial("SIP/55551234-08e306c0",
"SIP/device") in new stack
    -- Called device

When not in mysql I get:
   -- Registration for 'sip_id at myprovide.com' timed out, trying again
(Attempt http://bugs.digium.com/view.php?id=2