MHMDhub / enterprise-log-search-and-archive

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

MySQL Schema Import Error on SET_NODE_MYSQL - RHEL6.3 #55

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Install log and node on fresh RHEL6 base install using install.sh

What is the expected output? What do you see instead?
The schema import should finish successfully.
ERROR 1062 (23000) at line 182 in file: '/usr/local/elsa/node/conf/schema.sql': 
Duplicate entry '4-15' for key 'class_id'

What version of the product are you using? On what operating system?
Lastest as of 08/01/2012. RHEL6.3

Please provide any additional information below.
I tried dropping the syslog databases and running this part of the script again 
(set_node_mysql) but it fails each time.

The schema at like 182 looks like this:
...
INSERT INTO fields_classes_map (class_id, field_id, field_order) VALUES 
((SELECT id FROM classes WHERE class="WINDOWS"), (SELECT id FROM fields WHERE 
field="share_name"), 14);
INSERT INTO fields_classes_map (class_id, field_id, field_order) VALUES 
((SELECT id FROM classes WHERE class="WINDOWS"), (SELECT id FROM fields WHERE 
field="share_path"), 15);
INSERT INTO fields_classes_map (class_id, field_id, field_order) VALUES 
((SELECT id FROM classes WHERE class="WINDOWS"), (SELECT id FROM fields WHERE 
field="share_target"), 15);

/*INSERT INTO fields_classes_map (class_id, field_id, field_order) VALUES 
((SELECT id FROM classes WHERE class="WINDOWS"), (SELECT id FROM fields WHERE 
field="user"), 12);
...

Original issue reported on code.google.com by PacketSh...@gmail.com on 2 Aug 2012 at 10:22

GoogleCodeExporter commented 9 years ago
Oops, thanks!  Fixed in rev 370.

Original comment by mchol...@gmail.com on 3 Aug 2012 at 1:42