Dragonfly Networks

I went ahead and upgraded SugarCRM to 4.5f, fearing that if we waited too long, we’d have problems upgrading in the future.

Overall it went well; there were some permissions problems before I was able to upgrade, but the SugarCRM upgrader warned me about them beforehand so I had a chance to fix them before the upgrade script crapped out halfway through, which is how things used to be handled.

After the install, there were a couple error messages at the top of every page, including that fabulous “Could not connect to Sugar Server: please correct your Proxy Server settings in the Admin section” which appeared in bright red on every page. This I was able to fix somehow by clearing my cookie for sugar.dragonfly-networks.com, although I’m not sure why this worked.

The last error was something telling me to upgrade my Studio files in the admin section; the admin section didn’t have any options for upgrading these files at first, but logging out of Sugar and logging back in seemed to fix it so I could upgrade the files. Everything appears to be working well in Sugar now, so we should be ok for a while.
While doing this upgrade I was also trying to use the mysqldump utility to run a database backup of the sugarcrm database before upgrading. I ended up having to install PHPMyAdmin instead, and ran the backups from there, which worked but spurred me into investigating the source of the errors I was getting from mysqldump.

After slogging through a variety of forums and finding out how other people fixed the issue, I found an interesting post from a gentleman who mentioned how to look at the  mysql open-file-limits variable from within mysql, and found that our setting was way too low for the amount of databases and files we’re using these days. It was somehow set to 510 open files, and I was able to increase it to 1710, but it should really be around 8192 ideally, and although that was the parameter I passed to mysqld_safe when starting  it, apparently there may be some kind of limit built in to OpenBSD that is preventing it from reaching the higher limit.

I’m not sure how to fix this, although I may be able to work around it using some ulimit commands or whatnot.

In any case, everything is working now, so I might call it a night before I break something.