Add support for Firebird/Interbase

Looks promising.

Could you write down a tutorial on how to install firebird + pdo_firebird on any decent modern distribution (especially Debian/Ubuntu)?

I have some issues with the install script
here is how i try to solve them

http://lsces.co.uk/wiki/index.php?page=Drupal+7+on+Ubuntu+Jaunty+

will be tested in drupal 8 only

I can help as you install drupal on my slack 12.2 and I want to work in firebird if I may say that this error

PHP Fatal error: Class 'DatabaseInstaller' not found in /webserver/drupal/includes/database/firebird/install.inc on line 6

<?php
// $Id$

// Firebird/Interbase specific install functions

class DatabaseInstaller_firebird extends DatabaseInstaller {
protected $pdoDriver = 'firebird';
public function name() {
return 'Firebird';
}
}

I see that the mysql driver is
DatabaseTasks
and firebird is DatabaseInstaller

Thank

Core support will have to go into Drupal 8, but database drivers can be implemented as contrib modules now in D7.

you can change it , i will create a bzr repository in launchpad and send you the changes

I have created the git repository and i fixed the above error and others
http://gitorious.org/firebird-drupal/firebird-drupal

but now i'm stuck on another errro , i hope to fix it today

Failed to CREATE a test table on your Firebird database server with the command CREATE TABLE drupal_install_test (id int NULL). Firebird reports the following message: CREATE TABLE drupal_install_test (id int) - Array ( ) SQLSTATE[HY000]: General error: -607 unsuccessful metadata update Table DRUPAL_INSTALL_TEST already exists

Also i have updated the guide in the wiki

http://lsces.co.uk/wiki/index.php?page=Drupal+7+on+Ubuntu+Jaunty+

It might be solved easily by using something like is described here

http://drupal.org/node/1081460

I will check in weekend

Hi Guys,

I forked the code from #9 http://gitorious.org/firebird-drupal/firebird-drupal to https://github.com/drupalista-br/Firebird-Drupal7-Layer and did these slight changes here https://github.com/drupalista-br/Firebird-Drupal7-Layer/commits/master

I added the database files to /includes/databases/firebird in a Drupal 7 installation.
My firebird version is 1.5 in case that matters.

I am getting this error here at installation:

Failed to CREATE a test table on your database server with the command CREATE TABLE {drupal_install_test} (id int NULL). The server reports the following message: SQLSTATE[HY000]: General error: -104 Dynamic SQL Error SQL error code = -104 Token unknown - line 1, char 42 NULL

If you know how to fix this, please help me out because I have absolutely no idea on how to tackle it.

Any shed of light will be very much appreciated.

Cheers,

you need to remove NULL from column definition
by default column is nullable

If you add a column to a table that already has records, the fields added to the existing records will be NULL, except if you declare the column as NOT NULL and specify a default value for it. Note that both conditions must be satisfied for the fields to become anything other than NULL.

http://www.firebirdsql.org/manual/nullguide.html#nullguide-null-as-default

I'm trying to follow the tutorial on this page, but get stuck on the same point as #6. Using D7.
Any hints on how to get this working? I don't actually need it for my default database, but for an auxiliary db from which I intend to draw some useful data to a custom-made module.

I have updated the code , it still needs some tweaks
https://gitorious.org/firebird-drupal/firebird-drupal/

There are no visible errors but the install doesn't continue (i double checked the permissions with pdo connection)

Failed to CREATE a test table on your database server with the command CREATE TABLE {drupal_install_test} (id int NULL). The server reports the following message: .

Are you sure the configured username has the necessary permissions to create tables in the database?

Drupal 7 progress
I have moved the git repository to github
also i have cleaned up the code base a little bit

https://github.com/mariuz/firebird-drupal

The installation reaches this step

CREATE TABLE drupal_install_test (id int)
INSERT INTO drupal_install_test (id) VALUES (1)
UPDATE drupal_install_test SET id = 2
DELETE FROM drupal_install_test
DROP TABLE drupal_install_test
SELECT "VALUE" FROM "VARIABLE" WHERE name = :name
name => install_task

seems to be an issue with a select from a non existent table

Here is the related issue from pgsql install on drupal 8

ERROR:  relation "variable" does not exist at character 19
STATEMENT:  SELECT value FROM variable WHERE name = 'install_task'

https://www.drupal.org/node/2001350#comment-7723229

Unassigning stale issue. Hopefully someone else will pursue this.

I think this would be best done in a contrib module.

This looks like an interesting way to get interfaces working with external Firebird DBs. Will have a look next week if it can be somehow incorporated for D9 or if better suited as a contrib module.

There isn't any patch, so the status cannot be Needs work.

#3 and #16 include files that can be made into a patch.

@NWOM One of those comments has an archive attached, while the other one contains a link to an external repository. They aren't patches.
We review patches, not something that can be made into a patch.

Since https://www.drupal.org/node/3123251 it is possible for a contrib module to provide a database driver without any special installation steps.

Also, as SQL Server is only supported in contrib and not core I suspect that any other new drivers should be developed in contrib first and only considered for core once they are both stable and widely used.