Hi,
I had to change the default charset and collate as below to fix this.
mysql::db { 'test1':
charset => 'latin1',
collate => 'latin1_swedish_ci',
user => 'root',
password => 'root',
host => 'qaamysql',
sql => "/mnt/dbscripts/apimgt/mysql.sql",
}
Thanks,
Iqbal
On Mon, Aug 31, 2015 at 3:15 PM, Irham Iqbal <[email protected]> wrote:
>
> Hi,
>
> I am using puppetlabs/mysql puppet module to create databases. I have two
> sql files to create two different databases, one is running fine and
> creating the tables. when running the second sql file I am getting the
> following error. But i am not getting it when i am running it manually to
> create the tables.
>
> Notice:
> /Stage[main]/Main/Node[qaamysql]/Mysql::Db[test1]/Exec[test1-import]/returns:
> ERROR 1071 (42000) at line 525: Specified key was too long; max key length
> is 767 bytes
>
> Thanks,
> Iqbal
> --
> Irham Iqbal
> Software Engineer - Test Automation
> WSO2, Inc.: http://wso2.com
> lean. enterprise. middleware
> phone: +94 777888452
>
--
Irham Iqbal
Software Engineer - Test Automation
WSO2, Inc.: http://wso2.com
lean. enterprise. middleware
phone: +94 777888452
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
