Sign in to follow this  
Followers 0
mattsweet

Mysql archive database table error

2 posts in this topic

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.

 

winsnort error.JPG

Share this post


Link to post
Share on other sites

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>

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0