[asterisk-users] Problems w/Asterisk Realtime + MySQL + SIP [SOLVED!]

[Walter Stanish]

After upgrading to 1.4.21.1 I received some more verbose debug messages.

Apparently the cause of the problem was that the following table
columns MUST exist for a SIP peer to register.

 ipaddr (i used varchar(32))
 port (i used int unsigned)
 regseconds (i used bigint unsigned)

This is apparently because realtime stores the IP address, port and
registration time for a dynamic IP, realtime peer in the database
along with the static accounting information.

After adding those columns I was able to register fine with asterisk
from kphone.

Unfortunately the console commands 'sip show peers', 'sip show
registry', etc. don't seem to work (is this normal?) ... but otherwise
all is fine.

Thanks to all who offered help while debugging this issue.

Regards,
Walter Stanish
Owner / Director
Occident Systems
(+86 15808 700 801)