2013-12-07 - Re: [GRASE-Hotspot] Radacct crashed

Header Data

From: Timothy White <ti***8@gmail.com>
Message Hash: d8726e46a468e7331f7cafa82cece4413cb70abbcdf33b03151565a5d02a7b5e
Message ID: <CAESLx0Kw8ZcJ6jJ3xkF5k2cX_m=MHDPHBR4Qb2deQUan6StwSg@mail.gmail.com>
Reply To: <1385541180.73087.YahooMailNeo@web124901.mail.ne1.yahoo.com>
UTC Datetime: 2013-12-07 23:19:15 UTC
Raw Date: Sun, 08 Dec 2013 16:19:15 +1000

Raw message

Nope.


On Wed, Nov 27, 2013 at 6:33 PM, jb <be***s@yahoo.com> wrote:

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