--- In firebird-support@yahoogroups.com, "Adam" <s3057043@y...> wrote:

>
> Is Firebird running in services? I have personally found the

control

> panel applet says funny things on 2003 server (but I know it is a
> security permissions thing for us).

Yes. The firebird service says that it is running and the
fbserver.exe process is in the windows active process list.

> If Firebird service is running, does it have full permissions to

the

> fdb file?

Windows file protections are now so versatile and feature-rich that
it is nearly impossible to tell if a process has access to a file. I
have granted all kinds of access to "LOCAL SERVICE", "SERVICE",
and "NETWORK SERVICE" as well as running the service as a user and
granting that user access. I've also tried granting access to
Everyone. I've tried all of the above with full control and numerous
combinations of inherited access to the entire installation
directory. If fbserver doesn't have access to that file, it isn't
letting on. I welcome suggestions of other file protection
combinations. I would also like to know if there's some way to get
fbserver.exe to tell me that this is an access problem.

> Can you telnet into localhost:3050?

Good point. Yes, localhost is accepting connections on 3050. The
netstat command shows a listener on this port whose pid corresponds
to the fbserver.exe process. So, it's definitely running.

> Paste your command line for gsec here so you can be sure it is
> nothing silly.

C:\>gsec
unavailable database
unable to open database

C:\>

>
> Adam
>
> --- In firebird-support@yahoogroups.com, "jlwa1ker" <walker@j...>
> wrote:
> >
> >
> > I have Firbird 1.5.2 installed on a Windows 2003 server running

as

> a
> > service. The service applet shows that firebird is running and

the

> > firebird log file doesn't show any errors. However, if I just
> > type "gsec" on a command line I get:
> >
> > unavailable database
> > unable to open database
> >
> > However, if I run Firebird as an application, everything works
> fine.
> > Unfortunately, I'm using it as the back end of a web app so I

can't

> > count on a particular user being logged in all the time -- nor
> would
> > I want to.
> >
> > I suspect that it's a permissions thing, but I have tried

granting

> > all kinds of permissions to the firebird install directory and I
> > always get the same thing. I've also tried running the service as
> the
> > same user for which it works as an application and get the same
> error.
> >
> > Does anyone have any ideas how to debug this with so little
> > information? Or... how do I get more information?
> >
> > -- Les Walker