SugarOS Apache Linux PHP Oracle 10g R2

[gmilliken]

I'm working on getting SugarCRM OS to work on Oracle 10gR2.

I would really appreciate any information, tips, bugs, problems, advice etc. I will post any information howto's etc. that I uncover.

I'm a developer and Oracle DBA, I am working on the Gentoo linux platform.

Thanks,

George
gmilliken@availmedia.com

[Angel]

SugarOS doesn't support Oracle databases. You would need to code all the DB access stuff yourself in order to get it to work with Oracle.

The Enterprise edition does support Oracle, but it is a paid-for product.

[gmilliken]

I am going to document the things I find as I go, and the questions I have. Hopefully this will generate some discussion. This might be more suitable for a blog or wiki, but since I don;t actually have a good idea of how to get SugarCRM OS working on Oracle 10g R2 (maybe it's easy?) I decided to post my progress.

If it is easy and I missed something in the docs -- someone please take pity on me and enlighten me. Otherwise......here goes......

My test box is up and running as follows:

gentoo linux 64 bit Intel kernel 2.6.20 compiled from source
Oracle 10g R2 Enterprise
PHP Version 5.2.2-pl1-gentoo
SugarOS-4.5.1e
Apache 20020903


-------
PHP Configure Info (I see my curl support is no active, nor is mysql. Curl I need to fix, mysql is off by choice)
------
./configure' '--prefix=/usr/lib64/php5' '--host=x86_64-pc-linux-gnu' '--mandir=/usr/lib64/php5/man' '--infodir=/usr/lib64/php5/info' '--sysconfdir=/etc' '--cache-file=./config.cache' '--with-libdir=lib64' '--disable-cli' '--with-apxs2=/usr/sbin/apxs2' '--with-config-file-path=/etc/php/apache2-php5' '--with-config-file-scan-dir=/etc/php/apache2-php5/ext-active' '--without-pear' '--disable-bcmath' '--without-bz2' '--disable-calendar' '--disable-ctype' '--without-curl' '--without-curlwrappers' '--disable-dbase' '--disable-exif' '--without-fbsql' '--without-fdftk' '--disable-filter' '--enable-ftp' '--without-gettext' '--without-gmp' '--disable-hash' '--disable-ipv6' '--disable-json' '--without-kerberos' '--enable-mbstring' '--with-mcrypt' '--without-mhash' '--without-msql' '--without-mssql' '--with-ncurses' '--with-openssl' '--with-openssl-dir=/usr' '--disable-pcntl' '--disable-pdo' '--without-pgsql' '--disable-posix' '--without-pspell' '--without-recode' '--disable-shmop' '--without-snmp' '--enable-soap' '--enable-sockets' '--without-sybase' '--without-sybase-ct' '--disable-sysvmsg' '--disable-sysvsem' '--disable-sysvshm' '--without-tidy' '--disable-tokenizer' '--enable-wddx' '--with-xmlrpc' '--with-xsl' '--disable-zip' '--with-zlib' '--disable-debug' '--enable-dba' '--without-cdb' '--with-db4' '--without-flatfile' '--with-gdbm' '--without-inifile' '--without-qdbm' '--without-freetype-dir' '--without-t1lib' '--disable-gd-jis-conv' '--without-jpeg-dir' '--without-png-dir' '--without-xpm-dir' '--without-gd' '--without-mysqli' '--with-oci8' '--with-readline' '--without-libedit' '--without-mm' '--without-sqlite' '--with-pic'

I am able to connect to Oracle from JDBC Thin Client from any box, and from SQLNET from any box (or locally). I can also connect to the Enterprise Manager (via http) and iSQLPLUS (via http). Therefore....Oracle is 'up'.

Likewise I can demonstrate that apache and php are working.

Sugars installed in the /var/www/..../htdocs and it works (at least as far as getting to the installer.php Setup Wizard Step 2 screen via http). Although the installer complains that mysql is missing.

The installer.php says these things are broken:
Writable Session Save Path () Not A Valid Directory
Optional Components Status
IMAP Module Not found: InboundEmail and Campaigns (Email) require the IMAP libraries. Neither will be functional.
cURL Module Not found: Sugar Scheduler will run with limited functionality.

OKAY lets start fixing things.......



Preliminary greping reveals the following files mention the work 'oracle'. Let's see what specifically is giong on in these first. I also see that install.php mentions mysql as a default database.

./data/SugarBean.php
./modules/EditCustomFields/EditView.php
./modules/EditCustomFields/Save.php
./modules/Studio/EditCustomFields/Save.php
./modules/Activities/OpenListView.php
./modules/Administration/expandDatabase.php
./modules/Administration/repairDatabase.php
./modules/Administration/RepairTeams.php
./modules/Administration/language/en_us.lang.php
./modules/Administration/DstFix.php
./modules/UpgradeWizard/uw_utils.php
./modules/DynamicFields/templates/Fields/TemplateField.php
./modules/DynamicFields/templates/Fields/TemplateFloat.php
./include/database/MysqlHelper.php
./include/database/DBHelper.php
./include/database/DBManager.php
./include/utils/db_utils.php
./include/ListView/ListViewDisplay.php
./include/utils.php
./install/seed_data/entreport_SeedData.php
./install/language/ja.lang.php
./install/language/en_us.lang.php
./install/language/pt_br.lang.php
./install/language/fr_fr.lang.php
./install/language/es_es.lang.php
./install/language/ge_ge.lang.php

[gmilliken]

Angel,

Since this is open source I am undaunted by the task of fixing it. Since I work in a company that is dedicated to open source, and in fact all our servers and desktops are built by compiling linux from source code, I am not too upset that it doesn't work. I'll fix it.

Then we can all enjoy a version of Sugar that works on Oracle, if we choose to use it.

[Angel]

That would be a pretty cool contribution. I'll try to help you test if possible.

[gmilliken]

Thanks Angel. I think we can do it. After all, that's what open source is all about. Some folks say Oracle and Open Source Sugar is an oxymoron but for us and many others Oracle is part of the landscape so getting our open source tools to work with it makes sense.

It's true that Oracle Admin is complicated, but given that you are committed to Oracle already then supporting MySQL or other databases adds grief and complexity.

Without debating the merits of Brand X Database versus Brand Y I find myself in a pure Oracle shop, that is open source (where possible).

We license Oracle, we buy other things too, like hardware, pencils, electricity etc.

But where we can we use open source.

So, enough of the soap box......on with the show.

Is there anyone we know who has Oracle and Sugar working that can tell us about the config without violating any non-disclosures or license agreements?

[gmilliken]

OK so it looks like the Open Source version has allowances for Oracle access. For instance in ./modules/EditCustomFields/Editview.php there is this comment:

//mysql max is 64, allow for few additional chars added by sugar.
//oracle max is 30,
$name_max_length=60;
if ($GLOBALS['db']->dbType=='oci8') {
$name_max_length=26;
}
$image_path = 'themes/'.$theme.'/images/';

What they are talking about here is that Oracle wants object names (tables, columns, whatever....to be 30 characters max.

The code was written to allow for that.

So it may be some simple config changes and it should work. Maybe just in the php.ini

Hmmmmmm.....

[eggsurplus]

If you do a search for oci8 in all of the files in Sugar you'll find these blocks in numerous files. The code has been removed there for the OS version. You'll probably want to add your code there as well as add your own OracleManager.php and OracleHelper.php in include/database.

Good luck!

[gmilliken]

OK thanks. It looked to be like some code was 'redacted' particularly where there are large numbers of blank lines right around Oracle comments.

[susiewilliams]

Hi all,

It's the Podcast Lady here. We recorded a short podcast a little while ago that explains how we build the different editions of Sugar (OS/Pro/Enterprise), and it goes into detail about why you see those blank lines.

Check it out here!

Podcast Lady out.