[Mono-list] Mono Firebird Database Access - only works as root

[Reilly, Andrew]

I'm experiencing a problem using the Firebird .NET Data Provider v1.6.1.
with Mono. Another user has already raised this on both lists but there's
been no luck so far in finding a solution.

When trying to connect to a Firebird database using the Firebird .NET Data
Provider v1.6.1 as a 'normal', unprivileged user the following exception is
thrown:

Unhandled Exception: FirebirdSql.Data.Firebird.FbException: Unable to
complete network request to host "10.8.16.212".

in <0x000d0> FirebirdSql.Data.Firebird.FbDbConnection:Connect ()
in <0x0004f> (wrapper remoting-invoke-with-check)
FirebirdSql.Data.Firebird.FbDbConnection:Connect ()
in <0x00342> FirebirdSql.Data.Firebird.FbConnectionPool:CheckOut
(FirebirdSql.Data.Firebird.FbDbConnection)
in <0x00058> (wrapper remoting-invoke-with-check)
FirebirdSql.Data.Firebird.FbConnectionPool:CheckOut
(FirebirdSql.Data.Firebird.FbDbConnection)
in <0x00197> FirebirdSql.Data.Firebird.FbConnection:Open ()
in <0x00066> Test:Main (string[])

However, if the program is run as root then the connection proceeds without
any problems. The same thing happens whether it is my test program or the
demo Firebird program on go-mono.com . I've tried on both Red Hat 9 (kernel
2.4.20) and SuSE 7.3 (kernel 2.4.10) and had the same result. When running
under the MS .NET runtime on Win2K there are no problems.

It must be some kind of permissions problem. Is there a Mono equivalent of
the MS caspol.exe security policy management tool? Does Mono actually
implement security zones in the same way? If I try to connect to a
PostgreSQL database using Npgsql then I don't have any problems.

Does anyone have any ideas?

Andrew

----------------------------------------------------------------------------
--
Andrew J Reilly
Imaging Physicist

Oncology Physics Department
Western General Hospital
Crewe Road South
EDINBURGH
EH4 2XU
Tel: +44 131 537 1000 page 5641 or + 44 131 537 1161
Fax: +44 131 537 1092 






**********************************************************************
The information contained in this message may be confidential or legally privileged and is intended for the addressee only, If you have received this message in error or there are any problems please notify the originator immediately. The unauthorised use, disclosure, copying or alteration of this message is strictly forbidden.
**********************************************************************