Запускаю MythTV - проблема с Mysql

[Eksodusmen]

скачал и скомпиллил MythTV
запустил - смотрю какие то ошибки с mysql
установил потом mysql
но всё равно при запуске MythTV из консоли - пишет такое

[root@localhost ]# mythtv
2007-07-19 03:31:30.443 Using runtime prefix = /usr/local
2007-07-19 03:31:30.449 DPMS is active.
QSqlDatabase: QMYSQL3 driver not loaded
QSqlDatabase: available drivers:
2007-07-19 03:31:30.451 New DB connection, total: 1
2007-07-19 03:31:30.451 Unable to connect to database!
2007-07-19 03:31:30.451 No error type from QSqlError? Strange...
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2007-07-19 03:31:30.503 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
2007-07-19 03:31:30.555 Unable to connect to database!
2007-07-19 03:31:30.555 No error type from QSqlError? Strange...
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2007-07-19 03:31:30.607 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
2007-07-19 03:31:30.658 Database not open while trying to load setting: GuiVidModeResolution
2007-07-19 03:31:30.659 Unable to connect to database!
2007-07-19 03:31:30.659 No error type from QSqlError? Strange...
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2007-07-19 03:31:30.710 DB Error (KickDatabase):

на самом сайте MythTV пишут такое
To setup the initial MySQL databases:
$ cd database
а мне в ответ выдаёт такое
bash: cd: database: Нет такого файла или каталога

дальше - $ mysql -u root < mc.sql
мне в ответ
bash: mc.sql: Нет такого файла или каталога

сервер SQL работает

как заставить заработать MythTV ?

[fed71]

Не настроена скульная база. Если на двух пальцах, то
1. MySQL должна быть запущена
2. Создание пароля рута для скл-базы

$ mysql -u root
set password for root@localhost = password('xxxxxxx');
flush privileges;
quit;

Вместо ххх свой парол конечно

3. Создание базы для mythtv

$ mysql -p -u root
CREATE DATABASE mythtv;
USE mysql;
FLUSH PRIVILEGES;
quit;

Ну и в настройках проги наверное должны быть настройки базы.

[wahnsinn]

У меня аналогичная проблема. Стопорнулся на этой самой базе под данную программу. Нижеописанные дейсвия не помогли. Есть кто смог настроить MythTV и описать свои действия?

[lnkgyv]

У меня аналогичная проблема. Стопорнулся на этой самой базе под данную программу. Нижеописанные дейсвия не помогли. Есть кто смог настроить MythTV и описать свои действия?

У меня были проблемы описаные выше: я их решил так: необходимо собрать кутю с такими опциями ./configure -thread -sql-plugin-mysq -I /<путь где лежат develop файлы mysql(mysql.h, mysql.cpp)> -L<путь где лежат либы к mysql>.
Далее собираю кутю, запускаю демон mysql: в моём случае service mysqld start. Затем захожу в каталог, где сборочные файлы mythtv, databases и запускаю mysql -u root < mc.sql. Затем запускаю mythtv и - ура запускается!

[progressive]

А как нить, попроще, без пересборки, решить можно?

[progressive]

А как нить, попроще, без пересборки, решить можно?

[Cornet]

http://www.unix-news.com/articles/2007/02/...uide-for-debian
http://www.mythtv.org/wiki/index.php/Insta..._on_Debian_Etch
http://www.mythtv.org/wiki/index.php/Insta...N_on_Debian_Sid
http://www.linuxcenter.ru/lib/articles/soft/mysql.phtml
НУ помоему все.

[P1ngU1N]

Здравствуйте. Не стал создавать новую тему, а поднял эту. Поставил MythTV, MySQL на ALT 4.0 D. Выдает такое при запуске:

Код: Выделить всё

2008-02-17 21:33:22.438 Using runtime prefix = /usr, libdir = /usr/lib
2008-02-17 21:33:22.484 DPMS is active.
2008-02-17 21:33:22.485 Empty LocalHostName.
2008-02-17 21:33:22.485 Using localhost value of localhost
2008-02-17 21:33:22.494 New DB connection, total: 1
2008-02-17 21:33:22.542 Connected to database 'mythtv' at host: localhost
2008-02-17 21:33:22.565 Closing DB connection named 'DBManager0'
2008-02-17 21:33:22.565 Total desktop dim: 1280x1024, with 1 screen[s].
2008-02-17 21:33:22.566 Connected to database 'mythtv' at host: localhost
2008-02-17 21:33:22.567 Using screen 0, 1280x1024 at 0,0
2008-02-17 21:33:22.598 New DB connection, total: 2
2008-02-17 21:33:22.599 Connected to database 'mythtv' at host: localhost
2008-02-17 21:33:22.599 Current Schema Version: 0
2008-02-17 21:33:22.600 DataDirectProcessor::FixProgramIDs() -- begin
2008-02-17 21:33:22.600 New DB DataDirect connection
2008-02-17 21:33:22.601 Connected to database 'mythtv' at host: localhost
2008-02-17 21:33:22.613 DB Error (Fixing program ids in recorded):
Query was:
UPDATE recorded SET programid=CONCAT(SUBS
TRING(programid, 1, 2),                      '00', SUBSTRING(programid, 3)) WHERE length(programid) = 12
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythtv.recorded' doesn't exist

