[Thread Prev][Thread Next][Index]
Re: problem stems from Mysql server / Re: [las_users] MySQL problemwith LAS 6.5.1.2 on Mandriva 10.2
- To: Rob Cermak <cermak@xxxxxxxxxxxx>, las_users@xxxxxxxx
- Subject: Re: problem stems from Mysql server / Re: [las_users] MySQL problemwith LAS 6.5.1.2 on Mandriva 10.2
- From: Joerg Franke <joerg.franke@xxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 01 Mar 2006 13:57:24 +0100
- In-reply-to: <Pine.LNX.4.44.0512160811340.28196-100000@topcat.sfos.uaf.edu>
- References: <Pine.LNX.4.44.0512160811340.28196-100000@topcat.sfos.uaf.edu>
- Sender: owner-las_users@xxxxxxxxxxxxx
- User-agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.12) Gecko/20050921
Hi,
I also have this
"UI property in 'file:///ui.xml#VecVariable' " problem with URI-1.35. I tried las 5.6.1.2 as well as 6.4.2.0
Did anybody solved it by now?
I want to download a more recent version but I was not able to lock in
via cvs:
#
CVSROOT=':pserver:anonymous@stout.pmel.noaa.gov:/home/porter/tmap/FERRET_ROOT';
export CVSROOT
# cvs login
Logging in to
:pserver:anonymous@stout.pmel.noaa.gov:2401/home/porter/tmap/FERRET_ROOT
CVS password:
cvs [login aborted]: unrecognized auth response from stout.pmel.noaa.gov:
Where is the mistake?
Cheers
Jörg
Rob Cermak wrote:
> Jon,
>
> Looks like the native version for Mandrake 10.2 is URI-1.35
>
> I'll try to change the configure script to accept 1.35 and see if we are
> operating.
>
> Looks like 1.35 is unable to build html for the COADS or Levitus
> climatology.
>
> Building indexes...
> Resolving links...
> Generating dataset COADS climatology
> Generating dataset Levitus Climatology
> UI property in 'file:///ui.xml#VecVariable' must refer to file:ui.xml at
> ../xml/perl/LASServlet.pm line 2061.
> Error in generating HTML.
>
> Rob
>
>
>> Rob,
>>
>> We're doing some final testing on a bug-fix release of LAS and I would
>> like to get the URI module test correct. In the currently released
>> version of LAS the test and fix for the URI module is broken /(mea
>> culpa)/. What I really need to know is what version of URI is broken on
>> your system before you 'fix' it by installing the LAS version.
>>
>> We're currently running URI-1.21 on our RedHat Enterprise Linux systems
>> and that doesn't seem to cause any problems at all. We release URI-1.19
>> with LAS but I'm wondering if perhaps we should upgrade rather than
>> downgrade. It would be a tremendous help if you could try installing
>> the latest CPAN version of URI (1.35) to see if that works.
>>
>> We would love to save you and a host of other folks the headache of
>> debugging these knotty installation issues but we need your help in
>> finding out what works on your systems.
>>
>> Thanks,
>>
>>
>> -- Jon
>>
>> cermak@sfos.uaf.edu wrote:
>>
>>
>>> Hartmut,
>>>
>>> The answer is, java uses the fully qualified hostname to connect to
>>> the MySQL database. Once I enabled remote connections to MySQL, things
>>> started working.
>>>
>>> Edit : /etc/sysconfig/mysqld
>>>
>>> Remove:
>>> # (oe) Remove --skip-networking to enable network access from
>>> # non local clients. Access from localhost will still work.
>>> #MYSQLD_OPTIONS="--skip-networking"
>>>
>>> WARNING: You need to secure the MySQL server for root by giving
>>> it a password. You will also need to restrict access to/from
>>> the MySQL server using the fully qualified domain name.
>>>
>>> mysql> select Host,User,Password from user;
>>> +-----------+------+------------------+
>>> | Host | User | Password |
>>> +-----------+------+------------------+
>>> | localhost | root | |
>>> | localhost | | |
>>> | localhost | las | 51cca9f95577687a |
>>> +-----------+------+------------------+
>>>
>>> Unfortunately, I goofed my setup, but at any rate. Root
>>> should be secure as it can only connect from the localhost.
>>> You should set password for good measure.
>>>
>>> The Host entry for las should be the hostname from which
>>> Tomcat is running LAS. If you ended up with localhost for
>>> las, this can be changed.
>>>
>>> UPDATE user SET Host='my.host.net' WHERE User='las';
>>>
>>> It turns out the message you quoted from me has a bug as well. The
>>> suggested line should have two colons (::) for the module
>>> name. However, the installation still fails and you have to
>>> revert the change after doing a local install of the module.
>>>
>>> I have basic instructions up on our development site for LAS
>>> now (Mandrake 10.2). There is one more addition. The directories
>>> where you have pointed aliases:
>>>
>>> # LAS
>>> <Directory /usr/local/las/server>
>>> AllowOverride All
>>> Options ExecCGI
>>> <IfModule mod_access.c>
>>> Order allow,deny
>>> Allow from all
>>> </IfModule>
>>> </Directory>
>>>
>>> <Directory /usr/local/las/server/output>
>>> AllowOverride All
>>> <IfModule mod_access.c>
>>> Order allow,deny
>>> Allow from all
>>> </IfModule>
>>> </Directory>
>>> # END LAS
>>>
>>> Adjust yours appropriately. All seems right with the world.
>>> Give me hollar if there is still a problem.
>>>
>>> This is the first time I got this particular version of LAS
>>> working with Mandrake 10.2 :) Glad you nudged me to check this
>>> problem out.
>>>
>>> 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
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>
>
--
Jörg Franke
University of Bremen
Department of Geosciences
PO Box 330440
D-28334 Bremen
Germany
E-mail: joerg.franke@palmod.uni-bremen.de
Phone: +49-421-218-7186
[Thread Prev][Thread Next][Index]
Dept of Commerce /
NOAA /
OAR /
PMEL /
TMAP
Contact Us | Privacy Policy | Disclaimer | Accessibility Statement