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
Linux server may reject connections with a transliteration error [CORE4639] #4953
Comments
Modified by: @dyemanovstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0 Beta 2 [ 10586 ] assignee: Dmitry Yemanov [ dimitr ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] Test Details: TODO: make test after confirmation from Alex that CORE4760 is finally fixed. |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Deferred Test Specifics: [Platform (Windows/Linux) specific] |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Commented by: Ehmmm (ehmmm.firebird) I'm afraid that something like this still occurs. On Debian Stretch I have Firebird 3.0.4.32931 with some DB (in codepage win1250 but I think it isn't relevant). If I start FlameRobbin as the first user (testěščřžýáíé) and try to connect to DB then I get the mentioned error (Invalid or incomplete multibyte or wide character). And the most weird thing is that if I restart firebird on server (/etc/init.d/firebird restart) then I can connect even with the Windows user with diacritics. I will try to attach Wireshark capture of the three connection tests: |
Commented by: Ehmmm (ehmmm.firebird) Capture of tcp port 3050 communication. |
Modified by: Ehmmm (ehmmm.firebird)Attachment: 20180316 user1ok reboot user1error user2ok.pcapng [ 13226 ] |
Commented by: Ehmmm (ehmmm.firebird) And I forgot to mention that on couple other servers (with bit older Debian Stretch and bit older Firebird snapshot version) I don't have these problems. |
Commented by: Ehmmm (ehmmm.firebird) I'll answer to myself. export LC_ALL="en_US.UTF-8" somewhere on top into /etc/init.d/firebird and it seems to work OK. |
Submitted by: @dyemanov
Attachments:
20180316 user1ok reboot user1error user2ok.pcapng
Example of failure:
SQL> connect 192.168.1.105:employee user sysdba password 123;
Statement failed, SQLSTATE = 08001
Invalid connection string
-Cannot transliterate character between character sets
-Invalid or incomplete multibyte or wide character
It happens when a connection is being established from a client host with non-ASCII (e.g. Cyrillic) name or with non-ASCII OS user name. This could be quite common in the Windows world.
Commits: 729ff61 FirebirdSQL/fbt-repository@cfe270b
====== Test Details ======
TODO: make test after confirmation from Alex that CORE4760 is finally fixed.
The text was updated successfully, but these errors were encountered: