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
be sent to the user designated for PF alerts? If not, is there scope for this to be added as an option? Cheers, Andi From: Morris, Andi [mailto:amor...@cardiffmet.ac.uk] Sent: 21 September 2016 10:16 To: packetfence-users@lists.sourceforge.net Subject: [PacketFence-users] maintenance script

[PacketFence-users] maintenance script with remote database

2016-09-21 Thread Morris, Andi
Hi all, I've recently moved to a setup which has a remote database server, and I was wondering whether the regular addons/database-backup-and-maintenance.sh file will still run from the packetfence server to the remote DB server. I can see the flags inside the script calling for the database