maria-developers team mailing list archive
-
maria-developers team
-
Mailing list archive
-
Message #04971
[[Bug] skip-character-set-client-handshake]
>Description:
<I'm using MariaDB with my gameservers. Server works with db through sourcemod.
In my db i'am using utf8 encoding, and all works fine on MariaDB 5.3.8 with params:
init-connect = "SET NAMES 'utf8' COLLATE 'utf8_general_ci'"
skip-character-set-client-handshake
But after upgrade to 5.5.27 i found a 'bug'.
When i'm send query from my game server, over time character_set_connection, character_set_client and character_set_results set to latin1.
After enable log i saw:
88 Connect login@domain as anonymous on sourcebans
88 Query SET NAMES 'utf8' COLLATE 'utf8_general_ci'
88 Query SET NAMES latin1
88 Query SHOW VARIABLES LIKE '%character_set%'
But my request is only show vars.
I assumed that sourcemod is guilty. But skip-character-set-client-handshake is set! I disable it, and try again.
At this time i send SET collation_connection = utf8_general_ci and SET NAMES utf8 after my query. But over time it set to latin1 again.
No errosr in error.log
Sorry for my english.>
>How-To-Repeat:
<I don't know how to repeat it manually (without sourcemod app)>
>Fix:
<It works fine in previous versions. Just not accept NAMES from client.>
>Submitter-Id: <submitter ID>
>Originator: spumer
>Organization:
<russian game servers>
>MySQL support: [ email support ]
>Synopsis: <skip-character-set-client-handshake not work correctly>
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-5.5.28a (MariaDB Server)
>C compiler: gcc-4.5.3 (Gentoo 4.5.3-r1 p1.0, pie-0.4.5) 4.5.3
>C++ compiler: g++-4.5.3(Gentoo 4.5.3-r1 p1.0, pie-0.4.5) 4.5.3
>Environment:
<VMware ESXi 5, Gentoo, Glibc 2.15>
System: Linux localhost 3.6.1-gentoo #1 SMP Mon Oct 8 06:00:23 YEKT 2012 x86_64 Intel(R) Core(TM) i7 CPU 870 @ 2.93GHz GenuineIntel GNU/Linux
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: ÐÑполÑзÑÑÑÑÑ Ð²Ð½ÑÑÑенние ÑпеÑиÑикаÑии.
COLLECT_GCC=/usr/x86_64-pc-linux-gnu/gcc-bin/4.5.3/gcc
COLLECT_LTO_WRAPPER=/usr/libexec/gcc/x86_64-pc-linux-gnu/4.5.3/lto-wrapper
Ð¦ÐµÐ»ÐµÐ²Ð°Ñ Ð°ÑÑ
иÑекÑÑÑа: x86_64-pc-linux-gnu
ÐаÑамеÑÑÑ ÐºÐ¾Ð½ÑигÑÑаÑии: /var/tmp/portage/sys-devel/gcc-4.5.3-r1/work/gcc-4.5.3/configure --prefix=/usr --bindir=/usr/x86_64-pc-linux-gnu/gcc-bin/4.5.3 --includedir=/usr/lib/gcc/x86_64-pc-linux-gnu/4.5.3/include --datadir=/usr/share/gcc-data/x86_64-pc-linux-gnu/4.5.3 --mandir=/usr/share/gcc-data/x86_64-pc-linux-gnu/4.5.3/man --infodir=/usr/share/gcc-data/x86_64-pc-linux-gnu/4.5.3/info --with-gxx-include-dir=/usr/lib/gcc/x86_64-pc-linux-gnu/4.5.3/include/g++-v4 --host=x86_64-pc-linux-gnu --build=x86_64-pc-linux-gnu --disable-altivec --disable-fixed-point --without-ppl --without-cloog --disable-lto --enable-nls --without-included-gettext --with-system-zlib --disable-werror --enable-secureplt --enable-multilib --enable-libmudflap --disable-libssp --enable-libgomp --with-python-dir=/share/gcc-data/x86_64-pc-linux-gnu/4.5.3/python --enable-checking=release --disable-libgcj --enable-languages=c,c++,fortran --enable-shared --enable-threads=posix --enable-__cxa_a!
texit --enable-clocale=gnu --enable-targets=all --with-bugurl=http://bugs.gentoo.org/ --with-pkgversion='Gentoo 4.5.3-r1 p1.0, pie-0.4.5'
ÐÐ¾Ð´ÐµÐ»Ñ Ð¼Ð½Ð¾Ð³Ð¾Ð¿Ð¾ÑоÑноÑÑи: posix
gcc веÑÑÐ¸Ñ 4.5.3 (Gentoo 4.5.3-r1 p1.0, pie-0.4.5)
Compilation info (call): CC='/usr/bin/gcc' CFLAGS='-Wall -O3 -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DDBUG_OFF -DMY_PTHREAD_FASTMUTEX=1' CXX='/usr/bin/c++' CXXFLAGS='-Wall -Wno-unused-parameter -fno-implicit-templates -fno-exceptions -fno-rtti -O3 -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DDBUG_OFF -DMY_PTHREAD_FASTMUTEX=1' LDFLAGS='' ASFLAGS=''
Compilation info (used): CC='/usr/bin/gcc' CFLAGS='-Wall -O3 -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DDBUG_OFF -DMY_PTHREAD_FASTMUTEX=1' CXX='/usr/bin/c++' CXXFLAGS='-Wall -Wno-unused-parameter -fno-implicit-templates -fno-exceptions -fno-rtti -O3 -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DDBUG_OFF -DMY_PTHREAD_FASTMUTEX=1' LDFLAGS='' ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 12 дек. 2 12:43 /lib/libc.so.6 -> libc-2.15.so
-rwxr-xr-x 1 root root 1734576 дек. 2 12:42 /lib/libc-2.15.so
-rw-r--r-- 1 root root 4594916 дек. 2 12:42 /usr/lib/libc.a
-rwxr-xr-x 1 root root 253 дек. 2 12:42 /usr/lib/libc.so
Perl: This is perl 5, version 12, subversion 4 (v5.12.4) built for x86_64-linux-thread-multi
Follow ups