Log Slow Queries Path Invalid

[Maurice]

I have a file named log-slow-queries.log in the /var/log/mysql folder it has all the write permissions on it

but MonYog Enterprise log settings it tells me that the path /var/log/mysql/log-slow-queries.log is invalid.

Any suggestions ?

*************************************************************************

* ********************************************************************* *

* * MONyog * *

* * Connection Diagnostic Info * *

* * This file contains basic information about your server, and can * *

* * be safely transmitted to Webyog Softworks Pvt Ltd for debugging. * *

* * NOTE THAT THIS FILE DOES NOT CONTAIN ANY SENSITIVE INFROMATION. * *

* * * *

* ********************************************************************* *

*************************************************************************

Name = SunServer

Tags = server

Notify when server restarts = Yes

MySQL Server Details:

Is Replication Slave = No

Use SSH Tunnel = No

SSH Server Details:

Is SSH Enabled = Yes

OS of the Host = linux

Use same as Tunnel details = No

Data Collection Options:

Collect Data from this server = Yes

Data Collection Interval = 2 minute(s)

Data Retention Time Frame = 7 day(s)

Base Time =

ProcessList Options:

Display Refresh Interval = 1 second(s)

Log Settings:

Read File From = Local Path

Slow Query Log Enabled = Yes

Slow Query Log Destination = File

Slow Query Log Path = /var/log/mysql/log-slow-queries.log

Long Query Time = 0 second(s)

Log Queries not using Indexes = No

General Query Log Enabled = No

General Query Log Destination = File

General Query Log Path = /var/log/mysql/log-general-queries.log

Sniffer Settings:

Enable Sniffing = Yes

Sniffing Mode = Processlist

Sniffing Time Interval = 1 hour(s)

Data Retention Time Frame = 3 day(s)

Client User =

Client Host =

Minimum Time Taken = 0 second(s)

Queries Starting With =

Monitoring Long Query = Yes

Long Running Query Time = 10 second(s)

Action to be taken = Notify

Ignore User =

MySQL Error Log Settings:

Enable Error Log Monitoring = No

Notification Settings:

Enable SMTP = Yes

Enable SNMP = No

Send notification when alert-able = 5 time(s)

Notify again after every = 10 alert-able cycle(s)

Notify when stable = No

[Sayan Chaliha]

'Maurice' wrote on '15:

Log Settings:

Read File From = Local Path

…

Is MONyog running on the same system where the log file is?

[Maurice]

No the MonYog is running on my windows system and the mysql is on the linux server

ok I get it I had it set to local path

Read File From = Local Path

I have it set to sftp now and it finds the file

Cheer's

[Sayan Chaliha]

Hi Maurice,

I see that you've already enabled system monitoring through SSH, so all you need to do is select 'via SFTP' in “Edit Server” –> 'Log Settings”. This should solve the problem.

BTW, I also replied the same to the ticket you had created. I will close the ticket, and we can continue our discussion here… Is that ok?

[Maurice]

'Sayan wrote on '15:

Hi Maurice,

I see that you've already enabled system monitoring through SSH, so all you need to do is select 'via SFTP' in “Edit Server” –> 'Log Settings”. This should solve the problem.

BTW, I also replied the same to the ticket you had created. I will close the ticket, and we can continue our discussion here… Is that ok?

sure no problem

[Author]

Posts