[asterisk-bugs] [JIRA] (ASTERISK-27272) res_config_pjsql, contrib: Invalid input value for enum yesno_values: "true"

[Sean Bright (JIRA)]

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

Sean Bright commented on ASTERISK-27272:
----------------------------------------

Also, the file you referenced - {{asterisk-14.6.1/contrib/ast-db-manage/realtime/postgresql/postgresql_config.sql}} - does not exist in the Asterisk source tarball, so I'm not sure where you got it.

> res_config_pjsql, contrib: Invalid input value for enum yesno_values: "true"
> ----------------------------------------------------------------------------
>
>                 Key: ASTERISK-27272
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-27272
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Contrib/General, Resources/res_config_pgsql
>    Affects Versions: 14.6.1
>            Reporter: Ilgiz Badamshin
>            Assignee: Ilgiz Badamshin
>            Severity: Minor
>
> Configured Asterisk 14.6.1 with realtime in pgsql. 
> Some columns has yesno_value enum type in database. But ARI tries insert there boolean values. So sql execution failed and data isn't saved in database:
> bq. res_config_pgsql.c: PostgreSQL RealTime: Query Failed because: ERROR: invalid input value for enum yesno_values: "true"
> Details: https://community.asterisk.org/t/troubles-with-yesno-values-enum-in-postgresql/71993
> Hi.
> I configured Asterisk 14.6.1 realtime with pgsql. Schema was created from asterisk-14.6.1/contrib/ast-db-manage/realtime/postgresql/postgresql_config.sql
> PostgresSql version: 9.5.8.
> Then I enabled ARI and try push configs by exmples from: https://wiki.asterisk.org/wiki/display/AST/ARI+Push+Configuration
> In asterisk cli i see errors:
> {noformat}
> res_config_pgsql.c: PostgreSQL RealTime: Failed to query ‘ps_aors at asterisk-db’.
> res_config_pgsql.c: PostgreSQL RealTime: Query Failed: INSERT INTO ps_aors (id, minimum_expiration, default_expiration, qualify_timeout, mailboxes, support_path, voicemail_extension, max_contacts, authenticate_qualify, contact, maximum_expiration, qualify_frequency, remove_existing, outbound_proxy) VALUES (‘alice’, ‘60’, ‘3600’, ‘3.000000’, ‘’, ‘true’, ‘’, ‘1’, ‘false’, ‘’, ‘7200’, ‘0’, ‘true’, ‘’)
> res_config_pgsql.c: PostgreSQL RealTime: Query Failed because: ERROR: invalid input value for enum yesno_values: "true"
> LINE 1: …y) VALUES (‘alice’, ‘60’, ‘3600’, ‘3.000000’, ‘’, ‘true’, ‘’…
> That happens with other tables too.
> {noformat}
> Is it bug and should be fixed by developers or I should change column type to boolean or add “true”, “false” to enum yesno_values?



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