Issue Details (XML | Word | Printable)

Key: DNET-898
Type: Bug Bug
Status: Closed Closed
Resolution: Incomplete
Priority: Blocker Blocker
Assignee: Jiri Cincura
Reporter: Roland Turcan
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
.NET Data provider

Cannot connect to Linux server with 7.0, but 6.7 works fine

Created: 22/Aug/19 09:41 AM   Updated: 04/Sep/19 06:46 AM
Component/s: ADO.NET Provider
Affects Version/s: 7.0.0.0
Fix Version/s: None

Environment: Windows client .NET 4.5.2, Linux server Debian 6.0, Firebird 3.0.4 AMD64
Issue Links:
Replace
 


 Description  « Hide
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.



 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Jiri Cincura added a comment - 22/Aug/19 09:59 AM
Please post complete exception.

Roland Turcan added a comment - 22/Aug/19 10:05 AM
That's all I have logged at customer side.

Jiri Cincura added a comment - 22/Aug/19 10:16 AM
There's not much I can do on my side. Either more info or reproducible test case.

Will reopen when either is provided.

Roland Turcan added a comment - 22/Aug/19 10:17 AM
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




Jiri Cincura added a comment - 22/Aug/19 10:27 AM
No, that does not help.

Roland Turcan added a comment - 22/Aug/19 11:38 AM
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?

Jiri Cincura added a comment - 22/Aug/19 11:56 AM
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.

Ondřej Linhart added a comment - 02/Sep/19 01:06 PM
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.

Jiri Cincura added a comment - 02/Sep/19 01:47 PM
Can you give me the connection string you're using (or FbConnectionStringBuilder calls) and server to validate?

Ondřej Linhart added a comment - 02/Sep/19 02:55 PM
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.

Jiri Cincura added a comment - 02/Sep/19 03:54 PM - edited
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.