Re: Mirrored server

[Jonathan Callahan <callahan@xxxxxxxxxxxxx>]

Roland,

Which version of LAS are your currently working with?  Joe Sirott
checked your changes to LASDB.pm into CVS as of LASDB.pm revision
1.3.2.2 (May 15'th) and these changes are incorporated in LAS v_5_1_1.

This would not normally be an official release but I believe you've been
downloading code through remote CVS.  If you upgrade to LAS v_5_1_1 or
v_5_1_2 (recommended) you should get the remote SQL access without
hacking.

I hope this helps,


-- Jon


Roland Schweitzer wrote:
> 
> Joe,
> 
> Well, huh.  I guess I'm smarter (or dumber) than I look.
> 
> Yes, I did make all those changes, however it only affected the configuration
> process which serializes the information into the database.
> 
> I found the spot in LASTemplate.pm where the session management stuff gets it's
> database connection.  I hard coded a host in there and that successfully moved
> the session management db access from the local host to the remote host.
> 
>     my $args = {
>         cgi => $cgi,
>         DataSource => 'dbi:mysql:las:web1',
>         UserName => 'las',
>         Password => 'lasrules',
>         CookieError => 'nocookies.html'
>         };
> 
> However, the connection that yanks the info out of the database to build the UI
> still connects to the local host.
> 
> 011003 10:36:57     183 Connect    las@localhost on las
>                     183 Query      select dbase from map where
> urlid='9tuvk+i7ar2igZXPNxOqnA'
>                     183 Quit
> 
> So far I've not been able to locate where this connection gets initialized so I
> can intervene with a host name.  If I hack all the places in LASDB.pm where I
> added a host argument and hard code the value to the remote host, everything
> works so we're definitely on the right track...
> 
> Roland
> --
> Roland Schweitzer
> NOAA-CIRES Climate Diagnostics Center           325 Broadway
> NOAA/OAR/CDC - (R/CDC1)                         Boulder, CO 80303
> .... (303) 497-6249 .... (303) 497-7013 FAX .... rhs@cdc.noaa.gov ....