Re: URGENT! Dialupadmin "Could not connect to SQL database"
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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 < [EMAIL PROTECTED]> 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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: URGENT! Dialupadmin "Could not connect to SQL database"
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 probe 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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
Re: URGENT! Dialupadmin "Could not connect to SQL database"
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 < [EMAIL PROTECTED]> 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 Oracleinstallation 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 :-)CheersPeterOn 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 < [EMAIL PROTECTED]> 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 Nixonhttp://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
Re: URGENT! Dialupadmin "Could not connect to SQL database"
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 <[EMAIL PROTECTED]> 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 pgpQELm4ALEsR.pgp Description: PGP signature - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
Re: URGENT! Dialupadmin "Could not connect to SQL database"
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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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
Re: URGENT! Dialupadmin "Could not connect to SQL database"
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 <[EMAIL PROTECTED]> 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 Nixonhttp://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
Re: URGENT! Dialupadmin "Could not connect to SQL database"
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 pgp3gJXSB7dTB.pgp Description: PGP signature - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
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. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html