Bug 132577 - databases/oracle8-client: Appearence of connection (php5-oci8) in Oracle Database Manager
Summary: databases/oracle8-client: Appearence of connection (php5-oci8) in Oracle Data...
Status: Closed Overcome By Events
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: Normal Affects Only Me
Assignee: freebsd-ports-bugs (Nobody)
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-03-12 12:10 UTC by Sergey
Modified: 2014-11-23 17:35 UTC (History)
3 users (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Sergey 2009-03-12 12:10:01 UTC
I'm using web-server with php5-oci8 support.

The main problem is that the Oracle Database Manager in the field 'Machine' shows result of `uname -r` without first symbol instead the hostname.
I.e ( first string - Apache in native mode, the problem one, the next string is for Apache in Linux emulation - as it should work):

Machine	Machine	OSUser	Server	SID	Status	Terminal	Type	Program
								
.1-RELEASE								
ELPAY	.1-RELEASE	www	DEDICATED	18	INACTIVE		USER	?  @.1-RELEASE (TNS V1-V3)
								
BORMAN.CAOTUS.RU								
ELPAY	borman.caotus.ru	oracle	DEDICATED	41	ACTIVE		USER	?  @BORMAN.CAOTUS.RU (TNS V1-V3)


The problems with identifying server (when several web-servers with Oracle support and concurrent connections to the same database are used) are rather unpleasant.
Comment 1 Mark Linimon freebsd_committer freebsd_triage 2009-03-12 23:46:41 UTC
State Changed
From-To: open->feedback

To which port does this apply?  (It really helps us out if you put 
category/maintainer in the Synopsis.)
Comment 2 Mark Linimon freebsd_committer freebsd_triage 2009-03-13 07:23:19 UTC
State Changed
From-To: feedback->open

From private email received: 

Date: Fri, 13 Mar 2009 09:25:22 +0300 
Comment 3 Mark Linimon freebsd_committer freebsd_triage 2009-03-13 07:25:14 UTC
Responsible Changed
From-To: freebsd-ports-bugs->fjoe

Over to maintainer of databases/oracle8-client, although the problem could 
also be in databases/php5-oci8.
Comment 4 Carlo Strub freebsd_committer freebsd_triage 2014-08-29 20:13:22 UTC
Not maintained. Back to pool
Comment 5 Carlo Strub freebsd_committer freebsd_triage 2014-08-31 20:16:48 UTC
Is this PR still relevant?
Comment 6 Jean-François BOEUF 2014-10-08 12:50:26 UTC
(In reply to Carlo Strub from comment #5)
> Is this PR still relevant?

In my humble opinion, this really outdated port is candidate to disappear... As well as database/oracle7-client and database/oracle_odbc_driver. An up-to-date database/linux-oracle-instantclient-* port series should be enough to connect most currently operating oracle database versions.
Comment 7 Kurt Jaeger freebsd_committer freebsd_triage 2014-11-23 08:25:50 UTC
(In reply to Jean-François BOEUF from comment #6)
> (In reply to Carlo Strub from comment #5)
> > Is this PR still relevant?
> 
> In my humble opinion, this really outdated port is candidate to disappear...
> As well as database/oracle7-client and database/oracle_odbc_driver. An
> up-to-date database/linux-oracle-instantclient-* port series should be
> enough to connect most currently operating oracle database versions.

Unfortunatly, downloads links given in the port linux-oracle-instantclient-sqlplus
point to a site which returns 404:

http://www.oracle.com/technology/software/tech/oci/instantclient/index.html

Someone needs to update those ports to the new links.
Comment 8 Kurt Jaeger freebsd_committer freebsd_triage 2014-11-23 16:46:18 UTC
(In reply to Jean-François BOEUF from comment #6)
> (In reply to Carlo Strub from comment #5)
> > Is this PR still relevant?
> 
> In my humble opinion, this really outdated port is candidate to disappear...
> As well as database/oracle7-client and database/oracle_odbc_driver.

There are no ports that depend on database/oracle[78]* or oracle_odbc_driver.

So they can be removed with working database/linux-oracle-instantclient-*
Comment 9 Kurt Jaeger freebsd_committer freebsd_triage 2014-11-23 16:47:43 UTC
> There are no ports that depend on database/oracle[78]* or oracle_odbc_driver.

Well, there are a few that depend on database*s*/oracle*, so scratch
that last comment 8-}
Comment 10 Kurt Jaeger freebsd_committer freebsd_triage 2014-11-23 16:56:04 UTC
(In reply to Kurt Jaeger from comment #7)
> Unfortunatly, downloads links given in the port
> linux-oracle-instantclient-sqlplus
> point to a site which returns 404:

Fixed in r373168.
Comment 11 Kurt Jaeger freebsd_committer freebsd_triage 2014-11-23 17:35:06 UTC
As php5-oci8 is no longer in the ports tree, this ticket is closed
as overcome by events.