[LON-CAPA-dev] Re: SuSE installation

[Martin Siegert]

Hi Matthew,

On Wed, Sep 08, 2004 at 04:17:30PM -0400, Matthew Brian Hall wrote:
> 
> 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
> /home/matthew/loncapa/doc/install/fedora
> [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 
> LON-CAPA_fedora_install.html 

Hmmm.
# tar tzf loncapa-fedora-1.2.0.tar.gz | grep install.pl
loncapa-1.2.0/doc/install/redhat7.3/install.pl

Did I get the wrong tarball?

> 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 
> hand: 
> 
> # mysql -u www -p
> Enter password: localhostkey 
> 
> If you can get in and execute 

Yes, I can get in.

> mysql> USE loncapa; 

This does not work:
ERROR 1044: Access denied for user: 'www@localhost' to database 'loncapa'

What did I mess up this time?

Cheers,
Martin