Open-AudIT • View topic - [FIXED] Ver 09.12.10 db update fails on old MySQL versions

View unanswered posts | View active topics

Board index » Bugs

All times are UTC + 10 hours

[FIXED] Ver 09.12.10 db update fails on old MySQL versions

Page 1 of 1

[ 7 posts ]

Print view

Previous topic | Next topic

Author

Message

jpa

Post subject: [FIXED] Ver 09.12.10 db update fails on old MySQL versions

Posted: Thu Dec 17, 2009 4:36 am

Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1259

The 09.12.10 update has a couple VARCHAR > 255 declarations which fail on MySQL 4.0. I know we're dragging along in the dark ages but maybe this is unintentional as the developers don't test against such old MySQL versions.

Last edited by jpa on Fri Dec 25, 2009 9:19 am, edited 1 time in total.

Top

jpa

Post subject: Re: Version 09.12.10 db update fails on ancient MySQL versions

Posted: Thu Dec 17, 2009 7:29 am

Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1259

I also notice the "Database errors? Need the database structure altered?" sticky post includes a broken link. phpBb2->phpBB3 related.

Top

Chad

Post subject: Re: Version 09.12.10 db update fails on ancient MySQL versions

Posted: Sun Dec 20, 2009 5:40 am

Contributor

Joined: Fri Jul 04, 2008 6:46 am
Posts: 153
Location: USA - WI

Yes, quite unintentional as I didn't test against an older MySQL version =S . Some of those really should just be mediumtext data types and not varchar and some I should've just left at 255. I've gone through and fixed the open_audit.sql. I just need to fix-up upgrade.php when I get the time here. Thanks for reporting that.

_________________
OA Server: Debian Squeeze w/ Apache2
Auditing: 700 Workstations, 250 or so Retail Terminals, about 75 Servers
OS's: Windows XP/2003/2008/2008 R2/Vista/7, Debian
LDAP: Active Directory 2008 R2

Top

Chad

Post subject: Re: Version 09.12.10 db update fails on ancient MySQL versions

Posted: Sun Dec 20, 2009 8:39 am

Contributor

Joined: Fri Jul 04, 2008 6:46 am
Posts: 153
Location: USA - WI

Should be fixed on revision 1224. I setup MySQL 4 on an XP box to test.

Also, out of curiosity, did you run into issues getting through the initial setup? It seems like MySQL 4 doesn't like the commands used to create the user for the db during the initial setup.

Top

jpa

Post subject: Re: Version 09.12.10 db update fails on ancient MySQL versions

Posted: Sun Dec 20, 2009 3:57 pm

Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1259

[quote="Chad"]Should be fixed on revision 1224

Thank you.

[quote="Chad"]...did you run into issues getting through the initial setup
Did not run in to that for the same reason I'm on an ancient MySQL version - I started with an ancient OpenAudit version.

I think I've run in to this before as well but didn't see anything in my posting history.

Top

jpa

Post subject: Re: Version 09.12.10 db update fails on ancient MySQL versions

Posted: Tue Dec 22, 2009 4:03 am

Moderator

Joined: Fri Jul 20, 2007 8:27 am
Posts: 1259

I've updated and it seems there's still one problem in 09.12.10. Just missed one is all.

audit_cmd_command` VARCHAR(500) NOT NULL default ''

Top

Chad

Post subject: Re: Version 09.12.10 db update fails on ancient MySQL versions

Posted: Thu Dec 24, 2009 12:17 pm

Contributor

Joined: Fri Jul 04, 2008 6:46 am
Posts: 153
Location: USA - WI

Thanks for catching that :oops:

I went through each table I added a few times now just to double check again =/

Top

Page 1 of 1

[ 7 posts ]

Board index » Bugs

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