Closed GoogleCodeExporter closed 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
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
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
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
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
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
Closing as problem appears solved.
Original comment by mchol...@gmail.com
on 13 Jul 2012 at 1:41
Original issue reported on code.google.com by
vamsi.ma...@gmail.com
on 9 Jul 2012 at 10:07