2016-01-27 - Re: [GRASE-Hotspot] Re: 3.8.0 is Live!

Header Data

From: Timothy White <ti***8@gmail.com>
Message Hash: 3bec0414dc37ee39af5cf0968dea762507f6f98527ba1823c59ee49561b5770a
Message ID: <CAESLx0+pxFYYs4cfJJkTFGE=wjZdnAbJ-wyprW6M+eWp6nfR9A@mail.gmail.com>
Reply To: <CAESLx0+Uk_LVajtRKEB1Er24JcCajkTr7f7RvR3BXL-_aK3Prg@mail.gmail.com>
UTC Datetime: 2016-01-27 14:49:20 UTC
Raw Date: Thu, 28 Jan 2016 07:49:20 +1000

Raw message 

Hi Alex

Can you please try going to http://192.168.0.1/grase/radmin/cron and
capture any output from that page. Then try and login again.
In a quick test I did. If Apache wasn't running when the hotspot was
installed, the cronjob didn't get run, and so the database upgrade scripts
hadn't run.

I've created a ticket (
https://github.com/GraseHotspot/grase-www-portal/issues/142) to fix the
Cronjob not running.

It also sounds like you may not have had the correct database's in the
first place. When you installed, did you have issues setting up the
databases? It should have prompted you for the root password for the
databases so it could install it's own user, and databases.
If the databases are correctly installed, you should have 2 files with the
details in /etc/grase/ called radius.conf  and radmin.conf . Can you please
verify if those files are there.

Regards

Tim


On Thu, Jan 28, 2016 at 7:17 AM, Timothy White <ti***8@gmail.com> wrote:

> Hi Alex
>
> Is this a fresh installation or an upgrade?
>
> Can you please follow the instructions at
> https://grasehotspot.org/support/collecting-support-information/ to
> collect some support information so we can try and work out the cause of
> this.
>
> Regards
>
> Tim
>
> On Thu, Jan 28, 2016 at 6:32 AM, Alexander Schomburg <al***x@schomb.org>
> wrote:
>
>> I'm using http://192.168.0.1/grase/radmin/ for login.
>>
>> Thanks for your `radmin` database export. I imported it and added the
>> admin user with your hash. Still no joy. "Incorrect login"
>>
>> ###
>> mysql> INSERT INTO auth VALUES
>> ("admin","2c9c1aecd820e3fba580e10e1411fd42d32d3a3ac00dfb10d","1");
>> Query OK, 1 row affected (0.00 sec)
>>
>> mysql> SELECT * FROM auth;
>>
>> +----------+---------------------------------------------------+-------------+
>> | username | password                                          |
>> accesslevel |
>>
>> +----------+---------------------------------------------------+-------------+
>> | admin    | 2c9c1aecd820e3fba580e10e1411fd42d32d3a3ac00dfb10d
>> |           1 |
>>
>> +----------+---------------------------------------------------+-------------+
>> 1 row in set (0.00 sec)
>> ###
>>
>> I guess I need to reinstall again from scratch and try again?
>>
>> Am Mittwoch, 27. Januar 2016 21:19:47 UTC+1 schrieb tomas213:
>>>
>>> What is the path your are trying to login?
>>> http://yourip/grase/radmin/
>>>
>>> I sent you the radmin table.
>>> Can u create it and make the admin user in the auth table?
>>> Maybe something went wrong during the update
>>>
>>> On Wed, Jan 27, 2016 at 10:07 PM, Alexander Schomburg <al***.@schomb.org>
>>> wrote:
>>>
>>>> Hey Tomas,
>>>>
>>>> thanks for your quick answer. I can't find a `radmin` table in my
>>>> `grasewwwportal` database (or the `radius` database as well). But I do have
>>>> an `auth` table in `grasewwwportal`. I updated the hash accordingly, but
>>>> still can't login in the web interface: "Incorrect login".
>>>> ###
>>>> mysql> USE grasewwwportal;
>>>> mysql> UPDATE auth SET password =
>>>> "2c9c1aecd820e3fba580e10e1411fd42d32d3a3ac00dfb10d" WHERE username="admin";
>>>> Query OK, 1 row affected (0.00 sec)
>>>> Rows matched: 1  Changed: 1  Warnings: 0
>>>>
>>>> mysql> SELECT * FROM auth;
>>>> +----------+---------------------------------------------------+
>>>> | username | password                                          |
>>>> +----------+---------------------------------------------------+
>>>> | admin    | 2c9c1aecd820e3fba580e10e1411fd42d32d3a3ac00dfb10d |
>>>> | support  | 205e599a4bc20218232707bb1fbb4caf11c5bb634e84aeaa1 |
>>>> +----------+---------------------------------------------------+
>>>> 2 rows in set (0.00 sec)
>>>> ###
>>>>
>>>> Any ideas?
>>>>
>>>> Am Mittwoch, 27. Januar 2016 20:47:03 UTC+1 schrieb tomas213:
>>>>>
>>>>> Alexader, try this :
>>>>>
>>>>> Can you access your database? if yes, got to radmin --> auth.
>>>>> check if admin user exists.
>>>>> if yes, try this password
>>>>> 2c9c1aecd820e3fba580e10e1411fd42d32d3a3ac00dfb10d
>>>>> the hash for : hotspotadmin
>>>>>
>>>>> On Wed, Jan 27, 2016 at 8:49 PM, Alexander Schomburg <al***.@schomb.org
>>>>> > wrote:
>>>>>
>>>>>> Thanks Tim. Unfortunately we're not able to log into a fresh
>>>>>> installation. The default credentials admin / hotspotadmin are not correct.
>>>>>> Can you provide us with the correct default password for admin? Otherwise,
>>>>>> does anyone know which is the password encryption scheme and salt used in
>>>>>> the `auth` MySQL table?
>>>>>>
>>>>>> Am Sonntag, 10. Januar 2016 12:33:29 UTC+1 schrieb timwhite88:
>>>>>>>
>>>>>>> https://grasehotspot.org/2016/01/10/3-8-0-released/
>>>>>>>
>>>>>>> And finally, 3.8.0 is released! Here is a quick run down on what’s
>>>>>>> new!
>>>>>>>
>>>>>>>    - New login page! See
>>>>>>>    https://grasehotspot.org/2014/05/20/new-login-coming-soon/ for
>>>>>>>    more details. It’s mobile friendly, and looks great. Still can be fully
>>>>>>>    customised like the previous page.
>>>>>>>    - Free Access user. Auto creates an account for users. Also
>>>>>>>    known as a ‘Just accept Terms of Service’ style login.
>>>>>>>    - See the Github Tracker for more details of what has changed!
>>>>>>>    <https://github.com/GraseHotspot/grase-www-portal/issues?q=milestone%3A3.8+is%3Aclosed>
>>>>>>>    - You can also look at the Changelog for more details
>>>>>>>    <https://github.com/GraseHotspot/grase-www-portal/blob/3.8.0/debian/changelog>
>>>>>>>
>>>>>>> Updates should be automatic unless you have disabled automatic
>>>>>>> updates. Please report all bugs to the bug tracker
>>>>>>> <https://github.com/GraseHotspot/grase-www-portal/issues>.
>>>>>>>
>>>>>> --
>>>>>> 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***.@grasehotspot.org.
>>>>>> To post to this group, send email to gr***.@grasehotspot.org.
>>>>>> Visit this group at
>>>>>> https://groups.google.com/a/grasehotspot.org/group/grase-hotspot/.
>>>>>> To view this discussion on the web visit
>>>>>> https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/6588661f-f113-400f-ab68-2a84bbc63584%40grasehotspot.org
>>>>>> <https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/6588661f-f113-400f-ab68-2a84bbc63584%40grasehotspot.org?utm_medium=email&utm_source=footer>
>>>>>> .
>>>>>>
>>>>>
>>>>> --
>>>> 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***.@grasehotspot.org.
>>>> To post to this group, send email to gr***.@grasehotspot.org.
>>>> Visit this group at
>>>> https://groups.google.com/a/grasehotspot.org/group/grase-hotspot/.
>>>> To view this discussion on the web visit
>>>> https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/60171dc5-ca0f-4776-9244-8a06ce31a479%40grasehotspot.org
>>>> <https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/60171dc5-ca0f-4776-9244-8a06ce31a479%40grasehotspot.org?utm_medium=email&utm_source=footer>
>>>> .
>>>>
>>>
>>> --
>> 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 post to this group, send email to gr***t@grasehotspot.org.
>> Visit this group at
>> https://groups.google.com/a/grasehotspot.org/group/grase-hotspot/.
>> To view this discussion on the web visit
>> https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/4520a7c0-08a4-48db-bc29-cfd962359879%40grasehotspot.org
>> <https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/4520a7c0-08a4-48db-bc29-cfd962359879%40grasehotspot.org?utm_medium=email&utm_source=footer>
>> .
>>
>
>

Thread