Re: (RADIATOR) AddressAllocator SQL

2001-10-16 Thread Hugh Irvine


Hello Harrison -

On Wednesday 17 October 2001 15:45, Harrison Ng wrote:
> Hi,
>
> Is it possible to have multiple 'AllocateQuery' statement in
> , similar to multiple 'AuthSelect' in .
>
> In some occasion our RAS won't send accounting stop, so we are running out
> of ip address. So we need to reclaim those unused ip address before actual
> 'AllocateQuery'. 'ReclaimQuery' won't help in this situation, because our
> 'DefaultLeasePeriod' is 7 days.
>

No this is not possible. 

I think you have three options.

1. get your vendor to fix the problem with lost stop records

2. use a shorter DefaultLeasePeriod

3. write an external program that will scan the address table and ascertain 
which ones are still in use and which ones are not, freeing those that are not

regards

Hugh


-- 
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) AddressAllocator SQL

2001-10-16 Thread Harrison Ng
Title: AddressAllocator SQL





Hi,


Is it possible to have multiple 'AllocateQuery' statement in , similar to multiple 'AuthSelect' in .

In some occasion our RAS won't send accounting stop, so we are running out of ip address. So we need to reclaim those unused ip address before actual 'AllocateQuery'. 'ReclaimQuery' won't help in this situation, because our 'DefaultLeasePeriod' is 7 days.


Thanks in advance!



Harrison
SmarTone BroadBand Service Limited





Re: (RADIATOR) IP allocation

2001-10-16 Thread Hugh Irvine


Hello AbdusSami -

On Wednesday 17 October 2001 00:30, Mohammed AbdusSami wrote:
> Dear All,
>
> I had a typical requirement. If a user comes from one NAS server with realm
> r1 radiator should allocate IP and if he comes from other NNAS server with
> same realm i.e r1 then NAS server should allocate IP for that user.
>
> Is it possible. If yes please quote one example.
>

# define Client clauses


Identifier NasWillAllocate
.



Identifier RadiatorWillAllocate
.


..

# define Handlers


..



..



regards

Hugh


-- 
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.



Re: (RADIATOR) Radius client

2001-10-16 Thread Hugh Irvine


Hello Bob -

You might want to consider using PAM (plugable authentication modules) and 
simply use the PAM-Radius module.

Do a Google search (www.google.com) on "plugable authentication module".

regards

Hugh


