(RADIATOR) query during insert data

2003-06-11 Thread budi wibowo

can i do mysql query during data insertion?
i have read a litle about SessionDatabase keyword but
the information is not detail enough 
any idea?


rgds

boed



__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.


(RADIATOR) PEAP ms-chap-v2 Desired EAP type 25 not permitted

2003-06-11 Thread Mobic.com
Hi

I am testing different eap methods, and I have successfully tested:

eap-md5
eap-tls
eap-ttls (ms-chap-v2)

using the Odyssey supplicant.

But I have problems testing peap (ms-chap-v2), the log says Access rejected
for testUser: Desired EAP type 25 not permitted (se log file below).

I am using the eap_multi.cfg configuration and the demo certificates. I am
using the Zyxel B-1000 AP.

Any ideas how to resolv this?

This is what I get from the log:

Code:   Access-Request
Identifier: 227
Authentic:  Q236o156GjC226150e1791630251Ba
Attributes:
User-Name = testUser
NAS-IP-Address = 195.134.48.28
NAS-Identifier = WI_test
Framed-MTU = 1496
Called-Station-Id = 00-a0-c5-37-3e-62:Wireless
Calling-Station-Id = 00-04-75-df-ae-e3
NAS-Port-Type = Wireless-IEEE-802-11
EAP-Message = 2)06130
Message-Authenticator =
8}150137138239232291361421;2432416

Wed Jun 11 12:54:08 2003: DEBUG: Handling request with Handler
'TunnelledByPEAP=1'
Wed Jun 11 12:54:08 2003: DEBUG: Rewrote user name to testUser
Wed Jun 11 12:54:08 2003: DEBUG:  Deleting session for testUser,
195.134.48.28,
Wed Jun 11 12:54:08 2003: DEBUG: Handling with Radius::AuthFILE:
Wed Jun 11 12:54:08 2003: DEBUG: Handling with EAP: code 2, 41, 6
Wed Jun 11 12:54:08 2003: DEBUG: Response type 13
Wed Jun 11 12:54:08 2003: DEBUG: Radius::AuthFILE looks for match with
testUser
Wed Jun 11 12:54:08 2003: DEBUG: Radius::AuthFILE ACCEPT:
Wed Jun 11 12:54:08 2003: DEBUG: Access accepted for testUser
Wed Jun 11 12:54:08 2003: DEBUG: Packet dump:
*** Sending to 195.134.48.28 port 1026 
Code:   Access-Accept
Identifier: 227
Authentic:  Q236o156GjC226150e1791630251Ba
Attributes:
EAP-Message = 3)04
Message-Authenticator = 

Wed Jun 11 12:54:35 2003: DEBUG: Packet dump:
*** Received from 195.134.48.28 port 1026 
Code:   Access-Request
Identifier: 228
Authentic:  Z2081991422525139d199187213w12720340
Attributes:
User-Name = testUser
NAS-IP-Address = 195.134.48.28
NAS-Identifier = WI_test
Framed-MTU = 1496
Called-Station-Id = 00-a0-c5-37-3e-62:Wireless
Calling-Station-Id = 00-04-75-df-ae-e3
NAS-Port-Type = Wireless-IEEE-802-11
EAP-Message = 2*0131testUser
Message-Authenticator =
130194168'178146147156142x+18919018'*

Wed Jun 11 12:54:35 2003: DEBUG: Handling request with Handler
'TunnelledByPEAP=1'
Wed Jun 11 12:54:35 2003: DEBUG: Rewrote user name to testUser
Wed Jun 11 12:54:35 2003: DEBUG:  Deleting session for testUser,
195.134.48.28,
Wed Jun 11 12:54:35 2003: DEBUG: Handling with Radius::AuthFILE:
Wed Jun 11 12:54:35 2003: DEBUG: Handling with EAP: code 2, 42, 13
Wed Jun 11 12:54:35 2003: DEBUG: Response type 1
Wed Jun 11 12:54:35 2003: DEBUG: Access challenged for testUser: EAP
MSCHAP-V2 Challenge
Wed Jun 11 12:54:35 2003: DEBUG: Packet dump:
*** Sending to 195.134.48.28 port 1026 
Code:   Access-Challenge
Identifier: 228
Authentic:  Z2081991422525139d199187213w12720340
Attributes:
EAP-Message =
1+0/261+0*16G4193lC:21619112189133|24422!227in
novasjon.mobinor.no
Message-Authenticator = 

