[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



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