[asterisk-bugs] [JIRA] (ASTERISK-29771) Crash occurs when 2 realtime sippeers mysql connections are configured and we have a schema warning

[Mario Ban (JIRA)]

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

Mario Ban updated ASTERISK-29771:
---------------------------------

    Description: 
Crash occurs when starting Asterisk and we have 2 realtime sippeers mysql connections configured and there is a sippeers (sipfriends) schema WARNING logged.

In our case it was column ipaddr varchar(40) was less than 45

After we altered the table and set ipaddr to varchar(45) - no crash anymore
Also if there is only 1 realtime connection but still with ipaddr varchar(40) - no crash

I can provide some debugging output


  was:
Crash occurs when 2 realtime sippeers mysql connections are configured and we have a sippeers (sipfriends) schema WARNING logged.

In our case it was column ipaddr varchar(40) was less than 45

After we altered the table and set ipaddr to varchar(45) - no crash anymore
Also if there is only 1 realtime connection but still with ipaddr varchar(40) - no crash

I can provide some debugging output



> Crash occurs when 2 realtime sippeers mysql connections are configured and we have a schema warning
> ---------------------------------------------------------------------------------------------------
>
>                 Key: ASTERISK-29771
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-29771
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Addons/res_config_mysql, Channels/chan_sip/DatabaseSupport
>    Affects Versions: 16.20.0
>         Environment: OS: Oracle Linux 8.3
> MariaDB 10.3 (Galera Cluster)
>            Reporter: Mario Ban
>            Severity: Major
>
> Crash occurs when starting Asterisk and we have 2 realtime sippeers mysql connections configured and there is a sippeers (sipfriends) schema WARNING logged.
> In our case it was column ipaddr varchar(40) was less than 45
> After we altered the table and set ipaddr to varchar(45) - no crash anymore
> Also if there is only 1 realtime connection but still with ipaddr varchar(40) - no crash
> I can provide some debugging output



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