hi all
i installed a webmailclient on a postfix/dbmail/spamassin/new-amavisd
system.
from time to time it happens that the webmailclient (jawmail) reports
that there are no more connections to the mysql database avalible. a
mysql> show processlist;
outputs 101 lines of dbmail connections.
dbmail uses all avalible connections :(
mysql> show variables;
says that max_connections = 100 (default).
1) i couldnt figure out how to change the default value from 100 to 500
or even larger in mysql.
mysql> SET GLOBAL max_connections=500;
ERROR 1064: You have an error in your SQL syntax near
'max_connections=500' at line 1
i took the commands out of http://www.mysql.com/doc/en/SET_OPTION.html.
maybe my mysql installation is too old.
# mysql --version
mysql Ver 11.18 Distrib 3.23.51, for slackware-linux-gnu (i386)
does anybody know how to set the environment variable max_connections to
500?
2) is there any way to tell dbmail that it sould not be so >>rude<< and
grab all avalible connections?
thanx, best regards, armin.
