Arch Linux

Eratosthenes

Member

Registered: 2009-11-02

Posts: 19

[SOLVED] Lost installing mythtv

Hi all--

I am trying to set up a mythtv server on my Arch box following the How To in the wiki. All goes well until I get here in the wiki (http://wiki.archlinux.org/index.php/Myt … er_backend).

When I run "mythtv-setup" for the first time (or subsequent times, actually) I get some normal looking screens and then the gui freezes. The command line output looks like this:

...
2011-02-17 08:52:56.891 No current database version?
2011-02-17 08:52:56.892 Database appears to be empty/new!
2011-02-17 08:52:56.892 Timed out waiting.
2011-02-17 08:52:56.892 The database seems to be empty - not attempting a backup
2011-02-17 08:52:56.899 Newest MythTV Schema Version : 1264
2011-02-17 08:52:56.900 Inserting MythTV initial database information.
2011-02-17 08:52:56.900 New DB connection, total: 3
2011-02-17 08:52:56.900 Connected to database 'mythconverg' at host: localhost
2011-02-17 08:52:56.900 Upgrading to MythTV schema version 1226

Nothing happens in the database except that the schemalock table is created.

mysql> use mythconverg;
Database changed
mysql> show tables
    -> ;
+-----------------------+
| Tables_in_mythconverg |
+-----------------------+
| schemalock            |
+-----------------------+
1 row in set (0.00 sec)

At this point I deleted the schemalock table and tried to start mythbackend.

sudo  /etc/rc.d/mythbackend start

The beginning of the mythbackend log has this:

2011-02-17 08:56:15.953 mythbackend version: exported [0.24] www.mythtv.org
2011-02-17 08:56:15.955 Using runtime prefix = /usr
2011-02-17 08:56:15.956 Using configuration directory = /root/.mythtv          <------ I have a good mysql.txt here. I'm not sure why it is looking for this in root instead of /home/mythtv
2011-02-17 08:56:15.956 Using localhost value of MYCOOLMYTHTVHOST
2011-02-17 08:56:15.961 New DB connection, total: 1
2011-02-17 08:56:15.964 Connected to database 'mythconverg' at host: localhost
2011-02-17 08:56:15.967 Closing DB connection named 'DBManager0'
2011-02-17 08:56:15.969 Connected to database 'mythconverg' at host: localhost
2011-02-17 08:56:15.970 Error preparing query: SELECT data FROM settings WHERE value = :KEY AND hostname = :HOSTNAME
2011-02-17 08:56:15.970 Driver error was [2/1146]:
QMYSQL3: Unable to prepare statement
Database error was:
Table 'mythconverg.settings' doesn't exist

+ many more similar errors

The end of the mythbackend log has an old friend:

2011-02-17 08:56:19.079 Database appears to be empty/new!
2011-02-17 08:56:20.080 No current database version?
2011-02-17 08:56:20.081 Database appears to be empty/new!
2011-02-17 08:56:21.082 No current database version?
2011-02-17 08:56:21.083 Database appears to be empty/new!
2011-02-17 08:56:21.084 Timed out waiting.
2011-02-17 08:56:21.085 The database seems to be empty - not attempting a backup
2011-02-17 08:56:21.092 Newest MythTV Schema Version : 1264
2011-02-17 08:56:21.094 Inserting MythTV initial database information.
2011-02-17 08:56:21.095 New DB connection, total: 3
2011-02-17 08:56:21.096 Connected to database 'mythconverg' at host: localhost
2011-02-17 08:56:21.097 Upgrading to MythTV schema version 1226

I have left this to run a good long time, but the schema never gets created.

Suggestions or guidance, please.

Thanks in advance.

Last edited by Eratosthenes (2011-02-24 22:52:30)

neolith2099

Member

Registered: 2010-03-26

Posts: 2

Re: [SOLVED] Lost installing mythtv

I am having this same problem and I believe it may have something to do with the new update to MySQL that was just released. It was working before the update as far as I can remember. I will post here if and when I figure out a solution.

Cheers!

Update:

There are numerous bugs in MythTV when using MySQL 5.5; I believe schema update and building is one of them. There are other issues you will encounter even if you manage to get past that step. See here for an example of what I mean. I advise you do what you can to get back to MySQL 5.1.x.

Last edited by neolith2099 (2011-02-19 05:14:27)

fphillips

Member

From: Austin, TX

Registered: 2009-01-24

Posts: 202

Re: [SOLVED] Lost installing mythtv

There are numerous bugs in MythTV when using MySQL 5.5; I believe schema update and building is one of them. There are other issues you will encounter even if you manage to get past that step. See here for an example of what I mean. I advise you do what you can to get back to MySQL 5.1.x.

I had previously seen that ticket, which led me to test mysql-5.5 before it was released. Maybe there is a problem with initial installs, but for existing installs coming from mysql-5.1 it has been working fine, provided you follow the upgrade procedure. This is with 0.24-fixes, not 0.24.

Does the log in /var/lib/mysql/$HOSTNAME.err indicate any incompatibilities?
Have you tried running mysql_upgrade like the announcement says? http://www.archlinux.org/news/mysql-55-is-now-in-extra/

Last edited by fphillips (2011-04-20 16:34:26)

Eratosthenes

Member

Registered: 2009-11-02

Posts: 19

Re: [SOLVED] Lost installing mythtv

Thanks very much for the replys.

Running mysql_upgrade on the existing 5.5 install seemed to have had no effect on the immediate problem.

I also managed to hose my mysql server, perhaps by trying to downgrade to 5.1 after running mysql_upgrade. This is not a big deal because I only use this server for local testing. Meanwhile, the parts needed to repair my dedicated mythtv box arrived, and it is now working again. Therefore, I'm not going to pursue this mythtv installation further.

boomshalek

Member

Registered: 2007-10-12

Posts: 105

Re: [SOLVED] Lost installing mythtv

Hi

I have the same problem. I am trying to move my Mythbuntu Mythtv-Backend to Archlinux. And I do not have old pkgs in my repository as I used the newest ArchBang to get a base arch system

Can someone give me a hint how to downgrade to previous MYSQL Server. I tried to read the general manual, but it is not really specific in what to do. I would like to pin the package version to something like mysql-server-5.1*

How can I do that in Arch.

Best regards

eldragon

Member

From: Buenos Aires

Registered: 2008-11-18

Posts: 1,029

Re: [SOLVED] Lost installing mythtv

mythtv works with the new mysql server here.

did you follow the announcement about it?

boomshalek

Member

Registered: 2007-10-12

Posts: 105

Re: [SOLVED] Lost installing mythtv

OK, I have used ARM to downgrade to:

mysql-5.1.54-1-i686.pkg.tar.xz
libmysqlclient-5.1.54-1-i686.pkg.tar.xz
mysql-clients-5.1.54-1-i686.pkg.tar.xz

But I still get the same error ...

Please help. MythTV will not be "ready for MySQL 5.5" soon for default new installs, so this is a real troublemaker

eldragon

Member

From: Buenos Aires

Registered: 2008-11-18

Posts: 1,029

Re: [SOLVED] Lost installing mythtv

have you tried to repair the mythconverg database?

boomshalek

Member

Registered: 2007-10-12

Posts: 105

Re: [SOLVED] Lost installing mythtv

hi eldragon

thank you for the follow-up posts. I uninstalled mysql and mythtv and re-installed the old 5.1 versions of mysql first, then mythtv again. I could now initialize the database.

I will now try to upgrade to mysql 5.5 following the given how-to in the Arch News section and report afterwards.

Best regards

boomshalek

Member

Registered: 2007-10-12

Posts: 105

Re: [SOLVED] Lost installing mythtv

I upgraded the packages again after mythtv upgraded the DB and it works fine.

eldragon

Member

From: Buenos Aires

Registered: 2008-11-18

Posts: 1,029

Re: [SOLVED] Lost installing mythtv

please mark as solved