Mailing List Archive: MythTV: Users

Re: Ubuntu/Mythbuntu update problem

Index | Next | Previous | View Threaded

nicks272 at yahoo

May 17, 2012, 4:10 AM

Post #1 of 14 (1222 views)
Permalink

Re: Ubuntu/Mythbuntu update problem

I recently did a fresh install of Mythbuntu 12.04 64-bit. The first time I ran the system updates they failed part-way through and left the system in an inconsistent state. After a hard-disk surface scan and a memory test to rule out those underlying hardware issues, I've since wiped, re-installed and done the updates (including MythTV 0.25) and the system's working fine.

It could be that your failed power supply did some damage to your hardware so it'd be worth doing a memory test and hard-disk scan to check that out (see the "faulty RAM" and "Failing disk" sections at https://help.ubuntu.com/community/FaultyHardware ). Also, given "two completely different 64-bit systems", be sure you've verified the integrity of your downloaded install image (check the md5sum of the downloaded file and the CD you burnt - see https://help.ubuntu.com/community/HowToMD5SUM ) before doing a fresh install.

That should at least help to eliminate some of the possible background causes of some errors.

Nick

myth at surr

May 17, 2012, 12:13 PM

Post #2 of 14 (1178 views)
Permalink

Re: Ubuntu/Mythbuntu update problem [In reply to]

On 17/05/2012 12:10, NickS wrote:
> I recently did a fresh install of Mythbuntu 12.04 64-bit. The first
> time I ran the system updates they failed part-way through and left
> the system in an inconsistent state. After a hard-disk surface scan
> and a memory test to rule out those underlying hardware issues, I've
> since wiped, re-installed and done the updates (including MythTV 0.25)
> and the system's working fine.
>
> It could be that your failed power supply did some damage to your
> hardware so it'd be worth doing a memory test and hard-disk scan to
> check that out (see the "faulty RAM" and "Failing disk" sections at
> https://help.ubuntu.com/community/FaultyHardware ). Also, given "two
> completely different 64-bit systems", be sure you've verified the
> integrity of your downloaded install image (check the md5sum of the
> downloaded file and the CD you burnt - see
> https://help.ubuntu.com/community/HowToMD5SUM ) before doing a fresh
> install.
>
> That should at least help to eliminate some of the possible background
> causes of some errors.
>
> Nick
Hello all,

Thanks for your help. I'm gutted to hear that the only suggestion seems
to be formatting the hard drive and starting again! Is that really my
only option?

I'd be surprised if the issue was with 64 bit version of Ubuntu as I've
been running it, through different versions, for years now.

I can't bare the thought of backing up the database and restoring it
after restarting, mainly because the database always seems to be the
thing that stings me badly!

However, if that's my only option, is there a good simple (by simple, I
mean GUI based would be awesome!) guide anywhere that tells me how to do
that on a Mythbuntu system? Also, is the databse already compromised by
the fact that I was running 0.24 fine on Ubuntu 11.10, but haven't been
able to access any part of it since 'upgrading' to 0.25 on 12.04?

Looking forward to any tips .. and dreading the procedure :-)

Thanks
Damian
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-users

keemllib at gmail

May 17, 2012, 3:05 PM

Post #3 of 14 (1177 views)
Permalink

Re: Ubuntu/Mythbuntu update problem [In reply to]

On 05/17/2012 02:13 PM, Damian wrote:
...
> I can't bare the thought of backing up the database and restoring it after restarting,
> mainly because the database always seems to be the thing
> that stings me badly!

I suggest the following error is what needs to be concentrated on.

sudo mythbackend -v most --user mythtv --nodblog

mythbackend: symbol lookup error: /usr/lib/x86_64-linux-gnu/libva-x11.so.1:
undefined symbol: fool_postp

Please do this (its slightly different than what I asked you off-list:)

dpkg -l libva-x11-1

and post the response here.

Remembering that the backend won't run, the output of this too:

strings `locate -b '\mythbackend'` | grep '0.2[3-5]'

--
Bill
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-users

myth at surr

May 17, 2012, 3:16 PM

Post #4 of 14 (1204 views)
Permalink

Re: Ubuntu/Mythbuntu update problem [In reply to]

On 17/05/2012 23:05, Bill Meek wrote:
> On 05/17/2012 02:13 PM, Damian wrote:
> ...
>> I can't bare the thought of backing up the database and restoring it
>> after restarting,
> > mainly because the database always seems to be the thing
>> that stings me badly!
>
> I suggest the following error is what needs to be concentrated on.
>
> sudo mythbackend -v most --user mythtv --nodblog
>
> mythbackend: symbol lookup error:
> /usr/lib/x86_64-linux-gnu/libva-x11.so.1:
> undefined symbol: fool_postp
>
> Please do this (its slightly different than what I asked you off-list:)
>
> dpkg -l libva-x11-1
>
> and post the response here.
Hi Bill,

Here's the response to that command:

$ dpkg -l libva-x11-1
dpkg-query: warning: parsing file '/var/lib/dpkg/status' near line 77904
package 'virtualbox-3.0':
error in Version string '3.0.14-58977_Ubuntu_karmic': invalid
character in revision number
dpkg-query: warning: parsing file '/var/lib/dpkg/status' near line 77905
package 'virtualbox-3.0':
error in Config-Version string '3.0.14-58977_Ubuntu_karmic': invalid
character in revision number
dpkg-query: warning: parsing file '/var/lib/dpkg/available' near line
84640 package 'virtualbox-3.0':
error in Version string '3.0.14-58977_Ubuntu_karmic': invalid
character in revision number
Desired=Unknown/Install/Remove/Purge/Hold
|
Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name Version Description
+++-==============-==============-============================================
ii libva-x11-1 1.0.15-4 Video Acceleration (VA) API for Linux
-- X11

>
> Remembering that the backend won't run, the output of this too:
>
> strings `locate -b '\mythbackend'` | grep '0.2[3-5]'

libmythtv-0.25.so.0
libmythupnp-0.25.so.0
libmythbase-0.25.so.0
libmyth-0.25.so.0
libmythmetadata-0.25.so.0
libmythservicecontracts-0.25.so.0
0.25.20120506-1
fixes/0.25
v0.25-84-g9ccfac1

Does that get us any closer?
Damian
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-users

keemllib at gmail

May 17, 2012, 5:55 PM

Post #5 of 14 (1171 views)
Permalink

Re: Ubuntu/Mythbuntu update problem [In reply to]

On 05/17/2012 05:16 PM, Damian wrote:
...
> Here's the response to that command:
>
> $ dpkg -l libva-x11-1
> dpkg-query: warning: parsing file '/var/lib/dpkg/status' near line 77904 package 'virtualbox-3.0':
> error in Version string '3.0.14-58977_Ubuntu_karmic': invalid character in revision number
...
> ii libva-x11-1 1.0.15-4 Video Acceleration (VA) API for Linux -- X11
...
> strings `locate -b '\mythbackend'` | grep '0.2[3-5]'
...
> v0.25-84-g9ccfac1
>
> Does that get us any closer?

Sorry, no. The version of libva-x11-1 matches mine and the
backend at least has the v0.25-84... line.

At the very least, your status files looks stomped on. That gets
back to you original post of a failed (partial) upgrade. I did
google and see this if you want to try:

http://ubuntuforums.org/showpost.php?s=4b6cd598b367c4c5bfdc1961f2e61c4e&p=10226999&postcount=2

One more question:

Are you running a virtual machine (virtualbox 3.0)?

If you're in danger of losing your family, then since the root cause of
the problem isn't known yet (disk failure/upgrade failure/high tides)
then, yes I agree a fresh install is looking much quicker.

--
Bill
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-users

myth at surr

May 20, 2012, 11:15 AM

Post #6 of 14 (1135 views)
Permalink

Re: Ubuntu/Mythbuntu update problem [In reply to]

On 18/05/2012 01:55, Bill Meek wrote:
> On 05/17/2012 05:16 PM, Damian wrote:
> ...
>> Here's the response to that command:
>>
>> $ dpkg -l libva-x11-1
>> dpkg-query: warning: parsing file '/var/lib/dpkg/status' near line
>> 77904 package 'virtualbox-3.0':
>> error in Version string '3.0.14-58977_Ubuntu_karmic': invalid
>> character in revision number
> ...
>> ii libva-x11-1 1.0.15-4 Video Acceleration (VA) API for Linux -- X11
> ...
>> strings `locate -b '\mythbackend'` | grep '0.2[3-5]'
> ...
>> v0.25-84-g9ccfac1
>>
>> Does that get us any closer?
>
> Sorry, no. The version of libva-x11-1 matches mine and the
> backend at least has the v0.25-84... line.
>
> At the very least, your status files looks stomped on. That gets
> back to you original post of a failed (partial) upgrade. I did
> google and see this if you want to try:
>
> http://ubuntuforums.org/showpost.php?s=4b6cd598b367c4c5bfdc1961f2e61c4e&p=10226999&postcount=2
>
>
> One more question:
>
> Are you running a virtual machine (virtualbox 3.0)?
>
> If you're in danger of losing your family, then since the root cause of
> the problem isn't known yet (disk failure/upgrade failure/high tides)
> then, yes I agree a fresh install is looking much quicker.
>

Hello again all,

So, I bit the bullet today and installed Mythbuntu 12.04. I wiped my /
and /home partitions and kept all of the recordings and video files
where they live on another drive.

I now have a clean Mythbuntu 12.04 install. It's all new to me because I
have previously used Ubuntu and added Mythbuntu on top. However, as I
don't like Unity and ended up installing Gnome anyway, I thought I'd
give pure Mythbuntu a try.

Before I wiped my last installation, I backed up the database as well as
I could. I'm concerned that I have no idea of knowing what state this is
in. I know it was all working in 0.24, but nothing has worked since I
tried to go to 0.25. Will the database be in a 0.24 type format or a 0.25??

Anyway, I did a full backup of mythconverge using phpmyadmin. I also did
a second backup using:

mysqldump -u mythtv -pmythtv mythconverg -c > mythtv_backup.sql

Now the fun beggins. Can I shoe horn the old database into this new system?

Problem1 .. The mysql root database password?

What is it when in a clean 12.04 install?

mysql -u root
is returning:
damian [at] mythbo:~$ mysql -u root
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)

