cancel
Showing results for 
Search instead for 
Did you mean: 

04 Gateway time-out

csiatst
Dabbler
Posts: 13
Thanks: 4
Registered: ‎30-12-2016

04 Gateway time-out

I have a genealogy site at http://ccgi.stephenthompson.plus.com/genealogy/index.php
A few weeks ago I was able to logon to it and get info from the site. Now I can only log on. Anything else I do results in a 504 gateway time-out error. I've not made any changes to the site in probably many months. I logged on to the control panel the other day and received the following

"Cannot connect: invalid settings. mysqli::real_connect(): (HY000/1203): User ccgistephe670981 already has more than 'max_user_connections' active connections phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection".

Contacted PlusNet who suggested I should post here. I can now access my database through the control panel and MySQL and can see all my tables again, but the site still gives me a 04 error.

Stephen

5 REPLIES 5
Penny
Superuser
Superuser
Posts: 1,445
Thanks: 880
Fixes: 8
Registered: ‎05-04-2007

Re: 04 Gateway time-out


@csiatst wrote:

"Cannot connect: invalid settings. mysqli::real_connect(): (HY000/1203): User ccgistephe670981 already has more than 'max_user_connections' active connections phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection".


 

@csiatst   I clicked on the link which initially gave a genealogy page (but clicking on further links said 'no content' or some such).

Just tried the link again and it just says 'loading' (indefinitely) then 504 Gateway Timeout.


If it's a mysql issue I'm guessing @bobpullen  might be the only person who could help sort this - not his area of work these days afaik but hopefully he'll see your post at some stage soon.
.

Penny Rollo * * * joined Force9 on 17/02/98 * * * with PlusNet from 2000 onwards * * * personal website at pennymidasrollo.plus.com
Project HappyChild website (free educational resources for kids and schools, plus directory of charities helping children) 1998 onwards
Superusers are not PlusNet staff but do have a direct line of communication into the business to raise issues, concerns and feedback from the Community.
csiatst
Dabbler
Posts: 13
Thanks: 4
Registered: ‎30-12-2016

Re: 04 Gateway time-out

I think the problem is that PlusNet have moved the server. I found a thread in here from when they moved from Rumpus.
https://community.plus.net/t5/Everything-else/MySQL-cannot-connect-to-database/td-p/1400124/page/2

I can recall now where I find that database user name and password so I can update it again.

csiatst
Dabbler
Posts: 13
Thanks: 4
Registered: ‎30-12-2016

Re: 04 Gateway time-out

Can my CCGI webspace be restored to how it was before it was moved to a new server?
Where does db.inc live?

Do I need to set up a new database again?

@bobpullen are you able to help me with this issue?

Penny
Superuser
Superuser
Posts: 1,445
Thanks: 880
Fixes: 8
Registered: ‎05-04-2007

Re: 04 Gateway time-out


@csiatst wrote:

I can now access my database through the control panel and MySQL and can see all my tables again, but the site still gives me a 04 error.


 


@csiatst wrote:

I found a thread in here from when they moved from Rumpus.
https://community.plus.net/t5/Everything-else/MySQL-cannot-connect-to-database/td-p/1400124/page/2

 

Illuminating thread - in lots of ways.

 

Called up your site yesterday - and again just now - as per screenshot below, but the links (still) don't work.

20240329-1546pm-genealogy-site.jpg

 

... so, a couple of questions.

 

(1) have you re-enabled error-reporting - as per linked post on the referenced thread

https://community.plus.net/t5/Everything-else/MySQL-cannot-connect-to-database/m-p/1503252/highlight... 

 

(2) no idea what TNG might be (?) but wondering if changes to php / mysql versions in the interim, might have stopped your code from calling up the required content from the database.

As far as I recall, the php version on hostopia was 7.3 (ish) last summer (the linked post refers to php 5.6).  I don't know how php/mysql versions interface (not a techie) but I do know that it was necessary to replace mysql calls (in the code) with mysqli (similar types of call-ups but not structured the same), so that they would work on php 7.3, when I had to move several websites to Mythic Beasts (mainly for https).

Further to that, when MB moved from php 7.3 to 7.4, I discovered that a lot of scripts stopped working - randomly - and eventually tracked this down to the need to have <?php at the beginning of a call-up clause, rather than just <? which had crept into the coding here and there, over a period of some years

(as in, eg, <?php echo $data["bloggs"] ?> rather than <? echo $data["bloggs"] ?> ).

 

No idea whether either of the above would help solve your issues, but thought it might be worth asking, just in case.

.

Penny Rollo * * * joined Force9 on 17/02/98 * * * with PlusNet from 2000 onwards * * * personal website at pennymidasrollo.plus.com
Project HappyChild website (free educational resources for kids and schools, plus directory of charities helping children) 1998 onwards
Superusers are not PlusNet staff but do have a direct line of communication into the business to raise issues, concerns and feedback from the Community.
bobpullen
Community Gaffer
Community Gaffer
Posts: 16,930
Thanks: 5,017
Fixes: 317
Registered: ‎04-04-2007

Re: 04 Gateway time-out


@csiatst wrote:

Can my CCGI webspace be restored to how it was before it was moved to a new server?
Where does db.inc live?

Do I need to set up a new database again?

@bobpullen are you able to help me with this issue?


The last CGI/SQL migration was > 5 years ago, so no chance of that. Any config files you have will be on the FTP server.

If you're able to acces your SQL database then how large is it, I wonder if it's size could be the cause of the problem?

If you're adament things were working a few weeks back then I can try raising a support ticket to our hosting partner if you like?

Bob Pullen
Plusnet Product Team
If I've been helpful then please give thanks ⤵