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

Header Data

From: Timothy White <ti***8@gmail.com>
Message Hash: 56e318ad862d0430c598ab426c3b84879f93a55f75e62b977d1746b4e78a6d76
Message ID: <CAESLx0Kh1pEbvE1x4wBS9n26LnBw1DzRR9d5j4sqmX9btHa+qg@mail.gmail.com>
Reply To: <1385427606.34998.YahooMailNeo@web124905.mail.ne1.yahoo.com>
UTC Datetime: 2013-11-27 01:30:21 UTC
Raw Date: Wed, 27 Nov 2013 18:30:21 +1000

Raw message 

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
>
>

Thread