-Things to watch out for when installing using a Firebird database.
|
+Firebird is a simple yet powerful, fully open source relational database. It can be download from the [http://www.firebirdsql.org/index.php?id=about-firebird&nosb=1|Firebird Project Site] |
+ |
+Reworked 17th Feb 2009 for Release 2.5 ( Still applicable for the 2.7 build ) |
+ |
+#While bitweaver will run with PHP4 and Firebird 1.5, it is prefered to use PHP5.2.x and Firebird 2.1.x. The Firebird PHP driver was much updated for PHP5 and those improvements were never back ported. And Firebird 2.1 has a few built in functions that can be emulated via the UDF libraries in earlier versions if required. |
+#Installer should be able to create an empty database in which to build the database schema, but with the different Linux installs this sometimes fails. So it is easier to create an empty database and add it's alias to the alias.conf file before actually running the installer. bitweaver will then pick up this database to work with. |
+#If you have Firebird installed and running correctly and Bitweaver fails to list it as an option during installation, you need to make sure your version of php is compiled with support for interbase. The relevant flag to add when compiling php is "--with-interbase". |
+#While installing ensure that you do not add a custom table prefix as this will take table and other names over the 31 character limit that still exists in Firebird ( 22years of backwards compatibility is not easy to retain if this limit is removed ) |
+ |
+Once a database has been located and the config_inc.php file has been populated, there should be no problems with using Firebird. |
+ |
+ |
|
-create_firebird15_database.php may need adjusting to line up with your current Apache/Firebird setup. Line 36 should point to a valid and accessable temporary directory, and line 43 needs to point to your firebird programs directory.
|
|
-Both of these niggles need to be cleaned up and any help doing that will be welcome.
|
|
-In addition, schema_inc.php located in \quicktags\admin needs a little help at the end of line 33.^ \'\'text\'\' ^needs to be replaced by^ ''''text'''' ^to provide the correct excaping of -'- characters in the insert script. |