Subversion Repositories oidplus

Compare Revisions

Regard whitespace Rev 1234 → Rev 1235

/trunk/doc/developer_notes/database/firebird_notes.txt
0,0 → 1,33
 
Firebird installation notes
---------------------------
 
In PHP.ini:
extension=pdo_firebird
 
Restart Apache, XAMPP, etc.
 
Download and install from
https://www.firebirdsql.org/en/firebird-3-0/
Make sure that the clientlibrary fbclient.dll is also selected
 
If you need to run the Firebird server in application mode, run it as administrator.
(Otherwise error message "Error occurred during login, please check server firebird.log for details")
 
Open Firebird iSQL Tool:
 
CREATE DATABASE 'D:\SVN\OIDplus\trunk\userdata\database\oidplus.fdb' page_size 8192 user 'SYSDBA' password 'masterkey';
(replace with the directory to OIDplus and replace with the password you have entered in setup)
 
EXIT;
 
OIDplus userdata/baseconfig/config.inc.php
 
OIDplus::baseConfig()->setValue('DATABASE_PLUGIN', 'PDO');
OIDplus::baseConfig()->setValue('PDO_DSN', 'firebird:dbname=d:\\svn\\oidplus\\trunk\\userdata\\database\\oidplus.fdb');
OIDplus::baseConfig()->setValue('PDO_USERNAME', 'SYSDBA');
OIDplus::baseConfig()->setValue('PDO_PASSWORD', 'masterkey');
OIDplus::baseConfig()->setValue('TABLENAME_PREFIX', '');
OIDplus::baseConfig()->setValue('FORCE_DBMS_SLANG', 'firebird');
 
"C:\Program Files\Firebird\Firebird_3_0\isql.exe" -z -i "d:\SVN\OIDplus\trunk\setup\sql\struct_firebird.sql"