search

Star2Billing / a2billing

A2Billing is a telecom switch and billing system capable of providing and billing a range of telecom products and services to customers such as calling card products, residential and wholesale VoIP termination, DID resale and callback services.
www.asterisk2billing.org
Other
180 stars 174 forks source link

multiple a2billing in a single server - Realtime is not working #101

Open ghost opened 9 years ago

ghost commented 9 years ago

Hi,

We are using latest a2billing and asterisk 11. It is not an issue actually , I just want to know how can configure multiple a2billing in a single server with realtime. I was able to configure it through without realtime But using realtime , only one database is accepting for sip registration. I couldnt see any help in the forums. Thats why I been here for getting any help.These were my below settings for realtime,

extconfig.conf

[settings]

iaxusers => mysql,test1,cc_iax_buddies iaxpeers =>mysql,test1,cc_iax_buddies sipusers =>mysql,test1,cc_sip_buddies sippeers => mysql,test1,cc_sip_buddies extensions => mysql,test1,cc_sip_buddies

iaxusers2 => mysql,test2,cc_iax_buddies iaxpeers2 =>mysql,test2,cc_iax_buddies sipusers2 =>mysql,test2,cc_sip_buddies sippeers2 => mysql,test2,cc_sip_buddies extensions2 => mysql,test2,cc_sip_buddies

res_config_mysql.conf

[test1] dbhost = 127.0.0.1 dbname = first database name dbuser = first database user dbpass = password dbport = 3306

[test2] dbhost = 127.0.0.1 dbname = second database name dbuser = second database user dbpass = password dbport = 3306

I can manually check the realtime status for all the extension on both database in the asterisk cli. But, the sip details in the second database is not able to registering through softphone. Seems like asterisk only accept and check the sip registration from the first database not the second one

I really think I need to edit some files to make it work boths. Any small help would be appreciated.

Regards, Sujith

ghost commented 9 years ago

Please enable debug mode in asterisk and post the result, this is mainly Asterisk issue and you should ask in Asterisk forum

ghost commented 9 years ago

Yeah, I am aware that it's may be an issue with Asterisk. The real time is working when I choose a single database in the extconfig.conf , in my case either it is a first or second database. I just want to know whether any solution available for resolving this.

I am getting the error "- Wrong password" when I try registering an extension using realtime. This is clearly states that the Asterisk only checking the first database table cc_sip_buddies when any incoming SIP connection comes. If it try to check the other one, then surely the extension will register. So basically its not an issue. I am just looking for any solution to show me the right path whether the asterisk real time supports multiple databases or do I need to add anything in the A2billing files.

However I will post the same issue in Asterisk forums also. Thanks for your help :)

ghost commented 9 years ago

Please post your log in FULL DEBUG mode to see what's the cause, it can be authentication issue or table schema.

https://wiki.asterisk.org/wiki/display/AST/Collecting+Debug+Information

ghost commented 9 years ago

Please see below the debug information,

Extension got registerd using the first database details

