Bug #60853 Server Logs not viewable when Log Destination set to FILE,TABLE

• Submitted: 13 Apr 2011 11:44
• Modified: 18 May 2011 1:57
• Reporter: Anthony Pidden
• Status: Closed
• Category: MySQL Workbench: Administration
• Severity: S3 (Non-critical)
• Version: 5.2.33 CE
• OS: Any (Windows 7 x64, Mac OS X)
• CPU Architecture: Any
• Tags: log, logging

[13 Apr 2011 11:44] Anthony Pidden

Description:
I have my MySQL server setup to log to 'TABLE,FILE' however MySQL Workbench does not allow me to view the server logs and tells me my log destination must be 'TABLE'.

How to repeat:
Setup MySQL 5.1 with the follow line in my.cnf

log-output = TABLE,FILE

and attempt to view logs of this server from MySQL Workbench

Suggested fix:
Allow MySQL Workbench to accept a log-output LIKE '%TABLE%' instead of log-output = 'TABLE'

[13 Apr 2011 11:46] MySQL Verification Team

The server is local or remote?. Thanks.

[13 Apr 2011 12:28] Anthony Pidden

The server is remote through SSH. MySQL server version 5.1.49

I have switched from FILE,TABLE to TABLE and the log viewer is visible once again

[13 Apr 2011 13:05] Valeriy Kravchuk

Thank you for the bug report. Verified on Mac OS X.

[18 May 2011 1:57] Paul DuBois

Noted in 5.2.34 changelog.

Workbench could not view the server logs if the server was configured
with log output set to 'TABLE,FILE'.

[9 Jun 2011 11:30] Valeriy Kravchuk

Bug #61457 was marked as a duplicate of this one.