Hi dear all,
I have a problem when installing realtime sip on Asterisk 13.1.0. I have setup an Asterisk 11.x.x system on Ubuntu, the realtime sip feature have operated successful. I have installed new machine with Ubuntu 14.04.1 and Asterisk 13.1.0. I have moved all config files and Mysql database from the running system (Asterisk 11.x.x) to new system (Asterisk 13.1.0) , but when a sip phone register into new Asterisk system I have seen the error and warning information from console of Asterisk
[Jan 7 13:45:45] WARNING[1490] res_config_odbc.c: SQL Get Data error!
[SELECT * FROM ast_sipfriends WHERE name = ?]
[Jan 7 13:45:52] WARNING[1490] res_config_odbc.c: SQL Get Data error!
[SELECT * FROM ast_sipfriends WHERE name = ? AND host = ?]
[Jan 7 13:45:52] WARNING[1490] res_config_odbc.c: SQL Get Data error!
[SELECT * FROM ast_sipfriends WHERE name = ?]
[Jan 7 13:45:52] WARNING[1490] res_config_odbc.c: SQL Get Data error!
[SELECT * FROM ast_sipfriends WHERE name = ? AND host = ?]
[Jan 7 13:45:52] WARNING[1490] res_config_odbc.c: SQL Get Data error!
[SELECT * FROM ast_sipfriends WHERE name = ?]
[Jan 7 13:45:52] WARNING[1490] res_config_odbc.c: SQL Get Data error!
[SELECT * FROM ast_sipfriends WHERE name = ? AND host = ?]
[Jan 7 13:45:52] WARNING[1490] res_config_odbc.c: SQL Get Data error!
[SELECT * FROM ast_sipfriends WHERE name = ?]
[Jan 7 13:45:52] NOTICE[1490] chan_sip.c: Registration from ‘"301"sip:301@192.168.0.120;transport=UDP’ failed for ‘192.168.0.108:5060’ - Wrong password
[Jan 7 13:45:52] WARNING[1490] res_config_odbc.c: SQL Get Data error!
[SELECT * FROM ast_sipfriends WHERE name = ? AND host = ?]
[Jan 7 13:45:52] WARNING[1490] res_config_odbc.c: SQL Get Data error!
[SELECT * FROM ast_sipfriends WHERE name = ?]
Please help me!
Thanks