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 optimisation being run.
Would you like me to log this as an issue on github? On a related note, I can see that issue 1415 https://github.com/inverse-inc/packetfence/issues/1415 mentions an email that is generated when this script is run. I've never had that email. Is it something that should 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:[email protected]] Sent: 21 September 2016 10:16 To: [email protected] Subject: [PacketFence-users] maintenance script with remote database 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 hostname, so I assume it does, however when I scheduled it to run last night I didn't get a DB dump saved, whereas I did get the files dump, so I'm also concerned that the table optimisation wouldn't run, and these are likely to get pretty large if not. Cheers, Andi
------------------------------------------------------------------------------
_______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
