Hi Louis, I’ve edited the script with the variables and the backup works fine on the DB server, it’s the optimisation that isn’t. However, presuming that running the optimisation commands doesn’t dump the database locally first that should be ok to run from the pf app server I guess. Although that does still mean I need to have mariadb running on the packetfence server.
I’ll keep playing with the script remotely to see what I can do. Cheers, Andi From: Louis Munro [mailto:[email protected]] Sent: 28 September 2016 16:02 To: [email protected] Subject: Re: [PacketFence-users] maintenance script with remote database On Sep 28, 2016, at 10:34 AM, Morris, Andi <[email protected]<mailto:[email protected]>> wrote: Hi Louis, That makes sense, but in practice I get errors when running this on a server that hasn’t had packetfence installed as there are calls to log4perl.pm files in the database-clearner.pl script. You would need to edit it to fill in some variables, like the db name, username and password. Don't be afraid to play with the script. There's nothing really fancy in there. Out of interest, what’s the danger of running this script from a packetfence server against a remote db server? Is it likely to cause an issue? The issue is that it would have to copy the database over the network and dump the copy on the server you are running it from. While that is doable, it is not really recommended. You might end up saturating the link between those two servers during the dump. Regards, -- Louis Munro [email protected]<mailto:[email protected]> :: www.inverse.ca<http://www.inverse.ca> +1.514.447.4918 x125 :: +1 (866) 353-6153 x125 Inverse inc. :: Leaders behind SOGo (www.sogo.nu<http://www.sogo.nu>) and PacketFence (www.packetfence.org<http://www.packetfence.org>) ------------------------------------------------------------------------------ _______________________________________________ PacketFence-users mailing list [email protected]<mailto:[email protected]> https://lists.sourceforge.net/lists/listinfo/packetfence-users
------------------------------------------------------------------------------
_______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
