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
