[LON-CAPA-dev] Re: SuSE installation

Martin Siegert lon-capa-dev@mail.lon-capa.org
Wed, 8 Sep 2004 12:59:55 -0700


I am still struggling with the mysql setup:
"/etc/init.d/loncontrol start" only results in "cannot connect to database"
(and, yes, mysqld is running).

- it seems to me that the install.pl script is only for RH 7.3
  (loncapa-1.2.0/doc/install/redhat7.3/install.pl). In fact the
  corresponding loncapa-1.2.0/doc/install/fedora directory is
  empty. How is mysql setup for a fedora2 installation?

- I tried to execute the commands from install.pl manually:

# mysql -u root mysql
mysql> CREATE DATABASE loncapa;
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO user (Host, User, Password) VALUES ('localhost','www',password('localhostkey'));
ERROR 1062: Duplicate entry 'localhost-www' for key 1

  This is mysql-4.0.18. I do not know whether the mysql syntax has changed
  from RH7.3's mysql-3.23.58 so much that those commands in install.pl
  do not work anymore.

Any ideas?