and a simple 'enter' doesn't work if I try:
mysql -u root -p

I'm also concerned that there maybe some hardware issue still going on.
Obviously replacing the power supply was a big problem, but I've just
tried to install phpmyadmin via Ubuntu Software Centre and it seems to
have hung. Is XFCE not good at multitasking or something?

Looking forward to any tips on the password and hoping the rest of the
machine is actually ok.

Hope to get to the bottom of all of this one day!!

Cheers
Damian
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-users

myth at surr

May 20, 2012, 11:55 AM

Post #7 of 14 (1136 views)
Permalink

Re: Ubuntu/Mythbuntu update problem [In reply to]

On 20/05/2012 19:15, Damian wrote:
> On 18/05/2012 01:55, Bill Meek wrote:
>> On 05/17/2012 05:16 PM, Damian wrote:
>> ...
>>> Here's the response to that command:
>>>
>>> $ dpkg -l libva-x11-1
>>> dpkg-query: warning: parsing file '/var/lib/dpkg/status' near line
>>> 77904 package 'virtualbox-3.0':
>>> error in Version string '3.0.14-58977_Ubuntu_karmic': invalid
>>> character in revision number
>> ...
>>> ii libva-x11-1 1.0.15-4 Video Acceleration (VA) API for Linux -- X11
>> ...
>>> strings `locate -b '\mythbackend'` | grep '0.2[3-5]'
>> ...
>>> v0.25-84-g9ccfac1
>>>
>>> Does that get us any closer?
>>
>> Sorry, no. The version of libva-x11-1 matches mine and the
>> backend at least has the v0.25-84... line.
>>
>> At the very least, your status files looks stomped on. That gets
>> back to you original post of a failed (partial) upgrade. I did
>> google and see this if you want to try:
>>
>> http://ubuntuforums.org/showpost.php?s=4b6cd598b367c4c5bfdc1961f2e61c4e&p=10226999&postcount=2
>>
>>
>>
>> One more question:
>>
>> Are you running a virtual machine (virtualbox 3.0)?
>>
>> If you're in danger of losing your family, then since the root cause of
>> the problem isn't known yet (disk failure/upgrade failure/high tides)
>> then, yes I agree a fresh install is looking much quicker.
>>
>
> Hello again all,
>
> So, I bit the bullet today and installed Mythbuntu 12.04. I wiped my /
> and /home partitions and kept all of the recordings and video files
> where they live on another drive.
>
> I now have a clean Mythbuntu 12.04 install. It's all new to me because
> I have previously used Ubuntu and added Mythbuntu on top. However, as
> I don't like Unity and ended up installing Gnome anyway, I thought I'd
> give pure Mythbuntu a try.
>
> Before I wiped my last installation, I backed up the database as well
> as I could. I'm concerned that I have no idea of knowing what state
> this is in. I know it was all working in 0.24, but nothing has worked
> since I tried to go to 0.25. Will the database be in a 0.24 type
> format or a 0.25??
>
> Anyway, I did a full backup of mythconverge using phpmyadmin. I also
> did a second backup using:
>
> mysqldump -u mythtv -pmythtv mythconverg -c > mythtv_backup.sql
>
>
> Now the fun beggins. Can I shoe horn the old database into this new
> system?
>
> Problem1 .. The mysql root database password?
>
> What is it when in a clean 12.04 install?
>
> mysql -u root
> is returning:
> damian [at] mythbo:~$ mysql -u root
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: NO)
>
> and a simple 'enter' doesn't work if I try:
> mysql -u root -p
>
> I'm also concerned that there maybe some hardware issue still going
> on. Obviously replacing the power supply was a big problem, but I've
> just tried to install phpmyadmin via Ubuntu Software Centre and it
> seems to have hung. Is XFCE not good at multitasking or something?
>
> Looking forward to any tips on the password and hoping the rest of the
> machine is actually ok.
>
> Hope to get to the bottom of all of this one day!!
>
> Cheers
> Damian

