Hi

Yeah, I could be on the wrong track but I thought it was worth a go :)

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,
>
>I'm not 100% on this, but doesn't the local connection protocol bypass the
>tcp stack, so it shouldn't really matter if there's something else there or
>not.
>
>I'll have a look anyway.
>
>Cheers,
>
>Ryan Thomas
>TransActive Systems
>
>P: (02) 4322 3302
>F: (02) 4325 1141
>E: ryan@...
>W: http://www.transactive.com.au/
>
>
>
>
>>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@...
>>>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
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>------------------------ Yahoo! Groups Sponsor
>>--------------------~-->
>>Fair play? Video games influencing politics. Click and talk back!
>>http://us.click.yahoo.com/T8sf5C/tzNLAA/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
>
>
>
>
>
>
>
>
>
>
>