[asterisk-bugs] [JIRA] (ASTERISK-24772) ODBC error in realtime sippeers when device unregisters under MariaDB

[Matt Jordan (JIRA)]

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

Matt Jordan commented on ASTERISK-24772:
----------------------------------------

Merged - thanks for the contribution!

> ODBC error in realtime sippeers when device unregisters under MariaDB
> ---------------------------------------------------------------------
>
>                 Key: ASTERISK-24772
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-24772
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Channels/chan_sip/DatabaseSupport
>    Affects Versions: 11.16.0
>         Environment: CentOS 6.4, MariaDB 10.0.x
>            Reporter: Richard Miller
>            Severity: Minor
>         Attachments: chan_sip.diff
>
>
> In the file contrib/realtime/mysql/sippeers.sql, the port column is defined as
> `port` int(5) DEFAULT NULL
> When a device unregisters, the query to clear the port number in sippeers uses an empty string in the function destroy_association.  Most database engines will coerce an empty string value to a zero value.  MariaDB does not do this.
> The log shows
> {noformat}
> WARNING[17024]: res_odbc.c:646 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000: [MySQL][ODBC 5.1 Driver][mysqld-5.5.5-10.0.16-MariaDB]Incorrect integer value: '' for column 'port' at row 1 (108)
> WARNING[17024]: res_odbc.c:658 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to ...
> {noformat}



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