[asterisk-bugs] [JIRA] (ASTERISK-25041) 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:all-tabpanel ]

Alexandre Fournier updated ASTERISK-25041:
------------------------------------------

    Attachment: fix-res_config_mysql-column-type-checking.diff.txt

> 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
>            Severity: Trivial
>         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: [https://issues.asterisk.org/jira/browse/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: [https://issues.asterisk.org/jira/browse/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)