Just yesterday I sent another example of how to configure for sql, and gave some sample
data.
Look for postgres, in the archives.
The same data works with MySQL and the only config change is to include sql.conf
instead of postgresql.conf.
On the 20th I collected the most current version from CVS then built and installed it.
Yesterday I spent 10 minutes, and configured the new radiusd.conf and postgresql .conf for PostgreSQL and tested it with encrypted and clear text passwords. I then changed the include from postgresql.conf to sql.conf and configured sql.conf.
Here is some sample data for MySQL {password for troll is skunk}.
delete from usergroup ;
insert into usergroup (username,groupname) values('fredf','ppp-unlimited');
insert into usergroup (username,groupname) values('barneyr','ppp-static');
insert into usergroup (username,groupname) values('troll','ppp-unlimited');
insert into usergroup (username,groupname) values('frog','nas-prompt');delete from radcheck ;
insert into radcheck (username,attribute,op,value)
values('fredf','User-Password','==','wilma');
insert into radcheck (username,attribute,op,value)
values('barneyr','User-Password','==','betty');
insert into radcheck (username,attribute,op,value)
values('troll','Crypt-Password','==','$1$A8BotTi4$UTg2XL.fSStI2RFENUfnR.');
insert into radcheck (username,attribute,op,value)
values('frog','User-Password','==','kermit');delete from radreply ;
insert into radreply (username,attribute,op,value)
values('barneyr','Framed-IP-Address',':=','10.19.65.38');
insert into radreply (username,attribute,op,value)
values('barneyr','Framed-IP-Netmask',':=','255.255.255.252');delete from radgroupreply ;
insert into radgroupreply (groupname,attribute,op,value)
values('ppp-unlimited','Framed-Compression',':=','Van-Jacobsen-TCP-IP');
insert into radgroupreply (groupname,attribute,op,value)
values('ppp-unlimited','Framed-Protocol',':=','PPP');
insert into radgroupreply (groupname,attribute,op,value)
values('ppp-unlimited','Service-Type',':=','Framed-User');
insert into radgroupreply (groupname,attribute,op,value)
values('ppp-unlimited','Framed-MTU',':=','1500');
insert into radgroupreply (groupname,attribute,op,value)
values('ppp-static','Framed-Compression',':=','Van-Jacobsen-TCP-IP');
insert into radgroupreply (groupname,attribute,op,value)
values('ppp-static','Framed-Protocol',':=','PPP');
insert into radgroupreply (groupname,attribute,op,value)
values('ppp-static','Service-Type',':=','Framed-User');
insert into radgroupreply (groupname,attribute,op,value)
values('ppp-static','Framed-MTU',':=','1500');
insert into radgroupreply (groupname,attribute,op,value)
values('nas-prompt','Framed-MTU',':=','1500');
insert into radgroupreply (groupname,attribute,op,value)
values('nas-prompt','Framed-Compression',':=','Van-Jacobson-TCP-IP');
insert into radgroupreply (groupname,attribute,op,value)
values('nas-prompt','Service-Type',':=','NAS-Prompt');NOTE: There is nothing in radgroupcheck .
Bob Ross wrote:
Believe me when I tell you I do understand what your saying. The problem was that I was tossed in to this after all our fee's were paid to the wholesale dialup provider when he told us they do PAP, and on the day we were ready to start it didn't work. So I was between the rocks and a hard place and was recommended to use mySQL and freeradius, both that I have never used or looked at before a week ago.
It has been authenticating fine so far, no problems noticeable, but I still have to leave the two auth-type in the uesrs file or it quits. It works now and I think I'll leave it and hope it doesn't break.
Thanks for all your help.
Bob Ross
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
