URGENT! Dialupadmin "Could not connect to SQL database"
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. Please help. Thank you.* *
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
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
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
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
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@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@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
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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@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
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@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@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
participants (3)
-
Edoardo Causarano -
Guilherme Franco -
Peter Nixon