Re: [asterisk-users] func_odbc do not read LIKE predicate
Thank you, this statement is working. On 03/14/2014 07:08 AM, hkc323 wrote: Vadim Lungu try this one . readsql=SELECT name FROM asterisk_sippeers WHERE name LIKE '%477'; -- Mit freundlichen Gren / Best regards Vadim Lungu System Engineer Tel +49-941-569592-0 Fax +49-941-569592-99 Mail vadim.lu...@yopeso.com Web https://www.yopeso.com YOPESO s.r.l. Calea Orheiului 20/1 2059 Chisinau Republik Moldau Registergericht Chisinau Registernummer 1008600037623 VAT-ID 0207159 Geschftsfhrer Svetlana Arnaut -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] func_odbc do not read LIKE predicate
Hello everyone, I would be extremely glad if someone could help me with the following issue: cat /etc/asterisk/func_odbc.conf [call_user] prefix=GET dsn=asterisk_odbc_sip readsql=SELECT name FROM asterisk_sippeers WHERE name = '%477' Asterisk CLI show the following issue: -- Executing [205@phones_wildcard:1] NoOp("SIP/Y_MD_vlungu_477-0008", "000") in new stack -- Executing [205@phones_wildcard:2] NoOp("SIP/Y_MD_vlungu_477-0008", "205") in new stack Found no rows [SELECT name FROM asterisk_sippeers WHERE name = '%477'] -- Executing [205@phones_wildcard:3] Set("SIP/Y_MD_vlungu_477-0008", "YUID=") in new stack -- Executing [205@phones_wildcard:4] NoOp("SIP/Y_MD_vlungu_477-0008", "##") in new stack -- Executing [205@phones_wildcard:5] NoOp("SIP/Y_MD_vlungu_477-0008", "##") in new stack -- Executing [205@phones_wildcard:6] Macro("SIP/Y_MD_vlungu_477-0008", "simple,,30") in new stack Anyone has any ideas what is going wrong ? -- Mit freundlichen Gren / Best regards Vadim Lungu System Engineer Tel +49-941-569592-0 Fax +49-941-569592-99 Mail vadim.lu...@yopeso.com Web https://www.yopeso.com YOPESO s.r.l. Calea Orheiului 20/1 2059 Chisinau Republik Moldau Registergericht Chisinau Registernummer 1008600037623 VAT-ID 0207159 Geschftsfhrer Svetlana Arnaut -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] func_odbc do not read LIKE predicate
readsql=SELECT name FROM asterisk_sippeers WHERE name = '%477' Not sure what database you are accessing, but have you tried the following: readsql=SELECT name FROM asterisk_sippeers WHERE name LIKE '%477'-- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] func_odbc do not read LIKE predicate
Sure , here is the reasult. mysql SELECT name FROM asterisk_sippeers WHERE name LIKE '%477' ; +-+ | name | +-+ | Y_MD_vlungu_477 | +-+ 1 row in set (0.00 sec) On 03/13/2014 11:17 PM, Kevin Larsen wrote: SELECT name FROM asterisk_sippeers WHERE name LIKE '%477' -- Mit freundlichen Gren / Best regards Vadim Lungu System Engineer Tel +49-941-569592-0 Fax +49-941-569592-99 Mail vadim.lu...@yopeso.com Web https://www.yopeso.com YOPESO s.r.l. Calea Orheiului 20/1 2059 Chisinau Republik Moldau Registergericht Chisinau Registernummer 1008600037623 VAT-ID 0207159 Geschftsfhrer Svetlana Arnaut -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] func_odbc do not read LIKE predicate
Sure , here is the reasult. mysql SELECT name FROM asterisk_sippeers WHERE name LIKE '%477' ; +-+ | name| +-+ | Y_MD_vlungu_477 | +-+ 1 row in set (0.00 sec) What happens when you use that in your func_odbc.conf? Does your dialplan work?-- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] func_odbc do not read LIKE predicate
Vadim Lungu try this one . readsql=SELECT name FROM asterisk_sippeers WHERE name LIKE '%477'; -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users