[mythtvnz] Help please!

[mark.van.dijk at ihug.co.nz]

>Aaron Whitehouse wrote:
>I tried to reinstall mysql-server through synaptic, but got an error
>about a subprocess that made me realise that the problem was MythArchive
>leaving me with no free space on the root partition.
>
>I have now cleared the space and MySQL seems to be much happier (starts
>and mysqldump gives a sensibly-sized file). Unfortunately, I seem to
>have broken MythTV's connection to the database in my fiddling. I assume
>that I somehow need to change it so that it knows where to find the
>MySQL installation and the name/pass of the database.

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