Re: [PacketFence-users] maintenance script with remote database

2016-09-29 Thread Louis Munro
> On Sep 29, 2016, at 4:41 AM, Morris, Andi wrote: > > Yes, I have now commented out the DB dump from the main script and am running > that separately. As mentioned, this means that if I want the script to clean > up the tables, and optimise I still need the mariadb

Re: [PacketFence-users] maintenance script with remote database

2016-09-29 Thread Morris, Andi
@lists.sourceforge.net Subject: Re: [PacketFence-users] maintenance script with remote database On Sep 28, 2016, at 11:55 AM, Morris, Andi <amor...@cardiffmet.ac.uk<mailto:amor...@cardiffmet.ac.uk>> wrote: Apologies, I mean the database cleaner script being run remotely, not the

Re: [PacketFence-users] maintenance script with remote database

2016-09-28 Thread Louis Munro
> On Sep 28, 2016, at 11:55 AM, Morris, Andi wrote: > > Apologies, I mean the database cleaner script being run remotely, not the > optimisation. What was the error? Of course, if you run the database backup script on another server you will need to copy to

Re: [PacketFence-users] maintenance script with remote database

2016-09-28 Thread Morris, Andi
cketfence-users@lists.sourceforge.net> Subject: Re: [PacketFence-users] maintenance script with remote database On Sep 28, 2016, at 10:34 AM, Morris, Andi <amor...@cardiffmet.ac.uk<mailto:amor...@cardiffmet.ac.uk>> wrote: Hi Louis, That makes sense, but in practice I

Re: [PacketFence-users] maintenance script with remote database

2016-09-28 Thread Morris, Andi
: [PacketFence-users] maintenance script with remote database On Sep 28, 2016, at 10:34 AM, Morris, Andi <amor...@cardiffmet.ac.uk<mailto:amor...@cardiffmet.ac.uk>> wrote: Hi Louis, That makes sense, but in practice I get errors when running this on a server that hasn’t had packetfen

Re: [PacketFence-users] maintenance script with remote database

2016-09-28 Thread Louis Munro
On Sep 28, 2016, at 10:34 AM, Morris, Andi 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

Re: [PacketFence-users] maintenance script with remote database

2016-09-28 Thread Morris, Andi
a remote db server? Is it likely to cause an issue? Cheers, Andi From: Louis Munro [mailto:lmu...@inverse.ca] Sent: 28 September 2016 14:26 To: packetfence-users@lists.sourceforge.net Subject: Re: [PacketFence-users] maintenance script with remote database Hi Andi, The script will run

Re: [PacketFence-users] maintenance script with remote database

2016-09-28 Thread Louis Munro
Hi Andi, The script will run but not backup the database if it's not running locally. That is what the check for the `hostname`.pid does. It will only backup the PF files that are present locally in that case. I suggest you run that script on the database server itself. The script does not

Re: [PacketFence-users] maintenance script with remote database

2016-09-27 Thread Morris, Andi
Hi, An update to this. It does seem to work well if the packetfence server is also running the mariadb service. Mine wasn't as there's no need for it if the database is on a remote server. Starting it meant that I could run the maintenance job and see the backups being created, aswell as the