Dmitriy Sukharev. IT Blog

Today I've moved my personal site from free PHP hosting to Amazon S3 in static website hosting mode. The reason was that I didn't feel that it's right thing to host static content in MySQL database ツ. As result all my URLs changed. Search engines indexed old URLs ...

Well, I haven't remembered syntax of database creation in UTF-8 character set with MySQL for quite a long time. Finally I decided to write a little snippet because I used it so often last time.

CREATE DATABASE database CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER 'username'@'localhost' IDENTIFIED BY ...

It's kind of not trivial to use JBoss AS after usage of containers like Apache Tomcat or Jetty. And unfortunately JBoss AS isn't distributed in the way that let it be easily set up as service. This article is just a remember for me how should I install ...

Once you have SSH access to the server, you can use tunneling to connect to its services that are unavailable to others.

Use the following command to make example.com:1521 be available as your localhost:1522.

ssh -N -p 22 usename@example.com -L 1521:localhost:1522

To enable code highlighting in Vim add text "syntax on" to file ~/.vimrc or execute the following command:

echo "syntax on" >> ~/.vimrc

If you want to enable highlighting only once, you can execute the following command from Vim (press Esc before typing to exit from insert/replace mode):

:syntax on

For some reason there's no way to change standard behaviour when the lid is closed in Gnome3 via System Settings. Fortunately it's possible to do in terminal. For this execute the following commands (NOT as root):

$ gsettings set org.gnome.settings-daemon.plugins.power lid-close-ac-action "<action>"
$ gsettings set org ...

In Eclipse it's possible to create easy to insert templates. Probably you have used "main" template by typing "main" and pressing Ctrl + Space to create main method. You also probably have faced the problem of logging huge amount of classes, and everywhere you needed to use logger factory, type ...

It's possible to tell Eclipse which code should lead to warning, which to error and which should be handled as normal.

You need to do the following two steps for this purpose:

1. Open Window -> Preferences -> Java -> Compiler -> Errors/Warnings.
2. Change properties in the way you want.

My settings are ...

Very handful answer at superuser.com:
Apache Server on Windows 7 opening up ports?

The local XML file './data/bugzilla-update.xml' cannot be created. Please make sure the web server can write in this directory and that you can access the web. If you are behind a proxy, set the proxy_url parameter correctly.

If you got this error and you are sure that the ...