"Cris Boisvert" <cris@usai.net> wrote:

I would like to have 2 databases with the accounting in one and the auth in the other?

Is this possible?

Yes. You need two instances of the SQL module. See the docs. Alan DeKok.

"Cris Boisvert" <cris@usai.net> wrote:

So I just need to have another instance of the sql module and only one of them will have the accounting option enabled and the other will have only the auth portion enabled?

All you have to do is list one in "accounting", and the other in "authorize". What you configured in sql.conf is less relevant than telling radiusd.conf to use one for authorize, and the other for accounting. Alan DeKok.

where and how do i do it and what do i write??? jeremy -----Original Message----- From: "Duane Cox" <duanec@mail.illicom.net> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Date: Tue, 16 May 2006 18:17:26 -0500 Subject: Re: getting Freeradius to recorde login failure, etc yes, there is a subsection under the post_auth section for such a thing... ----- Original Message ----- From: Jeremy ohara To: FreeRadius users mailing list Sent: Tuesday, May 16, 2006 3:24 PM Subject: getting Freeradius to recorde login failure, etc hi there is there a way to get Freeradius 1.0.5 with Mysql to record login-failure, incorrect password or incorrect username into the mysql table? i can see its possbile. but when you login with wrong details it doesnt get to record the login failure, etc. and i dont knwo what code to use and how to make freeradius to record it Jeremy ---------------------------------------------------------------------------- This email has been scanned for Virus by MDaemon AntiVirus part of MDaemon. Updated daily to keep up-to-date with all new and old viruses. ---------------------------------------------------------------------------- - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html ---------------------------------------------------------------------------- This email has been scanned for Virus by MDaemon AntiVirus part of MDaemon. Updated daily to keep up-to-date with all new and old viruses. ----------------------------------------------------------------------------

Hi there i dont want to sound rude, etc but your not really answering my question. you only answered half of it what do i wite for the sql statement, etc Jeremy -----Original Message----- From: "Duane Cox" <duanec@mail.illicom.net> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Date: Tue, 16 May 2006 22:28:12 -0500 Subject: Re: getting Freeradius to recorde login failure, etc post-auth { # # If you want to have a log of authentication replies, # un-comment the following line, and the 'detail reply_log' # section, above. # reply_log sql Post-Auth-Type REJECT { sql } } ----- Original Message ----- From: Jeremy ohara To: FreeRadius users mailing list Sent: Tuesday, May 16, 2006 9:13 PM Subject: Re: getting Freeradius to recorde login failure, etc where and how do i do it and what do i write??? jeremy -----Original Message----- From: "Duane Cox" <duanec@mail.illicom.net> To: "FreeRadius users mailing list" <freeradius-users@lists.freeradius.org> Date: Tue, 16 May 2006 18:17:26 -0500 Subject: Re: getting Freeradius to recorde login failure, etc yes, there is a subsection under the post_auth section for such a thing... ----- Original Message ----- From: Jeremy ohara To: FreeRadius users mailing list Sent: Tuesday, May 16, 2006 3:24 PM Subject: getting Freeradius to recorde login failure, etc hi there is there a way to get Freeradius 1.0.5 with Mysql to record login-failure, incorrect password or incorrect username into the mysql table? i can see its possbile. but when you login with wrong details it doesnt get to record the login failure, etc. and i dont knwo what code to use and how to make freeradius to record it Jeremy ---------------------------------------------------------------------------- This email has been scanned for Virus by MDaemon AntiVirus part of MDaemon. Updated daily to keep up-to-date with all new and old viruses. ---------------------------------------------------------------------------- - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html ---------------------------------------------------------------------------- This email has been scanned for Virus by MDaemon AntiVirus part of MDaemon. Updated daily to keep up-to-date with all new and old viruses. ---------------------------------------------------------------------------- - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html ---------------------------------------------------------------------------- This email has been scanned for Virus by MDaemon AntiVirus part of MDaemon. Updated daily to keep up-to-date with all new and old viruses. ----------------------------------------------------------------------------

the version of freeradius doesnt not have the rim_sql files Freeradius 1.0.5 -----Original Message----- From: Nicolas Baradakis <nbk@sitadelle.com> To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Date: Wed, 17 May 2006 16:44:55 +0200 Subject: Re: getting Freeradius to recorde login failure, etc Jeremy ohara wrote:

is there a way to get Freeradius 1.0.5 with Mysql to record login-failure, incorrect password or incorrect username into the mysql table?

Please read the FAQ, and look for: "How do I log failed login attempts in a SQL database?" http://wiki.freeradius.org/index.php/FreeRADIUS_Wiki:FAQ -- Nicolas Baradakis - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html ---------------------------------------------------------------------------- This email has been scanned for Virus by MDaemon AntiVirus part of MDaemon. Updated daily to keep up-to-date with all new and old viruses. ----------------------------------------------------------------------------

it seems to be ok now. just having trouble getting Acct-Terminate-Cause to work its no showing any result when login or pass , etc is wrong jeremy -----Original Message----- From: Christopher Carver <ccarver@pennswoods.net> To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Date: Wed, 17 May 2006 12:12:33 -0500 Subject: Re: getting Freeradius to recorde login failure, etc Jeremy, You need to make sure mysql (and mysql development headers/libraries) installed on the server and then configure --with-mysql. When you compile you should see the rlm_sql files in the lib dir of freeradius. Watch the configure output and make sure it says that its configuring mysql and not skipping it because it couldn't find the headers or libs. Chris Carver Pennswoods.Net Network Engineer Jeremy ohara wrote:

the version of freeradius doesnt not have the rim_sql files

Freeradius 1.0.5

-----Original Message----- From: Nicolas Baradakis <nbk@sitadelle.com> To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Date: Wed, 17 May 2006 16:44:55 +0200 Subject: Re: getting Freeradius to recorde login failure, etc

Jeremy ohara wrote:

> is there a way to get Freeradius 1.0.5 with Mysql to record login-failure, > incorrect password or incorrect username into the mysql table?

Please read the FAQ, and look for: "How do I log failed login attempts in a SQL database?"

http://wiki.freeradius.org/index.php/FreeRADIUS_Wiki:FAQ

-- Nicolas Baradakis

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

----------------------------------------------------------------------------

This email has been scanned for Virus by MDaemon AntiVirus part of MDaemon. Updated daily to keep up-to-date with all new and old viruses.

----------------------------------------------------------------------------

------------------------------------------------------------------------

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html ---------------------------------------------------------------------------- This email has been scanned for Virus by MDaemon AntiVirus part of MDaemon. Updated daily to keep up-to-date with all new and old viruses. ----------------------------------------------------------------------------

the whole thing is arleady in the sql.conf. all it logs is the accepted passwords not failed passwords Jeremy -----Original Message----- From: Nicolas Baradakis <nbk@sitadelle.com> To: FreeRadius users mailing list <freeradius-users@lists.freeradius.org> Date: Wed, 17 May 2006 16:44:55 +0200 Subject: Re: getting Freeradius to recorde login failure, etc Jeremy ohara wrote:

is there a way to get Freeradius 1.0.5 with Mysql to record login-failure, incorrect password or incorrect username into the mysql table?

Please read the FAQ, and look for: "How do I log failed login attempts in a SQL database?" http://wiki.freeradius.org/index.php/FreeRADIUS_Wiki:FAQ -- Nicolas Baradakis - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html ---------------------------------------------------------------------------- This email has been scanned for Virus by MDaemon AntiVirus part of MDaemon. Updated daily to keep up-to-date with all new and old viruses. ----------------------------------------------------------------------------