Forums

Resolved
0 votes
Hello Community,

Alright so every other day I'm getting this error when i try to login to either webmail or owncloud.

Im not sure exactly what started triggering it but i usually have to restart everything to get it to clear up.

Any idea why the system database is getting too many connections after a few days?

Right now I'm the only user.

So far i have killed many of the network reporting apps as i saw somewhere else that those can cause this.
Tuesday, September 16 2014, 01:22 PM
Share this post:
Responses (12)
  • Accepted Answer

    Andrew
    Andrew
    Offline
    Tuesday, December 02 2014, 12:35 PM - #Permalink
    Resolved
    0 votes
    I got blacklisted!
    so then I opened a clear foundation ticket.
    4 hours later and 3 experts working we had it fixed!
    keeping port 22 closed would have stopped them!
    And a username and password were identical. That's what they used!
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, December 02 2014, 07:41 AM - #Permalink
    Resolved
    0 votes
    Just out of curiousity, how did you find out?
    The reply is currently minimized Show
  • Accepted Answer

    Andrew
    Andrew
    Offline
    Monday, December 01 2014, 08:01 PM - #Permalink
    Resolved
    0 votes
    My problem was solved.
    we discovered someone was using a ssh tunnel on port 25 to pipe email to the world,
    The reply is currently minimized Show
  • Accepted Answer

    dlbgp
    dlbgp
    Offline
    Monday, December 01 2014, 04:58 PM - #Permalink
    Resolved
    0 votes
    Good day, was this issue ever solved? I have the same issue and restarting the service temporarily fix's the problem.

    Thanks!
    The reply is currently minimized Show
  • Accepted Answer

    Andrew
    Andrew
    Offline
    Wednesday, October 22 2014, 04:08 PM - #Permalink
    Resolved
    0 votes
    Hello
    I just experienced a zarafa crash as well.
    I checked the number of connections to system-mysql and got over 300
    I restarted system-mysql with

    service system-mysqld restart

    and checked again and got 23

    the system-mysql log is rather empty.
    Just a few lines about the restart I had to do to get going again..
    The reply is currently minimized Show
  • Accepted Answer

    Monday, September 22 2014, 01:12 PM - #Permalink
    Resolved
    -1 votes
    OK - looks fine

    Do you have any third party clients connecting to the service? perhaps one is not terminating it's connections properly and leaving open database connections. The database has a default number of connections to maintain and can be modified to improve this number (150+) but that would seem only to be a work around and not to understand why its happening

    If you're happy to drop to the command line it might be useful to see how many connections are open? 'netstat -ntp | grep 3308'

    You can also count the number of connections by piping the output through wc, 'netstat -ntp | grep 3308 | wc -l'
    The reply is currently minimized Show
  • Accepted Answer

    Monday, September 22 2014, 03:08 AM - #Permalink
    Resolved
    0 votes
    8GB

    3 users total / 1 actually being used.

    system-mysql

    i don't use the mysql server app, everything is using the system database.

    Yes i have both webmail and owncloud using only 443, port 80 redirects to the 443 side of the site.

    Ill enable reports again but last time i checked there hasn't been any out of the norm traffic spikes or anything of the sort.


    Seems to take about 2-3 days to come back with this error and then i cannot log into webmail or owncloud as i get this message when trying.
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, September 21 2014, 09:19 PM - #Permalink
    Resolved
    0 votes
    Hi Nathan, did you see my response here? do you have enough RAM?

    How many users? which log file is the error shown in? mysql or system-mysql?
    http://www.clearfoundation.com/component/option,com_kunena/Itemid,232/catid,33/func,view/id,64010/limit,10/limitstart,10/#64215

    Is your webserver open to the world and could be the result of a brute force type login attack? you might find clues for failed authentication in the OwnCloud logs or monitor incoming port 80/443 traffic
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, September 20 2014, 01:50 AM - #Permalink
    Resolved
    0 votes
    done and done.

    took a day longer but ran into the same error still :(

    not sure were its coming from either..

    its becoming very irritating because i have to restart my gateway to resolve it.


    Anymore ideas? anyone? HALP!
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, September 17 2014, 06:34 AM - #Permalink
    Resolved
    0 votes
    pmacct is one of three programs installed be the app-network-detail-report and is only used by it. To remove it do:
    service pmacctd stop
    yum remove pmacct
    Instead of the service command you could do a "killall pmacctd". Normally be very careful about using "yum remove" as it can remove the heck of a lot of dependencies - "rpm -e" is safer. In this case yum is fine.
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, September 16 2014, 09:57 PM - #Permalink
    Resolved
    0 votes
    Forgive my ignorance,

    Whats pmacct? and is that the app name if indeed an app? yum remove pmacct ?
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, September 16 2014, 09:11 PM - #Permalink
    Resolved
    0 votes
    When killing the network reporting apps did you also remove pmacct? If not, please try removing it. I have no other ideas.
    The reply is currently minimized Show
Your Reply