Mythtv-setup fails to create the initial database

[cedric.dewijs@…]

I have installed mythtv, and mysql. After creating the initial database, mythtv-setup can not find the tables it needs.

Steps to reproduce: 1) regenerate the database: [code] [cedric@tvpc ~]$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 13 Server version: 5.5.11-log Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> drop database mythconverg; Query OK, 1 row affected (0.08 sec)

mysql> CREATE DATABASE IF NOT EXISTS mythconverg; Query OK, 1 row affected (0.00 sec)

mysql> GRANT ALL ON mythconverg.* TO mythtv@localhost IDENTIFIED BY "mythtv"; Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.05 sec)

mysql> GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv@localhost IDENTIFIED BY "mythtv"; Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec)

mysql> ALTER DATABASE mythconverg DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; Query OK, 1 row affected (0.00 sec)

mysql> quit Bye code 2)Run mythtv-setup: [code] [cedric@tvpc ~]$ mythtv-setup 2011-04-19 19:59:06.541 Using runtime prefix = /usr 2011-04-19 19:59:06.541 Using configuration directory = /home/cedric/.mythtv 2011-04-19 19:59:06.543 Unable to read configuration file mysql.txt 2011-04-19 19:59:06.543 Empty LocalHostName?. 2011-04-19 19:59:06.543 Using localhost value of tvpc 2011-04-19 19:59:06.568 New DB connection, total: 1 2011-04-19 19:59:06.578 Connected to database 'mythconverg' at host: localhost 2011-04-19 19:59:06.603 Closing DB connection named 'DBManager0' 2011-04-19 19:59:06.605 Connected to database 'mythconverg' at host: localhost 2011-04-19 19:59:06.607 Error preparing query: SELECT data FROM settings WHERE value = :KEY AND hostname = :HOSTNAME 2011-04-19 19:59:06.607 Driver error was [2/1146]: QMYSQL3: Unable to prepare statement Database error was: Table 'mythconverg.settings' doesn't exist

2011-04-19 19:59:06.609 Error preparing query: SELECT data FROM settings WHERE value = :KEY AND hostname IS NULL 2011-04-19 19:59:06.609 Driver error was [2/1146]: QMYSQL3: Unable to prepare statement Database error was: Table 'mythconverg.settings' doesn't exist

2011-04-19 19:59:06.611 Error preparing query: SELECT data FROM settings WHERE value = :KEY AND hostname = :HOSTNAME 2011-04-19 19:59:06.611 Driver error was [2/1146]: QMYSQL3: Unable to prepare statement Database error was: Table 'mythconverg.settings' doesn't exist

.......

2011-04-19 19:59:07.813 Error preparing query: SELECT data FROM settings WHERE value = :KEY AND hostname = :HOSTNAME 2011-04-19 19:59:07.813 Driver error was [2/1146]: QMYSQL3: Unable to prepare statement Database error was: Table 'mythconverg.settings' doesn't exist

2011-04-19 19:59:07.814 Error preparing query: SELECT data FROM settings WHERE value = :KEY AND hostname IS NULL 2011-04-19 19:59:07.814 Driver error was [2/1146]: QMYSQL3: Unable to prepare statement Database error was: Table 'mythconverg.settings' doesn't exist

2011-04-19 19:59:08.725 MythFontProperties?, Error: Failed to load 'Liberation Sans', got 'DejaVu? Sans' instead

Location: /usr/share/mythtv/themes/default/base.xml @ 11 Name: 'basetiny' Type: 'fontdef'

2011-04-19 19:59:08.726 MythFontProperties?, Error: Failed to load 'Liberation Sans', got 'DejaVu? Sans' instead

Location: /usr/share/mythtv/themes/default/base.xml @ 36 Name: 'basetinyred' Type: 'fontdef'

2011-04-19 19:59:08.727 MythFontProperties?, Error: Failed to load 'Liberation Sans', got 'DejaVu? Sans' instead

Location: /usr/share/mythtv/themes/default/base.xml @ 80 Name: 'basemediumyellow' Type: 'fontdef'

2011-04-19 19:59:08.781 Error preparing query: SELECT data FROM settings WHERE value = :KEY AND hostname = :HOSTNAME 2011-04-19 19:59:08.781 Driver error was [2/1146]: QMYSQL3: Unable to prepare statement Database error was: Table 'mythconverg.settings' doesn't exist

2011-04-19 19:59:08.783 Error preparing query: SELECT data FROM settings WHERE value = :KEY AND hostname IS NULL 2011-04-19 19:59:08.783 Driver error was [2/1146]: QMYSQL3: Unable to prepare statement Database error was: Table 'mythconverg.settings' doesn't exist

2011-04-19 19:59:19.386 System Locale (en_US), Country (US), Language (en) ^{C [cedric@tvpc ~]$}

My versions: mysql Ver 14.14 Distrib 5.5.11, for Linux (i686) using readline 5.1 Linux tvpc 2.6.38-ARCH #1 SMP PREEMPT Wed Mar 30 07:14:27 UTC 2011 i686 Intel(R) Pentium(R) 4 CPU 1.60GHz GenuineIntel? GNU/Linux code

See also this forum discussion: ​http://www.mythtvtalk.com/fresh-ach-linux-install-cannot-create-initial-database-mythconverg-14687/

[cedric.dewijs@…]

version of mythtv