[Sabyasachi Ruj]

'zeltus' wrote on '24:

Will look at your extensions module this evening…

Let me know the results. Is it possible for you to give a test FTP account to us? We may need to test why your PHP behaving in a different way.

[Sabyasachi Ruj]

1. Can you give us access to your phpinfo page?

2. Also, I am attaching one file here (extensions.php). Please upload this in the same server and give us the URL.

In case you don't want to make these information public, you can create a ticket here: http://webyog.com/support/ttx.cgi.

[Sabyasachi Ruj]

'Gordon wrote on '24:

But it creates a new problem. We then will not be be able to use https to access the site using the tunnel. I wonder if the SSL tab “Connect to MySQL Host” will work for me. The SSL certificate is about to be installed for the first time. I had to use the tunnel because of ISP restrictions.

I am afraid I don't understand the problem. Please explain what do you want to do exactly. If you want to access the tunnel PHP file using HTTPS, you could just use the URL in SQLyog like:

Code:

https://www.ourdomain.org/path/to/SQLyogTunnel.php

[Sabyasachi Ruj]

Hi Jeff,

1. Can you upgrade to our latest MONyog version (3.61)?

2. Can you explain “MONyog has been crashing the box”? What do you mean by “crashing” here? What is the effect?

3. Is it still crashing after upgrading to 3.61?

[Sabyasachi Ruj]

Additionally please answer these too:

8. When the error occurs, is the problematic server's SSH reachable from the system where MONyog is running? You can test this by connecting from a SSH client. I guess the problematic server is 10.201.1.66, right? I guess you have to involve your network admin.

9. You have told restarting MONyog service or the host solves the problem. Was there any case when restarting MONyog service did not help? So that, you had to restart the host? It is possible due to some reason the SSH server of 10.201.1.66 was not reachable from that host.

10. Are you using SSH tunneling to connect to replication slaves?

11. When processlist tab was showing the error, what was the “monitors and advisors” page showing for that server? Was it available?

[Sabyasachi Ruj]

Hi,

The user which is the owner of the process “MONyog-bin” should be added to group “mysql”.

Step 1

To find this execute the command in your shell: –

ps -o”%U” -C MONyog-bin

The above command will show the linux user which is running MONyog. Say it is 'rupurt' in your case.

Step 2

Add the user to mysql group by executing the following command: –

usermod -G mysql rupurt

Step 3

You can make sure if the user is added to the group 'mysql' by executing the following command: –

id rupurt

Remember, I have used 'rupurt' as an example here. Replace it with the owner of MONyog process (found in Step 2).

[Sabyasachi Ruj]

Shlomo Priymak wrote on Jun 30 2008, 02:09 PM:

3. Will do, but I do not intend to do so regularly.

Yes. This is just to test, if it works like that.

Shlomo Priymak wrote on Jun 30 2008, 02:09 PM:

4. About 2-3 GBs. I usually look at it using tail.

What could I check futher to assist you? It seems it should just work. Maybe it is somehow related to the fact it tries to access the wrong path, such as given in the error – “'/mnt/vol/slow.log'”? Or are those back-slashes only a display issue?

Shlomo

We are trying to reproduce this at our end. We'll get back to you.

[Sabyasachi Ruj]

Shlomo Priymak wrote on Jun 30 2008, 02:00 AM:

Negative. This is an Ubuntu Server 7.10 64bit.

Can the same (which is being used to run MONyog) Ubuntu user access the log file?

Does the user account have super user privileges which is being used to run MONyog?

Can you try starting MONyog in 'root' user?

What is the size of the log file that MONyog can not access?

[Sabyasachi Ruj]

peterlaursen wrote on Apr 18 2008, 02:44 AM:

@sabya

… and this we should add to documentation, I think?

@Peter: Yes

[Sabyasachi Ruj]

DavidL wrote on Apr 18 2008, 12:46 AM:

I'm using the 2.01 version of MONyog. It's displaying a message “Could not read PID file” for the Linux, Memory used by MySQL monitor. I don't understand what needs to be fixed so this monitor can correctly report memory usage. Are there some suggestions on either Linux or MONyog changes to resolve this? The other Linux monitors are showing good data. The Linux monitors are running with an admin account.

David

To get the memory usage by MySQL, MONyog reads the mysql pid file. So the SSH user should have permission to read the mysql pid file.

To do that, I suggest you to add the SSH user to mysql unix group.

[Sabyasachi Ruj]

Dave B wrote on Apr 10 2008, 03:10 AM:

If the SJA folder is: sja651

and the xml sample is: summer.xml

and the main SJA file is renamed: sja.sja (or any extension)

Then you could save me hours of frustration by, please, help tell me the exact format for the cron command, and if the sja for Linux files need to be on both servers, or just one.

Thank you very much

Hi,

There is a command call 'crontab' in Linux, that will allow you to create/edit cron jobs.

If you just want to know the format/sytax, refer to: –

http://en.wikipedia.org/wiki/Cron#Usage

As an example to schedule sja through cron: –

0 11 * * * “/home/sabya/sja/sja” “/home/sabya/sja/summer.xml” -l”/home/sabya/sja/sja.log”

This will schedule sja to execute queries in summer.xml, everyday at 11:00 AM.

[Sabyasachi Ruj]

ianmcg wrote on Apr 9 2008, 02:15 AM:

Does anyone know if you can customize a monitor which will execute a SQL statement?

Currently, it is not possible. But if you can give us a good reason/use of that feature, we will consider.

ianmcg wrote on Apr 9 2008, 02:15 AM:

I really want to integrate MonYog with DBTuna for MySQL, so that I can use MonYog alerting functionality based on DBTuna data.

Great tool by the way. I think with MonYog and DBTuna together you have complete coverage for MySQL monitoring.

Thanks.

We have not tried DBTuna yet. We will try that and will get back to you soon. By that time, can you say what will you get by integrating MONyog with DBTuna?

ianmcg wrote on Apr 9 2008, 02:15 AM:

Regards.

Ian

[Sabyasachi Ruj]

Good to know about your interest in MONyog.

We are planning a Beta of MONyog 2.0 within next 3 weeks.

[Sabyasachi Ruj]

Dan H wrote on Jan 8 2008, 04:18 AM:

Is the data monyog collects stored in a local database on the server? And if so, is it possible to connect to it externally to query the data? I am interested in being able to see the trend of CPU usage over a larger period of time than the given 1hr.

Thanks,

Dan H

Hi,

Yes MONyog data is collected in a SQLite database. You can find the directories named like '0001', '0002', etc in your data directory.

Where each 4 digit numbered directory is the store for a particular server registration.

Although they are in the database, we do not recommend connecting to it externally. Because we use some internal optimizations to store them.

Anyway, the given 1 hour is the data retention interval, I guess. Data, older than that interval will be purged by MONyog to save disk space.

So if you need longer period you can increase the data retention interval.

BTW: MONyog 2.0 will come with history analysis, where you can even see and analyze historical data.

[Sabyasachi Ruj]

Bruce Leister wrote on Nov 15 2007, 07:27 AM:

Hi,

Using MONyog 1.11 in Show ALL/InnoDB Cache it shows my sever with a hit cache rate of 99.9%, yet if I click the graph symbol it shows a graph with the Cache Hit Rate flat-lining on Zero.

Is something wrong, or am I misunderstanding the data ?

Bruce Leister

Hi Bruce,

I think nothing is wrong with that, except the user is not being notified (although it is documented) about the fact that:-

All the graphs for the cumulative values (like, 'Connection History -> Attempts' which gives the value since the server is started) which are being shown in MONyog are delta values, irrespective of the interface you are looking at (All time, Delta, Default sampling timeframe, Custom Timeframe).

I guess you are in 'All time' interface, so the value you see there and the graph are not matching.

Of course, we can communicate this to the user in a better way. We'll show the user a message notifying this.

[Author]

Posts