Smoothwall Database Errors

[MartinT]

We're getting a lot of database errors in the system log, with a request to reindex it. How do we do that? I rebooted Smoothwall yesterday and they went away for a while, but the entries are back again at the rate of several per second. Excerpt:

 

-----------------------------------------------------------------

 

10:48:52 smoothwall Database parser: Attempting individual inserts...

10:48:52 smoothwall Fallback: Entered: 1450 / 2000

10:48:52 smoothwall Database parser: ERROR: DBD::Pg::st execute failed: ERROR: index "guardian_get_parameters_protocol_idx" contains unexpected zero page at block 167516 HINT: Please REINDEX it.

10:48:52 smoothwall Database parser: Attempting individual inserts...

10:48:52 smoothwall Database parser: ERROR: DBD::Pg::st execute failed: ERROR: index "guardian_get_parameters_protocol_idx" contains unexpected zero page at block 167516 HINT: Please REINDEX it.

10:48:52 smoothwall Database parser: Attempting individual inserts...

10:48:52 smoothwall Database parser: ERROR: Can't call method "execute" on an undefined value at /modules/guardian/usr/lib/smoothwall/commonlogparsing.pm line 203.

[tom_newton]

Looks like you may need a database rebuild... worth getting in touch with support.

[MartinT]

Thanks, will do.

[MartinT]

Ticket raised. As a matter of interest, is there a way of forcing a database check/repair on reboot? I notice that every few reboots Smoothwall seems to perform additional file system checks but I don't know how to make it do them. Can it be done from the console after the system is up?

[tom_newton]

Martin, the FS check is much more low level. A database check would take even longer. We plan to give much more user control over the FS check at some point - they really are not needed so frequently.

[MartinT]

Now fixed with:

# /usr/bin/smoothwall/databasetools.pl --reindex

[tom_newton]

Excellent. Give a man a a fish and all that cobblers.

 

Probably should be a button on t'gui for that, but everyone says the GUI has too many buttons

[john]

Excellent. Give a man a a fish and all that cobblers.

 

Probably should be a button on t'gui for that, but everyone says the GUI has too many buttons

 

I've yet to see any buttons as such on the front page of the Gui really, there are about what 4 and a drop down. I think all the services (the ticks and crosses) should all be clickable

[tom_newton]

I've yet to see any buttons as such on the front page of the Gui really, there are about what 4 and a drop down. I think all the services (the ticks and crosses) should all be clickable

 

Good idea! Thanks.

[datalas]

Now fixed with:

# /usr/bin/smoothwall/databasetools.pl --reindex

 

Just a quick note that on the Database Backup page ( information >> settings >> database backup ) the "Optimize Database" button will perform this from the UI. Not that it's especially clear from the title that this is what it does.

 

/me wanders off to add things to the V8 design notes

 

I've yet to see any buttons as such on the front page of the Gui really, there are about what 4 and a drop down. I think all the services (the ticks and crosses) should all be clickable

 

Oddly enough this is one of the things I've been looking at in V8 the last few days. The dashboard and services pages should both present click-through links to something a bit more tangible about the services they're representing (start / stop / restart, logs, configuration etc) although we're still at the experimental stage

[tom_newton]

@ZeroHour: can you give Datalas (aka Darren) here "SmoothWall" rank -he's from SmoothWall, and he's rank, so he definitely deserves it

[ZeroHour]

@ZeroHour: can you give Datalas (aka Darren) here "SmoothWall" rank -he's from SmoothWall, and he's rank, so he definitely deserves it

 

Done, cheers