(RADIATOR) Rodopi & Radiator

[Mike McCauley]

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.



On Thu, 6 Feb 2003 06:23 pm, Tim Jung wrote:
> Ok I setup a whole new user just in SQL and made it also the owner of the 2
> Rodopi databases. I can connect with the new account "linux" and
> authenticate, but I still get all the can't find stored procedure errors. I
> even double checked to see what permissions the "sa" account had on those 2
> Rodopi databases (AbacBill and AbacPay) and the "linux" account has the
> same two, "db owner" and "public". I don't see the problem here at all. I
> even went in to the stored procedures and gave linux the EXEC
> bit/permission for those stored procedures. I have no clue what to do now.
>
> I even went in to Rodopi and told it to use TCP/IP sockets rather than
> pipes and everything works just fine. So it does not appear to be an issue
> with TCP/IP not working correctly.
>
> Anyone have any clue why this would be?
>
> 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>; "Hugh Irvine" <hugh at open.com.au>
> Cc: <radiator at open.com.au>; "Dave Birkbeck" <dbirkbeck at ikano.com>
> Sent: Thursday, February 06, 2003 1:06 AM
> Subject: Re: (RADIATOR) Rodopi & Radiator
>
> > Hello Tim,
> >
> > On Thu, 6 Feb 2003 05:59 pm, Tim Jung wrote:
> > > If I try and login as the "sa" or turn off/disable the NT "rodopi"
>
> account
>
> > > and still tell it to do a domain login, so it is forced to use the SQL
> > > "rodopi" account right? I get this error message:
> >
> > Im not sure.
> > Perhaps you should use a password based login to SQL server?
> >
> > > DBI connect('Rodopi','rodopi',...) failed: Server message number=18452
> > > severity=14 state=1 line=0 text=Login failed for user '(null)'. Reason:
>
> Not
>
> > > associated with a trusted SQL Server connection.OpenClient message:
>
> LAYER =
>
> > > (0) ORIGIN = (0) SEVERITY = (78) NUMBER = (36)
> > >
> > > What exactly does this mean, and how would I go about fixing this
>
> error?
>
> > > Tim Jung
> > > System Admin
> > > Internet Gateway
> > > tjung at igateway.net
> > >
> > >
> > > ----- Original Message -----
> > > From: "Mike McCauley" <mikem at open.com.au>
> > > To: "Hugh Irvine" <hugh at open.com.au>; "Tim Jung" <tjung at igateway.net>
> > > Cc: <radiator at open.com.au>; "Dave Birkbeck" <dbirkbeck at ikano.com>
> > > Sent: Thursday, February 06, 2003 12:08 AM
> > > Subject: Re: (RADIATOR) Rodopi & Radiator
> > >
> > > > Hello Tim,
> > > >
> > > > Hmmm, it appears that the  Interface_VircomUsers stored procedure is
>
> not
>
> > > > present in your database (or perhaps you dont have permission to run
>
> it).
>
> > > > Can you confiirm whether or not such a stored procedure exists in
>
> your
>
> > > > dbi:Sybase:Rodopi database (it should have been installed by the
>
> rodopi
>
> > > > installation).
> > > >
> > > > Can you confirm that the username rodopi has permission to run that
> > >
> > > stored
> > >
> > > > procedure?
> > > >
> > > > Cheers.
> >
> > --
> > 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.

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