No subject
Sun Mar 1 18:40:12 UTC 2009
mysql -u mythtv -pMYPASSWORD -h debtest mythconverg
I get
ERROR 1045 (28000): Access denied for user 'mythtv'@'debtest' (using password:
YES)
But the exact same command works perfectly from a different machine.
Seems like a mysql configuration thingy to me. It will only accept
connections from the same computer over loopback, not the network to self.
Anyone have any ideas what to do next?
Mark
--Boundary_(ID_UtRkxYgCyRfoDX8o0dRf9w)
Content-type: text/html; charset=iso-8859-1
Content-transfer-encoding: 7BIT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN" "http://www.w3.org/TR/REC-html40/strict.dtd"><html><head><meta name="qrichtext" content="1" /><style type="text/css">p, li { white-space: pre-wrap; }</style></head><body style=" font-family:'Georgia'; font-size:12pt; font-weight:400; font-style:normal;">On June 5, 2009, Brian Wood wrote:<br>
> On Friday 05 June 2009 12:05:38 Mark J. Small wrote:<br>
> > Hi everybody,<br>
> ><br>
> > I'm trying to use the upnp features of mythtv to serve my music and<br>
> > pictures. I'm using the 0.21 packages from the stable tree of<br>
> > debian-multimedia.org on a Debian Stable system.<br>
> ><br>
> > I've installed djmount on a separate machine, and it does not see any<br>
> > upnp servers on my internal network.<br>
> ><br>
> > I've read the the ip address (not localhost), must be entered in to the<br>
> > backend for upnp to work properly. Well Mythtv-setup has the proper ip<br>
> > address entered, but the setup->general screen in mythfrontend points to<br>
> > localhost. If I try to change this, then I can no longer connect to the<br>
> > database, and the backend will not restart either.<br>
> ><br>
> > I've used nmap to check the standard upnp ports, but tcp 5000, 1900 and<br>
> > udp 1900 are all closed.<br>
> ><br>
> > Does anyone have any advice?<br>
><br>
> You need to have the real IP in both locations in your setup. I guess this<br>
> means figuring out why things don't work when you set things up that way.<br>
><br>
> I entered the real IP of a combined FE/BE machine in both locatons in the<br>
> setup, once I did that the UPnP server function worked fine.<br>
><br>
> Even if you could get the UPnP functions running with "localhost" you would<br>
> still have a problem, because the URLs that your UPnP control point tried<br>
> to go to would contain the localhost address, which would obviously not<br>
> work.<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>So I'm trying to set the host to the real IP address in both locations, but when I do, I can't connect to the database anymore. I get this:<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>QMYSQL3: Unable to connect<br>
Database error was:<br>
Access denied for user 'mythtv'@'debtest' (using password: YES)<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>where debtest is the name of my backend.<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Hmm,<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>This really looks like a mysql problem now, but if I check the grants, I see <br>
mysql> show grants for mythtv@"%";<br>
+-------------------------------------------------------------------------------------------------------+<br>
| Grants for mythtv@% |<br>
+-------------------------------------------------------------------------------------------------------+<br>
| GRANT USAGE ON *.* TO 'mythtv'@'%' IDENTIFIED BY PASSWORD 'deleted' | <br>
| GRANT ALL PRIVILEGES ON `mythconverg`.* TO 'mythtv'@'%' |<br>
+<br>
I deleted the password hash from this mail just in case..<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Looks like anybody called mythtv should be able to connect from any machine.<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>So this test is the kicker:<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>From my backend if I do:<br>
mysql -u mythtv -pMYPASSWORD -h debtest mythconverg<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>I get <br>
ERROR 1045 (28000): Access denied for user 'mythtv'@'debtest' (using password: YES)<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>But the exact same command works perfectly from a different machine.<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Seems like a mysql configuration thingy to me. It will only accept connections from the same computer over loopback, not the network to self.<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p><p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Anyone have any ideas what to do next?<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p>Mark<br>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><br></p></body></html>
--Boundary_(ID_UtRkxYgCyRfoDX8o0dRf9w)--
More information about the mythtv-users
mailing list