Firebird 5.02. - the root of all my troubles

[Nicole]

It was that easy to install Firebird 5.02
Just starting the install.sh waiting for 3 seconds and read "Firebird is installed succesfully".
Yeah!! So easy.

The problem is, no software and no search can find this installation.
As Flamerobin and IBX and Lazarus with IBX need it, - I had a lot of troubles.

What I seem to need:
Linux Mint on 64 bit, only local access of Firebird, so no FB-server-version.
Firebird 4 would be ok to me as well.
I heard a rumour, there would be *.deb files, but cannot find them.

I tried is this script attached, which I got from the Firebird-server, which
I started by

Code: Bash  [Select][+][-]

1. sudo ./install.sh

.

After it tells me "successful installation fairy tales", I am not sure what to do now.

And: What about Flamerobin and IBX?
Both I installed, trusting, there would be a Firebird waiting for them.
Both have nasty error messages now.

[rvk]

The problem is, no software and no search can find this installation.
As Flamerobin and IBX and Lazarus with IBX need it, - I had a lot of troubles.

What says the following command?
whereis libfbclient.so

I also installed via install.sh on a raspberry pi and for it says:
libfbclient.so: /usr/lib/aarch64-linux-gnu/libfbclient.so

If there is no correct libfbclient.so then this needs to be created as linked file. But the install.sh should have done this.

And: What about Flamerobin and IBX?

Does Flamerobin work with the Firebird 5 installation, or do you also get an error with that?

Did you start the Firebird instance?

What does this show?
sudo netstat -tulpn | grep 3050

Both have nasty error messages now.

Without knowing the messages, we can't help.

[Nicole]

Thank you for your answer. I do not understand what you are talking about in any way.
But I will ask my Linux VM about:

What says the following command?

Code: Text  [Select][+][-]

1.  whereis libfbclient.so

►

Code: Bash  [Select][+][-]

1. libfbclient.so: /usr/lib/x86_64-linux-gnu/libfbclient.so

Code: Text  [Select][+][-]

1. sudo netstat -tulpn | grep 3050

►

Code: Bash  [Select][+][-]

1. ltcp6       0      0 :::3050                 :::*                    LISTEN      33230/firebird

[rvk]

Code: Text  [Select][+][-]

1. sudo netstat -tulpn | grep 3050

►

Code: Bash  [Select][+][-]

1. ltcp6       0      0 :::3050                 :::*                    LISTEN      33230/firebird

There you might have a problem. How are you connecting to the server?

You do know that :::3050 is IPv6?

If you want IPv4 connectivity then you should see something like 0 0.0.0.0:3050

You can change firebird.conf to only IPv4. Search for RemoteBindAddress and make it

Code: [Select]

RemoteBindAddress = 0.0.0.0and do a

Code: [Select]

sudo service firebird restart

[Nicole]

cit: "You do know that :::3050 is IPv6?"

I am glad, that I known round about what IPv6 is.
So I searched for the config file and found something very irritating.
I post you the screenshot.
How can this file be in a subdirectory of IBX?!
Or so I err?

I have no idea of Linux and installed with the install routines looking working. I trusted, the directories would land on a sense making place. See screenshot. Happened what I fear? If yes, shall I delete my VM and start all over again? a work of at least three days ;-(

[rvk]

How can this file be in a subdirectory of IBX?!

You need to look for firebird.conf in the installation directory of firebird itself.
Normally this is in /opt/firebird.

So open /opt/firebird/firebird.conf and search for RemoteBindAddress.
If there is a # in front, it will take the default.
But you need to make it without the # to make it accept 0.0.0.0 and use IPv4.

So this:

Code: [Select]

# ----------------------------
# Allows incoming connections to be bound to the IP address of a
# specific network card. It enables rejection of incoming connections
# through any other network interface. By default, connections from any
# available network interface are allowed.
# If you are using Classic Server, this setting is for Windows only.
# Under Linux, BSD or macOS, with Classic server, use xinetd or launchd
# configuration file (bind parameter).
#
# Type: string
#
RemoteBindAddress = 0.0.0.0

[Nicole]

now the answer is:

Code: Text  [Select][+][-]

1. tcp        0      0 0.0.0.0:3050            0.0.0.0:*               LISTEN      36884/firebird    

3050 is read and this looks as if it was left behind from the previous setting?

[rvk]

now the answer is:

Code: Text  [Select][+][-]

1. tcp        0      0 0.0.0.0:3050            0.0.0.0:*               LISTEN      36884/firebird    

3050 is read and this looks as if it was left behind from the previous setting?

This is correct. Now Firebird is listening on port 3050 for IPv4. You should be able to connect to it and access or create a database. If you get any errors, they are because of something else. Then you need to provide the errors (and connection options).

Do note that it could be that Firebird 5 can't read earlier versions of databases. Firebird reads ODS 13 databases. I think that's including Firebird 4. For earlier databases you need to do a backup and restore cycle.

[Nicole]

to reply in between:
Thank you for your good and precise answers.

It looked like it would work, but I read "unknown password". As my password is the same all the time, I am puzzled. I must refetch all the data from Windows. As there are many troubles on doing so, you do not want to read. I will report later, if the database is open finally.

The good news are: Flamerobin started and looks ok.

[rvk]

It looked like it would work, but I read "unknown password". As my password is the same all the time, I am puzzled.

In the past the default password for SYSDBA was masterkey.
On Windows it still is but on Linux it works ask for the SYSDBA password during installation (that's been a long time already).

If it didn't ask it might be empty and you need to change it first.

[rvk]

O, there also might be a ${fb_install_prefix}/SYSDBA.password file with the generated password. Easiest is to change it to masterkey is you want to use that. So... You need to check if there is a /opt/firebird/SYSDBA.password

You can see in the script it could also ask for password but I'm not sure if there are options for this. I thought it would have asked you during install.

[Nicole]

oups, this can be a topic.

I THOUGHT the default user would be admin, the time I installed Flamerogin.
And probably I keyed this in on installation.

As later connection did not work, I searched in my notices and found "SYSDBA". I keyed this into Flamerobin's registrations info. But maybe there is the false password around from installation still? It kept saying "permission not granted".

Shall I reinstall Firebird? Is there an easy way to correct my "admin"?
It is not proved that my installation-error gives me the trouble, as it should not, right?

[rvk]

oups, this can be a topic.

I just tested it and the install script definitely asks for the password of SYSDBA during install.

The hardest way to reset the password is

Code: [Select]

sudo systemctl stop firebird

rm /opt/firebird/security5.fdb  # this removes the old security database with forgotten password

<< copy a clean copy of security5.fdb to /opt/firebird, it's in the buildroot.tar.gz >>

sudo systemctl start firebird
But it's easier to just install over it.
During the install, the old firebird will be stopped, then the current installation in /opt/firebird will be archived in /opt/firebird-version.tar.gz, and a fresh copy will be install and started.

Don't forget to type in a correct password, maybe masterkey is easiest because it's the default on Windows and many Firebird installations.
After that, change the /opt/firebird/firebird.conf again to include the RemoteBindAddress 0.0.0.0
Restart the service instance (sudo systemctl restart firebird) and you should be good to go.

You can remove the archived /opt/firebird-version.tar.gz if all is running well.

[duralast]

Code: [Select]

tar -xvf buildroot.tar.gz --files-from=security5.fdbThat will extract the specific file from the tar archive.
Add "--strip-compnents 2" to remove the file structure.

[egsuh]

Installing Firebird 5 was straightforward, but defining "users" was not simple. Even sysdba has to be created, not given by default. Have you followed the steps to create users described in the installation guide?

Following is for Windows. Not sure the same is applied to Linux, but please give a read.

https://ib-aid.com/download/docs/fb5migrationguide.html#_manual_installation_of_firebird_5_0_in_windows