Can´t connect to MySQL Server

Administration
1

Hi There,

I´ve been using gibbon for the last few weeks now and have plenty of data inputted into the system. Just yesterday the wamp server stopped working fully. The MySQL service wouldn´t start. I changed the port and it is now working but I still get the following message when trying to load the gibbon homepage. Any help on this matter would be much appreciated.

SQLSTATE[HY000] [1130] Host ‘’ is not allowed to connect to this MySQL server

( ! ) Fatal error: Call to a member function prepare() on null in C:\wamp64\www\schoolsystem\functions.php on line 3910
Call Stack

Time Memory Function Location

1 0.0156 437104 {main}( ) …\index.php:0
2 0.0468 2005000 getSettingByScope( ) …\index.php:57

2

Paul,

Sadly one of Gibbon’s limitations is that it only supports the default port for database connections. I have made a note in the v14 todo (item 11) to address this, but for the time being I think the only option is to get the standard port working.

Can you backup your WAMP install, and then reinstall it, and put Gibbon back into place? I have a lot more experience with MAMP than WAMP.

Thanks,

Ross

3

Hi There,

I could reinstall WAMP no problem. I would be worried about the data on Gibbon though as it would all be in the MySQL database. Is there a way I can copy everything effectively and then reinstall it?

4

Paul,

If you use phpMyAdmin, which I think comes with WAMP (from memory), you could export the database before reinstalling, and then import again after.

Thanks,

Ross

5

Many thanks. I did just that. Bit complicated with the gibbon install again but got it all working again.

6

Paul, excellent to hear. Are you using WAMP for testing, or is this going to be a production server? For production I would personally (and professionally ; ) recommend Ubuntu Linux Server edition: the setup is harder, but you get better performance without a desktop, and what I believe to be a more secure, stable, extensible setup. Just some thoughts to consider.