[Sabyasachi Ruj]

Hi,

May be your environment is not allowing what is working for us.

For faster resolving of this issue can you create one SSH user on your environment with VERY LIMITED PERMISSIONS?

We DO NOT need any other access to your environment than just being able to connect and adding public keys ONLY in that account.

If you agree, I insist you to use our ticket system for sharing the details.

It can be found here:-

http://www.webyog.com/support/ttx.cgi

If you do not agree to create any account for us. Please write us what is the OS of your environment, ssh server vendor, etc so that we can set up a similar environment.

The second method will take some more time to investigate the problem.

[Sabyasachi Ruj]

Hi,

We will look into that again by tomorrow evening.

[Sabyasachi Ruj]

krlloyd wrote on Sep 22 2007, 02:18 AM:

I am using the non rpm build for the beta and I am running into a mysql.sock error. I was able to see that my mysql socket name and location is different from what SYSyog expects.

So i altered my.cnf and changed it from /var/run/mysqld/mysqld.sock to /var/lib/mysql/mysql.sock and it works fine. But this fix broke phpMyAdmin.

So i need to recompile SYSyog to change the sock location? I want it to match what is on my system. Thanks!

Hi krlloyd,

I am assuming that 'your SYSyog'='our MONyog'.

There are two ways you can solve this problem on your own.

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'

And in your “phpMyAdmin”, it is '/var/run/mysqld/mysqld.sock'

So if one software works the other breaks.

To solve this problem:

1.

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.

2.

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'

[Sabyasachi Ruj]

Hi Jexxer,

Are you sure that you are using the “unencrypted” certificate with SQLyog and then trying with garbage passphrase?

Because, I can connect here with unencrypted certificate and a garbage passphrase in SQLyog Enterprise v6.07.

Can you provide us with the screen shots of your connection window(MySQL, SSH tabs), and the error you are getting?

You can create a ticket in our support system, if you want privacy.

The ticket can be created at:-

http://www.webyog.com/support/ttx.cgi

[Sabyasachi Ruj]

Can you connect with plink and putty with the same key you are using with SQLyog?

You can download plink from:-

http://www.chiark.greenend.org.uk/~sgtatha…y/download.html

And then try the following command with parameters changed according to your configuration.

plink -ssh -l username -pw “some_crap_passphrase” -L 3310:localhost:3306 -P 22 192.168.1.3 -i “path_to_private_key.ppk”

Can plink connect to SSH server with anything you use as passphrase in the -pw option?

NOTE: -pw option is also used for specifying the password also, when using “password based” authentication.

[Sabyasachi Ruj]

Hi jexxer,

You are correct in both of them.

1. Passphrase is used to encrypt the private key file.

2. SQLyog should not throw up the message:”Please provide your SSH server's Password”,

when using key based authentication and the 'Passphrase' field is empty.

Currently as a work around (If you want to use your private key file which is without passphrase):

You can just type something crap in the 'Passphrase' input box, and it will use your private key file only.

BTW: This will be fixed soon.

Thanks for reporting,

[Sabyasachi Ruj]

Hello,

Thanks for your interest in MONyog.

We are planning to release MONyog 1.1 (beta) next week.

We'll support 64 bit systems from that version.

successor wrote on Sep 13 2007, 10:51 AM:

I wanted to evaluate MONyog and tried to install the non-rpm linux version on our monitoring-server (Gentoo, AMD64). At first the start script couldn't find the zlib library since it doesn't seem to recognize the lib64/ path. After editing the script accordingly the following message is returned:

Code:

./MONyog-bin: error while loading shared libraries: libz.so.1: wrong ELF class: ELFCLASS64

Am I right in my assumption, that the downloadable linux evaluation version of MONyog is not runnable under a 64bit Linux? Are there plans to release such a version?

[Sabyasachi Ruj]

Hi,

The change that you have to do in php.ini is in [MySQL] section. for example:

[MySQL]

; Allow or prevent persistent links.

mysql.allow_persistent = On

And as more information:-

---

If you are using mysql_pconnect(), and say five persistent connections are in pool for that client.

Now mysql_pconnect can return any one of them.

So, If you are expecting that mysql_pconnect will return always use the same persistent connection, that is not the case.

As a result, say you are executing the following query after connecting with mysql_pconnect:

set @aa=6;

And after one more mysql_pconnect, you executed:

select @aa;

That will not necessarily return '6' as the result!

Because the second mysql_pconnect can take another persistent connection from that server's connection pool.

[Sabyasachi Ruj]

Tushar Mahale wrote on Aug 7 2007, 07:57 PM:

Thanks for the reply Sabyasachi, much appreciated.

Regarding the graphs, I was just wondering if it was possible to use our own metrics there instead of time e.g. say select_scan plotted against the number of queries that may give an insight into how good our indexing system is.

Let me explain what I understood from your example.

You want to plot Select_scan against number of queries to get an overview of how good the indexing is.

I have a solution:

Say, Select_scan = x, and number of queries = y.

You can always add a dashboard graph to plot x/y, if the ratio is low, I think that means you have good indexing.

Am I missing something to get your requirement?

Tushar Mahale wrote on Aug 7 2007, 07:57 PM:

One more question regarding MONYog, if you dont mind 🙂

No. I won't mind. 😉

Tushar Mahale wrote on Aug 7 2007, 07:57 PM:

Does MONyog support internationalization now? If not, do you guys have any plans to provide it in the near future?

The answer to this is, yes it supports Internationalization now, but to some extent.

MONyog supports UTF-8.

Inputs can be given in any language.

And those will be displayed in that language only. 🙄

But the strings, which MONyog shows itself, are only in English now.

We do not have any immediate plan to convert those strings to support multiple languages. But we will do, once we get some requests from our users.

