AES_DECRYPT(garabage, key) problem (4.0.4 bk snapshot)
am 12.09.2002 13:13:03 von rathamahata>Description:
Server hang when trying to test field=3DAES_DECRYPT(filed, key)
=09in case when filed contain garbage.
>How-To-Repeat:
=09
=09CREATE TABLE atest(
id int(11) NOT NULL auto_increment,
tmp text NOT NULL,
KEY id (id)
=09) TYPE=3DMyISAM;
=09INSERT INTO atest VALUES (1, 'a545f661efdd1fb66fdee3aab79945bf');
=09SELECT * FROM atest WHERE tmp=3DAES_DECRYPT(tmp,"password");
=09
=09(server crashed)
=09mysql>
=09Number of processes running now: 0
=09020912 15:07:48 mysqld restarted
>Fix:
Unknown
>Submitter-Id:=20
>Originator: Sergey S. Kostyliov
>Organization:
=09eHouse holding (http://www.ehouse.ru/)
>MySQL support: none
>Synopsis: Server hang with AES_DECRYPT()
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.4-beta (Source distribution)
>Server: /usr/bin/mysqladmin Ver 8.37 Distrib 4.0.4-beta, for pc-linux-g=
nu on=20
i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.0.4-beta
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 7 min 44 sec
Threads: 8 Questions: 10647 Slow queries: 0 Opens: 18 Flush tables: 1=
=20
Open tables: 12 Queries per second avg: 22.946
>Environment:
System: Linux db.lamport.msk.ru 2.4.19-pre5aa1 #3 ðÎÄ áÐ=D2 1 2=
0:57:05 MSD 2002=20
i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake
/usr/local/gcc/bin/gcc -v
Reading specs from=20
/usr/local/gcc/bin/../lib/gcc-lib/i686-pc-linux-gnu/3.2/spec s
Configured with: /var/tmp/gcc-3.2/configure --prefix=3D/usr/local/gcc-3.2=
=20
--enable-threads=3Dposix --enable-languages=3Dc++,c
Thread model: posix
gcc version 3.2
Compilation info: CC=3D'/usr/local/gcc/bin/gcc' CFLAGS=3D'-O4 -march=3Dp=
entium3=20
-mcpu=3Dpentium3 -msse -pipe' CXX=3D'/usr/local/gcc/bin/gcc' CXXFLAGS=3D=
'-O4=20
-march=3Dpentium3 -mcpu=3Dpentium3 -msse -pipe -felide-constructors=20
-fno-exceptions -fno-rtti -DUSE_MYSYS_NEW' LDFLAGS=3D''
LIBC:
lrwxrwxrwx 1 root root 13 á×=C7 14 15:30 /lib/libc.s=
o.6 ->=20
libc-2.2.4.so
-rwxr-xr-x 1 root root 1285884 á×=C7 7 16:13 /lib/libc-2=
2.4.so
-rw-r--r-- 1 root root 27336078 á×=C7 7 14:56 /usr/lib/li=
bc.a
-rw-r--r-- 1 root root 178 á×=C7 7 14:57 /usr/lib/li=
bc.so
lrwxrwxrwx 1 root root 10 íÁ=CA 26 15:08 /usr/lib/li=
bc-client.a=20
-> c-client.a
Configure command: ./configure --prefix=3D/usr --libexecdir=3D/usr/sbin=20
--localstatedir=3D/var/lib/mysql --mandir=3D/usr/share/man=20
--infodir=3D/usr/share/info --enable-assembler=20
--with-mysqld-ldflags=3D-all-static --with-mysql-user=3Dmysql --with-inno=
db=20
--with-unix-socket-path=3D/var/lib/mysql/mysql.sock=20
--with-extra-charsets=3Dlatin1,koi8_ru,cp1251 --enable-thread-safe-client
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php