Page History

...

• 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'.

...

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

...

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.

...

Please 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,:

• Puttygen
• SecureCRT

MONyog-bin not found on MONyog START command

...

Problem: I have a log in a shared folder. I am able to access that log myself, but press test '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 authentication

To resolve an error like ,the following:

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

1. 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 '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.

...

Say for example, in the Query Analyzer Page, the 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:

...

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 Next.
   Image Added

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 Added

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

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 Added