Last week I installed SugarCRM for arsenic.ph to try it out. While I was playing around with adding new users and roles, I noticed that it took over a minute for SugarCRM to finish creating one user. I began investigating and slow queries notwithstanding, MySQL turned out to be the performance bottleneck. This server is still new and I still have not come around to tuning MySQL as I have already begun moving most of my work to Postgres. Unfortunately there are still a large number of good software packages out there that require MySQL so I was left with no choice but to tune it.

(more…)

While setting up my new server, I followed the guide found here. Because of SmartBro’s braindead policy of forcing its subscribers to use their flaky SMTP server, I am forced to work around this issue by running SMTPS instead. I followed Step 5 of the guide and I was wondering why Evolution could not connect to the server. I have already enabled port 465 to go through on Bastille firewall but running nmap on the server does indicate that Postfix was not listening on port 465 as it should be.

I even went as far as regenerating my self-signed SSL certificates to be sure I had everything buttoned down. This just another one of those face-in-palm moments where the cause of the problem was so obvious. I forgot to enable SMTPS in master.cf. I simply uncommented the following lines in master.cf:

smtps     inet  n       -       n       -       -       smtpd
  -o smtpd_tls_wrappermode=yes
  -o smtpd_sasl_auth_enable=yes
  -o smtpd_client_restrictions=permit_sasl_authenticated,reject

Then I restarted Postfix and nmap now reports port 465 open.