URGENT! Dialupadmin "Could not connect to SQL database"

[Guilherme Franco]

Thanks,

I've already managed to make it work using oracle instant client and custom
tnsnames.ora. I was using the entire oracle enterprise install before and it
didn't work! Crazy, but it's working now.

Thanks.

On 9/1/06, Edoardo Causarano <curious.corn at katamail.com> wrote:
>
> Make sure you pass the checklist on http://ora-12154.ora-code.com/
> Personally I've seen oracle clients that suddenly refuse to work because it
> decides that it wants ip<->name mappings. Usually a trip to the dns or
> /etc/hosts solves the prob
> e
>
> On 31/ago/06, at 16:38GMT+02:00, Guilherme Franco wrote:
>
> Mr. Peter,
>
> I did a test right now with the command line "php", for example "php
> test.php" and it works!
>
> test.php is a program I've created to retrieve some tables from the oracle
> server. (tcpdump  in oracle server shows traffic correctly this way)
>
> But when I try to open test.php from the apache web page, it states *Parse
> error*: syntax error, unexpected '>' in */www/htdocs/test.php* on line *10
> *(then, tcpdump in oracle server shows nothing)*
>
> *I think that the same problem is blocking dialupadmin from connecting
> with oracle.*
>
> * What might it be?
>
> Thanks.
>
>
> *
> *
> On 8/31/06, Guilherme Franco <guilhermefranco at gmail.com> wrote:
> >
> > Hello,
> >
> > Yes, I configured it with the option "--with-oci8", and phpinfo() shows
> > oci8 support as enabled.
> >
> > This machine (dialupadmin server) is standalone (oracle in other server
> > and radius in other).
> >
> > I'm trying to use sqlplus from the dialupadmin server but it gives me
> > either ORA-12546 TNS permission denied or ORA-12514 TNS listener does not
> > currently know of service requested in connect descriptor.
> >
> > I've researched a lot about this problems but found nothing.
> >
> > note: (I've read somewhere that oci does not work well with modules,
> > just with static php links)
> >
> > Please help.
> >
> > Thank you very much.
> >
> > On 8/31/06, Peter Nixon <listuser at peternixon.net> wrote:
> >
> > >  On Thu 31 Aug 2006 16:17, Guilherme Franco wrote:
> > > URGENT!
> > >
> > > Hi,
> > >
> > > I'm getting this error *Could not connect to SQL database. *in
> > dialupadmin.
> > > (using OCI8 with ORACLE)
> > > *
> > > *Radiusd connects to Oracle without any problems, dialupadmin don't.
> >
> > Does your PHP module have Oracle support?
> >
> > --
> >
> > Peter Nixon
> > http://www.peternixon.net/
> > PGP Key: http://www.peternixon.net/public.asc
> >
> >
> > -
> > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> >
> >
> >
> >
> >
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20060901/29e3a4cb/attachment.html>