MySQL Bugs: #59395: Error: 2059 (CR_AUTH_PLUGIN_CANNOT

Bug #59395	Error: 2059 (CR_AUTH_PLUGIN_CANNOT_LOAD) not generic
Submitted:	10 Jan 2011 15:27	Modified:	20 Jan 2011 12:19
Reporter:	Ulf Wendel	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: General	Severity:	S3 (Non-critical)
Version:	5.5	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
The MySQL 5.5 reference manual lists client error 2059:

Error: 2059 (CR_AUTH_PLUGIN_CANNOT_LOAD)
Message: Authentication plugin '%s' cannot be loaded: %s 

Connector/C 6.0.3 is using 2059 if loading of the CTA/MEM plugin fails. C/C 6.0.3 understands the error in a generic way: loading of *any* plugin has failed. There can be several messages accomplishing 2059. None of them is "Authentication plugin '%s' cannot be loaded: %s"

The mismatch is confusing.

There should be either a distinct error code for every possible plugin or a generic CR_PLUGIN_CANNOT_LOAD code. Using distinct error codes for every possible plugin may be a bit too much because one cannot foresee which plugins the community might provide in the future and those potential community plugins should not try to occupy/invent new error codes. 

How to repeat:
Check manual and C/C 6.0.3 source.

Suggested fix:
Add 2060/CR_PLUGIN_CANNOT_LOAD or change 2059 to CR_PLUGIN_CANNOT_LOAD.

Thank you for the report.

Verified as described. At least additional generic error for any plugin should be created.