Hi Helen,

Helen Borrie wrote:

>At 05:47 PM 25/10/2005 +1000, you 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
>>
>>
>
>OK, the first thing I suggest you try to do is get in touch with the Debian
>package maintainer for Firebird 1.5.x to find out whether you can get a
>newer, more stable deb package for Firebird 1.5. Those original Debian
>Sarge builds were not stable. Unfortunately, the Firebird project doesn't
>have any control over what Debian distributes; but those old 1.5.1 builds
>should be considered suspect.
>
>Try this page:
>http://alioth.debian.org/forum/forum.php?forum_id=1888
>
>There you can find links to the appropriate forum, list, etc. (alioth is
>like a Sourceforge-for-Debian).
>
>
>

Thanks for this link.
We weren't sure but suspected this might be the case... currently
considering backporting firebird debian packages from testing or
installing from tar ball.

>>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.
>>
>>
>
>Well, they are network (socket) errors. The log info is faulty (unless you
>replaced the real hostname of your server with the word "hostname"!) We
>should see the network node name of the server in these messages.
>
>
>

yeah that was me... I replaced my hostname with 'hostname', just being a
paranoid dork...

>>hostname Tue Oct 4 15:55:41 2005
>> INET/inet_error: read errno = 104
>>
>>
>
>The 104 error is "Connection reset by peer". It means the server lost the
>connection to the client. Reasons for this? Many! Client terminated the
>connection abnormally, somehow. Application crash? Server crash? (Using a
>bad UDF?) Using a wireless network? Or are you trying to access a
>database that is located on a network drive? (DBs must be on a local
>drive), etc., etc.
>
>
>
>>hostname Tue Oct 25 16:05:01 2005
>> INET/inet_error: read errno = 88
>>
>>
>
>"Socket operation on non-socket". Client or host is trying to access a
>socket that's not there. It follows on from 104, probably. But it will
>also show up if your server has been connected to a database on a network
>drive and *that* socket has been lost...
>
>So - no short answers. It's impossible to tell from this info whether this
>is problems with your Debian package, network configuration or the physical
>layout of the network.
>
>./heLen
>
>
>

A connection is made from host01 to host02 ie. isql-fb
host02:/var/lib/firebird/data/database.fdb. No network drives in use and
we're using FreeUDFLibC.
Thanks for the info helen, has been a great help.
We've been running firebird since it was open sourced, when it was still
/opt/interbase and have never had any problems until now.


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@...
Web: http://www.StrategicData.com.au/
Post: P.O. Box 4262
Melbourne University, VIC 3052
Australia