Results 1 to 7 of 7

Thread: MySQL 5.0 to 5.1 upgrade failure

  1. #1
    davidm777 NNTP User

    Default MySQL 5.0 to 5.1 upgrade failure

    Running a Suse L.A.M.P. stack:
    - Linux: openSUSE 10.3
    - Apache 2.2.11
    - MySQL 5.0.45
    - PHP 5.2.9

    Yast->Software Management informed me that I could upgrade MySQL from 5.0.45 to 5.1.33. Nice, I thought.

    Ran the upgrade, rebooted, and lost most points-of-access to MySQL. In Yast -> System -> System Services, MySQL is listed as enabled=Yes* (Simple Mode) and running=No (Expert Mode). Starting the service from here didn't work (says it starts, but nothing works)

    '/etc/init.d/mysql start' states 'started' (when run as root, didn't try as a user)

    Using MySQL Administrator or Query Browser fails to access MySQL at all. Any PHP-MySQL page fails to access the database.

    However, I CAN run 'mysql -u root -p' from the command line and get in, poke around, etc. No access problems here (unless, of course, I run '/etc/init.d/mysql stop').

    I tried running 'mysql_upgrade' and 'mysql_fix_*' only to get access-related errors.

    Most error messages cycle around "Access denied for... (using password = NO)".

    Totally lost,
    David

  2. #2

    Default Re: MySQL 5.0 to 5.1 upgrade failure

    Quote Originally Posted by davidm777 View Post
    Running a Suse L.A.M.P. stack:
    - Linux: openSUSE 10.3
    - Apache 2.2.11
    - MySQL 5.0.45
    - PHP 5.2.9

    Yast->Software Management informed me that I could upgrade MySQL from 5.0.45 to 5.1.33. Nice, I thought.
    No, not nice, because there is certainly no officially supported version for 10.3.

    So whatever you installed is not supported and using such stuff on a productive server machine is not recommended.

  3. #3
    davidm777 NNTP User

    Default Re: MySQL 5.0 to 5.1 upgrade failure

    The package is coming from:
    Index of /repositories/server:/database/openSUSE_10.3

    I was assuming it is fine to use this repository... should I not be using it?

    or is this more down the road of a bug? or does this happen when going from 5.0 to 5.1 and I need to (re)configure my system?

    Thanks for the quick reply!
    David

  4. #4

    Default Re: MySQL 5.0 to 5.1 upgrade failure

    No, this is not an official repository.

    If you suspect a bug, file a bug report with complete information (version, logs and error messages) here:

    https://bugzilla.novell.com

  5. #5
    Kevin Miller NNTP User

    Default Re: MySQL 5.0 to 5.1 upgrade failure

    Akoellh wrote:
    > No, this is not an official repository.
    >
    > If you suspect a bug, file a bug report with complete information
    > (version, logs and error messages) here:
    >
    > https://bugzilla.novell.com


    So how does one distinguish an "official" repository, especially when
    they're on the opensuse.org site? How can one know what's actually safe
    to install and in what repositories 'Thar be dragons'...

    --
    Kevin Miller
    Juneau, Alaska
    http://www.alaska.net/~atftb
    In a recent poll, seven out of ten hard drives preferred Linux.

  6. #6

    Default Re: MySQL 5.0 to 5.1 upgrade failure


  7. #7
    Kevin Miller NNTP User

    Default Re: MySQL 5.0 to 5.1 upgrade failure

    Akoellh wrote:
    > Very simple.
    >
    > 'Package Repositories - openSUSE'
    > (http://en.opensuse.org/Package_Repositories)


    Thanks. Multiple repositories are a bit of a mixed blessing. Lots more
    packages to choose from, but sometimes they cause weird dependency
    issues. I pared it down to the official ones...

    ....Kevin
    --
    Kevin Miller
    Juneau, Alaska
    http://www.alaska.net/~atftb
    In a recent poll, seven out of ten hard drives preferred Linux.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •