[RADIATOR] AuthEMERALD Platypus

[Hugh Irvine]

Hello Gilbert -

If you have a choice, Radiator on Windows with the ODBC driver is a  
much better option.

The alternative is a commercial ODBC driver for the platform you are  
running on.

Please let us know how you get on.

regards

Hugh


On 12 Nov 2008, at 04:25, Gilbert T. Gutierrez, Jr. wrote:

> Hugh,
>
> Even though the first log excerpt received a no such user, when I  
> have the
> AddATDefaults flag set, the user always is accepted and user  
> attributes are
> returned.  When the AddATDefaults flag is not set the first query  
> works, but
> the subsequent queries are rejected.
>
> Also, I provided the isql results which are a bit deceiving.  After I
> submitted the email to the list, I found that if I kept running the  
> queries,
> the I would get no results.  I am wondering if it is a problem with  
> freetds,
> the driver that I use to access the database?  I am currently  
> running the
> queries against a MS SQL2000 server but the database is  
> transitioning at the
> end of the week to MS SQL2005.
>
> Should I just install Radiator on a MS Windows box with MS Windows  
> ODBC and
> see if that resolves the problem?  The more I think about it, the  
> more I
> think that this may not be a radiator issue but a SQL driver issue.   
> Since I
> first purchased my license for Radiator in '01, I have never had any  
> issue
> but this one.
>
> Thank you,
> Gilbert
>
>
> -----Original Message-----
> From: radiator-bounces at open.com.au [mailto:radiator-bounces at open.com.au 
> ] On
> Behalf Of Hugh Irvine
> Sent: Monday, November 10, 2008 3:25 PM
> To: Gilbert T. Gutierrez, Jr.
> Cc: radiator at open.com.au
> Subject: Re: [RADIATOR] AuthEMERALD Platypus
>
>
> Hello Gilbert -
>
> My apologies - I missed this mail last week.
>
> I am not sure what is happening with your user database, but you are
> getting "No such user" for the user "Gilbert".
>
>
>>
>> Mon Nov  3 15:37:15 2008: DEBUG: Handling request with Handler
>> 'Realm=gilbert'
>> Mon Nov  3 15:37:15 2008: DEBUG: Rewrote user name to Gilbert
>> Mon Nov  3 15:37:15 2008: DEBUG:  Deleting session for
>> Gilbert at gilbert,
>> 203.63.154.1, 1234
>> Mon Nov  3 15:37:15 2008: DEBUG: Handling with Radius::AuthEMERALD:
>> Mon Nov  3 15:37:15 2008: DEBUG: Handling with Radius::AuthEMERALD:
>> Mon Nov  3 15:37:15 2008: DEBUG: Query is: 'select DateAdd(Day,
>> ma.extension+ma.overdue, maExpireDate),
>> DateAdd(Day, sa.extension, saExpireDate), sa.AccountID,
>> sa.AccountType,
>> sa.password, sa.login, sa.shell, sa.TimeLeft
>> from masteraccounts ma, subaccounts sa
>> where (sa.login = 'Gilbert' or sa.shell = 'Gilbert')
>> and ma.customerid = sa.customerid
>> and sa.active <> 0 and ma.active <> 0':
>
> 	
>>
>> Mon Nov  3 15:37:15 2008: DEBUG: Radius::AuthEMERALD looks for match
>> with
>> Gilbert [Gilbert at gilbert]
>> Mon Nov  3 15:37:15 2008: DEBUG: Radius::AuthEMERALD REJECT: No such
>> user:
>> Gilbert [Gilbert at gilbert]
>
>
> In the second debug you are getting an initial accept, but the second
> result is also "No such user".
>
> Can you clarify what is going on?
>
> regards
>
> Hugh
>
>
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator



NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/radiator)?
Have you had a quick look on Google (www.google.com)?
Have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?
Have you checked the RadiusExpert wiki:
http://www.open.com.au/wiki/index.php/Main_Page

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
Includes support for reliable RADIUS transport (RadSec),
and DIAMETER translation agent.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.