The next lines from packetfence.log were: Jun 17 14:51:23 httpd.portal(13792) INFO: Matched MAC '60:eb:69:56:4e:6e' to IP address '192.168.11.244' using OMAPI (pf::iplog::mac2ip) Jun 17 14:51:23 httpd.portal(13792) INFO: Matched MAC '60:eb:69:56:4e:6e' to IP address '192.168.11.244' using OMAPI (pf::iplog::mac2ip)
Here's the result from the SQL query: +-------------------+--------------+------+------+-----------------+----------------+------+---------------------+----------+--------------+------------+--------------------+-------+------------+ | mac | switch | port | vlan | connection_type | dot1x_username | ssid | start_time | end_time | switch_ip | switch_mac | stripped_user_name | realm | session_id | +-------------------+--------------+------+------+-----------------+----------------+------+---------------------+----------+--------------+------------+--------------------+-------+------------+ | 60:eb:69:56:4e:6e | 192.168.11.1 | 0 | 11 | Inline | | | 2015-06-17 14:48:38 | NULL | 192.168.11.1 | NULL | NULL | NULL | NULL | +-------------------+--------------+------+------+-----------------+----------------+------+---------------------+----------+--------------+------------+--------------------+-------+------------+ 1 row in set (0.00 sec) Thanks, Joshua Nathan IT Administrator Black Forest Academy +49 (0) 7626-916123 On Wed, Jun 17, 2015 at 2:56 PM, Fabrice DURAND <[email protected]> wrote: > Does pfdhcplistener work on your install ? > > Can you query the database with: > > select * from locationlog where mac="60:eb:69:56:4e:6e"; > > What after : > Jun 17 14:51:22 httpd.portal(13792) INFO: Instantiate a new iptables > modification method. pf::ipset (pf::inline::get_technique) > > > Regards > Fabrice > > > Le 2015-06-17 08:52, Nathan, Josh a écrit : > > I tried doing a fresh install... still seeing the problem. Here's > another error I'm getting: > Jun 17 14:51:22 httpd.portal(13792) INFO: [60:eb:69:56:4e:6e] shouldn't > reach here. Calling access re-evaluation. Make sure your network device > configuration is correct. > (captiveportal::PacketFence::Controller::CaptivePortal::unknownState) > Jun 17 14:51:22 httpd.portal(13792) ERROR: WARNING ! Unknown switch(es) > 192.168.11.1 (pf::SwitchFactory::instantiate) > Jun 17 14:51:22 httpd.portal(13792) INFO: [60:eb:69:56:4e:6e] > re-evaluating access (redir.cgi called) (pf::enforcement::reevaluate_access) > Jun 17 14:51:22 httpd.portal(13792) INFO: Instantiate a new iptables > modification method. pf::ipset (pf::inline::get_technique) > > In this case 192.168.11.1 is the PacketFence gateway, itself. Not sure > why it's calling it an "unknown switch"... > > Thanks, > Joshua Nathan > IT Administrator > Black Forest Academy > +49 (0) 7626-916123 > > > On Tue, Jun 16, 2015 at 12:42 PM, Nathan, Josh <[email protected]> > wrote: > >> Oh, and we're running it as InlineL2 >> >> Thanks, >> Joshua Nathan >> IT Administrator >> Black Forest Academy >> +49 (0) 7626-916123 <%2B49%20%280%29%207626-916123> >> >> >> On Tue, Jun 16, 2015 at 12:41 PM, Nathan, Josh < >> [email protected]> wrote: >> >>> Hello, >>> >>> I'm seeing a strange problem with my PF 5.1 server. It works, except >>> that every few minutes people are reaching the "Sorry" page. Here's the >>> error from the packetfence.log file: >>> >>> Jun 16 12:39:08 httpd.portal(27967) INFO: Matched IP '172.22.159.209' to >>> MAC address 'b0:34:95:f0:d9:b6' using OMAPI (pf::iplog::ip2mac) >>> Jun 16 12:39:09 httpd.portal(27967) WARN: database query failed with: >>> Column 'pid' cannot be null (errno: 1048), will try again >>> (pf::db::db_query_execute) >>> Jun 16 12:39:09 httpd.portal(27967) WARN: database query failed with: >>> Column 'pid' cannot be null (errno: 1048), will try again >>> (pf::db::db_query_execute) >>> Jun 16 12:39:09 httpd.portal(27967) WARN: database query failed with: >>> Column 'pid' cannot be null (errno: 1048), will try again >>> (pf::db::db_query_execute) >>> Jun 16 12:39:09 httpd.portal(27967) ERROR: Database issue: We tried 3 >>> times to serve query person_add_sql called from pf::person::person_add and >>> we failed. Is the database running? (pf::db::db_query_execute) >>> Jun 16 12:39:09 httpd.portal(27967) ERROR: modify of non-existent >>> person attempted - person add failed (pf::person::person_modify) >>> Jun 16 12:39:30 httpd.portal(28041) INFO: Matched IP '172.22.159.209' to >>> MAC address 'b0:34:95:f0:d9:b6' using OMAPI (pf::iplog::ip2mac) >>> Jun 16 12:39:31 httpd.portal(28041) WARN: database query failed with: >>> Column 'pid' cannot be null (errno: 1048), will try again >>> (pf::db::db_query_execute) >>> Jun 16 12:39:31 httpd.portal(28041) WARN: database query failed with: >>> Column 'pid' cannot be null (errno: 1048), will try again >>> (pf::db::db_query_execute) >>> Jun 16 12:39:31 httpd.portal(28041) WARN: database query failed with: >>> Column 'pid' cannot be null (errno: 1048), will try again >>> (pf::db::db_query_execute) >>> Jun 16 12:39:31 httpd.portal(28041) ERROR: Database issue: We tried 3 >>> times to serve query person_add_sql called from pf::person::person_add and >>> we failed. Is the database running? (pf::db::db_query_execute) >>> Jun 16 12:39:31 httpd.portal(28041) ERROR: modify of non-existent >>> person attempted - person add failed (pf::person::person_modify) >>> >>> Normally the person just has to refresh the page, and it will work for >>> a few more minutes before hitting the "Sorry" page again. Any ideas??? >>> >>> Thanks, >>> Joshua Nathan >>> IT Administrator >>> Black Forest Academy >>> +49 (0) 7626-916123 <%2B49%20%280%29%207626-916123> >>> >>> >> > > > ------------------------------------------------------------------------------ > > > > _______________________________________________ > PacketFence-users mailing > [email protected]https://lists.sourceforge.net/lists/listinfo/packetfence-users > > > > -- > Fabrice [email protected] :: +1.514.447.4918 (x135) :: www.inverse.ca > Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence > (http://packetfence.org) > > > > ------------------------------------------------------------------------------ > > _______________________________________________ > PacketFence-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/packetfence-users > >
------------------------------------------------------------------------------
_______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