[2015-05-04 18:11:10] DEBUG[9592]: chan_sip.c:9038 find_call: = Looking for Call ID: 0c26e475-e0d27cd3-6f29099@70.167.153.136 (Checking From) --From tag 8aaf38d4 --To-tag [2015-05-04 18:11:10] DEBUG[9592]: acl.c:979 ast_ouraddrfor: For destination '216.115.69.144', our source address is '172.31.2.104'. [2015-05-04 18:11:10] DEBUG[9592]: chan_sip.c:3848 ast_sip_ouraddrfor: Target address 216.115.69.144:5060 is not local, substituting externaddr [2015-05-04 18:11:10] DEBUG[9592]: chan_sip.c:3881 ast_sip_ouraddrfor: Setting SIP_TRANSPORT_UDP with address 52.24.XX.XX:5060 [2015-05-04 18:11:10] DEBUG[9592]: netsock2.c:138 ast_sockaddr_split_hostport: Splitting '216.115.69.144' into... [2015-05-04 18:11:10] DEBUG[9592]: netsock2.c:192 ast_sockaddr_split_hostport: ...host '216.115.69.144' and port ''. [2015-05-04 18:11:10] DEBUG[9592]: chan_sip.c:8641 sip_alloc: Allocating new SIP dialog for 0c26e475-e0d27cd3-6f29099@70.167.153.136 - OPTIONS (No RTP) [2015-05-04 18:11:10] DEBUG[9592]: chan_sip.c:28378 handle_incoming: **** Received OPTIONS (3) - Command in SIP OPTIONS [2015-05-04 18:11:10] DEBUG[9592]: netsock2.c:138 ast_sockaddr_split_hostport: Splitting '52.24.XX.XX:5060' into... [2015-05-04 18:11:10] DEBUG[9592]: netsock2.c:192 ast_sockaddr_split_hostport: ...host '52.24.XX.XX' and port ''. [2015-05-04 18:11:10] DEBUG[9592]: netsock2.c:138 ast_sockaddr_split_hostport: Splitting 'invalid' into... [2015-05-04 18:11:10] DEBUG[9592]: netsock2.c:192 ast_sockaddr_split_hostport: ...host 'invalid' and port ''. [2015-05-04 18:11:10] DEBUG[9592]: chan_sip.c:3724 sip_xmit: Trying to put 'SIP/2.0 200' onto UDP socket destined for 216.115.69.144:5060 [2015-05-04 18:11:18] DEBUG[9592]: chan_sip.c:8641 sip_alloc: Allocating new SIP dialog for 784bee7b028fa41368e2cfcd18c068fc@172.31.2.104:5060 - OPTIONS (No RTP) [2015-05-04 18:11:18] DEBUG[9592]: acl.c:979 ast_ouraddrfor: For destination '216.115.69.144', our source address is '172.31.2.104'. [2015-05-04 18:11:18] DEBUG[9592]: chan_sip.c:3848 ast_sip_ouraddrfor: Target address 216.115.69.144:5060 is not local, substituting externaddr [2015-05-04 18:11:18] DEBUG[9592]: chan_sip.c:3881 ast_sip_ouraddrfor: Setting SIP_TRANSPORT_UDP with address 52.24.XX.XX:5060 [2015-05-04 18:11:18] DEBUG[9592]: chan_sip.c:8429 change_callid_pvt: SIP call-id changed from '784bee7b028fa41368e2cfcd18c068fc@172.31.2.104:5060' to '620888d43a4545b0733042ad6d6b6272@52.24.XX.XX:5060' [2015-05-04 18:11:18] DEBUG[9592]: chan_sip.c:3367 initialize_initreq: Initializing initreq for method OPTIONS - callid 620888d43a4545b0733042ad6d6b6272@52.24.XX.XX:5060 [2015-05-04 18:11:18] DEBUG[9592]: chan_sip.c:3724 sip_xmit: Trying to put 'OPTIONS sip' onto UDP socket destined for 216.115.69.144:5060 [2015-05-04 18:11:18] DEBUG[9592]: chan_sip.c:9038 find_call: = Looking for Call ID: 620888d43a4545b0733042ad6d6b6272@52.24.XX.XX:5060 (Checking To) --From tag as4e0b5513 --To-tag 20e1698a3241cbcc6677a39fcb65a0aa.c865 [2015-05-04 18:11:18] DEBUG[9592]: chan_sip.c:4421 sip_ack: Stopping retransmission on '620888d43a4545b0733042ad6d6b6272@52.24.XX.XX:5060' of Request 102: Match Found [2015-05-04 18:11:18] DEBUG[9592]: chan_sip.c:6681 sip_destroy: Destroying SIP dialog 620888d43a4545b0733042ad6d6b6272@52.24.XX.XX:5060 [2015-05-04 18:11:24] DEBUG[9592]: chan_sip.c:4277 sip_autodestruct: Auto destroying SIP dialog '95f5da82-95925b6c-b6ef7e1@216.115.XX.XX' [2015-05-04 18:11:24] DEBUG[9592]: chan_sip.c:6681 sip_destroy: Destroying SIP dialog 95f5da82-95925b6c-b6ef7e1@216.115.XX.XX [2015-05-04 18:11:33] DEBUG[9592]: res_config_mysql.c:1604 mysql_reconnect: MySQL RealTime: Connection okay. [2015-05-04 18:11:33] DEBUG[9592]: res_config_mysql.c:378 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM cc_sip_buddies WHERE name = 'sip.flowroute.com' AND host = 'dynamic' [2015-05-04 18:11:33] DEBUG[9592]: res_config_mysql.c:1604 mysql_reconnect: MySQL RealTime: Connection okay. [2015-05-04 18:11:33] DEBUG[9592]: res_config_mysql.c:378 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM cc_sip_buddies WHERE name = 'sip.flowroute.com' [2015-05-04 18:11:33] DEBUG[9592]: chan_sip.c:3326 registry_addref: SIP Registry sip.flowroute.com: refcount now 3 [2015-05-04 18:11:33] DEBUG[9592]: netsock2.c:138 ast_sockaddr_split_hostport: Splitting 'sip.flowroute.com' into... [2015-05-04 18:11:33] DEBUG[9592]: netsock2.c:192 ast_sockaddr_split_hostport: ...host 'sip.flowroute.com' and port ''. [2015-05-04 18:11:33] DEBUG[9592]: netsock2.c:138 ast_sockaddr_split_hostport: Splitting 'sip.flowroute.com' into... [2015-05-04 18:11:33] DEBUG[9592]: netsock2.c:192 ast_sockaddr_split_hostport: ...host 'sip.flowroute.com' and port ''. [2015-05-04 18:11:33] DEBUG[9592]: chan_sip.c:3318 registry_unref: SIP Registry sip.flowroute.com: refcount now 2 [2015-05-04 18:11:33] DEBUG[9592]: chan_sip.c:8641 sip_alloc: Allocating new SIP dialog for 4dcb681272a5ea2d6e3b62c671e73533@172.31.2.104 - REGISTER (No RTP) [2015-05-04 18:11:33] DEBUG[9592]: res_config_mysql.c:1604 mysql_reconnect: MySQL RealTime: Connection okay. [2015-05-04 18:11:33] DEBUG[9592]: res_config_mysql.c:378 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM cc_sip_buddies WHERE name = 'sip.flowroute.com' AND host = 'dynamic' [2015-05-04 18:11:33] DEBUG[9592]: res_config_mysql.c:1604 mysql_reconnect: MySQL RealTime: Connection okay. [2015-05-04 18:11:33] DEBUG[9592]: res_config_mysql.c:378 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM cc_sip_buddies WHERE name = 'sip.flowroute.com' [2015-05-04 18:11:33] DEBUG[9592]: res_config_mysql.c:1604 mysql_reconnect: MySQL RealTime: Connection okay. [2015-05-04 18:11:33] DEBUG[9592]: res_config_mysql.c:378 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM cc_sip_buddies WHERE name = 'sip.flowroute.com' AND host = 'dynamic' [2015-05-04 18:11:33] DEBUG[9592]: res_config_mysql.c:1604 mysql_reconnect: MySQL RealTime: Connection okay. [2015-05-04 18:11:33] DEBUG[9592]: res_config_mysql.c:378 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM cc_sip_buddies WHERE name = 'sip.flowroute.com' [2015-05-04 18:11:33] DEBUG[9592]: chan_sip.c:3326 registry_addref: SIP Registry sip.flowroute.com: refcount now 3 [2015-05-04 18:11:33] DEBUG[9592]: acl.c:979 ast_ouraddrfor: For destination '216.115.69.144', our source address is '172.31.2.104'. [2015-05-04 18:11:33] DEBUG[9592]: chan_sip.c:3848 ast_sip_ouraddrfor: Target address 216.115.69.144:5060 is not local, substituting externaddr [2015-05-04 18:11:33] DEBUG[9592]: chan_sip.c:3881 ast_sip_ouraddrfor: Setting SIP_TRANSPORT_UDP with address 52.24.XX.XX:5060 [2015-05-04 18:11:33] DEBUG[9592]: chan_sip.c:3326 registry_addref: SIP Registry sip.flowroute.com: refcount now 4 [2015-05-04 18:11:33] DEBUG[9592]: chan_sip.c:15369 transmit_register: Scheduled a registration timeout for sip.flowroute.com id #206 [2015-05-04 18:11:33] DEBUG[9592]: netsock2.c:138 ast_sockaddr_split_hostport: Splitting 'sip.flowroute.com' into... [2015-05-04 18:11:33] DEBUG[9592]: netsock2.c:192 ast_sockaddr_split_hostport: ...host 'sip.flowroute.com' and port ''. [2015-05-04 18:11:33] DEBUG[9592]: netsock2.c:138 ast_sockaddr_split_hostport: Splitting 'sip.flowroute.com' into... [2015-05-04 18:11:33] DEBUG[9592]: netsock2.c:192 ast_sockaddr_split_hostport: ...host 'sip.flowroute.com' and port ''. [2015-05-04 18:11:33] DEBUG[9592]: netsock2.c:138 ast_sockaddr_split_hostport: Splitting 'sip.flowroute.com' into... [2015-05-04 18:11:33] DEBUG[9592]: netsock2.c:192 ast_sockaddr_split_hostport: ...host 'sip.flowroute.com' and port ''. [2015-05-04 18:11:33] DEBUG[9592]: chan_sip.c:3367 initialize_initreq: Initializing initreq for method REGISTER - callid 4dcb681272a5ea2d6e3b62c671e73533@172.31.2.104 [2015-05-04 18:11:33] DEBUG[9592]: chan_sip.c:15445 transmit_register: REGISTER attempt 1 to 74792752@sip.flowroute.com [2015-05-04 18:11:33] DEBUG[9592]: chan_sip.c:3724 sip_xmit: Trying to put 'REGISTER si' onto UDP socket destined for 216.115.69.144:5060 [2015-05-04 18:11:33] DEBUG[9592]: chan_sip.c:3318 registry_unref: SIP Registry sip.flowroute.com: refcount now 3 [2015-05-04 18:11:33] DEBUG[9592]: chan_sip.c:9038 find_call: = Looking for Call ID: 4dcb681272a5ea2d6e3b62c671e73533@172.31.2.104 (Checking To) --From tag as1de6e211 --To-tag aa681f9fdf30149b00040f579a1d99c4.dbb9 [2015-05-04 18:11:33] DEBUG[9592]: chan_sip.c:4421 sip_ack: Stopping retransmission on '4dcb681272a5ea2d6e3b62c671e73533@172.31.2.104' of Request 117: Match Found [2015-05-04 18:11:33] DEBUG[9592]: chan_sip.c:23603 handle_response_register: Registration successful [2015-05-04 18:11:33] DEBUG[9592]: chan_sip.c:23605 handle_response_register: Cancelling timeout 206 [2015-05-04 18:11:33] DEBUG[9592]: chan_sip.c:3318 registry_unref: SIP Registry sip.flowroute.com: refcount now 2 [2015-05-04 18:11:33] DEBUG[9592]: chan_sip.c:3318 registry_unref: SIP Registry sip.flowroute.com: refcount now 1 [2015-05-04 18:11:33] DEBUG[9592]: chan_sip.c:3326 registry_addref: SIP Registry sip.flowroute.com: refcount now 2 [2015-05-04 18:11:33] DEBUG[9592]: chan_sip.c:6681 sip_destroy: Destroying SIP dialog 4dcb681272a5ea2d6e3b62c671e73533@172.31.2.104 [2015-05-04 18:11:42] DEBUG[9592]: chan_sip.c:4277 __sip_autodestruct: Auto destroying SIP dialog '0c26e475-e0d27cd3-6f29099@70.167.153.136' [2015-05-04 18:11:42] DEBUG[9592]: chan_sip.c:6681 sip_destroy: Destroying SIP dialog 0c26e475-e0d27cd3-6f29099@70.167.153.136 [2015-05-04 18:11:47] DEBUG[9592]: chan_sip.c:9038 find_call: = Looking for Call ID: 95f5da82-1dc45b6c-2aef7e1@216.115.XX.XX (Checking From) --From tag b844ff8a --To-tag [2015-05-04 18:11:47] DEBUG[9592]: acl.c:979 ast_ouraddrfor: For destination '216.115.69.144', our source address is '172.31.2.104'. [2015-05-04 18:11:47] DEBUG[9592]: chan_sip.c:3848 ast_sip_ouraddrfor: Target address 216.115.69.144:5060 is not local, substituting externaddr [2015-05-04 18:11:47] DEBUG[9592]: chan_sip.c:3881 ast_sip_ouraddrfor: Setting SIP_TRANSPORT_UDP with address 52.24.XX.XX:5060 [2015-05-04 18:11:47] DEBUG[9592]: netsock2.c:138 ast_sockaddr_split_hostport: Splitting '216.115.69.144' into... [2015-05-04 18:11:47] DEBUG[9592]: netsock2.c:192 ast_sockaddr_split_hostport: ...host '216.115.69.144' and port ''. [2015-05-04 18:11:47] DEBUG[9592]: chan_sip.c:8641 sip_alloc: Allocating new SIP dialog for 95f5da82-1dc45b6c-2aef7e1@216.115.XX.XX - OPTIONS (No RTP) [2015-05-04 18:11:47] DEBUG[9592]: chan_sip.c:28378 handle_incoming: **\ Received OPTIONS (3) - Command in SIP OPTIONS [2015-05-04 18:11:47] DEBUG[9592]: netsock2.c:138 ast_sockaddr_split_hostport: Splitting '52.24.XX.XX:5060' into... [2015-05-04 18:11:47] DEBUG[9592]: netsock2.c:192 ast_sockaddr_split_hostport: ...host '52.24.XX.XX' and port ''. [2015-05-04 18:11:47] DEBUG[9592]: netsock2.c:138 ast_sockaddr_split_hostport: Splitting 'invalid' into... [2015-05-04 18:11:47] DEBUG[9592]: netsock2.c:192 ast_sockaddr_split_hostport: ...host 'invalid' and port ''. [2015-05-04 18:11:47] DEBUG[9592]: chan_sip.c:3724 __sip_xmit: Trying to put 'SIP/2.0 200' onto UDP socket destined for 216.115.69.144:5060

