Time to create a database user
14. Go back to SecureCRT and type
Code:
sudo -u postgres createuser --superuser <username>
to create a new PostGreSQL super user. It's not required as you can use the default user "postgres". It's up to you. Just make sure to set a password. Do so by typing
Code:
alter user <username> password '<password>';
. You must remember to use the ' in the password to let it know it's a string.
15. Now type
then
when the 'bash' comes.
16. Create the necessary databases and give them a name of your choice. To create a database type
Code:
create database <database name> encoding 'SQL_ASCII' template template0;
. You must end a PostGreSQL command with a ';' otherwise nothing will happen. To import a SQL first connect to the database by typing then .
Caution: You must have the encoding in order to make the database read chinese letters otherwise the server won't let you in. The encoding is case-sensitive as well so make sure you type it as shown. Template is making sure that you can use a custom template of the database creation. Template0 means custom. No further explanation from here.
17. Once done go to Navicat and open up the game- and login server database.
In the game server database find the 'serverstatus' table and edit the IP's to your server's. Do so as well with login server database's 'worlds' table.
18. Open up the start file and replace the paths accordingly so they match yours.
19. Start your server by typing
and you're done!