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

[Fathi Boudra]

Hi michel,

I have started to update the installer with mike fedyk. There's already some 
modifications done. You can look at 4.2 branches.

we probably introduce db selection after 4.2.4 but i'm not 4.2.4 release 
manager :)

thks for your enhancements.

cheers,

Fathi

Le Lundi 27 Février 2006 10:02, Michel JACQUEMES a écrit :
> 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