[asterisk-bugs] [JIRA] (ASTERISK-25041) Broken column type checking in res_config_mysql addon

[Rusty Newton (JIRA)]

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

Rusty Newton updated ASTERISK-25041:
------------------------------------

    Assignee: Alexandre Fournier
      Status: Waiting for Feedback  (was: Triage)

Alexandre - reattach the patch once your CLA is approved and then we'll be able to see it. Then use "Send Back" or "Enter Feedback" to send the issue back to us. Thanks.

> Broken column type checking in res_config_mysql addon
> -----------------------------------------------------
>
>                 Key: ASTERISK-25041
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-25041
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Addons/res_config_mysql
>    Affects Versions: 13.3.2
>            Reporter: Alexandre Fournier
>            Assignee: Alexandre Fournier
>            Severity: Trivial
>              Labels: realtime
>         Attachments: fix-res_config_mysql-column-type-checking.diff.txt
>
>
> The improved real-time queue logging, introduced by [~coolmig] in 2010 does not work with a MySQL (or MariaDB) database since column type checking is broken in the _res_config_mysql_ add-on.
> Nevertheless, it is still possible to use this feature with _res_config_odbc_  and a MySQL connector or _res_config_pgsql_ as stated in the original patch proposal: ASTERISK-15863
> This might affect all versions of asterisk since 1.8 to current.
> To know if your version of Asterisk is affected by this bug, you'll get this error message in the CLI:
> {noformat}
> res_config_mysql.c:XXXX require_mysql: Realtime table queue_log at db: Column time cannot be a datetime)
> {noformat}
> Also, this might be related: ASTERISK-18252
> Please review the patch in attachment  It fixes MySQL type checking for DATETIME, DATE and FLOAT types in _res_config_mysql_.
> -- Waiting for CLA approval.



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