Installing SQLite 3

If SQLite 3 is failing on you during installation or usage, maybe it would be good to check a few things:

• When trying to install the sqlite3-ruby gem, make sure to have the SQLite 3 development package with the header files. On most distributions, there should be a package named libsqlite3-dev (or something like this). The header files are required for installing the gem because there is an intermediate building step.

• If you see the messagem 'sqlite3 not recognized as internal command' (or something like that) on Windows systems, maybe you forgot to add the SQLite directory on the PATH environment variable.

Segmentation fault under Win32

There may be segfaults if the compiler used for the gems is different than the one used for Ruby itselft under Windows. It looks like the One-Click Ruby Installer project uses Visual C++ 6 for building the binaries, so, if you happen to be using their distro, it is a good idea to download the matching gems. If you are not, please see what compiler was used in your Ruby binary and adapt accordingly.

When installing the Motiro required gems, you may stumble across a question like this

  % gem install popen4
  Select which gem to install for your platform (i486-linux)
  1. POpen4 0.1.1 (win32-1.8.2-VC7)
  2. POpen4 0.1.1 (unix)
  3. POpen4 0.1.1 (win32-1.8.4-VC6)
  4. POpen4 0.1.1 (win32-source)
  5. POpen4 0.1.0 (unix)
  6. POpen4 0.1.0 (win32-1.8.2-VC7)
  7. POpen4 0.1.0 (win32-source)
  8. POpen4 0.1.0 (win32-1.8.4-VC6)
  9. Cancel installation

For this gem, the best option is the third one. Besides being the most recent version, it was compiled with Visual C++ 6 (as show by the suffix -VC6).

Special characters on the installation paths

You may experiment some strange errors when Motiro or its dependencies are inside a directory with spaces on the path. It isn't enough to have everything installed in directories with simple and short names: the whole path down from the file system root needs to be free of spaces and other special characters. Windows platforms are much famous for favouring this kind of error, but the problem may happen in the best families.

Please be sure that there is no space or other special character on the path from the file system root to where your stuff is installed. This includes the Ruby interpreter (ruby), the SQLite libraries and Motiro.