[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:all-tabpanel ]

Sean Bright updated ASTERISK-28188:
-----------------------------------

    Assignee: Michael
      Status: Waiting for Feedback  (was: Open)

Where are you getting the Asterisk source from that you have a {{contrib/realtime/mysql/mysql_config.sql}} file?

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