[mythtvnz] Help please!

[Simon Cantem]

Hi,

The config files for the backend are stored in /etc/mythtv - the most
important file there is mysql.txt which will contains the database settings.
You might want to connect to the database with those settings to make sure
the username and password still work, or as root run "mysql" then "show
databases;" to make sure the mythconverg database is still there.

The other thing to try is give the backend a kick (run:
/etc/init.d/mythbackend restart) and then have a look at the end of the file
/var/log/mythtv/mythbackend.log to see if there's any errors.

Simon


On Wed, Jan 21, 2009 at 11:19 PM, Aaron Whitehouse
<lists at whitehouse.org.nz>wrote:

> Hello all,
>
> I just tried to archive a recording on my Mythbuntu setup. The recording
> was bigger than a DVD, so I canceled it. Then things started to go
> funky with the Media Library showing no recordings and the Upcoming
> Recordings missing. I restarted and MythTV couldn't connect to the
> database.
>
> If I typed:
> $ mysql
> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
> '/var/run/mysqld/mysqld.sock' (2)
>
> And the /var/run/mysqld directory doesn't seem to exist.
>
> mythbuntu at mythbuntu-server:/var/run$ ls mysql*
> ls: cannot access mysql*: No such file or directory
>
> 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.
>
> Normally I would just reinstall Mythbuntu (again), but our TV was
> stolen, so I am doing everything over VNC until we get a replacement.
> Needless to say, reinstalling with no screen would not be fun.
>
> I have tried renaming the ~/mythtv/ folder, which I thought was where
> the backend files were (as distinct from ~/mythbuntu/, where I thought
> the frontend files were), but that didn't reset anything or make
> anything ask me for the database details.  If I run mythtv-setup, it
> prompts me to close running processes, then asks me to run
> mythfilldatabase, without doing anything in between.
>
> Can anybody please think of anything?
>
> Thanks a lot,
>
> Aaron
>
>
> _______________________________________________
> 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/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ourshack.com/pipermail/mythtvnz/attachments/20090121/cb398969/attachment.htm