search

caliskanfurkan / enterprise-log-search-and-archive

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

latest install.sh is failing on Debian 6 #166

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Basic install fails, it appears the syslog_data table doesn't get built 
properly on Debian 6.

2. It worked fine a couple weeks ago, I was doing a fresh install on a new 
system and it's failing as of yesterday

What is the expected output? What do you see instead?

ERROR: index 'perm_197': sql_query_pre[0]: Table 'syslog.v_directory' doesn't 
exist (DSN=mysql://elsa:***@localhost:3306/syslog).
total 0 docs, 0 bytes
total 0.000 sec, 0 bytes/sec, 0.00 docs/sec
indexing index 'temp_197'...
ERROR: index 'temp_197': sql_query_pre[0]: Table 'syslog.v_directory' doesn't 
exist (DSN=mysql://elsa:***@localhost:3306/syslog).
total 0 docs, 0 bytes
total 0.000 sec, 0 bytes/sec, 0.00 docs/sec
indexing index 'perm_198'...
ERROR: index 'perm_198': sql_query_pre[0]: Table 'syslog.v_directory' doesn't 
exist (DSN=mysql://elsa:***@localhost:3306/syslog).
total 0 docs, 0 bytes
total 0.000 sec, 0 bytes/sec, 0.00 docs/sec
indexing index 'temp_198'...
ERROR: index 'temp_198': sql_query_pre[0]: Table 'syslog.v_directory' doesn't 
exist (DSN=mysql://elsa:***@localhost:3306/syslog).
total 0 docs, 0 bytes
total 0.000 sec, 0 bytes/sec, 0.00 docs/sec
indexing index 'perm_199'...
ERROR: index 'perm_199': sql_query_pre[0]: Table 'syslog.v_directory' doesn't 
exist (DSN=mysql://elsa:***@localhost:3306/syslog).
total 0 docs, 0 bytes
total 0.000 sec, 0 bytes/sec, 0.00 docs/sec
indexing index 'temp_199'...
ERROR: index 'temp_199': sql_query_pre[0]: Table 'syslog.v_directory' doesn't 
exist (DSN=mysql://elsa:***@localhost:3306/syslog).
total 0 docs, 0 bytes
total 0.000 sec, 0 bytes/sec, 0.00 docs/sec
indexing index 'perm_200'...
ERROR: index 'perm_200': sql_query_pre[0]: Table 'syslog.v_directory' doesn't 
exist (DSN=mysql://elsa:***@localhost:3306/syslog).
total 0 docs, 0 bytes
total 0.000 sec, 0 bytes/sec, 0.00 docs/sec
indexing index 'temp_200'...
ERROR: index 'temp_200': sql_query_pre[0]: Table 'syslog.v_directory' doesn't 
exist (DSN=mysql://elsa:***@localhost:3306/syslog).
total 0 docs, 0 bytes

...

DBD::mysql::st execute failed: Table 'syslog.buffers' doesn't exist at 
/usr/local/elsa/node/Indexer.pm line 925.
DBD::mysql::st execute failed: Table 'syslog.buffers' doesn't exist at 
/usr/local/elsa/node/Indexer.pm line 925.
test_elsa FAIL

What version of the product are you using? On what operating system?

Fresh install of Debian 6 

Please provide any additional information below.

I've tried installing mysql outside of the elsa install and providing the 
password in the install.sh file and got the same results.  I looked for a mysql 
import type file to build the tables myself but didn't find what I expected.

Original issue reported on code.google.com by ret...@gmail.com on 23 Jul 2013 at 1:40

GoogleCodeExporter commented 9 years ago 
I think these two lines are wrong.

(196 and 197 in /usr/local/elsa/node/conf/schema.sql)

INSERT INTO fields_classes_map (class_id, field_id, field_order) VALUES (0, 
(SELECT id FROM fields WHERE field="program"), 2);
INSERT INTO fields_classes_map (class_id, field_id, field_order) VALUES (0, 
(SELECT id FROM fields WHERE field="class"), 3);

My fields table gets build prior to this but doesn't contain program or class, 
but does contain program_id and class_id but this file gets recreated every run 
so it's hard to troubleshoot.

Original comment by ret...@gmail.com on 24 Jul 2013 at 5:50

GoogleCodeExporter commented 9 years ago 
Quite right, sorry about that.  Fixed in 990.

Original comment by mchol...@gmail.com on 24 Jul 2013 at 6:54

GoogleCodeExporter commented 9 years ago

Original comment by mchol...@gmail.com on 24 Jul 2013 at 6:54