[Sabyasachi Ruj]

Quote:

Hi,

I've been evaluating MONyog and I have a few questions about it. I would be grateful if anybody could help me out with those.

Thanks for trying MONyog!

Quote:

1. On the dashboard interface, it seems that all the graphs need to be plotted against time. Is it the requirement or would it be possible for me to provide a two dimensional array in the JavaScript code to draw the graph using those two values instead of against time? As far as I have seen, this does not seem to be possible though.

All the graphs in dashboard interface are plotted against time. And they are last fifteen collected data.

Currently it is not possible to plot any graph against something except time.

But we would like to know your request/doubt in more detail.

Can you give one example of what do you want in the graphs?

Quote:

2. what commands does MONyog use to collect the system info?

MONyog reads “/proc” file system in Linux systems to collect system related values.

Quote:

Does it also obtain the memory information? I did not see any documentation on how to access the system memory value using MONyog object model.

Yes it displays the memory information. Of-course, the target system (which you are monitoring) has to be Linux based.

I am discussing the system related MONyog Object Model(MOM) below:

There are four system related categories in MOM. They are:

Physical Memory related:

---

All these physical memory related metrics gives the values in KB.

“MONyog.System.Mem.sys_mem_total” : Total physical memory.

“MONyog.System.Mem.sys_mem_free” : Available physical memory.

“MONyog.System.Mem.proc_mem_vmrss” : Physical memory being used by MySQL.

Swap memory related:

---

All these swap memory related metrics gives the values in KB.

“MONyog.System.Swp.sys_swp_total” : Total swap memory.

“MONyog.System.Swp.sys_swp_free” : Free Swap memory.

“MONyog.System.Swp.proc_swp_vmsize” : Swap memory being used by MySQL.

CPU related:

---

All these CPU related metrics give the number of jiffies spent in various modes, since the last capture.

“MONyog.System.Cpu.sys_cpu_user” : User mode

“MONyog.System.Cpu.sys_cpu_nice” : Nice mode

“MONyog.System.Cpu.sys_cpu_system” : System/Kernel mode

“MONyog.System.Cpu.sys_cpu_idle” : Spent Idly

“MONyog.System.Cpu.sys_cpu_iowait” : Spent in waiting for IO

“MONyog.System.Cpu.sys_cpu_hi” : Spent in hardware interrupts

“MONyog.System.Cpu.sys_cpu_si” : Spent in Software interrupts

Custom:

---

“MONyog.System.Custom.Available” : If the system is available to MONyog or not.

Quote:

3. We can modify the client side Java script code to manage the information shown on MONyog web pages. Is it possible to change the server side code or customize it? e.g. if I want to monitor some system resource other than CPU, memory, can I modify the server code to do so?

Currently you can monitor only “Availability”, other CPU and Memory.

NOTE:

—-

Please note that, currently “Timeframe” does not have any effect on system related values.

[Sabyasachi Ruj]

burnsoft wrote on Aug 1 2007, 04:12 PM:

Very brilliant indeed, when are you guys going to have a price list for this tool?

Just a few minor issues that’ I’ve noticed in the first day concerning the system information section. It was able to get the CPU Usage, but it was not able t get the Total Memory, Memory used by MySQL, and Memory Free. The Information that it is trying to get is from a Mandriva 2006 x86 OS.

Thanks for reporting. We have fixed this issue.

We will release the new version soon.

[Sabyasachi Ruj]

Mike_the_newbie wrote on Jul 18 2007, 07:19 PM:

I have seen this same issue with W2K since version Beta 0.18. I am still using version Beta 0.16, filename MONyog016.exe, which was the last version to work properly with W2K. If you cannot find this file, try downloading it here:

http://home.earthlink.net/~networkscompany/MONyog016.exe

I hope someone is able to get the newer versions working with W2K. Good Luck!

Hello,

Last night we released MONyog 1.0 Release Candidate 1.

And this time MONyog is compatible with Windows 2000.

With some other improvemets.

For more details check our news link given below:-

http://www.webyog.com/forums//index.php?sh…amp;#entry14376

[Sabyasachi Ruj]

Thanks for this observation and reporting.

We are still working on this issue and found where the problem is.

We will get back very soon after solving this issue.

Probably next week.

Mike_the_newbie wrote on Jul 18 2007, 07:19 PM:

I have seen this same issue with W2K since version Beta 0.18. I am still using version Beta 0.16, filename MONyog016.exe, which was the last version to work properly with W2K. If you cannot find this file, try downloading it here:

http://home.earthlink.net/~networkscompany/MONyog016.exe

I hope someone is able to get the newer versions working with W2K. Good Luck!

[Sabyasachi Ruj]

Hello,

We know this issue. If fails to install in Win2K.

Currently we are testing with Win2K.

We will get back after solving this.

Jürgen Falch wrote on Jun 19 2007, 10:30 PM:

When starting MONYog.exe, it complains about 'entry”freeaddrinfo” not found in WS2_32.dll' and exits. Is this for XP or Vista only ? I still have Win2000.

Regards,

[Sabyasachi Ruj]

Hello,

Thanks for your inerest in MONyog.

What is the exact error report that you get in win98 and winxp ?

Copy-Paste of the message recommended.

For Linux versions, currently we are supporting only Red Hat based distributions.

However we have in mind to support SUSE and Ubuntu.

smbaloo wrote on Jun 12 2007, 06:09 PM:

Hello,

I have tried to install MONyog in win98 and winxp and ended with error report.

I tried to install in ubuntu using alien and it installed.

But donot know how to start the program.

The browser does not respond to [url=”http://localhost:9999/”]http://localhost:9999/[/url]

Please tell me is there any detailed document on how to install

and start the program

Baloo

[Author]

Posts