← Back to team overview

maria-developers team mailing list archive

[[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