$ 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
<answer all the questions> - 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
--
mythtv-setup: unable to connect to database
https://bugs.launchpad.net/bugs/243504
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
