Hello.
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)
What are those errors and warnings? Clearly, PF is able to match a MAC address
to an IP from the iplog table in the remote host database.
select * from
iplog;+-------------------+--------------+---------------------+---------------------+|
mac | ip | start_time | end_time
|+-------------------+--------------+---------------------+---------------------+|
60:03:08:a5:84:3a | 10.252.7.120 | 2015-04-19 07:38:40 | 2015-07-18 07:38:40
|+-------------------+--------------+---------------------+---------------------+1
row in set (0.00 sec)
Can someone help? Thanks
------------------------------------------------------------------------------
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
