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: 1135
Founded: Jan 16, 2020
Civil Rights Lovefest

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
Nacrad, Briefly
International News: Air campaign against Burma continues | Conflict between Hamas and Israel escalates, experts warn of "total war"
Domestic News: 14/05/2021 (FRI) | Tsangshing Power Plant suffers malfunction, causes blackouts for 3 hours in Pearl River Delta | Nacradian computer chip makers "unscathed" by blackouts |Domestic UVT vaccines' effectiveness against Wuhan Pneumonia "above 90%", says study | Asus releases newest flagship smartphone ZenPhone 8 | Riverfort 34/28°C | Amoy 33/25°C | Taipei 36/28°C


User avatar
Cavirfi
Envoy
 
Posts: 306
Founded: Feb 28, 2021
Inoffensive Centrist Democracy

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

User avatar
Miraaki
Ambassador
 
Posts: 1008
Founded: May 01, 2016
Left-Leaning College State

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
Envoy
 
Posts: 334
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.
Warden of The Order of the Grey Wardens since February 10th, 2021.
Baptism of Fire 75 Champions... somehow?
...I'll always be your friend!

User avatar
Miraaki
Ambassador
 
Posts: 1008
Founded: May 01, 2016
Left-Leaning College State

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
Envoy
 
Posts: 306
Founded: Feb 28, 2021
Inoffensive Centrist Democracy

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?

User avatar
Zarnicovia nova
Negotiator
 
Posts: 6658
Founded: Jun 03, 2020
Scandinavian Liberal Paradise

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
to make an embassy with zarnicovia nova go to viewtopic.php?f=6&t=490604
Q&A here! viewtopic.php?f=23&t=491532
airport viewtopic.php?f=6&t=491681
country founded by a religion based off of my and the views of Utah/the Mormons. far-left democracy very powerful.

THIS NATION IS BASED ON STATS!
OOC: flag is ZN history summarized

User avatar
Eshialand
Envoy
 
Posts: 334
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.
Warden of The Order of the Grey Wardens since February 10th, 2021.
Baptism of Fire 75 Champions... somehow?
...I'll always be your friend!

User avatar
Cavirfi
Envoy
 
Posts: 306
Founded: Feb 28, 2021
Inoffensive Centrist Democracy

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

User avatar
New Jacobland
Chargé d'Affaires
 
Posts: 372
Founded: Oct 01, 2019
Anarchy

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
Envoy
 
Posts: 345
Founded: Jul 27, 2014
Inoffensive Centrist Democracy

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: 392
Founded: Apr 21, 2020
Capitalist Paradise

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.
NS' resident salty gamer. My WA nation is Parx
Saying 'Goodbye' to 2020 be like..| Hello creepy NSGP stalker!

User avatar
Southeast Marajarbia
Ambassador
 
Posts: 1411
Founded: Mar 21, 2021
Inoffensive Centrist 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.
Proud Co-Founder of the IDSF, SETZA Host Nation, Founder of the CFTC.

User avatar
Eshialand
Envoy
 
Posts: 334
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?
Warden of The Order of the Grey Wardens since February 10th, 2021.
Baptism of Fire 75 Champions... somehow?
...I'll always be your friend!

User avatar
Southeast Marajarbia
Ambassador
 
Posts: 1411
Founded: Mar 21, 2021
Inoffensive Centrist 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.
Proud Co-Founder of the IDSF, SETZA Host Nation, Founder of the CFTC.

User avatar
Reploid Productions
Forum Admin
 
Posts: 27891
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 18 on March 23, 2021!
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
Ambassador
 
Posts: 1411
Founded: Mar 21, 2021
Inoffensive Centrist 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.
Proud Co-Founder of the IDSF, SETZA Host Nation, Founder of the CFTC.

User avatar
Cavirfi
Envoy
 
Posts: 306
Founded: Feb 28, 2021
Inoffensive Centrist Democracy

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.

User avatar
Southeast Marajarbia
Ambassador
 
Posts: 1411
Founded: Mar 21, 2021
Inoffensive Centrist 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?
Proud Co-Founder of the IDSF, SETZA Host Nation, Founder of the CFTC.

User avatar
Cavirfi
Envoy
 
Posts: 306
Founded: Feb 28, 2021
Inoffensive Centrist Democracy

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.

User avatar
Katganistan
Senior Game Moderator
 
Posts: 34527
Founded: Antiquity
Inoffensive Centrist Democracy

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: 1472
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.
COVID19 still exists! | Donate your free time
The Labyrinth | TGW Warden | GA Committee List

OOC by default | Admins: Please allow blocking WA TGs!
E -8.0 S -3.18
Wrote 532 GA
meth
I've noticed that everybody that is for abortion has already been born. — Ronald Reagan
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
Powerbroker
 
Posts: 9644
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 authoritarianism, totalitarianism, and dictatorship in all forms.
Flag is currently Papple from Hugtto Precure.
I'm female.
OOC Info
Twitter: @Sailor_Viola
Steam: Princess Viola
TGs are welcome


Advertisement

Remove ads

Return to Technical

Who is online

Users browsing this forum: Majestic-12 [Bot]

Advertisement

Remove ads