[asterisk-bugs] [JIRA] (ASTERISK-27283) Realtime config fail with PostgreSQL version before 9.1

[Friendly Automation (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-27283?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=238838#comment-238838 ] 

Friendly Automation commented on ASTERISK-27283:
------------------------------------------------

Change 6552 merged by Joshua Colp:
res_config_pgsql: Fix removed support to previous for versions PostgreSQL 9.1

[https://gerrit.asterisk.org/6552|https://gerrit.asterisk.org/6552]

> Realtime config fail with PostgreSQL version before 9.1
> -------------------------------------------------------
>
>                 Key: ASTERISK-27283
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-27283
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Resources/res_config_pgsql
>         Environment: Linux 
> PostgreSQL 8.4.21 on i486-pc-linux-gnu, compiled by GCC gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 32-bit
>            Reporter: Rodrigo Ramirez Norambuena
>            Assignee: Rodrigo Ramirez Norambuena
>
> When is used a previous version of PostgreSQL than 9.1 the realtime fail because the is need double backslash to use ESCAPE
> Log
> Using `queue show`
> {code}
> [Sep 19 08:48:19] DEBUG[15708]: res_config_pgsql.c:227 pgsql_exec: PostgreSQL query attempt 1
> [Sep 19 08:48:19] ERROR[15708]: res_config_pgsql.c:165 _pgsql_exec: PostgreSQL RealTime: Failed to query 'queues at asterisk'.
> [Sep 19 08:48:19] ERROR[15708]: res_config_pgsql.c:166 _pgsql_exec: PostgreSQL RealTime: Query Failed: SELECT * FROM queues WHERE name LIKE '%' ESCAPE '\' ORDER BY name
> [Sep 19 08:48:19] ERROR[15708]: res_config_pgsql.c:167 _pgsql_exec: PostgreSQL RealTime: Query Failed because: ERROR:  unterminated quoted string at or near «'\' ORDER BY name»
> LINE 1: SELECT * FROM queues WHERE name LIKE '%' ESCAPE '\' ORDER BY...
>                                                         ^
>  (PGRES_FATAL_ERROR)
> [Sep 19 08:48:19] DEBUG[15708]: res_config_pgsql.c:227 pgsql_exec: PostgreSQL query attempt 1
> [Sep 19 08:48:19] DEBUG[15708]: res_config_pgsql.c:183 _pgsql_exec: PostgreSQL query successful: SELECT * FROM queues WHERE name = 'queue_test'
> [Sep 19 08:48:19] DEBUG[15708]: res_config_pgsql.c:481 realtime_pgsql: PostgreSQL RealTime: Result=0x939dbe0 Query: SELECT * FROM queues WHERE name = 'queue_test'
> [Sep 19 08:48:19] DEBUG[15708]: res_config_pgsql.c:489 realtime_pgsql: PostgreSQL RealTime: Found 1 rows.
> [Sep 19 08:48:19] DEBUG[15708]: res_config_pgsql.c:227 pgsql_exec: PostgreSQL query attempt 1
> [Sep 19 08:48:19] ERROR[15708]: res_config_pgsql.c:165 _pgsql_exec: PostgreSQL RealTime: Failed to query 'queue_members at asterisk'.
> [Sep 19 08:48:19] ERROR[15708]: res_config_pgsql.c:166 _pgsql_exec: PostgreSQL RealTime: Query Failed: SELECT * FROM queue_members WHERE interface LIKE '%' ESCAPE '\' AND queue_name = 'queue_test' ORDER BY interface
> [Sep 19 08:48:19] ERROR[15708]: res_config_pgsql.c:167 _pgsql_exec: PostgreSQL RealTime: Query Failed because: ERROR: syntax error at or near «queue_test»
> LINE 1: ...E interface LIKE '%' ESCAPE '\' AND queue_name = 'queue_test' ORDE...
>                                                              ^
>  (PGRES_FATAL_ERROR)
> {code}



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