[asterisk-bugs] [JIRA] (ASTERISK-29452) Invalid Input Value for enum yesno_values in SQL Query

[Asterisk Team (JIRA)]

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

Asterisk Team commented on ASTERISK-29452:
------------------------------------------

The severity of this issue has been automatically downgraded from "Blocker" to "Major". The "Blocker" severity is reserved for issues which have been determined to block the next release of Asterisk. This severity can only be set by privileged users. If this issue is deemed to block the next release it will be updated accordingly during the triage process.

> Invalid Input Value for enum yesno_values in SQL Query
> ------------------------------------------------------
>
>                 Key: ASTERISK-29452
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-29452
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Core/Sorcery
>    Affects Versions: 16.18.0, 18.3.0, 18.4.0
>         Environment: OS: Debian 10
> PostgreSql version: 11.12
>            Reporter: Michael Reinisch
>            Severity: Major
>
> I configured Asterisk 18.4 with a realtime pgsql and ari.
> The schema was created via alembic with the config file asterisk-18.4.0/contrib/ast-db-manage/config.ini-sample.
> I just changed the sqlalchemy url.
> I tried to add a new entry to the aor table via the ARI, using :
> http://ari.asterisk.org/#!/asterisk
> {noformat}
> [May 26 09:35:05] VERBOSE[578] res_ari.c: <--- ARI request received from: XX.XX.XX.XX:37326 --->
> Host: XX.XX.XX.XX:8088
> User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:88.0) Gecko/20100101 Firefox/88.0
> Accept: */*
> Accept-Language: de,en-US;q=0.7,en;q=0.3
> Accept-Encoding: gzip, deflate
> Content-Type: application/json
> Content-Length: 108
> Origin: http://ari.asterisk.org
> Connection: keep-alive
> Referer: http://ari.asterisk.org/
> api_key: asterisk:asterisk
> body:
> {
>   "fields": [
>     {
>       "attribute": "max_contacts",
>       "value": "1"
>     },
>     {
>       "attribute": "support_path",
>       "value": "yes"
>     }
>   ]
> }
> {noformat}
> Error Message:
> {noformat}
> [May 26 09:35:05] DEBUG[578] res_config_pgsql.c: PostgreSQL RealTime: Update SQL: UPDATE ps_aors SET minimum_expiration = '60', default_expiration = '3600', qualify_timeout = '3.000000', mailboxes = '', support_
> path = 'true', voicemail_extension = '', max_contacts = '1', authenticate_qualify = 'false', contact = '', maximum_expiration = '7200', qualify_frequency = '0', remove_existing = 'false', outbound_proxy = '' WHE
> RE id = '9100'
> [May 26 09:35:05] DEBUG[578] res_config_pgsql.c: PostgreSQL query attempt 1
> [May 26 09:35:05] ERROR[578] res_config_pgsql.c: PostgreSQL RealTime: Failed to query 'ps_aors at asterisk'.
> [May 26 09:35:05] ERROR[578] res_config_pgsql.c: PostgreSQL RealTime: Query Failed: UPDATE ps_aors SET minimum_expiration = '60', default_expiration = '3600', qualify_timeout = '3.000000', mailboxes = '', suppor
> t_path = 'true', voicemail_extension = '', max_contacts = '1', authenticate_qualify = 'false', contact = '', maximum_expiration = '7200', qualify_frequency = '0', remove_existing = 'false', outbound_proxy = '' W
> HERE id = '9100'
> [May 26 09:35:05] ERROR[578] res_config_pgsql.c: PostgreSQL RealTime: Query Failed because: ERROR:  invalid input value for enum yesno_values: "true"
> LINE 1: ...eout = '3.000000', mailboxes = '', support_path = 'true', vo...
>                                                              ^
>  (PGRES_FATAL_ERROR)
> [May 26 09:35:05] DEBUG[578] res_config_pgsql.c: PostgreSQL query attempt 1
> {noformat}
> The schema for yesno_values is the following:
> {noformat}
> create type yesno_values as enum ('yes', 'no');
> {noformat}



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