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"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.
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"
Then, directories must be created in "data" directory of firebird
mkdir /var/lib/firebird/2.5/data/SystemCopy the backups into /tmp and restore them on these directories
mkdir /var/lib/firebird/2.5/data/Respaldos
mkdir /var/lib/firebird/2.5/data/Exportación
/usr/bin/gbak -t -c -user SYSDBA -pass xxxx -rep /tmp/MyCompany.fbk /var/lib/firebird/2.5/data/MyCompany.fdbAll files should be "firebird" owner
/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
chown -R firebird.firebird /var/lib/firebird/2.5/data/
Microsip config is:
"Conexion", "Abrir conexion"To test access with isql, try
Servidor: 172.16.1.1
Carpeta de datos: /var/lib/firebird/2.5/data/
/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.