[Vtigercrm-developers] Enhancements to installation procedure, support of other databases

[Michel JACQUEMES]

You will find here joined some enhancements I have made to installation
procedure. The main purpose is to follow up $mysql_dbtype value added in
connection.php through the whole installation process (db_type field added
in the headers from 2setConfig.php through the end). The correct value is
written in config.php.

 

I have also added a $mysql_hostname variable in connection.php to support
separate sql server  and internet server.

 

A skeleton to be modified is inserted in 2setConfig.php around line 155 in
order to support other databases :

 

if ($db_type == 'mysql')

            $db_hostname .= $sock_path;

// with adodb 4.72 mssql_pconnect does not accept port number (not know how
to do with non default installs)

elseif ($db_type == 'mssql')

            $db_hostname = $db_hostname;

// code to be added here to support other drivers

else

            $db_hostname .= $sock_path;

 

I have successfully tested this patch with MySQL 4.1.16 and MsSQL server
2000 SP4. Do not have time to test it with Postgres, maybe later or somebody
else.

 

For MsSQL server or Postgres users, this does'nt solve management of
identity fields when populating the database, it will be the next step.

XML schema modification is also required to support numeric fields
definition (ref my preceding mail).

 

I am sorry for the size of two of the patches, I have not been able to have
WinMerge generates smaller ones.

 

I have chosen not to post it as a new forge ticket because it is not a bug
and it has to be fully validated.

 

Hope this will help having vtiger more open, it could be probably applied to
version 5 (not tested).

 

Michel

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20060227/886ae7af/attachment-0003.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: InstallEnhancements.zip
Type: application/x-zip-compressed
Size: 12522 bytes
Desc: not available
Url : http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20060227/886ae7af/attachment-0003.bin