search

MHMDhub / enterprise-log-search-and-archive

Automatically exported from code.google.com/p/enterprise-log-search-and-archive
0 stars 0 forks source link

NODE & WEB Seperate installation not working #43

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1.I am trying to install NODE on one server & WEB on other server.
2. Both servers are having Ubuntu Server 12.04 LTS OS.
3. I am using ELSA Quickstart script to do the above

Please provide any additional information below.
NODE SERVER :

i am running the below scripts:
wget 
"http://enterprise-log-search-and-archive.googlecode.com/svn/trunk/elsa/contrib/
install.sh"

sudo sh -c "sh install.sh node"
Installation is Success without any error!!

WEB SERVER :

i am running the below scripts:
wget 
"http://enterprise-log-search-and-archive.googlecode.com/svn/trunk/elsa/contrib/
install.sh"
sudo sh -c "sh install.sh web"

when i am running this script in NODE server, i am getting the below Error & 
installation FAILS:

A    elsa/web/inc/chart.js
A    elsa/web/inc/graphAnything.js
A    elsa/web/cron.pl
Exported revision 335.
get_elsa success
Executing set_web_mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket 
'/var/run/mysqld/mysqld.sock' (2)
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket 
'/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' 
exists!
set_web_mysql FAIL
ise@elsaweb:~$ 
ise@elsaweb:~$

Are there any configuration changes to be done in the Script if we install NODE 
& WEB on different machines?? 

CAN YOU HELP !!

Original issue reported on code.google.com by vamsi.ma...@gmail.com on 9 Jul 2012 at 10:07

GoogleCodeExporter commented 8 years ago 
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.

Original comment by mchol...@gmail.com on 9 Jul 2012 at 2:13

GoogleCodeExporter commented 8 years ago 
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$

Original comment by vamsi.ma...@gmail.com on 11 Jul 2012 at 1:02

GoogleCodeExporter commented 8 years ago 
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.

Original comment by mchol...@gmail.com on 11 Jul 2012 at 2:03

GoogleCodeExporter commented 8 years ago 
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.

Original comment by vamsi.ma...@gmail.com on 12 Jul 2012 at 7:52

GoogleCodeExporter commented 8 years ago 
Sorry its the Latest time in WEB is not matching with the server time.

Original comment by vamsi.ma...@gmail.com on 12 Jul 2012 at 7:54

GoogleCodeExporter commented 8 years ago 
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.

Original comment by mchol...@gmail.com on 12 Jul 2012 at 1:08

GoogleCodeExporter commented 8 years ago 
Closing as problem appears solved.

Original comment by mchol...@gmail.com on 13 Jul 2012 at 1:41