Hi,
I've got a very strange problem with one of my MySQL servers.
I've got 2 dedicated servers with MySQL 4.0.21, all is fine there.
My new server with MySQL-4.1.14 give me some headakes !
Sometimes i've got errors like
UPDATE command denied to user 'MyUser'@'192.168.0.4' for table 'MyTable'.
But 99% of time, theses queries are OK.
MySQL privilges haven't changed since several days.
Plateform description :
Severals RedHat 9.0 webservers with apache, glibc, MySQL-devel-4.0.21-0.rpm
and MySQL-client-4.0.21-0.rpm.
Client program is a C language program built against mysql librairies
(MySQL-devel-4.0.21-0.rpm).
All webservers can access to severals MySQL servers against Lan.
SQL1 and SQL2 are running MySQL 4.0.21
(mysql-standard-4.0.21-pc-linux-i686.tar.gz), all is fine.
The new one, SQL3 (RedHat 9.0) is running MySQL-4.1.14
(mysql-standard-4.1.14-pc-linux-gnu-i686-icc-glibc23.tar.gz).
Here is my.cnf :
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-name-resolve
skip-host-cache
skip-locking
old-passwords
key_buffer=256M
query_cache_size = 0
record_buffer=2M
sort_buffer=2M
max_allowed_packet=1M
max_connections=800
max_connect_errors=100
table_cache=1800
net_read_timeout=180
net_write_timeout=180
wait_timeout=360
thread_concurrency=4
log-bin
server-id = 1
innodb_additional_mem_pool_size = 16M
innodb_buffer_pool_size = 1G
innodb_data_file_path = ibdata1:1000M:autoextend
innodb_file_io_threads = 4
innodb_thread_concurrency = 16
innodb_flush_log_at_trx_commit = 1
innodb_log_buffer_size = 8M
innodb_log_file_size = 256M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
[myisamchk]
set-variable = key_buffer=256M
set-variable = sort_buffer=256M
set-variable = read_buffer=4M
set-variable = write_buffer=4M
[mysqld_safe]
open-files-limit = 8192
Did someone know why queries can worked 99% of the time and sometimes give
me "command denied to user" ?
Perhaps because C client is built against 4.0.21 librairie and connexion are
done to a 4.1.14 server ?
But "old-passwords" prevent me from having troubles with new passwords
format.
Thanks.
_________________________________________________________________
Apprenez à lutter contre le spam !
http://go.msn.fr/10-channel/80-security/spam/default.asp
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
