NODE & WEB Seperate installation not working about enterprise-log-search-and-archive HOT 7 CLOSED

Ah, this is an easy fix: you need to set the variable MYSQL_HOST at the top of 
install.sh to the IP address of a valid MySQL server, such as the log node, 
when you do the web install.  Alternatively, you can install mysql-server 
locally on the web node.  I don't do this by default because many folks have a 
dedicated MySQL server elsewhere they use for web databases, and you can use 
that by setting MYSQL_HOST.  So, just set that variable to a valid MySQL server 
and the web install should complete.

Hi 
1.I have given my remote NODE ip for MYSQL_HOST in install.sh script & began 
the installation for WEB.

2.Installation Successful without any error.

3.After restart i have edited /etc/elsa_web.conf file on the web frontend 
server to point towards my remote NODE server.

after doing the above steps, still i am unable to open ELSA WEB on browser. its 
throwing errors in the Apache log. Pls find the below errors i am getting & 
suggest a solution..

ERROR :

ise@ELSAWEB:/etc$ tail /var/log/apache2/error.log
Use of qw(...) as parentheses is deprecated at /usr/local/elsa/web/lib/API.pm 
line 1067.
Use of qw(...) as parentheses is deprecated at /usr/local/elsa/web/lib/API.pm 
line 1075.
Use of qw(...) as parentheses is deprecated at /usr/local/elsa/web/lib/API.pm 
line 1198.
Use of qw(...) as parentheses is deprecated at /usr/local/elsa/web/lib/API.pm 
line 2076.
Use of qw(...) as parentheses is deprecated at /usr/local/elsa/web/lib/API.pm 
line 2412.
Use of qw(...) as parentheses is deprecated at /usr/local/elsa/web/lib/API.pm 
line 2434.
Use of qw(...) as parentheses is deprecated at /usr/local/elsa/web/lib/API.pm 
line 2692.
Use of qw(...) as parentheses is deprecated at /usr/local/elsa/web/lib/API.pm 
line 3687.
Use of uninitialized value $query in concatenation (.) or string at 
/usr/local/elsa/web/lib/Utils.pm line 97.
[Wed Jul 11 18:17:56 2012] [error] [client X.X.X.X] Error while loading 
/usr/local/elsa/web/lib/Web.psgi: DBI connect('database=elsa_web','elsa',...) 
failed: Can't connect to local MySQL server through socket 
'/var/run/mysqld/mysqld.sock' (2) QUERY:  at /usr/local/elsa/web/lib/Utils.pm 
line 103.\n\tUtils::_dbh_error_handler('DBI 
connect(\\'database=elsa_web\\',\\'elsa\\',...) failed: Can\\'...', 
'DBI::dr=HASH(0x2321436c)', undef) called at /usr/lib/perl5/DBI.pm line 
677\n\tDBI::__ANON__(undef, undef) called at /usr/lib/perl5/DBI.pm line 
734\n\tDBI::connect('DBI', 'dbi:mysql:database=elsa_web', 'elsa', 'biglog', 
'HASH(0x22d95f84)') called at /usr/local/elsa/web/lib/Utils.pm line 
65\n\tClass::MOP::Class:::around('CODE(0x22f1dd54)', 'API', 'config_file', 
'/etc/elsa_web.conf') called at 
/usr/local/lib/perl/5.14.2/Class/MOP/Method/Wrapped.pm line 
162\n\tClass::MOP::Method::Wrapped::__ANON__('API', 'config_file', 
'/etc/elsa_web.conf') called at 
/usr/local/lib/perl/5.14.2/Class/MOP/Method/Wrapped.pm line 
91\n\tAPI::BUILDARGS('API', 'config_file', '/etc/elsa_web.conf') called at 
constructor API::new (defined at /usr/local/elsa/web/lib/API.pm line 3723) line 
6\n\tAPI::new('API', 'config_file', '/etc/elsa_web.conf') called at 
/usr/local/elsa/web/lib/Web.psgi line 20\n\trequire 
/usr/local/elsa/web/lib/Web.psgi called at (eval 6) line 3\n\teval 'package 
Plack::Sandbox::_2fusr_2flocal_2felsa_2fweb_2flib_2fWeb_2epsgi;\n{\n    my $app 
= do $_file;\n    if ( !$app && ( my $error = $@ || $! )) { die $error; }\n    
$app;\n}\n\n;' called at /usr/local/share/perl/5.14.2/Plack/Util.pm line 
118\n\tPlack::Util::_load_sandbox('/usr/local/elsa/web/lib/Web.psgi') called at 
/usr/local/share/perl/5.14.2/Plack/Util.pm line 
155\n\tPlack::Util::load_psgi('/usr/local/elsa/web/lib/Web.psgi') called at 
/usr/local/share/perl/5.14.2/Plack/Handler/Apache2.pm line 
32\n\tPlack::Handler::Apache2::load_app('Plack::Handler::Apache2', 
'/usr/local/elsa/web/lib/Web.psgi') called at 
/usr/local/share/perl/5.14.2/Plack/Handler/Apache2.pm line 
91\n\tPlack::Handler::Apache2::handler('Apache2::RequestRec=SCALAR(0x21762704)')
 called at /usr/local/elsa/web/lib/Web.psgi line 0\n\teval {...} called at 
/usr/local/elsa/web/lib/Web.psgi line 0\n
ise@ELSAWEB:/etc$

In your setup, you're putting the meta_db on the log node, which is fine, but 
that means you'll need to set the config for "meta_db" in elsa_web.conf to 
point to the MySQL instance on your log node.

Thanks, its working now.. it would be a great help if you could update the 
configuration changes to be done when doing separate installation of  NODE & 
WEB in your Documentation for future reference.

I am getting time difference issue, Server time is perfect & whereas earliest 
time in WEB is not matching with the server time.

Sorry its the Latest time in WEB is not matching with the server time.

I will update the documentation, thanks for reminding me.

The "latest" listed date should be a few minutes behind the current server 
time, as logs are loaded in one minute batches.  "Latest" may be more than a 
minute behind, but should not be more than three minutes behind server time.

Closing as problem appears solved.