On 2020-05-15 21:40, Jorge Gonçalves wrote:
I already have to fb3 running alongside fb4
but with some strange problems ..
some examples :
I've tried to reproduce on linux but used fresh fb3 snapshot. (3.0.4 is
bad choice for given attempt - see
http://tracker.firebirdsql.org/browse/CORE-6072. Everything works fine
for me:
# ./isql -user sysdba -pas masterkey
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'localhost:/tmp/xxx.fdb';
SQL> show db;
Database: localhost:/tmp/xxx.fdb
Owner: SYSDBA
DB = /tmp/xxx.fdb
Host = fbs3
PAGE_SIZE 8192
Number of DB pages allocated = 180
Number of DB pages used = 176
Number of DB pages free = 4
Sweep interval = 20000
Forced Writes are ON
Transaction - oldest = 1
Transaction - oldest active = 2
Transaction - oldest snapshot = 2
Transaction - Next = 5
ODS = 12.0
Database not encrypted
Default Character set: NONE
SQL> show version;
ISQL Version: LI-T4.0.0.1970-dev Firebird 4.0 Beta 2
Server version:
Firebird/Linux/AMD/Intel/x64 (access method), version
"LI-V3.0.6.33289-dev Firebird 3.0"
Firebird/Linux/AMD/Intel/x64 (remote server), version
"LI-T4.0.0.1970-dev Firebird 4.0 Beta 2/tcp (fbs3)/P16:C"
Firebird/Linux/AMD/Intel/x64 (remote interface), version
"LI-T4.0.0.1970-dev Firebird 4.0 Beta 2/tcp (fbs3)/P16:C"
on disk structure version 12.0
SQL> select current_timestamp from rdb$database;
CURRENT_TIMESTAMP
=========================
2020-05-16 00:51:47.9480
SQL> select current_time from rdb$database;
CURRENT_TIME
=============
00:51:58.0000
SQL> select current_date from rdb$database;
CURRENT_DATE
============
2020-05-16
SQL> select current_user from rdb$database;
USER
===============================
SYSDBA
SQL>
Firebird versions
FB3 : 3.0.4.33054
FB4: 4.0.0.1963
Configuration :
copy engine12.dll to plugins
copy security3.fdb to firebird root page
database.conf
fb3 = d:/Projectos/database/fb3/PINGWIN_30.FDB
{
Providers = Remote,Engine12,Loopback
SecurityDatabase = $(dir_secDb)/security3.fdb
}
Any mistake on my configuration or is firebird problem?
Please retry with fresh engine12.
I have another question ...
The provider configuration must be on a database level or can I
configure one a folder level ?
I do not know what does folder level mean here. Provider configuration
may be set in firebird.conf (default for all server) or for any database
in databases.conf (overrides server default).
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
