jOpenSimWorld

Grid Status: Online
Total Regions: 23
Visitors (30 Days): 7
Total Residents: 485
Online Now: 0
Hypergriders online: 0

Installing Joomla

11 years 6 months ago #1848 by tricon
The 'server_check.zip' file attached above contains a .php file that will check your server/database settings. Just modify the values at the top of the file (in notepad etc.) to your own settings, and then load the file from your web directory on the server. It should return OK for everything if it is setup correctly. Hopefully that might help to narrow down the problem.

Please Log in or Create an account to join the conversation.

11 years 6 months ago #1850 by Dayna Bedrosian
Strange. I modified the details and I get an error message. Also no I do not have SQL installed on the machine running the website.

Server error
The website encountered an error while retrieving www.ufgqgrid.org/server_check.php . It may be down for maintenance or configured incorrectly.
Here are some suggestions:
Reload this webpage later.
HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while the server was attempting to fulfill the request.

Please Log in or Create an account to join the conversation.

11 years 6 months ago #1851 by tricon
What happens when you just run the original file? It should return something like:

Webserver: OK
PHP: 5.3.10 OK
MySQL extension: OK
MySQL connection: Error
Access denied for user 'Database_Name'@'localhost' (using password: YES)

Please Log in or Create an account to join the conversation.

11 years 6 months ago #1852 by Dayna Bedrosian
When I open up the file locally in the browser it gives me a text read out of the file. Should I have left the " "? I took those out when I was entering in the data.

Please Log in or Create an account to join the conversation.

11 years 6 months ago #1853 by Dayna Bedrosian
Okay it was the comments that were needed. Here is what I am getting. From the looks if it. It is not using the outside IP address.

Webserver: OK
PHP: 5.3.24 OK
MySQL extension: OK
MySQL connection: Error
Access denied for user 'ufgquser'@'192.168.1.1' (using password: YES)

Please Log in or Create an account to join the conversation.

11 years 6 months ago #1854 by foto50
Hi Dayna

Ok, this tells me now a few things:

First of all, the good point: MySQL seems to be running and accepting connections :)

The "Access denied" tells us, that either the user 'ufgquser' does not exist with the host '192.168.1.1' or it does not have the priviledges to access the desired database. I would guess for the first case: mind that 'ufgquser'@'localhost' is not the same user as 'ufgquser'@'192.168.1.1' for the database server. Usually, you can duplicate the localhost user and replace the hostname with 192.168.1.1

But the IP also gives something to think about: it is NOT an outside IP ... all 192.168.x.x IP's are for a local network only (same as e.g. 10.x.x.x). This works only if the database server and the webserver are located in the same local network. Is this the case?

Greetz
FoTo50

Please Log in or Create an account to join the conversation.

11 years 6 months ago #1855 by Dayna Bedrosian
Yes it is on a different server than the one that is handling the website. I have on the server_check.php I put in the outside static IP address that I have and it still referred to a local address where there is no SQL.

WAMP is physically running on a separate machine and I checked the server to see if Port 3306 was open in the firewall on that server and it was.

Thank you again for your patience.

Please Log in or Create an account to join the conversation.

11 years 6 months ago #1856 by Dayna Bedrosian
I also changed the IP address to the local network IP of the machine running MySQL/WAMP and it is still trying to use 192.168.1.1.

Please Log in or Create an account to join the conversation.

11 years 6 months ago #1857 by Dayna Bedrosian
Issue fixed. What the problem was that the users were all set to local host. So I changed it to allow outside connections and Joomla started right up. Next on the to do list. Install JopenSIM. Thank you for all the help. I am sure this will not be the last request for help lol.

Please Log in or Create an account to join the conversation.

11 years 6 months ago #1858 by tricon
Glad you got everything working! Once you have Joomla! installed, JOpenSim should install without issue from the Extension Manager.

Please Log in or Create an account to join the conversation.

Time to create page: 0.126 seconds

Search

Donate jOpenSim

Please consider supporting our efforts.

Amount

Our Regions

Region: Loc X: Loc Y:
Agora 1000 998
BareBad… 997 997
Bohemas 996 998
BoraBor… 1002 999
Crystal… 1001 1000
DeepTho… 1005 998
FoToSan… 999 995
jCity 1001 997
jOpenWe… 1000 999
JuniorT… 1002 1001
Kanadah… 1002 1000
LindaKe… 1000 997
LittleC… 996 997
MonteSc… 1001 1001
Naos 999 999
Pangaea 1005 1003
RiverSi… 999 1000
Sakani 999 998
Snambin 1001 998
Tartola 997 998
ViewerH… 1002 998
WaterWo… 1001 999
WilderK… 1000 1000

jOpenSimWorld

Grid Status: Online
Total Regions: 23
Visitors (30 Days): 7
Total Residents: 485
Online Now: 0
Hypergriders online: 0