If you've got some code working for postgre, I'm sure I could port that to work for mysql. I'm willing to do the work, I just don't know where to get the differentiating information from freeradius so I know what ISP that user belongs to. Something based on Called-Station-ID like the users and acct_users file (DEFAULT Called-Station-Id == "1234567890", Proxy-To-Realm := "ISP1") would be useful.
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:freeradius- > [EMAIL PROTECTED] On Behalf Of Guy Fraser > Sent: Wednesday, July 21, 2004 1:27 PM > To: [EMAIL PROTECTED] > Subject: Re: Is there a ChangeLog > > There was a program written to work with "Squid" that sent the logs to a > database. It used a "FIFO" for the log file, so squid would write to the > FIFO and The program would read from the FIFO. The program would decipher > the logs and insert the relevant data into a table. > > I believe the program was written in Perl and was called "squid2mysql" or > something like that. > > I think I may have "ported" it to PostgreSQL, I will see if I have it > archived > somewhere. > > I have considered making a rlm_log module but have not had time to delve > into > it yet. Once such a module exists having the data exported to a DB and > file for > redundancy, should not be too difficult. > > For now I will try to find the pipe based stuff, and see what I can do > with it. > > > Anson Rinesmith wrote: > > > > > > >>-----Original Message----- > >>From: [EMAIL PROTECTED] [mailto:freeradius- > >>[EMAIL PROTECTED] On Behalf Of Alan DeKok > >>Sent: Wednesday, July 21, 2004 9:06 AM > >>To: [EMAIL PROTECTED] > >>Subject: Re: Is there a ChangeLog > >> > >>"Anson Rinesmith" <[EMAIL PROTECTED]> wrote: > >> > >> > >>>I would like to find out what new features have been added since my > >>>version of FreeRADIUS. I looked but this was the best I found: "It > >>>is a significant leap in functionality over 0.9.3, and contains too > >>>many bug fixes and feature enhancements to list in detail." > >>> > >>> > >> Have you tried doc/ChangeLog? > >> > >> > >> > >>>I'm looking specifically for what has changed in error > >>>reporting. Any new messages, can it be put to a DB, can it be > >>>separated by realm, etc. > >>> > >>> > >> I'm not sure what you mean by that. > >> > >> > >> > > > >Can the /var/log/radiusd.log file be sent to a database instead? I have > >written my own user interface and it would be much simpler if I could > show > >my clients their error logs by querying a table, rather than parsing a > file. > > > > > > > >> Alan DeKok. > >> > >>- > >>List info/subscribe/unsubscribe? See > >>http://www.freeradius.org/list/users.html > >> > >> > > > > > >- > >List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > > > >. > > > > > > > > -- > Guy Fraser > Network Administrator > The Internet Centre > 780-450-6787 , 1-888-450-6787 > > There is a fine line between genius and lunacy, fear not, walk the > line with pride. Not all things will end up as you wanted, but you > will certainly discover things the meek and timid will miss out on. > > > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