Grrrrr....
I've just had a:
"Sorry, Ubuntu 12.04 has experienced an internal error.
If you notice any further problems, try restarting the computer"
And then a load of information that I can't cut and paste for some
unhelpful reason.

I had a couple of this messages before the clean install, but assumed it
was due to what had happened with the upgrade.

This is driving me nuts! Had a whole day on this today and I've got nowhere.

Not got time for this!

I'd really appreciate help on the mysql root password issue

And if anyone can tell me a user-friendly tool (live cd or something?)
to help me find the vulnerability in my hardware, I'd appreciate that too.

As far away from the command line as possible would make me happy. M$
Windows is looking pretty darn good to me at the moment!

Cheers all
Damian
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-users

mythtv at hambone

May 20, 2012, 12:19 PM

Post #8 of 14 (1137 views)
Permalink

Re: Ubuntu/Mythbuntu update problem [In reply to]

On Sun, May 20, 2012 at 2:55 PM, Damian <myth [at] surr> wrote:

>
> I'd really appreciate help on the mysql root password issue
> Damian,
>

Here's a link on resetting the mysql root password. It happened to me a
couple of years ago.

http://www.howtoforge.com/reset-forgotten-mysql-root-password

Hope that helps!
Jerry

myth at surr

May 20, 2012, 1:05 PM

