[SOLVED] Realtime Asterisk iax.conf problem

Inbound calls work fine when I use a flat-file for iax.conf. But they break as soon as I get asterisk to try to load iax.conf from mysql (i.e static realtime). I get the following error on inbound calls using static realtime:

Here’s my very simple iax.conf for testing:

[code][general]
register = ##########:#######@trunk.hostname

[##########]
type=user
context=from-sip-external
[/code]
Once again, the mysql version of this is identical, I’ve checked and triple checked.

IAX2 debugging shows:

[code]Rx-Frame Retry[ No] – OSeqno: 000 ISeqno: 000 Type: IAX Subclass: NEW
Timestamp: 00019ms SCall: 07679 DCall: 00000 [###.###.###.###:4569]
VERSION : 2
CALLED NUMBER : ##########
CODEC_PREFS : (ulaw|gsm)
CALLING NUMBER : ##########
CALLING PRESNTN : 0
CALLING TYPEOFN : 0
CALLING TRANSIT : 0
CALLING NAME : AAAAAAAAAA
LANGUAGE : en
USERNAME : ##########
FORMAT : 4
CAPABILITY : 6
ADSICPE : 2
DATE TIME : 2012-01-17 23:36:46

Rx-Frame Retry[ No] – OSeqno: 000 ISeqno: 000 Type: IAX Subclass: NEW
Timestamp: 00037ms SCall: 07679 DCall: 00000 [###.###.###.###:4569]
VERSION : 2
CALLED NUMBER : ##########
CODEC_PREFS : (ulaw|gsm)
CALLING NUMBER : ##########
CALLING PRESNTN : 0
CALLING TYPEOFN : 0
CALLING TRANSIT : 0
CALLING NAME : AAAAAAAAAA
LANGUAGE : en
USERNAME : ##########
FORMAT : 4
CAPABILITY : 6
ADSICPE : 2
DATE TIME : 2012-01-17 23:36:46
CALLTOKEN : 51 bytes

Tx-Frame Retry[000] – OSeqno: 000 ISeqno: 001 Type: IAX Subclass: AUTHREQ
Timestamp: 00006ms SCall: 00505 DCall: 07679 [###.###.###.###:4569]
AUTHMETHODS : 3
CHALLENGE : ################
USERNAME : ##########

Rx-Frame Retry[ No] – OSeqno: 001 ISeqno: 001 Type: IAX Subclass: AUTHREP
Timestamp: 00057ms SCall: 07679 DCall: 00505 [###.###.###.###:4569]
MD5 RESULT : 0034c0bb5ab8ec27d8f4c06fb7c3f8bb

[Jan 17 23:36:47] NOTICE[28681]: chan_iax2.c:10905 socket_process: Host ###.###.###.### failed to authenticate as ##########
Tx-Frame Retry[-01] – OSeqno: 001 ISeqno: 002 Type: IAX Subclass: ACK
Timestamp: 00057ms SCall: 00505 DCall: 07679 [###.###.###.###:4569]
Tx-Frame Retry[000] – OSeqno: 001 ISeqno: 002 Type: IAX Subclass: REJECT
Timestamp: 00024ms SCall: 00505 DCall: 07679 [###.###.###.###:4569]
CAUSE : No authority found
CAUSE CODE : 50

Rx-Frame Retry[ No] – OSeqno: 002 ISeqno: 002 Type: IAX Subclass: ACK
Timestamp: 00024ms SCall: 07679 DCall: 00505 [###.###.###.###:4569][/code]

Ideas anyone?

Old thread, I know, but I’m still having this issue.

Is there anything I can do to help diagnose this? I’d like to use realtime config rather than a flat-file.

Note, with debugging enabled, this is the no authority found error described here:

http://www.voip-info.org/wiki/view/Asterisk+No+authority+found

SOLVED. For the section field in the iax.conf mysql table I had included the brackets around the username, and wasn’t supposed to.

Hello, davegravy.
I have exactly the same issue. But it is not clear for me how You resolve it.
Can You show example of Youre database row or INSERT statement?