Introduction

Getting osFinancials to work with Linux isn't that hard, but unfortunately not everything works. The dutch "Dutch TAX" and "Exhortation" plugins don't work, but the rest of the plugins seem to work. In this manual we are going to set up a single-user environment.

Prerequisites

If you want to use osFinancials you will need to have two applications installed. We shall not go into details about installing the applications, since this is distribution specific.

• Wine (a recent version)
• Firebird 2 super server

Note: You can use the built-in Firebird server, but it's advised to use the Linux Firebird server for stability and perfomance reasons.

Wine

You will to copy two dll's from a Windows computer (or from the internet) to your /home/<username>/.wine directory.

fbclient.dll --> gds32.dll (.wine/drive_c/windows/system32)  msvcp60.dll (.wine/drive_c/windows/system32)  

Firebird 2

If you wish to create a connection to the database on your hard disk of your Linux/Wine computer, you will NOT select this during the installation of osFinancials, but you will need to install it seperately with Linux! For detailed installation information you can take a look at the Firebird website

Name administration (fill out)  Directory where the administration is (fill out completely, example: /home/<username>/<databasename>.fdb)  Username (fill out, probably sysdba)  Password (fill out, probably masterkey)  Server (fill out, probably 127.0.0.1)  

Note: The firebird group and user need read and write access on the .fdb files

osFinancials installation

You can easily start it by typing "wine <osfinancialsinstallname>.exe" and then follow the normal installation procedure.

Tips - Firebird 2

Change the sysdba (database administrator) password. The default password is masterkey

$gsec -user sysdba -password masterkey   GSEC> modify sysdba -pw <newpassword>   GSEC> quit  

Create a new Firebird database user

$gsec -user sysdba -password <password>   GSEC> add <username> -pw <password>   GSEC> quit  

Create a Firebird database

$/user/lib/firebird2/bin/isql   SQL> create database '127.0.0.1:/var/lib/firebird2/data/<databasenaam>.fdb' user '<username' password '<password>';   SQL> quit;  

Create a connection to the database

$/user/lib/firebird2/bin/isql 127.0.0.1:/var/lib/firebird2/data/<databasenaam>.fdb -u <username> -p <password>;   SQL>  

Working configurations

Wine: 0.9.27, Firebird2-super-server: 1.5.3.4870-10, osFinancials: 1.0.1.0, Distribution: Ubuntu Edgy (6.10)
Wine: 0.9.28, Firebird2-super-server: 1.5.3.4870-3, osFinancials: 1.0.2.1, Distribution: Ubuntu Dapper (6.06)
Note: If you get the error "can not start server", you can solve it by using "sudo mkdir /var/run/firebird2 && sudo chmod 770 -R /var/run/firebird2 && sudo chown -R firebird:firebird /var/run/firebird2"