Extension Failed to register using the second database details and showing the wrong password error ( I am sure that the authentication is correct )

[2015-05-04 18:06:48] DEBUG[9592]: chan_sip.c:9038 find_call: = Looking for Call ID: HfJMi33FqlE6C3bc6csBfw.. (Checking From) --From tag d7077a65 --To-tag
[2015-05-04 18:06:48] DEBUG[9592]: acl.c:979 ast_ouraddrfor: For destination '121.242.XX.XX', our source address is '172.31.2.104'. [2015-05-04 18:06:48] DEBUG[9592]: chan_sip.c:3848 ast_sip_ouraddrfor: Target address 121.242.XX.XX:53886 is not local, substituting externaddr [2015-05-04 18:06:48] DEBUG[9592]: chan_sip.c:3881 ast_sip_ouraddrfor: Setting SIP_TRANSPORT_UDP with address 52.24.XX.XX:5060 [2015-05-04 18:06:48] DEBUG[9592]: netsock2.c:138 ast_sockaddr_split_hostport: Splitting '10.254.254.26:42016' into... [2015-05-04 18:06:48] DEBUG[9592]: netsock2.c:192 ast_sockaddr_split_hostport: ...host '10.254.254.26' and port '42016'. [2015-05-04 18:06:48] DEBUG[9592]: chan_sip.c:18082 check_for_nat: NAT detected for 10.254.254.26 / 121.242.XX.XX [2015-05-04 18:06:48] DEBUG[9592]: chan_sip.c:8641 sip_alloc: Allocating new SIP dialog for HfJMi33FqlE6C3bc6csBfw.. - SUBSCRIBE (No RTP) [2015-05-04 18:06:48] DEBUG[9592]: chan_sip.c:28378 handle_incoming: * Received SUBSCRIBE (10) - Command in SIP SUBSCRIBE [2015-05-04 18:06:48] DEBUG[9592]: netsock2.c:138 ast_sockaddr_split_hostport: Splitting '10.254.254.26:42016' into... [2015-05-04 18:06:48] DEBUG[9592]: netsock2.c:192 ast_sockaddr_split_hostport: ...host '10.254.254.26' and port '42016'. [2015-05-04 18:06:48] DEBUG[9592]: chan_sip.c:18082 check_for_nat: NAT detected for 10.254.254.26 / 121.242.XX.XX [2015-05-04 18:06:48] DEBUG[9592]: chan_sip.c:16341 build_route: build_route: Contact hop: sip:814307626229@10.254.254.26:42016;transport=UDP [2015-05-04 18:06:48] DEBUG[9592]: netsock2.c:138 ast_sockaddr_split_hostport: Splitting '52.24.XX.XX' into... [2015-05-04 18:06:48] DEBUG[9592]: netsock2.c:192 ast_sockaddr_split_hostport: ...host '52.24.XX.XX' and port ''. [2015-05-04 18:06:48] DEBUG[9592]: res_config_mysql.c:1604 mysql_reconnect: MySQL RealTime: Connection okay. [2015-05-04 18:06:48] DEBUG[9592]: res_config_mysql.c:378 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM cc_sip_buddies WHERE name = '814307626 229' AND host = 'dynamic' [2015-05-04 18:06:48] DEBUG[9592]: res_config_mysql.c:1604 mysql_reconnect: MySQL RealTime: Connection okay. [2015-05-04 18:06:48] DEBUG[9592]: res_config_mysql.c:378 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT \ FROM cc_sip_buddies WHERE name = '814307626 229' [2015-05-04 18:06:48] DEBUG[9592]: chan_sip.c:3724 __sip_xmit: Trying to put 'SIP/2.0 404' onto UDP socket destined for 121.242.XX.XX:53886 [2015-05-04 18:06:48] DEBUG[9592]: chan_sip.c:6681 sip_destroy: Destroying SIP dialog HfJMi33FqlE6C3bc6csBfw.. [2015-05-04 18:06:48] DEBUG[9592]: chan_sip.c:9038 find_call: = Looking for Call ID: QB2MJHz0DiNcNZKpnF-DTQ.. (Checking From) --From tag 58555125 --To-tag
[2015-05-04 18:06:48] DEBUG[9592]: acl.c:979 ast_ouraddrfor: For destination '121.242.XX.XX', our source address is '172.31.2.104'. [2015-05-04 18:06:48] DEBUG[9592]: chan_sip.c:3848 ast_sip_ouraddrfor: Target address 121.242.XX.XX:53886 is not local, substituting externaddr [2015-05-04 18:06:48] DEBUG[9592]: chan_sip.c:3881 ast_sip_ouraddrfor: Setting SIP_TRANSPORT_UDP with address 52.24.XX.XX:5060 [2015-05-04 18:06:48] DEBUG[9592]: netsock2.c:138 ast_sockaddr_split_hostport: Splitting '121.242.XX.XX:53886' into... [2015-05-04 18:06:48] DEBUG[9592]: netsock2.c:192 ast_sockaddr_split_hostport: ...host '121.242.XX.XX' and port '53886'. [2015-05-04 18:06:48] DEBUG[9592]: chan_sip.c:8641 sip_alloc: Allocating new SIP dialog for QB2MJHz0DiNcNZKpnF-DTQ.. - REGISTER (No RTP) [2015-05-04 18:06:48] DEBUG[9592]: chan_sip.c:28378 handle_incoming: *** Received REGISTER (2) - Command in SIP REGISTER [2015-05-04 18:06:48] DEBUG[9592]: netsock2.c:138 ast_sockaddr_split_hostport: Splitting '121.242.XX.XX:53886' into... [2015-05-04 18:06:48] DEBUG[9592]: netsock2.c:192 ast_sockaddr_split_hostport: ...host '121.242.XX.XX' and port '53886'. [2015-05-04 18:06:48] DEBUG[9592]: netsock2.c:138 ast_sockaddr_split_hostport: Splitting '52.24.XX.XX' into... [2015-05-04 18:06:48] DEBUG[9592]: netsock2.c:192 ast_sockaddr_split_hostport: ...host '52.24.XX.XX' and port ''. [2015-05-04 18:06:48] DEBUG[9592]: res_config_mysql.c:1604 mysql_reconnect: MySQL RealTime: Connection okay. [2015-05-04 18:06:48] DEBUG[9592]: res_config_mysql.c:378 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM cc_sip_buddies WHERE name = '814307626 229' AND host = 'dynamic' [2015-05-04 18:06:48] DEBUG[9592]: res_config_mysql.c:1604 mysql_reconnect: MySQL RealTime: Connection okay. [2015-05-04 18:06:48] DEBUG[9592]: res_config_mysql.c:378 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM cc_sip_buddies WHERE name = '814307626 229' [2015-05-04 18:06:48] DEBUG[9592]: chan_sip.c:3724 __sip_xmit: Trying to put 'SIP/2.0 401' onto UDP socket destined for 121.242.XX.XX:53886 [2015-05-04 18:06:48] DEBUG[9592]: res_config_mysql.c:1604 mysql_reconnect: MySQL RealTime: Connection okay. [2015-05-04 18:06:48] DEBUG[9592]: res_config_mysql.c:378 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM cc_sip_buddies WHERE name = '814307626 229' AND host = 'dynamic' [2015-05-04 18:06:48] DEBUG[9592]: res_config_mysql.c:1604 mysql_reconnect: MySQL RealTime: Connection okay. [2015-05-04 18:06:48] DEBUG[9592]: res_config_mysql.c:378 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM cc_sip_buddies WHERE name = '814307626 229' [2015-05-04 18:06:48] DEBUG[9592]: chan_sip.c:9038 find_call: = Looking for Call ID: QB2MJHz0DiNcNZKpnF-DTQ.. (Checking From) --From tag 58555125 --To-tag
[2015-05-04 18:06:48] DEBUG[9592]: chan_sip.c:28378 handle_incoming: * Received REGISTER (2) - Command in SIP REGISTER [2015-05-04 18:06:48] DEBUG[9592]: netsock2.c:138 ast_sockaddr_split_hostport: Splitting '121.242.XX.XX:53886' into... [2015-05-04 18:06:48] DEBUG[9592]: netsock2.c:192 ast_sockaddr_split_hostport: ...host '121.242.XX.XX' and port '53886'. [2015-05-04 18:06:48] DEBUG[9592]: netsock2.c:138 ast_sockaddr_split_hostport: Splitting '52.24.XX.XX' into... [2015-05-04 18:06:48] DEBUG[9592]: netsock2.c:192 ast_sockaddr_split_hostport: ...host '52.24.XX.XX' and port ''. [2015-05-04 18:06:48] DEBUG[9592]: res_config_mysql.c:1604 mysql_reconnect: MySQL RealTime: Connection okay. [2015-05-04 18:06:48] DEBUG[9592]: res_config_mysql.c:378 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM cc_sip_buddies WHERE name = '814307626 229' AND host = 'dynamic' [2015-05-04 18:06:48] DEBUG[9592]: res_config_mysql.c:1604 mysql_reconnect: MySQL RealTime: Connection okay. [2015-05-04 18:06:48] DEBUG[9592]: res_config_mysql.c:378 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM cc_sip_buddies WHERE name = '814307626 229' [2015-05-04 18:06:48] DEBUG[9592]: chan_sip.c:3724 sip_xmit: Trying to put 'SIP/2.0 403' onto UDP socket destined for 121.242.XX.XX:53886 [2015-05-04 18:06:48] NOTICE[9592]: chan_sip.c:28235 handle_request_register: Registration from 'sip:814307626229@52.24.XX.XX;transport=UDP' failed for '12 1.242.90.50:53886' - Wrong password [2015-05-04 18:06:48] DEBUG[9592]: res_config_mysql.c:1604 mysql_reconnect: MySQL RealTime: Connection okay. [2015-05-04 18:06:48] DEBUG[9592]: res_config_mysql.c:378 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM cc_sip_buddies WHERE name = '814307626 229' AND host = 'dynamic' [2015-05-04 18:06:48] DEBUG[9592]: res_config_mysql.c:1604 mysql_reconnect: MySQL RealTime: Connection okay. [2015-05-04 18:06:48] DEBUG[9592]: res_config_mysql.c:378 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM cc_sip_buddies WHERE name = '814307626 229' [2015-05-04 18:06:48] DEBUG[9592]: chan_sip.c:28681 handle_request_do: SIP message could not be handled, bad request: QB2MJHz0DiNcNZKpnF-DTQ..
[2015-05-04 18:06:48] DEBUG[9592]: chan_sip.c:4277 sip_autodestruct: Auto destroying SIP dialog '95f5da82-ff774b6c-85df7e1@216.115.XX.XX' [2015-05-04 18:06:48] DEBUG[9592]: chan_sip.c:6681 sip_destroy: Destroying SIP dialog 95f5da82-ff774b6c-85df7e1@216.115.XX.XX

ghost commented 9 years ago

What's the result of below query when you run it in your MySQL console?

SELECT * FROM cc_sip_buddies WHERE name = '814307626 229' AND host = 'dynamic'

ghost commented 9 years ago

Your Realtime settings is correct, you probably don't have the correct "Name" in the database cc_sip_buddies or or you are don't have correct entry at client side , there is a space before 229