Firebird 2.5 Superclassic on Ubuntu 16.04 LTS – Installation Guide

debianfirebirdlinuxUbuntuusers

I installed firebird2.5-superclassic using sudo apt-get install firebird2.5-superclassic and then ran sudo dpkg-reconfigure firebird2.5-superclassic and set the password per https://firebirdsql.org/manual/ubusetup.html. Even after doing this, I cannot gsec SYSDBA. I try running gsec -user SYSDBA -password ********* and i receive Your user name and password are not defined. Ask your database administrator to set up a Firebird login. unable to open database Is there a way to ensure this gets created/fix this? I cannot seem to find a way.

Best Answer

Ok, so I found functions.sh in /usr/share/firebird2.5-common. Running this creates all of the maintenance scripts and logging files that need to be there. It also creates security2.fdb which stores the security info for users and sets up the password according to the SYSDBA.password file. You will need to set up two environment variables before running this:

FB_VER

and

FB_FLAVOUR

These need to be set to the point release you are on, ex: 2.5 and the flavor you are running, ex: superclassic.

Note: Mark Rotteveel's solution seemed to work as well, but I think this would be deemed as the more acceptable method.

Related Solutions

No luck trying out Firebird 3.0

The problem is twofold:

First Firebird 3 uses tighter security and has the old authentication mechanism disabled by default. So clients depending on older connection libraries will not work out of the box.

To allow the old authentication mechanism to work, the following setting needs to be set in firebird.conf:

AuthServer = Legacy_Auth, Srp, Win_Sspi

(be sure to remove the # prefix)

Second, the pure-java wire protocol implementation of Jaybird (the Firebird JDBC driver) uses an outdated authentication mechanism that is not supported by this Legacy_Auth option. Using Jaybird to connect to Firebird 3 at this time will only work if you use the native option (with the jdbc:firebirdsql:native: URL-prefix and jaybird2x.dll and fbclient.dll).

Addendum 1

Firebird 3 (since Alpha 1) has now also implemented the old authentication method used by Jaybird, so Jaybird will now also work without using the native library (as long as the legacy authentication is enabled, and the user has been setup with the legacy usermanager).

Addendum 2

Jaybird 3 and higher support the more secure Srp authentication model out of the box, and Jaybird 3.0.4 introduced support for the wire protocol encryption. This means that it can connect to Firebird 3 without additional configuration.

Mysql – Change ‘root’ Password forMySQL but Change Lost after Reboot

There appeared to be no way out of this! Eventually after backing up Mint 17.3 was re-installed and MySQL added. MySQL did ask for a password to be set and everything has worked fine since. I doubt the reason for the problem will ever be known!