Wed Jun 11 12:54:35 2003: DEBUG: Packet dump:
*** Received from 195.134.48.28 port 1026 
Code:   Access-Request
Identifier: 229
Authentic:  164254}w153236?M139166149/254239180253
Attributes:
User-Name = testUser
NAS-IP-Address = 195.134.48.28
NAS-Identifier = WI_test
Framed-MTU = 1496
Called-Station-Id = 00-a0-c5-37-3e-62:Wireless
Calling-Station-Id = 00-04-75-df-ae-e3
NAS-Port-Type = Wireless-IEEE-802-11
EAP-Message = 2+06325
Message-Authenticator =
180h24219a149,159201249236rk16128

Wed Jun 11 12:54:35 2003: DEBUG: Handling request with Handler
'TunnelledByPEAP=1'
Wed Jun 11 12:54:35 2003: DEBUG: Rewrote user name to testUser
Wed Jun 11 12:54:35 2003: DEBUG:  Deleting session for testUser,
195.134.48.28,
Wed Jun 11 12:54:35 2003: DEBUG: Handling with Radius::AuthFILE:
Wed Jun 11 12:54:35 2003: DEBUG: Handling with EAP: code 2, 43, 6
Wed Jun 11 12:54:35 2003: DEBUG: Response type 3
Wed Jun 11 12:54:35 2003: INFO: EAP Nak desires type 25
Wed Jun 11 12:54:35 2003: INFO: Access rejected for testUser: Desired EAP
type 25 not permitted
Wed Jun 11 12:54:35 2003: DEBUG: Packet dump:
*** Sending to 195.134.48.28 port 1026 
Code:   Access-Reject
Identifier: 229
Authentic:  164254}w153236?M139166149/254239180253
Attributes:
Reply-Message = Request Denied

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.


Re: (RADIATOR) PEAP ms-chap-v2 Desired EAP type 25 not permitted

2003-06-11 Thread Mike McCauley
Hello,

You did not send you configuration file: it makes it much easier for us to 
diagnose problems if you send your configuration file (ne secrets)

It looks like you have your EAPType set to just MSCHAP-V2, and the client is 
trying to the do the outer authetiocaiton PEAP first.

You probably need to set your EAPType to 

EAPType PEAP,MSCHAP-V2

See goodies/eap_peap.cfg for examples on how to configure for PEAP.

Cheers.


On Wed, 11 Jun 2003 09:55 pm, Mobic.com wrote:
 Hi

 I am testing different eap methods, and I have successfully tested:

 eap-md5
 eap-tls
 eap-ttls (ms-chap-v2)

 using the Odyssey supplicant.

 But I have problems testing peap (ms-chap-v2), the log says Access
 rejected for testUser: Desired EAP type 25 not permitted (se log file
 below).

 I am using the eap_multi.cfg configuration and the demo certificates. I am
 using the Zyxel B-1000 AP.

 Any ideas how to resolv this?

 This is what I get from the log:

 Code:   Access-Request
 Identifier: 227
 Authentic:  Q236o156GjC226150e1791630251Ba
 Attributes:
   User-Name = testUser
   NAS-IP-Address = 195.134.48.28
   NAS-Identifier = WI_test
   Framed-MTU = 1496
   Called-Station-Id = 00-a0-c5-37-3e-62:Wireless
   Calling-Station-Id = 00-04-75-df-ae-e3
   NAS-Port-Type = Wireless-IEEE-802-11
   EAP-Message = 2)06130
   Message-Authenticator =
 8}150137138239232291361421;2432416

 Wed Jun 11 12:54:08 2003: DEBUG: Handling request with Handler
 'TunnelledByPEAP=1'
 Wed Jun 11 12:54:08 2003: DEBUG: Rewrote user name to testUser
 Wed Jun 11 12:54:08 2003: DEBUG:  Deleting session for testUser,
 195.134.48.28,
 Wed Jun 11 12:54:08 2003: DEBUG: Handling with Radius::AuthFILE:
 Wed Jun 11 12:54:08 2003: DEBUG: Handling with EAP: code 2, 41, 6
 Wed Jun 11 12:54:08 2003: DEBUG: Response type 13
 Wed Jun 11 12:54:08 2003: DEBUG: Radius::AuthFILE looks for match with
 testUser
 Wed Jun 11 12:54:08 2003: DEBUG: Radius::AuthFILE ACCEPT:
 Wed Jun 11 12:54:08 2003: DEBUG: Access accepted for testUser
 Wed Jun 11 12:54:08 2003: DEBUG: Packet dump:
 *** Sending to 195.134.48.28 port 1026 
 Code:   Access-Accept
 Identifier: 227
 Authentic:  Q236o156GjC226150e1791630251Ba
 Attributes:
   EAP-Message = 3)04
   Message-Authenticator = 

 Wed Jun 11 12:54:35 2003: DEBUG: Packet dump:
 *** Received from 195.134.48.28 port 1026 
 Code:   Access-Request
 Identifier: 228
 Authentic:  Z2081991422525139d199187213w12720340
 Attributes:
   User-Name = testUser
   NAS-IP-Address = 195.134.48.28
   NAS-Identifier = WI_test
   Framed-MTU = 1496
   Called-Station-Id = 00-a0-c5-37-3e-62:Wireless
   Calling-Station-Id = 00-04-75-df-ae-e3
   NAS-Port-Type = Wireless-IEEE-802-11
   EAP-Message = 2*0131testUser
   Message-Authenticator =
 130194168'178146147156142x+18919018'*

 Wed Jun 11 12:54:35 2003: DEBUG: Handling request with Handler
 'TunnelledByPEAP=1'
 Wed Jun 11 12:54:35 2003: DEBUG: Rewrote user name to testUser
 Wed Jun 11 12:54:35 2003: DEBUG:  Deleting session for testUser,
 195.134.48.28,
 Wed Jun 11 12:54:35 2003: DEBUG: Handling with Radius::AuthFILE:
 Wed Jun 11 12:54:35 2003: DEBUG: Handling with EAP: code 2, 42, 13
 Wed Jun 11 12:54:35 2003: DEBUG: Response type 1
 Wed Jun 11 12:54:35 2003: DEBUG: Access challenged for testUser: EAP
 MSCHAP-V2 Challenge
 Wed Jun 11 12:54:35 2003: DEBUG: Packet dump:
 *** Sending to 195.134.48.28 port 1026 
 Code:   Access-Challenge
 Identifier: 228
 Authentic:  Z2081991422525139d199187213w12720340
 Attributes:
   EAP-Message =
 1+0/261+0*16G4193lC:21619112189133|24422!227i