On Tuesday 16 October 2001 21:21, bshafer wrote:
> This isn`t exactly a Radiator question. But since we use Radiator, I
> thought I`d ask it here.
>
> We use Radiator for VPN authentication.  We are developing a custom
> application that requires authentication.  I said, "Gee, why not use
> radius?"
>
> So I`ve been looking an easy to use radius client.  Something that does
> authentication and some simple accounting.  I`ve looked at and tried
> RadiusPerl-0.05.  And so far, no luck with the authentication, and it
> doesn`t appear to do accounting.
>
> With some persistence, sooner or later, I might get the authentication to
> work, but without the accounting, it seems of little use for our needs.
>
> The other thought I had is to use radpwtst as an example, and roll our own,
> but I thought I`d check here before I did that.  I`d prefer not to have
> re-invent the wheel, if I can.
>
> Thanks,
>
> Bob Shafer
> University of Denver
>
> ===
> 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: 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.



Re: (RADIATOR) Multiple AuthBy and Accounting

2001-10-16 Thread Hugh Irvine


Hello Suwat -

On Tuesday 16 October 2001 21:01, Suwat Charoensakpanich wrote:
> Hello.
>  I have some problem. I use Multiple AuthBy
> (). It's work for authentication ,but
> it isn't send accouting log to MySQL.OK I use
> ,  and .
>  In my radius.cfg
> 
>   AuthByPolicy ContinueUntilAccept
>   
>   
>   
> 
> If I use "AuthByPolicy ContinueUntilAccept" ,then
> it woke correct with authentication and accouting log
> (detail file).But RADMIN don't have accouing in
> mySQL.
> If I use "AuthByPolicy ContinueAlways" ,then
> radiator
> check user in all AuthBy,but it don't send accounting
> to
> RADMIN.

It is usually easiest to do this with Handlers:

# define AuthBy clauses


Identifier CheckRADMIN
.



Identifier CheckFILE
.



Identifier CheckNT>
.


# define Handlers


AuthBy CheckRADMIN
.



AuthByPolicy ContinueUntilAccept
AuthBy CheckFILE
AuthBy CheckNT
AuthBy CheckRADMIN
.


Note that you cannot mix Realms and Handlers in the same configuration file.

hth

Hugh


-- 
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.



Re: (RADIATOR) Radius auithentication on Microsoft IIS

2001-10-16 Thread Hugh Irvine


Hello Rik -

On Tuesday 16 October 2001 20:39, [EMAIL PROTECTED] wrote:
> Hi all,
>
> It may be slightly off topic, but I would like to know if it is possible to
> let MS IIS authenticate against a Radius Server. One of our customers would
> like to be able to do this.
>

If IIS can be configured to use radius for authentication, all you need to do 
is configure a Client clause for it in the radius server configuration file.

If IIS cannot be configured this way, you might consider using Apache.

regards

Hugh


-- 
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.



Re: (RADIATOR) Help with Proxy

2001-10-16 Thread Hugh Irvine


Hello Oscar -

The attribute that you are looking for is this:

VENDORATTR 429  Terminal-Type   0x9823  string

It is contained in the file "dictionary.usr" in the Radiator distribution.

If you are going to be using these attributes, you should edit the standard 
"dictionary" file with your favourite text editor and cut and paste the 
additional USR attributes from "dictionary.usr".

Note that you should always start with the standard dictionary and add (or 
remove) attributes to it as required.

Also note that the vendors are constantly adding dictionary definitions and 
it is a real challenge for us to keep the dictionary(s) up to date.

regards

Hugh


On Wednesday 17 October 2001 02:17, Oscar Xavier Zovo wrote:
> Hello,
>
> First I'm new to RADIUS
>
> I'm running the demo version of Radiator (2.18.4)
> It's acting as a proxy for a RADIUS server (cistron), and receives
> authentication requests for a realm (@teste1).
>
> All seems to go well, but I receive the following error.
>
> ERR: Attribute number 38947 (vendor 429) is not defined in your dictionary
>
> I have used only the example files that comes with radiator for config and
> users No additional Attributes where used.
>
> I've tried the some schem between 2 cistron servers and there was no
> message error like that. I tried to concatenate the standard dictionary
> with the USR one, but all I got was more errors.
>
>
> We want to build a central database for authentication info, not only for
> RADIUS, but for all services Web, FTP, Email, and let clients access
> independent servers with the some username/password. After searching a lot
> we found that Radiator can be part of our solution since that supports a
> huge range of authentication methods.
>
> So I would like to know:
>   1* if there are additional steps to follow for appropriately proxy a
> RADIUS server other than Radiator.
>   2* if both servers must have the same attributes in the dictionary files,
> or I can let each one using the defaults from their distribution
>
> This is the reply from radiator in a test with cistron-radius test client
> (radtest).
>
> # radtest user4@teste1 fred 194.133.xxx.yyy 0 secret
> Sending request.
> radrecv: Reply from host 127985c2 code=2, id=75, length=62
> Service-Type = Framed-User
> Framed-Protocol = PPP
> Framed-IP-Netmask = 255.255.255.255
> Framed-Routing = None
> Framed-MTU = 1500
> Framed-Compression = Van-Jacobson-TCP-IP
> Session-Timeout = 30
>
> This is the config file for user4 in radiator:
>
> user4@teste1User-Password = "fred"
> Service-Type = Framed-User,
> Framed-Protocol = PPP,
> Framed-IP-Netmask = 255.255.255.255,
> Framed-Routing = None,
> Framed-MTU = 1500,
> Framed-Compression = Van-Jacobson-TCP-IP,
> Session-Timeout = 30
>
> 
> Oscar Xavier Zovo Manuel
> EBONet Media <[EMAIL PROTECTED]>
>
> --
> Este e-mail foi enviado através do serviço Mukanda Webmail da Rede EBONet
> "Pense Global, Actue Local"
> Terminal Helpdesk: 39-2381
> Email: [EMAIL PROTECTED]
> ===
> 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: 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.



Re: (RADIATOR) authentication when SQL/proxyRadius is down

2001-10-16 Thread Hugh Irvine


Hello David -

On Wednesday 17 October 2001 01:13, [EMAIL PROTECTED] wrote:
> Hi
> I'm testing (Radiator/Radmin DEMO ) with some possible configuratin to
> solve our requirements.
> Overview: Radius server is connected to other server with SQL database.
> Radius do Authby SQL or Auth by Radius (proxy)  - based on @realm
>
> So in case of SQL database or proxy radius server is down I would like to
> authenticate (send Access accept)  users ( possible users with bad password
> - it doesn't matter - it's free dial up ) and do accounting to file on
> radius server.
>

You would do something like this:

# define AuthBy clauses


Identifier CheckSQL
DBSource .
DBUsername .
DBAuth .
..
AcctFailedLogFileName .
AcctFailedLogFileFormat .



Identifier ForwardToProxy
..
NoReplyHook .
AcctFailedLogFileName .
AcctFailedLogFileFormat .



Identifier AcceptAll


# define Realms


AuthByPolicy ContinueUntilAccept
AuthBy CheckSQL
AuthBy AcceptAll
.



Identifier AcceptAll
AuthBy ForwardToProxy
.


There is an example NoReplyHook in the file "goodies/hooks.txt" that will 
work with what is shown above.

Also have a look at sections 6.28 and 6.29 in the Radiator reference manual 
included in the file "doc/ref.html" in the distribution.

If you have any other questions please ask.

regards

Hugh


-- 
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) Help with Proxy

2001-10-16 Thread Oscar Xavier Zovo



Hello,

First I'm new to RADIUS

I'm running the demo version of Radiator (2.18.4)
It's acting as a proxy for a RADIUS server (cistron), and receives 
authentication requests for a realm (@teste1).

All seems to go well, but I receive the following error.

ERR: Attribute number 38947 (vendor 429) is not defined in your dictionary

I have used only the example files that comes with radiator for config and users
No additional Attributes where used.

I've tried the some schem between 2 cistron servers and there was no message 
error like that. I tried to concatenate the standard dictionary with the USR 
one, but all I got was more errors.


We want to build a central database for authentication info, not only for 
RADIUS, but for all services Web, FTP, Email, and let clients access 
independent servers with the some username/password. After searching a lot we 
found that Radiator can be part of our solution since that supports a huge 
range of authentication methods.

So I would like to know:
  1* if there are additional steps to follow for appropriately proxy a RADIUS 
server other than Radiator.
  2* if both servers must have the same attributes in the dictionary files, or 
I can let each one using the defaults from their distribution

This is the reply from radiator in a test with cistron-radius test client 
(radtest).

# radtest user4@teste1 fred 194.133.xxx.yyy 0 secret
Sending request.
radrecv: Reply from host 127985c2 code=2, id=75, length=62
Service-Type = Framed-User
Framed-Protocol = PPP
Framed-IP-Netmask = 255.255.255.255
Framed-Routing = None
Framed-MTU = 1500
Framed-Compression = Van-Jacobson-TCP-IP
Session-Timeout = 30

This is the config file for user4 in radiator:

user4@teste1User-Password = "fred"
Service-Type = Framed-User,
Framed-Protocol = PPP,
Framed-IP-Netmask = 255.255.255.255,
Framed-Routing = None,
Framed-MTU = 1500,
Framed-Compression = Van-Jacobson-TCP-IP,
Session-Timeout = 30


Oscar Xavier Zovo Manuel
EBONet Media <[EMAIL PROTECTED]>

--
Este e-mail foi enviado através do serviço Mukanda Webmail da Rede EBONet
"Pense Global, Actue Local"
Terminal Helpdesk: 39-2381
Email: [EMAIL PROTECTED]
===
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) authentication when SQL/proxyRadius is down

2001-10-16 Thread david . kramar

Hi 
I'm testing (Radiator/Radmin DEMO ) with some possible configuratin to solve
our requirements.
Overview: Radius server is connected to other server with SQL database.
Radius do Authby SQL or Auth by Radius (proxy)  - based on @realm  

So in case of SQL database or proxy radius server is down I would like to
authenticate (send Access accept)  users ( possible users with bad password
- it doesn't matter - it's free dial up ) and do accounting to file on
radius server.


Thanks for any idea
David Kramar   
===
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) IP allocation

2001-10-16 Thread Mohammed AbdusSami

Dear All,

I had a typical requirement. If a user comes from one NAS server with realm
r1 radiator should allocate IP and if he comes from other NNAS server with
same realm i.e r1 then NAS server should allocate IP for that user.

Is it possible. If yes please quote one example.

Tnx in Advance.

Regards,

AbdusSami

===
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) insert errors

2001-10-16 Thread Robert G. Fisher

On Tue, Oct 16, 2001 at 05:45:22PM +1000, manager wrote:
> I keep getting this error
> 
> ('username', 'Oct 16, 2001 14:23', 1, 0, '0019',
> 'patton1.domain.com.au', 6)': Server message number=2627 severity=14 state=1
> line=3 server=ntserver procedure=calls_insert text=Violation of PRIMARY KEY
> constraint 'pk_ServerPorts': Attempt to insert duplicate key in object
> 'ServerPorts'.Server message number=3621 severity=0 state=0 line=3
> server=ntserver procedure=calls_insert text=Command has been aborted.
> 
> My set up is Radiator using emerald.cfg to back into platpus

If you used BoardTown's scripts to setup the database 
for RadiusNT or Radiator then you will find that there is 
a trigger on the Calls table that populates the ServerPorts
table.  Which lends itself to an obvious problem with your
configuaration if Radiator is trying to manage this data
simultaneously.  You can either remove the trigger or remove
the session management information from Radiator.
===
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) Radius client

2001-10-16 Thread neil d. quiogue

Hello Bob,

Have you tried Lars' radiusclient?
http://www.mcs-cityline.net/~lf/radius/

Regards,

Neil D. Quiogue
PSINet Hong Kong Ltd.
A MEMBER OF THE CITIC PACIFIC GROUP
Voice (852) 2170.7140
Fax   (852) 2372.0287

"Information and attachments herein are intended for the named recipients
only.  It may contain attorney-client privileged or confidential matter.
If you have received this message in error, please notify the sender
immediately, and destroy the original message.  Do not disclose the
contents to anyone.  Thank you."
- Original Message -
From: "bshafer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 16, 2001 7:21 PM
Subject: (RADIATOR) Radius client


> This isn`t exactly a Radiator question. But since we use Radiator, I
thought
> I`d ask it here.
>
> We use Radiator for VPN authentication.  We are developing a custom
> application that requires authentication.  I said, "Gee, why not use
radius?"
>
> So I`ve been looking an easy to use radius client.  Something that does
> authentication and some simple accounting.  I`ve looked at and tried
> RadiusPerl-0.05.  And so far, no luck with the authentication, and it
doesn`t
> appear to do accounting.
>
> With some persistence, sooner or later, I might get the authentication to
> work, but without the accounting, it seems of little use for our needs.
>
> The other thought I had is to use radpwtst as an example, and roll our
own,
> but I thought I`d check here before I did that.  I`d prefer not to have
> re-invent the wheel, if I can.
>
> Thanks,
>
> Bob Shafer
> University of Denver
>
> ===
> 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.
>

