[LON-CAPA-cvs] cvs: doc /install/fedora install.pl

[matthew]

matthew		Wed Sep  8 17:37:06 2004 EDT

  Modified files:              
    /doc/install/fedora	install.pl 
  Log:
  MySQL configuration: use column names on the INSERT INTO db command.
  
  
Index: doc/install/fedora/install.pl
diff -u doc/install/fedora/install.pl:1.4 doc/install/fedora/install.pl:1.5
--- doc/install/fedora/install.pl:1.4	Fri Dec 19 10:12:59 2003
+++ doc/install/fedora/install.pl	Wed Sep  8 17:37:06 2004
@@ -2,7 +2,7 @@
 # The LearningOnline Network 
 # Fedora installation script
 #
-# $Id: install.pl,v 1.4 2003/12/19 15:12:59 matthew Exp $
+# $Id: install.pl,v 1.5 2004/09/08 21:37:06 matthew Exp $
 #
 # Copyright Michigan State University Board of Trustees
 #
@@ -35,7 +35,7 @@
 # note: The filehandle LOG is global.
 open LOG,">>loncapa_install.log" || die "Unable to open log file.\n";
 
-print LOG '$Id: install.pl,v 1.4 2003/12/19 15:12:59 matthew Exp $'."\n";
+print LOG '$Id: install.pl,v 1.5 2004/09/08 21:37:06 matthew Exp $'."\n";
 
 # Some friendly subroutines
 sub die_if_nonempty {
@@ -334,8 +334,7 @@
 	$mysql_commands .= <<"END";
 INSERT INTO user (Host, User, Password)
 VALUES ('localhost','www',password('localhostkey'));
-INSERT INTO db VALUES ('localhost','loncapa','www',
-'Y','Y','Y','Y','Y','Y','N','Y','Y','Y');
+INSERT INTO db (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv,Grant_priv,References_priv,Index_priv,Alter_priv) 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;