Sutff about my job and comments about personal activities. Take a look to the first idea.

Monday, September 19, 2011

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.