On Apr 21, 2015, at 12:53 , Andy A <[email protected]> wrote:
> I am using a remote MySQL host (MySQL on a different box from PF installation)
> I have changed the database host address in pf.conf, pfconfig.conf and
> pf.conf.defaults. I have also used pf-schema.sql to populate the remote DB
> host.
>
> I am unable to get an IP address via DHCP because when a client device tries
> to get an IP address I see the following in pfdhcplistener.log
>
> pfdhcplistener(7664) INFO: Unseen before node added: 60:03:08:a5:84:3a
> (main::listen_dhcp)
> pfdhcplistener(7664) WARN: database query failed with: Incorrect integer
> value: '' for column 'bypass_role_id' at row 1 (errno: 1366), will try again
> (pf::db::db_query_execute)
> pfdhcplistener(7664) WARN: database query failed with: Incorrect integer
> value: '' for column 'bypass_role_id' at row 1 (errno: 1366), will try again
> (pf::db::db_query_execute)
> pfdhcplistener(7664) WARN: database query failed with: Incorrect integer
> value: '' for column 'bypass_role_id' at row 1 (errno: 1366), will try again
> (pf::db::db_query_execute)
> pfdhcplistener(7664) ERROR: Database issue: We tried 3 times to serve query
> node_add_sql called from pf::node::node_add and we failed. Is the database
> running? (pf::db::db_query_execute)
> pfdhcplistener(7664) INFO: DHCPREQUEST from 60:03:08:a5:84:3a (10.252.7.120)
> with lease of 7776000 seconds (main::parse_dhcp_request)
> pfdhcplistener(7664) INFO: Matched MAC '60:03:08:a5:84:3a' to IP address
> '10.252.7.120' using SQL 'iplog' table (pf::iplog::mac2ip)
> pfdhcplistener(7664) INFO: Matched IP '10.252.7.120' to MAC address
> '60:03:08:a5:84:3a' using SQL 'iplog' table (pf::iplog::ip2mac)
> pfdhcplistener(7664) INFO: Matched MAC '60:03:08:a5:84:3a' to IP address
> '10.252.7.120' using SQL 'iplog' table (pf::iplog::mac2ip)
> pfdhcplistener(7664) WARN: database query failed with: Incorrect integer
> value: '' for column 'bypass_role_id' at row 1 (errno: 1366), will try again
> (pf::db::db_query_execute)
> pfdhcplistener(7664) WARN: database query failed with: Incorrect integer
> value: '' for column 'bypass_role_id' at row 1 (errno: 1366), will try again
> (pf::db::db_query_execute)
> pfdhcplistener(7664) WARN: database query failed with: Incorrect integer
> value: '' for column 'bypass_role_id' at row 1 (errno: 1366), will try again
> (pf::db::db_query_execute)
> pfdhcplistener(7664) ERROR: Database issue: We tried 3 times to serve query
> node_add_sql called from pf::node::node_add and we failed. Is the database
> running? (pf::db::db_query_execute)
> pfdhcplistener(7664) ERROR: modify of non-existent node 60:03:08:a5:84:3a
> attempted - node add failed (pf::node::node_modify)
> pfdhcplistener(7664) WARN: Unable to perform a Fingerbank lookup for device
> with MAC address '60:03:08:a5:84:3a' (pf::fingerbank::process)
> pfdhcplistener(7664) INFO: 60:03:08:a5:84:3a requested an IP with the
> following informations: last_dhcp = 2015-04-21 17:38:40,computername =
> Blocks-MBP,dhcp_fingerprint = 1,3,6,15,119,95,252,44,46,dhcp_vendor =
> (main::listen_dhcp)
> pfdhcplistener(7664) INFO: 60:03:08:a5:84:3a is of device type
> (main::listen_dhcp)
>
Hi Andy,
Which version of PF is this?
Also, could you show the output to this command please?
# mysqldump -upf -p --no-data pf node
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
