The Network People Support Forums

Other TNPI Software => NicTool => Topic started by: benemanuel on May 05, 2015, 07:28:33 AM

Title: error in install & unable to logon
Post by: benemanuel on May 05, 2015, 07:28:33 AM
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
Title: Re: error in install & unable to logon
Post by: rainer_d on May 08, 2015, 02:42:24 AM
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.
Title: Re: error in install & unable to logon
Post by: matt on May 14, 2015, 12:29:36 AM
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