Mysql archive database table error

[mattsweet]

Everything seems to work I have the system up but when I go to the http://winids/ url, the page loads but I receive the error

"Database ERROR"Database ERROR: Table'archive.acid_event' doesn't exist.

I connect with sql developer to verify and it indeed doesn't.  Do I need to run the MySQL_ configuration again for the archive database?  or can I manually add the tables and row column data?  can someone provide the steps to do that?

 thanks so much.. really looking forward to using this system I have been severely compromised on my home network and This is the final piece to hardening my home network.

 

[Morpheus]

You should have checked and verified the tables per the tutorial.

The error states there is a problem with the archive database.

Below is how to check the existence of the tables in the archive database.

If the tables are missing then you might need to reinstall, and make sure that no steps are missed.

Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Operator>mysql -u root -pd1ngd0ng
mysql: [Warning] Using a password on the command line interface can be insecure.

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.7.18-log MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> connect archive;
Connection id:    8
Current database: archive

mysql> show tables;
+-------------------+
| Tables_in_archive |
+-------------------+
| acid_ag           |
| acid_ag_alert     |
| acid_event        |
| acid_ip_cache     |
| base_roles        |
| base_users        |
| data              |
| detail            |
| encoding          |
| event             |
| icmphdr           |
| iphdr             |
| opt               |
| reference         |
| reference_system  |
| schema            |
| sensor            |
| sig_class         |
| sig_reference     |
| signature         |
| tcphdr            |
| udphdr            |
+-------------------+
22 rows in set (0.00 sec)

mysql>