Skip to content
New issue

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

Cannot connect to Linux server with 7.0, but 6.7 works fine [DNET898] #825

Closed
firebird-automations opened this issue Aug 22, 2019 · 15 comments

Comments

@firebird-automations
Copy link

Submitted by: Roland Turcan (rotursoft)

Is replaced by DNET899

The only change was update of .NET provider and connection causes:

DateTime = 22.8.2019 10:23:46
Header = CreateAndOpenConnection()

FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Unable to complete network request to host "
No message for error code 335544721 found. ---> Unable to complete network request to host "
No message for error code 335544721 found.
at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect()
at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.CreateNewConnectionIfPossibleImpl(ConnectionString connectionString)
at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.GetConnection(FbConnection owner)
at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Get(ConnectionString connectionString, FbConnection owner)
at FirebirdSql.Data.FirebirdClient.FbConnection.Open()

==================================================

but againt Windows servers I have not found any problem.

@firebird-automations
Copy link
Author

Commented by: @cincuranet

Please post complete exception.

@firebird-automations
Copy link
Author

Commented by: Roland Turcan (rotursoft)

That's all I have logged at customer side.

@firebird-automations
Copy link
Author

Commented by: @cincuranet

There's not much I can do on my side. Either more info or reproducible test case.

Will reopen when either is provided.

@firebird-automations
Copy link
Author

Modified by: @cincuranet

status: Open [ 1 ] => Closed [ 6 ]

resolution: Cannot Reproduce [ 5 ]

@firebird-automations
Copy link
Author

Commented by: Roland Turcan (rotursoft)

If it helps I use this code for building ConnectionString:

    private string BuildConnectionString\(\)
    \{
        FbConnectionStringBuilder cs = new FbConnectionStringBuilder\(\);
        cs\.UserID = Connection\.UserName;
        cs\.Password = Connection\.Password;
        cs\.Database = Connection\.DatabasePath;
        cs\.Dialect = 3;
        cs\.Charset = "UTF8";
        cs\.Pooling = true;
        // Set the ServerType to 1 for connect to the embedded server
        cs\.ServerType = 0;
        return cs\.ToString\(\);
    \}

customer sends this DatabasePath:

192.168.1.190:/data/data/db.fdb

@firebird-automations
Copy link
Author

Commented by: @cincuranet

No, that does not help.

@firebird-automations
Copy link
Author

Commented by: Roland Turcan (rotursoft)

I suppose that it must be something in Database property parser in 7.0 for Linux environment. I did not change anything in my code, I did only update from 6.6 to 7.0 over nuget. Downgrade to 6.7 helped to get it working again.

What else can I do to get richer log which helps you?

@firebird-automations
Copy link
Author

Commented by: @cincuranet

There's nothing Linux specific in Database property parsing. You "only" upgraded across major versions, you're expected to do you homework.

Exception.ToString() should be enough for start. Obviously a simple test case would be worth the effort, if you want this to be fixed.

@firebird-automations
Copy link
Author

Commented by: Ondřej Linhart (ondrej.linhart)

I have this issue too. Downgrade to 6.7.0 works fine. Thanks to this bug, Database .NET software stopped working for Firebird databases. Look at that error message - request to host " which means you are trying to connect to empty string.

@firebird-automations
Copy link
Author

Commented by: @cincuranet

Can you give me the connection string you're using (or FbConnectionStringBuilder calls) and server to validate?

@firebird-automations
Copy link
Author

Commented by: Ondřej Linhart (ondrej.linhart)

servertype=0;username=sysdba;password=**********;database=10.1.2.23:/opt/***/**********.fdb"

Just to note, Firebird 3.0 database engine is installed on CentOS Linux virtualized system and client software on Windows 10.

@firebird-automations
Copy link
Author

Commented by: @cincuranet

I need a server to connect to, 10.1.2.23 is not gonna cut it. VM, as long as I can convert it to VMware, would do it too.

@firebird-automations
Copy link
Author

Modified by: @cincuranet

status: Closed [ 6 ] => Reopened [ 4 ]

resolution: Cannot Reproduce [ 5 ] =>

@firebird-automations
Copy link
Author

Modified by: @cincuranet

Link: This issue is replaced by DNET899 [ DNET899 ]

@firebird-automations
Copy link
Author

Modified by: @cincuranet

status: Reopened [ 4 ] => Closed [ 6 ]

resolution: Incomplete [ 4 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants