Re: [asterisk-users] func_odbc do not read LIKE predicate

2014-03-14 Thread Vadim Lungu 

  
  
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

2014-03-13 Thread Vadim Lungu 

  
  
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

2014-03-13 Thread Kevin Larsen 
 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

2014-03-13 Thread Vadim Lungu 

  
  
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

2014-03-13 Thread Kevin Larsen 
 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

2014-03-13 Thread hkc323 
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