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

Firebird3 - Disable ipv6 support option when no network connection [CORE6349] #6590

Closed
firebird-automations opened this issue Jul 1, 2020 · 9 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Eric Himmer (ehimmer)

Related to CORE5679.

Our product is designed for use by computer illiterate people using Windows devices most likely not connected to the internet. Based on the report in bug report CORE5679, support was added for ipv6 which causes a failure to be able to connect to the local database on a localhost without an internet connection unless a user, makes changes to their Windows settings. This is not something our users are likely capable of doing, especially out in the field with no internet connection.

Can a setting be added to override the ipv6 support when there is no active internet connection? This is truly a show stopper for us. Not easy for us to back down to FB 2.5 at this late stage. I did not notice any warning in the FB3 description that FB3 requires an internet connection even for embedded-like usage unless you disable Windows Media Sense by using RegEdit and adding the DisableDHCPMediaSense key to disable it and not sure if I want our setup to disable something in Windows itself that the user or other applications might want enabled:
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Tcpip\Parameters

@firebird-automations
Copy link
Collaborator Author

Commented by: @aafemt

This failure is not limited to IPv6, IPv4 is affected as well. If you want reliable connection to local server - use XNET.

@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

Eric,

1- Is your product using embedded or full engine for local database access?

2- What connection string are you using to the local database? (As Dimitry outlined, you should be able to use direct/XNET connection to avoid "localhost:..." in connection string)

@firebird-automations
Copy link
Collaborator Author

Commented by: Eric Himmer (ehimmer)

Seems I can trap for the error and not display it since it appears to not cause any harm as it seems the database access is OK. The errors were coming from some design time queries used in a dashboard. The dynamically created ones work fine once those errors are skipped.

So I guess, nevermind.

@firebird-automations
Copy link
Collaborator Author

Commented by: Eric Himmer (ehimmer)

To answer your questions:

1 - As I understood it, there is no embedded version for FB3 like there was for FB2. Am I wrong? I use the full engine and use SuperClassic. FireDAC is set to use fbclient.dll

2 - I am using FireDAC pooled connections (except for the design time queries). I just set properties to make the connection and let FireDAC generate the proper connection string AFAIK. for the design time queries: Protocol is ipLocal and the Server is localhost which are the defaults.

@firebird-automations
Copy link
Collaborator Author

Commented by: Eric Himmer (ehimmer)

I replaced the design time FDQuery components for my dashboard with my normal dynamic pooled connection queries and all is good. My only guess is that FireDAC has an issue with their FDQuery component (only difference I can see between the two). I do not get the error anymore when disconnected from the internet.

You can close the ticket.

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Won't Fix [ 2 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

To not left question unanswered :

> 1 - As I understood it, there is no embedded version for FB3 like there was for FB2. Am I wrong?

please, read carefully chapter "Remodelled Architecture" in Release Notes:
http://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-engine.html#d0e12188

@firebird-automations
Copy link
Collaborator Author

Commented by: Eric Himmer (ehimmer)

Thanks. What I was referring to was that there is no longer an fbembed.dll in FB3 as there was in FB2. I will re-review the link you provided as I have a feeling I might not be connecting the way I think I wanted to be.

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

1 participant