Post #9 of 14 (1130 views)
Permalink

Re: Ubuntu/Mythbuntu update problem [In reply to]

On 20/05/2012 20:19, mythtv [at] hambone wrote:
> On Sun, May 20, 2012 at 2:55 PM, Damian <myth [at] surr
> <mailto:myth [at] surr>> wrote:
>
>
> I'd really appreciate help on the mysql root password issue
> Damian,
>
>
> Here's a link on resetting the mysql root password. It happened to me a
> couple of years ago.
>
> http://www.howtoforge.com/reset-forgotten-mysql-root-password
>
> Hope that helps!
> Jerry

Thanks for that Jerry,

In the mean time, I found these instructions:
http://ubuntu.flowconsult.at/en/mysql-set-change-reset-root-password/
and set a new password for mysql.

I then returned to the guide I followed to backup my database:
http://ubuntuforums.org/showpost.php?p=2298778&postcount=4

and went to the restore section.

Here's where I got to ...

damian [at] mythbo:/storage/zzz-mythbak-manual$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 822
Server version: 5.5.22-0ubuntu1 (Ubuntu)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql> DROP DATABASE mythconverg;
Query OK, 104 rows affected (0.10 sec)

mysql> create database mythconverg;
Query OK, 1 row affected (0.00 sec)

mysql> exit
Bye
damian [at] mythbo:/storage/zzz-mythbak-manual$ ls
mythtv_backup.sql
damian [at] mythbo:/storage/zzz-mythbak-manual$ mysql -u mythtv -p
mythconverg <mythtv_backup.sql
Enter password:
ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using
password: YES)
damian [at] mythbo:/storage/zzz-mythbak-manual$

What went wrong there, and why?

Thanks
Damian
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-users

icicimov at gmail

May 20, 2012, 1:16 PM

Post #10 of 14 (1134 views)
Permalink

Re: Ubuntu/Mythbuntu update problem [In reply to]

Didnt you say its a new database? Do you think mysql comes with myth user
by default?
On May 21, 2012 6:06 AM, "Damian" <myth [at] surr> wrote:

> On 20/05/2012 20:19, mythtv [at] hambone wrote:
>
>> On Sun, May 20, 2012 at 2:55 PM, Damian <myth [at] surr
>> <mailto:myth [at] surr>> wrote:
>>
>>
>> I'd really appreciate help on the mysql root password issue
>> Damian,
>>
>>
>> Here's a link on resetting the mysql root password. It happened to me a
>> couple of years ago.
>>
>> http://www.howtoforge.com/**reset-forgotten-mysql-root-**password<http://www.howtoforge.com/reset-forgotten-mysql-root-password>
>>
>> Hope that helps!
>> Jerry
>>
>
> Thanks for that Jerry,
>
> In the mean time, I found these instructions:
> http://ubuntu.flowconsult.at/**en/mysql-set-change-reset-**root-password/<http://ubuntu.flowconsult.at/en/mysql-set-change-reset-root-password/>
> and set a new password for mysql.
>
> I then returned to the guide I followed to backup my database:
> http://ubuntuforums.org/**showpost.php?p=2298778&**postcount=4<http://ubuntuforums.org/showpost.php?p=2298778&postcount=4>
>
> and went to the restore section.
>
> Here's where I got to ...
>
> damian [at] mythbo:/storage/zzz-**mythbak-manual$ mysql -u root -p
> Enter password:
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 822
> Server version: 5.5.22-0ubuntu1 (Ubuntu)
>
> Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights
> reserved.
>
> Oracle is a registered trademark of Oracle Corporation and/or its
> affiliates. Other names may be trademarks of their respective
> owners.
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input
> statement.
>
> mysql> DROP DATABASE mythconverg;
> Query OK, 104 rows affected (0.10 sec)
>
> mysql> create database mythconverg;
> Query OK, 1 row affected (0.00 sec)
>
> mysql> exit
> Bye
> damian [at] mythbo:/storage/zzz-**mythbak-manual$ ls
> mythtv_backup.sql
> damian [at] mythbo:/storage/zzz-**mythbak-manual$ mysql -u mythtv -p
> mythconverg <mythtv_backup.sql
> Enter password:
> ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using
> password: YES)
> damian [at] mythbo:/storage/zzz-**mythbak-manual$
>
> What went wrong there, and why?
>
> Thanks
> Damian
> ______________________________**_________________
> mythtv-users mailing list
> mythtv-users [at] mythtv
> http://www.mythtv.org/mailman/**listinfo/mythtv-users<http://www.mythtv.org/mailman/listinfo/mythtv-users>
>

myth at surr

May 20, 2012, 1:41 PM

Post #11 of 14 (1128 views)
Permalink

Re: Ubuntu/Mythbuntu update problem [In reply to]

On 20/05/2012 21:16, Igor Cicimov wrote:
> Didnt you say its a new database? Do you think mysql comes with myth
> user by default?

Hi Igor,

I've installed the Mythbuntu OS, so with the whole system based around
MythTV, yes I had assumed that everything would be set up by default.

If I'm mistaken, can you enlighten me?

Damian
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-users

thomas at mashos

May 20, 2012, 1:50 PM

Post #12 of 14 (1128 views)
Permalink

Re: Ubuntu/Mythbuntu update problem [In reply to]

On Sun, May 20, 2012 at 1:41 PM, Damian <myth [at] surr> wrote:
> On 20/05/2012 21:16, Igor Cicimov wrote:
>>
>> Didnt you say its a new database? Do you think mysql comes with myth
>> user by default?
>
>
> Hi Igor,
>
> I've installed the Mythbuntu OS, so with the whole system based around
> MythTV, yes I had assumed that everything would be set up by default.
>
> If I'm mistaken, can you enlighten me?
>
>
> Damian
> _______________________________________________
> mythtv-users mailing list
> mythtv-users [at] mythtv
> http://www.mythtv.org/mailman/listinfo/mythtv-users

The default root password for mysql on a Ubuntu system is the same
password you used during installation.

