[mythtvnz] Help please!

[Aaron Whitehouse]

Thanks a lot, Mark,

The answer would have fixed everything for me, were it not for Simon
getting there first! I am really impressed by the speed that you both
answered - who needs paid support with a community like this??

I put the question and answer on Launchpad's Mythbuntu section so that
anyone else with the problem can find it (hopefully):
https://answers.launchpad.net/mythbuntu/+question/58364/+index

I hope you don't mind, but thought that your messages were public anyway.

Thanks again,

Aaron

mark.van.dijk at ihug.co.nz wrote:

> Hi Aaron, coincidentally i just had a similar thing thing happen to me a
> couple of days ago.  I filled up my root partition, which prevented mysql
> from starting, and then somehow prevented myth frontend/backend from seeing
> the database when it did come back up.
> 
>  
> To fix it, here's what i did:
> 1) clear out the root partition
> 2) use the 'df' and 'du' commands to verify the root partition 
>    had plenty of space
> 3) rebooted, then made sure that i could access mysql via a 
>    command line
> 4) for MythTv to connect to mysql, it needs some info.  For 
>    Mythbuntu 8.04 (at least) this is:
>       host     (usually 'localhost')
>       database (usually 'mythconverg')
>       username (usually 'mythtv')
>       password ( ????? - no idea what this is supposed to be )
> 
>    I didn't know what password i should be using, so using the 
>    mysql command line tools i did:
>         update user set password=PASSWORD('mythtv') where username='mythtv'
> 5) reboot (don't think that was actually necessary, but thats 
>    what i did)
> 6) run 'mythtv-setup' from the command line and entered the 
>    details from step 4).  This should modify the /etc/mythtv/mysql.txt
>    file with the correct information
> 7) At this point, i could start Myth Frontend manually.  Did another
> reboot.
> 8) that was it!  everything burst into life after that.
> 
> 
> 
> Hope something here was of assistance...
> 
> Cheers
> Mark
> 
> 
> 
> 
> _______________________________________________
> mythtvnz mailing list
> mythtvnz at lists.linuxnut.co.nz
> http://lists.ourshack.com/mailman/listinfo/mythtvnz
> Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/
>