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:[email protected]] 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 >
