<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.14.1">
</HEAD>
<BODY>
On Fri, 2007-04-20 at 00:50 -0500, Mitch Gore wrote:<BR>
<BLOCKQUOTE TYPE=CITE>
<FONT COLOR="#000000">I am trying to use Jarod's guide to set up mythweb so when i put my machines name in the address bar it takes me right to mythweb.</FONT><BR>
<BR>
<FONT COLOR="#000000">Here are his instructions:</FONT><BR>
<BR>
<BLOCKQUOTE>
<FONT COLOR="#000000">Personally, I don't plan on using the web server on this box for anything *but* MythWeb, so I opted to move everything in /var/www/html/mythweb/ to /var/www/html/ and remove the mythweb folder, so I get to MythWeb with just <A HREF="http://htpc/">http://htpc/</A> (htpc is the hostname for MythTV box). Alternatively, Zachary Hamm suggests creating an index.php file in /var/www/html/, containing the following to achieve the same effect:</FONT><BR>
<BR>
</BLOCKQUOTE>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BLOCKQUOTE>
<FONT COLOR="#000000"><?php header("Location: /mythweb"); ?></FONT>
</BLOCKQUOTE>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BLOCKQUOTE>
<FONT COLOR="#000000">This works better for those who also run other web-based apps on their MythTV box (like phpMyAdmin, for example), and keeps the apache doc root a bit tidier.</FONT><BR>
<BR>
</BLOCKQUOTE>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
<FONT COLOR="#000000">I want to use the php forward method. But when i do all I see is a blank white page. If i run "/usr/sbin/setsebool -P httpd_can_network_connect=1" like the guide says it says that SELinux is disabled (what i want) </FONT><BR>
<BR>
<FONT COLOR="#000000">Why is it doing this? If i remove the index.html file I see the Apache test page. And if i put the /mythweb after the address i can use mythweb.</FONT><BR>
<BR>
<BLOCKQUOTE>
<FONT COLOR="#000000">[root@Mitchell_mc html]# ls</FONT><BR>
<FONT COLOR="#000000">mythweb</FONT><BR>
<FONT COLOR="#000000">[root@Mitchell_mc html]# echo "<?php header("Location: /mythweb"); ?>" > index.html</FONT><BR>
<FONT COLOR="#000000">[root@Mitchell_mc html]# ls</FONT><BR>
<FONT COLOR="#000000">index.html mythweb</FONT><BR>
<FONT COLOR="#000000">[root@Mitchell _mc html]# </FONT><BR>
</BLOCKQUOTE>
<BR>
<BR>
<FONT COLOR="#000000">Thanks,</FONT><BR>
<FONT COLOR="#000000">Mitchell</FONT><BR>
<FONT COLOR="#000000"> </FONT>
</BLOCKQUOTE>
<BLOCKQUOTE TYPE=CITE>
<BR>
<BR>
<PRE>
<FONT COLOR="#000000">_______________________________________________</FONT>
<FONT COLOR="#000000">mythtv-users mailing list</FONT>
<FONT COLOR="#000000"><A HREF="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</A></FONT>
<FONT COLOR="#000000"><A HREF="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</A></FONT>
</PRE>
</BLOCKQUOTE>
<BR>
There may be a more elegant solution, but here's what I did when I accidentally deleted the MySQL root account once (!).<BR>
<BR>
Use the following command to dump your database to disk.<BR>
<BR>
<I>mysqldump -u mythtv -p mythconverg -c > mythtv_backup.sql</I><BR>
<BR>
In Ubuntu, I just go into Synaptic and tell it to "Completely remove" the MySQL server. This basically strips everything MySQL server off the system including configuration files.<BR>
<BR>
Now, reinstall MySQL server - you'll have a clean slate. Change the root password to "password" or something else easy to remember. =P<BR>
<BR>
Now use the following commands to restore your database.<BR>
<BR>
<I>$ mysql -u root -p</I><BR>
<I> mysql>create database mythconverg;</I><BR>
<I> mysql>exit</I><BR>
<I>$ mysql -u mythtv -p mythconverg < mythtv_backup.sql</I>
<PRE>
That should restore your data correctly and give you a fresh database with a root password you know.
Good luck!
-Keller
Reference : <A HREF="http://www.mythtv.org/wiki/index.php/User_Manual:Periodic_Maintenance">http://www.mythtv.org/wiki/index.php/User_Manual:Periodic_Maintenance</A>
</PRE>
</BODY>
</HTML>