[ha-clusters-discuss] SC3.2 + MySQL

[Detlef Ulherr]

 Hi Robert,

I am currently in the process of creating the fix amongst others.
Unfortunately there is no timeline yet, when the fix will be available..

Detlef

Robert Milkowski wrote:
> Hi,
>
> Here's a copy&paste from SR #38047079 I've just raised.
> I don't know if it's still the issue in latest development bits.
>
> Pair of x4150, S10U4 + patches, Sun Cluster 3.2, SE 2530
>
> We set-up a MySQL under SC3.2 using provided MySQL agent.
>
> We're using MySQL 5.0.51a and that version number is causing a problem with mysql registration in suin cluster (because of tha 'a' in version number)
> root at mk-msh-1[tmp] /opt/SUNWscmys/util/ha_mysql_register -f /home/milek/tmp/ha_mysql_config 
> sourcing /home/milek/tmp/ha_mysql_config and create a working copy under /opt/SUNWscmys/util/ha_mysql_config.work
> mk-msh-1 - /opt/SUNWscmys/bin/control_mysql[84]: 51a: bad number
>
> Registration of resource rs-mysql-master succeeded.
>  remove the working copy /opt/SUNWscmys/util/ha_mysql_config.work
> root at mk-msh-1[tmp] 
>
> As you can see above there's a problem in line 84 of control_mysql script.
>
> In that line there's: . ${MYDIR}/functions
>
> After inspecting functions file I found the problem - here's a workaroung:
> root at mk-msh-1[tmp] diff -u /opt/SUNWscmys/bin/functions.orig /opt/SUNWscmys/bin/functions
> --- /opt/SUNWscmys/bin/functions.orig   Mon Feb 18 12:39:26 2008
> +++ /opt/SUNWscmys/bin/functions        Mon Feb 18 12:42:05 2008
> @@ -336,7 +336,7 @@
>                         "Validate - Couldn't retrieve MySQL version number"
>                 rc_validate=1
>  
> -       elif [ "${MYSQL_VERSION}" -lt 3 -a "${MYSQL_RELEASE}" -lt 23 -a "${MYSQL_UPDATE}" -lt 54 ]
> +       elif [ "${MYSQL_VERSION}" -lt 3 -a "${MYSQL_RELEASE}" -lt 23 ]
>         then 
>                 # SCMSGS
>                 # @explanation
> root at mk-msh-1[tmp] 
>
> so the problem is that scripts checkes if "${MYSQL_UPDATE}" -lt 54
>
> but since MYSQL_UPDATE will be 51a it will fail here.
>
> The workaround is completely fine if you're using version 5.x - I suggest to do nested checking - so first to check if it's version 3, and then check subversions - that way it should be fine with recent versions.
>
> I don't need any patch this time - just letting you know so it will be hopefully corrected.
>
>
>   

-- 

*****************************************************************************
 Detlef Ulherr
 Staff Engineer                     		Tel: (++49 6103) 752-248
 Availability Engineering			Fax: (++49 6103) 752-167
 Sun Microsystems GmbH             
 Amperestraße 6                    		mailto:detlef.ulherr at sun.com
 63225 Langen                        		http://www.sun.de/
*****************************************************************************

Sitz der Gesellschaft: Sun Microsystems GmbH, Sonnenallee 1, D-85551
Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB 161028
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering

*****************************************************************************