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
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
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
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
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
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:
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
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
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
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
** 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
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
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
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
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
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
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 '*
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]
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
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
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
** 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
22 matches
Mail list logo