Results 1 to 8 of 8

Thread: Failure to Connect to Database

  1. #1
    Join Date
    Feb 2006
    Location
    Melbourne, Australia
    Beans
    24
    Distro
    Ubuntu 9.10 Karmic Koala

    Failure to Connect to Database

    I have a version of 7.10 running off a USB harddrive. Recently I tied to enable other front-end machines to access it so I ran
    Code:
    sudo dpkg-reconfigure mythtv-database
    I left everything the same accept for allowing other front ends. Since then I have unable to run the front end or mythtv-setup. Each time it goes into database configuration. If I try to run dpkg-reconfigure mythtv-database all the settings appear correct but when I finish I get the warning
    Code:
    Failed to connect to database: Access denied for user 'root'@'localhost' (using 
    password: YES) at -e line 5, <> line 1.
    Failed to create database (incorrect admin username/password?)
    It's possible the mysql-server wasn't running. After install is
     completed, you will need to make sure mysql-server is running
     and that you supplied the correct information. Try:
    sudo dpkg-reconfigure mythtv-database
    Password for root is blank as recommended.

    I have obviously done something wrong. Can I correct it or do I need to reinstall.

  2. #2
    Join Date
    Feb 2006
    Location
    Melbourne, Australia
    Beans
    24
    Distro
    Ubuntu 9.10 Karmic Koala

    Re: Failure to Connect to Database

    Anyone??

  3. #3
    Join Date
    Feb 2006
    Location
    Melbourne, Australia
    Beans
    24
    Distro
    Ubuntu 9.10 Karmic Koala

    Re: Failure to Connect to Database

    Silence.

    Looks like it's a re-install.

  4. #4
    Join Date
    Oct 2005
    Location
    Austin, TX
    Beans
    2,983
    Distro
    Ubuntu Development Release

    Re: Failure to Connect to Database

    Quote Originally Posted by nicom View Post
    I have a version of 7.10 running off a USB harddrive. Recently I tied to enable other front-end machines to access it so I ran
    Code:
    sudo dpkg-reconfigure mythtv-database
    I left everything the same accept for allowing other front ends. Since then I have unable to run the front end or mythtv-setup. Each time it goes into database configuration. If I try to run dpkg-reconfigure mythtv-database all the settings appear correct but when I finish I get the warning
    Code:
    Failed to connect to database: Access denied for user 'root'@'localhost' (using 
    password: YES) at -e line 5, <> line 1.
    Failed to create database (incorrect admin username/password?)
    It's possible the mysql-server wasn't running. After install is
     completed, you will need to make sure mysql-server is running
     and that you supplied the correct information. Try:
    sudo dpkg-reconfigure mythtv-database
    Password for root is blank as recommended.

    I have obviously done something wrong. Can I correct it or do I need to reinstall.
    If at some point you put a password for root, it has a hard time resetting itself to blank.

    Try setting a root password and then using that in the reconfigure

  5. #5
    Join Date
    Feb 2006
    Location
    Melbourne, Australia
    Beans
    24
    Distro
    Ubuntu 9.10 Karmic Koala

    Re: Failure to Connect to Database

    Thanks for the suggestion but no joy.

  6. #6
    Join Date
    Feb 2006
    Location
    Melbourne, Australia
    Beans
    24
    Distro
    Ubuntu 9.10 Karmic Koala

    Re: Failure to Connect to Database

    Well I gave up and reinstalled Mythbuntu onto the USB hard disk and got it working again. Since the purpose of my investigation is to try and get a remote front end working I then ran "sudo dpkg-reconfigure mythtv-database" but I just accepted all the default entries, ie no change. It returned to the command line succesfully when complete. However now each time I try to start the local front end it goes into the database configuration which finishes correctly when all pages are complete but still the front end does not start. It seems running "sudo dpkg-reconfigure mythtv-database" has broken it again for me.

    Has anyone else had this problem?

  7. #7
    Join Date
    Jul 2007
    Beans
    2

    Re: Failure to Connect to Database


  8. #8
    Join Date
    Feb 2006
    Location
    Melbourne, Australia
    Beans
    24
    Distro
    Ubuntu 9.10 Karmic Koala

    Re: [SOLVED] Failure to Connect to Database

    Thanks for that link. It was the
    Code:
    sudo dpkg-reconfigure mythtv-common
    step I was missing. Now it reconnects.
    Last edited by nicom; July 29th, 2008 at 09:02 AM. Reason: Solved

Bookmarks

Posting Permissions

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