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

Header Data

From: Mohammad Javad Ra’adi <pe***t@gmail.com>
Message Hash: 47bb9ac2590be84d3dc94b3da7bc0c89d26d8478dd388c99c6793e9d69f3abf8
Message ID: <5e7709a7-f00a-4600-8392-3668366b3ccf@grasehotspot.org>
Reply To: <CAESLx0LyUsC=dqJuXbDSNsemya5zrTwwtwgtSMfnbbTk8Cy_JA@mail.gmail.com>
UTC Datetime: 2014-09-05 23:35:53 UTC
Raw Date: Fri, 05 Sep 2014 23:35:53 -0700

Raw message 

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 <javascript:>> 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 <javascript:>.
>> To post to this group, send email to gr***.@grasehotspot.org 
>> <javascript:>.
>> 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/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>
>> .
>>
>
>

Thread