2014-09-06 - Re: [GRASE-Hotspot] Re: Nightly Build

Header Data

From: Timothy White <ti***8@gmail.com>
Message Hash: 4a9863b6b88ed197afbc0c7f437ca6eb39b097711ec57656e0706b2c13fd4ae9
Message ID: <CAESLx0Lss-EY5eFHXoB92xf4B7BdAAT4b3xhKQ1Dg2nCfY2TtQ@mail.gmail.com>
Reply To: <f07376b1-ffb7-4b13-97e6-a37b783ce37e@grasehotspot.org>
UTC Datetime: 2014-09-06 02:56:46 UTC
Raw Date: Sat, 06 Sep 2014 19:56:46 +1000

Raw message 

Can you show my a full picture of that error? It looks like the Squid
error. And it sounded like that was a client connected to the nightly?

I've updated the squid package, so install the latest nightly one and let
me know.

Also, the "service --status-all" command doesn't seem to show it even when
I fix the squid package. I know ubuntu uses Upstart, and I believe the
"initctl status squid3" command is what you need.

Tim




On Sat, Sep 6, 2014 at 6:30 PM, Mohammad Javad Ra'adi <
pe***t@gmail.com> wrote:

> i'm running the nightly build on ubuntu server 14.04.1 and its 32 bit
> edition, i'm sure there is a problem with the squid server because when i
> do "service --status-all" it doesn't show the squid at all. i have the
> stable version ubuntu server 12.04.4 and when i do "service --status-all" i
> can see that the squid3 is running. and when i do ls /etc/init.d i can see
> squid3 listed but i can't see it on my nightly. i tried "/etc/init.d/squid3
> start" on my nightly and it didn't return anything but on my client side i
> get the attachment picture. i ran apt-get upgrade for the last modification
> as you said.
> thank you tim
>
> On Saturday, September 6, 2014 12:39:24 PM UTC+4:30, timwhite88 wrote:
>>
>> Can you check that Squid is running?
>> What distro and architecture are you running on? (32bit vs 64bit).
>>
>> And was it a clean install of Grase or an upgrade? (From stable to
>> nightly?)
>>
>> Tim
>>
>>
>> On Sat, Sep 6, 2014 at 5:43 PM, Mohammad Javad <pe***.@gmail.com>
>> wrote:
>>
>>> Thank you Tim. It solved the problem i now can login. But I'm still not
>>> able to surf the web. I can ping like 8.8.8.8 and i can lookup internet
>>> hosts, I'm also able to open Ubuntu software center but i just can't open
>>> webpages. I tried apt-get update on my Ubuntu desktop client and it says
>>> unable to connect to ...... . I'm guessing it doesn't let me make http
>>> connections.
>>> What should i do now?
>>> Thanks again
>>> On Sep 6, 2014 11:52 AM, "Timothy White" <ti***.@gmail.com> wrote:
>>>
>>>> I've uploaded a new nightly that should fix that.
>>>>
>>>> Try installing it and check the cron script again.
>>>>
>>>> Tim
>>>>
>>>>
>>>> On Sat, Sep 6, 2014 at 4:35 PM, Mohammad Javad Ra'adi <
>>>> pe***.@gmail.com> wrote:
>>>>
>>>>> i got this error in my apache log file after i ran cron.php file:
>>>>>
>>>>> [Sat Sep 06 11:00:02.066620 2014] [:error] [pid 2131] [client
>>>>> 127.0.0.1:45866] PHP Fatal error:  Uncaught exception 'PDOException'
>>>>> with message 'SQLSTATE[42000]: Syntax error or access violation: 1091 Can't
>>>>> DROP 'ServiceType'; check that column/key exists' in
>>>>> /usr/share/grase/src/Grase/Database/Upgrade.php:364\nStack trace:\n#0
>>>>> /usr/share/grase/src/Grase/Database/Upgrade.php(364): PDO->exec('?
>>>>>            ...')\n#1 /usr/share/grase/src/Grase/Database/Upgrade.php(101):
>>>>> Grase\\Database\\Upgrade->fixPostAuthTable()\n#2
>>>>> /usr/share/grase/www/radmin/cron.php(53): Grase\\Database\\Upgrade->
>>>>> upgradeDatabase(Object(Grase\\Database\\Radmin))\n#3 {main}\n  thrown
>>>>> in /usr/share/grase/src/Grase/Database/Upgrade.php on line 364
>>>>>
>>>>>
>>>>> thank you tim
>>>>>
>>>>> On Saturday, September 6, 2014 10:52:13 AM UTC+4:30, timwhite88 wrote:
>>>>>>
>>>>>> This sounds like the cron function didn't run at package install
>>>>>> time. Just goto localhost/grase/radmin/cron.php (replace localhost
>>>>>> with the correct server ip) and check for any fatal errors when the Cron
>>>>>> script tries to run.
>>>>>>
>>>>>> Tim
>>>>>>
>>>>>>
>>>>>> On Sat, Sep 6, 2014 at 4:17 PM, Mohammad Javad Ra'adi <
>>>>>> pe***.@gmail.com> wrote:
>>>>>>
>>>>>>> There was no fatal PHP error in appache log file but i found this on
>>>>>>> radius log file:
>>>>>>> Error: rlm_sql (sql) in sql_postauth: Database query error - Unknown
>>>>>>> column 'ServiceType' in 'field list'
>>>>>>> i get this line every time i try to login with a voucher.
>>>>>>> what should i do?
>>>>>>>
>>>>>>> On Saturday, September 6, 2014 10:18:48 AM UTC+4:30, timwhite88
>>>>>>> wrote:
>>>>>>>
>>>>>>>> On Sat, Sep 6, 2014 at 3:13 PM, Mohammad Javad <
>>>>>>>> pe***.@gmail.com> wrote:
>>>>>>>>
>>>>>>>>> I tried everything from the beginning and yes i was able to see
>>>>>>>>> groups and creating new groups was fine. But I'm not able to login on the
>>>>>>>>> client side. It says: "login failed due to sever error. Please try again".
>>>>>>>>> What should i do? where can i see the log files?
>>>>>>>>> Thanks tim
>>>>>>>>>
>>>>>>>>> First thing would be to check for fatal PHP errors in the apache
>>>>>>>> error log.
>>>>>>>> Otherwise, check in the freeradius radius.log and see if that
>>>>>>>> helps. Normally that error suggests that freeradius isn't running, or the
>>>>>>>> perl module has errored. (So check that freeradius is actually running).
>>>>>>>>
>>>>>>>> Tim
>>>>>>>>
>>>>>>>  --
>>>>>>> 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 http://groups.google.com/a/gra
>>>>>>> sehotspot.org/group/grase-hotspot/.
>>>>>>> To view this discussion on the web visit
>>>>>>> https://groups.google.com/a/grasehotspot.org/d/msgid/grase-
>>>>>>> hotspot/baae000b-d5c3-4794-a256-5d81e796ea51%40grasehotspot.org
>>>>>>> <https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/baae000b-d5c3-4794-a256-5d81e796ea51%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 http://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/5e7709a7-f00a-
>>>>> 4600-8392-3668366b3ccf%40grasehotspot.org
>>>>> <https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/5e7709a7-f00a-4600-8392-3668366b3ccf%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 http://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/CAESLx0J0Qzz-1_
>>>> es1B24tK_A57TWJMHXogtB%2BvT_Ybn_GPbj7w%40mail.gmail.com
>>>> <https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/CAESLx0J0Qzz-1_es1B24tK_A57TWJMHXogtB%2BvT_Ybn_GPbj7w%40mail.gmail.com?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 http://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/CAL7r4-
>>> XdjjMRnixkDFYkXBrHYkvEam9ToTf_WeDPHt1atjKpjg%40mail.gmail.com
>>> <https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/CAL7r4-XdjjMRnixkDFYkXBrHYkvEam9ToTf_WeDPHt1atjKpjg%40mail.gmail.com?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
> http://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/f07376b1-ffb7-4b13-97e6-a37b783ce37e%40grasehotspot.org
> <https://groups.google.com/a/grasehotspot.org/d/msgid/grase-hotspot/f07376b1-ffb7-4b13-97e6-a37b783ce37e%40grasehotspot.org?utm_medium=email&utm_source=footer>
> .
>

Thread