Install error when creating MySQL database

[rgreiner]

Hi,

I'm trying to make a new install of Cacti , but during the creation of the database I'm getting the following error:

root@server:~/temp/cacti# mysql -p cacti < cacti.sql
Enter password:
ERROR 1071 (42000) at line 1916: Specified key was too long; max key length is 1000 bytes

Has anyone else had this problem?

I'm running the install in the following platform:
Debian 7.7
MySQL version 5.5.40 (from Debian's APT)
Cacti 0.8.8b (downloaded, not APT)

Tks,

Roberto

PS: as a curiosity. MySQL is favoring InnoDB in place of MyISAM. Why does Cacti specify MyISAM in it's creation?

[rgreiner]

I had created the database with utf-16-general and utf-32-general. After deleting and creating it with default collation (whichever that is...), the script to populate the database worked fine.