(RADIATOR) RE: Not inserting in Radonline table

[Hugh Irvine]

Hello AbdusSami -

I have had another look at the log file, and the problem may be due to 
the way you have specified the queries in the SessionDatabase SQL 
clause. The DeleteQuery shown below will delete all sessions in the 
session database for a given user when the access request is received 
(see the debug log), because the Acct-Session-Id is not present (it is 
only present in the accounting requests).

	DeleteQuery DELETE FROM RADONLINE \
		WHERE ACCTSESSIONID like '%{Acct-Session-Id}' AND UserName like '%n'

This being the case, you will never be able to check simultaneous use, 
because there will never be any more than one session shown for a given 
user.

I think you will need to rethink what you are trying to do with your 
SessionDatabase SQL queries.

regards

Hugh


On Wednesday, October 16, 2002, at 11:40 AM, Mohammed AbdusSami wrote:

> Dear Hugh,
>
> Thanks for immediate response. In Radonline table there are no records
> though it is showing in log file.
>
> No there is nothing like retries good that it gets the connection 
> within
> seconds with single try.
>
> Regards,
>
> AbdusSami
>
>
>
> -----Original Message-----
> From: Hugh Irvine [mailto:hugh at open.com.au]
> Sent: Wednesday, October 16, 2002 4:33 PM
> To: Mohammed AbdusSami
> Cc: radiator at open.com.au
> Subject: Re: Not inserting in Radonline table
>
>
> Hello AbdusSami -
>
> Thanks for sending the files.
>
> As far as I can see, Radiator is operating correctly, and the log shows
> an insert happening for the RADONLINE table.
>
> What do you see in the RADONLINE table?
>
> BTW - there appear to be a lot of retries happening in the log - is
> this normal?
>
> regards
>
> Hugh
>
>
> On Wednesday, October 16, 2002, at 11:04 AM, Mohammed AbdusSami wrote:
>
>> Dear Hugh,
>>
>> Attached are the file of my both configuration & log file.
>>
>> My problem is I am getting connection successfully but for every
>> connection it is not insert record in radonline table which is
> enabling
>> multiple logins.
>>
>> Regards,
>>
>> AbdusSami
>>
>> <tasweeqLog.txt><tasweeq for hugh.cfg>
>
> NB: I am travelling this week, so there may be delays in our
> correspondence.
>
> -- 
> 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 radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
>
>

NB: I am travelling this week, so there may be delays in our 
correspondence.

-- 
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 radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.