connection rejected by remote interface

[Ted Miglautsch]

Now I am trying to get a second test production system with Open SuSE
10.3 to run Interbase. I loaded what I (thought was) loaded on the first
system. I still need to manually start the ibserver but for now that is
still not a problem. Unfortunately, one this system I cannot create a
local database. I looked at the notes for getting the first system able
to create a database but I never got this error.

SQL> create database "test";
Statement failed, SQLCODE = -923

connection rejected by remote interface

The system seems to be properly licensed, no complaints when I start
ibserver and nothing in the log file about an improper license.

I searched the Internet for help but the information was about a
connections between machines or a different database.

Sincerely,
Ted

[willr]

It's a lot easier to use the Console to create databases etc.

You get that "rejection" when the client cannot access a licensed
connection, or when the server is not running.

Rejection can be a terrible thing.

--
Will R
PMC Consulting

[Quinn Wildman (CodeGear Developer Support)]

IBConsole isn't going to help here.

You need to edit either /etc/host.equiv or /etc/gds_hosts.equiv to allow
trusted connections. Generally, you just need to add a line with +. For
more information, look at the man page for hosts.equiv. Note that
editing gds_hosts.equiv is quickly documented on page 47 of the
Interbase 2007 Operations Guide.

[Robert Schieck (TeamB)]

Ted Miglautsch wrote:

Do you have a '+' in your hosts.equiv file ?

--
Rob Schieck (TeamB)

[Ted Miglautsch]

Ah ha! The system that worked had a gds_hosts.equiv which was not
present on the other system. What I cannot figure out is, on the system
that did have it, where did it come from? Since it contained:

/********************* file contents ****************************/
# This file will allow InterBase to connect to the localhost
localhost
+
/********************* end of contents **************************/

I know I did not create it. On the one system it was created but not on
the other.

I do know that the first system I used the GUI install. But the second
system did not have an available GUI. So I used the console install
option. Possibly the Console install misses the step of creating that
file. Somebody should look into that.

Sitting here in Russia I have vast libraries of books. Unfortunately, I
cannot read most of them, they are in Russian. Where might I obtain a
copy of this "Interbase 2007 Operations Guide"?

Thank you for the help.