Firebird 5.02. - the root of all my troubles

[rvk]

Installing 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]

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]

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?

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]

I keep reading

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

1. *** IBPP::SQLException ***
2. Context: Database::Connect
3. Message: isc_attach_database failed
4.  
5. SQL Message : -902
6. Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
7.  
8. Engine Code    : 335544472
9. Engine Message :
10. 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]

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.

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]

Engine 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,

1.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]

Engine 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]

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]

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]

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]

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]

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]

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]

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.