[asterisk-bugs] [JIRA] (ASTERISK-26057) Not correct query for realtime dialplan in sqlite3 database

[Rusty Newton (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-26057?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rusty Newton updated ASTERISK-26057:
------------------------------------

    Attachment: res_config_sqlite3.txt
                extconfig.txt
                debug.txt

We require that debug and configs be attached to the issue in case the external sources disappear. Please note that for the future.

I'm going ahead and attaching your files to the issue.

> Not correct query for realtime dialplan in sqlite3 database
> -----------------------------------------------------------
>
>                 Key: ASTERISK-26057
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-26057
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Resources/res_config_sqlite3
>    Affects Versions: 11.20.0, 11.22.0
>         Environment: Ubuntu 14.04.3, 3.13.0-44-generic, x86_64, 
> Linux Mint 17.1, 3.13.0-37-generic, x86_64
>            Reporter: Stepan
>            Assignee: Unassigned
>              Labels: realtime, sqlite3
>         Attachments: debug.txt, extconfig.txt, res_config_sqlite3.txt
>
>
> Hello,
> I try to configure realtime dialplan on sqlite3 engine (it has already perfectly work on mysql engine). But I got a problem that Asterisk can not find extensions on db file. I've see query in debug 
> {noformat}SELECT * FROM "sip_extensions" WHERE "exten" LIKE '\_%' AND "context" = 'statusprofi_107' AND "priority" = '1'{noformat}
> This query did not work directly on db file. But query like that 
> {noformat}SELECT * FROM "sip_extensions" WHERE "exten" LIKE '_%' AND "context" = 'statusprofi_107' AND "priority" = '1'{noformat}
> works fine. I think Asterisk does not need to escaping '_' symbol for sqlite. 
> [extconfig.conf|http://pastebin.com/yR9GMkpG]
> [res_config_sqlite3.conf|http://pastebin.com/Uj8UWHuq]
> [debug|http://pastebin.com/tv7NLggC]
> Please feel free if you'll need any additional information.



--
This message was sent by Atlassian JIRA
(v6.2#6252)