Hi Jon, I can reproduce this on percona 5.7 : it seems that mysql 5.7 engine is less tolerant than before.
You can try to modify the sql file, and change the 'trigger' table creation this way: CREATE TABLE `trigger` ( `vid` int(11) NOT NULL DEFAULT '0', `tid_start` varchar(255) NOT NULL, `tid_end` varchar(255) NOT NULL, `type` varchar(255) NOT NULL DEFAULT '', `whitelisted_categories` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`vid`,`tid_start`,`tid_end`,`type`), KEY `trigger` (`tid_start`,`tid_end`,`type`), CONSTRAINT `0_64` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB and that should work. ----- Mail original ----- > De: "Jon Falconer" <[email protected]> > À: [email protected] > Envoyé: Vendredi 27 Janvier 2017 04:46:19 > Objet: [PacketFence-users] failed to created PF database on fresh install > Dear user community, > I've tried searching the archives, but have not found my specific problem. I'm > trying to install Packet Fence 6.4.0-1 on a fresh install of Debian 8.6.0 > (Jessie). I'm using MySQL 5.7.17. When I run the configurator to do the > initial > setup, it fails to create the PF database. It does pass the root login test. > If > I try to manually create the database by typing "mysql -u root -p pf < > /usr/local/pf/db/pf-schema-6.4.0.sql" MySQL complains with the message: > ERROR 1171 (42000) at line 43: All parts of a PRIMARY KEY must be NOT NULL; if > you need NULL in a key, use UNIQUE instead > Is this version of MySQL too picky or have a bug? Is the schema broken? Are > there some other steps that are needed? Any ideas? ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot _______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
