Hi,

I cannot answer which program is which on a machine.

However client machines can be found out. I use firebird 1.5x . the may be a more simple way for firebird 2.x.

Using the same approach I would use for any connection using IP.

run
'netstat -nap --tcp | grep fb_inet'
or 'netstat -nap --tcp | grep <ip address in question>'
or
'lsof -I'

they will give you an idea of what is going on regarding sockets in use and IP connected, providing the pid with which other look up can be done( such as 'ps' )

Google lsof. Or netstat. If you know some scripting you can go further that this with awk, cut and so on. For instance linking process hungry queries to hosts. Though we have added logging on the client side for slow queries as the later can slow the database server . Server side, we log application, user and machine at user login, along with firebird pid.

Hope that's a starting point.

alex




-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Dimitry Sibiryakov
Sent: 01 June 2009 22:38
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] How to know client connect to database that is on same machine server?

> Please help me, I want to know, client connect to database at server,
> which client program running on database server machine?

If used XNET protocol, then - yes, client is on the same computer.
Otherwise - no easy way tell it for sure.

SY, SD.


------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links