[asterisk-bugs] [JIRA] (ASTERISK-28188) mysql db import error

[Sean Bright (JIRA)]

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

Sean Bright commented on ASTERISK-28188:
----------------------------------------

There is no {{contrib/realtime/mysql}} directory in the git repository. Is that being packaged by a third party? My assumption is that your database's default charset is {{utf8mb4}} or something along those lines making the columns 4x longer than they should be.

> mysql db import error
> ---------------------
>
>                 Key: ASTERISK-28188
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-28188
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: General
>    Affects Versions: 16.0.0
>         Environment: debian 9 amd64, asterisk v16 LTS, using pjsip, mysql ODBC.
>            Reporter: Michael
>            Severity: Minor
>              Labels: pjsip
>
> root@#:/opt/src/asterisk-16.0.1# mysql temp < /opt/src/asterisk-16.0.1/contrib/realtime/mysql/mysql_config.sql
> ERROR 1071 (42000) at line 613: Specified key was too long; max key length is 767 bytes
> if I edit mysql_config.sql line 613 and change varchar to VARCHAR(190), it imports successfully. 



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