Want to create a server but have a few questions first

Hi everyone!

I love this game. As it turns out I may have a spare Dell Power Edge server that I could donate to the community as a permanent dedicated server.

She's an old girl with a 2.4 GHz Xeon X3430 Processor with 8GB memory with Server 2012 Std.

Q1. I've seen that the game was originally using SQLite but it's now recommended to use MySQL, first of all I take it there is no problem with me using MS SQL Server 2017 Express edition instead?

(I've seen the config file now, so I'll KIS)

Q2. Is it possible to block certain objects in the game? I want to make this a medieval / castle building server and I don't want modern objects allowed.

CHEERS!

Ok so the server is all up now.

Any idea when the beta server files are available so I can connect to it?

Thanks! Will take some testing I guess

OK I've done this so far. . . (been reading Permission system)

chatcolor: 0xFFFFFF
chatnamecolor: 0xFFFFFF


commands:
    deny:
    - *
general:
    fly: false
    debuglight: false
customimages:
    enabled: true
    maxupload: 10
    dimension: 512
blueprints:
    use: false
    create: false
creative:
    deny:
    - *

It's hard to know what the options are as I'm not sure of any resources to check apart from this forum and all the available options don't seem to be listed. . . (a comprehensive set of examples would smashing:)

I guess currently I would like to know;

1. if it's possible to turn off the console for users? (I guess this is my most important question)
2. if it's possible to set it so that you can't destroy objects/blocks that someone else placed? I see there is destroyblocks, destroyobjects under world permissions but I assume this means for everyone including a users own blocks / objects?

Also, in my server.properties file I've set server_world_disabled_dungeons=underground,underwater,surface but there still appears to be surface dungeons albeit without chests in them?
OK I've deleted database and created a new seed. Seems to have solved that one.

Great thanks migdyn!

Ahh I see that console commands are disabled by default I guess people need access for options like "hud"

You know when you create a new world with the server there is an option for ore "server_world_oreamount=3" (default)

Do you know if a smaller integer means more ore or less? I've set mine to "server_world_oreamount=2" as I want the ores to be more hard to come by. . . but I've just found some silver right up on the surface so I'm not sure if I should have set it to server_world_oreamount=4?

Hmm this is my test permissions file (default.permissions)

chatcolor: 0xFFFFFF
chatnamecolor: 0xFFFFFF


commands:
    deny:
    - *
general:
    fly: false
    debuglight: false
customimages:
    enabled: true
    maxupload: 10
    dimension: 512
blueprints:
    use: false
    create: false
creative:
    deny:
    - *
items:
crafting:
deny:
    - workbench2
    - counter1

Lines 20-24 create a NullPointerException?

OK I've worked it out! Thanks to Red post on Steam


Here's the file if anyone else is looking for the answer too

chatcolor: 0xFFFFFF
chatnamecolor: 0xFFFFFF


commands:
    deny:
    - *
general:
    fly: false
    debuglight: false
    pvp: false
    pve: true
customimages:
    enabled: true
    maxupload: 10
    dimension: 512
blueprints:
    use: false
    create: false
creative:
    deny:
    - *
items:
    crafting:
        deny:
        - tnt
    pickup:
        general:
            deny:
            - tnt
        chest:
            deny:
            - tnt
        body:
            deny:
            - tnt
    drop:
        general:
            deny:
            - tnt
        chest:
            deny:
            - tnt
        body:
            deny:
            - tnt

Hmm still struggling with this.

I'm getting warning messages such as: WARNING: Permission for item id counter1 not found

As a test I just replaced the tnt text under crafting deny to counter1 and I got the above warning message, I've also tried it for things like workbench2 and radiator.

Thanks for the reply but that doesn't really help.

The server is online and working. The config file segment is like

items:
    crafting:
        deny:
        - tnt

As soon as I modify *just* the tnt text bit to say "radiator" such as:

items:
    crafting:
        deny:
        - radiator

I'm getting "WARNING: Permission for item id radiator not found"

And no not in chat, the message is on the server side. Java error.

Ahh I've sorted it!

YAML syntax requires 2 spaces of the keyboard for every indent!

Hope that gets changed to XML at some point.

Though I had sorted it... but it's only working for items and not objects!

I've tried

objects:
    crafting:
        deny:
        - workbench2

You need to use this application: http://sqlitebrowser.org/

Let me see if i can grab a dump for you.

It looks like this once run - simply drag the file definitions.db into it

p.s. if you use a copy file like I have you can't do any damage!

Lol you're welcome.

There's a clue to the file location in my screen dump