I'm trailing a new install of MONyog 1.11 and so far have had a great impression of this. Unfortunately everything but the process list works:

Msg: "Empty Processlist. Consider changing Processlist filter.Change Filter"

I've looked at the MONyog.log and there are no errors except for a...

"[1.11] [2007-10-30 12:20:31] ./lib/webyog/src/ymysql.cpp(143) ErrCode:2006 ErrMsg:MySQL server has gone away"

...but I don't think this is it.

Any ideas?

1) Please try to execute SHOW FULL PROCESLIST as the same user. If you have SQLyog you can use the tools .. show menu.

2) What are the privileges of the user? Does he have PROCESS or SUPER privilege? (refer to the docs!)

3) What is the PROCESSLIST filter currently in action?

Thanks for your help!

I have to run 'SHOW FULL PROCESSLIST\G' at mysql command line to get anything - when I do I get:



2) the user has been given both Super and Process privileged.

3) The process filter is the default one.

The only processes you get returned are processes of user 'MONyog'. And those are filtered away .. !
so either there are no processes of other users or the privileges don't work as expected!

What does

return?

Thanks for this - the grants looked fine but I moved it to the root user just to be sure and still getting the same thing.

Looking at the MONyog.log file I get:

[root@lightershade-ds-03 MONyog]# tail -f MONyog.log
[1.11] [2007-10-30 22:46:52] ./MONyog/processlistmgr.cpp(151) ErrCode:-1 ErrMsg:Can't connect to MySQL server on 'intranet.lightershade.com' (111)
[1.11] [2007-10-30 22:46:54] ./MONyog/processlistmgr.cpp(235) ErrCode:2003 ErrMsg:Can't connect to MySQL server on 'intranet.lightershade.com' (111)
[1.11] [2007-10-30 22:46:54] ./MONyog/processlistmgr.cpp(151) ErrCode:-1 ErrMsg:Can't connect to MySQL server on 'intranet.lightershade.com' (111)
[1.11] [2007-10-30 22:46:55] ./MONyog/processlistmgr.cpp(235) ErrCode:2003 ErrMsg:Can't connect to MySQL server on 'intranet.lightershade.com' (111)
[1.11] [2007-10-30 22:46:55] ./MONyog/processlistmgr.cpp(151) ErrCode:-1 ErrMsg:Can't connect to MySQL server on 'intranet.lightershade.com' (111)
[1.11] [2007-10-30 22:46:56] ./MONyog/processlistmgr.cpp(235) ErrCode:2003 ErrMsg:Can't connect to MySQL server on 'intranet.lightershade.com' (111)
[1.11] [2007-10-30 22:46:56] ./MONyog/processlistmgr.cpp(151) ErrCode:-1 ErrMsg:Can't connect to MySQL server on 'intranet.lightershade.com' (111)
[1.11] [2007-10-30 22:48:51] ./lib/webyog/src/ymysql.cpp(143) ErrCode:2006 ErrMsg:MySQL server has gone away
[1.11] [2007-10-30 22:48:53] ./lib/webyog/src/ysftp.cpp(154) ErrCode:-1 ErrMsg:Could not open file '/var/run/mysqld/mysqld.pid': sftp server : Permission denied
[1.11] [2007-10-30 22:48:53] ./MONyog/populatesystem.cpp(139) ErrCode:-1 ErrMsg:GetMysqlPid


[1.11] [2007-10-30 22:50:51] ./lib/webyog/src/ymysql.cpp(143) ErrCode:2006 ErrMsg:MySQL server has gone away
[1.11] [2007-10-30 22:52:51] ./lib/webyog/src/ymysql.cpp(143) ErrCode:2006 ErrMsg:MySQL server has gone away
[1.11] [2007-10-30 22:54:51] ./lib/webyog/src/ymysql.cpp(143) ErrCode:2006 ErrMsg:MySQL server has gone away
[1.11] [2007-10-30 22:56:51] ./lib/webyog/src/ymysql.cpp(143) ErrCode:2006 ErrMsg:MySQL server has gone away
[1.11] [2007-10-30 22:58:51] ./lib/webyog/src/ymysql.cpp(143) ErrCode:2006 ErrMsg:MySQL server has gone away
[1.11] [2007-10-30 23:00:51] ./lib/webyog/src/ymysql.cpp(143) ErrCode:2006 ErrMsg:MySQL server has gone away


The break is when I set global read permissions so that MONyog can see the mysqld.pid file and read it.

I still get no processlist though

Hi,
By default MONyog will filter ''SHOW FULL PROCESSLIST' for queries and queries which are not like ''SHOW FULL PROCESSLIST'. You can change this by using 'Change Filter' option. If you click 'Change Filter' you can see the filter is set to

SELECT *
FROM processlist
WHERE Command = 'Query'
AND info <> 'SHOW FULL PROCESSLIST'
ORDER BY time DESC

you can replace this filter with the fiollowing

SELECT *
FROM processlist
ORDER BY time DESC

it will display all threads.