[prev in list] [next in list] [prev in thread] [next in thread]
List: security-onion
Subject: Re: [security-onion] ERROR 1040 (HY000): Too many connections
From: Wes Lambert <wlambertts () gmail ! com>
Date: 2017-04-21 19:07:14
Message-ID: CAHjBB6HjxC4qx9SMbrgPxtcuTL+VS-d2fuN_aZK2NAJRqo44JQ () mail ! gmail ! com
[Download RAW message or body]
Corey,
Have you tried going through the guidance found here?
https://github.com/Security-Onion-Solutions/security-onion/wiki/FAQ#why-does-sostat-show-high-loadcpu-usage-and-large-number-of-perl-processes
Thanks,
Wes
On Apr 21, 2017 1:18 PM, <theitguyonline1@gmail.com> wrote:
> Hi,
>
> I got the following error message in Elsa:
> cannot connect to dbi:mysql:database=syslog;port=3306: Too many
> connections at /opt/elsa/web/lib/SyncMysql.pm line 18.
>
> I updated yesterday (sudo soup) with no errors/issues. I ran sostat and
> found an extraordinary number of "perl /opt/elsa/web/cron.pl -c
> /etc/elsa_web.conf" processes. I read some of the previous threads, but the
> circumstances for those instances didn't apply here.
>
> I could use some help understanding why there are so many connections and
> how I can restore the system to a usable state.
>
>
> I've attached the redacted sostat details.
>
> Thanks,
> Corey
>
> --
> Follow Security Onion on Twitter!
> https://twitter.com/securityonion
> ---
> You received this message because you are subscribed to the Google Groups
> "security-onion" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to security-onion+unsubscribe@googlegroups.com.
> To post to this group, send email to security-onion@googlegroups.com.
> Visit this group at https://groups.google.com/group/security-onion.
> For more options, visit https://groups.google.com/d/optout.
>
--
Follow Security Onion on Twitter!
https://twitter.com/securityonion
---
You received this message because you are subscribed to the Google Groups \
"security-onion" group. To unsubscribe from this group and stop receiving emails from \
it, send an email to security-onion+unsubscribe@googlegroups.com. To post to this \
group, send email to security-onion@googlegroups.com. Visit this group at \
https://groups.google.com/group/security-onion. For more options, visit \
https://groups.google.com/d/optout.
[Attachment #3 (text/html)]
<div dir="auto">Corey,<div dir="auto"><br></div><div dir="auto">Have you tried going \
through the guidance found here?</div><div dir="auto"><br></div><div dir="auto"><a \
href="https://github.com/Security-Onion-Solutions/security-onion/wiki/FAQ#why-does-sos \
tat-show-high-loadcpu-usage-and-large-number-of-perl-processes">https://github.com/Sec \
urity-Onion-Solutions/security-onion/wiki/FAQ#why-does-sostat-show-high-loadcpu-usage-and-large-number-of-perl-processes</a><br></div><div \
dir="auto"><br></div><div dir="auto">Thanks,</div><div dir="auto">Wes</div><div \
dir="auto"><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On \
Apr 21, 2017 1:18 PM, <<a \
href="mailto:theitguyonline1@gmail.com">theitguyonline1@gmail.com</a>> wrote:<br \
type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br> <br>
I got the following error message in Elsa:<br>
cannot connect to dbi:mysql:database=syslog;<wbr>port=3306: Too many connections at \
/opt/elsa/web/lib/SyncMysql.pm line 18.<br> <br>
I updated yesterday (sudo soup) with no errors/issues. I ran sostat and found an \
extraordinary number of "perl /opt/elsa/web/<a href="http://cron.pl" \
rel="noreferrer" target="_blank">cron.pl</a> -c /etc/elsa_web.conf" processes. I \
read some of the previous threads, but the circumstances for those instances \
didn't apply here.<br> <br>
I could use some help understanding why there are so many connections and how I can \
restore the system to a usable state.<br> <br>
<br>
I've attached the redacted sostat details.<br>
<br>
Thanks,<br>
Corey<br>
<br>
--<br>
Follow Security Onion on Twitter!<br>
<a href="https://twitter.com/securityonion" rel="noreferrer" \
target="_blank">https://twitter.com/<wbr>securityonion</a><br>
---<br>
You received this message because you are subscribed to the Google Groups \
"security-onion" group.<br> To unsubscribe from this group and stop \
receiving emails from it, send an email to <a \
href="mailto:security-onion%2Bunsubscribe@googlegroups.com">security-onion+unsubscribe@<wbr>googlegroups.com</a>.<br>
To post to this group, send email to <a \
href="mailto:security-onion@googlegroups.com">security-onion@googlegroups.<wbr>com</a>.<br>
Visit this group at <a href="https://groups.google.com/group/security-onion" \
rel="noreferrer" target="_blank">https://groups.google.com/<wbr>group/security-onion</a>.<br>
For more options, visit <a href="https://groups.google.com/d/optout" \
rel="noreferrer" target="_blank">https://groups.google.com/d/<wbr>optout</a>.<br> \
</blockquote></div></div>
<p></p>
-- <br />
Follow Security Onion on Twitter!<br />
<a href="https://twitter.com/securityonion">https://twitter.com/securityonion</a><br \
/>
--- <br />
You received this message because you are subscribed to the Google Groups \
"security-onion" group.<br /> To unsubscribe from this group and stop \
receiving emails from it, send an email to <a \
href="mailto:security-onion+unsubscribe@googlegroups.com">security-onion+unsubscribe@googlegroups.com</a>.<br \
/> To post to this group, send email to <a \
href="mailto:security-onion@googlegroups.com">security-onion@googlegroups.com</a>.<br \
/> Visit this group at <a \
href="https://groups.google.com/group/security-onion">https://groups.google.com/group/security-onion</a>.<br \
/> For more options, visit <a \
href="https://groups.google.com/d/optout">https://groups.google.com/d/optout</a>.<br \
/>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic