2019-08-20 - Re: [GRASE-Hotspot] Re: my s cant get internet

Header Data

From: Vusumzi Ndzengu <nd***v@gmail.com>
Message Hash: f999616d315292d6d229becca964cead7886ba25ce397225f87c3c446cdfe64d
Message ID: <CA+QwxrPqiHMmDgRg8GaeMYF0PCRnP99GSJZGGMpzvmKHqGYfZA@mail.gmail.com>
Reply To: <07874ab8-d320-45d8-9c1b-10849ef9104b@grasehotspot.org>
UTC Datetime: 2019-08-20 02:56:13 UTC
Raw Date: Tue, 20 Aug 2019 11:56:13 +0200

Raw message 

i figured out thanks. I installed phpmyadmin and then i repaired the raddct
table which was broken.

On Fri, Aug 16, 2019 at 3:30 PM 'christopher' via Grase Hotspot <
gr***t@grasehotspot.org> wrote:

> 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] "]*
>>
> --
> This mailing list is for the Grase Hotspot Project http://grasehotspot.org
> ---
> You received this message because you are subscribed to the Google Groups
> "Grase Hotspot" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to gr***e@grasehotspot.org.
> To view this discussion on the web visit
> https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/07874ab8-d320-45d8-9c1b-10849ef9104b%40grasehotspot.org
> <https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/07874ab8-d320-45d8-9c1b-10849ef9104b%40grasehotspot.org?utm_medium=email&utm_source=footer>
> .
>

Thread