2019-08-16 - Re: my s cant get internet

Header Data

From: christopher <me***e@pc-networking-services.com>
Message Hash: 26ffc849839d0bf2555722c3ebb35fe8f30bd5739c4ade88ae8bcef7adf45db4
Message ID: <07874ab8-d320-45d8-9c1b-10849ef9104b@grasehotspot.org>
Reply To: <57c4b031-2d7a-4eda-aa7f-187ff27d1b3e@grasehotspot.org>
UTC Datetime: 2019-08-16 06:30:45 UTC
Raw Date: Fri, 16 Aug 2019 06:30:45 -0700

Raw message 

Hello,

The best course of action here is to go to /var/backups/grase/database and 
extract one of the known good backups, then import that into your 
database.  This is an automatic backup that was set up when you installed 
the server.  It will restore your user data.

Regards,

Christopher.

On Friday, 16 August 2019 22:10:49 UTC+12, Vusumzi Ndzengu wrote:
>
> Greetings 
>
> my clients complained that they cant get internet. when i look on the 
> admin page i found the following error
>
> *Get All User radacct details Query failed: : [mdb2_error: message="MDB2 
> Error: unknown error" code=-1 mode=return level=notice prefix="" 
> info="_doQuery: [Error message: Could not execute statement] [Last executed 
> query: SELECT LOWER(UserName) as UserName, 
> SUM(radacct.AcctInputOctets)+SUM(radacct.AcctOutputOctets) AS 
> AcctTotalOctets, SUM(AcctSessionTime) AS AcctSessionTime, MAX(AcctStopTime) 
> AS LastLogout FROM radacct GROUP BY UserName] [Native code: 144] [Native 
> message: Table './radius/radacct' is marked as crashed and last 
> (automatic?) repair failed] "]*
>

Thread