| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.12.3 |
| Bug #7216 | OCI8 module ignores non-standard port | ||
|---|---|---|---|
| Submitted: | 2006-03-27 13:57 UTC | ||
| From: | andrew_kerr at iamnos dot ca | Assigned: | aharvey |
| Status: | Closed | Package: | DB (version 1.7.6) |
| PHP Version: | 4.4.2 | OS: | Linux (RHEL4) |
| Roadmaps: | (Not assigned) | ||
[2006-03-27 13:57 UTC] andrew_kerr at iamnos dot ca
(Andrew Kerr)
Description:
------------
The OCI8 module will always attempt to connect to port 1521, even if a different port is specified in the DSN.
Test script:
---------------
$dsn = 'oci8://user:pass@10.10.10.1:1522/dbname';
$db =& DB::connect($dsn);
if (DB::isError($db)) {
echo "Failed connection\n";
}
Expected result:
----------------
No error message.
Actual result:
--------------
Failed connection.
A tcpdump shows that it is trying to connect on the default port (1521)
Comments
[2006-03-27 14:07 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2006-03-28 16:23 UTC] tom at greenleaftech dot net
(Tom Haddon)
I'm not sure I understand what you're asking us to do to verify this bug and/or a workaround.
You say "if no port is specified it would simply use
[hostspec]", but the whole point is that we are trying to use a port. Can you advise what string to pass as a $dsn to connect using an instantclient when using an alternate port?
Thanks, Tom
[2006-03-30 19:28 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2006-04-04 11:36 UTC] tom at greenleaftech dot net
(Tom Haddon)
I can confirm that:
$dbtype="oci8";
$dbuser="user";
$dbpass="pass";
$dbhost="///host";
$dbport="port";
$dbname="dbname";
works fine. I'm appending the port as well, as in my case, I'm using a non-standard port.
$oradsn="$dbtype://$dbuser:$dbpass@$dbhost:$dbport/$dbname";
Thanks, Tom
[2006-04-05 15:13 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2006-04-15 10:41 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!
[2007-01-11 02:16 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!