> 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
@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
> 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
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
: [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
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
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
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
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