Hi. I have a problem. I use a Firebird 1.5.6 Server for a lot of
applications, 5 databases on the same server.
I need to find the number of connection for a single database, and the names
of the users. For this i used IBX IBDatabaseInfo-UserNames-Count and
IBDatabaseInfo-UserNames-Strings[i], in Builder C++.
The problem is if i have started a lot of application, the number of
connections is the TOTAL connections to the SERVER, not only for my
database. I have only one connection to my TIBDatabase, but
IBDatabaseInfo-UserNames-Count report 3, with 2 connection to another
application, different database!!!
Give my a valid solution to find only UserNames connected to my database!!!
Can't be done in v.1.5, sorry. Firebird users connect to the server, then
the server connects them to a database. You could make a log table in each
database that records logins and logouts.
From v.2.1, you have the MON$ATTACHMENTS table that you can query. It
works only with databases of ODS 11.1.
Coming in Firebird 3 is the ability to have a dedicated security database for
each database - even to embed a security database inside a user database.
Are you sure this is impossible, Helen? We used Fb 1.5 way after its
best before date (upgraded only a year or two ago), and I'm almost
certain I used IB_SQL to verify no-one was connected to the database of
interest before doing DDL (though you made me doubt, I'm no longer 100%
certain the databases were on the same server, we had at least two
Firebird servers).
This link http://www.firebirdfaq.org/faq10/ indicates that using the
services API with SuperServer it is possible to find active connections,
but it doesn't say anything about it being per database or not.
Set
++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++
Yahoo Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
* Your email settings:
Individual Email | Traditional
* To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
* To change settings via email:
firebird-support-dig...@yahoogroups.com
firebird-support-fullfeatu...@yahoogroups.com
* To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com
* Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/