Yes exactly, mysql is a dependency but disable it when the system start. Le Jeudi, Février 25, 2016 10:49 EST, "Morris, Andi" <amor...@cardiffmet.ac.uk> a écrit: > Thanks Fabrice, > So for the actual packetfence server I just install as the complete package, > but just ignore/disable the local mysql installation? > > Cheers, > Andi > > -----Original Message----- > From: Fabrice Durand [mailto:fdur...@inverse.ca] > Sent: 25 February 2016 15:29 > To: packetfence-users@lists.sourceforge.net > Subject: Re: [PacketFence-users] Installing with separate database server > Importance: Low > > Hello Andi, > > you just need to install a mysql server (mysql, mariadb, gallera-cluster > ...), import db/pf-schema.sql. > And: > > GRANT SELECT,INSERT,UPDATE,DELETE,EXECUTE,LOCK TABLES ON pf.* TO > pf@172.20.20.1 IDENTIFIED BY packetfence; GRANT DROP ON pf.radius_nas TO > pf@172.20.20.1 IDENTIFIED BY packetfence; GRANT ALL PRIVILEGES ON > pf_graphite.* TO pf@172.20.20.1 IDENTIFIED BY packetfence; > > 172.20.20.1 is your pf ip address. > And change the db information in pf.conf (ie pf.conf.default). > > Regards > Fabrice > > Le Jeudi, Février 25, 2016 08:15 EST, "Morris, Andi" > <amor...@cardiffmet.ac.uk> a écrit: > > > Hi all. > > Just wondering what the best practice is for installing packetfence with a > > separate mysql database server. Do I need to install packetfence on the > > main server without the mysql elements? If so, what's the best way to do > > that so that I don't miss out a vital dependency when installing separate > > packages? > > > > For the database server itself, is it best to install mysql from the > > packetfence repository? If so, again what are the packages required for > > this to run? > > > > I'm aware of the schema scripts in /usr/local/pf/db and I've seen the > > command on this mailing list to set the necessary user permissions, is this > > info in any of the admin guides? > > > > Cheers, > > Andi > > ________________________________ > > > > [Cardiff Metropolitan University - 150 years of nurturing > > talent]<http://www.cardiffmet.ac.uk/cardiffmet150> > > > ------------------------------------------------------------------------------ > Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + > Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor > end-to-end web transactions and take corrective actions now Troubleshoot > faster and improve end-user experience. Signup Now! > http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 > _______________________________________________ > PacketFence-users mailing list > PacketFence-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/packetfence-users > ------------------------------------------------------------------------------ > Site24x7 APM Insight: Get Deep Visibility into Application Performance > APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month > Monitor end-to-end web transactions and take corrective actions now > Troubleshoot faster and improve end-user experience. Signup Now! > http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 > _______________________________________________ > PacketFence-users mailing list > PacketFence-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/packetfence-users
------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140 _______________________________________________ PacketFence-users mailing list PacketFence-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/packetfence-users