Jump to content
  • 0

Ubuntu Mysql Too Many Connections after launching gameserver


Question

Posted

Hi there,

 

My problem is: I can connect remotely to the database (using navicat) when the gameserver isn't running.

However after I launch the gameserver on my server machine and I try to connect remotely to the database I get the Too Many Connections error.

After I kill the gameserver I'm still unable to connect to the DB until i restart mysql.

 

And the same thing happens if I simply quit navicat while I'm logged in the DB without closing the connection first.

 

Does anyone have any ideas what may be the issue?

 

 

Recommended Posts

  • 0
Posted (edited)
4 hours ago, Horse said:

As for HeidiSQL I used it before switching  to  Navicat Premium which seems far better in my humble opinion, but each to its own, i guess

I bet that you're using it from Windows, yeah, that's explain everything. Windows, Putty and Navicat.. lol. 

I just tried to help you to switch back to Linux, HeidiSQL and Terminal, but nevermind go with Bill you deserve eachother. haha..

 

@Kara` < No comments! 

 

P.S. Don't be shitty programmer with a handicap, Windows is for users and all programs which are running on Windows, forget Windows and sh1t. Use Linux in everything. 

.. but nevermind you're free to use whatever you like. Is not my business.

 

Sorry for my partially offtipic. 

 

I forgot to ask you smtg, your gamserver is hosted on Linux or Windows? Try to allow your IP address from server firewall.

Edited by Irelia#1
  • 0
Posted
1 minute ago, Irelia#1 said:

I bet that you're using it from Windows, yeah, that's explain everything. Windows, Putty and Navicat.. lol. 

I just tried to help you to switch back to Linux, HeidiSQL and Terminal, but nevermind go with Bill you deserve eachother. haha..

 

@Kara` < No comments! 

 

P.S. Don't be shitty programmer with a handicap, Windows is for users and all programs which are running on Windows, forget Windows and sh1t. Use Linux in everything. 

.. but nevermind you're free to use whatever you like. Is not my business.

 

Sorry for my partially offtipic. 

Since my deskopt pc is running on windows yea, using navicat for remote  connection is a given.

  • 0
Posted (edited)
24 minutes ago, Horse said:

Since my deskopt pc is running on windows yea, using navicat for remote  connection is a given.

Really I want to help you, but what I can't understand is that you have your gameserver on your local machine with Windows, right? But why to connect as remote on your localhost? Anyway in case if you want to connect remotely then check your .cnf file there you'll see a localhost restriction .. just comment that restriction to allow remote connections and that's all. 

Edited by Irelia#1
  • 0
Posted (edited)
21 minutes ago, Irelia#1 said:

Really I want to help you, but what I can't understand is that you have your gameserver on your local machine with Windows, right? But why to connect as remote on your localhost? Anyway in case if you want to connect remotely then check your .cnf file there you'll see a localhost restriction .. just comment that restriction to allow remote connections and that's all. 

no no no, . The server is running on a Linux ubuntu dedicated machine. And I REMOTELY CONNECT to the DB through navicat from MY WIN7 deskopt pc.

 

And the mystery to me is that, when I was testing the server on my own PC Win7 and connected locally to the DB with navicat I never had the Too Many Connection error.

 

 

In a nutshell there are two big mysteries to me here:

 

1: When I run the server from the Linux OS Dedicated, I need to set the max_connections in the mysql's cnf higher than the MaxDBConnections in the server.properties file. Like MaxDBConnections: 100 in server.properties and in the Linux Server Mysql max_connection: 101 atleast to be able to connect to the server when the gameserver is running.

 

2: It seems that when I connect to the db with navicat and do not properly close the connection in navicat, or even if I try to connect with an unauthorized user and fail to actually enter the db,  that connection seems to stay active. And again, I didn't experienced such problem when I used My own Pc or when I temporarly uploaded my server to a win 2008 VPS.

It's as if idle or inactive connections stay alive when they shouldn't.

Edited by Horse

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



  • Posts

    • My official facebook profile!: https://www.facebook.com/spectrumL2 Specifications: Revamped L2JACIS revision FROM the core Private project!!! Revision that has been receiving corrections for over 3 years!!! Events already installed in the revision: TVT CTF KTB PARTY FARM SPOIL EVENT CRAZY RATES TOURNAMENT TIME ZONE (INSTANCE) All working correctly!!! SIEGE ESSENTIAL FEATURES: Walls fix Gates fix Flags fix 100% functional: OLYMPIADS: Implemented settings Hero receives enchanted Weapons with equal status PvP Weapons Optional /true/false Hero can acquire all Hero Weapons Optional true/false OTHER IMPLEMENTATIONS: Teleport fixed (directly to Giran) Teleport effect classic Vip skins vip collor name Pack NPCs with effect already configured BOSES already configured Mobs already configured CLASS BALANCE SPECIAL SYSTEM We have a SPECIAL system developed for Class Balance with only 1 digit in XML %tage of configurable debuffs Player limitation system in BOSES or PvP zones BS blocking system in FLEG zones or events Among others dozens of improvements made in the review... price: 390 USD !  OBS: WE CAN CHANGE THE BANNER AND NAME OF THE SERVICE TO THE ONE OF YOUR PREFERENCE BUT THE SETTINGS MUST BE KEPT ANY CHANGES REQUIRE ADDITION        
    • Server is Online – 1,000+ Active Players! We’re excited to announce the addition of a Europe Proxy to improve connectivity for our EU players! Clans can now benefit from VIP Access to help you catch up faster. 🎯 If you're a clan leader with at least 9 active members, join our Discord and open a ticket to claim your VIP rewards!  
    • The Telegram team is rolling out a new batch of Stars-only gifts you’ll be able to mint as NFTs. Don’t miss your chance to join the next Telegram trend and earn from it! Buy Telegram Stars cheap and KYC-free 1 Star from $0.0149 (min. 50 Stars, bulk discounts available) Promo code STARS5 — 5 % off Pay any way you like: bank cards · crypto · other popular methods How to purchase: ➡Online Store — Click ➡ Telegram bot — Click Other services: ➡ SMM panel — Click Regular buyers get extra discounts and promo codes. Support: ➡ Telegram: https://t.me/solomon_bog ➡ Telegram channel: https://t.me/accsforyou_shop ➡ Discord: https://discord.gg/y9AStFFsrh ➡ WhatsApp: https://wa.me/79051904467 ➡ Email: solomonbog@socnet.store Use these contacts to discuss wholesale orders, partnerships (current list: https://socnet.bgng.io/partners) or to become a supplier. SocNet — your shop for digital goods and premium subscriptions
    • The Telegram team is rolling out a new batch of Stars-only gifts you’ll be able to mint as NFTs. Don’t miss your chance to join the next Telegram trend and earn from it! Buy Telegram Stars cheap and KYC-free 1 Star from $0.0149 (min. 50 Stars, bulk discounts available) Promo code STARS5 — 5 % off Pay any way you like: bank cards · crypto · other popular methods How to purchase: ➡Online Store — Click ➡ Telegram bot — Click Other services: ➡ SMM panel — Click Regular buyers get extra discounts and promo codes. Support: ➡ Telegram: https://t.me/solomon_bog ➡ Telegram channel: https://t.me/accsforyou_shop ➡ Discord: https://discord.gg/y9AStFFsrh ➡ WhatsApp: https://wa.me/79051904467 ➡ Email: solomonbog@socnet.store Use these contacts to discuss wholesale orders, partnerships (current list: https://socnet.bgng.io/partners) or to become a supplier. SocNet — your shop for digital goods and premium subscriptions
  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock