Firebird 5.02. - the root of all my troubles lazarus / 16-Databases ---------------------------------------------------------------------- Nicole · 2025-06-12 09:23 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][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i 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 · 2025-06-12 09:37 Quote from: Nicole on June 12, 2025, 11:23:41 amThe 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. Quote from: Nicole on June 12, 2025, 11:23:41 amAnd: 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 Quote from: Nicole on June 12, 2025, 11:23:41 amBoth have nasty error messages now. Without knowing the messages, we can't help. ---------------------------------------------------------------------- Nicole · 2025-06-12 10:42 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][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i  whereis libfbclient.so► Code: Bash  [Select][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i libfbclient.so: /usr/lib/x86_64-linux-gnu/libfbclient.so Code: Text  [Select][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i sudo netstat -tulpn | grep 3050► Code: Bash  [Select][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i ltcp6     0      0 :::3050                 :::*                    LISTEN      33230/firebird ---------------------------------------------------------------------- rvk · 2025-06-12 11:15 Quote from: Nicole on June 12, 2025, 12:42:17 pmCode: Text  [Select][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i sudo netstat -tulpn | grep 3050► Code: Bash  [Select][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i 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 · 2025-06-12 12:52 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 · 2025-06-12 12:59 Quote from: Nicole on June 12, 2025, 02:52:53 pmHow 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 · 2025-06-12 13:21 now the answer is: Code: Text  [Select][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i 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 · 2025-06-12 13:51 Quote from: Nicole on June 12, 2025, 03:21:24 pmnow the answer is: Code: Text  [Select][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i 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 · 2025-06-12 15:42 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 · 2025-06-12 16:09 Quote from: Nicole on June 12, 2025, 05:42:36 pmIt 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 · 2025-06-12 16:11 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 · 2025-06-12 18:30 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 · 2025-06-12 20:52 Quote from: Nicole on June 12, 2025, 08:30:51 pmoups, 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 · 2025-06-12 21:52 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 · 2025-06-13 02:16 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_instal lation_of_firebird_5_0_in_windows ---------------------------------------------------------------------- rvk · 2025-06-13 02:51 Quote from: egsuh on June 13, 2025, 04:16:12 amInstalling Firebird 5 was straightforward, but defining "users" was not simple. Even sysdba has to be created, not given by default. No, SYSDBA is created by default by the install.sh script. The script asks for the password for SYSDBA after which it can be used without problems. The link you mentioned is only for manual installation if you are doing all the things the install.sh script (or the installer on Windows) does yourself. Adding new users (other than SYSDBA) also isn't that hard. Just a simple command with gsec. As a side note... Users are created and stored seperatly from your own database. That means if the database is be copied to another machine, there is no security copied with it and the database is freely accessible. That's why it's important to also limit the permissions to the database of security is a concern. Starting from Firebird 3.0 there is an option for encryption of databases but it's always better to limit access in those cases. ---------------------------------------------------------------------- Nicole · 2025-06-13 13:23 oh! I have so many problems, that I did not follow the database problem any more and did not copy it another time. How to use on my databases if the permissions are not copied? They are at the moment in a Windows 7 VM and know Firebird 4. No secrets on them. I am a single user and just want to transfer them to my Linux VM. I rather would prefer to use them without password. However all my code is ready to use the default settings. ---------------------------------------------------------------------- rvk · 2025-06-13 13:48 Quote from: Nicole on June 13, 2025, 03:23:48 pmI have so many problems, that I did not follow the database problem any more and did not copy it another time. How to use on my databases if the permissions are not copied?There is no problem... you can just copy a database from one place to another. (normally a backup and restore cycle is advised if you go from one platform to another, but I've never had any problem with it) Firebird 4 uses ODS 13.0 and Firebird 5 can handle 13.0 without any problem (although it will create ODS 13.1 so you can't copy a newly created database in Firebird 5 back to Firebird 4). Code: [Select]Server version  Main ODS  Can work with ODS    Note Firebird 2.5    11.2      10.x/11.x            ODS 11.2 is incompatible with Firebird 2.0/2.1. Firebird 3.0    12.0      Does not support previous ODS, only 12.0  Firebird 4.0    13.0      13.0  Firebird 5.0    13.1      13.0, 13.1           Database can be upgraded from 13.0 to 13.1 with gfix -upgrade from 13.0, or with backup/restorehttps://ib-aid.com/en/articles/all-firebird-and- interbase-on-disk-structure-ods-versions/ So you can just copy the database to Linux and use it with the SYSDBA and password you created in the installation in Linux (preferably masterkey if there are no further security concerns). ---------------------------------------------------------------------- Nicole · 2025-06-13 14:50 I keep reading Code: Text  [Select][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i *** IBPP::SQLException ***Context: Database::ConnectMessage: isc_attach_database failed SQL Message : -902Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements Engine Code    : 335544472Engine Message :Your user name and password are not defined. Ask your database administrator to set up a Firebird login. and a rather strange thing: my database has the ending *.FDB" in captial letters. Not my idea, any restore tool did this. Flamerobin does not find it. I have to click "*.*" for show all files, to see my database at all. ---------------------------------------------------------------------- rvk · 2025-06-13 14:55 Quote from: Nicole on June 13, 2025, 04:50:15 pmand a rather strange thing: my database has the ending *.FDB" in captial letters. Not my idea, any restore tool did this. Flamerobin does not find it. I have to click "*.*" for show all files, to see my database at all. That doesn't matter. As long as the chosen database is correct. The errors shows something about the username and password. Did you provide the password when installing Firebird 5? If not or you don't know, then reinstall as described earlier. If you only overwrote the security5.db then you need to set the password. So it's easier to reinstall because that asks for the password. ---------------------------------------------------------------------- egsuh · 2025-06-15 00:25 QuoteEngine Code    : 335544472 Engine Message : Your user name and password are not defined. Ask your database administrator to set up a Firebird login. This is what I experienced several times. In the link I attached previously, Quote1.1. Initialization of SYSDBA Starting from Firebird 3.0, the SYSDBA user is not initialized by default (for the SRP user management plugin), so you need to explicitly create a user and specify a password for him. This can be done in two ways: using the console tool for executing interactive queries isql.exe and the console tool for managing the security database gsec.exe. Somewhere else, I have read some regards on "SRP", which I do not know. ---------------------------------------------------------------------- rvk · 2025-06-16 07:40 Quote from: egsuh on June 15, 2025, 02:25:38 amQuoteEngine Code    : 335544472 Engine Message : Your user name and password are not defined. Ask your database administrator to set up a Firebird login. This is what I experienced several times. Hence my repeated question if there was a password prompt when using install.sh. But it should ask for the password of SYSDBA during installation (I tested this out). Only when not using this script, you need to setup the administrator user manually. ---------------------------------------------------------------------- Nicole · 2025-06-16 09:09 Thank you, I will keep the information and come back to Linux either if I have more time for it or Lazarus 4.1. is released. My whole Linux VM is suspepended because Lazarus 4 does not work for me not even without the database. ---------------------------------------------------------------------- incendio · 2025-06-20 08:15 Just for info, I have installed FB 5 on Ubuntu 22 VM via install.sh. During installation it was asked for sysdba password. Restore a dba on Ubuntu, give read and right permission to dba after restored. Connection from windows os with flamerobin is smooth. My advice is reinstall again, there's a reinstall script and make sure you don't miss sysdba password when asked. ---------------------------------------------------------------------- Nicole · 2025-06-20 19:54 thanks for the info. Does Lazarus 4 work fine for you? This was a disaster here. So my Linux VM is suspended. I used Linux Xia Cinnamon and heard, that I am not alone with my troubles. ---------------------------------------------------------------------- incendio · 2025-06-20 22:27 No, it won't ran after I rearrange windows layout for source editor, message, etc When I tried to open it, flash screen appeared than crashed. So I have to un-installed it and go back to the old version. ---------------------------------------------------------------------- Nicole · 2025-06-21 08:19 Same here! I wanted to do the big deal and to start all from scratch. So I started a very new project by adding containers. They should be populated later by code. I could not even move my first panel. It stayed where it was and after this it jumped to the other side. Then all froze that often. After 2 days I gave up. So the problem shall be the basic layout. Somebody here suspected the basic graphic interaction as not working. ---------------------------------------------------------------------- cdbc · 2025-06-21 08:38 Hi I'm not familiar with this 'XIA-Cinnamon-Linux', does it by any chance use 'Wayland'?!? If so, then All bets are off! (you've basically /banged/ your head against the gate, coming out of the starting-box)  MeThinks you got the wrong Linux to play with. Start with some of the easier distros, plenty of those around... I'm writing this, 'cause I'm running 3 different laptops successfully with: 1) Development: HP - PCLinuxOS 64bit     - Fpc 3.2.2 - Laz 3.8  (from linux repo) and     - Fpc 3.3.1 - Laz 4.99  (main/trunk) 2) Business: Lenovo - PCLinuxOS 64bit     - Fpc 3.2.2 - Laz 3.8  (from linux repo) and     - Fpc 3.3.1 - Laz 4.99  (main/trunk) 3) Old/Spare: Lenovo - PCLinuxOS 32bit     - Fpc 3.2.2 - Laz 3.8  (from linux repo) In lieu of the above, I'm having difficulties understanding all your troubles  -- Been running this setup for years now -- (well, repo/release versions & main/trunk versions) Regards Benny ---------------------------------------------------------------------- Nicole · 2025-06-21 09:20 I heard this "Wayland" before. Not sure, but probably: yes, I did. My Linux journey is over. I am no programmer and only program because I need a certain software functionality. Instead of doing my business, I am programming. Instead of programming I am messing OSs. I have to stop this and stay tuned.