https://redmine.pfsense.org/https://redmine.pfsense.org/favicon.ico?16780521162016-11-13T23:13:50ZpfSense bugtrackerpfSense Packages - Bug #6928: freeRADIUS, logging with "Access-Reject" not work in mysql table radpostauthhttps://redmine.pfsense.org/issues/6928?journal_id=294182016-11-13T23:13:50ZKonstantin Ab
<ul></ul><p>for change it - needed uncomment this:<br />/usr/local/etc/raddb/sites-enabled/default<br />section post-auth<br />variable sql</p>
<p><code> Post-Auth-Type REJECT {</code><br /> <code># log failed authentications in SQL, too.</code><br /> <code>sql</code></p> pfSense Packages - Bug #6928: freeRADIUS, logging with "Access-Reject" not work in mysql table radpostauthhttps://redmine.pfsense.org/issues/6928?journal_id=309572017-01-28T17:47:21ZKill Bill
<ul></ul><p>Does uncommenting this break things if SQL is <strong>disabled</strong>? The whole thing is a damn complex heap of code, not really keen to touch it beyond uncommenting the line.</p> pfSense Packages - Bug #6928: freeRADIUS, logging with "Access-Reject" not work in mysql table radpostauthhttps://redmine.pfsense.org/issues/6928?journal_id=309602017-01-29T00:15:16ZKonstantin Ab
<ul></ul><p>i tryed diable SQL. No problem. <br /> I'm watching the security problems in this table.</p> pfSense Packages - Bug #6928: freeRADIUS, logging with "Access-Reject" not work in mysql table radpostauthhttps://redmine.pfsense.org/issues/6928?journal_id=309612017-01-29T03:46:40ZKill Bill
<ul></ul><p>Can you please test this patch? <a class="external" href="https://github.com/pfsense/FreeBSD-ports/commit/cdf9b05e966f311b8ae83c7a3158479bd5c9e7bf.patch">https://github.com/pfsense/FreeBSD-ports/commit/cdf9b05e966f311b8ae83c7a3158479bd5c9e7bf.patch</a></p>
<p>- Apply via System Patches (Path Strip Count = 4) or manually<br />- Check "Enable SQL Post-Auth" in Package / FreeRADIUS / SQL, <strong>click Save</strong> and see if it works. The line should be uncommented and info logged.<br />- Uncheck "Enable SQL Post-Auth" in Package / FreeRADIUS / SQL, <strong>click Save</strong> and check again - the line should be commented and the info not logged any more.</p>
<p>Thanks.</p> pfSense Packages - Bug #6928: freeRADIUS, logging with "Access-Reject" not work in mysql table radpostauthhttps://redmine.pfsense.org/issues/6928?journal_id=309732017-01-29T21:27:38ZKonstantin Ab
<ul></ul><p>Hmmm, it seems to work!<br />records appear in Table</p> pfSense Packages - Bug #6928: freeRADIUS, logging with "Access-Reject" not work in mysql table radpostauthhttps://redmine.pfsense.org/issues/6928?journal_id=309902017-01-30T08:37:17ZKill Bill
<ul></ul><p>Konstantin Ab wrote:</p>
<blockquote>
<p>Hmmm, it seems to work!<br />records appear in Table</p>
</blockquote>
<p>Thanks for testing. Added to this monster commit: <a class="external" href="https://github.com/pfsense/FreeBSD-ports/pull/272">https://github.com/pfsense/FreeBSD-ports/pull/272</a></p> pfSense Packages - Bug #6928: freeRADIUS, logging with "Access-Reject" not work in mysql table radpostauthhttps://redmine.pfsense.org/issues/6928?journal_id=310132017-01-31T11:08:13ZRenato Botelhorenato@netgate.com
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Feedback</i></li><li><strong>Assignee</strong> set to <i>Renato Botelho</i></li><li><strong>Target version</strong> set to <i>2.4.0</i></li><li><strong>% Done</strong> changed from <i>0</i> to <i>100</i></li></ul> pfSense Packages - Bug #6928: freeRADIUS, logging with "Access-Reject" not work in mysql table radpostauthhttps://redmine.pfsense.org/issues/6928?journal_id=315252017-02-14T14:38:14ZKill Bill
<ul></ul><p>Merged and working, can be closed.</p> pfSense Packages - Bug #6928: freeRADIUS, logging with "Access-Reject" not work in mysql table radpostauthhttps://redmine.pfsense.org/issues/6928?journal_id=315272017-02-14T14:44:27ZRenato Botelhorenato@netgate.com
<ul><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Resolved</i></li></ul>