Open-AudIT

I had it installed on the server but had some php errors. Instead of getting the mess straightened out, I just removed it and installed the latest package from svc. Now, I goto set it up again and I get this error. I removed the database and readded it via phpMyAdmin.

It sets up a new instance of OA with 0 problems, then Setting defaults in the database gives me this error:
[code]Connecting to 192.168.10.18 as root. Connected.
Setting up data in tables.
Query failed. Query was:
SET PASSWORD FOR 'root'@'%' = OLD_PASSWORD('mypw')[/code]

Note: 'mypw' isn't the actual password.

I'm thinking it's a user error. I'm still looking into it.

Had the same problem this morning.

Just commented out the line and setup completed

Suspect its got something to do with the host not been specified

SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

I'm guessing I'd have to do that on the MySQL end? Where is it located?

(Obviously, newb to the whole MySQL/PHP game.)

comment out line 24 in setup_2.php

line 23&24
[code]
$sql = "SET PASSWORD FOR '" . $mysql_user . "'@'%' = OLD_PASSWORD('" . $mysql_password . "')";
//$result = mysql_query($sql) or die("<tr><td>".__("Query failed. Query was").":<br /><font color=\"red\">" . $sql . "</font></td></tr>\n");
[/code]

Wow, you're too quick with the replies! Thank you, that seemed to have worked. I'm configuring the audit.vbs right now. Hopefully I won't mangle anything else. If so, look forward to seeing another topic posted.

Thanks again!