firebird setup of microsip in linux

First, you have to backup youcurrent databases in windows

gbak.exe -t -user SYSDBA -password xxxx "c:\Microsip datos\MyCompany.fdb" "c:\Microsip datos\Respaldos\MyCompany.fbk"
gbak.exe -t -user SYSDBA -password xxxx "c:\Microsip datos\System\Config.fdb" "c:\Microsip datos\Respaldos\Config.fbk"
gbak.exe -t -user SYSDBA -password xxxx "c:\Microsip datos\System\Metadatos.fdb" "c:\Microsip datos\Respaldos\Metadatos.fbk"

The security2.fdb should be copied when firebird is not running, so the firebird service should be stopped before copying from windows, and services must be stopped too before copying into linux.

Then, directories must be created in "data" directory of firebird

mkdir /var/lib/firebird/2.5/data/System
mkdir /var/lib/firebird/2.5/data/Respaldos
mkdir /var/lib/firebird/2.5/data/Exportación

Copy the backups into /tmp and restore them on these directories

/usr/bin/gbak -t -c -user SYSDBA -pass xxxx -rep /tmp/MyCompany.fbk /var/lib/firebird/2.5/data/MyCompany.fdb
/usr/bin/gbak -t -c -user SYSDBA -pass xxxx -rep /tmp/Config.fbk /var/lib/firebird/2.5/data/System/Config.fdb
/usr/bin/gbak -t -c -user SYSDBA -pass xxxx -rep /tmp/Metadatos.fbk /var/lib/firebird/2.5/data/System/Metadatos.fdb

All files should be "firebird" owner

chown -R firebird.firebird /var/lib/firebird/2.5/data/

Microsip config is:

"Conexion", "Abrir conexion"
Servidor: 172.16.1.1
Carpeta de datos: /var/lib/firebird/2.5/data/

To test access with isql, try

/usr/bin/isql-fb
> CONNECT localhost:/var/lib/firebird/2.5/data/MyCompany.fdb
> user 'SYSDBA' password 'xxxx';
> show tables;
> quit;

I read this link to understand how to do it and then write this tutorial.

Backup firebird databases

I'm was looking forward how to backup Firebird used by Microsip

gbak "remote-host:c:\Databases\Mytest.FDB" /dev/stdout -user SYSDBA -pass xxxx | gzip > $path/Mytest-$(date +%Y%m%d%H%M).fbk.gz


# Backup config database

gbak "remote-host:c:\Databases\System\CONFIG.FDB" /dev/stdout -user SYSDBA -pass xxxx | gzip > $path/Config-$(date +%Y%m%d%H%M).fbk.gz


# The only way to access the security database is via the Service Manager. As
# GBAK can also use the Service Manager (Option -se), you can run a backup
# using this option. However, the backup file will also be written to the
# server machine.

gbak -user sysdba -pass xxxx -service dbhost:service_mgr "C:\Archivos de programa\Firebird\Firebird_2_1\security2.fdb" "C:\Archivos de programa\Firebird\Firebird_2_1\security2-$(date +%Y%m%d%H%M).fbk"