[Devel] [ openser-Bugs-1617085 ] Solaris openser_mysql.sh script error

[SourceForge.net]

Bugs item #1617085, was opened at 2006-12-16 17:31
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1617085&group_id=139143

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: core
Group: ver devel
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Samwise (samwiseuk)
Assigned to: Nobody/Anonymous (nobody)
Summary: Solaris openser_mysql.sh script error

Initial Comment:
The db_charset_test() function in:

/usr/local/sbin/openser_mysql.sh

does not work correctly with Solaris 9/04.

I think this will be true across other releases of Solaris as well because I think the script errors are due to the script not yet having been tested under Solaris.

I was able to get the database tables created by removing the E argument from grep on line 240:

ALLCHARSETS=`echo "show character set" | $CMD "-p$PW" | awk '{print $1}' | sed -e 1d | grep -iv

and by splitting the variable definition on line 252, over two lines:

CHARSET=$CURRCHARSET
export CHARSET

I'm not an expert shell scripter, though, and these were hacks I made rather than thoroughly understanding what the script was attempting to do.

This was discovered with the latest HEAD branch checked
out from CVS.  This was not a problem with the rel_1_1_0 branch last time I checked it out, so it only affects the development version, AFAICT.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1617085&group_id=139143