Subject Re: [firebird-support] Migrating a 2.5 server
Author Luke Crooks
Post date 2017-02-07T08:14:29Z
Thanks everyone, I needed to make the file transportable.

Separate question...

When running the 2.5 server on our Windows DC and having clients access from the local network, performance was very slow (almost unusable). We are using a safescan product (Time Attendance +) which uses a firebird database. So to combat this, I first tried serving the file locally on a machine and accessing it this way, no performance issues here.

So I then had the idea that it could be that our windows server has to much load already, so I installed firebird on our onsite dedicated SQL server (this server is much quicker by comparison, 8 cores, 32GB of ram and runs postgres for us with loads of resources to spare). So I installed firebird on this SQL server (FreeBSD), configured the software to point to the new database, and yet again the performance is awful, does anyone have an idea what might be causing such slow speeds when connecting to a database locally? I can't see the firewall blocking anything and have given full access to port 3050, thanks. 


Regards,
--
Luke Crooks
Solent Wholesale Carpets

On Mon, Feb 6, 2017 at 8:17 PM, 'Ismael L. Donis Garcia' slibre@... [firebird-support] <firebird-support@yahoogroups.com> wrote:
 



In Windows
 
gbak -b -t -user SYSDBA -pas adminpassword C:\database\database.fdb database.fbk
 
In Linux
 
gbak -c -user SYSDBA -pas adminpassword /var/lib/firebird/2.5/data/ database.fbk /var/lib/firebird/2.5/data/ database.fdb
 
 
Saludos
========
| ISMAEL |
========
 
----- Original Message -----
Sent: Monday, February 06, 2017 6:24 AM
Subject: [firebird-support] Migrating a 2.5 server

 

So currently I have firebird 2.5 installed and running on Windows, working fine but performance is a bit slow.

I have installed 2.5 on Ubuntu, and I can connect to the current database with ISQL easily:

connect "192.168.155.112:C:\database\ database.FDB" user 'SYSDBA' password 'adminpassword';

So I stopped the firebird services on the Windows server, copied the file to the Ubuntu server, and in isql tried to run:

SQL> connect "localhost:/var/lib/firebird/ 2.5/data/database.FDB" user 'SYSDBA' password 'adminpassword';
Statement failed, SQLSTATE = m
file /var/lib/firebird/2.5/data/ database.FDB is not a valid database

Note I have so far tried:

~$ sudo adduser `id -un` firebird
[sudo] password for luke: 
The user `luke' is already a member of `firebird'.

As well as

# chown firebird /var/lib/firebird/2.5/data/ database.fdb

With no luck, if anyone has any idea as to why I might be getting this error, I would be very grateful :)

I am not sure if Super or Classic was used on Windows, however I have tried using both on Ubuntu with the same error message. Windows server version 2.5.6, same version on Linux


Regards,
--
Luke Crooks