[LON-CAPA-dev] Re: SuSE installation

Matthew Brian Hall lon-capa-dev@mail.lon-capa.org
Wed, 08 Sep 2004 16:17:30 -0400

Hi Martin, 

> 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).

Good to hear :) 

> - 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?

Hmmm.  It's there on my machine: 

[matthew@kirk fedora]$ pwd
[matthew@kirk fedora]$ ls -l
total 32
drwxrwxr-x  2 matthew matthew  4096 Mar 17 13:48 CVS
 -rwxrwxr-x  1 matthew matthew 12671 Dec 19  2003 install.pl
 -rw-rw-r--  1 matthew matthew  9718 Mar 17 13:49 

Nevertheless, the commands are the same so it shouldn't make a difference 
which install.pl script you use. 

> - 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
> mysql> 

So it looks like the entry we want has already been made.  Try to log in by 

# mysql -u www -p
Enter password: localhostkey 

If you can get in and execute 

mysql> USE loncapa; 

then it should be set up well enough.  Running the searchcat.pl script 
should take care of setting up the necessary metadata table, assuming it can 
connect to the database. 

As to why you cannot connect....  I'm not sure.  I'll hack together a 
stripped down test script and we'll have to start from there. 

>   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.

I honestly doubt that's the problem here. 


Matthew Hall           hallmat3@msu.edu
LON-CAPA developer
Michigan State University