Registrations to Open-AudIT forums are now closed. To ask any new questions please visit Opmantek Community Questions.

Open-AudIT

What's on your network?
It is currently Fri Mar 29, 2024 8:12 pm

All times are UTC + 10 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 4 posts ] 
Author Message
 Post subject: Installing version 1.5
PostPosted: Fri Nov 21, 2014 9:22 pm 
Offline
Newbie

Joined: Fri Nov 21, 2014 9:43 am
Posts: 1
Hello Everyone,
I am new to the forum.
I installed open-audit on a virtual machine running debian 7.
However, I stopped in these two situations.
I would help you to solve this problem.


Attachments:
Erro 2.png
Erro 2.png [ 66.28 KiB | Viewed 4919 times ]
Erro 1.png
Erro 1.png [ 118.08 KiB | Viewed 4919 times ]
Top
 Profile  
Reply with quote  
PostPosted: Sat Nov 22, 2014 5:10 am 
Offline
Newbie

Joined: Fri Nov 21, 2014 12:12 am
Posts: 4
I just had the same issue or very similiar, please read the excerpts from the topic I just opened.


try the following if it is a brand new database only.
-DO NOT PERFORM THESE STEPS WITHOUT A BACKUP
-DO NOT PERFORM THESE STEPS IF YOUR DATABASE IS NOT BRAND NEW

[quote]Good day all,

I am new to Open-AudIT, and have just recently downloaded and installed OAE-Linux-x86_64-release_1.5.1.tar.gz on CentOS 6.6.

After getting Apache and Perl configured the installation went fairly smooth and it answers when I navigate to [url]http://<myip>[/url] in a browser.
The main landing page presented two options Open-AudIT Enterprise & Open-AudIT..
Seeing how I am evaluating the product I simply chose the second option "Open-AudIT” where I was then redirected to
[quote]http://<myIP>/open-audit/index.php/main/list_groups

this seemed to work well and is as speedy as I would expect...

While clicking through the navigation I was then presented with the notice "Upgrade" at almost every turn..
What I soon found out was the mysql database required an upgrade.. "On the latest version of a new installation" I thought.

In any case I backed up the database by navigating to ADMIN > Database > Backup the Database
This provided me with a browser download which I saved as "OAv2_database_backup_2014_11_21_14_06_29.sql"

I then proceeded to click Upgrade and received an error notice

[quote]Error Number: 1060
Duplicate column name 'sysDescr'
ALTER TABLE system ADD sysDescr varchar(255) NOT NULL
Filename: /usr/local/open-audit/code_igniter/application/controllers/admin.php
Line Number: 2769

Since this was a brand new database I just dropped all the columns in the system table that the admin.php script was trying to ALTER, described from lines 2769 - 2799.
The columns were:
    sysDescr, sysObjectID, sysUpTime, sysContact, sysName, sysLocation


How I did it was:

1) ssh to my server: [quote]mysql --user=root --password=<your password>
2) open the database: [quote]use openaudit
3) drop columns from the system table:
[quote]ALTER TABLE system DROP sysDescrOrig;
[quote]ALTER TABLE system DROP sysObjectID;
[quote]ALTER TABLE system DROP sysUptime;
[quote]ALTER TABLE system DROP sysContact;
[quote]ALTER TABLE system DROP sysName;
[quote]ALTER TABLE system DROP sysLocation;



Once the columns were dropped out of the system table I was then able to successfully upgrade from 1.5 to 1.5.1..

This is currently where I am now with OpenAudIT.. I hope this helps someone out there.

Please note I am in NO means a guru at this stuff and DO NOT recommend these steps if the database is not BRAND NEW but at least it is now working, please feel free to criticize me publicly. =0)

Top
 Profile  
Reply with quote  
PostPosted: Sat Nov 22, 2014 7:34 am 
Offline
Newbie
User avatar

Joined: Wed Nov 12, 2014 6:57 pm
Posts: 14
Location: Frankfurt a.M., Germany
I had the same problem, after changing display_version in the oa_config database-table to 1.5.1 it worked.

_________________
Server Info:
OS : Ubuntu 14.04
Auditing: ~ 500 machines (35 Windows Server, 440 Linux Server)
LDAP: not yet
Version: Open-AudIT Version 1.8.4


Top
 Profile  
Reply with quote  
PostPosted: Mon Nov 24, 2014 9:44 am 
Offline
Site Admin
User avatar

Joined: Mon Jun 07, 2004 11:48 am
Posts: 1964
Location: Brisbane, Australia
[size=200]ALERT[/size]

There was a bug in the SQL script for 1.5.1. I have now fixed this and updated a new 1.5.1 (9:30am Monday morning Brisbane, Australia time [GMT+10]).
You can fix it yourself to avoid re-downloading.
Open the file /open-audit/other/open-audit_mysql.sql.
Edit lines 1798 & 1799.
Change the lines to as below.
The changes are to the version numbers.
This is/was only affecting fresh Linux installs. Linux upgrades, Windows installs and upgrades should all have been fine.
Apologies for the inconvenience.

[code]INSERT INTO oa_config (config_name, config_value, config_editable, config_description) VALUES ('internal_version', '20141130', 'n', 'The internal numerical version.');
INSERT INTO oa_config (config_name, config_value, config_editable, config_description) VALUES ('display_version', '1.5.1', 'n', 'The version shown on the web pages.');[/code]

_________________
Support and Development hours available from [url=https://opmantek.com]Opmantek[/url].
Please consider a purchase to help make Open-AudIT better for everyone.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 4 posts ] 

All times are UTC + 10 hours


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group