<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.6000.16587" name=GENERATOR></HEAD>
<BODY
style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space">
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
mythtv-users-bounces@mythtv.org [mailto:mythtv-users-bounces@mythtv.org] <B>On
Behalf Of </B>Brad DerManouelian<BR><B>Sent:</B> Thursday, March 13, 2008
11:59 AM<BR><B>To:</B> Discussion about mythtv<BR><B>Subject:</B> Re:
[mythtv-users] can't get into mythweb<BR><BR></FONT></DIV>
<DIV>
<DIV>On Mar 13, 2008, at 11:48 AM, Steve Peters - Priority Electronics
wrote:</DIV><BR class=Apple-interchange-newline>
<BLOCKQUOTE type="cite">
<DIV>
<DIV><SPAN class=110154518-13032008><FONT face=Arial size=2>Hello all, i
can't get into mythweb. I was discussing the top under another form topic,
but it just didn't fit the topic.</FONT></SPAN></DIV>
<DIV><SPAN class=110154518-13032008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=110154518-13032008><FONT face=Arial size=2>I am able to get
into mythfrontend just fine, and i have php myadmin setup (locally) and it
get's in no prob using the root's account and password. However, i noticed
that i can't get into mysql from the command line using the same mythtv user
or the root user. So i am thinking that my mythweb problem is related to
that somehow.</FONT></SPAN></DIV>
<DIV><SPAN class=110154518-13032008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=110154518-13032008><FONT face=Arial size=2>Right now, when
i open up my mythweb url in my browser, it asks for the user and pass, so my
apache settings are somewhat correct, then i get in and get this
message:</FONT></SPAN></DIV>
<DIV><SPAN class=110154518-13032008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV id=message>
<H2>Database Access Denied</H2>
<P>You are most likely receiving this message because you<BR>have failed to
configure mythweb's database login info. </P>
<P>Please see INSTALL for instructions. </P></DIV>
<DIV><SPAN class=110154518-13032008><FONT face=Arial size=2>I have check
over the install instructions like 20 times. I just am
lost.</FONT></SPAN></DIV>
<DIV><SPAN class=110154518-13032008><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=110154518-13032008><FONT face=Arial size=2>Please
advise</FONT></SPAN></DIV>
<DIV><SPAN class=110154518-13032008><FONT face=Arial
size=2>-Thanks</FONT></SPAN></DIV>
<DIV><SPAN class=110154518-13032008><FONT face=Arial
size=2>-Steve</FONT></SPAN></DIV></DIV></BLOCKQUOTE><BR></DIV>
<DIV>You are likely not allowing mysql connections from the hostname that
apache is reporting. If you don't know your hostname, check your mysql/apache
logs to see why it's denying access.</DIV>
<DIV>Or it could be something as simple as using the wrong password (assuming
you've changed it from the default "mythtv" you need to also change it in your
config file for apache.</DIV>
<DIV><BR class=webkit-block-placeholder></DIV>
<DIV>mysql> grant all privileges on mythconverg.* to mythtv@"hostname"
identified by 'mythtv_password' with grant option;</DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT><FONT face=Arial
color=#0000ff size=2></FONT><FONT face=Arial color=#0000ff size=2></FONT><FONT
face=Arial color=#0000ff size=2></FONT><FONT face=Arial color=#0000ff
size=2></FONT><FONT face=Arial color=#0000ff size=2></FONT><BR
class=webkit-block-placeholder></DIV>
<DIV>will likely fix your problem.</DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT><FONT face=Arial
color=#0000ff size=2></FONT><BR class=webkit-block-placeholder></DIV>
<DIV>-Brad</DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT><BR
class=webkit-block-placeholder> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff size=2>OK,
i tried literally doing this at the command line:</FONT></SPAN></DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=403460921-13032008>
<DIV>mysql> grant all privileges on mythconverg.* to mythtv@"hostname"
identified by 'mythtv_password' with grant option;</DIV>
<DIV> </DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff
size=2>didn't get an error or anything, but it didn't work. About 3 weeks ago
i was using mythweb just fine when i had the ubuntu packages for mythtv
installed. I then decided, how bout I go and build it from the svn so i can
learn to do some linux building (I'm still pretty new to linux). Since then my
mythweb has not worked, though i got the rest of myth working just fine (so
far).</FONT></SPAN></DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff size=2>OK,
also, i was just able to get into mysql using the root user. I'm not sure why
it didn't work before. Using the mythtv user does not work still. Also, i
found this command on the mythtv site:</FONT></SPAN></DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff
size=2>mysql> UPDATE user SET Password=PASSWORD('mythtv') WHERE
user='mythtv';<BR>mysql> FLUSH PRIVILEGES;<BR>mysql>
quit</FONT></SPAN></DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff size=2>But
after running the first line i get this message:</FONT></SPAN></DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff
size=2>ERROR 1046 (3D000) : No database selected</FONT></SPAN></DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff size=2>So i
tried to log into the mysql database not the mythconverg database, and got
this error when trying the same commands:</FONT></SPAN></DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff
size=2>Query OK, 2 rows affected (0.00 sec)</FONT></SPAN></DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff size=2>Rows
matched: 4 Changed: 2 Warnings: 0</FONT></SPAN></DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff size=2>I
think that means it was successful...but i could be wrong.</FONT></SPAN></DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff
size=2>Mythweb is still not working though and i get the exact same database
access denied error.</FONT></SPAN></DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff size=2>I
really don't even think it's this, but I'm out of options at this point so
that's why i'm trying to just change the password. My frontends have no
problem connecting with the default mythtv user passwords.</FONT></SPAN></DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff size=2>Any
other ideas at what this issue could be?</FONT></SPAN></DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff
size=2>-Thanks</FONT></SPAN></DIV>
<DIV><SPAN class=403460921-13032008><FONT face=Arial color=#0000ff
size=2>-Steve</FONT></SPAN></DIV></SPAN></DIV></BLOCKQUOTE></BODY></HTML>