AUSCERT External Security Bulletin Redistribution

                     SSRT3645 (Rev. 1) MySQL in SCM3.0
                              31 October 2003


        AusCERT Security Bulletin Summary

Product:                MySQL (a component of Servicecontrol Manager)
Publisher:              Hewlett-Packard
Operating System:       HP-UX 11.11
                        HP-UX 11.00
Platform:               HP9000 Series 700/800
Impact:                 Execute Arbitrary Code/Commands

Ref:                    ESB-2003.0709

- --------------------------BEGIN INCLUDED TEXT--------------------

Hash: SHA1

 **REVISED 01**
 Originally issued: 7 October 2003
 Last updated: 29 October 2003
 SSRT3645 (Rev. 1) MySQL in SCM3.0
NOTICE: There are no restrictions for distribution of this
Bulletin provided that it remains complete and intact.

The information in the following Security Bulletin should be
acted upon as soon as possible.  Hewlett-Packard Company will
not be liable for any consequences to any customer resulting
from customer's failure to fully implement instructions in this
Security Bulletin as soon as possible.


PROBLEM:  MySQL version 3.23.39, which is delivered with
          Servicecontrol Manager (SCM) 3.0, has potential
          security vulnerabilities.

IMPACT:   Unauthorized access, increase in privilege or execution
          of arbitrary code.

PLATFORM: HP 9000 servers running HP-UX B.11.00 and B.11.11 only.

SOLUTION: Update the SCM central management server to use ixMySQL
          version 3.23.54 which is released by the HP Internet
          Express group.  (See below).
          Install ixMySQL version 3.23.54 or subsequent and
          configure the SCM central management server to use

   Note:  This fix is only available if you are running
          SCM 3.0 or later.  Earlier versions of SCM
          must be upgraded prior to applying this fix.

MANUAL ACTIONS:  Yes - NonUpdate

AVAILABILITY:  The solution is included herein.

CHANGE SUMMARY: Rev. 01 Clarified source for ixMySQL.

**REVISED 01**
 A. Background
    Any version of Servicecontrol Manager (SCM) 3.0 (such as
    B.03.00.01) was shipped with a version of MySQL (3.23.39)
    which contains security defects.

    For more information, see:

    SCM 2.5 uses LDAP and is therefore unaffected by this issue.
    Systems using SCM 2.5 that were upgraded to B.03.00.00,
    B.03.00.01, B.03.00.02, B.03.00.03, or B.03.00.04 need to be
    upgraded further on any HP-UX B.11.00 or B.11.11 platform.
    Sytems running SCM 3.0 on HP-UX B.11.23 are not affected, as
    they use ixMySQL.

 -->A new version of ixMySQL can be now downloaded from:
 --> http://software.hp.com/portal/swdepot/displayProductInfo.do?

    The following is a list by HP-UX revision of
    affected filesets or patches and fix information.
    To determine if a system has an affected version,
    search the output of "swlist -a revision -l fileset"
    for an affected fileset or patch, then determine if
    a fixed revision or applicable patch is installed.

    HP-UX B.11.00
    HP-UX B.11.11
    fix: install ixMySQL revision 3.23.54 or subsequent, and
         configure the SCM central management server to use


    NOTE: This problem does not impact HP NonStop Servers nor
          HP OpenVMS, nor HP Tru64 UNIX/Trucluster Server.

 B. Recommended solution
    If you are installing SCM 3.0 on a central management server
    for the first time, follow these installation instructions:

  1.  If SCM 3.0 is not B.03.00.01 or later, download the latest
      version on the Web at:
  2.  Install SCM:
        swinstall -s SCM3.0.x_depot -x reinstall=true B8339BA
  3.  Remove MySQL 3.23.39:
        swremove MySQL
  4.  After MySQL is removed, check if the mysqld daemon is
      still running:
        ps -ef | grep mysqld
      The mysqld daemon should not still be running.  If it is,
      stop it with:
        kill -9 <PIDofmysqld>
  5.  Install the new ixMySQL
      On HP-UX B.11.11
        swinstall -s ix_MySQL_depot ixMySQL
      On HP-UX B.11.00:
        swinstall -s depot -x allow_incompatible=true ixMySQL
        swconfig -x allow_incompatible=true ixMySQL
  6.  Configure SCM 3.0 to run with ixMySQL:
        /opt/mx/bin/mxinitconfig -a server

     If you need to update an existing central management server
     running SCM 3.0 with MySQL 3.23.39, follow these

  1.  Verify the version of SCM 3.0 (B8339BA):
        swlist B8339BA
      Note: Only B8339BA, B.03.00.01 or later is compatible
            with ixMySQL.  If you have B8339BA, B.03.00.00
            installed, you need to upgrade to B.03.00.01
            version or later and then complete this
  2.  Backup the SCM database to a file in a secure directory:
        /opt/mx/bin/mxrepositorysave -f $SAFEDIR/scm30save
  3.  Verify the backup file:
        ls -l $SAFEDIR/scm30save
  4.  Backup the MySQL files:
        tar cvf $SAFEDIR/mysql_files.tar /var/opt/mysq/mxcoredb/.
  5.  If the version of SCM is not B.03.00.01 or later, upgrade
      to the latest version of SCM.
    a.  Download the latest version on the Web at:
    b.  Update SCM to the latest version:
          swinstall -s SCM3.0.x_depot -x reinstall=true B8339BA
  6.  Stop SCM daemons:
        /sbin/init.d/ServCtlMgr stop server
  7.  Remove MySQL 3.23.39:
        swremove MySQL
  8.  After MySQL is removed, check if the mysqld daemon is still
        ps -ef | grep mysqld
      The mysqld daemon should not still be running.  If it is,
      stop it with:
        kill -9 <PIDofMySQL>
  9.  Install ixMySQL.
      On HP-UX B.11.11
        swinstall -s ix_MySQL_depot ixMySQL
      On HP-UX B.11.00:
        swinstall -s depot -x allow_incompatible=true ixMySQL
        swconfig -x allow_incompatible=true ixMySQL
 10.  Configure SCM 3.0 to run with ixMySQL:
        /opt/mx/lbin/mxconfigrepo -a -F
 11.  Restore the SCM 3.0 data:
        /opt/mx/bin/mxrepositoryrestore -f $SAFEDIR/scm30save
 12.  Run SCM 3.0 with ixMySQL:
        /opt/mx/bin/mxinitconfig -a server

 C. To subscribe to automatically receive future NEW HP Security
    Bulletins from the HP IT Resource Center via electronic
    mail, do the following:

    Use your browser to get to the HP IT Resource Center page


    Use the 'Login' tab at the left side of the screen to login
    using your ID and password.  Use your existing login or the
    "Register" button at the left to create a login, in order to
    gain access to many areas of the ITRC.  Remember to save the
    User ID assigned to you, and your password.

    In the left most frame select "Maintenance and Support".

    Under the "Notifications" section (near the bottom of
    the page), select "Support Information Digests".

    To -subscribe- to future HP Security Bulletins or other
    Technical Digests, click the check box (in the left column)
    for the appropriate digest and then click the "Update
    Subscriptions" button at the bottom of the page.


    To -review- bulletins already released, select the link
    (in the middle column) for the appropriate digest.

    NOTE: Using your itrc account security bulletins can be
          found here:

    To -gain access- to the Security Patch Matrix, select
    the link for "The Security Bulletins Archive".  (near the
    bottom of the page)  Once in the archive the third link is
    to the current Security Patch Matrix. Updated daily, this
    matrix categorizes security patches by platform/OS release,
    and by bulletin topic.  Security Patch Check completely
    automates the process of reviewing the patch matrix for
    11.XX systems.  Please note that installing the patches
    listed in the Security Patch Matrix will completely
    implement a security bulletin _only_ if the MANUAL ACTIONS
    field specifies "No."

    The Security Patch Check tool can verify that a security
    bulletin has been implemented on HP-UX 11.XX systems providing
    that the fix is completely implemented in a patch with no
    manual actions required.  The Security Patch Check tool cannot
    verify fixes implemented via a product upgrade.

    For information on the Security Patch Check tool, see:

    The security patch matrix is also available via anonymous


    On the "Support Information Digest Main" page:
    click on the "HP Security Bulletin Archive".

    The PGP key used to sign this bulletin is available from
    several PGP Public Key servers.  The key identification
    information is:

       HP Security Response Team (Security Bulletin signing only)
       Fingerprint =
         6002 6019 BFC1 BC62 F079 862E E01F 3AFC 2D2A 7D59

    If you have problems locating the key please write to
    security-alert@hp.com.  Please note that this key is
    for signing bulletins only and is not the key returned
    by sending 'get key' to security-alert@hp.com.

 D. To report new security vulnerabilities, send email to


    Please encrypt any exploit information using the
    security-alert PGP key, available from your local key
    server, or by sending a message with a -subject- (not body)
    of 'get key' (no quotes) to security-alert@hp.com.


