Troubleshooting
Having trouble? See if we can help you out with your issue:
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)"
...
- 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. SQL DM for MySQL 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 SQL DM for MySQL home pageSimply 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 dataSQL DM for MySQL can retrieve OS data from Linux operations systems if SSH shell access is possible or configured to that system. Note that SQL DM for MySQL can do this no matter on what Operating System SQL DM for MySQL itself is installed.
In the Opera browser the red and yellow indicators in 'Monitors' interface do not update correctly.You need to always configure Opera 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 that do not work properly with SQL DM for MySQL webpages. Set Check Images to Always.
SQL DM for MySQL History/Trend graphics display partly outside visible screen areaOn some systems that use a wide-screen monitor, earlier versions of the Opera browser (< 8.5) is not obeying the javascript command to open a new 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 errorThis error comes up because, if you give 'localhost' as the host, mysql client library trying 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.
...
- You can keep '/var/run/mysqld/mysqld.sock' as it is. And, you can force SQL DM for MySQL to use TCP based connection specifying "127.0.0.1" as the host instead of 'localhost'.
| Anchor |
|---|
| systemcounters |
|---|
| systemcounters |
|---|
|
Tunneling works for me but I cannot get system countersI 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 SQL DM for MySQL 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.
...
| Code Block |
|---|
|
jenny:x:10002:10003:Jenniffer:/home/jenny:/bin/bash |
| Anchor |
|---|
| authentication |
|---|
| authentication |
|---|
|
Key based authentication does not work with SQL DM for MySQLPlease note that for key based authentication SQL DM for MySQL supports only OpenSSH specified standard key format for public and private keys. SQL DM for MySQL does not work with the keys generated by other SSH related products. This list includes but not limited to key pairs generated by:
MONyog-bin not found on MONyog START commandThere may be two reasons for this error:
- Path is invalid. When using the .gz-compressed build for Linux you start the MONyog(SQL DM for MySQL) service like "{path to} MONyog START". If you are executing from the MONyog folder yourself you need to write "./MONyog START". "./" means 'current folder' and on most Linux 'current folder' is not in PATH environmental variable, so you have to specify it.
- 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' errorProblem: I have a log in a shared folder. I am able to access that log myself, but press test path button in Query Analyzer settings keeps throwing 'File Path Invalid' error.
Solution: By default SQL DM for MySQL installs on Windows with the privileges of the local system account. It does not automatically give you access to shared folders located on other systems. In the Windows service manager (Control Panel -> Administrative Tools -> Services) locate the MONyog(SQL DM for MySQL) 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 authenticationTo resolve an error like the following:
...
- Ensure that whatever the public key content you pasted in authorized_keys is same 'byte by byte' that you paste in SQL DM for MySQL public key field.
- Ensure that you are trying with the same username. This is a common mistake to add keys for one user authorized_keys and trying to connect with another user.
- The authorized_keys file should have permission 600. That is, read/write permission only to the owner.
- 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" columnsSay for example, in the Query Analyzer Page, the Total column value is 2:16:5.282 but in CSV it is displayed as 16:5.282.
...
- 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?After you have started Excel (this FAQ uses Excel 2003), follow these steps:
...