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

[Richard Mudgett (JIRA)]

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

Richard Mudgett updated ASTERISK-25041:
---------------------------------------

    Description: 
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.

  was:
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.


> 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
>              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)