Vince McIntyre wrote: > $ sudo aptitude --purge remove mythtv-database > Reading package lists... Done > Building dependency tree > Reading state information... Done > Reading extended state information > Initializing package states... Done > Building tag database... Done > The following packages are BROKEN: > mythtv > The following packages will be REMOVED: > mythtv-database > 0 packages upgraded, 0 newly installed, 1 to remove and 0 not upgraded. > Need to get 0B of archives. After unpacking 279kB will be freed. > The following packages have unmet dependencies: > mythtv: Depends: mythtv-database (= 0.21.0+fixes16838-0ubuntu3.1) but it is not installable > Resolving dependencies... > The following actions will resolve these dependencies: > > Remove the following packages: > mythtv > > Score is 119 > > Accept this solution? [Y/n/q/?] > The following packages are unused and will be REMOVED: > libfame-0.9{p} libhtml-template-perl{p} liblzo1{p} libmjpegtools0c2a{p} > libpvm3{p} mjpegtools{p} mysql-server{p} mysql-server-5.0{p} > mythtv-backend{p} mythtv-themes{p} mythtv-transcode-utils{p} ntp{p} > pvm{p} toolame{p} transcode{p} transcode-doc{p} > The following packages will be automatically REMOVED: > mythtv > The following packages will be REMOVED: > mythtv mythtv-database > 0 packages upgraded, 0 newly installed, 18 to remove and 0 not upgraded. > Need to get 0B of archives. After unpacking 101MB will be freed. > Do you want to continue? [Y/n/?] > Writing extended state information... Done > (Reading database ... 150712 files and directories currently installed.) > Removing mythtv ... > (Reading database ... 150703 files and directories currently installed.) > Removing mythtv-backend ... > * Stopping MythTV server: mythbackend [ OK ] > Purging configuration files for mythtv-backend ... > Removing mythtv-transcode-utils ... > Removing transcode ... > Removing libfame-0.9 ... > Purging configuration files for libfame-0.9 ... > Removing libhtml-template-perl ... > Removing liblzo1 ... > Purging configuration files for liblzo1 ... > Removing mjpegtools ... > Removing libmjpegtools0c2a ... > Purging configuration files for libmjpegtools0c2a ... > Removing pvm ... > Removing libpvm3 ... > Removing mysql-server ... > Removing mysql-server-5.0 ... > * Stopping MySQL database server mysqld [ OK ] > Purging configuration files for mysql-server-5.0 ... > Processing triggers for libc6 ... > ldconfig deferred processing now taking place > (Reading database ... 148202 files and directories currently installed.) > Removing mythtv-database ... > (Reading database ... 148189 files and directories currently installed.) > Removing mythtv-themes ... > Removing ntp ... > * Stopping NTP server ntpd [ OK ] > Purging configuration files for ntp ... > Removing toolame ... > Removing transcode-doc ... > Reading package lists... Done > Building dependency tree > Reading state information... Done > Reading extended state information > Initializing package states... Done > Writing extended state information... Done > Building tag database... Done > > (I said 'yes' when prompted about removing all mysql databases.) > > ~$ sudo aptitude install mythtv > Reading package lists... Done > Building dependency tree > Reading state information... Done > Reading extended state information > Initializing package states... Done > Building tag database... Done > The following NEW packages will be automatically installed: > libfame-0.9 libhtml-template-perl liblzo1 libmjpegtools0c2a libpvm3 > mjpegtools mysql-server mysql-server-5.0 mythtv-backend mythtv-themes > mythtv-transcode-utils ntp pvm toolame transcode transcode-doc > The following NEW packages will be installed: > libfame-0.9 libhtml-template-perl liblzo1 libmjpegtools0c2a libpvm3 > mjpegtools mysql-server mysql-server-5.0 mythtv mythtv-backend > mythtv-themes mythtv-transcode-utils ntp pvm toolame transcode > transcode-doc > 0 packages upgraded, 17 newly installed, 0 to remove and 0 not upgraded. > Need to get 0B/33.3MB of archives. After unpacking 101MB will be used. > Do you want to continue? [Y/n/?] > Writing extended state information... Done > Preconfiguring packages ... > Selecting previously deselected package mysql-server-5.0. > (Reading database ... 148071 files and directories currently installed.) > Unpacking mysql-server-5.0 (from .../mysql-server-5.0_5.0.51a-3ubuntu5.1_i386.deb) ... > Selecting previously deselected package libfame-0.9. > Unpacking libfame-0.9 (from .../libfame-0.9_0.9.1-0.2_i386.deb) ... > Selecting previously deselected package liblzo1. > Unpacking liblzo1 (from .../liblzo1_1.08-3_i386.deb) ... > Selecting previously deselected package libmjpegtools0c2a. > Unpacking libmjpegtools0c2a (from .../libmjpegtools0c2a_1%3a1.8.0-0.2ubuntu5_i386.deb) ... > Selecting previously deselected package libpvm3. > Unpacking libpvm3 (from .../libpvm3_3.4.5-10_i386.deb) ... > Selecting previously deselected package transcode. > Unpacking transcode (from .../transcode_2%3a1.0.2-0.8ubuntu7_i386.deb) ... > Selecting previously deselected package mythtv-transcode-utils. > Unpacking mythtv-transcode-utils (from .../mythtv-transcode-utils_0.21.0+fixes16838-0ubuntu3.1_i386.deb) ... > Selecting previously deselected package mythtv-backend. > Unpacking mythtv-backend (from .../mythtv-backend_0.21.0+fixes16838-0ubuntu3.1_i386.deb) ... > Selecting previously deselected package ntp. > Unpacking ntp (from .../ntp_1%3a4.2.4p4+dfsg-3ubuntu2_i386.deb) ... > Setting up mysql-server-5.0 (5.0.51a-3ubuntu5.1) ... > * Stopping MySQL database server mysqld [ OK ] > Reloading AppArmor profiles : done. > * Starting MySQL database server mysqld [ OK ] > * Checking for corrupt, not cleanly closed and upgrade needing tables. > > Selecting previously deselected package mythtv. > (Reading database ... 150477 files and directories currently installed.) > Unpacking mythtv (from .../mythtv_0.21.0+fixes16838-0ubuntu3.1_all.deb) ... > Selecting previously deselected package libhtml-template-perl. > Unpacking libhtml-template-perl (from .../libhtml-template-perl_2.9-1_all.deb) ... > Selecting previously deselected package mjpegtools. > Unpacking mjpegtools (from .../mjpegtools_1%3a1.8.0-0.2ubuntu5_i386.deb) ... > Selecting previously deselected package mysql-server. > Unpacking mysql-server (from .../mysql-server_5.0.51a-3ubuntu5.1_all.deb) ... > * Stopping MySQL database server mysqld [ OK ] > Selecting previously deselected package mythtv-themes. > Unpacking mythtv-themes (from .../mythtv-themes_0.21.0-0ubuntu2_all.deb) ... > Selecting previously deselected package toolame. > Unpacking toolame (from .../toolame_02l-6_i386.deb) ... > Selecting previously deselected package pvm. > Unpacking pvm (from .../archives/pvm_3.4.5-10_i386.deb) ... > Selecting previously deselected package transcode-doc. > Unpacking transcode-doc (from .../transcode-doc_2%3a1.0.2-0.8ubuntu7_all.deb) ... > Setting up libfame-0.9 (0.9.1-0.2) ... > > Setting up liblzo1 (1.08-3) ... > > Setting up libmjpegtools0c2a (1:1.8.0-0.2ubuntu5) ... > > Setting up libpvm3 (3.4.5-10) ... > > Setting up transcode (2:1.0.2-0.8ubuntu7) ... > Setting up mythtv-transcode-utils (0.21.0+fixes16838-0ubuntu3.1) ... > Setting up mythtv-backend (0.21.0+fixes16838-0ubuntu3.1) ... > udev active, devices will be created in /dev/.static/dev/ > * Starting MythTV server: mythbackend [ OK ] > > Setting up ntp (1:4.2.4p4+dfsg-3ubuntu2) ... > * Starting NTP server ntpd [ OK ] > > Setting up mythtv (0.21.0+fixes16838-0ubuntu3.1) ... > Setting up libhtml-template-perl (2.9-1) ... > Setting up mjpegtools (1:1.8.0-0.2ubuntu5) ... > > Setting up mysql-server (5.0.51a-3ubuntu5.1) ... > Setting up mythtv-themes (0.21.0-0ubuntu2) ... > Setting up toolame (02l-6) ... > Setting up pvm (3.4.5-10) ... > > Setting up transcode-doc (2:1.0.2-0.8ubuntu7) ... > > Processing triggers for libc6 ... > ldconfig deferred processing now taking place > Reading package lists... Done > Building dependency tree > Reading state information... Done > Reading extended state information > Initializing package states... Done > Writing extended state information... Done > Building tag database... Done > > $ id > uid=1000(vjm) gid=1000(vjm) groups=4(adm),20(dialout),24(cdrom),25(floppy),29(audio),30(dip),44(video),46(plugdev),107(fuse),110(lpadmin),120(admin),125(mysql),126(mythtv),1000(vjm) > > $ ps -fade|grep mysq > vjm 10388 6791 0 11:06 pts/0 00:00:00 grep mysq > $ sudo /etc/init.d/mysql status > * MySQL is stopped. > $ sudo /etc/init.d/mysql start > * Starting MySQL database server mysqld [ OK ] > * Checking for corrupt, not cleanly closed and upgrade needing tables. > $ sudo /etc/init.d/mysql status > * /usr/bin/mysqladmin Ver 8.41 Distrib 5.0.51a, for debian-linux-gnu on i486 > Copyright (C) 2000-2006 MySQL AB > This software comes with ABSOLUTELY NO WARRANTY. This is free software, > and you are welcome to modify and redistribute it under the GPL license > > Server version 5.0.51a-3ubuntu5.1 > Protocol version 10 > Connection Localhost via UNIX socket > UNIX socket /var/run/mysqld/mysqld.sock > Uptime: 10 sec > > Threads: 1 Questions: 172 Slow queries: 0 Opens: 132 Flush tables: 1 Open tables: 17 Queries per second avg: 17.200 > $ mysql -u root -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 606 > Server version: 5.0.51a-3ubuntu5.1 (Ubuntu) > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> show databases; > +--------------------+ > | Database | > +--------------------+ > | information_schema | > | mysql | > +--------------------+ > 2 rows in set (0.00 sec) > > mysql> quit > Bye > $ sudo dpkg-reconfigure mythtv-database > - one I had not seen before was "password for mysql administrator" > $ mysql -u root -p > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 2583 > Server version: 5.0.51a-3ubuntu5.1 (Ubuntu) > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> show databases; > +--------------------+ > | Database | > +--------------------+ > | information_schema | > | mysql | > | mythconverg | > +--------------------+ > 3 rows in set (0.00 sec) > mysql> quit > Bye > > $ mythtv-setup > now I start to get somewhere. My locale (en_AU.UTF-8) appears to be ignored but I am able to step through the mythtv-backend setup screens. I can't change some things (eg TV format is NTSC and I can't get it to highlight with the tab or arrow keys). I guess I am under way now, so this ticket can probably be > closed. > > I think the root of my problem was knowing the right sequence of configuration steps for mythtv as packaged by Ubuntu. The mythtv wiki is quite detailed but assumes you are working from their tarballs. > I looked at the /usr/share/doc/{mythtv,mythtv-backend}/README* files but could not see any "10,000 ft" overview. I eventually found /usr/share/doc/mythtv-doc/ but this appeared to be basically the same as > the wiki material. Where else should I have looked? > > The README.debian files talking about myth.rebuilddatabase.pl are too cryptic for me; > what is missing is _why one would want or need to do this. > > Perhaps it would help if there was an addiitional README.something that explained the basics in short form; > * get the hardware working > * pick somewhere to store recordings > * set up the mysql database (ie configure mythtv-database) > * run mythtv-setup to set up the backend > etc. and _then_ points people to the mythtv-howto.html > > Thanks for your help. > Vince > Well a majority of the work is supposed to be handled here by the packaging (eg install package mythtv and it does stuff for you). Can you go through the series of steps that led to the broken database? Like did you answer some of the debconf questions wrong? This is the most common problem that people encounter. If you can replay the entire process accurately, this would be best. -- Mario Limonciello