<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18812">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2 face=Arial>
<DIV><FONT size=2 face=Arial>I fixed it</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>ASUS eeePC 1008HA</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>+ re-install openSUSE 11.1 </FONT></DIV>
<DIV><FONT size=2 face=Arial>+ disable online repos and updates</FONT></DIV>
<DIV><FONT size=2 face=Arial>+ install mysql</FONT></DIV>
<DIV><FONT size=2 face=Arial>+ install apache2</FONT></DIV>
<DIV><FONT size=2 face=Arial>+ install PHP</FONT></DIV>
<DIV><FONT size=2 face=Arial>+ install kernel-source</FONT></DIV>
<DIV><FONT size=2 face=Arial>+ install gcc and make</FONT></DIV>
<DIV><FONT size=2 face=Arial>+ changed PHP to short tags </FONT></DIV>
<DIV><FONT size=2 face=Arial>+ turned on PHP globals</FONT></DIV>
<DIV><FONT size=2 face=Arial>+ installed LAN drivers</FONT></DIV>
<DIV><FONT size=2 face=Arial>+ configure LAN, IP DNS ROUTE DEFAULT
GW</FONT></DIV>
<DIV><FONT size=2 face=Arial>+ connected to net</FONT></DIV>
<DIV><FONT size=2 face=Arial>+ turned on mysql and apache2 and saved
run-levels</FONT></DIV>
<DIV><FONT size=2 face=Arial>+ add crontab jobs</FONT></DIV>
<DIV><FONT size=2 face=Arial>+ installed XASTIR and PREDICT</FONT></DIV>
<DIV><FONT size=2 face=Arial>+ added imagemagick etc for XASTIR</FONT></DIV>
<DIV><FONT size=2 face=Arial>+ modify defaul apache2 setup</FONT></DIV>
<DIV><FONT size=2 face=Arial>+ add samba</FONT></DIV>
<DIV><FONT size=2 face=Arial>
<DIV><FONT size=2 face=Arial>+ copied back web pages and scripts</FONT></DIV>
<DIV>
<DIV><FONT size=2 face=Arial>+ added no-ip.org binary</FONT></DIV>
<DIV>+ added ssh service</DIV>
<DIV>+ install perl DBD</DIV>
<DIV>+ install PHP mysql</DIV>
<DIV>+ restart apache2</DIV>
<DIV> </DIV>
<DIV>Andrew VK4TEC</DIV></DIV></FONT></DIV></FONT></DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<A title=vk4tec@tech-software.net
href="mailto:vk4tec@tech-software.net">Andrew Rich</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=vk4tec@tech-software.net
href="mailto:vk4tec@tech-software.net">Andrew Rich</A> ; <A
title=aprssig@tapr.org href="mailto:aprssig@tapr.org">TAPR APRS Mailing
List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Sunday, October 04, 2009 12:49
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [aprssig] MySQL dramas</DIV>
<DIV><BR></DIV>
<DIV><FONT size=2 face=Arial>interesting</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>From DVD the installed version was </FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>5.0.67-12:11</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>The online update installed</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>5.0.67-12:16.1 when the probs
started</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<A title=vk4tec@tech-software.net
href="mailto:vk4tec@tech-software.net">Andrew Rich</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=aprssig@tapr.org
href="mailto:aprssig@tapr.org">TAPR APRS Mailing List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Sunday, October 04, 2009 4:26
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [aprssig] MySQL dramas</DIV>
<DIV><BR></DIV>
<DIV><FONT size=2 face=Arial>Hello</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>I built a LINUX box for satellite tracking and
APRS type stuff</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>All was going well, until the box did an
update</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Seems now I have no entry in the mysql.user
table.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>I get the error "Access denied for user <A
href="mailto:'root'@'localhost'">'root'@'localhost'</A> using PASSWORD:
NO</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>I managed to jump in without using grant
options, and was able to see a blank user table.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Can anyone suggest how to fix ? I tried
uninstall and re-install same problem.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>The only way I fixed it before was to re-build
from scratch, not real fun.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>I think what I need to do is get the root user
back into the system</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Andrew VK4TEC</FONT></DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>aprssig mailing
list<BR>aprssig@tapr.org<BR>https://www.tapr.org/cgi-bin/mailman/listinfo/aprssig<BR>
<P>
<HR>
<P></P><BR>No virus found in this incoming message.<BR>Checked by AVG -
www.avg.com <BR>Version: 8.5.409 / Virus Database: 270.14.3/2411 - Release
Date: 10/03/09 06:20:00<BR></BLOCKQUOTE>
<P>
<HR>
<P></P><BR>No virus found in this incoming message.<BR>Checked by AVG -
www.avg.com <BR>Version: 8.5.420 / Virus Database: 270.14.3/2412 - Release
Date: 10/03/09 18:34:00<BR></BLOCKQUOTE></BODY></HTML>