Connection rejected by remote interface linux

Saved searches

Use saved searches to filter your results more quickly

You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session.

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ibase_connect Interbase Remote connection rejected by remote interface #49

ibase_connect Interbase Remote connection rejected by remote interface #49

Comments

InberBase2020
OS: windows server 2019

App Server OS: Ubuntu 22.04
php: 8.1.2
php-firebird : php_8.1.13-interbase-3.0.1-linux-x64.so

 $dbh = ibase_connect('xxx.xxx.xxx.xxx:D:\workspace\DB\TEST2.IB', 'SYSDBA', 'masterkey');

return PHP Warning: ibase_connect(): connection rejected by remote interface

while I can use python ODBC to connect on windows plateform ,

. connection_string = f'DRIVER=InterBase ODBC driver;DBNAME=10.10.99.11:D:\workspace\DB\TEST2.IB;UID=;PWD=;' print(connection_string) # Connect to the server connection = pyodbc.connect(connection_string) # Create a cursor cursor = connection.cursor() . 

The text was updated successfully, but these errors were encountered:

Источник

Lazarus

• Free Pascal
• Website
• Downloads
• Wiki
• Documentation
• Bugtracker
• Mailing List
• Lazarus
• Website
• Downloads (Laz+FPC)
• Packages (OPM)
• FAQ
• Wiki
• Documentation (RTL/FCL/LCL)
• Bugtracker
• CCR Bugs
• IRC channel
• GIT
• Mailing List
• Other languages
• Foundation
• Website
• Useful Wiki Links
• Project Roadmap
• Getting the Source
• Screenshots
• How to use the forum

Источник

Flamerobin connection failed with Firebird 3.0 in Ubuntu 16.04 LTS — Error: connection rejected by remote interface

I just installed Firebird 3.0 in Ubuntu 16.04 LTS. I can connect to the server with Flamerobin from a Windows computer. I also installed Flamerobin in the server to be able to manage the databases locally, but after to register the server and database, connections fails. Flamerobin displays the following error message:

IBPP::SQLException Context: Database::Connect, Message: isc_attach_database failed, SQL Message: -923, Connection not established, Engine code: 335544421, Engine Message: connection rejected by remote interface. 

How are you connecting (show the connection properties you use), and what version of the libfbclient,so is loaded? It sounds like you are connecting using a 2.5 or earlier version of the client library, which doesn’t work by default because of stricter security settings.

@MarkRotteveel Sorry for the delay, I was fighting with other configurations for remote access, issue with local access persists. These are the connection settings. For server registration, Display name: Localhost, Hostname: 127.0.0.1, Port Number: 3050. For database registration. Display name: Testing, Database path: /home/angel/Documentos/FBDB/test.fdb, Authentication: Use saved user name and password, User name: SYSDBA, Password: password, Charset: NONE, Role: (empty). How I can verify the client library version?

3 Answers 3

Ok, after a couple of days trying to configure Flamerobin to connect with Firebird 3.0, finally I can do it.

First we need to know which library Flamerobin is trying to load. To know it, we use the following command:

ldd /usr/bin/flamerobin | grep libfb 

libfbclient.so.2 => /usr/lib/x86_64-linux-gnu/libfbclient.so.2 (0x00007f48bb6f0000) 

So, Flamerobin loads an older version of client library. The correct client library for Firebird 3.0 is in the following path:

/opt/firebird/lib/libfbclient.so.3.0.0 

After researching for several hours (I am new in Linux) I discovered that it was necessary create a symbolic link between the correct library and the path where Flamerobin loads the older library. To do this I typed the following command (first, I renamed the older library to «libfbclient.so.2_»):

sudo ln -s /opt/firebird/lib/libfbclient.so.3.0.0 /usr/lib/x86_64-linux-gnu/libfbclient.so.2 

Finally, execute again Flamerobin and now it is connected. @MarkRotteveel thanks for the clues.

Источник

GDS Exception. 335544421. connection rejected by remote interface

I am trying to connect to a firebird db using the jaybird jdbc driver. Firebird is running under ubuntu. I have created a simple database located under /tmp/hellofb.fdb (yeah not the best place, just for testing). I am running firebird superserver 3.0. The firebird service is up and running sudo service firbird3.0 status :

firebird3.0.service - Firebird Database Server ( SuperServer ) Loaded: loaded (/lib/systemd/system/firebird3.0.service; enabled; vendor preset: enabled) Active: active (running) since Wed 2017-10-25 22:40:53 CEST; 25min ago Process: 23411 ExecStart=/usr/sbin/fbguard -pidfile /run/firebird3.0/default.pid -daemon -forever (code=exited, status=0/SUCC Main PID: 23412 (fbguard) Tasks: 4 (limit: 4915) CGroup: /system.slice/firebird3.0.service ├─23412 /usr/sbin/fbguard -pidfile /run/firebird3.0/default.pid -daemon -forever └─23413 /usr/sbin/firebird Okt 25 22:40:53 XPS-L322X systemd[1]: Starting Firebird Database Server ( SuperServer ). Okt 25 22:40:53 XPS-L322X systemd[1]: Started Firebird Database Server ( SuperServer ). 

spring.datasource.url:jdbc:firebirdsql://localhost:3050//tmp/hellofb.fdb spring.datasource.driverClassName:org.firebirdsql.jdbc.FBDriver 

org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544421. connection rejected by remote interface 

I have tried all possible permutations given by the jaybird FAQ, I am running out of options. Any help would be greatly appreciated! Note: I tried to connect to the databse using flamerobin and everything works just fine

Источник