(c)Copyright 2003 Hewlett-Packard Company
Hewlett-Packard Company shall not be liable for technical or
editorial errors or omissions contained herein. The information
in this document is subject to change without notice.
Hewlett-Packard Company and the names of HP products referenced
herein are trademarks and/or service marks of Hewlett-Packard
Company.  Other product and company names mentioned herein may be
trademarks and/or service marks of their respective owners.

- - --

Version: PGP 8.0


- --------------------------END INCLUDED TEXT--------------------

You have received this e-mail bulletin as a result of your organisation's
registration with AusCERT. The mailing list you are subscribed to is
maintained within your organisation, so if you do not wish to continue
receiving these bulletins you should contact your local IT manager. If
you do not know who that is, please send an email to auscert@auscert.org.au
and we will forward your request to the appropriate person.

This security bulletin is provided as a service to AusCERT's members.  As
AusCERT did not write the document quoted above, AusCERT has had no control
over its content. The decision to follow or act on information or advice
contained in this security bulletin is the responsibility of each user or
organisation, and should be considered in accordance with your organisation's
site policies and procedures. AusCERT takes no responsibility for consequences
which may arise from following or acting on information or advice contained in
this security bulletin.

NOTE: This is only the original release of the security bulletin.  It may
not be updated when updates to the original are made.  If downloading at
a later date, it is recommended that the bulletin is retrieved directly
from the author's website to ensure that the information is still current.

Contact information for the authors of the original document is included
in the Security Bulletin above.  If you have any questions or need further
information, please contact them directly.

Previous advisories and external security bulletins can be retrieved from:


If you believe that your computer system has been compromised or attacked in 
any way, we encourage you to let us know by completing the secure National IT 
Incident Reporting Form at:


Internet Email: auscert@auscert.org.au
Facsimile:      (07) 3365 7031
Telephone:      (07) 3365 4417 (International: +61 7 3365 4417)
                AusCERT personnel answer during Queensland business 
                hours which are GMT+10:00 (AEST).  On call after hours 
                for member emergencies only.
Comment: http://www.auscert.org.au/render.html?it=1967