asterisk-1.2.23
asterisk-addons-1.2.7
mysql-4.1.11
i’ve configured all the required bits for getting mysql working with * and it all seems fiine. using the CLI i get all the right answers. i can see mysql stuff being loaded when i start asterisk. but i’ve got an issue with getting SIP clients reg’d using mysql. the message i get is:
Aug 3 15:50:04 DEBUG[16410] chan_sip.c: Allocating new SIP dialog for MmMyODI3YWNlMTBhYzc5Nzg3OWZhNTJhMWExMjNlMzI. - REGISTER (No RTP)
Aug 3 15:50:04 DEBUG[16410] chan_sip.c: **** Received REGISTER (2) - Command in SIP REGISTER
chan_sip.c: Registration from ‘"user"sip:user@some.co.uk’ failed for ‘10.0.0.102’ - ACL error (permit/deny)
i have a db called asterisk and a table called sip_users with the following:
id 1
name 4001
type friend
username 4001
secret 4001
context main
callerid “user”<4001>
qualify 100
host dynamic
canreinvite no
mailbox 4001
defaultip 10.0.0.102
( that was taken from realtime load sipusers name 4001 in the CLI so db connection and query works )
there is no NAT involved here, just some machine on a private network along with the * server. mysql and * are on the same box. i would have expected to see some sort of query in the mysql logs when registration is attempted but i get nothing.
when i’ve just used the config files ( /etc/asterisk/ ) it all works fine.
i’ve seen some posts with similar problems but no concrete answers
any clues anyone?