jOpenSimWorld

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

Table Regions does not exist 04-08-2018

6 years 8 months ago #2974 by tazzarkin
I keep getting the error message that the Table Regions does not exist. I have tried reading your forum to find a solution, but it does not seem like any clear answer exists.

How can I fix this?

Attachments:

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

6 years 8 months ago #2975 by tazzarkin
Please tell me if I did this right...

1) In StandaloneCommon.ini, I did two things under [Grid Service]
a) Commented out the line under [Grid Service]
;; For in-memory region storage (default)
;; StorageProvider = "OpenSim.Data.Null.dll:NullRegionData"
b) Uncommented the line under [Grid Service]
;;--- For MySql region storage (alternative)
StorageProvider = "OpenSim.Data.MySQL.dll:MySqlRegionData"

2) In Standalone.Common.ini, I added the following at the end of the file (with my info of course)

[PresenceService]
LocalServiceModule = "OpenSim.Services.PresenceService.dll:PresenceService"
StorageProvider = "OpenSim.Data.MySQL.dll"
ConnectionString = "Data Source=localhost;Database=dbname;User ID=dbuser;Password=dbpassword;"

Am I doing this right? Is there anything else that I need to do?

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

6 years 8 months ago #2980 by tazzarkin
foto50 wrote:

Reading this post, I assume that your previous post "Table Regions does not exist 04-08-2018" seems to be solved? If yes, what was the issue? Could you pls post it there so others also can read it? thnx


Yes, to answer your question, the Tables Regions Does Not Existerror was fixed by doing the following steps (which were put together from previous posts in your Forum). This is what I did...

1) In StandaloneCommon.ini, I did two things under [Grid Service]
a) Commented out the line under [Grid Service]
;; For in-memory region storage (default)
;; StorageProvider = "OpenSim.Data.Null.dll:NullRegionData"
b) Uncommented the line under [Grid Service]
;;--- For MySql region storage (alternative)
StorageProvider = "OpenSim.Data.MySQL.dll:MySqlRegionData"

2) In Standalone.Common.ini, I added the following at the end of the file (with my info of course)

[PresenceService]
LocalServiceModule = "OpenSim.Services.PresenceService.dll:PresenceService"
StorageProvider = "OpenSim.Data.MySQL.dll"
ConnectionString = "Data Source=localhost;Database=dbname;User ID=dbuser;Password=dbpassword;"


So basically, I followed the steps listed in previous posts on your Forum.
The following user(s) said Thank You: foto50

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

Time to create page: 0.095 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