MySQL Bugs: #61409: Bogus link in Server Logs tab of WorkBench 5.2.34 CE Rev 7780

Bug #61409	Bogus link in Server Logs tab of WorkBench 5.2.34 CE Rev 7780
Submitted:	5 Jun 2011 1:04	Modified:	5 Jun 2011 16:46
Reporter:	Grayson Churchel	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	5.2.34	OS:	Any (dev.mysql.com/doc/refman/5.1/en/log-tables.html)
Assigned to:		CPU Architecture:	Any
Tags:	Link to web page which doesn't exist

Description:
In a default installation of MySQL WorkBench 5.2.34, if you click on Server Logs under MANAGEMENT it reads: 
Your current Log Destination is set to FILE.
For logs to be viewed within Workbench they must be configured to be sent to TABLE.
This option is only available in MySQL version 5.1 and newer.
Fore more information read http://dev.mysql.com/doc/refman/5.1/en/log-tables.html

That's a bad URL. It doesn't exist. 

I've been digging around in the manuals and I can find nothing about how to set the logs to be sent to a table.

How to repeat:
Install Workbench 5.2.34, open it and click on Server Logs under MANAGEMENT.
Try to follow the URL given (NOTE: you'll have to visually copy the URL because you can't high-light it and copy it with your mouse).

Suggested fix:
Include some useful information or a link to where a user can find useful information on how to set it up so you can view your server's logs.

The link works fine for me and redirects to 
http://dev.mysql.com/doc/refman/5.1/en/log-destinations.html

Peter
(not a MySQL person)

With 5.2.34 I see no problems to copy/paste this URL, and indeed redirection happens to proper manual page, http://dev.mysql.com/doc/refman/5.1/en/log-destinations.html, as Peter noted. So, I see no real bug here.

Quite right. It does re-direct. It was late, I was tired and I didn't see anything on the redirected page telling me how to direct my server logs to a table. 

In the morning light I was able to follow enough links from that page to determine the parameter and value, and where to put it. I edited my my.ini file and added the 'log-output=table' parameter to it. At first the Workbench screen threw an error about the query used:
[Window Title]
MySQL Workbench

[Main Instruction]
Error

[Content]
Unhandled exception: Error fetching log contents: Error executing 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-50, 50' at line 1'
SELECT * FROM mysql.general_log ORDER BY event_time DESC LIMIT -50, 50.
SQL Error: 1064

[OK]

But after I checked the query syntax and clicked around in the Workbench some then returned to that screen I found it working correctly.

Now I just need to find a way to start the service from a command line and from the NetBeans 7.0 IDE.

Grayson

Quite right. It does re-direct. It was late, I was tired and I didn't see anything on the redirected page telling me how to direct my server logs to a table. 

In the morning light I was able to follow enough links from that page to determine the parameter and value, and where to put it. I edited my my.ini file and added the 'log-output=table' parameter to it. At first the Workbench screen threw an error about the query used:
[Window Title]
MySQL Workbench

[Main Instruction]
Error

[Content]
Unhandled exception: Error fetching log contents: Error executing 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-50, 50' at line 1'
SELECT * FROM mysql.general_log ORDER BY event_time DESC LIMIT -50, 50.
SQL Error: 1064

[OK]

But after I checked the query syntax and clicked around in the Workbench some then returned to that screen I found it working correctly.

Now I just need to find a way to start the service from a command line and from the NetBeans 7.0 IDE.

Grayson