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
> [EMAIL PROTECTED]
>
>
> ----- Original Message -----
> From: "Mike McCauley" <[EMAIL PROTECTED]>
> To: "Tim Jung" <[EMAIL PROTECTED]>; "Hugh Irvine" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>; "Dave Birkbeck" <[EMAIL PROTECTED]>
> 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
> > > [EMAIL PROTECTED]
> > >
> > >
> > > ----- Original Message -----
> > > From: "Mike McCauley" <[EMAIL PROTECTED]>
> > > To: "Hugh Irvine" <[EMAIL PROTECTED]>; "Tim Jung" <[EMAIL PROTECTED]>
> > > Cc: <[EMAIL PROTECTED]>; "Dave Birkbeck" <[EMAIL PROTECTED]>
> > > 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 [EMAIL PROTECTED]
> > 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 [EMAIL PROTECTED]
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 [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
