Category: Troubleshooting

Troubleshooting Questionmark Perception database connections

Posted on by

We’ve had just about every sort of database connection issue with our two Questionmark Perception servers, so in the interest of saving someone else the kind of struggles we’ve gone through, here are some things to look for.

  1. tnsnames.ora issues:
    There is a file that lives in a subdirectory of the Oracle folder – this directory may be called Oracle_Home, Oracle9 etc, and is often but not always in the root directory of the server.

    A typical path to the tnsnames.ora file on a server is

    E:\Oracle_HomenetworkAdmintnsnames.ora

    There are a variety of things that could be incorrect in this file.

    1. Hidden control characters brought in during copy and paste:
      If you copy and paste the settings from some email programs into this file, you may be adding hidden control characters to the tnsnames.ora file. You won’t be able to see them but they’re there, and they’re screwing things up.

      Continue reading

When MovableType won’t recognize ImageMagick

Posted on by

Recently my web-host restored the server I use after some problems which necessitated wiping it and starting from scratch. After doing this my installation of MovableType was no longer able to create thumbnails. The thumbnail option no longer appeared in the upload dialog. When I looked at the config file, all the thumbnail options were commented out – in other words it was defaulting to use ImageMagick.

If you read the verbiage in that file carefully, which I did not, it says:

Specifies the image toolkit used to create thumbnails from uploaded images.
# By default, the ImageMagick library and Image::Magick Perl module are used;
# if your system does not have these, you can use the NetPBM tools instead
# (assuming that your system has these tools installed). Possible values for
# this setting are "ImageMagick" or "NetPBM".
#
# ImageDriver NetPBM

Continue reading