On Thursday, June 28, 2001, at 08:02 AM, Ann W. Harrison wrote:

> At 03:48 AM 6/28/2001 +0000, Carlos Yu wrote:
>
>> I installed the Free BSD version ... The exact error message is:
>>
>> Statement failed, SQLCODE = -902
>> operating system directive semget failed
>> -No such file or directory
>
> My guess is that you need to increase the number of semaphores
> and rebuild the kernel. Firebird is trying to set up the shared
> lock table - the "file" it can't find is a shared memory region.

Ann is right. In addition you might not have semaphores compiled into
your kernel. There are a number of different semaphore API's. The one
in question that Firebird uses is System V semaphores. I'm not on a
FreeBSD box, but the man page for semget might have more information on
how to change the number of semaphores in your system.

-John