2008-02-17 21:33:22.614 DB Error (Clear setting):
Query was:
DELETE FROM settings WHERE value = 'BackupDBLastRunStart' AND hostname is NULL;
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythtv.settings' doesn't exist

2008-02-17 21:33:22.615 DB Error (SaveSettingOnHost query failure: ):
Query was:
INSERT INTO settings (value,data,hostname ) VALUES ( 'BackupDBLastRunStart', '2008-02-17 21:33:22', NULL );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythtv.settings' doesn't exist

2008-02-17 21:33:22.615 DB Error (StorageGroup::StorageGroup()):
Query was:
SELECT DISTINCT dirname FROM storagegroup WHERE groupname = 'DB Backups' AND hostname = 'localhost'
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythtv.storagegroup' doesn't exist

2008-02-17 21:33:22.616 New DB connection, total: 3
2008-02-17 21:33:22.616 Connected to database 'mythtv' at host: localhost
2008-02-17 21:33:22.617 SG(DB Backups) Error: Directory value for Default Storage Group is empty.  Using hardcoded default value of '/mnt/store'
2008-02-17 21:33:22.617 SG(DB Backups) Error: FindNextDirMostFree: '/mnt/store' does not exist!
2008-02-17 21:33:22.617 Backing up database to file: /tmp/mythtv--20080217213322.sql
2008-02-17 21:33:22.691 Compressing database backup file.
2008-02-17 21:33:22.695 Database Backup filename: /tmp/mythtv--20080217213322.sql.gz
2008-02-17 21:33:22.695 Database Backup complete.
2008-02-17 21:33:22.696 DB Error (Clear setting):
Query was:
DELETE FROM settings WHERE value = 'BackupDBLastRunEnd' AND hostname is NULL;
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythtv.settings' doesn't exist

2008-02-17 21:33:22.696 DB Error (SaveSettingOnHost query failure: ):
Query was:
INSERT INTO settings (value,data,hostname ) VALUES ( 'BackupDBLastRunEnd', '2008-02-17 21:33:22', NULL );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythtv.settings' doesn't exist

2008-02-17 21:33:22.701 Total desktop dim: 1280x1024, with 1 screen[s].
2008-02-17 21:33:22.703 Using screen 0, 1280x1024 at 0,0
2008-02-17 21:33:22.704 Switching to square mode (blue)
2008-02-17 21:33:22.714 Using the Qt painter
mythtv: could not connect to socket
mythtv: Нет такого файла или каталога
2008-02-17 21:33:22.716 lirc_init failed for mythtv, see preceding messages
2008-02-17 21:33:22.716 JoystickMenuClient Error: Joystick disabled - Failed to read /home/maks/.mythtv/joystickmenurc
2008-02-17 21:33:24.017 DB Error (Clear setting):
Query was:
DELETE FROM settings WHERE value = 'Language' AND hostname = 'localhost';
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythtv.settings' doesn't exist

