RE: (Fwd) RE: (RADIATOR) (Fwd) can i have two accounting tables?

2000-10-16 Thread Hakim Tass
hi Hugh!!! I am sorry about the wrong email address, and I apologize for the inconvience that might have caused to you. well this is what exactly i want to do. We are planning to have two different type of subscription scheme. In the first scheme the subscription is charged on hourly basis while

Re: Fwd: (RADIATOR) Oracle to_date with integer-date's DateFormat?

2000-10-16 Thread Mike McCauley
Hello Frederik, For Oracle date columns, you should use formatted-date: AcctColumnDef SDATE,Timestamp,formatted-date,to_date('%e %m %Y %H:%M:%S', 'DD MM HH24:MI:SS') Hope that helps. Cheers. On Oct 17, 2:53pm, Hugh Irvine wrote: > Subject: Fwd: (RADIATOR) Oracle to_date with integer-

Re: (RADIATOR) Cisco AS5300 ISDN Ports

2000-10-16 Thread Hugh Irvine
Hello David - On Tue, 17 Oct 2000, David Lloyd wrote: > Has anyone ever had any luck getting Radiator to talk SNMP with an > AS5300 with ISDN, that gives high port numbers (200xx) for the > NAS-Port? The normal MIB (.1.3.6.1.4.1.9.2.9.2.1.18) works fine for > analog (Async) calls, but when an I

Re: (Fwd) RE: (RADIATOR) (Fwd) can i have two accounting tables?

2000-10-16 Thread Hugh Irvine
Hello Hakim - Could you please send your mail to "[EMAIL PROTECTED]" please (not [EMAIL PROTECTED])? Thanks. > > hi Hugh!!! > > I did try that before putting in my question to the mailing list. > But some how the accounting is being done in the first clause > that i mention. > I am writing b

Re: (RADIATOR) Update table with check/reply attributes from perl script

2000-10-16 Thread Hugh Irvine
Hello Stephen - On Tue, 17 Oct 2000, Delanet Administration wrote: > I'm trying to write a script that pulls in reply attributes from a MSSQL > (Platypus) database and inserts them into an existing SUBSCRIBERS table > on a MySQL database. I've got everything working fine down to one part.. > The

Re: (RADIATOR) Load Balancing Radiator

2000-10-16 Thread Hugh Irvine
Hello Chris - On Tue, 17 Oct 2000, Chris wrote: > I'm trying to load balance radiator across three seperate servers > with an Extreme Summit 7i switch. All servers respond correctly to > requests out of the server farm. However when put in the server farm they > respond to the authentication r

Re: (RADIATOR) 2 questions about SessionDatabase SQL

2000-10-16 Thread Hugh Irvine
Hello Gildas - On Tue, 17 Oct 2000, Gildas PERROT wrote: > Hi, > > I would like to modify SQL queries for SessionDatabase SQL since sometimes, > one field (Calling-Station-Id or CALLINGID) is empty as you can see below : > > Mon Oct 16 19:01:59 2000: ERR: do failed for 'insert into ONLINE (USE

Re: (RADIATOR) Unknown error

2000-10-16 Thread Hugh Irvine
Hello Cortney - On Tue, 17 Oct 2000, Cortney Thompson wrote: > I was wondering if you could help me out with this error. I am not sure > why I get it. The nas does have a reverse DNS Lookup, but I don't have any > nastype's configured? > > Mon Oct 16 15:03:41 2000: WARNING: SDB1 Could not f

Re: (RADIATOR) Proxy getting no reply

2000-10-16 Thread Hugh Irvine
On Tue, 17 Oct 2000, Lisa Goulet wrote: > Hello, > > I have a simple set up with one Radiator master and one proxy. When > testing with radpwtst I'm getting a "no reply". I've double checked the ip > address, secret and the ports. I don't see much in the log files. Here are > my configs: >

(RADIATOR) Cisco AS5300 ISDN Ports

2000-10-16 Thread David Lloyd
Has anyone ever had any luck getting Radiator to talk SNMP with an AS5300 with ISDN, that gives high port numbers (200xx) for the NAS-Port? The normal MIB (.1.3.6.1.4.1.9.2.9.2.1.18) works fine for analog (Async) calls, but when an ISDN call comes in and arrives on a high port number, the SNMP ge

Re: (RADIATOR) Load Balancing Radiator

2000-10-16 Thread Ron Hensley
That is odd. I didnt mention it, but I also use load balancing, though with a Linux Server doing the clustering rather then a layer 2 switch. Same concept though, it intercepts the packets destined for the radius server ip address, and redirects them to the cluster nodes, who have the ips bound as

(RADIATOR) Unknown error

