and:
# pkg_info| grep mysql
libnss-mysql-1.5_2 NSS module using a MySQL database for backend
mysql-client-4.1.20 Multithreaded SQL database (client)
in one jailed system
and:
# pkg_info| grep mysql
libnss-mysql-1.5_2 NSS module using a MySQL database for backend
mysql-client-4.1.21 Multithreaded SQL database (client)
mysql-server-4.1.21 Multithreaded SQL database (server)
on the other jailed system
In my maillog in postfix i have error like:
libnss-mysql: mysql_query failed: Lost connection to MySQL server during query, trying again (2)
This error is normal *IF* (in your case) 60 seconds has passed since that particular process made a passwd/shadow/group query. It's normal and can be ignored. If you're seeing something actually fail due to that error message, however, let me know.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello, I have server on:
# uname -srm
FreeBSD 6.1-STABLE i386
and:
# pkg_info| grep mysql
libnss-mysql-1.5_2 NSS module using a MySQL database for backend
mysql-client-4.1.20 Multithreaded SQL database (client)
in one jailed system
and:
# pkg_info| grep mysql
libnss-mysql-1.5_2 NSS module using a MySQL database for backend
mysql-client-4.1.21 Multithreaded SQL database (client)
mysql-server-4.1.21 Multithreaded SQL database (server)
on the other jailed system
In my maillog in postfix i have error like:
libnss-mysql: mysql_query failed: Lost connection to MySQL server during query, trying again (2)
my mysql config is like:
[client]
port = 3306
socket = 153.xxx.xxx.xxx
[mysqld]
port = 3306
socket = 153.xxx.xxx.xxx
skip-locking
key_buffer = 256M
max_allowed_packet = 128M
table_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
thread_concurrency = 8
set-variable=wait_timeout=60
log-bin
server-id = 1
[mysqldump]
quick
max_allowed_packet = 128M
[mysql]
no-auto-rehash
max_allowed_packet = 128M
[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
My question is, why I see this error:
libnss-mysql: mysql_query failed: Lost connection to MySQL server during query, trying again (2)
Thanks for answers.
This error is normal *IF* (in your case) 60 seconds has passed since that particular process made a passwd/shadow/group query. It's normal and can be ignored. If you're seeing something actually fail due to that error message, however, let me know.