error in install & unable to logon

Started by benemanuel, May 05, 2015, 07:28:33 AM

Previous topic - Next topic

benemanuel

in Configure MySQL
perl create_tables.pl
it dies on

     /* CONSTRAINT `nt_zone_record_ibfk_1` FOREIGN KEY (`nt_zone_id`) REFERENCES `nt_zone` (`nt_zone_id`) ON DELETE CASCADE ON UPDATE CASCADE */
) DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=COMPRESSED;DBD::mysql::db do failed: Specified key was too long; max key length is 767 bytes at create_tables.pl line 88, <$fh> line 69.
Specified key was too long; max key length is 767 bytes at create_tables.pl line 88, <$fh> line 69.

also but not necessarily connected, after continuing until the end. the web interface doesn't let me login. with this error
SOAP: fault: Can't use an undefined value as an ARRAY reference at /usr/local/lib/perl5/site_perl/NicToolServer.pm line 1523.

technical info:
freebsd 10.1
mysql_server56

rainer_d

I think you need to try with MySQL 5.5, MariaDB 5.5 (which I'm using) or Percona 5.5.
Is MySQL5.6 the default now?
I build my own packages, so I don't really care about the defaults because I've defined my own.
--
FreeBSD - The Power To Serve

matt

#2
Hey ben,
See https://www.tnpi.net/support/forums/index.php?topic=1053.0, which has info about that MySQL error you're getting.
Matt