[prev in list] [next in list] [prev in thread] [next in thread]
List: freeradius-users
Subject: Re: URGENT! Dialupadmin "Could not connect to SQL database"
From: Edoardo Causarano <curious.corn () katamail ! com>
Date: 2006-09-01 6:47:52
Message-ID: 20060901064740.096598 () host169-198 ! pool8249 ! interbusiness ! it
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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@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@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
[Attachment #5 (unknown)]
<HTML><BODY style="word-wrap: break-word; -khtml-nbsp-mode: space; -khtml-line-break: \
after-white-space; ">Make sure you pass the checklist on <A \
href="http://ora-12154.ora-code.com">http://ora-12154.ora-code.com</A>/ 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<DIV><BR class="khtml-block-placeholder"></DIV><DIV>e</DIV><DIV> <BR><DIV><DIV>On \
31/ago/06, at 16:38GMT+02:00, Guilherme Franco wrote:</DIV><BR \
class="Apple-interchange-newline"><BLOCKQUOTE type="cite">Mr. Peter,<BR><BR>I did a \
test right now with the command line "php", for example "php test.php" and it \
works!<BR><BR>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) \
<BR><BR>But when I try to open test.php from the apache web page, it states <B>Parse \
error</B>: syntax error, unexpected '>' in <B>/www/htdocs/test.php</B> on line \
<B>10 </B>(then, tcpdump in oracle server shows nothing)<B><BR><SPAN \
style="font-weight: bold;"><SPAN style="font-weight: bold;"><SPAN style="font-weight: \
bold;"><BR></SPAN></SPAN></SPAN> </B>I think that the same problem is blocking \
dialupadmin from connecting with oracle.<B><SPAN style="font-weight: \
bold;"><BR><BR></SPAN><SPAN style="font-weight: bold;"><SPAN style="font-weight: \
bold;"></SPAN></SPAN></B> What might it be?<BR><BR>Thanks.<BR><B><SPAN \
style="font-weight: bold;"><SPAN style="font-weight: \
bold;"></SPAN></SPAN><BR></B><BR><DIV><SPAN class="gmail_quote">On 8/31/06, <B \
class="gmail_sendername">Guilherme Franco</B> <<A \
href="mailto:guilhermefranco@gmail.com">guilhermefranco@gmail.com</A>> \
wrote:</SPAN><BLOCKQUOTE class="gmail_quote" style="border-left: 1px solid rgb(204, \
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> <DIV>Hello,<BR><BR>Yes, I \
configured it with the option "--with-oci8", and phpinfo() shows oci8 support as \
enabled.<BR><BR>This machine (dialupadmin server) is standalone (oracle in other \
server and radius in other). <BR> <BR>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.<BR><BR>I've researched a lot about this problems but found nothing. \
<BR><BR>note: (I've read somewhere that oci does not work well with modules, just \
with static php links)<BR><BR>Please help.<BR><BR>Thank you very \
much.<BR><BR><DIV></DIV><DIV><SPAN class="e" id="q_10d64969eaf544b3_1"><SPAN \
class="gmail_quote"> On 8/31/06, <B class="gmail_sendername"> Peter Nixon</B> <<A \
href="mailto:listuser@peternixon.net" target="_blank" onclick="return \
top.js.OpenExtLink(window,event,this)">listuser@peternixon.net</A>> \
wrote:</SPAN></SPAN></DIV><DIV><BLOCKQUOTE class="gmail_quote" style="border-left: \
1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> \
</BLOCKQUOTE></DIV><DIV><SPAN class="e" id="q_10d64969eaf544b3_3"> On Thu 31 Aug 2006 \
16:17, Guilherme Franco wrote:<BR>> URGENT!<BR>><BR>> Hi,<BR>><BR>> \
I'm getting this error *Could not connect to SQL database. *in dialupadmin.<BR>> \
(using OCI8 with ORACLE)<BR>> * <BR> > *Radiusd connects to Oracle without any \
problems, dialupadmin don't.<BR><BR>Does your PHP module have Oracle \
support?<BR><BR>--<BR><BR>Peter Nixon<BR><A href="http://www.peternixon.net/" \
target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"> \
http://www.peternixon.net/</A> <BR>PGP Key: <A \
href="http://www.peternixon.net/public.asc" target="_blank" onclick="return \
top.js.OpenExtLink(window,event,this)">http://www.peternixon.net/public.asc</A><BR><BR><BR></SPAN></DIV><DIV>-<BR>List \
info/subscribe/unsubscribe? See <A href="http://www.freeradius.org/list/users.html" \
target="_blank" onclick="return \
top.js.OpenExtLink(window,event,this)">http://www.freeradius.org/list/users.html \
</A><BR><BR><BR></DIV><BR> </DIV></BLOCKQUOTE></DIV><BR><DIV style="margin-top: 0px; \
margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">-<SPAN \
class="Apple-converted-space"> </SPAN></DIV><DIV style="margin-top: 0px; \
margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">List \
info/subscribe/unsubscribe? See <A \
href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</A></DIV> \
</BLOCKQUOTE></DIV><BR></DIV></BODY></HTML>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic