Re: [Help-gnu-radius] GNU Radius with --enable-sql=mysql

[wiwinleung]

Thanks Milovan!

I would like to know more.  After I have created a database named RADIUS
and created the 3 tables, how can I connect the radius to mysql?
What I mean is how I should re-written my config files to work with the
mysql database?  Coz it seems that the radius can't connect to mysql
successfully.
For example:
>radauth -v wiwin wiwin123
NO REPLY
Authentication failed

the radiusd is running properly:
Jul 23 16:00:08: [2553]: ready
Jul 23 16:00:08: [2553]: /usr/local/gnu-radius/etc/raddb/users reloaded.
Jul 23 16:00:08: [2553]: using 127.0.0.1 as my IP address
Jul 23 16:00:08: [2554]: Ready to process requests.

and I can access the RADIUS by:

>mysql -u radius -ppassword RADIUS.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 42 to server version: 3.23.39-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select * from passwd;
+-----------+----------+
| user_name | password |
+-----------+----------+
| wiwin     | wiwin123 |
+-----------+----------+
1 row in set (0.00 sec)
mysql>

Any clue?  Thanks a lot for all of your help.


cheers,
Wiwin



                                                                                
                                                
                    "Toni                                                       
                                                
                    Milovan"             To:     <address@hidden>               
                                       
                    <address@hidden        cc:                                  
                                                  
                    u.hr>                Subject:     Re: [Help-gnu-radius] GNU 
Radius with --enable-sql=mysql                  
                                                                                
                                                
                    23/07/2001                                                  
                                                
                    14:16                                                       
                                                
                                                                                
                                                
                                                                                
                                                




Well I'm no expert but I somehow succeded to install and run radius on my
solaris. So, first you have to compile your radius with enable-sql=mysql
statement when doing ./configure:
./configure --enable-sql=mysql --prefix=/usr/local/radius
After you compiled and installed radius go in /usr/locl/radius/etc/raddb
and
look at file sqlserver. On the beginning of file you'll have sql statements
needed to create three tables that you need: passwd, calls, groups. Use
that
code in your mysql base, configure your users file and that's it.

Hope it helps,

Toni Milovan


> Hi, experts!
>
> I can successfully install gnu radius but I don't know how to use mysql
as
> the source for users information?
> What database/tables I will need to create and how can I config the
radius
> to talk with mysql?
>
> Thanks in advance!
>
> - wiwin
>
>
> _______________________________________________
> Help-gnu-radius mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/help-gnu-radius
>