Is there way to know has there been connectiosn to the _Server_ for awile (or last connection to Db through that server to any DB)

32 views
Skip to first unread message

Tommi Prami

unread,
Aug 18, 2025, 5:49:27 AMAug 18
to firebird-support
Hellon,

We have lot of customers that have FB259 server running, because we can't be sure that are there some other software on the computer running on that server,

If there would be a way to get that This server was used for DB connection 13.04.2021, then we could most likely ask user that we would like to uninstall the old firebird server,

Also how to uninstall Firebird from other Inno Setup Installer, have not needed that functionality before, Or if there has been one, it has been removed, I think.

-Tee-

Elmar Haneke

unread,
Aug 18, 2025, 7:36:10 AMAug 18
to firebird...@googlegroups.com


We have lot of customers that have FB259 server running, because we can't be sure that are there some other software on the computer running on that server,

If there would be a way to get that This server was used for DB connection 13.04.2021, then we could most likely ask user that we would like to uninstall the old firebird server,


FirebirdSQL does not offer a registry of all databases created. Therefore, you cannot simply ask server is some databases are left over after removing your applications' database.

If firebird.conf does restrict databases to a directory, you can look there if any files are left over.

Ideally the user should know from his documentation if multiple applications use the database server.

If nothing fits, "uninstall and wait for error report" is the only option.


Also how to uninstall Firebird from other Inno Setup Installer, have not needed that functionality before, Or if there has been one, it has been removed, I think.


You should invoke uninstaller from old installation.

Else you have to stop and remove firebird service.

If nothing else helps remove installation directory and reboot machine - firebird service will be unable to start afterward, but you leave some junk in configuration.


Elmar


Tommi Prami

unread,
Aug 18, 2025, 1:11:59 PMAug 18
to firebird-support
I do not need to know anything about any database.

Only that is the server used to connect any DB.

There is no such info in the log, that I could make any assumption is the server installation used or not.

Is the security db access/read/write time changed if some db is connected?

-tee- 

--
Support the ongoing development of Firebird! Consider donating to the Firebird Foundation and help ensure its future. Every contribution makes a difference. Learn more and donate here:
https://www.firebirdsql.org/donate
---
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion, visit https://groups.google.com/d/msgid/firebird-support/17f298db-6fbe-498d-a320-b7eb22e2e848%40haneke.de.

Tommi Prami

unread,
Aug 18, 2025, 1:14:20 PMAug 18
to firebird-support
Is the fb259, etc... Uninstaller location written it windows registry in known key?

Or some other solid way to find uninstaller without hardcoding path...

-tee-

Dimitry Sibiryakov

unread,
Aug 18, 2025, 3:02:47 PMAug 18
to firebird...@googlegroups.com
Tommi Prami wrote 18.08.2025 19:11:
> Is the security db access/read/write time changed if some db is connected?

Yes. Every connection start a transaction in the security database. You can
use gstat to watch the counters.

--
WBR, SD.

Tommi Prami

unread,
Aug 19, 2025, 1:01:39 AMAug 19
to firebird-support
Nice,

Maybe the file information would be easiest way to go.

Getting security db last write time is maybe where I go.

Tommi Prami

unread,
Aug 19, 2025, 1:05:51 AMAug 19
to firebird-support
Yellow,

If someone can point me in the right direction, to getting uninstaller locations. I would guess those are  in the registry.

Or is there ready to use code in  Firebird windows installer for uninstallation, to get that information per version.

But any information and ideas are welcome.

-tee-
Reply all
Reply to author
Forward
0 new messages