2000-10-16 Thread Cortney Thompson
I was wondering if you could help me out with this error. I am not sure why I get it. The nas does have a reverse DNS Lookup, but I don't have any nastype's configured? Mon Oct 16 15:03:41 2000: WARNING: SDB1 Could not find a Client for NAS 204.227.210.1 to double-check Simultaneous-Use. Per

(RADIATOR) Update table with check/reply attributes from perl script

2000-10-16 Thread Delanet Administration
I'm trying to write a script that pulls in reply attributes from a MSSQL (Platypus) database and inserts them into an existing SUBSCRIBERS table on a MySQL database. I've got everything working fine down to one part.. The UPDATE statement fails to put the correct data in, and instead cuts short at

Re: (RADIATOR) Load Balancing Radiator

2000-10-16 Thread Chris
I tried this, so also to listen only on that ip, however this also did not appear to work possibly because the ip is bound to the loopback (it has to be bound to the loopback because of the method of load balancing the Summit 7i is doing. So when I did this, radiator only responded to requests o

Re: (RADIATOR) Load Balancing Radiator

2000-10-16 Thread Ron Hensley
In the main global section BindAddress 10.0.0.1 Thats the one for the normal auth/accounting information to listen and respond with. Make it whichever ip bound to the nic, you want it to use and reload. - Original Message - From: "Chris" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> S

Re: (RADIATOR) RE: Proxy getting no reply

2000-10-16 Thread Ron Hensley
If you haven't overridden it in the radius.cfg file, then its getting its default ports from the /etc/services file If you edit that file to have 1645 and 1646 instead of 1812 and 1813(?) and restart radius, it should bind to those ports. You can also override the /etc/services file by adding to

(RADIATOR) Load Balancing Radiator

2000-10-16 Thread Chris
I'm trying to load balance radiator across three seperate servers with an Extreme Summit 7i switch. All servers respond correctly to requests out of the server farm. However when put in the server farm they respond to the authentication request with the ethernet ip even though the reque

(RADIATOR) 2 questions about SessionDatabase SQL

2000-10-16 Thread Gildas PERROT
Hi, I would like to modify SQL queries for SessionDatabase SQL since sometimes, one field (Calling-Station-Id or CALLINGID) is empty as you can see below : Mon Oct 16 19:01:59 2000: ERR: do failed for 'insert into ONLINE (USERNAME, NASIDENTIFIER, NASPORT, ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRE

(RADIATOR) RE: Proxy getting no reply

2000-10-16 Thread Lisa Goulet
Hello again, I fixed the problem by defaulting all the ports (to 1645). Thanks, Lisa > -Original Message- > From: Lisa Goulet > Sent: Monday, October 16, 2000 4:58 PM > To: 'Radiator@Open. Com. Au' > Subject: RE: Proxy getting no reply > > > Hello again, > > Here's a follow u

(RADIATOR) RE: Proxy getting no reply

2000-10-16 Thread Lisa Goulet
Hello again, Here's a follow up question. Now I'm seeing on the console that the proxy server is sending on port 1645. Both servers are listening on 1812. Where is the sending port configured? Thanks again, Lisa > -Original Message- > From: Lisa Goulet > Sent: Monday, October 16, 20

(RADIATOR) Proxy getting no reply

2000-10-16 Thread Lisa Goulet
Hello, I have a simple set up with one Radiator master and one proxy. When testing with radpwtst I'm getting a "no reply". I've double checked the ip address, secret and the ports. I don't see much in the log files. Here are my configs: Proxy: Trace 4

(RADIATOR) Oracle to_date with integer-date's DateFormat?

2000-10-16 Thread Anheuser, Frederik {POYN~Kaiseraugst}
Hi, I would like to store Radius accounting data into an Oracle SQL database. However, I cannot get the necessary "to_date" conversion to work with the (new) configurable integer-date accounting column definition format, the quotes are always at the wrong place. Can anybody send me a piece of

Re: (RADIATOR) AuthLDAPSDK Timing bug?

2000-10-16 Thread Hugh Irvine
Hello Karel - On Mon, 16 Oct 2000, [EMAIL PROTECTED] wrote: > Hello All, > > I have the following experience using: > > Radiator 2.16.1 including patches on either W2K/NT > > When an LDAPSDK authentication handler has not been spoken to for some time > (about 15 to 30 minutes, further investi

(RADIATOR) AuthLDAPSDK Timing bug?

2000-10-16 Thread c . w . vandervelden
Hello All, I have the following experience using: Radiator 2.16.1 including patches on either W2K/NT When an LDAPSDK authentication handler has not been spoken to for some time (about 15 to 30 minutes, further investigation will tell us the exact amount of time) it doesn't react correctly anymo