Subversion Repositories oidplus

Compare Revisions

Regard whitespace Rev 1234 → Rev 1235

/trunk/doc/config_values.md
342,6 → 342,7
 
Currently valid values:
- `access`
- `firebird`
- `mssql`
- `mysql`
- `oracle`
/trunk/doc/database_connectivity_diagram.drawio
1,6 → 1,6
<mxfile host="app.diagrams.net" modified="2023-04-26T14:36:51.399Z" agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36" etag="I0CPav2Bw26YggocyvIt" version="21.2.2" type="device">
<mxfile host="app.diagrams.net" modified="2023-04-27T00:39:12.379Z" agent="Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36" etag="6niowIrc-BWQS2SQ42EU" version="21.1.9" type="device">
<diagram id="-CuTGTWnEKNFAuos6sQm" name="Page-1">
<mxGraphModel dx="2049" dy="1080" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="827" pageHeight="1169" math="0" shadow="0">
<mxGraphModel dx="1687" dy="832" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="827" pageHeight="1169" math="0" shadow="0">
<root>
<mxCell id="0" />
<mxCell id="1" parent="0" />
52,7 → 52,7
<mxCell id="rkxFK2iF5i7AjHGrBCSy-22" value="OIDplus Database Connectivity" style="text;html=1;strokeColor=none;fillColor=none;align=center;verticalAlign=middle;whiteSpace=wrap;rounded=0;fontSize=30;fontStyle=4;shadow=0;" parent="1" vertex="1">
<mxGeometry x="180" y="80" width="1570" height="20" as="geometry" />
</mxCell>
<mxCell id="aevjvMxUrnnEDrcyBwDK-1" value="&lt;p style=&quot;line-height: 80%;&quot;&gt;&lt;span style=&quot;font-size: 20px&quot;&gt;MySQL/MariaDB, PostgreSQL,&lt;br&gt;Microsoft SQL Server, SQLite3, Oracle, Microsoft Access&lt;/span&gt;&lt;/p&gt;" style="rounded=0;whiteSpace=wrap;html=1;fontSize=30;fillColor=#fff2cc;strokeColor=#d6b656;shadow=0;" parent="1" vertex="1">
<mxCell id="aevjvMxUrnnEDrcyBwDK-1" value="&lt;p style=&quot;line-height: 80%;&quot;&gt;&lt;span style=&quot;font-size: 20px&quot;&gt;MySQL/MariaDB, PostgreSQL, Firebird,&lt;br&gt;Microsoft SQL Server, SQLite3, Oracle, Microsoft Access&lt;/span&gt;&lt;/p&gt;" style="rounded=0;whiteSpace=wrap;html=1;fontSize=30;fillColor=#fff2cc;strokeColor=#d6b656;shadow=0;" parent="1" vertex="1">
<mxGeometry x="1170" y="610" width="580" height="100" as="geometry" />
</mxCell>
<mxCell id="ppWasWMKm3SrtxTAx-Xf-1" value="&lt;span style=&quot;font-size: 20px&quot;&gt;Operating System Windows, Linux, Mac OS X, ...&lt;br&gt;&lt;/span&gt;" style="rounded=0;whiteSpace=wrap;html=1;fontSize=30;fillColor=#f8cecc;strokeColor=#b85450;shadow=0;" parent="1" vertex="1">
127,16 → 127,16
<mxCell id="OQT0X5HdhIb7dxfhtFS0-6" value="&lt;p style=&quot;line-height: 80%;&quot;&gt;&lt;span style=&quot;font-size: 20px&quot;&gt;ADO&lt;br&gt;&lt;/span&gt;&lt;/p&gt;" style="rounded=0;whiteSpace=wrap;html=1;fontSize=30;fillColor=#f8cecc;strokeColor=#b85450;shadow=0;" parent="1" vertex="1">
<mxGeometry x="1570" y="480" width="180" height="50" as="geometry" />
</mxCell>
<mxCell id="_qeA2vBpsVk76i-9lK4X-1" value="&lt;p style=&quot;line-height: 80%;&quot;&gt;&lt;font style=&quot;font-size: 20px&quot;&gt;SQLSRV&lt;br&gt;&lt;span style=&quot;font-size: 15px&quot;&gt;Database provider plugin&lt;/span&gt;&lt;br&gt;&lt;/font&gt;&lt;/p&gt;" style="rounded=0;whiteSpace=wrap;html=1;fontSize=30;fillColor=#d5e8d4;strokeColor=#82b366;shadow=0;" vertex="1" parent="1">
<mxCell id="_qeA2vBpsVk76i-9lK4X-1" value="&lt;p style=&quot;line-height: 80%;&quot;&gt;&lt;font style=&quot;font-size: 20px&quot;&gt;SQLSRV&lt;br&gt;&lt;span style=&quot;font-size: 15px&quot;&gt;Database provider plugin&lt;/span&gt;&lt;br&gt;&lt;/font&gt;&lt;/p&gt;" style="rounded=0;whiteSpace=wrap;html=1;fontSize=30;fillColor=#d5e8d4;strokeColor=#82b366;shadow=0;" parent="1" vertex="1">
<mxGeometry x="970" y="210" width="180" height="100" as="geometry" />
</mxCell>
<mxCell id="_qeA2vBpsVk76i-9lK4X-2" value="&lt;p style=&quot;line-height: 80%;&quot;&gt;&lt;span style=&quot;font-size: 20px;&quot;&gt;SQLSRV&lt;/span&gt;&lt;br&gt;&lt;font style=&quot;font-size: 15px;&quot;&gt;PHP Extension&lt;/font&gt;&lt;/p&gt;" style="rounded=0;whiteSpace=wrap;html=1;fontSize=30;fillColor=#dae8fc;strokeColor=#6c8ebf;shadow=0;" vertex="1" parent="1">
<mxCell id="_qeA2vBpsVk76i-9lK4X-2" value="&lt;p style=&quot;line-height: 80%;&quot;&gt;&lt;span style=&quot;font-size: 20px;&quot;&gt;SQLSRV&lt;/span&gt;&lt;br&gt;&lt;font style=&quot;font-size: 15px;&quot;&gt;PHP Extension&lt;/font&gt;&lt;/p&gt;" style="rounded=0;whiteSpace=wrap;html=1;fontSize=30;fillColor=#dae8fc;strokeColor=#6c8ebf;shadow=0;" parent="1" vertex="1">
<mxGeometry x="970" y="410" width="180" height="200" as="geometry" />
</mxCell>
<mxCell id="_qeA2vBpsVk76i-9lK4X-3" value="&lt;p style=&quot;line-height: 80%;&quot;&gt;&lt;span style=&quot;font-size: 20px;&quot;&gt;Microsoft&lt;br&gt;SQL Server&lt;/span&gt;&lt;br&gt;&lt;font style=&quot;font-size: 15px;&quot;&gt;DBMS&lt;/font&gt;&lt;/p&gt;" style="rounded=0;whiteSpace=wrap;html=1;fontSize=30;fillColor=#fff2cc;strokeColor=#d6b656;shadow=0;" vertex="1" parent="1">
<mxCell id="_qeA2vBpsVk76i-9lK4X-3" value="&lt;p style=&quot;line-height: 80%;&quot;&gt;&lt;span style=&quot;font-size: 20px;&quot;&gt;Microsoft&lt;br&gt;SQL Server&lt;/span&gt;&lt;br&gt;&lt;font style=&quot;font-size: 15px;&quot;&gt;DBMS&lt;/font&gt;&lt;/p&gt;" style="rounded=0;whiteSpace=wrap;html=1;fontSize=30;fillColor=#fff2cc;strokeColor=#d6b656;shadow=0;" parent="1" vertex="1">
<mxGeometry x="970" y="610" width="180" height="100" as="geometry" />
</mxCell>
<mxCell id="_qeA2vBpsVk76i-9lK4X-5" value="&lt;p style=&quot;line-height: 80%;&quot;&gt;&lt;font style=&quot;font-size: 20px&quot;&gt;MSSQL&lt;br&gt;&lt;span style=&quot;font-size: 15px&quot;&gt;SQL Slang plugin&lt;/span&gt;&lt;br&gt;&lt;/font&gt;&lt;/p&gt;" style="rounded=0;whiteSpace=wrap;html=1;fontSize=30;fillColor=#d5e8d4;strokeColor=#82b366;shadow=0;" vertex="1" parent="1">
<mxCell id="_qeA2vBpsVk76i-9lK4X-5" value="&lt;p style=&quot;line-height: 80%;&quot;&gt;&lt;font style=&quot;font-size: 20px&quot;&gt;MSSQL&lt;br&gt;&lt;span style=&quot;font-size: 15px&quot;&gt;SQL Slang plugin&lt;/span&gt;&lt;br&gt;&lt;/font&gt;&lt;/p&gt;" style="rounded=0;whiteSpace=wrap;html=1;fontSize=30;fillColor=#d5e8d4;strokeColor=#82b366;shadow=0;" parent="1" vertex="1">
<mxGeometry x="970" y="310" width="180" height="100" as="geometry" />
</mxCell>
</root>
/trunk/doc/database_connectivity_diagram.png
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/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"