From: 156 Oud (oud156hotmail.com)
Date: Fri Oct 28 2005 - 08:36:00 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]