Static Assigned IP address to PPPoE User HELP!!!

RouterOS General
1

Has anyone got a clue as to assigning a specific ip address to a user
based on their USER name?

Or some other sort of way.

Im using a MySQL database for users and their Radius Attributes
and i think im seposed to use a command to assign them an IP but not
sure on what it is

I would like to be able to provide a static ip if a user wants one
Can anyone help?

Thanks

2

Set Radius reply attribute “Framed-IP-Address” to static IP address you want.

3

Like what? this!

Framed-IP-Address = 192168.0.10

I’ve tried this and every time i enter this and dial the user in from PPPoE
no simple queue is made and the user is defaulted to the default PPPoE settings
on the mikrotik rather then using the attributes.

Strange i don’t know why it’s doing this

4

‘/ppp secret’ configuration is taken before radius. So remove that user from this submenu and try it.

Edgars

5

I don’t have a user in the ppp secret area, i’m using radius through a MySQL databe for authentication.

And it seems that only when there is a mistake in the attributes or they are not taken properly that the user will still be logged in but the attributes will be ignored.

6

doesn’t your RADIUS have a debug mode (like freeradius -X option) were you can watch the protocol data flow?
if not a sniffer between the RADIUS and the NAS might help.

7

I figured it out

I’m using an HTML, PHP script page to create packages that create the
rate-limit and so on and also alows the admin to add in a texarea field extra
custom radius attributes.

My script was creating the rate-limit first e.g.

Rate-Limit = 192k/64k 1024k/100k 10/5 15/10

and if you wanted custom stuff you would enter it into another textarea field it would then gather all attributes and combine them to gether e.g.

Rate-Limit = 192k/64k 1024k/100k 10/5 15/10
framed-ip-address=172.168.0.6

my mystake was i did not enter a ( ; ) at the end of the first line
like this
Rate-Limit = 192k/64k 1024k/100k 10/5 15/10;
framed-ip-address=172.168.0.6

should i enter them at the end of every line?
like this
Rate-Limit = 192k/64k 1024k/100k 10/5 15/10;
framed-ip-address=172.168.0.6;

Cause i sometimes get errors when trying to connect by PPPoE stating
that the user name was wrong or just a basic error and you have to click connect again until it finaly connects.

We came to the conclusion that these errors where comming from
remed out lines like comments e.g.
#bla bla date or something
then the attributes

When we removed these comments the error came around alot less
but would still show up during connect every now and then

Now i’m thinking that the last few random errors might be comming from the semicolon not being there.

Correct me if i’m wrong, i would like to be 100% sure on this so that i know that i will have a rock solid scipt and i will never get the error again

Thanks

8

hello,
i am not sure, but in RADIUS user-files there must be a “,” after each line except the first one. and i tried not to use comments within the user profile.

but i have not runing a sql backend yet, so it might differ.

9

Well it now works with a semicolon on each line but it might also work with comma after each line also, i have not tried it yet.

But i do know that is i put nothing after the first line it does not work and it did at one time crash the radius server.

So i will try the comma after each line but i would like to know the proper syntax to make sure it is safe and sound.

Thanks