NATION

PASSWORD

Too many connections SQL error

Bug reports, general help, ideas for improvements, and questions about how things are meant to work.
User avatar
Nacrad
Ambassador
 
Posts: 1449
Founded: Jan 16, 2020
Left-Leaning College State

Too many connections SQL error

Postby Nacrad » Sun Apr 11, 2021 4:56 pm

Is anyone getting the "Too Many Connections" SQL error very often? The site is barely usable in the gaps of attacks
OOC - HRT 19.07.2023
Call me Hannah
Pronouns: She/They

Basically the result of Anglo-Dutch quarrels on who can profit more from Mingsplosion, coming to a retcon near you!

International News: HUNGARY IS OUT: Hungary quits the Warsaw Pact | Greece legalises same-sex marriage
Domestic News: 16 FEB 2024 (FRI) | Year of the Dragon: 10% birth rate boost expected, says Dept. of Health | CSG Resolute departs for ally visit | Highways & Transport Dept. revives M17 Motorway project between Namchon, KX and Samming, LK
Weather: Riverfort 23/27°C | Amoy 19/21°C | Taipei 23/25°C | Namchon 13/26°C


User avatar
Cavirfi
Ambassador
 
Posts: 1159
Founded: Feb 28, 2021
Ex-Nation

Postby Cavirfi » Sun Apr 11, 2021 4:58 pm

Nacrad wrote:Is anyone getting the "Too Many Connections" SQL error very often? The site is barely usable in the gaps of attacks

Yes, I am experiencing these errors too. I think the mods are trying to deal with the recent waves of post and nation spam? That's just my theory
My Storefronts | THE Barn | Set up an Embassy to Cavirfi

CAVIRFI ONE: #BoycottCavirfi movement enters Day 203; CBCC-Cavirfite Wing Strike enters Day 181 | 529 days left until Federal Police inaugurated, Training enters Day 203 | Crabaiaian Electoral Board declares 2023 Federal Election to be held on July 9 for Amine and Imguria and July 16 for the rest of the country | Chano-Cavirfite Sea Storm hits Cavirfi at wind speeds of 54 km/h, causes mild damage; Inauguration of new Great Tribunal, Technocratic Council, and Ministers postponed indefinitely | Average Weather: 20.91℃

User avatar
Miraaki
Ambassador
 
Posts: 1008
Founded: May 01, 2016
Ex-Nation

Postby Miraaki » Sun Apr 11, 2021 4:59 pm

Its a DDOS attack. Almost certainly
P2TMs Cuddly Trap
Formerly Mirakai. Fucked up and got DEATed

User avatar
Eshialand
Diplomat
 
Posts: 972
Founded: Apr 03, 2017
Anarchy

Postby Eshialand » Sun Apr 11, 2021 5:01 pm

Yup. I don't know if it's a Denial of Service attack or just a high amount of traffic.
Anything I say is IC unless proven otherwise by a court of law.

(he/him/any/all)

User avatar
Miraaki
Ambassador
 
Posts: 1008
Founded: May 01, 2016
Ex-Nation

Postby Miraaki » Sun Apr 11, 2021 5:01 pm

Eshialand wrote:Yup. I don't know if it's a Denial of Service attack or just a high amount of traffic.

considering there was a ton of spam right before it, I can almost guarantee it was a DDOS
P2TMs Cuddly Trap
Formerly Mirakai. Fucked up and got DEATed

User avatar
Cavirfi
Ambassador
 
Posts: 1159
Founded: Feb 28, 2021
Ex-Nation

Postby Cavirfi » Sun Apr 11, 2021 5:02 pm

Eshialand wrote:Yup. I don't know if it's a Denial of Service attack or just a high amount of traffic.

It's a probably both? A DDOS attacker creates many nations to the point of high traffic? I mean isn't that how DDOS attacks work?
My Storefronts | THE Barn | Set up an Embassy to Cavirfi

CAVIRFI ONE: #BoycottCavirfi movement enters Day 203; CBCC-Cavirfite Wing Strike enters Day 181 | 529 days left until Federal Police inaugurated, Training enters Day 203 | Crabaiaian Electoral Board declares 2023 Federal Election to be held on July 9 for Amine and Imguria and July 16 for the rest of the country | Chano-Cavirfite Sea Storm hits Cavirfi at wind speeds of 54 km/h, causes mild damage; Inauguration of new Great Tribunal, Technocratic Council, and Ministers postponed indefinitely | Average Weather: 20.91℃

User avatar
Zarnicovia nova
Postmaster-General
 
Posts: 10209
Founded: Jun 03, 2020
Democratic Socialists

Postby Zarnicovia nova » Sun Apr 11, 2021 5:04 pm

Cavirfi wrote:
Eshialand wrote:Yup. I don't know if it's a Denial of Service attack or just a high amount of traffic.

It's a probably both? A DDOS attacker creates many nations to the point of high traffic? I mean isn't that how DDOS attacks work?

and posts
The Abrahamic Republic of Zarnicovia Nova


Free Palestine!


User avatar
Eshialand
Diplomat
 
Posts: 972
Founded: Apr 03, 2017
Anarchy

Postby Eshialand » Sun Apr 11, 2021 5:06 pm

Cavirfi wrote:
Eshialand wrote:Yup. I don't know if it's a Denial of Service attack or just a high amount of traffic.

It's a probably both? A DDOS attacker creates many nations to the point of high traffic? I mean isn't that how DDOS attacks work?

By "a high amount of traffic" I mean genuine traffic, i.e. not a DDoS.
Anything I say is IC unless proven otherwise by a court of law.

(he/him/any/all)

User avatar
Cavirfi
Ambassador
 
Posts: 1159
Founded: Feb 28, 2021
Ex-Nation

Postby Cavirfi » Sun Apr 11, 2021 5:09 pm

Eshialand wrote:
Cavirfi wrote:It's a probably both? A DDOS attacker creates many nations to the point of high traffic? I mean isn't that how DDOS attacks work?

By "a high amount of traffic" I mean genuine traffic, i.e. not a DDoS.

Okay then, it's probably a DDOS
My Storefronts | THE Barn | Set up an Embassy to Cavirfi

CAVIRFI ONE: #BoycottCavirfi movement enters Day 203; CBCC-Cavirfite Wing Strike enters Day 181 | 529 days left until Federal Police inaugurated, Training enters Day 203 | Crabaiaian Electoral Board declares 2023 Federal Election to be held on July 9 for Amine and Imguria and July 16 for the rest of the country | Chano-Cavirfite Sea Storm hits Cavirfi at wind speeds of 54 km/h, causes mild damage; Inauguration of new Great Tribunal, Technocratic Council, and Ministers postponed indefinitely | Average Weather: 20.91℃

User avatar
New Jacobland
Diplomat
 
Posts: 521
Founded: Oct 01, 2019
Ex-Nation

Postby New Jacobland » Sun Apr 11, 2021 5:54 pm

I had this same issue. It seems likely NS is getting DDOSed because a person was spamming probably with bots everywhere on the forum.
Link here

My nation does not reflect my IRL views

If I am in a non-The Western Isles RP, ignore all factbooks not marked [FORUM].

Likes: Cricket, tennis, Australia, democracy
Dislikes: Guns, warfare, CCP, Modi, North Korea, cigarettes

User avatar
United Republic Empire
Chargé d'Affaires
 
Posts: 398
Founded: Jul 27, 2014
Left-Leaning College State

Postby United Republic Empire » Mon Apr 12, 2021 5:08 pm

General Error
SQL ERROR [ mysqli ]

Too many connections [1040]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

User avatar
Parxland
Chargé d'Affaires
 
Posts: 455
Founded: Apr 21, 2020
Ex-Nation

Postby Parxland » Tue Apr 13, 2021 5:42 pm

I was trying to read this thread about the SQL errors, but I got an SQL error when I clicked the title.
- < D O O M > -

User avatar
Southeast Marajarbia
Post Marshal
 
Posts: 18891
Founded: Mar 21, 2021
Moralistic Democracy

Postby Southeast Marajarbia » Tue Apr 13, 2021 5:45 pm

Every day at around 6:00 P.M ET, these errors keep on continuing, and a new nation is found pornspamming the forums.
Just a regular old II Superpower nation, and large scale trading empire that likes to have fun! You (the reader) can find me all over II nowadays, so I suggest having a chat.

Some NS stats are not canon. Nation represents some (not all) of my RL views

Join I&II (An NS news thread open to everybody and anybody) here: viewtopic.php?f=5&t=525784

User avatar
Eshialand
Diplomat
 
Posts: 972
Founded: Apr 03, 2017
Anarchy

Postby Eshialand » Tue Apr 13, 2021 5:58 pm

Southeast Marajarbia wrote:Every day at around 6:00 P.M ET, these errors keep on continuing, and a new nation is found pornspamming the forums.

It's the ciiiircle of lifeeee

Seriously though, is this just gonna keep happening?
Anything I say is IC unless proven otherwise by a court of law.

(he/him/any/all)

User avatar
Southeast Marajarbia
Post Marshal
 
Posts: 18891
Founded: Mar 21, 2021
Moralistic Democracy

Postby Southeast Marajarbia » Tue Apr 13, 2021 6:30 pm

Eshialand wrote:
Southeast Marajarbia wrote:Every day at around 6:00 P.M ET, these errors keep on continuing, and a new nation is found pornspamming the forums.

It's the ciiiircle of lifeeee

Seriously though, is this just gonna keep happening?


I mean, unless the mods IP ban the original guy. Whoever is doing this is obviously the same person, with the same IP Address. Unless he is using bots to DDOS the servers.
Just a regular old II Superpower nation, and large scale trading empire that likes to have fun! You (the reader) can find me all over II nowadays, so I suggest having a chat.

Some NS stats are not canon. Nation represents some (not all) of my RL views

Join I&II (An NS news thread open to everybody and anybody) here: viewtopic.php?f=5&t=525784

User avatar
Reploid Productions
Director of Moderation
 
Posts: 30507
Founded: Antiquity
Democratic Socialists

Postby Reploid Productions » Tue Apr 13, 2021 7:39 pm

Southeast Marajarbia wrote:I mean, unless the mods IP ban the original guy. Whoever is doing this is obviously the same person, with the same IP Address. Unless he is using bots to DDOS the servers.

Once again, "IP bans" are not the magic bullet folks think they are. IP addresses are very easy to change (often without the user even being aware of it. You can check out your own info, you might be surprised how many IPs you have!), and IP bans are not difficult to evade.
Forum mod since May 8, 2003 -- Game mod since May 19, 2003 -- Nation turned 20 on March 23, 2023!
Sunset's DoGA FAQ - For those using DoGA to make their NS military and such.
One Stop Rules Shop -- Reppy's Sig Workshop -- Getting Help Page
[violet] wrote:Maybe we could power our new search engine from the sexual tension between you two.
Char Aznable/Giant Meteor 2024! - Forcing humanity to move into space and progress whether we goddamn want to or not!

User avatar
Southeast Marajarbia
Post Marshal
 
Posts: 18891
Founded: Mar 21, 2021
Moralistic Democracy

Postby Southeast Marajarbia » Tue Apr 13, 2021 7:44 pm

Reploid Productions wrote:
Southeast Marajarbia wrote:I mean, unless the mods IP ban the original guy. Whoever is doing this is obviously the same person, with the same IP Address. Unless he is using bots to DDOS the servers.

Once again, "IP bans" are not the magic bullet folks think they are. IP addresses are very easy to change (often without the user even being aware of it. You can check out your own info, you might be surprised how many IPs you have!), and IP bans are not difficult to evade.


I have all of those IPs because I travel a lot, and I wanted to hang out with a few friends. Getting back on topic, I doubt that whoever is doing this just has another house. Just IP ban him once, and if it happens again, we will all see.
Just a regular old II Superpower nation, and large scale trading empire that likes to have fun! You (the reader) can find me all over II nowadays, so I suggest having a chat.

Some NS stats are not canon. Nation represents some (not all) of my RL views

Join I&II (An NS news thread open to everybody and anybody) here: viewtopic.php?f=5&t=525784

User avatar
Cavirfi
Ambassador
 
Posts: 1159
Founded: Feb 28, 2021
Ex-Nation

Postby Cavirfi » Tue Apr 13, 2021 7:46 pm

Southeast Marajarbia wrote:
Reploid Productions wrote:Once again, "IP bans" are not the magic bullet folks think they are. IP addresses are very easy to change (often without the user even being aware of it. You can check out your own info, you might be surprised how many IPs you have!), and IP bans are not difficult to evade.


I have all of those IPs because I travel a lot, and I wanted to hang out with a few friends. Getting back on topic, I doubt that whoever is doing this just has another house. Just IP ban him once, and if it happens again, we will all see.

Again, like Reppy said, IP Bans won't do anything. Whoever is the culprit can simply change their computer or even use VPN.
My Storefronts | THE Barn | Set up an Embassy to Cavirfi

CAVIRFI ONE: #BoycottCavirfi movement enters Day 203; CBCC-Cavirfite Wing Strike enters Day 181 | 529 days left until Federal Police inaugurated, Training enters Day 203 | Crabaiaian Electoral Board declares 2023 Federal Election to be held on July 9 for Amine and Imguria and July 16 for the rest of the country | Chano-Cavirfite Sea Storm hits Cavirfi at wind speeds of 54 km/h, causes mild damage; Inauguration of new Great Tribunal, Technocratic Council, and Ministers postponed indefinitely | Average Weather: 20.91℃

User avatar
Southeast Marajarbia
Post Marshal
 
Posts: 18891
Founded: Mar 21, 2021
Moralistic Democracy

Postby Southeast Marajarbia » Tue Apr 13, 2021 7:51 pm

Cavirfi wrote:
Southeast Marajarbia wrote:
I have all of those IPs because I travel a lot, and I wanted to hang out with a few friends. Getting back on topic, I doubt that whoever is doing this just has another house. Just IP ban him once, and if it happens again, we will all see.

Again, like Reppy said, IP Bans won't do anything. Whoever is the culprit can simply change their computer or even use VPN.


That is why I recommend IP Banning him once. If he somehow bypasses the IP Ban, the mods can come up with a solution. Why don't the NS Owners just fix the forums to make them less unstable, or have policies that make new users unable to post for 48 hours, just to attempt to slow this down?
Just a regular old II Superpower nation, and large scale trading empire that likes to have fun! You (the reader) can find me all over II nowadays, so I suggest having a chat.

Some NS stats are not canon. Nation represents some (not all) of my RL views

Join I&II (An NS news thread open to everybody and anybody) here: viewtopic.php?f=5&t=525784

User avatar
Cavirfi
Ambassador
 
Posts: 1159
Founded: Feb 28, 2021
Ex-Nation

Postby Cavirfi » Tue Apr 13, 2021 7:53 pm

Southeast Marajarbia wrote:
Cavirfi wrote:Again, like Reppy said, IP Bans won't do anything. Whoever is the culprit can simply change their computer or even use VPN.


That is why I recommend IP Banning him once. If he somehow bypasses the IP Ban, the mods can come up with a solution. Why don't the NS Owners just fix the forums to make them less unstable, or have policies that make new users unable to post for 48 hours, just to attempt to slow this down?

I honestly don't know how to keep this forum stable, so you have a point.
My Storefronts | THE Barn | Set up an Embassy to Cavirfi

CAVIRFI ONE: #BoycottCavirfi movement enters Day 203; CBCC-Cavirfite Wing Strike enters Day 181 | 529 days left until Federal Police inaugurated, Training enters Day 203 | Crabaiaian Electoral Board declares 2023 Federal Election to be held on July 9 for Amine and Imguria and July 16 for the rest of the country | Chano-Cavirfite Sea Storm hits Cavirfi at wind speeds of 54 km/h, causes mild damage; Inauguration of new Great Tribunal, Technocratic Council, and Ministers postponed indefinitely | Average Weather: 20.91℃

User avatar
Katganistan
Senior Game Moderator
 
