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

[Joshua C. Colp (JIRA)]

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

Joshua C. Colp closed ASTERISK-29452.
-------------------------------------

    Resolution: Duplicate

> 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
>              Labels: ari, postgresql, sorcery
>         Attachments: asterisk_schema.sql
>
>
> 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)