[Bug 41339] Re: Mythtv won't install
I upgraded from Edgy to Feisty on Saturday, April 14, 2007 using update- manager (which worked very well until it encountered Myth), and ran into this problem on my previously functional MythTV setup. Now nothing will install via apt/adept without error messages. The most promising solution appeared to be, sudo dpkg-reconfigure mythtv-database, but that presents its own problem. When running that command, I get an error message saying: /usr/sbin/dpkg-reconfigure: mythtv-database is broken or not fully installed Prior to running that command, I had tried uninstalling and reinstalling mythtv-database and mythtv. Removal went okay, but reinstallation caused the root password problem to reappear. Since my web site runs on Wordpress and therefore requires MySQL, I have a pre-existing non- default root password. The mythtv-database installer does not appear to try acquiring the MySQL root password in any form, and so gets stuck. I am using 192.168.1.101 as the MySQL bind address since I want to allow my other networked MythTV front ends to connect to my server, and have allowed remote access to MySQL: grant all privileges on mythconverg.* to 'root'@'192.168.1.101' identified by '[my password]'; flush privileges; mythtv-database attempts to connect to MySQL without a root password in any event. -- Mythtv won't install https://bugs.launchpad.net/bugs/41339 You received this bug notification because you are a member of Ubuntu Bugs, which is a direct subscriber. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 41339] Re: Mythtv won't install
The latest feisty packages now assume no root password during installation (as is the case for a brand new install of myth). This prevents any confusion for the user as to what password to enter. Now for anyone who HAS changed their root password, the package will install, but just require reconfiguration to setup that password. sudo dpkg-reconfigure mythtv-database will handle this ** Changed in: mythtv (Ubuntu) Status: Confirmed = Fix Released -- Mythtv won't install https://bugs.launchpad.net/bugs/41339 You received this bug notification because you are a member of Ubuntu Bugs, which is a direct subscriber. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 41339] Re: Mythtv won't install
Will the user be told they have to reconfigure if there is a root password, or will they have to go searching around for help? Can it just run dpkg-reconfigure mythv-database if there is a root pass? On Thu, 12 Apr 2007 02:35:04 +1000, Mario Limonciello [EMAIL PROTECTED] wrote: The latest feisty packages now assume no root password during installation (as is the case for a brand new install of myth). This prevents any confusion for the user as to what password to enter. Now for anyone who HAS changed their root password, the package will install, but just require reconfiguration to setup that password. sudo dpkg-reconfigure mythtv-database will handle this ** Changed in: mythtv (Ubuntu) Status: Confirmed = Fix Released -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ -- Mythtv won't install https://bugs.launchpad.net/bugs/41339 You received this bug notification because you are a member of Ubuntu Bugs, which is a direct subscriber. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 41339] Re: Mythtv won't install
this solution is good for most users they will have no other mysql applications and have no root password set, it will just work. for more advanced users they will have a root password and will have to figure it out what it is this solution rewards the most common use case and puts the burden on advanced users to handle the more difficult case. -- Mythtv won't install https://bugs.launchpad.net/bugs/41339 You received this bug notification because you are a member of Ubuntu Bugs, which is a direct subscriber. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 41339] Re: Mythtv won't install
A warning should be popped up during installation if the mysql server is not accessible during installation. The user will have to run dpkg-reconfigure mythtv-database in this case. It doesn't automatically pop up because then during upgrades users would receive errors about mysql passwords not working (because mysql server is stopped during an upgrade) and are likely to further muck up things by investigating wrong passwords. On 4/11/07, flaccid [EMAIL PROTECTED] wrote: Will the user be told they have to reconfigure if there is a root password, or will they have to go searching around for help? Can it just run dpkg-reconfigure mythv-database if there is a root pass? On Thu, 12 Apr 2007 02:35:04 +1000, Mario Limonciello [EMAIL PROTECTED] wrote: The latest feisty packages now assume no root password during installation (as is the case for a brand new install of myth). This prevents any confusion for the user as to what password to enter. Now for anyone who HAS changed their root password, the package will install, but just require reconfiguration to setup that password. sudo dpkg-reconfigure mythtv-database will handle this ** Changed in: mythtv (Ubuntu) Status: Confirmed = Fix Released -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ -- Mythtv won't install https://bugs.launchpad.net/bugs/41339 You received this bug notification because you are a direct subscriber of the bug. -- Mario Limonciello [EMAIL PROTECTED] -- Mythtv won't install https://bugs.launchpad.net/bugs/41339 You received this bug notification because you are a member of Ubuntu Bugs, which is a direct subscriber. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 41339] Re: Mythtv won't install
This bug still exists in MythTV today (3.26.07) in Beta 1+ updates. It's a real pain. There's a meta package to setup a complete mythtv backend that should make it simple for a user to configure but actually breaks their system because the mythtv-database package will not configure. Problem: mysql-server is a dependency of mythtv-backend. When mythtv- backend is installed the mysql server is installed, but not configured with a password for the root user. Then mythtv-backend prompts the user for the root's password, but not properly distinguish between the root user's plain old password (which may / may not exist) and the mysql user's password. The user doesn't know what the mysql server password is so they enter their own password or something else and the package fails. Solution: When mythtv-backend or similar meta packages trigger the installation of mysql they need to configure it. A password for the root user should be set and then mythtv-backend should be setup using this password. Otherwise this whole meta-package should go away because as it is the package just breaks systems until you remove mythtv- database or manually setup a password. -- Mythtv won't install https://launchpad.net/bugs/41339 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 41339] Re: Mythtv won't install
well the problem is that mysql has its own little world of usernames and passwords and privileges there are security issues if applications can get mysql root access to easily but i agree it is a bug and needs to be solved somehow, even if we simply provide instructions on how to set a mysql root password for that point of the installation -- Mythtv won't install https://launchpad.net/bugs/41339 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 41339] Re: Mythtv won't install
I was able to change the the root password really simply with mysqladmin -u root -p password (this might be a tiny bit wrong). It just prompts for the new root password at this point. What keeps the package from prompting the user the enter the password using this same method? -- Mythtv won't install https://launchpad.net/bugs/41339 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 41339] Re: Mythtv won't install
yes that is how I did it also the problem is if they are already using applications with mysql, they probably already have a root password set but possibly it could assume there is no root password, set it, and then if that fails ask the user for the root password mysql permissions are extremely capable but very complicated -- Mythtv won't install https://launchpad.net/bugs/41339 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 41339] Re: Mythtv won't install
Unfortunately there are repercussions in either assuming no root password set, or having to ask for one. A note though, the text does clearly point out: Unless you have explicitly changed the password on the MySQL server, leave this blank. Wayne, I think you hit a possible solution right on the head though with regard to trying with no password first and then asking only if need be. I'll see what I can come up with the next few days that implements something to this nature. On 3/27/07, Wayne Schuller [EMAIL PROTECTED] wrote: yes that is how I did it also the problem is if they are already using applications with mysql, they probably already have a root password set but possibly it could assume there is no root password, set it, and then if that fails ask the user for the root password mysql permissions are extremely capable but very complicated -- Mythtv won't install https://launchpad.net/bugs/41339 -- Mario Limonciello [EMAIL PROTECTED] -- Mythtv won't install https://launchpad.net/bugs/41339 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 41339] Re: Mythtv won't install
** Changed in: mythtv (Ubuntu) Assignee: stanwebber = Mario Limonciello -- Mythtv won't install https://launchpad.net/bugs/41339 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 41339] Re: Mythtv won't install
I hit this exact same problem. Today. Jan 6th 2006. It seems you need to have mysql-server preinstalled and preconfigured and already know what your root password is. -- Mythtv won't install https://launchpad.net/bugs/41339 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 41339] Re: Mythtv won't install
Wayne, I had mysql-server preinstalled, preconfigured and it doesn't make a difference. Just wish the bug would get fixed. -- Mythtv won't install https://launchpad.net/bugs/41339 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 41339] Re: Mythtv won't install
Flaccid, I can't exactly follow what the workaround posted above was doing since his site went down. Based on the fact that it is trying to get into the database by a random string of characters, I would bet those characters were the password generated for your mythtv user on the mysql database. During the install of mythtv-database, the information that is used is the username and password stored in /etc/mythtv/mysql.txt. If you have since then changed the information used here in an attempt to resolve the database problem, that would be why you can't properly install mythtv-database. At this point, sudo apt-get -f install or sudo dpkg-reconfigure mythtv-database should complete the install of mythtv-database. If there are permissions problems, the first thing to do is verify that /etc/mythtv/mysql.txt contains the correct information. If the database is already created and has data, edit this file to match the database name, user name, and password. If there are still issues here, and you can login to the database using the mysql command and your database username and password, then we have a problem here. Contact me off this bug, and we will attempt to nail this before edgy release. -- Mythtv won't install https://launchpad.net/bugs/41339 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 41339] Re: Mythtv won't install
Your best bet at this point is to sudo apt-get remove --purge mythtv-database and reinstall it. This should remove any settings that may be making a mockery of your setup. -- Mythtv won't install https://launchpad.net/bugs/41339 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 41339] Re: Mythtv won't install
Mario, then you go back to the start again. This is a bug. -- Mythtv won't install https://launchpad.net/bugs/41339 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 41339] Re: Mythtv won't install
The workaround suggested by stanwebber didn'g work for me. Error is: Failed to execute SQL: GRANT ALL PRIVILEGES ON .* TO @localhost IDENTIFIED BY 'zfcdascr'\nYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* TO @localhost IDENTIFIED BY 'zfcdascr'' at line 1 at -e line 8, line 1. Why is the user zfcdascr coming from? Anyway this is terrible and needs to be fixed by the package I assume. I may create this user to see if I can work around the problem. -- Mythtv won't install https://launchpad.net/bugs/41339 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 41339] Re: Mythtv won't install
Looking at the query anyway: GRANT ALL PRIVILEGES ON .* TO @localhost IDENTIFIED BY 'zfcdascr'; Its obviously missing the database name and user params. eg: GRANT ALL PRIVILEGES ON db_name.* TO [EMAIL PROTECTED] IDENTIFIED BY 'zfcdascr'; or GRANT ALL PRIVILEGES ON db_name.tbl_name TO [EMAIL PROTECTED] IDENTIFIED BY 'zfcdascr'; depending on required scope. Pretty please fix this up or let me know a manual way to edit the script for now. -- Mythtv won't install https://launchpad.net/bugs/41339 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 41339] Re: Mythtv won't install
this page should be of help to you: http://www.abarbaccia.com/content/view/17/32/ i also just stumbled across this site which i haven't looked at closely yet that you might want to check out, parker1.co.uk/mythtv_ubuntu.php Randy-Rhodas writes: thank you for taking time to help me!!! I actualy struggeld so much that I gave up:-( I will try this as soon as my spare-time allows it:-) again Thanks!!! Hope it is ok, if i send you an E-mail if there should apear any other problems. best regards john gunnar. From: stanwebber [EMAIL PROTECTED] Reply-To: Bug 41339 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [Bug 41339] Re: Mythtv won't install Date: Wed, 09 Aug 2006 12:43:21 - ** Changed in: mythtv (Ubuntu) Status: Rejected = Confirmed -- Mythtv won't install https://launchpad.net/bugs/41339 _ MSN Music http://music.msn.no Finn din favorittmusikk blant nesten 1 million låter -- Mythtv won't install https://launchpad.net/bugs/41339 -- Mythtv won't install https://launchpad.net/bugs/41339 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 41339] RE: [Bug 41339] Re: Mythtv won't install
thank you for taking time to help me!!! I actualy struggeld so much that I gave up:-( I will try this as soon as my spare-time allows it:-) again Thanks!!! Hope it is ok, if i send you an E-mail if there should apear any other problems. best regards john gunnar. From: stanwebber [EMAIL PROTECTED] Reply-To: Bug 41339 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [Bug 41339] Re: Mythtv won't install Date: Wed, 09 Aug 2006 12:43:21 - ** Changed in: mythtv (Ubuntu) Status: Rejected = Confirmed -- Mythtv won't install https://launchpad.net/bugs/41339 _ MSN Music http://music.msn.no Finn din favorittmusikk blant nesten 1 million låter -- Mythtv won't install https://launchpad.net/bugs/41339 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 41339] Re: Mythtv won't install
i ran into this exact same sequence. the problem occurs when mysql- server is installed as a dependancy of mythtv instead of being setup (with accounts passwords) ahead of time. i fixed my install by assigning a mysql root password, reconfiguring mythtv-database to use that password finally reinstalling mythtv: mysql -u root mysql mysql UPDATE user SET Password=PASSWORD('YourPasswordHere') WHERE user='root'; mysql FLUSH PRIVILEGES; mysql quit dpkg-reconfigure --force mythtv-database apt-get install mythtv ** Changed in: mythtv (Ubuntu) Assignee: (unassigned) = stanwebber Status: Unconfirmed = Rejected -- Mythtv won't install https://launchpad.net/bugs/41339 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 41339] Re: Mythtv won't install
** Changed in: mythtv (Ubuntu) Status: Rejected = Confirmed -- Mythtv won't install https://launchpad.net/bugs/41339 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs