Bug #42966 mysql_upgrade fails on netware due to invalid file and path for mysql.nlm
Submitted: 18 Feb 2009 11:48 Modified: 5 Jan 2010 23:36
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:5.0.78 OS:Novell NetWare
Assigned to: Jim Winstead CPU Architecture:Any
Tags: mysql_upgrade

[18 Feb 2009 11:48] Shane Bester
Description:
mysql_upgrade fails with this error on the logger screen:

SERVER-5.70-151: Unable to find load file SYS:\MYSQL\BIN\'MYSQL'
FATAL ERROR: popen("'mysql' '--help' 2>&1 > /dev/null ", "r") failed

The correct path for mysql client is really SYS:\MYSQL\BIN\MYSQL.NLM

How to repeat:
run mysql_upgrade.nlm
or run the mysql_upgrade.test:
[19 Feb 2009 20:12] MySQL Verification Team
The workaround is to not run mysql_upgrade.  dump/reload all tables after major upgrade or manually run check table, and update the `mysql` database structures.
[23 Apr 2009 17:03] Colin Bodkin
I am having this same issue using MySQL version 5.077 on Netware 6.5.
[5 May 2009 17:58] Jim Winstead
This should be relatively straightforward to fix -- all the IF_WIN("mysql.exe", "mysql")-like stuff in mysql_upgrade.c should be changed to TOOL_EXE("mysql") and TOOL_EXE defined as:

#ifdef __WIN__
# define TOOL_EXE(name) name ".exe"
#else
# ifdef __NETWARE__
#  define TOOL_EXE(name) name ".nlm"
# else
#  define TOOL_EXE(name) name
# endif
#endif

There's also a IF_WIN("> NUL", "> /dev/null") that may need a Netware variant.
[5 Jan 2010 23:36] Omer Barnir
Issue is 5.0 specific and standard support for the release ended