--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> What about the Firebird server? Classic? Superserver? both?

As far as I know, there is no server. I just have a PERL XS module
that I linked to this library:

[root@fedora fb]# ls -sal /usr/lib/libgds*
0 lrwxrwxrwx 1 root root 26 Feb 22 05:24
/usr/lib/libgds.so -> /root/fb/lib/libfbembed.so
0 lrwxrwxrwx 1 root root 26 Feb 22 05:24
/usr/lib/libgds.so.0 -> /root/fb/lib/libfbembed.so

I downloaded:

firebird-1.5.2.4731.tar

and built it.

As far as I know, I see httpd processes and assume that these
processes are just execute scripts-- no fancy threading.

Maybe if I use rpm it will compile correctly as opposed to just
running configure with my custom prefix and then make at the command
line?

Since I just use the embedded library, NPTL shouldn't be an issue...

>
>
> >For whatever reason, I think that I fixed things to the point where
> >they work OK.
> >
> >The only major problem is that the system is now crashing.
>
> That doesn't seem very OK to me.
>
> >I told my customer that I've never heard of firebird or interbase

doing this.

>
> Which is true. But apparently it's doing it, so there is a first

time for

> everything.
>
>
> >Essentially, Apache runs a script which uses the embedded library

as

> >user apache.
>
> Gulp.
>
>
> >When I first set up the system, the semaphores were owned by apache
> >(since it kicked off fb_lock_mgr) and when root tried to run isql,
> >the isql script would hang.
> >
> >So then I setuid and chmod +s on the fb_lock_mgr program.
> >
> >That let multiple users access the database but then the system
> >started crashing, as mentioned.
>
> You'll help yourself a lot by telling us which server you are

using. Do a

> rpm -qa | grep Firebird
>
> and report the *exact* name of the installed package. (If it's
> FirebirdSS... and it's not the NPTL version then there will be one

major

> cause of the problem. If there is more than one, then that's

another. If

> you're also running a version of Apache that isn't NPTL-aware, then

that's

> another. I can't help with troubleshooting threading problems with

Apache.

>
>
> >When I got home today, I thought about using an inittab boot entry

to

> >launch fb_lock_mgr so it runs as root and creates semaphores as

root.

> >
> >At this point, I don't know what to think about the crashes.
> >
> >Does anyone think it's possible for embedded firebird to crash a
> >fedora linux server?
>
> If the configuration is screwed, anything can happen. If you (or

your

> "Apache script" <gulp>) are trying to multi-thread libfbembed.so,

then

> anything can happen. If you're trying to mix libfbembed.so with
> Superserver then anything can happen.
>
>
> >The system seems to crash in close proximity to when I run isql so

I

> >was thinking about fb_lock_mgr.
>
> I haven't tried to mismatch fb_lock_manager and server owners but I

reckon

> it could cause some sparks to fly.
>
> At some point you will have provided enough information about your

setup

> for *someone* to be able to help...we're not there yet.
>
> ./heLen