topic Re: 04 Gateway time-out in Everything else

04 Gateway time-out

csiatst — Mon, 25 Mar 2024 18:09:05 GMT

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

Re: 04 Gateway time-out

Penny — Mon, 25 Mar 2024 22:35:57 GMT

@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.
.

Re: 04 Gateway time-out

csiatst — Thu, 28 Mar 2024 20:26:44 GMT

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.

Re: 04 Gateway time-out

csiatst — Fri, 29 Mar 2024 07:57:46 GMT

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?

Re: 04 Gateway time-out

Penny — Fri, 29 Mar 2024 16:29:29 GMT

@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.

... 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/true#M18494

(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.

Re: 04 Gateway time-out

bobpullen — Thu, 04 Apr 2024 19:32:42 GMT

@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?