Help: Collecting Client Data (using freeradius + myslq)

Hello,

I am currently using freeradius + mysql to autenticate users. I can use it to check users information like username, password, mac address, etc and it works great, but i can’t use that to collect information from the user.

What i would like to do is to have a free access where the user would enter data, such as email, age, genter or whatever, and I would store that information in the database with an incremental username (ie. user1 user2 user3 and so on).

So in short: how can i write user imput in the database ?

Thanks in advace.

It sounds like you need a hotspot backend. The User Manager is made for this, there are a multitude of others out there (I have one available). If you want just a frontend to your current setup, you need to find a programmer who understands how to build the web application you need.

Is there a way i can use my current setup (Mikrotik + Freeradius + Mysql) to store user imput?

For example, and one text box for email on the logging page, and save it as another user atribute in the mysql database.

Just as radius stores the stadistics there must be a simple way to store user generated data.

Thanks for your reply.

Yes, it is possible. It is a fairly simple web program that needs to be written. I am assuming you are using the hotspot functionality in MT. If so, it is a fairly trivial thing to build, but it is not a MT question. Also, it will require a programmer to build this for you. I am sure there are some programmers on these forums, but not sure who, or how much they would charge for such a thing. I could put one together in 4-5 hours, but a programmer may be able to do it much quicker.

SO, it’s not a matter of whether it is possible or not (it certainly IS possible), rather, it is a question of whether this is the place to look for assistance. FWIW, my last ISP, I built a system very similar to what you are after. It took me a LONG time to do, since I am not really a programmer.

This is not a big project, so i was rather looking for the “do it yourself” solution. The problem is, i don´t know where to start…
Could you, or anyone else, give me some directions or point me to the correct place to ask for assistance ?

Thanks

Hi Landuchi, try Google and search Dialupadmin, it is simple and great.
Ciao
Alessandro