Posts by yahwho
-
-
Has anyone setup a MySQL server recently? I've not done this in a few years and I'm stuck!
I thought I would rebuilt my local test server on my workstation - clean OS install.
I've installed the latest MySQL Community (v8) including the shell. Last one I used was version 6!
Opened the MySQL Shell up and created a database called `risingworld` also creating a user called `rwadmin` and assigned the user all privileges to the new database. Reopened the shell and connected with new credentials to database to check working. Sure was!
I have then installed a local copy of the RW standalone server via the SteamCMD tool. I won't bore you with screenshots...
I've then gone and changed the server.properties file to reflect the MySQL server.
I run the win_startscript.bat but the server fails to start.
Codejava.sql.SQLInvalidAuthorizationSpecException: Access denied for user 'rwadmin'@'localhost' (using password: NO)at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1113)Current charset is windows-1252. If password has been set using other charset, consider using option 'passwordCharacterEncoding'at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authentication(AbstractConnectProtocol.java:854)at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:777)at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:451)at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1109)java.sql.SQLInvalidAuthorizationSpecException: Access denied for user rwadmin@localhost (using password: NO)at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1113)Current charset is windows-1252. If password has been set using other charset, consider using option passwordCharacterEncodingat org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authentication(AbstractConnectProtocol.java:854)at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:777)at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:451)at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1109)Current charset is windows-1252. If password has been set using other charset, consider using option passwordCharacterEncodingat org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authentication(AbstractConnectProtocol.java:854)at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:777)at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:451)Clearly the Access denied for user 'rwadmin'@'localhost' (using password: NO) is to blame - but I don't get why the password I've supplied in the server.properties file is not being used
I'm a little lost.
-
Server has been updated to version 0.1.6
The server now pushes player stats onto the player.medievalrealms.co.uk website.
This is currently an early alpha release so don't expect fancy CSS
-
-
james1bow what key do you want to use? I could quickly make an edit and compile a second copy for you with an alternate key.
-
Only Red can answer this, in order for a 32 bit program to access more that 4GB ram the program itself needs to manage the memory. But this is bad practice imho.
Having said this, there is a very simple way you can find out. . .
-
Could I make coal classify as an ore?
I don't know of any way. Someone else smarter might.
-
I like this new version.
Glad it's being put to use!
-
Hi I've just reinstalled this (been away from the game) and for some reason the skin now isn't working for me all I'm getting is a plain white skin "I'm guessing iv got the jpg in the wrong place" where exactly dose this go again?
Inside the plugin folder, there should be a nested folder called "img" and inside that there should be a single jpg file called background.jpg
plugins/MRPrecision/img/background.jpg
-
1. As far as I am aware coal is not an ore so the Ore Detector not being able to find coal makes sense. Coal is neither a mineral or rock comprised of minerals. Coal is actually composed of macerals which is the organic equivalent of minerals.
2. Okay you have done it!
3. The main files you want to edit are the database files and some JAR files. There are a lot of topics on this very subject on the forums. The Plugin Discussion forum would be my go to place.
4. Limitations are only to your imagination - and of course the API - https://javadoc.rising-world.net/
5. Yes, you could probably do this via the API. I would suggest you look at the PlayerDestroyTerrainEvent there is a method in there called getTerrainID
You could then work out if the terrain was an ore and then add extra ore to the players inventory (if they have space!).
-
The Daleks has landed on my roof
They just can't work out how to get down the stairs!
-
There will be some exciting improvements compared to the old version which makes building a lot easier (especially if you want to create rounded structures).
Castle towers!!!
-
still some people out there who don't know there is actually a journal in the game
You can lead a horse to water but you can't make him drink.
-
Server updated to version 0.1.5 - bug fixes, surely there can't be any more?
-
-
red51 really great progress on the current update!
-
Hi red51but please create a backup first.
Hehe that's my daily blurb!
Yes I thought that was the issue, but also thought I would wait for your confirmation before "hitting the button" just in case you had any further ideas.
I ran a repair table command (as it was the table and not the database as a whole - at least at this stage!).
Indeed the table was corrupted - wrong record length!
Fix table command worked, however it seemed to convert the chunkadditions table to MyISAM
I ran another conversion on the table and got it back to InnoDB. So far so good!
-
what we did when this appeared was use the terrain tool on the edge of the bad chunk, that usually brought the chunk back to life
That's the first thing I tried! Doesn't work in this case. It looks like the chunkadditions table in SQL is corrupt - or at least a row in the table is - as everything else is working.
I've messaged you the log. With a clearer head this morning (that scrumpy cider aye?) it looks to me like I might need to run a table repair on the chunkadditons table (The error is certainly been thrown from SQL). But I'll wait back to see if you agree.
-
Hi red51
My server log is reporting chunkadditions is marked as crashed and should be repaired.
Getting some strange behaviour some chunks appear black and some chunks are missing all together. Pressing F10 to fix chunk boarders does not work.
Server restart does not fix it.
Moving into the crashed chunk/chunks crashes server.
-
AshWardle have you tried looking in the database of the game? Or other game config files? It would be bad practice for a programmer to hard code these values in.