Google July 27

On July 27, exactly one month after June 27, one of our larger web sites Multiplex Systems Store regained its position for all competitive sets of keywords. What exactly caused the problem still remains a question, but this is something that is referred to as “data refresh” by Matt Cutts.

As a preventive measure for future, we are launching a static web site GSM Modem devoted exclusively to GSM modems, including GSM/GPRS/EDGE modules, terminals, PC cards and other equipment. The content is not there yet (just the domain) but we plan to add it soon. Initially it will be in Russian, but we may add Ukrainian and English content.

Google June 27

It looks like something quite bad happened to Google search on June 27. There are long threads about this event on Webmaster World.com: June 27 - changes and June 27 - changes Part 2 but everybody can only guess why certain sites have been hit and certain have not.

Unfortunately Multiplex Systems Store is one of the sites that suffered badly from this event. It produced top 5 search results for a wide range of keywords and products for several month now. However, after June 27, almost all results went to nowhere, almost zeroing traffic from Google. The resolution is yet to be found.

JBuilder is not dead

Borland posted JBuilder roadmap outlining future development of JBuilder including previously announced JBuilder 2007 codenamed “Peloton”. It is expected to be released in Q4 of 2006 and will be based on Eclipse for its core IDE features. Features will include:

  • Support for new Java standards including Java SE 6 and the latest JSRs
  • Visual GUI development for Swing and SWT
  • Certified Eclipse bundle, updated regularly with the latest plug-ins
  • Visual Web Services development using a familiar GUI, full round-trip development of web services and web service clients
  • Virtual Peer-to-Peer Collaboration allowing distributed teams to work together with live co-editing and co-debugging (first introduced for JBuilder 2006 as a separate product)

For more information check the full product roadmap at Borland’s web site.

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, preventing even your front page from opening:

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

This is a bug of Ultimate SEO contribution. 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

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.