[Pkg-mythtv-maintainers] Bug#502911: mythtv-database: backend doesnt use configured password

[Daniel Gasser]

Package: mythtv-database
Version: 0.21-0.11etch1
Severity: important
Tags: patch

After installing mythtv from the debian repository, mythbackend was not able to 
connect to the database. Altough the right password was configured in mythtv-common and the frontend. The backend always 
tried to use a "default" password.
The installation was made on a system with a self-compiled mythtv (0.20.2) on it 
before. Might be important, but i don't know.

I had to do the following to make the backend start:
cp /etc/mythtv/mysql.txt /var/lib/mythtv/.mythtv/mysql.txt

Now i can startup mythbackend.

The database structure was not updated after installation. On startup, I get the 
following error message. This might be unrelated to the above:

DB Error (Error in JobQueue::GetJobs(), Unable to query list of Jobs in Queue.):
Query was:
SELECT j.id, j.chanid, j.starttime, j.inserttime, j.type, j.cmds,
j.flags, j.status, j.statustime, j.hostname, j.args, j.comment, r.endtime,
j.schedruntime FROM jobqueue j, recorded r WHERE j.chanid = r.chanid AND j.starttime =
r.starttime ORDER BY j.inserttime, j.chanid, j.id;
Driver error was [2/1054]:
QMYSQL3: Unable to execute query
Database error was:
Unknown column 'j.schedruntime' in 'field list'


Anyway, i'd like to thank you for the great work on integrating mythtv in debian. 
This will make things a lot easier in future.

-- System Information:
Debian Release: 4.0
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: i386 (i686)
Shell:  /bin/sh linked to /bin/bash
Kernel: Linux 2.6.18-6-686
Locale: LANG=de_CH.UTF-8, LC_CTYPE=de_CH.UTF-8 (charmap=UTF-8)