At 10:45 a.m. 12/05/2015, 'David E. Wheeler' david@... [firebird-support] wrote:

>Firebirders,
>
>I have been using the firebird-classic RPM for testing Sqitch, connecting like so:
>
>
> isql-fb -u sysdba -p masterkey
>
>
>This worked well, but now I’d like to use superserver, instead. So I removed that RPM and installed 2.5.4.26856.0-1.el6 from EPEL and fired up the server with `sudo service firebird-superserver start`.

Use the fbmgr executable to manage superserver. But there is no default 'masterkey' password for SYSDBA. You should find a temporary password in a text file named "SYSDBA.password" in the Firebird root directory. As to *which* directory that would be in an EPEL install, I don't know; but search for that file.

In the /bin/ directory of the Firebird installation (or the EPEL equivalent) you should find a script named "changeDBAPassword.sh", if you want a quick way to make a password you like better.

>But now the above command is unable to connect me:
>
>
> $ isql-fb -u sysdba -p masterkey
> Use CONNECT or CREATE DATABASE to specify a database
> SQL> create database 'foo';
> Statement failed, SQLSTATE = 08004
> connection rejected by remote interface

Means either the Superserver isn't running or you have an incompatible version of isql. I'm guessing the first. Supposing the password is 'whatever', get into Firebird's /bin/ directory and start it with this:

./fbmgr -start -once -user SYSDBA -password whatever

Or, if you prefer to have the Guardian running:

./fbmgr -start -forever -user SYSDBA -password whatever

>What do I need to tweak to get it so that I can connect and create a database? The hosts file includes “localhost” as a name for 127.0.0.1, for what that’s worth, so I doubt it’s a host name issue.

Either localhost or 127.0.0.1 is OK. Or the hostname of the server. With SS, you must use one of them - SS cannot accept direct connections to databases. And when you finally get around to creating a database, provide either the full path or a pre-entered database alias, otherwise that database will be created in the cwd.

BTW, forget about xinetd. It is not in the picture for SS.


Helen Borrie, Support Consultant, IBPhoenix (Pacific)
Author of "The Firebird Book" and "The Firebird Book Second Edition"
http://www.firebird-books.net
__________________________________________________________________