I recommend using the provided utility to backup and restore the database.
http://www.mythtv.org/wiki/Database_Backup_and_Restore

Since we're past that, did you try inserting the database using the
root user? You dropped the mythconverg database, so it sound like it
removed any permissions you would have with the mythtv user on it.
Since the mythtv user likely doesn't have permission to create a new
database you will need to either create one and give the mythtv user
permission, or use root to restore the database (and then give the
mythtv user access again)

Thanks,

Thomas Mashos
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-users

myth at surr

May 22, 2012, 10:07 AM

Post #13 of 14 (1095 views)
Permalink

Re: Ubuntu/Mythbuntu update problem [In reply to]

On 20/05/2012 21:50, Thomas Mashos wrote:
> On Sun, May 20, 2012 at 1:41 PM, Damian<myth [at] surr> wrote:
>> On 20/05/2012 21:16, Igor Cicimov wrote:
>>>
>>> Didnt you say its a new database? Do you think mysql comes with myth
>>> user by default?
>>
>>
>> Hi Igor,
>>
>> I've installed the Mythbuntu OS, so with the whole system based around
>> MythTV, yes I had assumed that everything would be set up by default.
>>
>> If I'm mistaken, can you enlighten me?
>>
>>
>> Damian
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users [at] mythtv
>> http://www.mythtv.org/mailman/listinfo/mythtv-users
>
> The default root password for mysql on a Ubuntu system is the same
> password you used during installation.
>
> I recommend using the provided utility to backup and restore the database.
> http://www.mythtv.org/wiki/Database_Backup_and_Restore
>
> Since we're past that, did you try inserting the database using the
> root user? You dropped the mythconverg database, so it sound like it
> removed any permissions you would have with the mythtv user on it.
> Since the mythtv user likely doesn't have permission to create a new
> database you will need to either create one and give the mythtv user
> permission, or use root to restore the database (and then give the
> mythtv user access again)
>
> Thanks,
>
> Thomas Mashos

Thanks for that Thomas,

I used the 'root' user instead of 'mythtv' to restore the database and I
think it all got restored ok.

How can I add the 'mythtv' user now and grant required privileges?

Thanks a lot,
Damian
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-users

thomas at mashos

May 22, 2012, 2:27 PM

Post #14 of 14 (1091 views)
Permalink

Re: Ubuntu/Mythbuntu update problem [In reply to]

On Tue, May 22, 2012 at 10:07 AM, Damian <myth [at] surr> wrote:
> On 20/05/2012 21:50, Thomas Mashos wrote:
>>
>> On Sun, May 20, 2012 at 1:41 PM, Damian<myth [at] surr> wrote:
>>>
>>> On 20/05/2012 21:16, Igor Cicimov wrote:
>>>>
>>>>
>>>> Didnt you say its a new database? Do you think mysql comes with myth
>>>> user by default?
>>>
>>>
>>>
>>> Hi Igor,
>>>
>>> I've installed the Mythbuntu OS, so with the whole system based around
>>> MythTV, yes I had assumed that everything would be set up by default.
>>>
>>> If I'm mistaken, can you enlighten me?
>>>
>>>
>>> Damian
>>> _______________________________________________
>>> mythtv-users mailing list
>>> mythtv-users [at] mythtv
>>> http://www.mythtv.org/mailman/listinfo/mythtv-users
>>
>>
>> The default root password for mysql on a Ubuntu system is the same
>> password you used during installation.
>>
>> I recommend using the provided utility to backup and restore the database.
>> http://www.mythtv.org/wiki/Database_Backup_and_Restore
>>
>> Since we're past that, did you try inserting the database using the
>> root user? You dropped the mythconverg database, so it sound like it
>> removed any permissions you would have with the mythtv user on it.
>> Since the mythtv user likely doesn't have permission to create a new
>> database you will need to either create one and give the mythtv user
>> permission, or use root to restore the database (and then give the
>> mythtv user access again)
>>
>> Thanks,
>>
>> Thomas Mashos
>
>
> Thanks for that Thomas,
>
> I used the 'root' user instead of 'mythtv' to restore the database and I
> think it all got restored ok.
>
> How can I add the 'mythtv' user now and grant required privileges?
>
> Thanks a lot,
> Damian

You'll want to take a look at
http://www.mythtv.org/wiki/Category:MySQL

Thanks,

Thomas Mashos
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-users

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads