Luigi123 Posted April 21, 2017 Posted April 21, 2017 Hello,I would like to open UDP and TCP port number 21725 for my Sourcebans connect to my Game Server. Hosting information Username: luigi123 Main Domain: edge-gamers.heliohost.org Server: Tommy Game Server information Public IP address: 158.69.57.87 Port number: 21725 Location: US If you have any questions, feel free to let me know. Thanks.
Krydos Posted April 21, 2017 Posted April 21, 2017 Is this instead of your existing port 21715 to 158.69.57.87 or do you need both?
Luigi123 Posted April 21, 2017 Author Posted April 21, 2017 The UDP and TCP port number 21725 is for my second Game Server.
Luigi123 Posted April 22, 2017 Author Posted April 22, 2017 Alright, It's working now. But, I got this error from my Sourcebans Log saying this "luigi123_sb already has more than 'max_user_connections' active connections. See FAQ: https://sarabveer.github.io/SourceBans-Fork/faq/" after I did everything.
Krydos Posted April 22, 2017 Posted April 22, 2017 It looks like you have 4 remote persistent mysql connections open just sleeping and doing nothing. Is it possible to not have persistent connections, but rather just connect when they need and then close the connection? One has been sleeping for 1688+ seconds without doing anything other than wasting Tommy's total available mysql connections.
Luigi123 Posted April 22, 2017 Author Posted April 22, 2017 What can I do? I only have 2 remote MySQL. https://www.dropbox.com/s/xdrrpz11whlm51m/Capture.PNG?dl=0
Krydos Posted April 23, 2017 Posted April 23, 2017 Those are just rules that allow remote connections. What I mean is there are four incoming connections from your IP that are persistently open.
Krydos Posted April 23, 2017 Posted April 23, 2017 I guess you have two options: 1) Edit whatever configuration or code that is running at 158.69.57.87 so it closes its connections. 2) Create another mysql user that has access to luigi123_sourcebanssb_bans, and run one gameserver on luigi123_sb and the other on luigi123_sb2.
Luigi123 Posted April 23, 2017 Author Posted April 23, 2017 How can I add another MySQL User and added to my database name "luigi123_sourcebanssb_bans"?
Krydos Posted April 23, 2017 Posted April 23, 2017 Go to https://tommy.heliohost.org:2083/frontend/paper_lantern/sql/index.htmlScroll down to add new user.Enter a username (eg: luigi123_sb2), password, confirm password, and click create user.Scroll down to add user to database.Select the luigi123_sb2, select the database luigi123_sourcebanssb_bans, and click add.Check the appropriate permissions required, and click make changes.
Recommended Posts