[RADIATOR] AuthEMERALD Platypus

[Gilbert T. Gutierrez, Jr.]

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