URGENT! Dialupadmin "Could not connect to SQL database"

[Guilherme Franco]

Ok Peter,

It's 10g.

But why my test.php worked in cli mode, even without the sqlplus working?

Another test, in oracle/functions.php3, I changed the $config[sql_username]
for the real username. After doing that, I can see communications with the
oracle server with tcpdump, but the pages appears blank...

So, it's not totally oracle's fault.

Anyway, I'm desperate for fix this!

HELP!

On 8/31/06, Peter Nixon <listuser at peternixon.net> wrote:
>
> We made the changes to dialup_admin to make it work with oracle, however I
> am
> afraid you are going to have to solve the problems with your Oracle
> installation yourself.
>
> The first thing you need to do is get sqlplus working, then PHP.
>
> For your info, we have it working fine with Oracle 10g. If you are running
> an
> older version you are on your own :-)
>
> Cheers
>
> Peter
>
> On Thu 31 Aug 2006 17:16, Guilherme Franco 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
>
> --
>
> 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
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20060831/652a3e35/attachment.html>