(RADIATOR) Rodopi & Radiator

Thu Feb 6 16:15:56 CST 2003

Hello Tim,

On Fri, 7 Feb 2003 08:54 am, Tim Jung wrote:
> Ok I changed mt freetds.conf file to read:
> [rodopi]
>         host = 206.142.60.100
>         port = 1433
>         tds version = 7.0
>
> Which makes it the exact same format as your listed freetds.conf file and
> it is still no go.
>
> Ok I removed the NT "rodopi" account so now there is only the "rodopi"
> account in SQL. The really interesting thing is that if I login as "rodopi"
> via SQL it causes Radiator to lock up. I get the trace below for the first
> test request and then nothing when I try to do a second request. So there
> is certainly something hosed on the Radiator/Linux side of things. Why
> would it let me login and then "lock up" when it tries to do the stored
> procedure?

I dont understand that. It looks like the SQL server has locked or blocked 
access to the stored procedure or the tables it accesses.

Im pretty sure this is not due to a problem in Radiator or freetds, but 
something about the SQL server configuration. Im not sure how to proceed from 
here. 

Is it possible to get remote access to your Radiator host by ssh and/or your 
SQL server by pcanywhere or whatever?

Cheers.

>
> Tim Jung
> System Admin
> Internet Gateway
> tjung at igateway.net
>
>
> ----- Original Message -----
> From: "Mike McCauley" <mikem at open.com.au>
> To: "Tim Jung" <tjung at igateway.net>; <radiator at open.com.au>
> Cc: <hugh at open.com.au>; <dbirkbeck at ikano.com>
> Sent: Thursday, February 06, 2003 2:04 AM
> Subject: Re: (RADIATOR) Rodopi & Radiator
>
> > Hi Tim,
> >
> > Is it possible that you need to alter the freetds.conf configuration,
>
> removing
>
> > any domain login information etc.
> >
> > This is how we have our freetds.conf set up for access to MS-SQL from
>
> Unix:
> > [uniform]
> >         host = 203.63.154.24
> >        port = 1433
> >        tds version = 7.0
> >
> >
> > (the name of the host is uniform) So perhaps you need:
> >
> >  [Rodopi]
> >         host = billing.igateway.net
> >          port = 1433
> >          tds version = 7.0
> >
> > Cheers.
>
> ------------------ Radiator Debug ------------------------------
>
> /usr/bin/radiusd -config_file /etc/radiator/radius.cfg
> Thu Feb  6 17:20:11 2003: DEBUG: Finished reading configuration file
> '/etc/radiator/radius.cfg'
> This Radiator license will expire on 2003-06-01
> This Radiator license will stop operating after 1000 requests
> To purchase an unlimited full source version of Radiator, see
> http://www.open.com.au/ordering.html
> To extend your evaluation period, contact admin at open.com.au
>
> Thu Feb  6 17:20:11 2003: DEBUG: Reading dictionary file
> '/etc/radiator/dictionary'
> Thu Feb  6 17:20:12 2003: DEBUG: Creating authentication port 0.0.0.0:1645
> Thu Feb  6 17:20:12 2003: DEBUG: Creating accounting port 0.0.0.0:1646
> Thu Feb  6 17:20:12 2003: INFO: Server started: Radiator 3.5 on
> radius.igateway.net (DEMO)
> Thu Feb  6 17:20:19 2003: DEBUG: Packet dump:
> *** Received from 206.142.60.79 port 1091 ....
>
> Packet length = 108
> 01 21 00 6c 31 32 33 34 35 36 37 38 39 30 31 32
> 33 34 35 36 01 18 74 65 73 74 69 6b 61 6e 6f 40
> 69 67 61 74 65 77 61 79 2e 6e 65 74 06 06 00 00
> 00 02 04 06 cb 3f 9a 01 05 06 00 00 04 d2 1e 0b
> 31 32 33 34 35 36 37 38 39 1f 0b 39 38 37 36 35
> 34 33 32 31 3d 06 00 00 00 00 02 12 42 05 d9 e1
> 00 3c e1 71 a9 ae 09 a1 07 78 87 21
> Code:       Access-Request
> Identifier: 33
> Authentic:  1234567890123456
> Attributes:
>         User-Name = "testikano at igateway.net"
>         Service-Type = Framed-User
>         NAS-IP-Address = 203.63.154.1
>         NAS-Port = 1234
>         Called-Station-Id = "123456789"
>         Calling-Station-Id = "987654321"
>         NAS-Port-Type = Async
>         User-Password =
> "B<5><217><225><0><<225>q<169><174><9><161><7>x<135>!"
>
> Thu Feb  6 17:20:19 2003: DEBUG: Handling request with Handler
> 'Realm=igateway.net'
> Thu Feb  6 17:20:19 2003: DEBUG: Rewrote user name to testikano
> Thu Feb  6 17:20:19 2003: DEBUG:  Deleting session for
> testikano at igateway.net, 203.63.154.1, 1234
> Thu Feb  6 17:20:19 2003: DEBUG: Handling with Radius::AuthRODOPI
> Thu Feb  6 17:20:19 2003: DEBUG: Handling with Radius::AuthRODOPI:
> Thu Feb  6 17:20:19 2003: DEBUG: Query is: exec Interface_VircomUsers
> 'testikano'

-- 
Mike McCauley                               mikem at open.com.au
Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
Phone +61 3 9598-0985                       Fax   +61 3 9598-0955

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, 
TTLS, PEAP etc on Unix, Windows, MacOS etc.

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