Re: [PHP-DB] PHP ORACLE SSL ?
Narasimha Gangaiah wrote: Greetings, I am writing a web application using PHP. I want to use PEAR::DB to connect to user database. I want the connection to be secured using SSL. Does oci8.sl (php oracle dblibrary) support SSL connection to Oracle Server ? I know we can securely connect to MYSQL server using PEAR::DB SSL. Is it possible to estable secure connection to oracle server using PHP ? Best Regards Simha The network protocols used by Oracle can encrypt and/or checksum data transfers between Oracle library calls in PHP's oci8 extension and the database server. See http://download.oracle.com/docs/cd/B12037_01/network.101/b10772/asoconfg.htm#1006342 The useful bits are at the bottom of that page where the sample sqlnet.ora files are given (just above tables 3-2 and 3-3). In effect all you need to do is add a couple of configuration lines and restart the network listener to get encrypted traffic. Check your license too: the Advanced Security Option (ASO) is probably a separately licensble product. Chris -- Christopher Jones, Oracle Email: [EMAIL PROTECTED]Tel: +1 650 506 8630 Blog: http://blogs.oracle.com/opal/ Free PHP Book: http://tinyurl.com/f8jad -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP ORACLE SSL ?
Thanks all for your replies. So to secure the connection between oracle server and PHP oci8 client, we have to modify the sqlnet.ora shipped with oracle product ,as suggested by christopher in his reply, and no API or interface is avaialble to do the same via PHP . In the same manual suggested by Chris, I found a link to secure oracle connection using SSL . ( http://download.oracle.com/docs/cd/B14117_01/network.101/b10772/asossl.htm#1006120). Christopher Jones wrote: Narasimha Gangaiah wrote: Greetings, I am writing a web application using PHP. I want to use PEAR::DB to connect to user database. I want the connection to be secured using SSL. Does oci8.sl (php oracle dblibrary) support SSL connection to Oracle Server ? I know we can securely connect to MYSQL server using PEAR::DB SSL. Is it possible to estable secure connection to oracle server using PHP ? Best Regards Simha The network protocols used by Oracle can encrypt and/or checksum data transfers between Oracle library calls in PHP's oci8 extension and the database server. See http://download.oracle.com/docs/cd/B12037_01/network.101/b10772/asoconfg.htm#1006342 The useful bits are at the bottom of that page where the sample sqlnet.ora files are given (just above tables 3-2 and 3-3). In effect all you need to do is add a couple of configuration lines and restart the network listener to get encrypted traffic. Check your license too: the Advanced Security Option (ASO) is probably a separately licensble product. Chris -- Christopher Jones, Oracle Email: [EMAIL PROTECTED]Tel: +1 650 506 8630 Blog: http://blogs.oracle.com/opal/ Free PHP Book: http://tinyurl.com/f8jad -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- View this message in context: http://www.nabble.com/PHP-ORACLE-SSL---tf4208442.html#a11991531 Sent from the Php - Database mailing list archive at Nabble.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP ORACLE SSL ?
Narasimha Gangaiah wrote: Greetings, I am writing a web application using PHP. I want to use PEAR::DB to connect to user database. I want the connection to be secured using SSL. Does oci8.sl (php oracle dblibrary) support SSL connection to Oracle Server ? I know we can securely connect to MYSQL server using PEAR::DB SSL. Is it possible to estable secure connection to oracle server using PHP ? If you're using pear, the pear guys would be able to help a lot more: http://pear.php.net/support/lists.php -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php