mythtv+gentoo

digweed · Postitus Postitas **digweed** » 14.04.2006, 00:19

et üritaks tv kaardi abil TVd vaadata (saa7135 kiviga)
panen mythtv käima ja..
2006-04-14 00:19:26.885 Database not open while trying to save setting: Language2006-04-14 00:19:26.885 Unable to connect to database!
2006-04-14 00:19:26.885 Driver error was [1/2002]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

2006-04-14 00:19:26.885 Database not open while trying to load setting: Language2006-04-14 00:19:26.886 Unable to connect to database!
2006-04-14 00:19:26.887 Driver error was [1/2002]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

2006-04-14 00:19:26.887 Database not open while trying to save setting: Language2006-04-14 00:19:26.888 Unable to connect to database!
2006-04-14 00:19:26.888 Driver error was [1/2002]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

2006-04-14 00:20:02.500 Writing settings file /home/alari/.mythtv/mysql.txt
2006-04-14 00:20:02.502 Unable to connect to database!
2006-04-14 00:20:02.502 Driver error was [1/2002]:
QMYSQL3: Unable to connect
Database error was:
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

2006-04-14 00:20:02.503 Failed to init MythContext, exiting.

ingram · Postitus Postitas **ingram** » 14.04.2006, 08:02

Sul peab olema mingis kohas Confitud MySQL, Too ei saa mingi MySQL serveriga connectida.

digweed · Postitus Postitas **digweed** » 14.04.2006, 09:21

2006-04-14 09:24:43.687 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user 'digweed'@'localhost' (using password: YES)

2006-04-14 09:24:44.587 Unable to connect to database!
2006-04-14 09:24:44.587 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user 'digweed'@'localhost' (using password: YES)

2006-04-14 09:24:44.587 Failed to init MythContext, exiting.

mysql> SET PASSWORD FOR 'digweed'@'localhost'=alariaug('betchawontguessit'); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'alariaug('betchawontguessit')' at line 1

kas seda kuidgi inimlikumalt ei saagi tööle?st.mul on vaja vaadata ainult tv-kaardiga TVd mitte midagi muud.MySQL,mingid databased jms.pahna

milleks see veel vajalik on

digweed · Postitus Postitas **digweed** » 08.07.2006, 10:43

ikka ei saa tööle
teen selle õpetuse järgi
http://gentoo-wiki.com/HOWTO_Setup_MythTV
# /etc/init.d/mysql start
* ...
* MySQL datadir is empty or invalid
* Please check your my.cnf : /etc/mysql/my.cnf
mida krt.ma sinna my.cnfi kirjutan.proovisin küll määrata passwd.

# mysql -u root -p < /usr/share/mythtv/database/mc.sql
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

#mythtv-setup küsib minu passwd jms.kuid mitte midagi ei toimu
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-07-08 10:43:01.117 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
2006-07-08 10:43:01.169 Failed to init MythContext, exiting.
MySQL ja muus ellien pa.k ei ole vajalik.vaja ainult tv-tuner tööle saada

pacho · Postitus Postitas **pacho** » 08.07.2006, 10:55

digweed, KnoppMyth

Postitus Postitas **spott** » 08.07.2006, 10:58

sul MySQL ei tööta ju. Tänu sellele ei saa sa määrata parooli ja otse loomulikult ei saa sa ka MytTV-d tööle.

Anna oma my.cnf conf faili sisu.

digweed · Postitus Postitas **digweed** » 08.07.2006, 11:04

http://www.zone.ee/digweed/stuff/mysql.txt

Postitus Postitas **spott** » 08.07.2006, 11:22

Proovi:
eselect version
vaata, mis versiooni annab ja siis anna see number talle ette:
eselect mysql set versiooni number.
Näiteks eselect 1.0_rc2 puhul paned:
eselect mysql set 1
vajadusel paigalda: eselect-mysql

või siis võid lihtsalt proovida MySQL-i uuesti confida:
emerge --config mysql

pacho · Postitus Postitas **pacho** » 08.07.2006, 11:41

[ot]
digweed, kui see saladus pole mis failisüsteemi sa mythtv'ga kasutad
[/ot]

digweed · Postitus Postitas **digweed** » 08.07.2006, 11:49

/ ext3
/home reiser4
paigaldasin eselect-mysql

eselect version
eselect 1.0

eselect mysql set 1 või 1.0
!!! Error: I don't recognise that version of MYSQL
exiting.

emerge --config mysql tegin läbi ja määürasin passwd

pacho · Postitus Postitas **pacho** » 08.07.2006, 12:13

mythtv.org kirjutas:MythTV creates large files, many in excess of 4GB. You must use a 64 or 128 bit filesystem. These will allow you to create large files. Filesystems known to have problems with large files are FAT (all versions), and ReiserFS (versions 3 and 4). The ext3 filesystem can be made to work but requires great care in how you format and mount the volume.

Because MythTV creates very large files, a filesystem that does well at deleting large files is important. Numerous benchmarks show that XFS and JFS do very well at this task. You are strongly encouraged to consider one of these for your MythTV filesystem. JFS is the absolute best at deletion, so you may want to try it if XFS gives you problems.

NOTE: You must not use ReiserFS v3 for your recordings. You will get corrupted recordings if you do.

Because of the size of the MythTV files, it may be useful to plan for future expansion right from the beginning. If your case and power supply have the capacity for additional hard drives, read through the LVM and Advanced Partition Formatting sections for some pointers.

Anna igatahes teada kuidas reiser4'ga töötab.
Minul läks ReiserFS 3'ga asi sinna kus päike ei paista

Postitus Postitas **spott** » 08.07.2006, 12:23

Mis versioon MySQL-ist sul üldse on?

digweed · Postitus Postitas **digweed** » 08.07.2006, 12:27

5.0.22

Postitus Postitas **spott** » 08.07.2006, 12:55

eselect mysql set 5.0.22

digweed · Postitus Postitas **digweed** » 08.07.2006, 13:16

proovitud.
+proovitud eselect mysql set 5
sama error

Postitus Postitas **spott** » 08.07.2006, 13:33

mysql_install_db
oled käivitanud?
mythtv meilinglistist leidsin Gentoo jaoks soovituse kasutada 4.1 seeria MySQL-i.

digweed · Postitus Postitas **digweed** » 08.07.2006, 14:25

mysql_install_db
Installing all prepared tables
Fill help tables

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h gentoo password 'new-password'
See the manual for more instructions.

NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd /usr ; /usr/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at http://shop.mysql.com

mida edasi?