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

[Michael (JIRA)]

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

Michael commented on ASTERISK-28188:
------------------------------------

If i...
create database temp character set UTF8;
then
mysql temp < /opt/src/asterisk-16.1.1/contrib/realtime/mysql/mysql_config.sql
it seems to work fine.

> 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
>            Assignee: Unassigned
>            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)