[jamesv]

peterlaursen wrote on Oct 30 2007, 09:41 PM:

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

Code:

SHOW GRANTS for 'MONyog'@'localhost'

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 🙁

[jamesv]

peterlaursen wrote on Oct 30 2007, 12:19 PM:

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 PROCESSLISTG' at mysql command line to get anything – when I do I get:

[codebox]mysql> SHOW FULL PROCESSLISTG

*************************** 1. row ***************************

Id: 9634

User: MONyog

Host: localhost

db: NULL

Command: Query

Time: 0

State: NULL

Info: SHOW FULL PROCESSLIST

*************************** 2. row ***************************

Id: 9667

User: MONyog

Host: localhost:46985

db: NULL

Command: Sleep

Time: 11

State:

Info: NULL

2 rows in set (0.00 sec)[/codebox]

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

3) The process filter is the default one.

[Author]

Posts