2008-02-17 21:33:24.018 DB Error (SaveSettingOnHost query failure: ):
Query was:
INSERT INTO settings (value,data,hostname) VALUES ( 'Language', 'EN', 'localhost' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythtv.settings' doesn't exist

2008-02-17 21:33:24.019 DB Error (Clear setting):
Query was:
DELETE FROM settings WHERE value = 'Language' AND hostname = 'localhost';
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythtv.settings' doesn't exist

2008-02-17 21:33:24.020 DB Error (SaveSettingOnHost query failure: ):
Query was:
INSERT INTO settings (value,data,hostname) VALUES ( 'Language', 'EN', 'localhost' );
Driver error was [2/1146]:
QMYSQL3: Unable to execute query
Database error was:
Table 'mythtv.settings' doesn't exist

2008-02-17 21:33:26.542 Newest Schema Version : 1211
2008-02-17 21:33:26.544 Told to create a NEW database schema, but the database
already has 12 tables.
If you are sure this is a good mythtv database, verify
that the settings table has the DBSchemaVer variable.

2008-02-17 21:33:26.544 Database Schema upgrade FAILED, unlocking.
2008-02-17 21:33:26.545 Couldn't upgrade database to new schema.

В какую сторону копать?

[VladimirVladimirovich]

скачал и скомпиллил MythTV
запустил - смотрю какие то ошибки с mysql
установил потом mysql
но всё равно при запуске MythTV из консоли - пишет такое

Код: Выделить всё

[root@localhost ]# mythtv
2007-07-19 03:31:30.443 Using runtime prefix = /usr/local
2007-07-19 03:31:30.449 DPMS is active.
QSqlDatabase: QMYSQL3 driver not loaded
QSqlDatabase: available drivers:
2007-07-19 03:31:30.451 New DB connection, total: 1
2007-07-19 03:31:30.451 Unable to connect to database!
2007-07-19 03:31:30.451 No error type from QSqlError? Strange...
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2007-07-19 03:31:30.503 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
2007-07-19 03:31:30.555 Unable to connect to database!
2007-07-19 03:31:30.555 No error type from QSqlError? Strange...
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2007-07-19 03:31:30.607 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
2007-07-19 03:31:30.658 Database not open while trying to load setting: GuiVidModeResolution
2007-07-19 03:31:30.659 Unable to connect to database!
2007-07-19 03:31:30.659 No error type from QSqlError? Strange...
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2007-07-19 03:31:30.710 DB Error (KickDatabase)

Если при запуске вываливается ошибка: QSqlDatabase: QMYSQL3 driver not loaded
Это означает, что не загружен драйвер qt-MySQL, нужно установить пакет qt-MySQL

[TAV]

Потею над Avermedia MCE 116 Plus. Изучал хауты по адресам http://forum.sat-expert.com/mythtv/6331-us...vka-mythtv.html http://wiki.archlinux.org/index.php/MythTV а также с офсайта но с mysql что делать не пойму. Мои действия:
# /etc/rc.d/mysqld restart
:: Stopping MySQL [DONE]
:: Starting MySQL [DONE]
# mysql -u root -p -e 'drop database mythconverg;'
Enter password:
ERROR 1008 (HY000) at line 1: Can't drop database 'mythconverg'; database doesn't exist
# mysql -u root -p < /root/mc.sql
Enter password:
# mythbackend
2009-12-09 20:12:26.252 mythbackend version: tags/release-0-22 [0.22] www.mythtv.org
2009-12-09 20:12:26.252 Using runtime prefix = /usr
2009-12-09 20:12:26.252 Using configuration directory = /root/.mythtv
2009-12-09 20:12:26.252 Empty LocalHostName.
2009-12-09 20:12:26.252 Using localhost value of 4b5b
2009-12-09 20:12:26.257 New DB connection, total: 1
2009-12-09 20:12:26.258 Unable to connect to database!
2009-12-09 20:12:26.258 Driver error was [1/2003]:
QMYSQL: Unable to connect
Database error was:
Can't connect to MySQL server on '127.0.0.1' (111)

................................................................................
2009-12-09 20:12:29.238 UPnPautoconf() - No UPnP backends found
2009-12-09 20:12:29.238 No UPnP backends found

No UPnP backends found

Would you like to configure the database connection now? [no] yes
Database host name: 127.0.0.1
Should I test connectivity to this host using the ping command? [yes]
Database non-default port: [0]
Database name: [mythconverg]
Database user name: [mythtv]
Database password: [mythtv]
Unique identifier for this machine (if empty, the local host name will be used):
Would you like to use Wake-On-LAN to retry database connections? [no]
2009-12-09 20:12:54.463 Writing settings file /root/.mythtv/mysql.txt
2009-12-09 20:12:54.464 Closing DB connection named 'DBManager0'
2009-12-09 20:12:54.464 Closing DB connection named 'DBManager0'
2009-12-09 20:12:54.464 Unable to connect to database!
2009-12-09 20:12:54.464 Driver error was [1/2003]:
QMYSQL: Unable to connect
Database error was:
Can't connect to MySQL server on '127.0.0.1' (111)

2009-12-09 20:12:54.464 Cannot login to database?
2009-12-09 20:12:54.464 Cannot login to database?

Cannot login to database?

Would you like to configure the database connection now? [no] ^C

mythbackend ввел вместо mythtv-setup для наглядности. Базы mc.sql по указанному пити небыло, поэтому взял из тарбола с офсайта проекта, потому и путь /root.
почему mythtv не может подконектится к скулю? Все пароли с логинами вроде как уже в импортированной базе должны быть.