Subject Re: [ib-support] Problem with user creation
Author Paul Reeves
On Mon, 29 Apr 2002 12:09:46 -0000, pcdsoftdev wrote:
> Hi, I'm using "SO-T0.9.4.49 Firebird Test1" as the server (solaris)
> and V6.0.1.0 Interbase client to connect to a database.
> My problem is that when I'm trying to add a user (I'm in as
> SYSDBA), I get an error of...
> "I/O error for file 'isc4.gdb' Error while trying to open file No
> such file or directory" Very strange, as I have already logged in
> to another database on the same server fine. How can Interbase let
> me log into a server,which needs isc4 to authenticate, but will not
> let me add / modify / delete a user?

The error is an OS one, indicating that you are logged in as a user who has neither ownerships nor group access rights . That said, I couldn't reproduce the error with gsec, although I could with ISQL.

BTW, I recommend that you upgrade to Firebird 1.0 for the server. It won't solve this problem, but it will forestall others. I'd also recommend that you match the client libraries to the server if possible. That can be another source of problems, as no-one does QA of mismatched server/client combos.

Paul Reeves
Supporting users of Firebird and InterBase