<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:D="DAV:" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:st="" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="State"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:Verdana;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3 face=Verdana><span
style='font-size:12.0pt'>Hi,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face=Verdana><span style='font-size:12.0pt'>I get<font
color=navy><span style='color:navy'> </span></font>the following error while
doing a fresh install and setup of backend and frontend on the same PC:<br>
<br>
QMYSQL3: Unable to connect<br>
QMYSQL3: Can't connect to MySQL server on 'bains-homepc' (111)<br>
<br>
<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face=Verdana><span style='font-size:12.0pt'>I
also changed the DBHostName=localhost to the name of the local PC but came
across the same issue.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face=Verdana><span style='font-size:12.0pt'><br>
I checked permissions on mythconverg database for user 'mythtv' to<br>
ensure I could not login and query the database to rule out access issues.<br>
<br>
During one purge and reinstall cycle I got access denied for mythtv user<br>
so I granted permissions using the command below:<br>
<br>
mysql> grant all on mythconverg.* to mythtv@"<a href="http://192.168.1."
target="_blank" title="http://192.168.1.">192.168.1.</a>%" identified by
"mythtv";<br>
mysql> flush privileges;<br>
Query OK, 0 rows affected (0.00 sec)<br>
<br>
** Attachment added: "Screenshots and log of installation."<br>
<a href="http://launchpadlibrarian.net/17663277/mythtv_dberr3.zip"
target="_blank" title="http://launchpadlibrarian.net/17663277/mythtv_dberr3.zip">http://launchpadlibrarian.net/17663277/mythtv_dberr3.zip</a><br>
<br>
<br>
<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face=Verdana><span style='font-size:12.0pt'>I
also posted this to bug 243504<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face=Verdana><span style='font-size:12.0pt'>--<br>
mythtv-setup: unable to connect to database<br>
<a href="https://bugs.launchpad.net/bugs/243504" target="_blank"
title="https://bugs.launchpad.net/bugs/243504">https://bugs.launchpad.net/bugs/243504</a><br>
You received this bug notification because you are a direct subscriber<br>
of the bug.<br>
<br>
Status in "mythtv" source package in Ubuntu: New<br>
<br>
Bug description:<br>
Binary package hint: mythtv-backend<br>
<br>
$ dpkg -l mythtv-backend<br>
ii mythtv-backend 0.21.0+fixes16838-0 A personal
video recorder application (server)<br>
<br>
$ lsb_release -rd<br>
Description: Ubuntu 8.04<br>
Release: 8.04<br>
<br>
what happens - I cannot complete the configuration of mythtv with mythtv-setup.
This appears to be because the mysql database is not fully populated.<br>
<br>
what should happen - I should be able to set up mythtv.<br>
<br>
Background information<br>
$ id<br>
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)<br>
<br>
$ sudo /etc/init.d/mysql status<br>
* /usr/bin/mysqladmin Ver 8.41 Distrib 5.0.51a, for
debian-linux-gnu on i486<br>
Copyright (C) 2000-2006 <st1:place w:st="on"><st1:City w:st="on">MySQL</st1:City>
<st1:State w:st="on">AB</st1:State></st1:place><br>
This software comes with ABSOLUTELY NO WARRANTY. This is free software,<br>
and you are welcome to modify and redistribute it under the GPL license<br>
<br>
Server version 5.0.51a-3ubuntu5.1<br>
Protocol version 10<br>
Connection Localhost via UNIX
socket<br>
UNIX socket
/var/run/mysqld/mysqld.sock<br>
Uptime: 1 hour 25 min
56 sec<br>
<br>
Threads: 1 Questions: 43 Slow queries: 0 Opens: 23
Flush tables: 1 Open tables: 17 Queries per second avg: 0.008<br>
<br>
$ ps -fade|grep myth<br>
mythtv 8983 1 0 22:22 ?
00:00:06 /usr/bin/mythbackend --daemon --logfile
/var/log/mythtv/mythbackend.log --pidfile /var/run/mythtv/mythbackend.pid<br>
vjm 9178 6809 0 22:34 pts/0
00:00:00 grep myth<br>
<br>
What I tried to do:<br>
<br>
$ mythtv-setup<br>
(I get a popup asking to close any running mythbackends. I say OK)<br>
<br>
(I get a small xterm with error messages in it, saying unable to connect to
database.<br>
Could not capture this for you, because a fullscreen display suddenly appears)<br>
The fullscreen display prompts for things like database name, user , password.<br>
I left these as defaults, and hit <return> immediately.<br>
(Oh, and it shows "No UPnP devices available", to which I say
"OK" since there is nothing else to say.<br>
<br>
On the original terminal I get:<br>
* Stopping MythTV server: mythbackend
[ OK ]<br>
* Restarting MythTV server: mythbackend
No /usr/bin/mythbackend found running; none
killed.<br>
[ OK ]<br>
<br>
(I get another popup, would you like to run mythfilldatabase?) <cancel><br>
<br>
yet, I am able to connect to mysql as mythv@localhost, with no password.<br>
$ mysql -u mythtv@localhost<br>
Welcome to the MySQL monitor. Commands end with ; or \g.<br>
Your MySQL connection id is 87923<br>
Server version: 5.0.51a-3ubuntu5.1 (Ubuntu)<br>
<br>
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.<br>
<br>
mysql> show databases;<br>
+--------------------+<br>
| Database |<br>
+--------------------+<br>
| information_schema |<br>
+--------------------+<br>
1 row in set (0.00 sec)<br>
mysql> use mythconverg;<br>
ERROR 1044 (42000): Access denied for user ''@'localhost' to database
'mythconverg'<br>
mysql> quit<br>
Bye<br>
<br>
I checked for .my.cnf files and so forth, could find none in my home dir nor in
/home/mythtv.<br>
The closest thing was the .mythtv/mysql.txt file;<br>
<br>
$ grep -v ^# /home/mythtv/.mythtv/mysql.txt<br>
DBHostName=localhost<br>
<br>
DBHostPing=no<br>
<br>
DBUserName=mythtv<br>
DBName=mythconverg<br>
DBType=<br>
<br>
<br>
DBPassword=<font color=navy><span style='color:navy'>***********</span></font><br>
<br>
$ sudo dpkg-reconfigure mythtv<br>
< does nothing.><br>
<br>
$ sudo dpkg-reconfigure mythtv-backend<br>
<answer NO to create v4l device nodes><br>
Then it asks me to run mythtv-setup. oh. Well that's going to be a problem.<br>
Then I have to start mythtv-backend again.<br>
<br>
Try that anyway:<br>
$ /etc/init.d/mythtv-backend stop<br>
$ /etc/init.d/mythtv-backend start<br>
(no errors, let's stop again)<br>
$ /etc/init.d/mythtv-backend stop<br>
$ mythtv-setup<br>
does not seem to help.</span></font><font face="Times New Roman"><span
style='font-family:"Times New Roman"'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face=Verdana><span style='font-size:12.0pt'><br>
Any help would be appreciated.</span></font><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face=Verdana><span style='font-size:12.0pt'><br
clear=all>
<br>
-- <br>
Regards,<br>
Gurvinder Singh<br>
<br>
"God's gifts put man's best dreams to shame." - Elizabeth Barrett
Browning</span></font><font face="Times New Roman"><span style='font-family:
"Times New Roman"'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
</div>
</body>
</html>