Subject Re: [firebird-support] Gsec Problem
Author Helen Borrie
At 03:53 PM 18/12/2009, you wrote:
>I have firebird 1.5 on Vista and am having trouble using Gsec to establish new user - password combinations. At the command prompt when I enter:
>gsec -user sysdba -password masterkey
>I get the message "unavailable database".
>What is wrong here?

You're trying to use the IPCServer transport that's implemented in Fb 1.5 on Vista. It doesn't work there.

Use TCP/ip local loopback.

1. Put an alias in aliases.conf for the path to your security.fdb, e.g.
sec = C:\Program Files\Firebird\Firebird_1_5\security.fdb

2. Call gsec as follows:

gsec -se localhost:service_mgr -database sec -user SYSDBA -password masterkey

localhost isn't available on some Vista workstations. If it's not, substitute the hostname or internal IP address of the computer.