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

[Alexandre Fournier (JIRA)]

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

Alexandre Fournier commented on ASTERISK-25041:
-----------------------------------------------

Gerrit review request done in master.

> [patch]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: 11.18.0, 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_.



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