Subject Re: [firebird-support] can't access database from gpre
Author Helen Borrie
At 04:05 PM 23/02/2004 -0500, you wrote:
>I've recently set up an new machine (Suse Linux 9.0) and am trying to rebuild
>a library I wrote in Firebird 1.0.2 using ESQL for C. However I am getting
>an error from gpre on every *.e file in the database:
>
>$ make -f Makefile.lnx firebird
>/opt/interbase/bin/gpre -c -n -m dbutil.e
>connection rejected by remote interface
>(E) dbutil.e:68: Couldn't access database optix = 'optix.gdb'
>1 error, no warnings
>make: *** [dbutil.c] Error 1
>
>This worked on the old (now dead) machine. I can access optix.gdb from isql
>and from previously compiled code so the error makes no sense to me.
>The line in question is
>
>/* --- database declaration ------------------------------- */
>EXEC SQL BEGIN DECLARE SECTION;
>char db_name[256];
>EXEC SQL
> SET DATABASE optix = COMPILETIME 'optix.gdb'
> RUNTIME :db_name;
>EXEC SQL END DECLARE SECTION;
>
>The database, optix.gdb, exists in the same directory as I my files and is
>the
>same place I'm calling make. I have tried optix.gdb as a softlink and as an
>actual file. Permissions have been everything from -rw------- root roo to
>myself with -rw-r--r--
>
>Any ideas?

Only an idea...the user that started the server needs to have execute
rights on the *directory* where the database file is located. Was the
server perhaps started by a non-root user that does not have that privilege?

/hb