(RADIATOR) Rodopi & Radiator

[Tim Jung]

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.

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