Re: [las_users] MySQL problem with LAS 6.5.1.2 on Mandriva 10.2

[cermak@xxxxxxxxxxxx]

Hartmut,

Yup. Interesting hangup.  Things start going bad if you secure the MySQL
server before installing LAS.  Even reinstalling causes a problem.  

I went through the process of installing ant and recompiling the .war file
to fix the MySQL error and that wasn't it.  It was the fact I secured the
database after and LAS couldn't deal with the new password.

I would start with a clean slate if possible.   Remove MySQL and the database
directory if possible.  Then, reinstall the default MySQL, then run through
the LAS installation process with the fix for configure.pl.  

I have a nearly fresh 10.2 install here on my laptop.  I should try and run
through all this again... from the step of installing Ferret.   

As I go through the process of a LAS install, I'll throw up documents
here:
  http://ak.aoos.org/dev/  -- probably las.html with a reference to
     ferret.html

If I run out of time before vacation, it may appear some days later
and definitely by the first week of January 2006.

Rob

Quoting Hartmut Frenzel <frenzel@quercus.igpp.ucla.edu>:

> Hello there,
> 
> thanks to the first tip in this message
> http://ferret.pmel.noaa.gov/Ferret/LAS/Mail_Archives/fu_2005/msg00210.html
> 
> (i.e. modify line 1689 in configure.pl back and forth, the version
> 
> } elsif ($module eq 'URI' || $module eq 'URI:URL') {
> 
> doesn't work for me), I got LAS installed, and "sort of running".
> 
> Now I have the second problem from the same message, i.e. the MySQL 
> connection doesn't work, the error message in the browser is
> 
> javax.servlet.ServletException: Server connection failure during 
> transaction. Due to underlying exception: 'java.net.SocketException: 
> java.net.ConnectException: Connection refused'.
> 
> 
> I can't figure out what Rob did, and there doesn't seem to be anything 
> in the LAS documentation. So far, I ran the configure and startserver.sh 
> scripts as root. During the configure process, I also set root as the 
> MySQL account.
> 
> Do I have to create a las user for MySQL with mysqladmin, and use that 
> in configure?
> Or run configure as a non-root user?
> 
> My version of MySQL is MySQL-4.1.11-1mdk
> 
> I appreciate your help. Thanks a lot!
> -- Hartmut
>