> * I have populated the tables with the following commands ( No other
> commands !!)
> insert into radcheck values ('','fablab','Password','LetMeIn');
I encrypt passwords with ENCRYPT(). I never tried to use plaintext passwords
with mysql.
> insert into usergroup values ('','fablab','PPP');
> insert into radgroupcheck values ('','PPP','Service-Type','Framed-User');
> insert into radgroupcheck values ('','PPP','Framed-Protocol','PPP');
>
> insert into radgroupreply values
> ('','PPP','Framed-IP-Address','255.255.255.254');
Use
insert into radgroupreply values
('','PPP','Framed-IP-Address','192.168.1.1+');
instead.
> insert into radgroupreply values ('','PPP','Framed-MTU','576');
> insert into radgroupreply values ('','PPP','Service-Type','Framed-User');
> insert into radgroupreply values ('','PPP','Framed-Protocol','PPP');
> insert into radgroupreply values
> ('','PPP','Framed-Compression','Van-Jacobson-TCP-IP');
>
>
> But a radtest fails to authenticate!!!
>
> Question 1:
> ------------
> If I want to use MySQL do I have to put data in the TABLE nas / TABLE
> dictionary
> or is it enough to have a working clients.conf ??
No, you need to populate dictionary database. There is a script for this
purpose in the distribution.
>
> Question 2:
> -----------
> I don't understand why i get this "rlm_sql: Pairs do not match [fablab] "
> what pairs are not matching ??
> Am I missing something in my insert list ? Or is it in my radiusd.conf ??
Maybe this is due to password encryption.
> Can someone provide me a list of complete working INSERT statement to make
a
> dummy test work ?
>
> 2) IP+NAS-PORT // IP Pool Allocation question .
>
> I have read in the newsgroup that it is the NAS that SHOULD be allocating
> the IP ... and I could not agree more. Bad luck: the NAS is not mine
> and the owner refuses to allocate the IP.
>
> I have tested , and it is working in -0.3 , that in the users file
> if you provide
> Framed-IP-Address = x.x.x.x+,
> the IP will be allocated with the formula Base+NAS-Port
>
> Question 1:
> ------------
> [Once you guys will have helped me to get the MySQL config to work,]
> can I count on the same IP-Allocation feature to work with MySql ??
>
> Question 2:
> ------------
> let's say that my base IP is 192.168.1.1.
> what if I have more that 253 simultanious users / Nas-Port available ?
> will the users who get NAS-PORT 254 and 255 be allocated
> IP 192.168.1.255 and 192.168.2.0 ??????? is FreeRadius taking cae of this
> problems ?
> any known workaround ? or Can I use more than one pool? to go around those
> "bad" IPs ?
No, as far as I know Freeradius is able to allocate only continous range of
IP addresses. 192.168.1.255 and 192.168.2.0 are not a "bad" ip addresses.
They are bad only if you use /24 network. Use /23 network mask instead and
those IPs will be OK.
Andrew
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
