Open-AudIT

How do I go about setting up the DB and tables in mysql? Is there a script for this? I was able to do this through the setup with Winventory but this isn't happening with OpenAudIT. Any help will be greatly appreciated!

TIA!

The database structure is given in scripts/open_audit.sql. If you run the contents against the DB, it will create it. You can do this with phpMyAdmin. If you need more help on that let me know. I'm working on a new installer that will do everything for you, so if you need that, I can try and polish it up a bit and let you test it (I've tested it a bunch, no problem so far... just I got busy and it has sat there).

on the commandline (either Linux or Windows) just type:

# mysql -p openaudit < open_audit.sql
assuming you're in the directory containing the open_audit.sql script, "openaudit" is the database' name!
it'll ask you for the password of the user you're logged in with running that command.
(linux: most of the time as root, windows: administrator?)

cheers,
b1ff