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

[Michael Reinisch (JIRA)]

Michael Reinisch created ASTERISK-29452:
-------------------------------------------

             Summary: 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: 18.4.0, 18.3.0, 16.18.0
         Environment: OS: Debian 10

PostgreSql version: 11.12
            Reporter: Michael Reinisch
            Severity: Blocker


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)