2013-11-27 - Re: [GRASE-Hotspot] Radacct crashed

Header Data

From: jb <be***s@yahoo.com>
Message Hash: 13c48fadd1c97f6a0c818a129844ac55a49aee4938de4b504b909e89c9e51875
Message ID: <1385541180.73087.YahooMailNeo@web124901.mail.ne1.yahoo.com>
Reply To: <CAESLx0Kh1pEbvE1x4wBS9n26LnBw1DzRR9d5j4sqmX9btHa+qg@mail.gmail.com>
UTC Datetime: 2013-11-27 01:33:00 UTC
Raw Date: Wed, 27 Nov 2013 00:33:00 -0800

Raw message 

any incoming ports do i need to enable in my firewall?



On Wednesday, November 27, 2013 4:30 PM, Timothy White <ti***8@gmail.com> wrote:
 
Just outgoing ports like you'd normally have for a web browser. I assume you are asking about on the WAN side.

Tim



On Tue, Nov 26, 2013 at 11:00 AM, jb <be***s@yahoo.com> wrote:

hi tim..
>
>
>a query.
>what incoming and outgoing tcp/udp ports do i need to allow for the grase server?
>
>
>ty
>jb
>
>
>
>On Wednesday, October 30, 2013 1:59 PM, Timothy White <ti***8@gmail.com> wrote:
> 
>Interesting.
>
>
>One of the keys is just a key, the other is a unique key. Having both won't hurt. I believe what must have happened is initially just the key was there, but then I wanted the unique constraint, and so added it. I don't think it should have ever had both keys, but it's not hurting it.
>
>
>I believe it's been in the database code since the first BZR commit, so it dates back a long way.
>
>
>Tim
>
>
>
>On Fri, Jul 12, 2013 at 5:02 AM, Drazen <dr***a@radez.hr> wrote:
>
>Just when decided to put new server in production, discovered that radacct crashed. Couldnt open "users" or "sessions" pages.
>>This is Admin log:
>>"FATAL: 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 UserName,
    SUM(radacct.AcctInputOctets)+SUM(radacct.AcctOutputOctets) AS
    AcctTotalOctets, SUM(AcctSessionTime) AS AcctSessionTime,
    MAX(AcctStopTime) AS LastLogout FROM radacct GROUP BY UserName]
    [Native code: 1194]
    [Native message: Table 'radacct' is marked as crashed and should be repaired] "]"
>>
>>Then I had to install phpmyadmin, and saw that 'radacct' table was
    marked "crashed" and reparation needed.
>>Funy thing what I discover there was two keys in radacct table:
    AcctUniqueId and AcctUniqueId_2, both indexed on AcctUniqueId
    collumn 'unique'.
>>Even phpMyAdmin recomends to remove one key.
>>
>>After repairing table, 'Users' and 'Sessions' pages worked normally,
    but double key still exist there.
>>Have no clue how that happened and should I delete one key?
>>
>>Regards
>>Drazen
>>
>>------------------------------------------------------------------------------
>>See everything from the browser to the database with AppDynamics
>>Get end-to-end visibility with application monitoring from AppDynamics
>>Isolate bottlenecks and diagnose root cause in seconds.
>>Start your free trial of AppDynamics Pro today!
>>http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
>>_______________________________________________
>>Grase-hotspot mailing list
>>Gr***t@lists.sourceforge.net
>>https://lists.sourceforge.net/lists/listinfo/grase-hotspot
>>
>>
>
>------------------------------------------------------------------------------
>Android is increasing in popularity, but the open development platform that
>developers love is also attractive to malware creators. Download this white
>paper to learn more about secure code signing practices that can help keep
>Android apps secure.
>http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk
>
>_______________________________________________
>Grase-hotspot mailing list
>Gr***t@lists.sourceforge.net
>https://lists.sourceforge.net/lists/listinfo/grase-hotspot
>
>
>
>------------------------------------------------------------------------------
>Shape the Mobile Experience: Free Subscription
>Software experts and developers: Be at the forefront of tech innovation.
>Intel(R) Software Adrenaline delivers strategic insight and game-changing
>conversations that shape the rapidly evolving mobile landscape. Sign up now.
>http://pubads.g.doubleclick.net/gampad/clk?id=63431311&iu=/4140/ostg.clktrk
>_______________________________________________
>Grase-hotspot mailing list
>Gr***t@lists.sourceforge.net
>https://lists.sourceforge.net/lists/listinfo/grase-hotspot
>
>


------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT 
organizations don't have a clear picture of how application performance 
affects their revenue. With AppDynamics, you get 100% visibility into your 
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk

_______________________________________________
Grase-hotspot mailing list
Gr***t@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/grase-hotspot

Thread