[Galette-devel] [task #3507] Support pour le SGBD Firebird 2.0 -- August 07, 2006 - 20:19

URL:
  <http://gna.org/task/?func=detailitem&item_id=3507>

                 Summary: Support pour le SGBD Firebird 2.0
                 Project: Galette
            Submitted by: legrand
            Submitted on: lundi 07.08.2006 à 18:19
         Should Start On: lundi 07.08.2006 à 00:00
   Should be Finished on: jeudi 07.12.2006 à 00:00
                Priority: 1 - Later
                Severity: 5 - Average
                  Status: None
                 Privacy: Public
             Assigned to: None
        Percent Complete: 0%
             Open/Closed: Open
                  Effort: 0.00

    _______________________________________________________

Details:

Bonjour,

J'ai testé avec succés l'application Galette couplée avec le SGBD libre
Firebird 2.0. Vous trouverez ci dessous le mode opératoire en Anglais, ainsi
que le fichier de création de la base de données initiale.

Merci de me retourner vos remarques sur l'usage éventuel de Firebird.

Salutations
PAscal

---------------------------------------------------------------------------------------
Download and install firebird 2.0
a php server including firebird setup can be downloaded from
http://www.janus-software.com/phpserver.html

If not using that server: enable firebird extension (in php.ini)
(php_firebird.dll has to be a copy of php_interbase.dll)
 
create the DB:
cd firebird home /bin 
isql -u SYSDBA -p masterkey
Use CONNECT or CREATE DATABASE to specify a database
SQL>
CREATE DATABASE 'D:\firebird\database\GACHETTE.FDB'
PAGE_SIZE 4096
DEFAULT CHARACTER SET NONE;
CREATE DOMAIN TEXT AS VARCHAR(4000);
commit;
exit;

copy firebird.sql script in
galette\install\sql

script modification for installation
galette/install/index.php

        if ($_POST["install_dbtype"]!="mysql" 
            && $_POST["install_dbtype"]!="pgsql" 
            // added for firebird support       
            && $_POST["install_dbtype"]!="firebird")

        <SELECT name="install_dbtype">
                <OPTION value="mysql">MySQL</OPTION>
                <OPTION value="pgsql">PostgreSQL</OPTION>
                // Add firebird support
                <OPTION value="firebird">Firebird</OPTION>
        </SELECT>

script modification in
galette/includes/database.inc.pp

        // First modification for firebird support
        define('ADODB_ASSOC_CASE', 0); 

        include(WEB_ROOT."/includes/adodb/adodb.inc.php");
        $DB = ADONewConnection(TYPE_DB);
        $DB->debug = false;
        
        // Second modification for firebird support
        $DB->SetFetchMode(ADODB_FETCH_BOTH);

        if(!@$DB->Connect(HOST_DB, USER_DB, PWD_DB, NAME_DB)) die("No database
connection...");


script modification in
galette/includes/adodb/drivers/adodb-ibase.inc.php

// First modification
//      var $fmtTimeStamp = "'Y-m-d, H:i:s'";
        var $fmtTimeStamp = "'Y-m-d H:i:s'";


// Second modification
//      var $metaColumnsSQL = "select a.rdb\$field_name,
        var $metaColumnsSQL = "select lower(a.rdb\$field_name),

during install, provide the following DB informations:
db_type  firebird
username SYSDBA
password masterkey
host     localhost
database 'D:\firebird\database\GACHETTE.FDB' 

Regards
PAscal



    _______________________________________________________

Carbon-Copy List:

CC Address                          | Comment
------------------------------------+-----------------------------
legrand                             | 



    _______________________________________________________

File Attachments:


-------------------------------------------------------
Date: lundi 07.08.2006 à 18:19  Name: Firebird.sql  Size: 4,48Ko   By:
legrand

<http://gna.org/task/download.php?file_id=1133>

    _______________________________________________________

Reply to this item at:

  <http://gna.org/task/?func=detailitem&item_id=3507>

_______________________________________________
  Message posté via/par Gna!
  http://gna.org/