Entry
Server: Radius: Microsoft: Windows: Database:MySql: Install: How to install WinRadius RADIUS server?
Mar 28th, 2005 18:09
Knud van Eeden,
----------------------------------------------------------------------
--- Knud van Eeden --- 25 March 2005 - 03:35 pm ----------------------
Server: Radius: Microsoft: Windows: Database:MySql: Install: How to
install WinRadius RADIUS server?
---
Steps: Overview:
1. -Download the WinRadius radius server
http://www.itconsult2000.com/en/product/WinRadius.zip
2. -Install the WinRadius radius server
1. Unzip the file
winradius.zip
3. Create your MySql database
1. Prepare an empty database of your database,
(such as MySql, Microsoft SQL server, Oracle, ...)
etc.
1. Start your MySql
1. Goto your MySql bin directory
2. Start your MySql software server
mysqld-nt.exe
3. Start your MySql command line interface
mysql.exe
1. Type the command
1. Create a database
in general:
CREATE DATABASE <your databasename>;
e.g.
CREATE DATABASE WinRadius;
4. -Close MySql
1. Type the command
exit
4. -Download an ODBC driver for your MySql databases
http://dev.mysql.com/downloads/connector/odbc/3.51.html
1. -Click on link 'Driver Installer (EXE)'
for 'Windows downloads'
2. -Download
e.g.
http://dev.mysql.com/get/Downloads/MyODBC3/MyODBC-3.51.11-1-
win.exe/from/ftp://mirror.mcs.anl.gov/pub/mysql/
and run the file
MyODBC-3.51.11-1-win.exe
3. This will start a MyODBC installation wizard
1. Possibly accept the license agreement
2. -Click button 'Next'
3. -Click button 'Next'
4. -The installation starts
5. -Install this newly created MySql database in ODBC
1. -Click button Windows 'Start'
2. -Select from list 'Control Panel'
3. -Double click on icon 'Administrative Tools'
4. -Double click on icon 'Data Sources (ODBC)'
5. -Now inform where your newly created MySql database
can be found
1. -Select tab 'File DSN'
2. -Click button 'Add'
3. -Select from list 'MySQL ODBC 3.51 Driver'
4. -Click button 'Next'
5. -Click button 'Browse...'
1. -Browse to the directory of your
newly created MySql database
e.g.
h:\pdrive\MySql\MySQL_Server_4.1\data
2. -Select your newly created MySql database
in this directory
e.g.
WinRadius
1. -Click button 'Open'
3. Save this selection in a '.opt' file
e.g. the default
db.opt
1. -Click button 'Save'
6. -Click button 'Next'
7. -Click button 'Finish'
5. -Select tab 'User DSN'
6. -Click button 'Add...'
7. -Select the 'MySQL ODBC 3.51 Driver'
from list
8. -Click button 'Finish'
9. -Now an original MySql (showing the 'delphin'
animal icon of MySql) dialog box should
open
1. -Click button 'Login'
2. Fill in the fields
1. 'Data Source Name'
e.g.
WinRadius
2. 'Description'
e.g.
WinRadius
3. 'Server'
leave this e.g. blank
4. 'User'
e.g.
admin
5. 'Password'
leave this e.g. blank
6. 'Database'
1. -Select from list your MySql
database
e.g.
WinRadius
7. -Click button 'OK'
10. -Click button 'OK'
5. -Create automatically the tables in your MySql database
1. -Start the program
WinRadius.exe
1. -Select the database involved
1. -Select from menu option 'Settings'
2. -Select from list 'Database'
1. -This will open a dialog box
'ODB Settings'
1. Fill in the name you have chosen for
your 'ODBC name:'
e.g.
WinRadius
2. -Click button 'OK'
2. -Restart the program
WinRadius.exe
1. -Create the tables
1. -Select from menu option 'Advanced'
1. -Select from list 'Create Radius Table'
3. -Now wait a little while to let the tables be
created (a few minutes)
4. -Restart the program
WinRadius.exe
7. View and check this newly created MySql database
1. Open an MSDOS box
2. Start the mysql.exe program
--- cut here: begin --------------------------------------------------
-----------------------------------------------------------------------
mysql.exe
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 18 to server version: 4.1.8-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use winradius;
Database changed
mysql> show tables;
+---------------------+
| Tables_in_winradius |
+---------------------+
| tblogs |
| tbusers |
| tbvoip |
+---------------------+
3 rows in set (0.02 sec)
---
mysql> show fields from tblogs;
+----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| happen | varchar(25) | YES | | NULL | |
| username | varchar(25) | YES | | NULL | |
| called | varchar(255) | YES | | NULL | |
| duration | float | YES | | NULL | |
| input | float | YES | | NULL | |
| output | float | YES | | NULL | |
| fee | float | YES | | NULL | |
+----------+--------------+------+-----+---------+-------+
7 rows in set (0.03 sec)
---
mysql> show fields from tbusers;
+----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| username | varchar(25) | YES | | NULL | |
| password | varchar(25) | YES | | NULL | |
| groups | varchar(25) | YES | | NULL | |
| addr | varchar(255) | YES | | NULL | |
| cash | float | YES | | NULL | |
| expiry | varchar(25) | YES | | NULL | |
| others | varchar(255) | YES | | NULL | |
| method | varchar(255) | YES | | NULL | |
| billtype | varchar(255) | YES | | NULL | |
+----------+--------------+------+-----+---------+-------+
9 rows in set (0.04 sec)
---
mysql> show fields from tbvoip;
+-----------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------+--------------+------+-----+---------+-------+
| username | varchar(255) | YES | | NULL | |
| called_station_id | varchar(255) | YES | | NULL | |
| calling_station_id | varchar(255) | YES | | NULL | |
| acct_status_type | varchar(255) | YES | | NULL | |
| acct_delay_time | varchar(255) | YES | | NULL | |
| acct_session_id | varchar(255) | YES | | NULL | |
| acct_session_time | varchar(255) | YES | | NULL | |
| nas_ip_address | varchar(255) | YES | | NULL | |
| nas_port | varchar(255) | YES | | NULL | |
| h323_conf_id | varchar(255) | YES | | NULL | |
| h323_call_origin | varchar(255) | YES | | NULL | |
| h323_call_type | varchar(255) | YES | | NULL | |
| h323_remote_address | varchar(255) | YES | | NULL | |
| h323_connect_time | varchar(255) | YES | | NULL | |
| h323_disconnect_time | varchar(255) | YES | | NULL | |
| h323_disconnect_cause | varchar(255) | YES | | NULL | |
| h323_voice_quality | varchar(255) | YES | | NULL | |
+-----------------------+--------------+------+-----+---------+-------+
17 rows in set (0.04 sec)
--- cut here: end ----------------------------------------------------
6. -To authenticate users via WinRadius.exe
1. -Start the program
WinRadius.exe
1. To add users that should get access to your network
1. -Select from menu option 'Operation'
1. -Select from list 'Add User...'
1. Fill in the fields
'Username'
e.g.
user1
'Password'
test1
'Group'
group1
'Address'
adress1
...
2. -Click button 'OK'
3. -You should now see in the log
'Add user successfully'
4. -Check also in your MySql database
if a user has been added
1. -And this is the case,
the user 'user1' has been
added in the 'tbusers' table
--- cut here: begin --------------------------------------------------
cd h:\pdrive\mysql\mySQL_Server_4.1\bin
mysql.exe
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 39 to server version: 4.1.8-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use winradius;
Database changed
mysql> select * from tbusers;
+----------+----------+--------+----------+------+--------+--------+---
------------+----------+
| username | password | groups | addr | cash | expiry | others |
method | billtype |
+----------+----------+--------+----------+------+--------+--------+---
------------+----------+
| user1 | test1 | group1 | address1 | 0 | | |
Based on Time | Postpaid |
+----------+----------+--------+----------+------+--------+--------+---
------------+----------+
1 row in set (0.09 sec)
mysql>
--- cut here: end ----------------------------------------------------
8. Configure now your device so that it can use the data of the
allowed users in this MySql database to authenticate access
to it system
---
---
Tested successfully on Microsoft Windows XP Professional, running
WinRadius v2.25
MySql ODBC driver v3.51
MySql v4.1
---
---
Internet: see also:
---
[search google: 'winradius password': http://216.239.51.104/search?
q=cache:HN4ODbfGVxMJ:www.tranzeo.com/support_pdfs/User%2520Guide%
2520For%25208021x%2520Deployment.pdf+winradius+password&hl=en]
---
[Internet: see also: http://www.tayle.com/documents/dsa3100_22.php]
---
Database: MySql: Microsoft: Windows: Install: How to download and
install the MySql v4.1 database?
http://www.faqts.com/knowledge_base/view.phtml/aid/33002/fid/185
---
Operating system: Microsoft Windows: WAMP: Link: Overview: Can you
give an overview of links? [LAMP]
http://www.faqts.com/knowledge_base/view.phtml/aid/33803/fid/772
----------------------------------------------------------------------
