Monyog Remote Usage

[[email protected]]

I've installed Monyog and pointed it to a remote mysql 5.0 server but only “version”, “running for”, and “start time” are displayed. Is this tool meant to be run on the same server as mysql? If there's docs explaining this please point me to them.

Thanks,

Kathy Mazur Worden

[peterlaursen]

No .. it will connect to remote MySQL servers as well (if direct connection is available).

I think you just do not understand how to use MONyog!  Just position the mouse over one of the 'groups' (the left column) and the counters for that group will display. Do not click!

BTW: moving this to the 'MONyog' category

[dc45]

The website that this runs off of is [url=”http://localhost:9999/”]http://localhost:9999/[/url]

Is this accessible from other computers by going to [url=”http://SERVER_NAME:9999/”]http://SERVER_NAME:9999/[/url] ?

I am unable to access it from another computer. Can the port be changed?

[brashquido]

dc45 wrote on Mar 15 2007, 08:51 PM:

The website that this runs off of is [url=”http://localhost:9999/”]http://localhost:9999/[/url]

Is this accessible from other computers by going to [url=”http://SERVER_NAME:9999/”]http://SERVER_NAME:9999/[/url] ?

I am unable to access it from another computer. Can the port be changed?

As far as I know you are not able to access Monyog from remote servers, and the port is hardcoded at this stage. If you need to monitor a remote MySQL server with Monyog the only way at present that I know of is to install Monyog on your local machine and connect to your MySQL server over the network. You'll need to make sure networking is enabled in MySQL and that you are able to connect to it (e.g, make sure TCP port 3306 is open in your firewall, etc)

[Rohit]

Yes, only localhost connection is supported for the web-server.

We will allow remote access to the web-server after we build a robust authentication system.

[maranax]

Guys,

I've just started using MONyog, please advise me: Is there possible to watch query log from remote server if MONYog installed on Windows and the remote server is on Linux?

[manohar]

Hi,

Yes, it is possible to analyze your query log in Linux machine from windows machine. All you have to do is

1) Go to “SSH server details” section in connection settings.

2) Do you want to use SSH? –> choose yes.

3) Choose “Linux” as OS of the host

4) Enter SSH details. (SSH user should have permission for SFTP access)

5) Go to “Log Analyzer Settings” and choose “Via SFTP”

6) Enter the log file path

Now you are ready for Analyzing, just go to Log Analyzer page and select appropriate connection for which you have entered log file path and analyze.

[maranax]

Thanks a lot!

[Author]

Posts