High Resolution Science Imaging experiment(HiRISE) project for one of
important instrument on MRO spacecraft which will be launched to MAR in
2005 are using MySQL server 4.0.13 as database management system.
we recently encounter a unstable privilege problem.what we do like that:
(1) In 8/19, we insert two entry in mysql database:
insert into db values('%.lpl.arizona.edu','test','',
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','N','N');
insert into host values('%.lpl.arizona.edu','test','Y',
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','N','N');
flush privileges;
quit normally
(2)In 8/19 and 8/20, any user from %.lpl.arizona.edu can get access to
test database,it work.
(3) but in 8/21, it does not work,users can not access test database,even
we did not chang anything.
(4)we do the same thing to test2,test3 database, the privilege keep on
working, users can always access this two database;
(5)Then in 8/21 afternoon, we stop and start MySQL server again, users can
access test database again.
so we just feel confusing about the problem. privilege is the most
important function for us.Is the privilege system unstable,what is wrong
with it?
How-To-Repeat: Fix:
Submitter-Id: <submitter ID>
Originator:
Organization: Lunar and planetary lab in University of Arizona.High Resolution Science
Imaging experiment(HiRISE) project team for HiRISE instrument on MRO
spacecraft which will be launched to MAR in
2005
MySQL support: none
Synopsis: unstable privilege system
Severity: critical
Priority: high
Category: mysql
Class: sw-bug
Release: mysql-4.0.13 (yes)
Server: /opt/mysql/bin/mysqladmin Ver 8.40 Distrib 4.0.13, for sun-solaris2.9 on sparc 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.13-log
Protocol version 10
Connection pirldb via TCP/IP
TCP port 3306
Uptime: 19 hours 13 min 7 sec
Threads: 1 Questions: 280 Slow queries: 0 Opens: 66 Flush tables: 1 Open tables: 28 Queries per second avg: 0.004C compiler: gcc
C++ compiler: gcc
Environment:
System: SunOS pirlserver 5.9 Generic_112233-06 sun4u sparc SUNW,Ultra-Enterprise
Architecture: sun4
Some paths: /opt/pub/bin/perl /usr/ccs/bin/make /opt/pub/bin/gmake /opt/gcc/bin/gcc /opt/SUNWspro/bin/cc
GCC: Reading specs from /opt/gcc/bin/../lib/gcc-lib/sparc-sun-solaris2.7/3.2.2/specs
Configured with: /opt/pub/src/gcc/src/gcc-3.2.2/configure --prefix=/opt/pirl/gcc-3.2.2 --with-local-prefix=/opt/pub --enable-threads=posix --with-system-zlib
Thread model: posix
gcc version 3.2.2
Compilation info: CC='cc-5.0' CFLAGS='-Xa -xstrconst -mt -D_FORTEC_ -xarch=v9' CXX='CC' CXXFLAGS='-noex -mt -D_FORTEC_ -xarch=v9' LDFLAGS='-L/opt/SUNWspro/lib/v9 -lCrun' ASFLAGS='-xarch=v9'
LIBC:
-rw-r--r-- 1 root bin 1848328 May 16 15:52 /lib/libc.a
lrwxrwxrwx 1 root root 11 Oct 26 2002 /lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root bin 866148 May 16 15:52 /lib/libc.so.1
-rw-r--r-- 1 root bin 1848328 May 16 15:52 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Oct 26 2002 /usr/lib/libc.so -> ./libc.so.1
-rwxr-xr-x 1 root bin 866148 May 16 15:52 /usr/lib/libc.so.1
Configure command: ./configure '--prefix=/opt/mysql' '--with-extra-charsets=complex' '--enable-thread-safe-client' '--enable-local-infile' '--enable-assembler' '--with-named-z-libs=no' '--with-embedded-server' '--with-pic' '--without-debug' '--with-comment' '--with-libwrap=/opt/local/lib' 'CC=cc-5.0' 'CFLAGS=-Xa -xstrconst -mt -D_FORTEC_ -xarch=v9' 'CXXFLAGS=-noex -mt -D_FORTEC_ -xarch=v9' 'CXX=CC' 'LDFLAGS=-L/opt/SUNWspro/lib/v9 -lCrun'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw