Posts by yahwho

    Haha fixed it.


    Anyone else using the latest MySQL server build you will need to set the password as native via the shell.


    Code
    \sql ALTER USER 'rwadmin'@'localhost' IDENTIFIED WITH mysql_native_password BY 'thisissillypassword';
    \sql FLUSH PRIVELEGES;

    Has anyone setup a MySQL server recently? I've not done this in a few years and I'm stuck! :wat:


    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. :dizzy:




    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.



    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. . . ;)

    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! :P


    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


    Java
    public int getTerrainID()
    //Gets the terrain id the player is going to destroy.
    //Returns:
    //the old terrain id.


    You could then work out if the terrain was an ore and then add extra ore to the players inventory (if they have space!).


    Hi red51


    but 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 :crazy: I ran another conversion on the table and got it back to InnoDB. So far so good!


    :thumbup:

    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

    Minotorious


    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.


    red51


    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.

    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.