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

Header Data

From: Timothy White <ti***8@gmail.com>
Message Hash: 66ed27c09c6d798d18e76ee9f1d0b3e00ddaebde1188aea60b15ce3b26c1f8dd
Message ID: <CAESLx0+FcEqGCKYac1dKPMVJnUcUMckXhL=5t2wrMn3OeuaZgg@mail.gmail.com>
Reply To: <6a66fe4b-9330-4a6e-830b-efa6942cf274@grasehotspot.org>
UTC Datetime: 2016-01-27 19:07:57 UTC
Raw Date: Thu, 28 Jan 2016 12:07:57 +1000

Raw message 

Can you please collect the support information as stated previously, as
that gives us lots of information about your setup that helps us work out
what's causing the problems.

Thanks

Tim
On Jan 28, 2016 10:44 AM, "Alexander Schomburg" <al***x@schomb.org> wrote:

> Hey Tim,
>
> thanks! The command http://192.168.0.1/grase/radmin/cron in combination
> with tomas' mysql export did the trick: "Database upgraded 48". I can now
> login and configure GRASE Hotspot.
>
> I did indeed have several problems with MySQL during installation, because
> I already had a MySQL daemon setup on my machine. I decided to reset it and
> was able to successfully run the installation of GRASE.
>
> Concerning /etc/radius.conf and radmin.conf I found that the installation
> / dpkg-reconfigure didn't have sufficient rights to write those files. Just
> for this demo installation I allowed chmod 777 on those both files and then
> was able to install/reconfigure.
>
> After some other issues with dnsmasq (conf-dir was commented in
> dnsmasq.conf) GRASE seems to run just fine. But: Login is not working. I
> tried both creating users in the admin interface and allowing free access.
> Both variants give me errors on the TOS server (server error / invalid
> response).
>
> Thanks for your help so far!
>
> Am Mittwoch, 27. Januar 2016 22:49:22 UTC+1 schrieb timwhite88:
>>
>> 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
>> <https://www.google.com/url?q=https%3A%2F%2Fgithub.com%2FGraseHotspot%2Fgrase-www-portal%2Fissues%2F142&sa=D&sntz=1&usg=AFQjCNFSsQFliZnfnxuuiFVvQohuvghQqg>)
>> 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***.@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***.@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***.@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/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>
>>>> .
>>>>
>>>
>>>
>> --
> 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/6a66fe4b-9330-4a6e-830b-efa6942cf274%40grasehotspot.org
> <https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/6a66fe4b-9330-4a6e-830b-efa6942cf274%40grasehotspot.org?utm_medium=email&utm_source=footer>
> .
>

Thread