[webstack-discuss] Additional PHP extensions for SXDE

[Tracy, John]

You are correct regarding the Oracle drivers--I had to download the
"Oracle Instant Client" to add the support to PHP. I have been using the
MSSQL drivers in light production with no issues. It took me a few days
of bumbling around to get the support for MSSQL and Oracle added, so if
we could add these features right of the box, I'm sure it would help a
few folks.

Once I got it all working, the first thing I did was send example
connect strings (for each DB type) and such to all of our web
programmers (for which they were immensely grateful). I think it might
be helpful to include these example connect strings in any
documentation. What does the group think?

-John

-----Original Message-----
From: Sriram.Natarajan at Sun.COM [mailto:Sriram.Natarajan at Sun.COM] 
Sent: Thursday, October 25, 2007 4:23 PM
To: Tracy, John 
Cc: webstack-discuss at opensolaris.org
Subject: Re: [webstack-discuss] Additional PHP extensions for SXDE

Hi John
 Thanks for your response. It is nice to know that customers are indeed 
interested in MSSQL server support. I will start looking into the cost 
of integrating this extension . With respect MySQL and LDAP , these 
extensions will definitely be added in the upcoming integration.  With 
respect to Oracle database support - If I am not mistaken, one will need

to have Oracle client libraries installed on the system to add support 
for Oracle database. I will need to find out the licensing requirements.

Now, if integrate support for unixODBC or iODBC - then one should be 
able to use the ODBC driver manager and talk to these databases. I am 
not sure on the performance and stability aspect of these ODBC driver 
manager - I will definitely investigate on this as well.
 
 Our current integration already has support for GD libraries in 
2007/168 ARC case.
 
thanks
sriram

Tracy, John wrote:
> Hello Sriram-
>
> We are using Ldap, Mysql, and MSSQL (through FreeTDS). It would be
nice,
> although I believe impossible, if Oracle extensions were added (don't
> know about licensing and all that...). We seem to like our many
> different DB platforms around here...
>
> Are the GD libraries included in the existing ARC case?
>
> Thanks for asking-
> John
>
> -----Original Message-----
> From: webstack-discuss-bounces at opensolaris.org
> [mailto:webstack-discuss-bounces at opensolaris.org] On Behalf Of Sriram
> Natarajan
> Sent: Thursday, October 25, 2007 4:58 AM
> To: Webstack Discuss
> Subject: [webstack-discuss] Additional PHP extensions for SXDE
>
> HI
>  As we all know, PHP 5.2.4 has been integrated within SXDE build 73 
> onwards. This integration is based on previously approved ARC case : 
> PSARC/2007/552
> and PSARC/2007/168.    Some very useful PHP extensions like CGI / 
> FastCGI, LDAP, Kerberos, MySQL, Pear etc are not included within our 
> current integration. So, I am hoping that we can file additional ARC 
> case to track these new extensions.    So, here are the additional 
> extensions that I am considering to add support for. Please take a
look 
> at the below list and let us know your thoughts.
>
> - inifile -> Ability to read PHP INI file programmatically
>
> - cgi  / fastcgi ->  Support PHP to run in CGI or FastCI environment. 
> For example, this could allow Apache Worker MPM to execute PHP in 
> FastCGI environment.
>
> - dbase ->  Adds support for leveraging the bundled DBase library
>
> - flatfile  -> Adds support for different file based databases
>
> - ndb / cdb -> Abstraction layer for leveraging the bundled database 
> libraries.
>
> - SQLite -> Adds support for SQLite database. SQLite is a small C 
> library that implements a self-contained, embeddable,
zero-configuration
>
> SQL database engine.
>
> - mysql - MySQL support . This can be added as soon as MySQL support 
> gets integrated within SXDE
>
> - xdebug -> Adds debugging support through IDE like Netbeans
>
> - pdo / pdo-sqlite -> Enable PHP data objects support.  Also enables 
> SQLite database to be accessed as PHP objects.
>
> - pear ->  Allows PHP programmers to dynamically download and install 
> 3rd party PHP extensions that are available from either pecl.php.net
or 
> pear.php.net
>
> - ldap / kerberos -> Authentication support for php programmers.  Uses

> Sun's LDAP and Kerberbos libraries here.
>
> - pspell -> Dictionary support for programmers
>
> - snmp - Add snmp support for  PHP programmers
>
> Here are the other popular extensions that we cannot still add support

> at this time because of missing 3rd party library dependency
>
> - unixODBC  - Need unixODBC libraries
>
> - gdbm / qdbm -> Need external native database library that is not 
> bundled within PHP.
>
> - ncurses -> Need ncurses library in /usr/sfw
>
> - readline -> Need readline library in /usr/gnu
>
> - imap  -> Need IMAP library in /usr/sfw
>
> - gmp -> Needs GNU MP library in /usr/gnu
>
> - mssql[=DIR]      Includes support for Microsoft SQL Server. 
> Unfortunately, this requires FreeTDS libraries to be installed in
> /usr/sfw
>
> - unixODBC/ iODBC -> support for ODBC Driver Manager. Again, this 
> requires appropriate native libraries to be installed within Solars.
>
> If you happen to know any popular extension that is not captured in
the 
> above list, please please let us know. This information could be
useful 
> in determining what other extensions to include so that PHP developers

> can comfortably develop and deploy PHP based web applications on
> Solaris.
>
> thanks
> sriram
> _______________________________________________
> webstack-discuss mailing list
> webstack-discuss at opensolaris.org
> http://mail.opensolaris.org/mailman/listinfo/webstack-discuss
> _______________________________________________
> webstack-discuss mailing list
> webstack-discuss at opensolaris.org
> http://mail.opensolaris.org/mailman/listinfo/webstack-discuss
>