Nope. MySQL on the external machine is only being used for PF. I made a default
yum install of latest mysql-community-server and it installed with those
settings.
I just did a local install, to test what are the default settings and I opened
/etc/my.cnf and this is what mysql got installed with. It seems like it's the
default setting with 5.6
http://stackoverflow.com/questions/20576917/how-do-i-disable-strict-trans-tables-for-a-homebrew-installed-mysql-server
# Recommended in standard MySQL
setupsql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
On the external machine, I am running a master slave replication. I think I
can live with the following sql_mode
# Recommended in standard MySQL setupsql_mode=NO_ENGINE_SUBSTITUTION
That worked and now I have moved forward to the next problem.
Apr 22 18:12:51 pfdhcplistener(10751) ERROR: Unable to list iptables mangle
table: (pf::ipset::get_mangle_mark_for_mac)
Here's the output for iptables -t mangle (I am logged in as root, when I run
this command)
iptables -t mangle -L -nvChain PREROUTING (policy ACCEPT 1167 packets, 449K
bytes) pkts bytes target prot opt in out source
destination 344 49648 prerouting-int-inline-if all -- eth1 *
0.0.0.0/0 0.0.0.0/0
Chain INPUT (policy ACCEPT 581 packets, 391K bytes) pkts bytes target prot
opt in out source destination
Chain FORWARD (policy ACCEPT 0 packets, 0 bytes) pkts bytes target prot opt
in out source destination
Chain OUTPUT (policy ACCEPT 769 packets, 380K bytes) pkts bytes target prot
opt in out source destination
Chain POSTROUTING (policy ACCEPT 769 packets, 380K bytes) pkts bytes target
prot opt in out source destination
Chain prerouting-int-inline-if (1 references) pkts bytes target prot opt in
out source destination 344 49648 MARK all -- *
* 0.0.0.0/0 0.0.0.0/0 MARK set 0x3 0 0
MARK all -- * * 0.0.0.0/0 0.0.0.0/0
match-set pfsession_Unreg_172.31.30.0 src,src MARK set 0x3 0 0 MARK
all -- * * 0.0.0.0/0 0.0.0.0/0 match-set
pfsession_Reg_172.31.30.0 src,src MARK set 0x1 0 0 MARK all -- *
* 0.0.0.0/0 0.0.0.0/0 match-set
pfsession_Isol_172.31.30.0 src,src MARK set 0x2
From: [email protected]
Date: Wed, 22 Apr 2015 12:58:41 -0400
To: [email protected]
Subject: Re: [PacketFence-users] Using remote MySQL host
On Apr 22, 2015, at 12:51 , Andy A <[email protected]> wrote:
Okay cool. Is this enough or do I need to do anything else?
SET sql_mode='';
Well that will set it until the next time you restart MySQL.You need to make
sure it’s set permanently, probably in /etc/my.cnf or one of the included files.
The question is though, why was it set in the first place?Are you running
another database on that mysql that might require those modes?
Only you can answer that.
Regards,
--
Louis Munro
[email protected] :: www.inverse.ca
+1.514.447.4918 x125 :: +1 (866) 353-6153 x125
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence
(www.packetfence.org)
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
