Re: (RADIATOR) Remote Postgresql DB
Nathan Alberti wrote: I see examples for connecting to a remote MySQL database in the user manual, but on searching I am unable to find examples of it being done with Postgresql. Is it possible ? Any pointing the correct direction for help would be appreciated, I wish to authenticate and log to a remote Postgresql DB. Regards, Nathan in MySQL examples make changes: ... DBSourcedbi:Pg:dbname=radius;host= DBUsername radiususer DBAuth radiususerpwd ... works fine ;) sy, dennis. === 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) Problem with Class attribute
Hi,
I'm having trouble with Radiator 3.3.1. I'm putting concatenated value to
Class attribute.
But in radius logfile it says ERR: There is no value named 19-400 for
attribute Class. Using 0.
In insert statement it gets Class value and gets part of string and puts
into 2 different int field.
Following is the part of logfile and insert statement.
Ganbold
--Logfile --
Thu Nov 21 19:53:08 2002: ERR: There is no value named 19-400 for attribute
Class. Using 0.
Thu Nov 21 19:53:08 2002: ERR: There is no value named 19-400 for attribute
Class. Using 0.
Thu Nov 21 19:53:08 2002: DEBUG: do query is: insert into ACCOUNTING
(USERNAME,ACCTSTATUSTYPE,class_id,TIME_STAMP,ACCTTERMINAT
ECAUSE,NASPORT,CALLINGSTATIONID,ACCTDELAYTIME,CONTRACTID,ACCTSESSIONID,ACCTINPUTOCTETS,FRAMEDIPADDRESS,ACCTSESSIONTIME,ACCTOUT
PUTOCTETS) values
('skytel','Stop',substring('19-400',1,locate('-','19-400')-1),1037879588,'User-Request','56','11366801',0,su
bstring('19-400',locate('-','19-400')+1),'000F6CE3',511690,'202.179.x.xx',3131,7864103)
===
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) Remote Postgresql DB
I see examples for connecting to a remote MySQL database in the user manual, but on searching I am unable to find examples of it being done with Postgresql. Is it possible ? Any pointing the correct direction for help would be appreciated, I wish to authenticate and log to a remote Postgresql DB. Regards, Nathan --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.419 / Virus Database: 235 - Release Date: 13/11/2002 === 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) Re: Retry - Loop
Hello Steven -
Add NoDefault to your AuthBy clause:
.
NoDefault
.
BTW - all of your questions are answered in the Radiator reference
manual ("doc/ref.html").
regards
Hugh
On Friday, Nov 22, 2002, at 14:01 Australia/Melbourne,
[EMAIL PROTECTED] wrote:
Hi,
How to prevent re-attempt ?
(See attached file: logfile2_1118)
[This e-mail is confidential and may also be privileged. If you are
not the
intended recipient, please delete it and notify us immediately; you
should
not copy or use it for any purpose, nor disclose its contents to any
other
person. Thank you.]
--
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) FailureQuery quoted string
Hello Jason -
There is a patch for this in the patches area.
If it doesn't fix the problem please let me know.
regards
Hugh
On Friday, Nov 22, 2002, at 09:35 Australia/Melbourne, Jason Signalness
wrote:
Hello,
I tried to post this a few hours ago, but it didn't show up in the
list for whatever reason. I apologize if it shows up twice.
We make use of to log authentication failures to an SQL
database (Oracle). After upgrading to Radiator v3.3.1, this fails.
The reason is that we use a %1 in the FailureQuery parameter to log
the error. The single quotes that are now a part of %1 (the quoted
reason string for the failure) messes up our SQL syntax.
Is there any way to get just the reason string, without the quotes?
Here's my clause:
# Log authentication FAILURES to the database for customers.
Identifier BTIAuthLoggerSQL
DBSourcedbi:Oracle:
DBUsername
DBAuth
Timeout 10
FailureBackoffTime 60
FailureQueryBEGIN radius.logAppAction('%n','rad','LOGIN
FAILED (%h): %n (%1)','error','%c'); END;
Thanks in advance,
--
Jason Signalness, Systems Administrator
Basin Telecommunications, Inc.
[EMAIL PROTECTED] 1-701-355-5727
--
===
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.
(RADIATOR) FailureQuery quoted string
Hello,
I tried to post this a few hours ago, but it didn't show up in the list
for whatever reason. I apologize if it shows up twice.
We make use of to log authentication failures to an SQL
database (Oracle). After upgrading to Radiator v3.3.1, this fails.
The reason is that we use a %1 in the FailureQuery parameter to log the
error. The single quotes that are now a part of %1 (the quoted reason
string for the failure) messes up our SQL syntax.
Is there any way to get just the reason string, without the quotes?
Here's my clause:
# Log authentication FAILURES to the database for customers.
Identifier BTIAuthLoggerSQL
DBSourcedbi:Oracle:
DBUsername
DBAuth
Timeout 10
FailureBackoffTime 60
FailureQueryBEGIN radius.logAppAction('%n','rad','LOGIN
FAILED (%h): %n (%1)','error','%c'); END;
Thanks in advance,
--
Jason Signalness, Systems Administrator
Basin Telecommunications, Inc.
[EMAIL PROTECTED] 1-701-355-5727
--
===
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 Host definitions in AuthBy LDAP2
Hello Vangelis -
Yes. Have a look at section 6.35 in the Radiator 3.3.1 reference manual
("doc/ref.html").
regards
Hugh
On Thursday, Nov 21, 2002, at 22:56 Australia/Melbourne, Vangelis
Kyriakakis wrote:
Hello,
If I use two LDAP servers in an AuthBy LDAP2 (two Host
attributes)
will Radiator change to the second one when the first one fails?
thanks
Vangelis
===
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.
(RADIATOR) Re: Realm - Cases
Hello Steven - You would use a Handler: . The expression defined by the // is a Perl regexp - check your Perl manual for details. regards Hugh On Thursday, Nov 21, 2002, at 20:31 Australia/Melbourne, [EMAIL PROTECTED] wrote: How to accept different cases for the Realm: Eg: 1234@ICC, 1234@IcC and also sometime the user include space behind Best Regards [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] -- 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) Multiple Host definitions in AuthBy LDAP2
Hello, If I use two LDAP servers in an AuthBy LDAP2 (two Host attributes) will Radiator change to the second one when the first one fails? thanks Vangelis === 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) Several realms logged to same accounting file
Hello, Jesus Rodriguez replied me yesterday. I forgoted that in each realm I have a Rewrite username in order to cut the realm and only check for username (without @realmXXX). Just by cutting this Rewrite, the User-Name logs the entire login (loginY@realmX). Now it is simple for me to modify the autentication database in order to add the @realm into the username. Thank you two very much for your help!! Antonio Hugh Irvine wrote: > Hello Antonio - > > Could you please send me a copy of your current configuration file? > > I will take a look and make some suggestions. > > regards > > Hugh > > On Wednesday, Nov 20, 2002, at 23:10 Australia/Melbourne, Antonio J. > Anton wrote: > > > Hello all, > > > > I have two realms running on same radiator; nowadays I have two > > accounting logfile, one for the first realm and another one for the > > second realm. > > I want to have only one accounting logfile with tickets from both > > realms > > but I need the realm information (need to log User-Name = > > "loginXXX@realm1" or "loginYYY@realm2" or in a different attribute like > > User-Realm = 'realm1' or 'realm2'). > > > > How can I do that? > > Thankyou!!! > > Antonio > > > > === > > 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.
(RADIATOR) Realm - Cases
How to accept different cases for the Realm: Eg: 1234@ICC, 1234@IcC and also sometime the user include space behind Best Regards [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] === 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.
