Re: [pfSense] Captive Portal Bug in 2.1.1
You could look at the commit below, download the appropriate /etc/inc/captiveportal.inc file, and manually apply it. No need to reinstall firmware for one change to one file. On Feb 24, 2014, at 2:45 PM, Brian Caouette bri...@dlois.com wrote: OK but you said it was fixed for latest snapshot. When should I try again? Anyway of confirming before shutting the network down for the hour it takes to reinstall firmware? On 2/24/2014 5:33 PM, Ermal Luçi wrote: Probably the fix is not in there. Hence the error. On Mon, Feb 24, 2014 at 10:58 PM, Brian Caouette bri...@dlois.com wrote: Installed today's snapshot. No change. Feb 24 16:54:53 logportalauth[55653]: Trying to modify DB returned error: no such column: first Feb 24 16:54:50 logportalauth[55653]: LOGIN: brianc, 9c:04:eb:5b:86:88, 192.168.1.20 Feb 24 16:52:09 logportalauth[55570]: Trying to modify DB returned error: no such column: first Feb 24 16:52:08 logportalauth[55570]: LOGIN: brianc, e0:ca:94:2c:f3:ec, 192.168.1.10 On 2/24/2014 3:41 PM, Ermal Luçi wrote: This is the commit. https://github.com/pfsense/pfsense/commit/846bedf994079102c29cd140b41b2d1deb466a13 Normally 1 or 2 snapshot per day. On Mon, Feb 24, 2014 at 4:45 PM, Brian Caouette bri...@dlois.com wrote: I installed the 2.1.1 on Sunday. How often are the snapshots updated? Is there a change list per snapshot? On 2/24/2014 9:40 AM, Ermal Luçi wrote: On Mon, Feb 24, 2014 at 12:02 AM, Brian Caouette bri...@dlois.com wrote: Last 25 Portal Auth log entries Feb 23 18:00:05 logportalauth[61937]: Trying to modify DB returned error: no such column: first Feb 23 18:00:03 logportalauth[61937]: LOGIN: brianc, e0:ca:94:2c:f3:ec, 192.168.1.10 I suspect this is why the dashboard shows no connected users? Fixed for the latest snapshot. My bad. ___ List mailing list List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list ___ List mailing list List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list ___ List mailing list List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list ___ List mailing list List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list ___ List mailing list List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list -- Ermal ___ List mailing list List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list ___ List mailing list List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list ___ List mailing list List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list
Re: [pfSense] Captive Portal Bug in 2.1.1
On Mon, Feb 24, 2014 at 12:02 AM, Brian Caouette bri...@dlois.com wrote: Last 25 Portal Auth log entries Feb 23 18:00:05 logportalauth[61937]: Trying to modify DB returned error: no such column: first Feb 23 18:00:03 logportalauth[61937]: LOGIN: brianc, e0:ca:94:2c:f3:ec, 192.168.1.10 I suspect this is why the dashboard shows no connected users? Fixed for the latest snapshot. My bad. ___ List mailing list List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list ___ List mailing list List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list
Re: [pfSense] Captive Portal Bug in 2.1.1
I installed the 2.1.1 on Sunday. How often are the snapshots updated? Is there a change list per snapshot? On 2/24/2014 9:40 AM, Ermal Luçi wrote: On Mon, Feb 24, 2014 at 12:02 AM, Brian Caouette bri...@dlois.com mailto:bri...@dlois.com wrote: Last 25 Portal Auth log entries Feb 23 18:00:05 logportalauth[61937]: Trying to modify DB returned error: no such column: first Feb 23 18:00:03 logportalauth[61937]: LOGIN: brianc, e0:ca:94:2c:f3:ec, 192.168.1.10 I suspect this is why the dashboard shows no connected users? Fixed for the latest snapshot. My bad. ___ List mailing list List@lists.pfsense.org mailto:List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list ___ List mailing list List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list ___ List mailing list List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list
Re: [pfSense] Captive Portal Bug in 2.1.1
This is the commit. https://github.com/pfsense/pfsense/commit/846bedf994079102c29cd140b41b2d1deb466a13 Normally 1 or 2 snapshot per day. On Mon, Feb 24, 2014 at 4:45 PM, Brian Caouette bri...@dlois.com wrote: I installed the 2.1.1 on Sunday. How often are the snapshots updated? Is there a change list per snapshot? On 2/24/2014 9:40 AM, Ermal Luçi wrote: On Mon, Feb 24, 2014 at 12:02 AM, Brian Caouette bri...@dlois.com wrote: Last 25 Portal Auth log entries Feb 23 18:00:05 logportalauth[61937]: Trying to modify DB returned error: no such column: first Feb 23 18:00:03 logportalauth[61937]: LOGIN: brianc, e0:ca:94:2c:f3:ec, 192.168.1.10 I suspect this is why the dashboard shows no connected users? Fixed for the latest snapshot. My bad. ___ List mailing list List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list ___ List mailing listList@lists.pfsense.orghttp://lists.pfsense.org/mailman/listinfo/list ___ List mailing list List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list ___ List mailing list List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list
Re: [pfSense] Captive Portal Bug in 2.1.1
Installed today's snapshot. No change. Feb 24 16:54:53 logportalauth[55653]: Trying to modify DB returned error: no such column: first Feb 24 16:54:50 logportalauth[55653]: LOGIN: brianc, 9c:04:eb:5b:86:88, 192.168.1.20 Feb 24 16:52:09 logportalauth[55570]: Trying to modify DB returned error: no such column: first Feb 24 16:52:08 logportalauth[55570]: LOGIN: brianc, e0:ca:94:2c:f3:ec, 192.168.1.10 On 2/24/2014 3:41 PM, Ermal Luçi wrote: This is the commit. https://github.com/pfsense/pfsense/commit/846bedf994079102c29cd140b41b2d1deb466a13 Normally 1 or 2 snapshot per day. On Mon, Feb 24, 2014 at 4:45 PM, Brian Caouette bri...@dlois.com mailto:bri...@dlois.com wrote: I installed the 2.1.1 on Sunday. How often are the snapshots updated? Is there a change list per snapshot? On 2/24/2014 9:40 AM, Ermal Luçi wrote: On Mon, Feb 24, 2014 at 12:02 AM, Brian Caouette bri...@dlois.com mailto:bri...@dlois.com wrote: Last 25 Portal Auth log entries Feb 23 18:00:05 logportalauth[61937]: Trying to modify DB returned error: no such column: first Feb 23 18:00:03 logportalauth[61937]: LOGIN: brianc, e0:ca:94:2c:f3:ec, 192.168.1.10 I suspect this is why the dashboard shows no connected users? Fixed for the latest snapshot. My bad. ___ List mailing list List@lists.pfsense.org mailto:List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list ___ List mailing list List@lists.pfsense.org mailto:List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list ___ List mailing list List@lists.pfsense.org mailto:List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list ___ List mailing list List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list ___ List mailing list List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list
Re: [pfSense] Captive Portal Bug in 2.1.1
Probably the fix is not in there. Hence the error. On Mon, Feb 24, 2014 at 10:58 PM, Brian Caouette bri...@dlois.com wrote: Installed today's snapshot. No change. Feb 24 16:54:53 logportalauth[55653]: Trying to modify DB returned error: no such column: first Feb 24 16:54:50 logportalauth[55653]: LOGIN: brianc, 9c:04:eb:5b:86:88, 192.168.1.20 Feb 24 16:52:09 logportalauth[55570]: Trying to modify DB returned error: no such column: first Feb 24 16:52:08 logportalauth[55570]: LOGIN: brianc, e0:ca:94:2c:f3:ec, 192.168.1.10 On 2/24/2014 3:41 PM, Ermal Luçi wrote: This is the commit. https://github.com/pfsense/pfsense/commit/846bedf994079102c29cd140b41b2d1deb466a13 Normally 1 or 2 snapshot per day. On Mon, Feb 24, 2014 at 4:45 PM, Brian Caouette bri...@dlois.com wrote: I installed the 2.1.1 on Sunday. How often are the snapshots updated? Is there a change list per snapshot? On 2/24/2014 9:40 AM, Ermal Luçi wrote: On Mon, Feb 24, 2014 at 12:02 AM, Brian Caouette bri...@dlois.comwrote: Last 25 Portal Auth log entries Feb 23 18:00:05 logportalauth[61937]: Trying to modify DB returned error: no such column: first Feb 23 18:00:03 logportalauth[61937]: LOGIN: brianc, e0:ca:94:2c:f3:ec, 192.168.1.10 I suspect this is why the dashboard shows no connected users? Fixed for the latest snapshot. My bad. ___ List mailing list List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list ___ List mailing listList@lists.pfsense.orghttp://lists.pfsense.org/mailman/listinfo/list ___ List mailing list List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list ___ List mailing listList@lists.pfsense.orghttp://lists.pfsense.org/mailman/listinfo/list ___ List mailing list List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list -- Ermal ___ List mailing list List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list
Re: [pfSense] Captive Portal Bug in 2.1.1
OK but you said it was fixed for latest snapshot. When should I try again? Anyway of confirming before shutting the network down for the hour it takes to reinstall firmware? On 2/24/2014 5:33 PM, Ermal Luçi wrote: Probably the fix is not in there. Hence the error. On Mon, Feb 24, 2014 at 10:58 PM, Brian Caouette bri...@dlois.com mailto:bri...@dlois.com wrote: Installed today's snapshot. No change. Feb 24 16:54:53 logportalauth[55653]: Trying to modify DB returned error: no such column: first Feb 24 16:54:50 logportalauth[55653]: LOGIN: brianc, 9c:04:eb:5b:86:88, 192.168.1.20 Feb 24 16:52:09 logportalauth[55570]: Trying to modify DB returned error: no such column: first Feb 24 16:52:08 logportalauth[55570]: LOGIN: brianc, e0:ca:94:2c:f3:ec, 192.168.1.10 On 2/24/2014 3:41 PM, Ermal Luçi wrote: This is the commit. https://github.com/pfsense/pfsense/commit/846bedf994079102c29cd140b41b2d1deb466a13 Normally 1 or 2 snapshot per day. On Mon, Feb 24, 2014 at 4:45 PM, Brian Caouette bri...@dlois.com mailto:bri...@dlois.com wrote: I installed the 2.1.1 on Sunday. How often are the snapshots updated? Is there a change list per snapshot? On 2/24/2014 9:40 AM, Ermal Luçi wrote: On Mon, Feb 24, 2014 at 12:02 AM, Brian Caouette bri...@dlois.com mailto:bri...@dlois.com wrote: Last 25 Portal Auth log entries Feb 23 18:00:05 logportalauth[61937]: Trying to modify DB returned error: no such column: first Feb 23 18:00:03 logportalauth[61937]: LOGIN: brianc, e0:ca:94:2c:f3:ec, 192.168.1.10 I suspect this is why the dashboard shows no connected users? Fixed for the latest snapshot. My bad. ___ List mailing list List@lists.pfsense.org mailto:List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list ___ List mailing list List@lists.pfsense.org mailto:List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list ___ List mailing list List@lists.pfsense.org mailto:List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list ___ List mailing list List@lists.pfsense.org mailto:List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list ___ List mailing list List@lists.pfsense.org mailto:List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list -- Ermal ___ List mailing list List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list ___ List mailing list List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list
[pfSense] Captive Portal Bug in 2.1.1
Last 25 Portal Auth log entries Feb 23 18:00:05 logportalauth[61937]: Trying to modify DB returned error: no such column: first Feb 23 18:00:03 logportalauth[61937]: LOGIN: brianc, e0:ca:94:2c:f3:ec, 192.168.1.10 I suspect this is why the dashboard shows no connected users? ___ List mailing list List@lists.pfsense.org http://lists.pfsense.org/mailman/listinfo/list