===
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) Radius client

2001-10-16 Thread bshafer

This isn`t exactly a Radiator question. But since we use Radiator, I thought 
I`d ask it here.

We use Radiator for VPN authentication.  We are developing a custom 
application that requires authentication.  I said, "Gee, why not use radius?"

So I`ve been looking an easy to use radius client.  Something that does 
authentication and some simple accounting.  I`ve looked at and tried 
RadiusPerl-0.05.  And so far, no luck with the authentication, and it doesn`t 
appear to do accounting.

With some persistence, sooner or later, I might get the authentication to 
work, but without the accounting, it seems of little use for our needs.

The other thought I had is to use radpwtst as an example, and roll our own, 
but I thought I`d check here before I did that.  I`d prefer not to have 
re-invent the wheel, if I can.

Thanks,

Bob Shafer
University of Denver

===
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) Multiple AuthBy and Accounting

2001-10-16 Thread Suwat Charoensakpanich

Hello.
 I have some problem. I use Multiple AuthBy 
(). It's work for authentication ,but 
it isn't send accouting log to MySQL.OK I use 
,  and .  
 In my radius.cfg 

  AuthByPolicy ContinueUntilAccept
  
  
  

If I use "AuthByPolicy ContinueUntilAccept" ,then
it woke correct with authentication and accouting log 
(detail file).But RADMIN don't have accouing in 
mySQL.
If I use "AuthByPolicy ContinueAlways" ,then
radiator
check user in all AuthBy,but it don't send accounting
to 
RADMIN.
Please recommend me
Regards,
suwat.c
Logic Company

__
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.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) Radius auithentication on Microsoft IIS

2001-10-16 Thread rik . nagtegaal

Hi all,

It may be slightly off topic, but I would like to know if it is possible to
let MS IIS authenticate against a Radius Server. One of our customers would
like to be able to do this.

Any suggestions?

Regards,

Rik


DISCLAIMER:
The information contained in this communication is confidential and may be
legally privileged. It is intended solely for the use of the individual or
entity to whom it is addressed and others authorized to receive it. If you
are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution, or taking any action in reliance of the
contents of this information is strictly prohibited and may be unlawful.
Stork is liable for neither the proper and complete transmission of the
information contained in this communication nor for any delay in its
receipt.

===
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) insert errors

2001-10-16 Thread Hugh Irvine


Hello Matthew -

I will need to see a trace 4 debug from Radiator and a copy of your 
configuration file (no secrets).

thanks

Hugh

On Tuesday 16 October 2001 17:45, manager wrote:
> I keep getting this error
>
> ('username', 'Oct 16, 2001 14:23', 1, 0, '0019',
> 'patton1.domain.com.au', 6)': Server message number=2627 severity=14
> state=1 line=3 server=ntserver procedure=calls_insert text=Violation of
> PRIMARY KEY constraint 'pk_ServerPorts': Attempt to insert duplicate key in
> object 'ServerPorts'.Server message number=3621 severity=0 state=0 line=3
> server=ntserver procedure=calls_insert text=Command has been aborted.
>
> My set up is
> Radiator using emerald.cfg to back into platpus
> I have 3 portmaster3 which don't cause this problem
> And 2 (recently added) patton2800 NAS boxes which cause the above problem.
>
> From what I can see is when the patton boxes are switch off and on again
> the session id or " '0019'" part from above resets back to zero.
> and you end up with  '0019' from patton box 1 and then again from
> patton box 2.
>
> Is there a fix for this or work around for this problem ?
>
> Thanks for any help
> Matthew


Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 


-- 
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.



Re: (RADIATOR) insert errors

2001-10-16 Thread Jesús M Díaz


Hello,

i had the same problem too, but whit the pair 'nas-identifier/nas-port'. i could solve it changing the AddQuery sentence at 'session sql' clause from 'insert into ...' to 'replace into ...'.

the problem, as i could see, is when due an error or any other reason, Radiator keeps a session entry but that sessions is not real yet.

regards


--Original Message Text---
From: manager
Date: Tue, 16 Oct 2001 17:45:22 +1000

I keep getting this error

   ('username', 'Oct 16, 2001 14:23', 1, 0, '0019',
'patton1.domain.com.au', 6)': Server message number=2627 severity=14 state=1
line=3 server=ntserver procedure=calls_insert text=Violation of PRIMARY KEY
constraint 'pk_ServerPorts': Attempt to insert duplicate key in object
'ServerPorts'.Server message number=3621 severity=0 state=0 line=3
server=ntserver procedure=calls_insert text=Command has been aborted.

My set up is
Radiator using emerald.cfg to back into platpus
I have 3 portmaster3 which don't cause this problem
And 2 (recently added) patton2800 NAS boxes which cause the above problem.

>From what I can see is when the patton boxes are switch off and on again
the session id or " '0019'" part from above resets back to zero.
and you end up with '0019' from patton box 1 and then again from patton
box 2.

Is there a fix for this or work around for this problem ?

Thanks for any help
Matthew









Jesus M Diaz <[EMAIL PROTECTED]>

ONO Service Provider
Planificación y Diseño de Red
Tfno: +34 91 623 2909
Fax:  +34 91 623 2911



(RADIATOR) insert errors

2001-10-16 Thread manager



I keep getting 
this 
error    
('username', 'Oct 16, 2001 14:23', 1, 0, '0019','patton1.domain.com.au', 
6)': Server message number=2627 severity=14 state=1line=3 server=ntserver 
procedure=calls_insert text=Violation of PRIMARY KEYconstraint 
'pk_ServerPorts': Attempt to insert duplicate key in 
object'ServerPorts'.Server message number=3621 severity=0 state=0 
line=3server=ntserver procedure=calls_insert text=Command has been 
aborted.My set up isRadiator using emerald.cfg to back into 
platpusI have 3 portmaster3 which don't cause this problemAnd 2 
(recently added) patton2800 NAS boxes which cause the above 
problem.>From what I can see is when the patton boxes are switch off 
and on againthe session id or " '0019'" part from above resets back to 
zero.and you end up with  '0019' from patton box 1 and then again 
from pattonbox 2.Is there a fix for this or work around for this 
problem ?Thanks for any 
helpMatthew