Powerline misreporting available computers

[JesseMc]

Powerline has been working flawlessly for over six months now but just
today began misreporting the computers available. We have five patron
computers (#1, #2, #3, #4, #5) but Powerline only says that #2, #3,
and #4 are available even if none are in use - it is consistent in
ignoring #1 and #5. Even though #1 and #5 are not being presented as
available it is *sometimes* possible to login to one of these
machines.

Things I've tried: delete and restore # 1 and #5 - no change
ran mysqlcheck (--optimize|--repair) on the database - all four tables
returned "OK"
shutdown and restarted mysql and powerline -- no change
rebooted server, restarted powerline etc -- no change.

Anyone seen this before/any suggestions on how to troubleshoot this
issue further?

Thanks!

Jesse

[Jesse]

Hi other Jesse,

This is a known problem with Powerline; if a session isn't closed properly on a particular system, it'll keep taking up that system even if it happened a month ago.

Here's how to fix it, using a mysql prompt:

SELECT * FROM sessions WHERE end_time IS NULL AND DATE(timestamp) < CURRENT_DATE; -- Just to check that old sessions are actually causing your problem
DELETE FROM sessions WHERE end_time IS NULL AND DATE(timestamp) < CURRENT_DATE; -- Actually delete them

2010/12/13 JesseMc <jessemc...@gmail.com>

--
You received this message because you are subscribed to the Google Groups "Powerline Discussion" group.
To post to this group, send email to powerlin...@googlegroups.com.
To unsubscribe from this group, send email to powerline-disc...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/powerline-discuss?hl=en.

Apologies for the issue,
--
Jesse Weaver

[JesseMc]

Hi Jesse numero uno,

That fixed it, there were two sessions from December 6 with a NULL end
time. Thanks for the help and the really quick response!

Jesse

On Dec 14, 12:06 am, Jesse <pianohac...@gmail.com> wrote:
> Hi other Jesse,
>
> This is a known problem with Powerline; if a session isn't closed properly
> on a particular system, it'll keep taking up that system even if it happened
> a month ago.
>
> Here's how to fix it, using a mysql prompt:
>
> SELECT * FROM sessions WHERE end_time IS NULL AND DATE(timestamp) <
> CURRENT_DATE; -- Just to check that old sessions are actually causing your
> problem
> DELETE FROM sessions WHERE end_time IS NULL AND DATE(timestamp) <
> CURRENT_DATE; -- Actually delete them
>

> 2010/12/13 JesseMc <jessemcdonn...@gmail.com>

>
>
>
> > Powerline has been working flawlessly for over six months now but just
> > today began misreporting the computers available. We have five patron
> > computers (#1, #2, #3, #4, #5) but Powerline only says that #2, #3,
> > and #4 are available even if none are in use - it is consistent in
> > ignoring #1 and #5. Even though #1 and #5 are not being presented as
> > available it is *sometimes* possible to login to one of these
> > machines.
>
> > Things I've tried: delete and restore # 1 and #5 - no change
> > ran mysqlcheck (--optimize|--repair) on the database - all four tables
> > returned "OK"
> > shutdown and restarted mysql and powerline --  no change
> > rebooted server, restarted powerline etc -- no change.
>
> > Anyone seen this before/any suggestions on how to troubleshoot this
> > issue further?
>
> > Thanks!
>
> > Jesse
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "Powerline Discussion" group.
> > To post to this group, send email to powerlin...@googlegroups.com.
> > To unsubscribe from this group, send email to

> > powerline-disc...@googlegroups.com<powerline-discuss%2Bunsu...@googlegroups.com>
> > .