Re: [asterisk-users] Realtime logic in Asterisk 1.4.16.1
On Sunday 30 December 2007 14:40:40 Mindaugas Kezys wrote: Thank you! Will it come to 1.4.16.3 or 1.4.17? Yes, it will. -- Tilghman ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Realtime logic in Asterisk 1.4.16.1
Currently we are using 1.4.15 which does not have such nasty BUG. When I will be free, I will try to review Asterisk sources to find a problem and submit patch to this. From this case I see that not much people are using Asterisk Realtime with newest Asterisk version. When holidays will end more and more people will start to complain about this. Regards, Mindaugas Kezys http://www.kolmisoft.com MOR - Advanced Billing for Asterisk PBX -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Messina Sent: Sunday, December 30, 2007 12:09 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] Realtime logic in Asterisk 1.4.16.1 On Wednesday 19 December 2007 05:48:01 pm Mindaugas Kezys wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tilghman Lesher Sent: Thursday, December 20, 2007 1:35 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] Realtime logic in Asterisk 1.4.16.1 On Wednesday 19 December 2007 16:12:27 Mindaugas Kezys wrote: [Dec 20 00:04:12] DEBUG[25686]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM devices WHERE name = 'Provider' AND host = 'dynamic' Note: host = 'dynamic' Correct, that's the FIRST lookup that is done. It then checks the IP address and does: SELECT * FROM devices WHERE name = 'Provider' AND host='23.45.67.89' where the IP address is what is sent in the SIP INVITE. If that fails, it does a lookup only on the name (old behavior). If that fails: SELECT * FROM devices WHERE host='23.45.67.89' AND port='5060' If that fails: SELECT * FROM devices WHERE ipaddr='23.45.67.89' AND port='5060' If that fails: SELECT * FROM devices WHERE host='23.45.67.89' and checks every match for insecure=yes If that fails: SELECT * FROM devices WHERE ipaddr='23.45.67.89' and checks every match for insecure=yes And if that fails, then it returns no match. So all of those queries had to run and fail for you to get no match. were you ever able to get a solution for this? i seem the same problem when storing my sip trunks in mysql, using 1.4.16.2 -- Anthony - http://messinet.com - http://messinet.com/~amessina/gallery 8F89 5E72 8DF0 BCF0 10BE 9967 92DC 35DC B001 4A4E ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Realtime logic in Asterisk 1.4.16.1
On Sunday 30 December 2007 05:34:12 am Mindaugas Kezys wrote: Currently we are using 1.4.15 which does not have such nasty BUG. When I will be free, I will try to review Asterisk sources to find a problem and submit patch to this. From this case I see that not much people are using Asterisk Realtime with newest Asterisk version. When holidays will end more and more people will start to complain about this. i found that it did not affect my iax2 tunks (outbound peers) in mysql realtime, but it did affect the sip trunks (outbound peers) in realtime. -- Anthony - http://messinet.com - http://messinet.com/~amessina/gallery 8F89 5E72 8DF0 BCF0 10BE 9967 92DC 35DC B001 4A4E signature.asc Description: This is a digitally signed message part. ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Realtime logic in Asterisk 1.4.16.1
Just want to double check. When you are using this for IAX2 then first query is with 'dynamic', right? And after that when no peer is found other query(-ies) are executed which retrieves correct info about IAX2 user? I will have to test this myself. If it is correct - then problem could be only for SIP and less trouble to troubleshoot. Thanks for info. Regards, Mindaugas Kezys http://www.kolmisoft.com MOR - Advanced Billing for Asterisk PBX -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Messina Sent: Sunday, December 30, 2007 1:47 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] Realtime logic in Asterisk 1.4.16.1 On Sunday 30 December 2007 05:34:12 am Mindaugas Kezys wrote: Currently we are using 1.4.15 which does not have such nasty BUG. When I will be free, I will try to review Asterisk sources to find a problem and submit patch to this. From this case I see that not much people are using Asterisk Realtime with newest Asterisk version. When holidays will end more and more people will start to complain about this. i found that it did not affect my iax2 tunks (outbound peers) in mysql realtime, but it did affect the sip trunks (outbound peers) in realtime. -- Anthony - http://messinet.com - http://messinet.com/~amessina/gallery 8F89 5E72 8DF0 BCF0 10BE 9967 92DC 35DC B001 4A4E ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Realtime logic in Asterisk 1.4.16.1
On Sunday 30 December 2007 06:30:09 Mindaugas Kezys wrote: Just want to double check. When you are using this for IAX2 then first query is with 'dynamic', right? And after that when no peer is found other query(-ies) are executed which retrieves correct info about IAX2 user? I will have to test this myself. If it is correct - then problem could be only for SIP and less trouble to troubleshoot. Thanks for info. Regards, Mindaugas Kezys http://www.kolmisoft.com MOR - Advanced Billing for Asterisk PBX -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Messina Sent: Sunday, December 30, 2007 1:47 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] Realtime logic in Asterisk 1.4.16.1 On Sunday 30 December 2007 05:34:12 am Mindaugas Kezys wrote: Currently we are using 1.4.15 which does not have such nasty BUG. When I will be free, I will try to review Asterisk sources to find a problem and submit patch to this. From this case I see that not much people are using Asterisk Realtime with newest Asterisk version. When holidays will end more and more people will start to complain about this. i found that it did not affect my iax2 tunks (outbound peers) in mysql realtime, but it did affect the sip trunks (outbound peers) in realtime. Please update to the latest SVN 1.4 -- this should have already been fixed. -- Tilghman ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Realtime logic in Asterisk 1.4.16.1
Thank you! Will it come to 1.4.16.3 or 1.4.17? Regards, Mindaugas Kezys http://www.kolmisoft.com MOR - Advanced Billing for Asterisk PBX -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tilghman Lesher Sent: Sunday, December 30, 2007 5:07 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] Realtime logic in Asterisk 1.4.16.1 On Sunday 30 December 2007 06:30:09 Mindaugas Kezys wrote: Just want to double check. When you are using this for IAX2 then first query is with 'dynamic', right? And after that when no peer is found other query(-ies) are executed which retrieves correct info about IAX2 user? I will have to test this myself. If it is correct - then problem could be only for SIP and less trouble to troubleshoot. Thanks for info. Regards, Mindaugas Kezys http://www.kolmisoft.com MOR - Advanced Billing for Asterisk PBX -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Messina Sent: Sunday, December 30, 2007 1:47 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] Realtime logic in Asterisk 1.4.16.1 On Sunday 30 December 2007 05:34:12 am Mindaugas Kezys wrote: Currently we are using 1.4.15 which does not have such nasty BUG. When I will be free, I will try to review Asterisk sources to find a problem and submit patch to this. From this case I see that not much people are using Asterisk Realtime with newest Asterisk version. When holidays will end more and more people will start to complain about this. i found that it did not affect my iax2 tunks (outbound peers) in mysql realtime, but it did affect the sip trunks (outbound peers) in realtime. Please update to the latest SVN 1.4 -- this should have already been fixed. -- Tilghman ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Realtime logic in Asterisk 1.4.16.1
On Wednesday 19 December 2007 05:48:01 pm Mindaugas Kezys wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tilghman Lesher Sent: Thursday, December 20, 2007 1:35 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] Realtime logic in Asterisk 1.4.16.1 On Wednesday 19 December 2007 16:12:27 Mindaugas Kezys wrote: [Dec 20 00:04:12] DEBUG[25686]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM devices WHERE name = 'Provider' AND host = 'dynamic' Note: host = 'dynamic' Correct, that's the FIRST lookup that is done. It then checks the IP address and does: SELECT * FROM devices WHERE name = 'Provider' AND host='23.45.67.89' where the IP address is what is sent in the SIP INVITE. If that fails, it does a lookup only on the name (old behavior). If that fails: SELECT * FROM devices WHERE host='23.45.67.89' AND port='5060' If that fails: SELECT * FROM devices WHERE ipaddr='23.45.67.89' AND port='5060' If that fails: SELECT * FROM devices WHERE host='23.45.67.89' and checks every match for insecure=yes If that fails: SELECT * FROM devices WHERE ipaddr='23.45.67.89' and checks every match for insecure=yes And if that fails, then it returns no match. So all of those queries had to run and fail for you to get no match. were you ever able to get a solution for this? i seem the same problem when storing my sip trunks in mysql, using 1.4.16.2 -- Anthony - http://messinet.com - http://messinet.com/~amessina/gallery 8F89 5E72 8DF0 BCF0 10BE 9967 92DC 35DC B001 4A4E signature.asc Description: This is a digitally signed message part. ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] Realtime logic in Asterisk 1.4.16.1
Hello, I have configured one provider in Asterisk Realtime DB without username and password, only host=providers_IP and ipaddress=providers_IP Now when I'm trying to send call using this provider I'm using following string: Dial(SIP/[EMAIL PROTECTED]) In Asterisk 1.4.15 debug I see that Realtime engine is using query: [Dec 20 00:02:15] DEBUG[14634]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM devices WHERE name = 'Provider' to retrieve info about this device. And in Asterisk 1.4.16.1 I see: [Dec 20 00:04:12] DEBUG[25686]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM devices WHERE name = 'Provider' AND host = 'dynamic' Note: host = 'dynamic' Where this came from? In mine DB host=providers_IP, how Asterisk managed to visualize that it should be dynamic?! Offcourse I get: [Dec 20 00:05:58] WARNING[25686]: chan_sip.c:2898 create_addr: No such host: Provider [Dec 20 00:05:58] WARNING[25686]: app_dial.c:1191 dial_exec_full: Unable to create channel of type 'SIP' (cause 3 - No route to destination) == Everyone is busy/congested at this time (1:0/0/1) Because Realtime Engine is not able to find my Provider which is NOT DYNAMIC! No other settings changed. Same configuration files. res_config_mysql.so recompiled to 1.4.16.1. Please help or explain what's wrong! Regards, Mindaugas Kezys http://www.kolmisoft.com MOR - Advanced Billing for Asterisk PBX ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Realtime logic in Asterisk 1.4.16.1
On 00:12, Thu 20 Dec 07, Mindaugas Kezys wrote: Hello, I have configured one provider in Asterisk Realtime DB without username and password, only host=providers_IP and ipaddress=providers_IP Now when I'm trying to send call using this provider I'm using following string: Dial(SIP/[EMAIL PROTECTED]) In Asterisk 1.4.15 debug I see that Realtime engine is using query: [Dec 20 00:02:15] DEBUG[14634]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM devices WHERE name = 'Provider' to retrieve info about this device. And in Asterisk 1.4.16.1 I see: [Dec 20 00:04:12] DEBUG[25686]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM devices WHERE name = 'Provider' AND host = 'dynamic' Note: host = 'dynamic' Where this came from? In mine DB host=providers_IP, how Asterisk managed to visualize that it should be dynamic?! Offcourse I get: [Dec 20 00:05:58] WARNING[25686]: chan_sip.c:2898 create_addr: No such host: Provider [Dec 20 00:05:58] WARNING[25686]: app_dial.c:1191 dial_exec_full: Unable to create channel of type 'SIP' (cause 3 - No route to destination) == Everyone is busy/congested at this time (1:0/0/1) Because Realtime Engine is not able to find my Provider which is NOT DYNAMIC! No other settings changed. Same configuration files. res_config_mysql.so recompiled to 1.4.16.1. Please help or explain what's wrong! Have a look at http://downloads.digium.com/pub/security/AST-2007-027.pdf That's why it's not working anymore -- Michiel van Baak [EMAIL PROTECTED] http://michiel.vanbaak.eu GnuPG key: http://pgp.mit.edu:11371/pks/lookup?op=getsearch=0x71C946BD Why is it drug addicts and computer afficionados are both called users? ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Realtime logic in Asterisk 1.4.16.1
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michiel van Baak Sent: Thursday, December 20, 2007 12:22 AM To: asterisk-users@lists.digium.com Subject: Re: [asterisk-users] Realtime logic in Asterisk 1.4.16.1 On 00:12, Thu 20 Dec 07, Mindaugas Kezys wrote: Hello, I have configured one provider in Asterisk Realtime DB without username and password, only host=providers_IP and ipaddress=providers_IP Now when I'm trying to send call using this provider I'm using following string: Dial(SIP/[EMAIL PROTECTED]) In Asterisk 1.4.15 debug I see that Realtime engine is using query: [Dec 20 00:02:15] DEBUG[14634]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM devices WHERE name = 'Provider' to retrieve info about this device. And in Asterisk 1.4.16.1 I see: [Dec 20 00:04:12] DEBUG[25686]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM devices WHERE name = 'Provider' AND host = 'dynamic' Note: host = 'dynamic' Where this came from? In mine DB host=providers_IP, how Asterisk managed to visualize that it should be dynamic?! Offcourse I get: [Dec 20 00:05:58] WARNING[25686]: chan_sip.c:2898 create_addr: No such host: Provider [Dec 20 00:05:58] WARNING[25686]: app_dial.c:1191 dial_exec_full: Unable to create channel of type 'SIP' (cause 3 - No route to destination) == Everyone is busy/congested at this time (1:0/0/1) Because Realtime Engine is not able to find my Provider which is NOT DYNAMIC! No other settings changed. Same configuration files. res_config_mysql.so recompiled to 1.4.16.1. Please help or explain what's wrong! Have a look at http://downloads.digium.com/pub/security/AST-2007-027.pdf That's why it's not working anymore -- Michiel van Baak [EMAIL PROTECTED] http://michiel.vanbaak.eu GnuPG key: http://pgp.mit.edu:11371/pks/lookup?op=getsearch=0x71C946BD Why is it drug addicts and computer afficionados are both called users? --- Thank you for pointing this, but I red this doc many times. It does not help. I tried to put username/password for my device - but it still is looking for dynamic. Does it mean I can't have anything else in host field for device except dynamic? Also this PDF states: An attacker may impersonate any user using host-based authentication without a secret, simply by guessing the username of that user. AFAIK host-based authentication is done by IP address. Username and password are not present. Following this I see no logic in above statements: host-based authentication without a secret - host-based auth. is always WITHOUT secret, and simply by guessing the username of that user - again - host-based auth. is always WITHOUT username If device (peer/user) has username/password - that's not HOST-BASED authentication. Correct me if I'm wrong. Question follows - how can I have host-based authentication in Realtime in Asterisk 1.4.16.1?? Maybe tommorow we will see Asterisk 1.4.16.2? Regards, Mindaugas Kezys http://www.kolmisoft.com MOR - Advanced Billing for Asterisk PBX ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Realtime logic in Asterisk 1.4.16.1
On Wednesday 19 December 2007 16:12:27 Mindaugas Kezys wrote: [Dec 20 00:04:12] DEBUG[25686]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM devices WHERE name = 'Provider' AND host = 'dynamic' Note: host = 'dynamic' Correct, that's the FIRST lookup that is done. It then checks the IP address and does: SELECT * FROM devices WHERE name = 'Provider' AND host='23.45.67.89' where the IP address is what is sent in the SIP INVITE. If that fails, it does a lookup only on the name (old behavior). If that fails: SELECT * FROM devices WHERE host='23.45.67.89' AND port='5060' If that fails: SELECT * FROM devices WHERE ipaddr='23.45.67.89' AND port='5060' If that fails: SELECT * FROM devices WHERE host='23.45.67.89' and checks every match for insecure=yes If that fails: SELECT * FROM devices WHERE ipaddr='23.45.67.89' and checks every match for insecure=yes And if that fails, then it returns no match. So all of those queries had to run and fail for you to get no match. -- Tilghman ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] Realtime logic in Asterisk 1.4.16.1
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tilghman Lesher Sent: Thursday, December 20, 2007 1:35 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] Realtime logic in Asterisk 1.4.16.1 On Wednesday 19 December 2007 16:12:27 Mindaugas Kezys wrote: [Dec 20 00:04:12] DEBUG[25686]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM devices WHERE name = 'Provider' AND host = 'dynamic' Note: host = 'dynamic' Correct, that's the FIRST lookup that is done. It then checks the IP address and does: SELECT * FROM devices WHERE name = 'Provider' AND host='23.45.67.89' where the IP address is what is sent in the SIP INVITE. If that fails, it does a lookup only on the name (old behavior). If that fails: SELECT * FROM devices WHERE host='23.45.67.89' AND port='5060' If that fails: SELECT * FROM devices WHERE ipaddr='23.45.67.89' AND port='5060' If that fails: SELECT * FROM devices WHERE host='23.45.67.89' and checks every match for insecure=yes If that fails: SELECT * FROM devices WHERE ipaddr='23.45.67.89' and checks every match for insecure=yes And if that fails, then it returns no match. So all of those queries had to run and fail for you to get no match. -- Tilghman -- Thank you for explanation, but problem is that only this first query is executed: [Dec 20 00:04:12] DEBUG[25686]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM devices WHERE name = 'Provider' AND host = 'dynamic' [Dec 20 00:04:12] WARNING[25686]: chan_sip.c:2898 create_addr: No such host: Provider [Dec 20 00:04:12] WARNING[25686]: app_dial.c:1191 dial_exec_full: Unable to create channel of type 'SIP' (cause 3 - No route to destination) == Everyone is busy/congested at this time (1:0/0/1) That's it. No more queries. End of call. Why? Regards, Mindaugas Kezys http://www.kolmisoft.com MOR - Advanced Billing for Asterisk PBX ___ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users