Zend_Db in ZFW 1.5 requires hostname?

[Philip G]

Some parts of this message have been removed. Learn more about Nabble's security policy.

I'm running into a bit of a two part issue with Zend_Db.

The issue is this: initially, we used ZFW 1.0 for different sites. Zend_Db_Adapter_Pdo_Oci created Oracle DSNs using the old format: dsn://host:port/dbname. This works just fine with: dsn://dbname

In ZFW 1.5, that took a 180 and used a TNS Address format: dbname=(DESCRIPTION=(ADDRSES_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<host>)(PORT=<port>)(CONNECT_DATA=(SID=<dbname)))

Well ... there's a slight issue here. With our config file, we never supplied the hostname. However, in 1.5, if we don't supply the hostname name, I get the error:

exception 'Zend_Db_Adapter_Exception' with message 'SQLSTATE[HY000]: pdo_oci_handle_factory: ORA-12533: TNS:illegal ADDRESS parameters

 (/usr/src/php-5.2.4/ext/pdo_oci/oci_driver.c:513)

DNS: oci:dbname=(DESCRIPTION=(CONNECT_DATA=(SID=<dbname>)))

But, if I add the hostname/port to the config file, the 1.0 code then errors out with TNS Timeout errors...

A bit of a quandry here. The two code bases are not compatiable.  One requires hostname:port and the other will not work if I specify it. Any suggestions on how to fix this? They both use the same config file. The TNS file works file, or else the "dsn://dbname" wouldn't never work. However, the optional dbname seems to break PDO in ZFW 1.5.

I did a google on the error and everybody suggested the same thing: supply the hostname. Which then ends up negating the whole purpose of a TNS names file. And by-passing that file is a bad idea.

--
Philip
gp@...
http://www.gpcentre.net/