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 chan_sip.c: Allocating new SIP dialog for MmMyODI3YWNlMTBhYzc5Nzg3OWZhNTJhMWExMjNlMzI. - REGISTER (No RTP)
Aug 3 15:50:04 DEBUG chan_sip.c: **** Received REGISTER (2) - Command in SIP REGISTER
chan_sip.c: Registration from ‘"user"sip:email@example.com’ 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:
( 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?