Thanks Oliver! That fixed it, knew it had to be something simple. Jake Sallee Godfather Of Bandwidth Network Engineer
Fone: 254-295-4658 Phax: 254-295-4221 -----Original Message----- From: Olivier Bilodeau [mailto:[email protected]] Sent: Friday, July 23, 2010 11:54 AM To: [email protected] Subject: Re: [Packetfence-users] reinit pf database Hi Jake, Sallee, Stephen (Jake) wrote: > Ok, during my PF install I was not able to connect to the MYSQL server > (I stupidly forgot to configure the firewall) however, that is now > remedied. BUT, I cannot start PF because it never got to setup its > database. I have tried manually adding the pf database but then I get > an error about missing person with user id 1, and if the pf database > is not there it complains about that too. > > How do I initialize the DB? Rerunning the configurator script does > not give me the option. I know it has to be something rather simple, > any help is appreciated. Database is done by installer.pl so re-run it. If you only intend to create the database then you can skip installer.pl and call this directly instead: * database must not exist if it does drop it * cd /usr/local/pf/ mysqladmin --host=<host> --port=<port> -u <admin_user> create <database> mysql --host=<host> --port=<port> -u <admin_user> -p <database> < db/pfschema.mysql host is localhost if you are running mysql locally port is usually 3306 database is usually pf admin_user is usually root password will be prompted for on the command line I hope this helps! -- Olivier Bilodeau [email protected] :: +1.514.447.4918 *115 :: www.inverse.ca Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (www.packetfence.org) ------------------------------------------------------------------------ ------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ Packetfence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users ------------------------------------------------------------------------------ This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first _______________________________________________ Packetfence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