n novasjon.mobinor.no
   Message-Authenticator = 

 Wed Jun 11 12:54:35 2003: DEBUG: Packet dump:
 *** Received from 195.134.48.28 port 1026 
 Code:   Access-Request
 Identifier: 229
 Authentic:  164254}w153236?M139166149/254239180253
 Attributes:
   User-Name = testUser
   NAS-IP-Address = 195.134.48.28
   NAS-Identifier = WI_test
   Framed-MTU = 1496
   Called-Station-Id = 00-a0-c5-37-3e-62:Wireless
   Calling-Station-Id = 00-04-75-df-ae-e3
   NAS-Port-Type = Wireless-IEEE-802-11
   EAP-Message = 2+06325
   Message-Authenticator =
 180h24219a149,159201249236rk16128

 Wed Jun 11 12:54:35 2003: DEBUG: Handling request with Handler
 'TunnelledByPEAP=1'
 Wed Jun 11 12:54:35 2003: DEBUG: Rewrote user name to testUser
 Wed Jun 11 12:54:35 2003: DEBUG:  Deleting session for testUser,
 195.134.48.28,
 Wed Jun 11 12:54:35 2003: DEBUG: Handling with Radius::AuthFILE:
 Wed Jun 11 12:54:35 2003: DEBUG: Handling with EAP: code 2, 43, 6
 Wed Jun 11 12:54:35 2003: DEBUG: Response type 3
 Wed Jun 11 12:54:35 2003: INFO: EAP Nak desires type 25
 Wed Jun 11 12:54:35 2003: INFO: Access rejected for testUser: Desired EAP
 type 25 not permitted
 Wed Jun 11 12:54:35 2003: DEBUG: Packet dump:
 *** Sending to 195.134.48.28 port 1026 
 Code:   Access-Reject
 Identifier: 229
 

(RADIATOR) Using until Time in AuthBy SQL

2003-06-11 Thread newmor








Ive just started to use
Radiator, and I have problem: 

I dont know how to reply
correctly Session-Timeout 

in AuthBy SQL for
different clients:



for example 

- first Client have time block (e.g. Wk1000-1700)

- second client have only prepaid time and no TimeBlock

- third client does not have any time limits







Please, explain me how to write
that in radius.cfg.





Valera. 

[EMAIL PROTECTED]








(RADIATOR)

2003-06-11 Thread newmor








Ive just started to
use Radiator, and I have problem: 

I dont know how to
reply correctly Session-Timeout 

in AuthBy SQL for
different clients:



for example 

- first Client have time block
(e.g. Wk1000-1700)

- second client have only prepaid
time and no TimeBlock

