Author Topic: error in install & unable to logon  (Read 3073 times)

benemanuel

  • wiki
  • **
  • Posts: 1
  • Karma: +0/-0
error in install & unable to logon
« 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

rainer_d

  • Veteran
  • ****
  • Posts: 66
  • Karma: +3/-0
    • http://www.i-duffner.de
Re: error in install & unable to logon
« Reply #1 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.
--
FreeBSD - The Power To Serve

matt

  • Administrator
  • Wizard
  • *****
  • Posts: 635
  • Karma: +0/-0
    • Matt's Personal Site
Re: error in install & unable to logon
« Reply #2 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
« Last Edit: May 14, 2015, 12:36:51 am by matt »