General Questions

hi all of you,

i'am in process of finishing a windows program to manage user access / vouchers

user access will be managed via a freeradius server, vouchers are included in the  software ( reading it like a dos file)

the software knows
how to managed vouchers and print them on windows printer( format A4) , serial ticket printer managed by windows, serial ticket printers  managed by my own socket printer tool, so managing remote serial printers ( epson tmt88/cbm1000) is easy.

the software managed the full historical of the connections ( by user / by ip/ by mac address) i use a syslog linux server to log all the actions via the firewall ( all is logged), a cron makes the gzip file, then the windows software access via ftp to get the file / unzip / treat the archive

i added a freeradius server using mysql to managed users on the syslog server  , i do not have found "a dictionnary " to use with freeradius+mysql with monowall

i would like to  manage users ip / gateway / dns server / accesstime  with freeradius + mysql

i have found in radchek howto user/cleartext-password/password := ( to manage user/password)
radreply (id/user/Framed-IP-Address/value/:=) to assign an ip address)

do you have some  tips to send the dns server address, the gateway address/ sql to manage time limitation user acces and in what base write it.

I use IP addresse to manage the way users can access the net
sample 10.0.0.10 to 10.0.0.100 go into a pipe of 200k download
and 10.0.0.110 to 10.0.0.210 go into a pipe of 2000 k download,

that will help me to give free-net-access with a poor access pipe, and i will give a high speed access for users that pay for.

i wish  will try to manage  service period  for access , a user will have access from" 09:00 am till 10:00 am

you know all, the system is actually running in 3 hotels, in the future i'll try to manage group access for seminary ( in hotels), so the group will use the access during worktime only.

sorry for my English, french people are not gifted in languages.

Eric