when i run packetfence i get the followings in packetfence.log:
Apr 22 15:09:12 pfcmd.pl(8578) WARN: database query failed with: Unknown
column 'window' in 'field list'. (errno: 1054), will try again
(pf::db::db_query_execute)
Apr 22 15:09:12 pfcmd.pl(8578) ERROR: Database issue: We tried 3 times to
serve query class_add_sql called from pf::class::class_add and we failed.
Is the database running? (pf::db::db_query_execute)
Apr 22 15:09:12 pfcmd.pl(8578) WARN: database query failed with: Cannot add
or update a child row: a foreign key constraint fails (`pf`.`action`,
CONSTRAINT `FOREIGN` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON
DELETE CASCADE ON UPDATE CASCADE). (errno: 1452), will try again
(pf::db::db_query_execute)
Apr 22 15:09:12 pfcmd.pl(8578) WARN: database query failed with: Cannot add
or update a child row: a foreign key constraint fails (`pf`.`action`,
CONSTRAINT `FOREIGN` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON
DELETE CASCADE ON UPDATE CASCADE). (errno: 1452), will try again
(pf::db::db_query_execute)
Apr 22 15:09:12 pfcmd.pl(8578) WARN: database query failed with: Cannot add
or update a child row: a foreign key constraint fails (`pf`.`action`,
CONSTRAINT `FOREIGN` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON
DELETE CASCADE ON UPDATE CASCADE). (errno: 1452), will try again
(pf::db::db_query_execute)
Apr 22 15:09:12 pfcmd.pl(8578) ERROR: Database issue: We tried 3 times to
serve query action_add_sql called from pf::action::action_add and we
failed. Is the database running? (pf::db::db_query_execute)
Apr 22 15:09:12 pfcmd.pl(8578) WARN: database query failed with: Cannot add
or update a child row: a foreign key constraint fails (`pf`.`action`,
CONSTRAINT `FOREIGN` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON
DELETE CASCADE ON UPDATE CASCADE). (errno: 1452), will try again
(pf::db::db_query_execute)
Apr 22 15:09:12 pfcmd.pl(8578) WARN: database query failed with: Cannot add
or update a child row: a foreign key constraint fails (`pf`.`action`,
CONSTRAINT `FOREIGN` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON
DELETE CASCADE ON UPDATE CASCADE). (errno: 1452), will try again
(pf::db::db_query_execute)
Apr 22 15:09:12 pfcmd.pl(8578) WARN: database query failed with: Cannot add
or update a child row: a foreign key constraint fails (`pf`.`action`,
CONSTRAINT `FOREIGN` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON
DELETE CASCADE ON UPDATE CASCADE). (errno: 1452), will try again
(pf::db::db_query_execute)
Apr 22 15:09:12 pfcmd.pl(8578) ERROR: Database issue: We tried 3 times to
serve query action_add_sql called from pf::action::action_add and we
failed. Is the database running? (pf::db::db_query_execute)
Apr 22 15:09:12 pfcmd.pl(8578) WARN: database query failed with: Cannot add
or update a child row: a foreign key constraint fails (`pf`.`trigger`,
CONSTRAINT `0_64` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE
CASCADE ON UPDATE CASCADE). (errno: 1452), will try again
(pf::db::db_query_execute)
Apr 22 15:09:12 pfcmd.pl(8578) WARN: database query failed with: Cannot add
or update a child row: a foreign key constraint fails (`pf`.`trigger`,
CONSTRAINT `0_64` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE
CASCADE ON UPDATE CASCADE). (errno: 1452), will try again
(pf::db::db_query_execute)
Apr 22 15:09:12 pfcmd.pl(8578) WARN: database query failed with: Cannot add
or update a child row: a foreign key constraint fails (`pf`.`trigger`,
CONSTRAINT `0_64` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE
CASCADE ON UPDATE CASCADE). (errno: 1452), will try again
(pf::db::db_query_execute)
Apr 22 15:09:12 pfcmd.pl(8578) ERROR: Database issue: We tried 3 times to
serve query trigger_add_sql called from pf::trigger::trigger_add and we
failed. Is the database running? (pf::db::db_query_execute)
Apr 22 15:09:12 pfcmd.pl(8578) WARN: database query failed with: Cannot add
or update a child row: a foreign key constraint fails (`pf`.`trigger`,
CONSTRAINT `0_64` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE
CASCADE ON UPDATE CASCADE). (errno: 1452), will try again
(pf::db::db_query_execute)
Apr 22 15:09:12 pfcmd.pl(8578) WARN: database query failed with: Cannot add
or update a child row: a foreign key constraint fails (`pf`.`trigger`,
CONSTRAINT `0_64` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE
CASCADE ON UPDATE CASCADE). (errno: 1452), will try again
(pf::db::db_query_execute)
Apr 22 15:09:12 pfcmd.pl(8578) WARN: database query failed with: Cannot add
or update a child row: a foreign key constraint fails (`pf`.`trigger`,
CONSTRAINT `0_64` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE
CASCADE ON UPDATE CASCADE). (errno: 1452), will try again
(pf::db::db_query_execute)
Apr 22 15:09:12 pfcmd.pl(8578) ERROR: Database issue: We tried 3 times to
serve query trigger_add_sql called from pf::trigger::trigger_add and we
failed. Is the database running? (pf::db::db_query_execute)
Apr 22 15:09:12 pfcmd.pl(8578) WARN: database query failed with: Cannot add
or update a child row: a foreign key constraint fails (`pf`.`trigger`,
CONSTRAINT `0_64` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE
CASCADE ON UPDATE CASCADE). (errno: 1452), will try again
(pf::db::db_query_execute)
Apr 22 15:09:12 pfcmd.pl(8578) WARN: database query failed with: Cannot add
or update a child row: a foreign key constraint fails (`pf`.`trigger`,
CONSTRAINT `0_64` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE
CASCADE ON UPDATE CASCADE). (errno: 1452), will try again
(pf::db::db_query_execute)
Apr 22 15:09:12 pfcmd.pl(8578) WARN: database query failed with: Cannot add
or update a child row: a foreign key constraint fails (`pf`.`trigger`,
CONSTRAINT `0_64` FOREIGN KEY (`vid`) REFERENCES `class` (`vid`) ON DELETE
CASCADE ON UPDATE CASCADE). (errno: 1452), will try again
(pf::db::db_query_execute)
Apr 22 15:09:12 pfcmd.pl(8578) ERROR: Database issue: We tried 3 times to
serve query trigger_add_sql called from pf::trigger::trigger_add and we
failed. Is the database running? (pf::db::db_query_execute)
2013/4/22 Fabrice DURAND <[email protected]>
> Hello Nour,
> in 3.6.1 you can use the configurator on this address
> http://@ip_packetfence:1444/configurator and follow all the step.
> Regards
> Fabrice
>
> Le 2013-04-22 04:42, nour soltani a écrit :
>
> hi,
> i'm installing packetfence v3.6.1 but pf database does not exist so when
> creat it i found several pfchema in /usr/local/pf/db/ i'm confused which
> one to use
> thanks
>
>
> ------------------------------------------------------------------------------
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free
> account!http://www2.precog.com/precogplatform/slashdotnewsletter
>
>
>
> _______________________________________________
> PacketFence-users mailing
> [email protected]https://lists.sourceforge.net/lists/listinfo/packetfence-users
>
>
>
> --
> Fabrice [email protected] :: +1.514.447.4918 (x135) :: www.inverse.ca
> Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence
> (http://packetfence.org)
>
>
>
> ------------------------------------------------------------------------------
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> _______________________________________________
> PacketFence-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>
>
------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
