SQL auth against existing database

[Charles Sprickman]

Hi,

I’m looking through the SQL docs on the wiki, and they seem very complete, but I’m not quite grasping how to accomplish what I want.

In short, I have an existing database that’s primarily used for our email system.  I currently also have gnu-radius using this db - in the past for dialup, but at this point just a few remaining oddball services like usenet.  I’m moving away from gnu-radius because it’s not very actively developed.

What I’d like to do is this:

- Use existing db for user/pass check
- Use static files for everything else
- Optionally alter my sql query based on which client is asking for auth

Is this possible?

Right now I don’t need to really return anything other than Access-Accept or Access-Reject - literally any other reply items are ignored.

I’m on a fresh install of FreeRadius 3.0.15.

Database schema is very simple, columns are:

pw_name, pw_domain, pw_passwd, pw_gid (vpopmail, for the curious)

It’s not practical to change the schema at this point…

Thanks,

Charles