Posts: 36918
Founded: Antiquity
Scandinavian Liberal Paradise

Postby Katganistan » Tue Apr 13, 2021 8:25 pm

Southeast Marajarbia wrote:
Cavirfi wrote:Again, like Reppy said, IP Bans won't do anything. Whoever is the culprit can simply change their computer or even use VPN.


That is why I recommend IP Banning him once. If he somehow bypasses the IP Ban, the mods can come up with a solution. Why don't the NS Owners just fix the forums to make them less unstable, or have policies that make new users unable to post for 48 hours, just to attempt to slow this down?

Because clearly, we don't have decades of experience with these things.

User avatar
Merni
Ambassador
 
Posts: 1800
Founded: May 03, 2016
Democratic Socialists

Postby Merni » Tue Apr 13, 2021 10:12 pm

Southeast Marajarbia wrote:
Cavirfi wrote:Again, like Reppy said, IP Bans won't do anything. Whoever is the culprit can simply change their computer or even use VPN.


That is why I recommend IP Banning him once. If he somehow bypasses the IP Ban, the mods can come up with a solution. Why don't the NS Owners just fix the forums to make them less unstable, or have policies that make new users unable to post for 48 hours, just to attempt to slow this down?

Since the message "IP bans aren't a silver bullet" doesn't seem to have got through...
With many if not most ISPs (I don't know if this is the case in the US, but it certainly is here), you are assigned a new IP address periodically, as well as every time your router disconnects and connects ("dynamic IP"). For instance I usually turn off my computer and router at night, and the next day when I turn it on I get a new IP (along with all the annoying websites that rely on this telling me I'm signed in from a new location/device!). This means that IP bans either will break whenever you get a new IP address (either automatically or by turning your router off and on), or if they are applied too broadly may block unrelated users of the same ISP that happen to be assigned that IP address at that particular time.
Edit: Plus, you can easily change your IP with a VPN or proxy as well.
Last edited by Merni on Tue Apr 13, 2021 10:16 pm, edited 1 time in total.
2024: the year of democracy. Vote!
The Labyrinth | Donate your free time, help make free ebooks | Admins: Please let us block WACC TGs!
RIP Residency 3.5.16-18.11.21, killed by simplistic calculation
Political Compass: Economic -9.5 (Left) / Social -3.85 (Liberal)
Wrote issue 1523, GA resolutions 532 and 659
meth
When the people are being beaten with a stick, they are not much happier if it is called 'the People’s Stick.' — Mikhail Bakunin (to Karl Marx)
You're supposed to be employing the arts of diplomacy, not the ruddy great thumping sledgehammers of diplomacy. — Ardchoille
The West won the world not by the superiority of its ideas or values or religion [...] but rather by its superiority in applying organised violence. — Samuel P. Huntington (even he said that!)

User avatar
Gandoor
Postmaster-General
 
Posts: 10232
Founded: Sep 23, 2008
Civil Rights Lovefest

Postby Gandoor » Tue Apr 13, 2021 11:18 pm

Southeast Marajarbia wrote:or have policies that make new users unable to post for 48 hours, just to attempt to slow this down?

Because why the Hell should legitimate new users (or new puppet nations of people who already play this game) be unable to post for 48 hours just because of one dipshit with too much free time on their hands?
OOC - Call me Viola
IC Flag|Gandoor Wiki|Q&A|National Currency Database
Reminder that true left-wing politics are incompatible with imperialism, authoritarianism, totalitarianism, and dictatorship in all forms.
Flag is currently a Cinderace.
I'm transfeminine non-binary (but I don't mind or care if you refer to me as a woman).
She/They
27 years old
OOC Info
Twitter: @Sailor_Viola
Steam: Princess Viola
Mastodon: @princessviola@retro.pizza
TGs are welcome


Advertisement

Remove ads

Return to Technical

Who is online

Users browsing this forum: Ankuran, Ferranghia, Gug Letter, K-Money, Liberal gunslingers, Myanerus, Reventus Koth, Sangrinaria, The Endless Eventide, Three Galaxies

Advertisement

Remove ads