Please enter a valid email address. The download links will be emailed to you.
The download links for
MONyog have been sent to
Back to Topics

Troubleshooting

Have trouble? See if we can help you out with that.

I am not able to connect to MySQL

The error message,

Error No. 2003: Can't connect to MySQL server on 'localhost' (or some other host)

simply means that connection is not possible for one of the following (or similar) reasons:

  • There is no MySQL server running at the specified host.
  • Connection to the MySQL server is not allowed using TCP/IP. Check the 'skip-networking' setting in the MySQL configuration file (my.ini on Windows, my.cnf on Unix/Linux). It shall be commented out like '#skip-networking'. If it is not commented out, then do it and restart the MySQL server for the change to take effect. Monyog needs to connect using TCP/IP.
  • When trying to connect to a MySQL server at an ISP this error message often indicates that direct connection to MySQL has been blocked. You must then use SSH-tunneling to connect.
  • Some networking issue prevents connection. It could be a network misconfiguration or a firewall issue. We have experienced sometimes that some firewalls (ZoneAlarm in particular) is blocking TCP/IP connections even if it claims to be disabled. Most often it will help to uninstall and reinstall the firewall.

I am not able to view the Monyog home page

Simply means that connection is not possible for one of the following (or similar) reasons:

  • Wrong details (port for instance)
  • Firewall

I can connect to MySQL on the host but not able to retrieve OS data

Monyog can retrieve OS data from Linux operations systems if SSH shell access is possible/configured to that system. Note that Monyog can do this no matter on what Operating System Monyog itself is installed.

In the Opera browser the red and yellow indicators in 'Monitors' interface do not update correctly.

You will need to configure Opera always to check if graphics was updated. Opera Tools > Preferences > Advanced > History. Opera alone has this option. This is a 'performance optimization' that may be ok with largely static webpages will not work properly with Monyog webpages. Set 'check images' to 'always'.

Monyog graphics ('graphs') do not display or display with errors

Monyog uses the de-facto web standard FLASH - for data-driven graphics display. You should have FLASH version 9 installed for best display. If some display issue occurs please start to ensure that you have the most recent the browser as well as FLASH upgrades installed. Monyog 2.0 was tested at release time with all popular browsers and FLASH plug-in version '9,0,115,0'. Please first upgrade to a version not lower than this. Also note that you may need to upgrade FLASH after a browser upgrade.

Monyog History/Trend graphics display partly outside visible screen area

On some systems that use a wide-screen monitor, earlier versions of the Opera browser (< 8.5) will not 'obey' the javascript command to open a new ('popup') window for the display of a History/TRENDs graph. It opened in an ordinary tab instead. That resulted in the lower part of the graph to be invisible with relatively low screen resolutions (including the popular widescreen resolution 900*1440 (very common with laptops designed for Windows Vista)). You should upgrade Opera.

Getting mysql.sock error

This error comes up because, if you give 'localhost' as the host, mysql client library will try to use the unix domain socket (file based) instead of the TCP one. And every mysql client library has one path to the Unix domain socket.

  • In Monyog's mysql client library it is: '/var/lib/mysql/mysql.sock'
  • In "phpMyAdmin", it is: '/var/run/mysqld/mysqld.sock'

So if one software works the other breaks. To solve this problem:

  • You can create a symbolic link to your original '/var/run/mysqld/mysqld.sock' in '/var/lib/mysql/mysql.sock' '/var/lib/mysql/mysql.sock' -> '/var/run/mysqld/mysqld.sock'

The command to create this is:

$ ln -s /var/run/mysqld/mysqld.sock /var/lib/mysql/mysql.sock

This will create a symbolic link '/var/lib/mysql/mysql.sock' to '/var/run/mysqld/mysqld.sock'. So both the applications will work.

  • You can keep '/var/run/mysqld/mysqld.sock' as it is. And you can force Monyog to use TCP based connection specifying "127.0.0.1" as the host instead of 'localhost'.

Tunneling works for me but I cannot get system counters

I can connect to my FTP server, but could not use that same user to get system counters. Even, I can use the same user in Monyog to tunnel to MySQL server. To collect system counters, the SSH user should have access to a shell. This is specified usually in '/etc/passwd' file. But to tunnel to MySQL server the SSH user does not need a shell access. You can check the shell access which is given in /etc/passwd file.

For FTP users generally shell access will be blocked. A typical FTP user will have an entry something like this in the '/etc/passwd' file:

john:x:10009:10001:Jonathan:/var/www/vhosts/yourdomain.com:/bin/false

A colon (:) is used to separate the fields. All the fields are explained below:

  • john: The login name.
  • x: An x indicates that the encrypted password for this user is kept in /etc/shadow file
  • 10009: The unique User ID for this user.
  • 10001: The primary Group ID for this user.
  • Jonathan: This is the User ID info. Generally comments, full name of the user, etc.
  • /var/www/vhosts/yourdomain.com: The home directory for this FTP user.
  • /bin/false: This field indicates the shell access given to the user. And you can see that, no shell access has been given to 'john'. It is /bin/false.

This user 'john' can not use a shell. That is the reason ’john’ can not be used for collecting system counters. But user 'john' can be used for tunneling to MySQL server.

A typical user entry with shell access will have an entry in /etc/passwd something like:

jenny:x:10002:10003:Jenniffer:/home/jenny:/bin/bash



Key based authentication does not work with Monyog

Please note that for key based authentication Monyog supports only OpenSSH specified standard key format for public and private keys. Monyog will not work with the keys generated by other SSH related products. This list includes but not limited to key pairs generated by,

  • Puttygen
  • SecureCRT

MONyog-bin not found on MONyog START command

There may be two reasons for this error:

  1. Path is invalid. When using the .gz-compressed build for Linux you start the Monyog service like "{path to} MONyog START". If you are executing from the MONyog folder yourself you will need to write "./MONyog START". "./" means 'current folder' and on most Linux 'current folder' is not in PATH environmental variable, so you will have to specify it.
  2. You are trying to run a 64 bit build on a 32 bit platform or vice-versa. The MONyog-bin file is not recognized by the OS as a valid binary. You should use the 32 bit build on 32 bit OS's and the 64 bit build on 64 bit OS's (however support for 32 bit binaries may be configured on 64 bit Linux's, but often it is not the case with DEBIAN based Linux distros - including (k/x)Ubuntu's.

'Test Path' button in Query Analyzer settings keeps throwing 'File Path Invalid' error

Problem: I have a log in a shared folder. I am able to access that log myself, but test 'test path' button in Query Analyzer settings keeps throwing 'File Path Invalid' error.

Solution: By default Monyog installs on Windows with the privileges of the local system account. That won't automatically give access to shared folders located on other systems. In the Windows service manager (Control Panel -> Administrative Tools -> Services) locate the Monyog service and select 'properties' from the context (right-click) menu. In the 'log on' tab select an account that has sufficient privileges to access the shared folder on the remote system.

Authentication problem with key authentication

To resolve an error like,

"Failed to connect to SFTP: Error: offering public key failed, access denied, authentications that can continue: ...." or similar, do this:

  1. Ensure that whatever the public key content you pasted in authorized_keys is same 'byte by byte' that you paste in Monyog's public key field.
  2. Ensure that you are trying with the same username. This is a common mistake to add keys for one user's authorized_keys and trying to connect with another user.
  3. The authorized_keys file should have permission 600. That is, read/write permission only to the owner.
  4. Finally, ensure that the keys are standard OpenSSH keys not any proprietary or application-specific format.

When I fetched Details from MySQL, Log file Path is not showing?

Log file path could be fetched if the MySQL server you are registering is greater than 5.1.6. If your server is lesser than this, then all fields would be read only and you have entered the slow query log/general query log path yourself.

CSV file is not displaying correct results for "Query Execution Time" columns

Say for example, in the Query Analyzer Page, Total column's value is 2:16:5.282 but in CSV it is displayed as 16:5.282.

This is a 'formatting problem' in Excel instead if you open the export in Notepad or any other editor this problem will not persist. To view in Excel follow these steps:

  • Save the .csv file on disk.
  • Import the .csv file in Excel as explained below. (Note: Set the Data Format for columns containing time values to Text).

How to import a text file into Excel?

A: After you have started Excel (this FAQ uses Excel 2003), follow these steps:

  1. On the Data menu, point to Import External Data, and then click Import Data.
  2. In the Files of type dialog, click Text Files.
  3. In the Look in list, locate and double-click the text file you want to import.
  4. Select Delimited option and click on Next.

    image

  5. Set Delimiter to your locale-specific delimiter (COMMA " , " for English and SEMICOLON " ; " for most non-English) as you should have already defined in 'Preferences'. Click Next.

    image

  6. Select each column and set the Data Format appropriately and then click Finish.

    image

In the Import Data dialog, either one of the following options should be performed:

  • To return the data to the location you selected, click Existing worksheet, and then click OK.
  • To return the data to a new worksheet, click New worksheet, and then click OK. Microsoft Excel adds a new worksheet to your workbook and automatically puts the external data range in the upper-left corner of the new worksheet.

    image