- third client does not have any
time limits







Please, explain me how to
write that in radius.cfg.





Valera. 

[EMAIL PROTECTED]










Re: (RADIATOR)

2003-06-11 Thread Hugh Irvine

Hello -

I have not been able to find your records in our database.

Could you please tell me the name of the registered company that has purchased this copy of Radiator and the username and password you use to access the download site?

Please respond to me directly.

regards

Hugh


On Thursday, Jun 12, 2003, at 07:04 Australia/Melbourne, newmor wrote:

Ive just started to use Radiator, and I have problem: 

I dont know how to reply correctly Session-Timeout 

inAuthBy SQL> for different clients:

?

forexample 

-??first Client have time block (e.g. Wk1000-1700)

-??second client have only prepaid time and no TimeBlock

-??third client does not have any time limits

?

?

?

Please, explain me how to write that in radius.cfg.

?

?

Valera. 

[EMAIL PROTECTED]

?



NB: have you included a copy of your configuration file (no secrets), 
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.



Re: (RADIATOR) query during insert data

2003-06-11 Thread Hugh Irvine
Hello Boed -

You should have a look at the AuthBy SQL clause in section 6.28 in the 
Radiator 3.6 reference manual.

	doc/ref.html

You can use the AuthSQLStatement to insert during authentication and 
you can use the AcctSQLStatement to insert during accounting (you can 
also have multiple instances).

regards

Hugh

On Wednesday, Jun 11, 2003, at 18:55 Australia/Melbourne, budi wibowo 
wrote:

can i do mysql query during data insertion?
i have read a litle about SessionDatabase keyword but
the information is not detail enough
any idea?
rgds

boed



__
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.


(RADIATOR) MDC Aegis Linux 1.2.0beta Wireless client

2003-06-11 Thread Mike McCauley
Hello all,

We have recently completed testing Radiator with the MDC Aegis 1.2.0beta Linux 
wireless client (www.meetinghousedata.com). The Aegis client works with 
Radiator and implements EAP MD5, TLS, TTLS, LEAP and PEAP.

Some remarks about installing and using the Aegis client can be found in the 
Radiator FAQ at http://www.open.com.au/radiator/faq.html

Cheers.

-- 
Mike McCauley   [EMAIL PROTECTED]
Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
Phone +61 3 9598-0985   Fax   +61 3 9598-0955

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, 
TTLS, PEAP etc on Unix, Windows, MacOS etc.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.


(RADIATOR) More Linux wireless client news

2003-06-11 Thread Mike McCauley
Hello all,

Chris Hessing, one of the maintainers of the Open1x wireless client for Linux 
etc reports:

As of the 0.7 release (due out next
week), it will support MD5, TLS, TTLS (PAP  CHAP), and MS-CHAPv2.  Also,
each of these authentication methods was developed and tested against the
Radiator server.  Xsupplicant also works on Mac OS-X, and Open BSD.  For
Mac OS-X, it only works on wired ports, but we should have a wireless
version within the next month.

See http://www.open1x.org/ for more details.

Cheers.


-- 
Mike McCauley   [EMAIL PROTECTED]
Open System Consultants Pty. LtdUnix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
Phone +61 3 9598-0985   Fax   +61 3 9598-0955

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, 
TTLS, PEAP etc on Unix, Windows, MacOS etc.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.


(RADIATOR) Radiator and MySQL 4

2003-06-11 Thread Bennie Warren
Is Radiator compatible with MySQL 4.X? I would like to upgrade my SQL 
server but Radiator is the main reason it exists.

Thanks
Bennie
--
**
Bennie Warren
LemooreNet
320 West D Street
Lemoore, CA  93245
Phone:  559.924.5909
Fax  559.924.9578
[EMAIL PROTECTED]
http://www.lemoorenet.com
**
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.


Re: (RADIATOR) Radiator and MySQL 4

2003-06-11 Thread Hugh Irvine
Hello Bennie -

As far as I know there are no incompatibilties, but you should set up a 
test configuration to verify correct operation with the DBI/DBD modules 
used by Radiator.

regards

Hugh

On Thursday, Jun 12, 2003, at 14:21 Australia/Melbourne, Bennie Warren 
wrote:

Is Radiator compatible with MySQL 4.X? I would like to upgrade my SQL 
server but Radiator is the main reason it exists.

Thanks
Bennie
--
**
Bennie Warren
LemooreNet
320 West D Street
Lemoore, CA  93245
Phone:  559.924.5909
Fax  559.924.9578
[EMAIL PROTECTED]
http://www.lemoorenet.com
**
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.