[LON-CAPA-cvs] cvs: doc /build install.html loncapasqldatabase.html /install/redhat7.3 install.pl

harris41 lon-capa-cvs@mail.lon-capa.org
Sat, 16 Nov 2002 00:57:29 -0000 

harris41		Fri Nov 15 19:57:29 2002 EDT

  Modified files:              
    /doc/build	install.html loncapasqldatabase.html 
    /doc/install/redhat7.3	install.pl 
  Log:
  bug workaround for mysql version 3.23 (49-51) which includes
  RH7.3 and RH8.0.
  
  ()*@#&$Q_)(@#*$(&_)#(@*$_)@#*($_*$@#&%_{)@#$(_#()@$*%)$(*#&)@#*$_
  @#$)(*@_)$(*@#_)($*@#%_)(*@#$_)(*@#_$)(*@#$_)(@*$_)(@#*$_)(@#*$_)@#(
  )*(#)&_+)&*#^#@$&((_#$_)(#@$*
  ARGGGH!!!!!!!!!!!!!!
  
  
  BAHHHH!!!!
  
  
  YAH YAH YAH KAWABUNGAH!!!!!!!!!!!
  
  
  AHHHHHHHHHHHHHHH
  AHHHHHHHHHHHHHHH
  AHHHHHHHHHHHHHHHHHH!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
  
  
Index: doc/build/install.html
diff -u doc/build/install.html:1.35 doc/build/install.html:1.36
--- doc/build/install.html:1.35	Fri Nov 15 18:36:58 2002
+++ doc/build/install.html	Fri Nov 15 19:57:28 2002
@@ -1,7 +1,7 @@
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 <!-- The LearningOnline Network with CAPA -->
-<!-- $Id: install.html,v 1.35 2002/11/15 23:36:58 harris41 Exp $ -->
+<!-- $Id: install.html,v 1.36 2002/11/16 00:57:28 harris41 Exp $ -->
 <html>
 <head>
 <meta http-equiv="Content-Type" content="text/html; charset=utf-8"></meta>
@@ -211,7 +211,8 @@
 mysql> INSERT INTO user (Host, User, Password)
 mysql> VALUES ('localhost','www',password('localhostkey'));
 
-mysql> GRANT ALL PRIVILEGES ON loncapa.* TO 'www@localhost';
+mysql> INSERT INTO db VALUES ('localhost','loncapa','www',
+mysql> 'Y','Y','Y','Y','Y','Y','N','Y','Y','Y');
 
 mysql> FLUSH PRIVILEGES;
 </pre>
Index: doc/build/loncapasqldatabase.html
diff -u doc/build/loncapasqldatabase.html:1.19 doc/build/loncapasqldatabase.html:1.20
--- doc/build/loncapasqldatabase.html:1.19	Fri Nov 15 18:36:58 2002
+++ doc/build/loncapasqldatabase.html	Fri Nov 15 19:57:28 2002
@@ -444,7 +444,7 @@
 Files=7,  Tests=179,  7 wallclock secs ( 6.46 cusr +  0.49 csys =  6.95 CPU)
 PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/i386-linux -I/usr/lib/perl5/5.00503 test.pl
 test.pl 
-DBI test application $Revision: 1.19 $
+DBI test application $Revision: 1.20 $
 Using /home/user/DBI-1.14/blib
 Switch: DBI 1.14 by Tim Bunce, 1.14
 Available Drivers: ADO, ExampleP, Multiplex, Proxy, mysql
@@ -557,7 +557,8 @@
 <P>
 <STRONG>Granting privileges to user 'www'</STRONG>:
 <PRE>
-GRANT ALL PRIVILEGES ON loncapa.* TO 'www@localhost';
+INSERT INTO db VALUES ('localhost','loncapa','www',
+'Y','Y','Y','Y','Y','Y','N'\,'Y','Y','Y');
 FLUSH PRIVILEGES;
 </PRE>
 </P>
Index: doc/install/redhat7.3/install.pl
diff -u doc/install/redhat7.3/install.pl:1.10 doc/install/redhat7.3/install.pl:1.11
--- doc/install/redhat7.3/install.pl:1.10	Fri Nov 15 19:01:29 2002
+++ doc/install/redhat7.3/install.pl	Fri Nov 15 19:57:29 2002
@@ -2,7 +2,7 @@
 # The LearningOnline Network 
 # Red Hat 7.3 installation script
 #
-# $Id: install.pl,v 1.10 2002/11/16 00:01:29 harris41 Exp $
+# $Id: install.pl,v 1.11 2002/11/16 00:57:29 harris41 Exp $
 #
 # Copyright Michigan State University Board of Trustees
 #
@@ -364,7 +364,8 @@
 CREATE DATABASE loncapa;
 INSERT INTO user (Host, User, Password)
 VALUES ('localhost','www',password('localhostkey'));
-GRANT ALL PRIVILEGES ON loncapa.* TO 'www\@localhost';
+INSERT INTO db VALUES ('localhost','loncapa','www',
+'Y','Y','Y','Y','Y','Y','N','Y','Y','Y');
 SET PASSWORD FOR root\@localhost=PASSWORD('$rootpass');
 DELETE FROM user WHERE host<>'localhost';
 FLUSH PRIVILEGES;