469,612 Members | 2,652 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,612 developers. It's quick & easy.

privilege unstable

>Description:
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

Jul 19 '05 #1
0 1471

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Chris Callahan | last post: by
reply views Thread by Christophe Poirier | last post: by
reply views Thread by Fei Peng | last post: by
2 posts views Thread by Praveen_db2 | last post: by
1 post views Thread by jatinder.saundh | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.