How to configure Firebird Classic to work with systemd

By Pavel Cisar

Take the Firebird 2.5.4 Classic tarball distribution package from firebirdsql.org and install in default location (/opt/firebird)

Place the documented configuration files into /etc/systemd/system

firebird.socket

[Unit] Description=Firebird Classic Activation Socket [Socket] ListenStream=3050 Accept=yes [Install] WantedBy=sockets.target

firebird@.service

[Unit] Description=Firebird Classic server After=syslog.target [Service] User=firebird Group=firebird ExecStart=/opt/firebird/bin/fb_inet_server StandardInput=socket [Install] WantedBy=multi-user.target

Now execute the following commands as root:

> systemctl daemon-reload > systemctl enable firebird.socket > systemctl enable firebird@.service > systemctl start firebird.socket

This needs to be only done once, as the service should be started automatically on the next boot.

Now it's possible to connect to the Firebird server via the remote interface:

> /opt/firebird/bin/isql -user sysdba -pas masterkey localhost:employee