Subject | firebird 1.5 losing default hostname or something ... |
---|---|
Author | kiwicmc |
Post date | 2004-05-28T03:05:33Z |
Hi,
I have 1.5 installed on a w2k server. I've had 1.0.3 working fine
previously on this box. I've uninstalled, reinstalled etc etc.
Problem seems to be that the applications can't find the local machine
by default.
So I've done this after unzipping latest download (also tried the
setup.exe deal):
C:\Program Files\Firebird\Firebird_1_5\bin>install_super.bat
C:\Program Files\Firebird\Firebird_1_5\bin>instreg install -z
instreg version WI-V1.5.0.4290 Firebird 1.5
Firebird has been successfully installed in the registry.
C:\Program Files\Firebird\Firebird_1_5\bin>instsvc install -auto
-superserver -guardian -z
instsvc version WI-V1.5.0.4290 Firebird 1.5
C:\Program Files\Firebird\Firebird_1_5\bin>instsvc start
Service "Firebird Guardian - DefaultInstance" successfully started.
Then I do this:
C:\Program Files\Firebird\Firebird_1_5\bin>gsec
unavailable database
unable to open database
But if I do this:
C:\Program Files\Firebird\Firebird_1_5\bin>gsec -database
"localhost:c:\program files\firebird\firebird_1_5\security.fdb" -user
sysdba -password masterkey
GSEC>
I get in, and can add a user without problems:
GSEC> add chris -pw pwd
GSEC> display
user name uid gid full name
--------------------------------------------------------------------------------
SYSDBA 0 0
CHRIS 0 0
GSEC> quit
Then I next have the following problem:
C:\Program Files\Firebird\Firebird_1_5\bin>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> CREATE DATABASE "C:\firebird\test.fdb" user "chris" password "pwd";
Statement failed, SQLCODE = -904
unavailable database
SQL>
And once again can only create or connect to databases with a fully
qualified path.
SQL> CREATE DATABASE "localhost:C:\firebird\test.fdb" user "chris"
password "pwd";
SQL>
So obviously something isn't set right in the networking of my w2k
box, although ping and nslookup work fine. Anyone have any ideas?
Regards,
Chris
I have 1.5 installed on a w2k server. I've had 1.0.3 working fine
previously on this box. I've uninstalled, reinstalled etc etc.
Problem seems to be that the applications can't find the local machine
by default.
So I've done this after unzipping latest download (also tried the
setup.exe deal):
C:\Program Files\Firebird\Firebird_1_5\bin>install_super.bat
C:\Program Files\Firebird\Firebird_1_5\bin>instreg install -z
instreg version WI-V1.5.0.4290 Firebird 1.5
Firebird has been successfully installed in the registry.
C:\Program Files\Firebird\Firebird_1_5\bin>instsvc install -auto
-superserver -guardian -z
instsvc version WI-V1.5.0.4290 Firebird 1.5
C:\Program Files\Firebird\Firebird_1_5\bin>instsvc start
Service "Firebird Guardian - DefaultInstance" successfully started.
Then I do this:
C:\Program Files\Firebird\Firebird_1_5\bin>gsec
unavailable database
unable to open database
But if I do this:
C:\Program Files\Firebird\Firebird_1_5\bin>gsec -database
"localhost:c:\program files\firebird\firebird_1_5\security.fdb" -user
sysdba -password masterkey
GSEC>
I get in, and can add a user without problems:
GSEC> add chris -pw pwd
GSEC> display
user name uid gid full name
--------------------------------------------------------------------------------
SYSDBA 0 0
CHRIS 0 0
GSEC> quit
Then I next have the following problem:
C:\Program Files\Firebird\Firebird_1_5\bin>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> CREATE DATABASE "C:\firebird\test.fdb" user "chris" password "pwd";
Statement failed, SQLCODE = -904
unavailable database
SQL>
And once again can only create or connect to databases with a fully
qualified path.
SQL> CREATE DATABASE "localhost:C:\firebird\test.fdb" user "chris"
password "pwd";
SQL>
So obviously something isn't set right in the networking of my w2k
box, although ping and nslookup work fine. Anyone have any ideas?
Regards,
Chris