Hi Adam,

it seems there is are network problems to me.

We get some error in our some customers network.
Here is my solution:
create a log table for LOGIN-LOGOUTS.

create table mylog(
user_name varchar(64),
IO smallint not null, -- 0=login, 1=logout
MAC_ID VARCHAR(12),
ACTION_TIME TIMESTAMP not null default 'now',
...
);

Add some code to your applications head and trail like this:
...
connect to db.
begin transaction
post a new row to log file as client is connected (LOGIN)
commit transaction.
...


...
post a new row to log file as client is disconnected (LOGOUT)
commit transaction.
disconnect connections.
application.terminate.


Then, check your login and logout(log) rows order by
MAC_ID,ACTION_TIME.
You can detect which terminal/user/link is problematic.
There is get_context function in FB2.0 to get MACs, also you can
send NIC# from cleints.

Regards.

Ali

--- In firebird-support@yahoogroups.com, Adam Thick
<adam.thick@s...> wrote:

>
> Hi,
> we are running Debian Sarge with firebird2-classic-server

installed,

> actual version is ISQL Version: LI-V1.5.1.4500 Firebird 1.5
> having experienced crashes at least once a week with the super

server I

> removed it and installed classic, it appeared to be working great

but

> we're experiencing the same kind of errors we did under super

server...

> that is to say I'm not sure if it's the same error but it's

definitely

> having the same result and that is that no users are able to

connect to

> the db. Error messages in the logs haven't been terribly helpful,

and

> I've been searching for a while to try and find their meaning...

if

> someone could give me a clue as to what they mean it would be

great.

>
> hostname Tue Oct 4 15:55:41 2005
> INET/inet_error: read errno = 104
>
> hostname Fri Oct 7 09:48:57 2005
> INET/inet_error: read errno = 104
>
> hostname Fri Oct 7 10:10:20 2005
> INET/inet_error: read errno = 104
>
> hostname Fri Oct 7 10:10:21 2005
> INET/inet_error: read errno = 104
>
> hostname Tue Oct 11 13:39:07 2005
> INET/inet_error: read errno = 104
>
> hostname Tue Oct 11 16:33:01 2005
> INET/inet_error: read errno = 104
>
> hostname Tue Oct 25 16:05:01 2005
> INET/inet_error: read errno = 88
>
> Thanks very much
> Cheers,
> Adam Thick.
>
> --
> Adam Thick
>
> Strategic Data Pty Ltd
>
> Ph : +61 (3) 9348-2013
> Fax: +61 (3) 9348-2015
> Mob: 0404 032 763
> Email: Adam.Thick@S...
> Web: http://www.StrategicData.com.au/
> Post: P.O. Box 4262
> Melbourne University, VIC 3052
> Australia
>