RE: Making FreeRadius
Try here: http://www.oreilly.com/catalog/radius/chapter/ch05.html --- Secure Wireless Networking Now --- Glynn Taylor President WiFiConsulting, Inc. Web: http://www.WiFiConsulting.com http://www.HotSpotVPN.com --- Secure Wireless Networking Now --- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Lau Kin Hoong Sent: Thursday, December 12, 2002 5:34 AM To: [EMAIL PROTECTED] Subject: Making FreeRadius Hi, I'm trying to install freeRadius. I followed the instructions given in the web site www.missl.cs.umd.edu/wireless/eaptls. When I try to "make", some errors were returned. The error returned was "error [2]" Therefore, i couldn't even get to the "make install" stage. The instructions mentioned that one solution to the problem (Linux system misdetecting the gethostbyadd_r() and gethostbyname_r() ) is radius-autoconf.h So, what i did was, to place radius-autoconf.hin /usr/src/802/radius/radiusd/src/include Then make again. But it doesn't seem to solve the problem. Can you help me? Regards, Lau - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Free 802.1X supplicant software for Win2K?
Try here: http://www.microsoft.com/windows2000/server/evaluation/news/bulletins/8021xc lient.asp --- Secure Wireless Networking Now --- Glynn Taylor President WiFiConsulting, Inc. Web: http://www.WiFiConsulting.com --- Secure Wireless Networking Now --- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Sarick Sent: Monday, November 11, 2002 11:19 PM To: [EMAIL PROTECTED] Subject: Re: Free 802.1X supplicant software for Win2K? Hi Jeffery: Thanks for your kind help. But I am looking for the free windows supplicant for permanent use. Can anyone help me? Regards Sarick - Original Message - From: "Jeffery Huang" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 11, 2002 1:14 PM Subject: Re: Free 802.1X supplicant software for Win2K? > jmc_cs ´£¨ì: > > Hi Jeffery: > > I have visited the meetinghouse's homepage. > > But the supplicant software for Windows version need to pay. > > Isn't it? > > > > Sarick > > > > - Original Message - > > From: "Jeffery Huang" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Friday, November 08, 2002 7:36 PM > > Subject: Re: Free 802.1X supplicant software for Win2K? > > > > > > > >>Sarick ´£¨ì: > >> > >>>Hi: > >>>Are there any 802.1X supplicant software for Win2K (or Win98/me)??? > >>>Can anyone advise me where I can download?? > >>> > >>>Regards > >>>Sarick > >>> > >>> > >>> > >>>- > >>>List info/subscribe/unsubscribe? See > >> > > http://www.freeradius.org/list/users.html > > > >>aegis client > >>download from http://www.mtghouse.com > >> > >>-- > >>Regard, > >>Jeffery Huang > >>iMining Technology Co.,Ltd. > >>886-2-2723-5122-11 > >>886-2-27232287 > >>http://www.imining.com.tw > >>email:[EMAIL PROTECTED] > >> > >> > >>- > >>List info/subscribe/unsubscribe? See > > > > http://www.freeradius.org/list/users.html > > > >> > > > > > > > > - > > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > > > > yes! > you can free try for 15 days! > > -- > Regard, > Jeffery Huang > iMining Technology Co.,Ltd. > 886-2-2723-5122-11 > 886-2-27232287 > http://www.imining.com.tw > email:[EMAIL PROTECTED] > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html > > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: Re[5]: (So close I can taste it...) freeradius & mssql2000
Nope, weird. I can connect with tsql by forcing the port, but if I change the port in the odbc.ini file like so: [iatms@localhost bin]$ cat /usr/local/etc/odbc.ini [sqlserver] Driver = TDS Descripttion = SQL Server Trace = Yes Servername = 192.168.0.4:1433 Database = wific and try to connect using the dsn, it failes: [glynn@localhost bin]$ /usr/local/bin/isql -v sqlserver hsvpnws eagles99 src/tds/login.c: tds_connect: 192.168.0.4:1433: Connection refused [unixODBC]tds_connect failed [ISQL]ERROR: Could not SQLConnect [glynn@localhost bin]$ It picks up the port number, bit still fails with a tds_connect failed, which is weird because I can connect with tsql, which uses tds... I'm stumped. -Original Message- From: [EMAIL PROTECTED] [mailto:freeradius-users-admin@;lists.cistron.nl]On Behalf Of Glynn Taylor Sent: Thursday, November 07, 2002 10:06 AM To: [EMAIL PROTECTED] Subject: RE: Re[5]: (So close I can taste it...) freeradius & mssql2000 Ok, using the tsql that comes with freetds in \usr\local\bin i can connect. [iatms@localhost bin]$ whoami iatms [iatms@localhost bin]$ /usr/local/bin/tsql -S 192.168.0.126:1433 -U hsvpnws Password: Msg 5703, Level 0, State 1, Server WFC-ACC1, Line 0 Changed language setting to us_english. 1> select * from customers; 2> go ID CustomerID NameAddr1 CityState Zip 1 1 Microsoft 1 Microsoft Way RedmondWA 98105 5 2 Oracle 1 Ellison Way Dontknow 9 1> Notice I forced the port. I'll try shoving the port in one of the ini files and I'll try isql next... -Original Message- From: [EMAIL PROTECTED] [mailto:freeradius-users-admin@;lists.cistron.nl]On Behalf Of Glynn Taylor Sent: Thursday, November 07, 2002 9:47 AM To: [EMAIL PROTECTED] Subject: RE: Re[5]: (So close I can taste it...) freeradius & mssql2000 Nope, I got a failure! [glynn@localhost bin]$ isql -v sqlserver hsvpnws eagles99 [unixODBC]tds_connect failed [ISQL]ERROR: Could not SQLConnect And it seems to be a tds conneciton failure. Hmmm, When compiling freetds --with unixodbc, did you specify a directory? Exactly what kind of files is it looking for? I recompiled since my last test, and tsql was working then and now it does not. I'm going to look at freetds compile more closely and report back. gt -Original Message- From: [EMAIL PROTECTED] [mailto:freeradius-users-admin@;lists.cistron.nl]On Behalf Of Christian Schmit Sent: Thursday, November 07, 2002 9:22 AM To: Glynn Taylor Subject: Re[5]: (So close I can taste it...) freeradius & mssql2000 GT> Wow, so close. Thank you thank you. GT> I actually had not run the odbcinst command, and in odbcinst.ini and I had GT> file useage = 1. (What is the difference between 1 and 2? I have not been GT> able to find that one in the docs). I think odbcinst changed the value from 1 to 2 in my case. GT> Below you mentioned sql.conf. Did you mean mssql.conf? I renamed my mssql.conf to sql.conf so it is the same file we are using. Did you try your odbc connection using: isql -v MSSQL-6 login MyPassword Christian GT> That is the one I'm using. Anyway, I eliminated those two obvious differences in our setup and GT> I still get the same error when connecting. I did notice something GT> different in my trace, but I don't know what it means if anything. Notice GT> that the word null shows up when it loads my rlm_sql, but in your's it does GT> not. GT> rlm_sql ((null)): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded GT> and linked GT> rlm_sql ((null)): Attempting to connect to [EMAIL PROTECTED]:/wific GT> rlm_sql ((null)): starting 0 GT> rlm_sql ((null)): Attempting to connect #0 GT> rlm_sql_unixodbc: Connection failed GT> rlm_sql ((null)): Failed to connect DB handle #0 GT> rlm_sql ((null)): starting 1 GT> rlm_sql ((null)): starting 2 GT> rlm_sql ((null)): starting 3 GT> rlm_sql ((null)): starting 4 GT> Module: Instantiated sql (sql) GT> Module: Loaded files GT> files: usersfile = "/etc/raddb/users" GT> files: acctusersfile = "/etc/raddb/acct_users" GT> files: preproxy_usersfile = "/etc/raddb/preproxy_users" GT> Is there a logfile that would have more detail of my failed connection? GT> Thanks GT> GT GT> -Original Message- GT> From: [EMAIL PROTECTED] GT> [mailto:freeradius-users-admin@;lists.cistron.nl]On Behalf Of Christian GT> Schmit GT> Sent: Thursday, November 07, 2002 6:05 AM GT> To: Christian Schmit GT> Subject: Re[3]: (So close I can taste it...) freeradius & mssql2000 GT> I found my error. GT> The sql script included with freeradius for creating the GT> mssql database layout has an error. Freeradius uses "NASPort" GT> and the sql script in
RE: Re[5]: (So close I can taste it...) freeradius & mssql2000
Ok, using the tsql that comes with freetds in \usr\local\bin i can connect. [iatms@localhost bin]$ whoami iatms [iatms@localhost bin]$ /usr/local/bin/tsql -S 192.168.0.126:1433 -U hsvpnws Password: Msg 5703, Level 0, State 1, Server WFC-ACC1, Line 0 Changed language setting to us_english. 1> select * from customers; 2> go ID CustomerID NameAddr1 CityState Zip 1 1 Microsoft 1 Microsoft Way RedmondWA 98105 5 2 Oracle 1 Ellison Way Dontknow 9 1> Notice I forced the port. I'll try shoving the port in one of the ini files and I'll try isql next... -Original Message- From: [EMAIL PROTECTED] [mailto:freeradius-users-admin@;lists.cistron.nl]On Behalf Of Glynn Taylor Sent: Thursday, November 07, 2002 9:47 AM To: [EMAIL PROTECTED] Subject: RE: Re[5]: (So close I can taste it...) freeradius & mssql2000 Nope, I got a failure! [glynn@localhost bin]$ isql -v sqlserver hsvpnws eagles99 [unixODBC]tds_connect failed [ISQL]ERROR: Could not SQLConnect And it seems to be a tds conneciton failure. Hmmm, When compiling freetds --with unixodbc, did you specify a directory? Exactly what kind of files is it looking for? I recompiled since my last test, and tsql was working then and now it does not. I'm going to look at freetds compile more closely and report back. gt -Original Message- From: [EMAIL PROTECTED] [mailto:freeradius-users-admin@;lists.cistron.nl]On Behalf Of Christian Schmit Sent: Thursday, November 07, 2002 9:22 AM To: Glynn Taylor Subject: Re[5]: (So close I can taste it...) freeradius & mssql2000 GT> Wow, so close. Thank you thank you. GT> I actually had not run the odbcinst command, and in odbcinst.ini and I had GT> file useage = 1. (What is the difference between 1 and 2? I have not been GT> able to find that one in the docs). I think odbcinst changed the value from 1 to 2 in my case. GT> Below you mentioned sql.conf. Did you mean mssql.conf? I renamed my mssql.conf to sql.conf so it is the same file we are using. Did you try your odbc connection using: isql -v MSSQL-6 login MyPassword Christian GT> That is the one I'm using. Anyway, I eliminated those two obvious differences in our setup and GT> I still get the same error when connecting. I did notice something GT> different in my trace, but I don't know what it means if anything. Notice GT> that the word null shows up when it loads my rlm_sql, but in your's it does GT> not. GT> rlm_sql ((null)): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded GT> and linked GT> rlm_sql ((null)): Attempting to connect to [EMAIL PROTECTED]:/wific GT> rlm_sql ((null)): starting 0 GT> rlm_sql ((null)): Attempting to connect #0 GT> rlm_sql_unixodbc: Connection failed GT> rlm_sql ((null)): Failed to connect DB handle #0 GT> rlm_sql ((null)): starting 1 GT> rlm_sql ((null)): starting 2 GT> rlm_sql ((null)): starting 3 GT> rlm_sql ((null)): starting 4 GT> Module: Instantiated sql (sql) GT> Module: Loaded files GT> files: usersfile = "/etc/raddb/users" GT> files: acctusersfile = "/etc/raddb/acct_users" GT> files: preproxy_usersfile = "/etc/raddb/preproxy_users" GT> Is there a logfile that would have more detail of my failed connection? GT> Thanks GT> GT GT> -Original Message- GT> From: [EMAIL PROTECTED] GT> [mailto:freeradius-users-admin@;lists.cistron.nl]On Behalf Of Christian GT> Schmit GT> Sent: Thursday, November 07, 2002 6:05 AM GT> To: Christian Schmit GT> Subject: Re[3]: (So close I can taste it...) freeradius & mssql2000 GT> I found my error. GT> The sql script included with freeradius for creating the GT> mssql database layout has an error. Freeradius uses "NASPort" GT> and the sql script included with freeradius for the mssql GT> database layout uses "NASPortid" GT> Christian CS>> Glynn, CS>> I am trying the same setup here. CS>> Here is my setup current setup: CS>> First I installed unixodbc. Then I compiled/installed CS>> freetds with "--with-unixodbc" as suggested by CS>> someone on the mailing list. Then I installed freeradius. CS>> My conf files are: CS>> freetds.conf: CS>> -- CS>> [MSSQL-6] CS>> host = 1.2.3.4 CS>> port = 1433 CS>> tds version = 7.0 CS>> odbc.ini CS>> - CS>> [MSSQL-6] CS>> Driver = TDS CS>> Description = SQL Server CS>> Trace = No CS>> Servername = 1.2.3.4 CS>> Database = freeradius CS>> odbcinst.ini CS>> - CS>> [TDS] CS>> Description = FreeTDS v0.60 CS>> Driver = /usr
RE: Re[5]: (So close I can taste it...) freeradius & mssql2000
After a recompile of the released version I get isql and tsql logon errors. There are two tsql's on my path, depending if I'm on as root or a plain user one or the other gets used. I made sure I used the freetds tsql and the unixodbc isql. Here are the errors: Notice that it seems to be going after port 4000! It should be going for port 1433... ++ [iatms@localhost bin]$ tsql -S 192.168.0.126 -U hsvpnws Password: src/tds/login.c: tds_connect: 192.168.0.126:4000: Connection refused Msg 20009, Level 9, State 0, Server OpenClient, Line 0 Server is unavailable or does not exist. There was a problem connecting to the server ++ [glynn@localhost bin]$ isql -v sqlserver hsvpnws eagles99 src/tds/login.c: tds_connect: 192.168.0.4:4000: Connection refused [unixODBC]tds_connect failed [ISQL]ERROR: Could not SQLConnect == How do I force it to go for port 1433? This is an internal test machine and does not have dns... Thanks GT -Original Message- From: [EMAIL PROTECTED] [mailto:freeradius-users-admin@;lists.cistron.nl]On Behalf Of Glynn Taylor Sent: Thursday, November 07, 2002 9:47 AM To: [EMAIL PROTECTED] Subject: RE: Re[5]: (So close I can taste it...) freeradius & mssql2000 Nope, I got a failure! [glynn@localhost bin]$ isql -v sqlserver hsvpnws eagles99 [unixODBC]tds_connect failed [ISQL]ERROR: Could not SQLConnect And it seems to be a tds conneciton failure. Hmmm, When compiling freetds --with unixodbc, did you specify a directory? Exactly what kind of files is it looking for? I recompiled since my last test, and tsql was working then and now it does not. I'm going to look at freetds compile more closely and report back. gt -Original Message- From: [EMAIL PROTECTED] [mailto:freeradius-users-admin@;lists.cistron.nl]On Behalf Of Christian Schmit Sent: Thursday, November 07, 2002 9:22 AM To: Glynn Taylor Subject: Re[5]: (So close I can taste it...) freeradius & mssql2000 GT> Wow, so close. Thank you thank you. GT> I actually had not run the odbcinst command, and in odbcinst.ini and I had GT> file useage = 1. (What is the difference between 1 and 2? I have not been GT> able to find that one in the docs). I think odbcinst changed the value from 1 to 2 in my case. GT> Below you mentioned sql.conf. Did you mean mssql.conf? I renamed my mssql.conf to sql.conf so it is the same file we are using. Did you try your odbc connection using: isql -v MSSQL-6 login MyPassword Christian GT> That is the one I'm using. Anyway, I eliminated those two obvious differences in our setup and GT> I still get the same error when connecting. I did notice something GT> different in my trace, but I don't know what it means if anything. Notice GT> that the word null shows up when it loads my rlm_sql, but in your's it does GT> not. GT> rlm_sql ((null)): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded GT> and linked GT> rlm_sql ((null)): Attempting to connect to [EMAIL PROTECTED]:/wific GT> rlm_sql ((null)): starting 0 GT> rlm_sql ((null)): Attempting to connect #0 GT> rlm_sql_unixodbc: Connection failed GT> rlm_sql ((null)): Failed to connect DB handle #0 GT> rlm_sql ((null)): starting 1 GT> rlm_sql ((null)): starting 2 GT> rlm_sql ((null)): starting 3 GT> rlm_sql ((null)): starting 4 GT> Module: Instantiated sql (sql) GT> Module: Loaded files GT> files: usersfile = "/etc/raddb/users" GT> files: acctusersfile = "/etc/raddb/acct_users" GT> files: preproxy_usersfile = "/etc/raddb/preproxy_users" GT> Is there a logfile that would have more detail of my failed connection? GT> Thanks GT> GT GT> -Original Message- GT> From: [EMAIL PROTECTED] GT> [mailto:freeradius-users-admin@;lists.cistron.nl]On Behalf Of Christian GT> Schmit GT> Sent: Thursday, November 07, 2002 6:05 AM GT> To: Christian Schmit GT> Subject: Re[3]: (So close I can taste it...) freeradius & mssql2000 GT> I found my error. GT> The sql script included with freeradius for creating the GT> mssql database layout has an error. Freeradius uses "NASPort" GT> and the sql script included with freeradius for the mssql GT> database layout uses "NASPortid" GT> Christian CS>> Glynn, CS>> I am trying the same setup here. CS>> Here is my setup current setup: CS>> First I installed unixodbc. Then I compiled/installed CS>> freetds with "--with-unixodbc" as suggested by CS>> someone on the mailing list. Then I installed freeradius. CS>> My conf files are: CS>> freetds.conf: CS>> -- CS>> [MSSQL-6] CS>> host
RE: Re[5]: (So close I can taste it...) freeradius & mssql2000
Nope, I got a failure! [glynn@localhost bin]$ isql -v sqlserver hsvpnws eagles99 [unixODBC]tds_connect failed [ISQL]ERROR: Could not SQLConnect And it seems to be a tds conneciton failure. Hmmm, When compiling freetds --with unixodbc, did you specify a directory? Exactly what kind of files is it looking for? I recompiled since my last test, and tsql was working then and now it does not. I'm going to look at freetds compile more closely and report back. gt -Original Message- From: [EMAIL PROTECTED] [mailto:freeradius-users-admin@;lists.cistron.nl]On Behalf Of Christian Schmit Sent: Thursday, November 07, 2002 9:22 AM To: Glynn Taylor Subject: Re[5]: (So close I can taste it...) freeradius & mssql2000 GT> Wow, so close. Thank you thank you. GT> I actually had not run the odbcinst command, and in odbcinst.ini and I had GT> file useage = 1. (What is the difference between 1 and 2? I have not been GT> able to find that one in the docs). I think odbcinst changed the value from 1 to 2 in my case. GT> Below you mentioned sql.conf. Did you mean mssql.conf? I renamed my mssql.conf to sql.conf so it is the same file we are using. Did you try your odbc connection using: isql -v MSSQL-6 login MyPassword Christian GT> That is the one I'm using. Anyway, I eliminated those two obvious differences in our setup and GT> I still get the same error when connecting. I did notice something GT> different in my trace, but I don't know what it means if anything. Notice GT> that the word null shows up when it loads my rlm_sql, but in your's it does GT> not. GT> rlm_sql ((null)): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded GT> and linked GT> rlm_sql ((null)): Attempting to connect to [EMAIL PROTECTED]:/wific GT> rlm_sql ((null)): starting 0 GT> rlm_sql ((null)): Attempting to connect #0 GT> rlm_sql_unixodbc: Connection failed GT> rlm_sql ((null)): Failed to connect DB handle #0 GT> rlm_sql ((null)): starting 1 GT> rlm_sql ((null)): starting 2 GT> rlm_sql ((null)): starting 3 GT> rlm_sql ((null)): starting 4 GT> Module: Instantiated sql (sql) GT> Module: Loaded files GT> files: usersfile = "/etc/raddb/users" GT> files: acctusersfile = "/etc/raddb/acct_users" GT> files: preproxy_usersfile = "/etc/raddb/preproxy_users" GT> Is there a logfile that would have more detail of my failed connection? GT> Thanks GT> GT GT> -Original Message- GT> From: [EMAIL PROTECTED] GT> [mailto:freeradius-users-admin@;lists.cistron.nl]On Behalf Of Christian GT> Schmit GT> Sent: Thursday, November 07, 2002 6:05 AM GT> To: Christian Schmit GT> Subject: Re[3]: (So close I can taste it...) freeradius & mssql2000 GT> I found my error. GT> The sql script included with freeradius for creating the GT> mssql database layout has an error. Freeradius uses "NASPort" GT> and the sql script included with freeradius for the mssql GT> database layout uses "NASPortid" GT> Christian CS>> Glynn, CS>> I am trying the same setup here. CS>> Here is my setup current setup: CS>> First I installed unixodbc. Then I compiled/installed CS>> freetds with "--with-unixodbc" as suggested by CS>> someone on the mailing list. Then I installed freeradius. CS>> My conf files are: CS>> freetds.conf: CS>> -- CS>> [MSSQL-6] CS>> host = 1.2.3.4 CS>> port = 1433 CS>> tds version = 7.0 CS>> odbc.ini CS>> - CS>> [MSSQL-6] CS>> Driver = TDS CS>> Description = SQL Server CS>> Trace = No CS>> Servername = 1.2.3.4 CS>> Database = freeradius CS>> odbcinst.ini CS>> - CS>> [TDS] CS>> Description = FreeTDS v0.60 CS>> Driver = /usr/local/freetds/lib/libtdsodbc.so CS>> FileUsage = 2 CS>> sql.conf of radius CS>> CS>> driver = "rlm_sql_unixodbc" CS>> # Connect info CS>> server = MSSQL-6 CS>> login = "freeradius" CS>> password = "something" CS>> # Database table configuration CS>> radius_db = "freeradius" CS>> Then I installed the odbc named "MSSQL-6" using: CS>> odbcinst -i -d -f odbcinst.ini CS>> odbcinst -i -s -f odbc.ini CS>> Making tests using "isql -v MSSQL-6 login MyPassword" CS>> works fine. I can manually update records in the MSSQL CS>> database. CS>> starting radius: CS>> radius connects fine to MSSQL server as debug shows: CS>> rlm_sql: Driver rlm_sql_unixodbc loaded and linked CS>> rlm_sql: Attempting to con
RE: Re[3]: (So close I can taste it...) freeradius & mssql2000
AcctInputOctets,
AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause,
ServiceType,
CS> FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay)
values('7400315D', '', 'dme', '', '212.24.192.4', '34', 'ISDN', '2002-11-06
18:44:40',
CS> '127', 'RADIUS', '', '', '2320', '157339', '', '', 'User-Request',
'Framed-User', 'PPP', '212.24.192.101', '0', '0')'
CS> rlm_sql_unixodbc: '0 '
CS> rlm_sql: Couldn't insert SQL accounting STOP record - 0
CS> rlm_sql: Released sql socket id: 4
CS> modcall[accounting]: module "sql" returns ok
CS> radius_xlat: '/usr/local/var/log/radius/radacct/212.24.192.4/detail'
CS> rlm_detail:
/usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail expands to
/usr/local/var/log/radius/radacct/212.24.192.4/detail
CS> modcall[accounting]: module "detail" returns ok
CS> modcall[accounting]: module "unix" returns ok
CS> radius_xlat: 'dme'
CS> Accounting: logout: entry for NAS 212.24.192.4 port 34 has wrong ID
CS> modcall[accounting]: module "radutmp" returns ok
CS> modcall: group accounting returns ok
CS> Sending Accounting-Response of id 175 to 212.24.192.4:1118
CS> Finished request 0
CS> Going to the next request
CS> ---
CS> regards,
CS> Christian
GT>> Thank you. My apologies for leaving that out:
GT>> my /usr/local/freetds.conf file has this as the only section database
GT>> section:
GT>> [192.168.0.126]
GT>> host = 192.168.0.126
GT>> port = 1433
GT>> tds version = 7.0
GT>> Does the name in [brackets] have to match anything else in the other
conf
GT>> files??
GT>> The test program tsql is working:
GT>>
GT>> [glynn@localhost bin]$ tsql -S 192.168.0.126 -p 1433 -U hsvpnws
GT>> Password:
GT>> Msg 5703, Level 0, State 1, Server WFC-ACC1, Line 0
GT>> Changed language setting to us_english.
1>>> use wific
2>>> go
1>>> select * from customer;
2>>> go
GT>> Msg 208, Level 16, State 1, Server WFC-ACC1, Line 1
GT>> Invalid object name 'customer'.
1>>> select * from customers;
2>>> go
GT>> ID CustomerID NameAddr1 CityState Zip
GT>> 1 1 Microsoft 1 Microsoft Way
GT>> Redmond
WA
GT>> 98105
GT>> 5 2 Oracle 1 Ellison Way
GT>> Dontknow
GT>> 9
1>>>
GT>> Yet radiusd can not get a connection to the database. Is there some
logging
GT>> I can turn on or check to help me figure this out?
GT>> Thanks all
GT>> GT
GT>> -Original Message-
GT>> From: [EMAIL PROTECTED]
GT>> [mailto:freeradius-users-admin@;lists.cistron.nl]On Behalf Of Adorable
GT>> Dauz
GT>> Sent: Wednesday, November 06, 2002 5:53 PM
GT>> To: [EMAIL PROTECTED]
GT>> Subject: Re: (So close I can taste it...) freeradius & mssql2000
GT>> you need also to configure the freetds first.
GT>> - Original Message -
GT>> From: "Glynn Taylor" <[EMAIL PROTECTED]>
GT>> To: "Freeradius-Users" <[EMAIL PROTECTED]>
GT>> Sent: Thursday, November 07, 2002 6:36 AM
GT>> Subject: (So close I can taste it...) freeradius & mssql2000
>>>
>>> 1. Do we have to specify a port number to connect to a MS SQL database?
GT>> (If
>>> so where, I can't find where to put one in MSSQL.conf)
>>>
>>> 2. Is it true that unixODBC does not work on it's own and still requires
>>> freeTDS?
>>>
>>> First I got freeRadius working with text files. So far so good. The
move
>>> to SQL has not yet worked. The user is hsvpnws, the database is wific.
GT>> The
>>> databases server is 192.168.0.126.
>>>
>>> My Modules load, but my connection never makes it.
>>>
>>> sql: simul_verify_query = ""
>>> rlm_sql ((null)): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc)
loaded
>>> and linked
>>> rlm_sql ((null)): Attempting to connect to [EMAIL PROTECTED]:/wific
>>> rlm_sql ((null)): starting 0
>>> rlm_sql ((null)): Attempting to connect #0
>>> rlm_sql_unixodbc: Connection failed
>>> rlm_sql ((null)): Failed to connect DB handle #0
>>&g
RE: (So close I can taste it...) freeradius & mssql2000
Thank you. My apologies for leaving that out:
my /usr/local/freetds.conf file has this as the only section database
section:
[192.168.0.126]
host = 192.168.0.126
port = 1433
tds version = 7.0
Does the name in [brackets] have to match anything else in the other conf
files??
The test program tsql is working:
[glynn@localhost bin]$ tsql -S 192.168.0.126 -p 1433 -U hsvpnws
Password:
Msg 5703, Level 0, State 1, Server WFC-ACC1, Line 0
Changed language setting to us_english.
1> use wific
2> go
1> select * from customer;
2> go
Msg 208, Level 16, State 1, Server WFC-ACC1, Line 1
Invalid object name 'customer'.
1> select * from customers;
2> go
ID CustomerID NameAddr1 CityState Zip
1 1 Microsoft 1 Microsoft Way
RedmondWA
98105
5 2 Oracle 1 Ellison Way
Dontknow
9
1>
Yet radiusd can not get a connection to the database. Is there some logging
I can turn on or check to help me figure this out?
Thanks all
GT
-Original Message-
From: [EMAIL PROTECTED]
[mailto:freeradius-users-admin@;lists.cistron.nl]On Behalf Of Adorable
Dauz
Sent: Wednesday, November 06, 2002 5:53 PM
To: [EMAIL PROTECTED]
Subject: Re: (So close I can taste it...) freeradius & mssql2000
you need also to configure the freetds first.
- Original Message -
From: "Glynn Taylor" <[EMAIL PROTECTED]>
To: "Freeradius-Users" <[EMAIL PROTECTED]>
Sent: Thursday, November 07, 2002 6:36 AM
Subject: (So close I can taste it...) freeradius & mssql2000
>
> 1. Do we have to specify a port number to connect to a MS SQL database?
(If
> so where, I can't find where to put one in MSSQL.conf)
>
> 2. Is it true that unixODBC does not work on it's own and still requires
> freeTDS?
>
> First I got freeRadius working with text files. So far so good. The move
> to SQL has not yet worked. The user is hsvpnws, the database is wific.
The
> databases server is 192.168.0.126.
>
> My Modules load, but my connection never makes it.
>
> sql: simul_verify_query = ""
> rlm_sql ((null)): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded
> and linked
> rlm_sql ((null)): Attempting to connect to [EMAIL PROTECTED]:/wific
> rlm_sql ((null)): starting 0
> rlm_sql ((null)): Attempting to connect #0
> rlm_sql_unixodbc: Connection failed
> rlm_sql ((null)): Failed to connect DB handle #0
> rlm_sql ((null)): starting 1
> rlm_sql ((null)): starting 2
> rlm_sql ((null)): starting 3
> rlm_sql ((null)): starting 4
> Module: Instantiated sql (sql)
> Module: Loaded files
> files: usersfile = "/etc/raddb/users"
> files: acctusersfile = "/etc/raddb/acct_users"
> files: preproxy_usersfile = "/etc/raddb/preproxy_users"
> files: compat = "no"
> Module: Instantiated files (files)
> Module: Loaded detail
> detail: detailfile =
"/var/log/radius/radacct/%{Client-IP-Address}/detail"
> detail: detailperm = 384
> detail: dirperm = 493
> detail: locking = no
> Module: Instantiated detail (detail)
> Module: Loaded radutmp
> radutmp: filename = "/var/log/radius/radutmp"
> radutmp: username = "%{User-Name}"
> radutmp: perm = 384
> radutmp: callerid = yes
> Module: Instantiated radutmp (radutmp)
> Listening on IP address *, ports 1812/udp and 1813/udp, with proxy on
> 1814/udp.
> Ready to process requests.
>
> At the top of the raddb trace (third line down here) there is a blank port
> directive, but I can't find where to enter it in mssql.conf:
>
> Module: Loaded SQL
> sql: driver = "rlm_sql_unixodbc"
> sql: server = "192.168.0.126"
> sql: port = ""
> sql: login = "hsvpnws"
> sql: password = "eagles99"
> sql: radius_db = "wific"
> sql: acct_table = "radacct"
> sql: acct_table2 = "radacct"
> sql: authcheck_table = "radcheck"
> sql: authreply_table = "radreply"
> sql: groupcheck_table = "radgroupcheck"
> sql: groupreply_table = "radgroupreply"
> sql: usergroup_table = "usergroup"
> sql: nas_table = "nas"
> sql: dict_table = "dictionary"
> sql: sqltrace = no
> sql: sqltracefile = "/var/log/radius/sqltrace.sql"
> sql: deletestalesessions = yes
> sql: num_sql_socks = 5
> sql: sql
(So close I can taste it...) freeradius & mssql2000
1. Do we have to specify a port number to connect to a MS SQL database? (If
so where, I can't find where to put one in MSSQL.conf)
2. Is it true that unixODBC does not work on it's own and still requires
freeTDS?
First I got freeRadius working with text files. So far so good. The move
to SQL has not yet worked. The user is hsvpnws, the database is wific. The
databases server is 192.168.0.126.
My Modules load, but my connection never makes it.
sql: simul_verify_query = ""
rlm_sql ((null)): Driver rlm_sql_unixodbc (module rlm_sql_unixodbc) loaded
and linked
rlm_sql ((null)): Attempting to connect to [EMAIL PROTECTED]:/wific
rlm_sql ((null)): starting 0
rlm_sql ((null)): Attempting to connect #0
rlm_sql_unixodbc: Connection failed
rlm_sql ((null)): Failed to connect DB handle #0
rlm_sql ((null)): starting 1
rlm_sql ((null)): starting 2
rlm_sql ((null)): starting 3
rlm_sql ((null)): starting 4
Module: Instantiated sql (sql)
Module: Loaded files
files: usersfile = "/etc/raddb/users"
files: acctusersfile = "/etc/raddb/acct_users"
files: preproxy_usersfile = "/etc/raddb/preproxy_users"
files: compat = "no"
Module: Instantiated files (files)
Module: Loaded detail
detail: detailfile = "/var/log/radius/radacct/%{Client-IP-Address}/detail"
detail: detailperm = 384
detail: dirperm = 493
detail: locking = no
Module: Instantiated detail (detail)
Module: Loaded radutmp
radutmp: filename = "/var/log/radius/radutmp"
radutmp: username = "%{User-Name}"
radutmp: perm = 384
radutmp: callerid = yes
Module: Instantiated radutmp (radutmp)
Listening on IP address *, ports 1812/udp and 1813/udp, with proxy on
1814/udp.
Ready to process requests.
At the top of the raddb trace (third line down here) there is a blank port
directive, but I can't find where to enter it in mssql.conf:
Module: Loaded SQL
sql: driver = "rlm_sql_unixodbc"
sql: server = "192.168.0.126"
sql: port = ""
sql: login = "hsvpnws"
sql: password = "eagles99"
sql: radius_db = "wific"
sql: acct_table = "radacct"
sql: acct_table2 = "radacct"
sql: authcheck_table = "radcheck"
sql: authreply_table = "radreply"
sql: groupcheck_table = "radgroupcheck"
sql: groupreply_table = "radgroupreply"
sql: usergroup_table = "usergroup"
sql: nas_table = "nas"
sql: dict_table = "dictionary"
sql: sqltrace = no
sql: sqltracefile = "/var/log/radius/sqltrace.sql"
sql: deletestalesessions = yes
sql: num_sql_socks = 5
sql: sql_user_name = "%{hsvpnws}"
I'm running the latest snapshot of freeRadius and freeTDS. (but the
symptons are the same with 0.7.1 and 0.60). I compiled and installed
unixODBC first, then the freeTDS, then recompiled freeRadius. The database
exists.
This is in my /usr/local/etc/odbc.ini:
[sqlserver]
Driver = TDS
Descripttion = SQL Server
Trace = Yes
Servername = 192.168.0.4
Database = wific
This is in my /usr/local/etc/odbcinst.ini:
[TDS]
Description = SQL 2000 Database
Driver = /usr/local/lib/libtdsodbc.so
FileUsage = 1
In mssql.conf the database type is declared as driver = "rlm_sql_unixodbc"
In radiusd.conf the following line chooses mssql.
# For MS-SQL, use ${confdir}/mssql.conf
$INCLUDE ${confdir}/mssql.conf
Any assistance or pointers greatly appreciated. Thanks for your time.
GT
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
RE: What are the proper ./configure arguments to compile to use MS SQL?
Thank you. I will try that. I have found where to change it in the mssql.conf file. My new question is what are the proper ./configure arguments to compile to use MS SQL using just unixODBC? unixODBC support was not compiled when I did the plain ./configure;make;make install. Thank you again. GT -Original Message- From: [EMAIL PROTECTED] [mailto:freeradius-users-admin@;lists.cistron.nl]On Behalf Of Alan DeKok Sent: Monday, November 04, 2002 2:15 PM To: [EMAIL PROTECTED] Subject: Re: What are the proper ./configure arguments to compile to use MS SQL? "Glynn Taylor" <[EMAIL PROTECTED]> wrote: > If I modify radiusd.conf to use mssql and modify mssql.conf to use > rlm_sql_freetds, radiusd -sfxxy -l stdout fails with: Don't use freetds. The libraries needed by the module are broken. > 1. What are the proper ./configure arguments to properly compile for use > with MS SQL? > 2. Does it depend on unixODBC being loaded first? That would be a better option to try INSTEAD of freetds. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
What are the proper ./configure arguments to compile to use MS SQL?
I've got 0.71 running on RH7.3 and need to authenticate against a MS SQL2000 database. If I modify radiusd.conf to use mssql and modify mssql.conf to use rlm_sql_freetds, radiusd -sfxxy -l stdout fails with: rlm_sql: Could not link driver rlm_sql_freetds: file not foundrlm_sql: Make sure it (and all its dependent libraries!) are in the search path of your system's ld.radiusd.conf[8]: sql: Module instantiation failed. Which means that it did not get compiled. I've scoured the docs and can not find explicit instructions for this. I tried the experimental modules string, but that compiled things I don't think I need and failed before it got to the SQL section (in a perl section I think). 1. What are the proper ./configure arguments to properly compile for use with MS SQL? 2. Does it depend on unixODBC being loaded first? Thanks in advance all. GT
How do I get freeRadius to use MS-CHAPv2 ? (MSChap Mismatch)
I have a vpn that is
talking mschapv2 to freeRadius. I get a MS-CHAP mismatch and
authentication failure even when I configure FR to use MS-CHAPv2. Am I
missing a configuration spot? I can't put it in the user file since it
only takes ms-chap as an argument.
I've read the
docs, I bought the book (finished it last night at about 3), but I can't get
this dog to hunk. Any assistance is greatly
appreciated.
Anyway, here
is the failure trace followed by the mschap portion of radius.conf, the users
section for demo user steve, and the startup trace which shows that it read
mschap2?
TIA
==
Listening on IP
address *, ports 1812/udp and 1813/udp, with proxy on 1814/udp.Ready to
process requests.rad_recv: Access-Request packet from host
192.168.0.2:32770, id=11,
length=121 Service-Type =
Framed-User Framed-Protocol =
PPP User-Name =
"steve" MS-CHAP-Challenge =
0x0c530d958865359599f730d1efcef034
MS-CHAP2-Response =
0x010049f496e0e4edd9b5de36d648ff27c03daa8dbe307bda7b321f02ad554eff263ceddcbeaed6301747modcall:
entering group authorize modcall[authorize]: module "preprocess"
returns ok rlm_realm: Looking up realm NULL for User-Name
= "steve" rlm_realm: No such realm NULL
modcall[authorize]: module "suffix" returns noop users:
Matched DEFAULT at 152 users: Matched DEFAULT at
171 users: Matched DEFAULT at 183
modcall[authorize]: module "files" returns ok modcall[authorize]:
module "mschap" returns notfoundmodcall: group authorize returns
ok rad_check_password: Found Auth-Type Systemauth: type
"System"modcall: entering group authenticaterlm_unix: Attribute
"User-Password" is required for authentication. modcall[authenticate]:
module "unix" returns invalidmodcall: group authenticate returns
invalidauth: Failed to validate the user.Delaying request 0 for 1
secondsFinished request 0Going to the next request--- Walking the
entire request list ---Waking up in 1 seconds...--- Walking the entire
request list ---Waking up in 1 seconds...--- Walking the entire request
list ---Sending Access-Reject of id 11 to
192.168.0.2:32770 MS-CHAP-Error =
"\001E=691 R=1"Waking up in 4 seconds...--- Walking the entire request
list ---Cleaning up request 0 ID 11 with timestamp
3daedbaa
Here is the part of
radiusd.conf where I tell it to use mschapv2..
# Microsoft
CHAP authentication # # This module supports SAMBA
passwd file authorization # and MS-CHAP, MS-CHAPv2
authentication. However, we recommend # using the 'passwd'
module, below, as it's more general. # mschap
{ # if given, passwd shows location of # SAMBA
passwd file # passwd = /etc/smbpasswd #
please note that smbpasswd authorization in # mschap is for
compatibility only. It works # slow and shouldn't be
used. # use rlm_passwd module instead in authorize
section # you can find configuration example for #
passwd etc_smbpasswd # below
#
authtype value, if present, will be used # to overwrite (or add)
Auth-Type during # authorization. Normally should be
MS-CHAP authtype = MS-CHAPv2# if
ignore_password set to yes mschap will # ignore password set by
any other module during # authorization and will always use
password file ignore_password = yes
# if
use_mppe is not set to no mschap will # add MS-CHAP-MPPE-Keys for
MS-CHAPv1 and # MS-MPPE-Recv-Key/MS-MPPE-Send-Key for
MS-CHAPv2 use_mppe = yes
# if
mppe is enabled require_encryption makes # encryption
moderate require_encryption = yes
#
require_strong always requires 128 bit key #
encryption require_strong = yes }
Here is the user
section for steve (I think the Chap-Password instead of Password is
correct...
## This is a complete entry for "steve". Note that there is no
Fall-Through# entry so that no DEFAULT entry will be used, and the user will
NOT# get any attributes in addition to the ones listed
here.#steve Auth-Type := MS-CHAP, Chap-Password ==
"testing9" Service-Type = Framed-User, Framed-Protocol =
PPP, Framed-IP-Address = 172.16.3.33, Framed-IP-Netmask =
255.255.255.0, Framed-Routing =
Broadcast-Listen, Framed-Filter-Id = "std.ppp", Framed-MTU =
1500, Framed-Compression = Van-Jacobsen-TCP-IP
#
Here is the startup
of the trace that shows that mschapv2 was loaded by modules!
HASH: Stored
37 entries from /etc/passwdHASH: Stored 47 entries from
/etc/groupModule: Instantiated unix (unix)Module: Loaded
MS-CHAP mschap: ignore_password = yes mschap: use_mppe =
yes mschap: require_encryption = yes mschap: require_strong =
yes mschap: passwd = "(null)" mschap: authtype =
"MS-CHAPv2"Module: Instantiated mschap (mschap)Module: Loaded
preprocess preprocess: huntgroups =
"/e
(Plain Text This time, sorry) Possible Newbie conf issue: VPN authenticating against FreeRadius
I have a Wolverine VPN (www.coyotelinux.com) attempting to authenticate against FreeRadius. I have installed Wolverine and it works ok with local authentication. I have FreeRadius installed on another box. I uncommented out user steve in the users file for testing. I can get a positive authentications when using Radping. If I try to authenticate steve via Wolverine (where another box trys to start a pptp session through wolverine using steve as the userid with password) it fails. The dump of the two conversations is below. Any ideas are way appreciated. Wolverine is 192.168.0.2 FreeRadius is 192.168.0.3 My workstation with NTRadPing is 192.168.0.125 Thanks GT Here is the Trace, I put in my comments surounded by plus(+) signs: [root@wfcRadiusSql01 raddb]# radiusd -sfxxyz -l stdout Starting - reading configuration files ... reread_config: reading radiusd.conf Config: including file: /etc/raddb/proxy.conf Config: including file: /etc/raddb/clients.conf Config: including file: /etc/raddb/snmp.conf Config: including file: /etc/raddb/sql.conf main: prefix = "/usr/local" main: localstatedir = "/var" main: logdir = "/var/log/radius" main: libdir = "/usr/local/lib" main: radacctdir = "/var/log/radius/radacct" main: hostname_lookups = no read_config_files: reading dictionary read_config_files: reading clients read_config_files: reading realms read_config_files: reading naslist main: max_request_time = 30 main: cleanup_delay = 5 main: max_requests = 1024 main: delete_blocked_requests = 0 main: port = 0 main: allow_core_dumps = no main: log_stripped_names = no main: log_auth = no main: log_auth_badpass = no main: log_auth_goodpass = no main: pidfile = "/var/run/radiusd/radiusd.pid" main: user = "(null)" main: group = "(null)" main: usercollide = no main: lower_user = "no" main: lower_pass = "no" main: nospace_user = "no" main: nospace_pass = "no" main: proxy_requests = yes proxy: retry_delay = 5 proxy: retry_count = 3 proxy: synchronous = no proxy: default_fallback = yes proxy: dead_time = 120 security: max_attributes = 200 security: reject_delay = 1 main: debug_level = 0 read_config_files: entering modules setup Module: Library search path is /usr/local/lib Module: Loaded System unix: cache = yes unix: passwd = "/etc/passwd" unix: shadow = "/etc/shadow" unix: group = "/etc/group" unix: radwtmp = "/var/log/radius/radwtmp" unix: usegroup = no unix: cache_reload = 600 HASH: Reinitializing hash structures and lists for caching... HASH: user root found in hashtable bucket 11726 HASH: user bin found in hashtable bucket 86651 HASH: user daemon found in hashtable bucket 11668 HASH: user adm found in hashtable bucket 26466 HASH: user lp found in hashtable bucket 54068 HASH: user sync found in hashtable bucket 42895 HASH: user shutdown found in hashtable bucket 71746 HASH: user halt found in hashtable bucket 7481 HASH: user mail found in hashtable bucket 79471 HASH: user news found in hashtable bucket 5375 HASH: user uucp found in hashtable bucket 38541 HASH: user operator found in hashtable bucket 21748 HASH: user games found in hashtable bucket 47657 HASH: user gopher found in hashtable bucket 47357 HASH: user ftp found in hashtable bucket 56226 HASH: user nobody found in hashtable bucket 99723 HASH: user ntp found in hashtable bucket 21418 HASH: user rpc found in hashtable bucket 72373 HASH: user vcsa found in hashtable bucket 25959 HASH: user nscd found in hashtable bucket 36306 HASH: user sshd found in hashtable bucket 71560 HASH: user rpm found in hashtable bucket 72383 HASH: user mailnull found in hashtable bucket 78086 HASH: user smmsp found in hashtable bucket 13600 HASH: user rpcuser found in hashtable bucket 552 HASH: user nfsnobody found in hashtable bucket 51830 HASH: user pcap found in hashtable bucket 55326 HASH: user xfs found in hashtable bucket 17213 HASH: user named found in hashtable bucket 7729 HASH: user gdm found in hashtable bucket 50360 HASH: user postgres found in hashtable bucket 19301 HASH: user apache found in hashtable bucket 26582 HASH: user postfix found in hashtable bucket 23093 HASH: user squid found in hashtable bucket 62826 HASH: user webalizer found in hashtable bucket 3037 HASH: user mysql found in hashtable bucket 46314 HASH: user glynn found in hashtable bucket 57940 HASH: Stored 37 entries from /etc/passwd HASH: Stored 47 entries from /etc/group Module: Instantiated unix (unix) Module: Loaded preprocess preprocess: huntgroups = "/etc/raddb/huntgroups" preprocess: hints = "/etc/raddb/hints" preprocess: with_ascend_hack = no preprocess: ascend_channels_per_line = 23 preprocess: with_ntdomain_hack = no preprocess: with_specialix_jetstream_hack = no preprocess: with_cisco_vsa_hack = no Module: Instantiated preprocess (preprocess) Module: Loaded realm realm: format = "suffix" realm: delimiter = "@" Module: Instantiated realm (suffix) Module: Loaded files files: usersfile = "/etc/raddb/users" files: acctusersfile = "/etc/raddb/acct_users" files: compat = "no" Module: Instantiated
Possible Newbie conf issue: VPN authenticating against FreeRadius
I have a Wolverine VPN (www.coyotelinux.com) attempting to authenticate against FreeRadius. I have installed Wolverine and it works ok with local authentication. I have FreeRadius installed on another box. I uncommented out user steve in the users file for testing. I can get a positive authentications when using Radping. If I try to authenticate steve via Wolverine (where another box trys to start a pptp session through wolverine using steve as the userid with password) it fails. The dump of the two conversations is below. Any ideas are way appreciated.Wolverine is 192.168.0.2FreeRadius is 192.168.0.3My workstation with NTRadPing is 192.168.0.125ThanksGTHere is the Trace, I put in my comments surounded by plus(+) signs:[root@wfcRadiusSql01 raddb]# radiusd -sfxxyz -l stdoutStarting - reading configuration files ...reread_config: reading radiusd.confConfig: including file: /etc/raddb/proxy.confConfig: including file: /etc/raddb/clients.confConfig: including file: /etc/raddb/snmp.confConfig: including file: /etc/raddb/sql.confmain: prefix = "/usr/local"main: localstatedir = "/var"main: logdir = "/var/log/radius"main: libdir = "/usr/local/lib"main: radacctdir = "/var/log/radius/radacct"main: hostname_lookups = noread_config_files: reading dictionaryread_config_files: reading clientsread_config_files: reading realmsread_config_files: reading naslistmain: max_request_time = 30main: cleanup_delay = 5main: max_requests = 1024main: delete_blocked_requests = 0main: port = 0main: allow_core_dumps = nomain: log_stripped_names = nomain: log_auth = nomain: log_auth_badpass = nomain: log_auth_goodpass = nomain: pidfile = "/var/run/radiusd/radiusd.pid"main: user = "(null)"main: group = "(null)"main: usercollide = nomain: lower_user = "no"main: lower_pass = "no"main: nospace_user = "no"main: nospace_pass = "no"main: proxy_requests = yesproxy: retry_delay = 5proxy: retry_count = 3proxy: synchronous = noproxy: default_fallback = yesproxy: dead_time = 120security: max_attributes = 200security: reject_delay = 1main: debug_level = 0read_config_files: entering modules setupModule: Library search path is /usr/local/libModule: Loaded Systemunix: cache = yesunix: passwd = "/etc/passwd"unix: shadow = "/etc/shadow"unix: group = "/etc/group"unix: radwtmp = "/var/log/radius/radwtmp"unix: usegroup = nounix: cache_reload = 600HASH: Reinitializing hash structures and lists for caching...HASH: user root found in hashtable bucket 11726HASH: user bin found in hashtable bucket 86651HASH: user daemon found in hashtable bucket 11668HASH: user adm found in hashtable bucket 26466HASH: user lp found in hashtable bucket 54068HASH: user sync found in hashtable bucket 42895HASH: user shutdown found in hashtable bucket 71746HASH: user halt found in hashtable bucket 7481HASH: user mail found in hashtable bucket 79471HASH: user news found in hashtable bucket 5375HASH: user uucp found in hashtable bucket 38541HASH: user operator found in hashtable bucket 21748HASH: user games found in hashtable bucket 47657HASH: user gopher found in hashtable bucket 47357HASH: user ftp found in hashtable bucket 56226HASH: user nobody found in hashtable bucket 99723HASH: user ntp found in hashtable bucket 21418HASH: user rpc found in hashtable bucket 72373HASH: user vcsa found in hashtable bucket 25959HASH: user nscd found in hashtable bucket 36306HASH: user sshd found in hashtable bucket 71560HASH: user rpm found in hashtable bucket 72383HASH: user mailnull found in hashtable bucket 78086HASH: user smmsp found in hashtable bucket 13600HASH: user rpcuser found in hashtable bucket 552HASH: user nfsnobody found in hashtable bucket 51830HASH: user pcap found in hashtable bucket 55326HASH: user xfs found in hashtable bucket 17213HASH: user named found in hashtable bucket 7729HASH: user gdm found in hashtable bucket 50360HASH: user postgres found in hashtable bucket 19301HASH: user apache found in hashtable bucket 26582HASH: user postfix found in hashtable bucket 23093HASH: user squid found in hashtable bucket 62826HASH: user webalizer found in hashtable bucket 3037HASH: user mysql found in hashtable bucket 46314HASH: user glynn found in hashtable bucket 57940HASH: Stored 37 entries from /etc/passwdHASH: Stored 47 entries from /etc/groupModule: Instantiated unix (unix)Module: Loaded preprocesspreprocess: huntgroups = "/etc/raddb/huntgroups"preprocess: hints = "/etc/raddb/hints"preprocess: with_ascend_hack = nopreprocess: ascend_channels_per_line = 23preprocess: with_ntdomain_hack = nopreprocess: with_specialix_jetstream_hack = nopreprocess: with_cisco_vsa_hack = noModule: Instantiated preprocess (preprocess)Module: Loaded realmrealm: format = "suffix"realm: delimiter = "@"Module: Instantiated realm (suffix)Module: Loaded filesfiles: usersfile = "/etc/raddb/users"files: acctusersfile = "/etc/raddb/acct_users"files: compat = "no"Module: Instantiated files (files)Module: Loaded detaildetail: detailfil
