Archives for Sergiy's Noter

Migrating from Cyrus IMAP to Dovecot on Fedora Core

This is our second attempt to migrate from Cyrus IMAP to Dovecot and now it is easy with a nice tool called imapsync

In order to compile it, you will probably have to install additional Perl packages both from Fedora native repositories and from Dries RPM Repository. The workstation where imapsync compiled successfully has the following Perl packages:

perl-5.8.8-4
perl-DBD-MySQL-3.0002-2.2.2
perl-Net-SSLeay-1.30-3.fc5
perl-DBI-1.50-2.2
perl-URI-1.35-2.2
perl-IO-Socket-SSL-0.97-1.fc5
perl-Cyrus-2.3.1-2.6.fc5
perl-Mail-IMAPClient-2.2.9-1.2.fc5.rf
perl-TermReadKey-2.30-1.2.2

Zen Cart and MySQL 5.x

One important feature of new Zen Cart 1.3.x is out of the box support of MySQL 5.x However, for some reason, it is not explicitly mentioned in release notes.

If you choose to have Zen Cart 1.2.* with MySQL 5.*, you sentence yourself to fixing many pieces of badly written SQL queries as described in this forum thread.

1054 Unknown column ‘p.products_id’ in ‘on clause

If you have Zen Cart 1.2.x with Ultimate SEO contribution running on MySQL 5.0.x, you will probably very soon run into the following error:

1054 Unknown column 'p.products_id' in 'on clause'

preventing even your front page from opening.

This is a bug of Ultimate SEO contribution and to fix it you will need to replace two occurrences of the following two lines:

FROM ".TABLE_CATEGORIES." c, ".TABLE_CATEGORIES_DESCRIPTION." cd

in includes/classes/seo.url.php with these lines:

FROM ".TABLE_CATEGORIES_DESCRIPTION." cd, ".TABLE_CATEGORIES." c 

as pointed out in this post on Zen Cart forum.

(13)Permission denied: httpd: could not open error log file

Those who have later versions of Fedora Core installed and trying to set up virtual hosts in Apache may encounter the following error:

(13)Permission denied: httpd: could not open error log file

As a result Apache refuses to start.

This problem should be easy to fix if it has to do with SELinux. Check what kind of security attributes you have in your /var/log/httpd , /var/www and other related directories using

ls -lZ

command and be sure to set the same attributes for the directories where you have you virtual hosts html files, logs, etc

For example if you have your virtual host html files in /server/1/html and your log files in /server/1/log you should issue the following commands to set the right attributes:

chcon -R system_u:object_r:httpd_sys_content_t /server/1/html

and

chcon -R system_u:object_r:httpd_log_t /server/1/log

yum problem upgrading to Fedora Core 5 (FC5)

To prevent yum from breaking when upgrading Fedora Core 4 (or possibly earlier version of Fedora) to Fedora Core 5, it is necessary to install sqlite-3.3.3-1.2.i386.rpm and python-sqlite-1.1.7-1.2.i386.rpm or later versions of these packages.

SugarCRM 4.2.0 with Cyrillic support

If you need SugarCRM 4.2.0 to correctly support Cyrillic without installing Russian language pack, change:

'LBL_CHARSET' => 'ISO-8859-1'

to

'LBL_CHARSET' => 'Windows-1251'

in include/language/en_us.lang.php

Migrating from Cyrus IMAP to Dovecot on Fedora Core 4

We have decided to migrate one of our mail servers to use Dovecot instead of Cyrus IMAP.

It appeared that moving existing messages from Cyrus IMAP 2.2.x format to Dovecot Maildir is not as straightforward as described in Dovecot Migration Wiki. Neither cyrus2courier nor cyrus2maildir.py appeared to work correctly on our Fedora Core 4 throwing different kinds of errors.

We will probably have to postpone this migration until later, when we find some time to try some IMAP to IMAP migration tool.

Blojsom 3.0 with Hibernate back-end is coming up

Blojsom 3.0 employing Hibernate and Spring has been announced. That’s great news for everybody who was concerned about Blojsom performance and scalability related to using plain text to store blog entries instead of employing some kind of database backend.

JVMXM008 workaround

Brian D. Carlstrom wrote:

At Stanford I have my own automated regression infrastructure that runs processor simulations remotely via ssh. One problem that has existed for months is this error from jbuild.linkImage:

JVMXM008: Error occured while initialising System ClassException in thread “main” Could not create the Java virtual machine.

I noticed that Sergiy Kyrylkov had posted in his blog about a similar issue when running JikesRVM regressions from cron:

http://sergiy.kyrylkov.name/blog/Jikes%20RVM/

I found that if I forced the ssh remote bash to be a login shell, I did not get the error. Eventually I narrowed it down to the fact that /etc/profile was sourcing /etc/profile.d/lang.sh which was setting the LANG environment variable. I found that if I my remote command set LANG explicitly, I can build jikesrvm over ssh without the JVMXM008 error.

I just wanted to post the workaround to the list in case it helps someone else. I don’t know if it is needed for later SDKs, but my version of JikesRVM seems to only work with 1.4.1, nothing earlier, nothing later.

For the record, this is on Fedora Core 4 on G5 machines running IBM’s SDK 1.4.1-SR2 with a jikesrvm source tree from last updated at “2005-12-09 03:00:00″. We are frozen until after some paper deadlines this month…

I hope I’ll have time soon to try this workaround on UNM machines.

Java SE 6 update

Planned release of Java SE 6, known as Mustang, slips to Autumn 2006 as indicated in this blog.