How does that work Rob? You dont even provide a port on local
connections. There is nothing else listening to 3050 or the tcp
loopback connection would fail. Local connections should work

The problem also exists on embedded which doesnt use TCP at all.

I have placed a bug report in the incident tracker. I do not know
this is definately related to the gsec error but it makes sense to me.

Adam




--- In firebird-support@yahoogroups.com, Robert martin <rob@c...>
wrote:

>
> Hi Ryan
>
> I would give it a go anyway. The local connection might be

defaulting

> to the SBS service whereas remote TCP/IP requests might be getting

the

> FB service.
>
> Rob Martin
> Software Engineer
>
> phone +64 03 377 0495
> fax +64 03 377 0496
> web www.chreos.com
>
> Wild Software Ltd
>
>
>
> Ryan Thomas wrote:
>
> >Hi Rob,
> >
> >The tcp connections to the database work fine, it's just the local
> >connections that give the 'unavailable database' error.
> >
> >Cheers,
> >
> >Ryan Thomas
> >TransActive Systems
> >
> >P: (02) 4322 3302
> >F: (02) 4325 1141
> >E: ryan@t...
> >W: http://www.transactive.com.au/
> >
> >
> >
> >
> >>Hi
> >>
> >>I just realized I think know the answer to this problem.

Amazing !!!

> >>
> >>The issue is probably related to small business server. A
> >>techie told
> >>me that One of the 'services' provided by SBS uses the same port

as

> >>Firebird. Try changing the firebird port to something different

and

> >>see if the problem goes away.
> >>
> >>Rob Martin
> >>Software Engineer
> >>
> >>phone +64 03 377 0495
> >>fax +64 03 377 0496
> >>web www.chreos.com
> >>
> >>Wild Software Ltd
> >>
> >>
> >>
> >>Ryan Thomas wrote:
> >>
> >>
> >>
> >>>Hi Adam,
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>>If anyone is running Windows 2003, try and connect to a

database

> >>>>using isql and a local string, and tell me I am not going nuts.
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>I gave it a try on a win2k3 small business server we have
> >>>
> >>>
> >>access to and came
> >>
> >>
> >>>to the same conclusion that you did. I get the unavailable
> >>>
> >>>
> >>database error
> >>
> >>
> >>>when trying to connect to the database with no other users
> >>>
> >>>
> >>on the system.
> >>
> >>
> >>>So, no - I guess you aren't going nuts ;)
> >>>
> >>>Cheers,
> >>>
> >>>Ryan
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>>Adam
> >>>>
> >>>>
> >>>>--- In firebird-support@yahoogroups.com, "Ryan Thomas"

<ryan@t...>

> >>>>wrote:
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>*snip*
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>>>Next thing I wanted to do was change the sysdba password

using

> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>gsec.
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>>In
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>the Command Prompt I did:
> >>>>>>>
> >>>>>>>C:\Program Files\Firebird\Firebird_1_5>bin\gsec -user
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>sysdba -password
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>>masterkey
> >>>>>>>
> >>>>>>>and got:
> >>>>>>>
> >>>>>>>unavailable database
> >>>>>>>unable to open database
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>This is the exact error message I received a week or two ago.

I

> >>>>>>believe there is a bug in Firebird 1.5 running on Windows

2003

> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>Server
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>>which prevents local connections from being made.
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>We also receive this message on all of our computers here (XP,

FB

> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>SS 1.5.2).
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>Local connections were fine when running FB 1.0 - after we

updated

> >>>>>everything we could no longer establish local connections. To

work

> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>around it
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>we just place a ':' in front of the database location (this is

the

> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>same as
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>specifying the localhostfor tcp connections, is it not?).
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>>I am unable to use the embedded version of our application on
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>Windows
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>>2003, unavailable database.
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>This is strange, whilst we cannot establish local connections

with

> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>SS, we
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>can get connections using FB embedded...
> >>>>>
> >>>>>*snip*
> >>>>>
> >>>>>We get the same results with iSQL.
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>>If someone can confirm this behaviour on their system, then I
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>will log
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>>it in the incident tracker, I do not believe it is specific

to our

> >>>>>>implementation because I have seen it on a customers server

as

> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>well.
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>>>So my question is, what have I missed that I am unable to

run

> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>gsec?
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>>My guess, gsec is trying to access the security database via

a

> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>local
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>>connection. On a side note, I hope this issue is resolved

before

> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>FB 2,
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>>because from memory you can not connect to the security

database

> >>>>>>directly then.
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>We also had the trouble accessing the security database

(adding

> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>users)
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>through IB_SQL when connected with localhost:database or
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>127.0.0.1:database
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>- we got the unavailable database error. To work around this

we

> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>changed the
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>ip to the actual ip of the machine I was on (in this case
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>10.1.1.45) and we
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>>could add users.
> >>>>>
> >>>>>I would love to know if there is a solution to this.
> >>>>>
> >>>>>Cheers,
> >>>>>
> >>>>>-Ryan
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>>>Adam
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>------------------------ Yahoo! Groups Sponsor
> >>>>>>--------------------~-->
> >>>>>>Get Bzzzy! (real tools to help you find a job). Welcome to
> >>>>>>the Sweet Life.
> >>>>>>http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/67folB/TM
> >>>>>>--------------------------------------------------------------
> >>>>>>------~->
> >>>>>>
>
>>>>>>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

++

> >>>>>>
> >>>>>>Visit http://firebird.sourceforge.net and click the Resources

item

> >>>>>>on the main (top) menu. Try Knowledgebase and FAQ links !
> >>>>>>
> >>>>>>Also search the knowledgebases at http://www.ibphoenix.com
> >>>>>>
>
>>>>>>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

++

> >>>>>>
> >>>>>>Yahoo! Groups Links
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>
> >>>>
> >>>>------------------------ Yahoo! Groups Sponsor
> >>>>--------------------~-->
> >>>>Get Bzzzy! (real tools to help you find a job). Welcome to
> >>>>the Sweet Life.
> >>>>http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/67folB/TM
> >>>>--------------------------------------------------------------
> >>>>------~->
> >>>>
>
>>>>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >>>>
> >>>>Visit http://firebird.sourceforge.net and click the Resources

item

> >>>>on the main (top) menu. Try Knowledgebase and FAQ links !
> >>>>
> >>>>Also search the knowledgebases at http://www.ibphoenix.com
> >>>>
>
>>>>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >>>>
> >>>>Yahoo! Groups Links
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>
> >>>
>
>>>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >>>
> >>>Visit http://firebird.sourceforge.net and click the Resources

item

> >>>on the main (top) menu. Try Knowledgebase and FAQ links !
> >>>
> >>>Also search the knowledgebases at http://www.ibphoenix.com
> >>>
>
>>>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >>>
> >>>Yahoo! Groups Links
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>------------------------ Yahoo! Groups Sponsor
> >>--------------------~-->
> >>Get Bzzzy! (real tools to help you find a job). Welcome to
> >>the Sweet Life.
> >>http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/67folB/TM
> >>--------------------------------------------------------------
> >>------~->
> >>
> >>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >>
> >>Visit http://firebird.sourceforge.net and click the Resources item
> >>on the main (top) menu. Try Knowledgebase and FAQ links !
> >>
> >>Also search the knowledgebases at http://www.ibphoenix.com
> >>
> >>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >>
> >>Yahoo! Groups Links
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
> >
> >
> >++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> >Visit http://firebird.sourceforge.net and click the Resources item
> >on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> >Also search the knowledgebases at http://www.ibphoenix.com
> >
> >++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> >Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>