Hi Louis.
PF version is 5.0
Here's the output that you requested.
-- MySQL dump 10.13 Distrib 5.6.23, for Linux (x86_64)---- Host: localhost
Database: pf-- -------------------------------------------------------- Server
version 5.6.23-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET
@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET
@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8
*/;/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;/*!40103 SET TIME_ZONE='+00:00'
*/;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0
*/;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'
*/;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;Warning: A partial
dump from a server that has GTIDs will by default include the GTIDs of all
trat-gtid-purged=OFF. To make a complete dump, pass --all-databases --triggers
--routines --events.SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN;SET
@@SESSION.SQL_LOG_BIN= 0;
---- GTID state at the beginning of the backup--
SET @@GLOBAL.GTID_PURGED='8bae3138-d6fe-11e4-8222-0050569312b9:1-5867';
---- Table structure for table `node`--
DROP TABLE IF EXISTS `node`;/*!40101 SET @saved_cs_client =
@@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE
TABLE `node` ( `mac` varchar(17) NOT NULL, `pid` varchar(255) NOT NULL
DEFAULT 'admin', `category_id` int(11) DEFAULT NULL, `detect_date` datetime
NOT NULL DEFAULT '0000-00-00 00:00:00', `regdate` datetime NOT NULL DEFAULT
'0000-00-00 00:00:00', `unregdate` datetime NOT NULL DEFAULT '0000-00-00
00:00:00', `lastskip` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`time_balance` int(10) unsigned DEFAULT NULL, `bandwidth_balance` int(10)
unsigned DEFAULT NULL, `status` varchar(15) NOT NULL DEFAULT 'unreg',
`user_agent` varchar(255) DEFAULT NULL, `computername` varchar(255) DEFAULT
NULL, `notes` varchar(255) DEFAULT NULL, `last_arp` datetime NOT NULL DEFAULT
'0000-00-00 00:00:00', `last_dhcp` datetime NOT NULL DEFAULT '0000-00-00
00:00:00', `dhcp_fingerprint` varchar(255) DEFAULT NULL, `dhcp_vendor`
varchar(255) DEFAULT NULL, `device_type` varchar(255) DEFAULT NULL,
`device_class` varchar(255) DEFAULT NULL, `bypass_vlan` varchar(50) DEFAULT
NULL, `voip` enum('no','yes') NOT NULL DEFAULT 'no', `autoreg`
enum('no','yes') NOT NULL DEFAULT 'no', `sessionid` varchar(30) DEFAULT NULL,
`machine_account` varchar(255) DEFAULT NULL, `bypass_role_id` int(11) DEFAULT
NULL, PRIMARY KEY (`mac`), KEY `pid` (`pid`), KEY `category_id`
(`category_id`), KEY `node_status` (`status`,`unregdate`), KEY
`node_dhcpfingerprint` (`dhcp_fingerprint`), CONSTRAINT `0_57` FOREIGN KEY
(`pid`) REFERENCES `person` (`pid`) ON DELETE CASCADE ON UPDATE C CONSTRAINT
`node_category_key` FOREIGN KEY (`category_id`) REFERENCES `node_category`
(`categor) ENGINE=InnoDB DEFAULT CHARSET=latin1;/*!40101 SET
character_set_client = @saved_cs_client */;/*!50003 SET @saved_cs_client =
@@character_set_client */ ;/*!50003 SET @saved_cs_results =
@@character_set_results */ ;/*!50003 SET @saved_col_connection =
@@collation_connection */ ;/*!50003 SET character_set_client = utf8 */
;/*!50003 SET character_set_results = utf8 */ ;/*!50003 SET
collation_connection = utf8_general_ci */ ;/*!50003 SET @saved_sql_mode
= @@sql_mode */ ;/*!50003 SET sql_mode =
'STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION' */ ;DELIMITER ;;/*!50003 CREATE*/
/*!50017 DEFINER=`root`@`172.30.10.200`*/ /*!50003 TRIGGER
node_useragent_deletFOR EACH ROWBEGIN DELETE FROM node_useragent WHERE mac =
OLD.mac;END */;;DELIMITER ;/*!50003 SET sql_mode = @saved_sql_mode
*/ ;/*!50003 SET character_set_client = @saved_cs_client */ ;/*!50003 SET
character_set_results = @saved_cs_results */ ;/*!50003 SET collation_connection
= @saved_col_connection */ ;SET @@SESSION.SQL_LOG_BIN =
@MYSQLDUMP_TEMP_LOG_BIN;/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;/*!40014 SET
FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;/*!40014 SET
UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;/*!40101 SET
CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;/*!40101 SET
CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;/*!40101 SET
COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;/*!40111 SET
SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2015-04-21
From: [email protected]
Date: Tue, 21 Apr 2015 13:16:08 -0400
To: [email protected]
Subject: Re: [PacketFence-users] Using remote MySQL host
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
------------------------------------------------------------------------------
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
