I am currently running PF 4.3 with a CISCO wirless controller 2500 series version 8.0.100.0.
I have the system setup to use an unsecure network for registration and use an ACL to control network access. We use the PF captive portal to redirect users and register them on the network. Once my users have registered they are continually directed to the captive portal and although they are registered and have proper access receive the messages “Your network should be enabled ….”. I see that the user is logged in assigned the role default and the correct VLAN When I look at the packet fence log I see Aug 25 15:19:49 httpd.webservices(1831) WARN: database query failed with: Column 'switch' cannot be null (errno: 1048), will try again (pf::db::db_query_execute) Aug 25 15:19:49 httpd.webservices(1831) WARN: database query failed with: Column 'switch' cannot be null (errno: 1048), will try again (pf::db::db_query_execute) Aug 25 15:19:49 httpd.webservices(1831) WARN: database query failed with: Column 'switch' cannot be null (errno: 1048), will try again (pf::db::db_query_execute) Aug 25 15:19:49 httpd.webservices(1831) ERROR: Database issue: We tried 3 times to serve query locationlog_insert_closed_sql called from pf::locationlog::locationlog_insert_closed and we failed. Is the database running? (pf::db::db_query_execute) Aug 25 15:20:17 httpd.webservices(1831) WARN: unable to convert connection_type to string. called from pf::api pf::locationlog::locationlog_insert_closed (pf::util::connection_type_to_str) Aug 25 15:20:17 httpd.webservices(1831) INFO: Asked to insert a locationlog entry with connection type unknown. (pf::locationlog::locationlog_insert_closed) Aug 25 15:20:17 httpd.webservices(1831) WARN: database query failed with: Column 'switch' cannot be null (errno: 1048), will try again (pf::db::db_query_execute) Aug 25 15:20:17 httpd.webservices(1831) WARN: database query failed with: Column 'switch' cannot be null (errno: 1048), will try again (pf::db::db_query_execute) Aug 25 15:20:17 httpd.webservices(1831) WARN: database query failed with: Column 'switch' cannot be null (errno: 1048), will try again (pf::db::db_query_execute) Aug 25 15:20:17 httpd.webservices(1831) ERROR: Database issue: We tried 3 times to serve query locationlog_insert_closed_sql called from pf::locationlog::locationlog_insert_closed and we failed. Is the database running? (pf::db::db_query_execute) I have setup the controller as per example Chapter 5 Wireless LAN Controller (WLC) Web Auth Any help would be greatly appreicated ------------------------------------------------------------------------------ Slashdot TV. Video for Nerds. Stuff that matters. http://tv.slashdot.org/ _______________________________________________ PacketFence-users mailing list PacketFence-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/packetfence-users
