Setup instructions for Tethealla PSOBB server:
Login Server (SQL version) @ https://files.pioneer2.net/spsos_login_v.047.zip
Login Server (.DAT version) @ https://files.pioneer2.net/spsos_login_v.048_nosql.zip
Ship Server @ https://files.pioneer2.net/spsos_ship_v.143.zip
Source Code for everything @ https://files.pioneer2.net/tethealla_source_032111.zip
See the individual notes inside of each archive for details.
For those who need instructions on how to set up the login server, you basically do this:
1. If using the .DAT version, skip to step 6.
2. Install MySQL on a machine. Whether it be Linux/Unix/Windows or whatever, it needs to have MySQL running on it from an accessible port. (For security reasons, you really should have the login server and MySQL server running either on the same machine or AT LEAST on the same network... don't access a MySQL server from the internet...)
3. Add a new MySQL user (don't use root as that'd be noob)
4. Create a new database and import the tables from sql\pso_server.sql into the database.
5. Give the new MySQL user permission to read, write and delete from these tables. Also give the MySQL user access to the MySQL server through whatever host it's going to use.
6. Configure the login_server parameters by editing the tethealla.ini at ini\tethealla.ini Once done with that, copy the tethealla.ini from the ini folders into the same folder as login_server.exe and account_add.exe
7. Run account_add.exe and add the first account. (This account will, by default, be granted global GM as it's the first account on the server...)
8. Run make_key.exe to generate your first ship's key binary file. (This will also import the key into the SQL table with the appropriate index ID...)
9. The ship_key.bin file generated by make_key.exe should be copied into the folder of your first ship's ship_server.exe
10. Edit the welcome.txt in the ini folder then copy it into the same folder as patch_server.exe
11. Run patch_server.exe
12. Run login_server.exe
13. Run ship_server.exe, all should be well. (Provided you already did all the appropriate configuration of ship.ini to connect to the new login_server)
14. Download the unpacked PSOBB executables and hex edit in your IP address.
https://files.pioneer2.net/TethExes010710_PW.zip for the v1.25.10 executables for both Vista and XP. (Password for ZIP is "pioneer2". Had to put a password due to Google flagging it as malware even though it's NOT.)
https://files.pioneer2.net/TethExes12513.zip for the v1.25.13 executable compatible with both Vista/7/8 and XP.
https://files.pioneer2.net/Tethealla_PSO ... Client.rar for complete client including the v1.25.13 executable compatible with both Vista/7/8 and XP
15. Distribute modified EXE to all of your connecting clients.
16. Make sure you've opened up port 11000, 11001, 12000 and 12001 for your login server on your firewall and if you wish players to connect externally configure NAT on your router to point these ports to the IP address hosting the server.**
17. Make sure you've opened ports 5278, 5279, and 5279+the number of blocks you're hosting in succession on your firewall and if you wish players to connect externally configure NAT on your router to point these ports to the IP address hosting the server.**
18. Have clients connect!
.. Hopefully I didn't miss a step.
The .DAT version of the login server has a hardcoded limit of 2,000 accounts. I didn't code any checking but if you attempt to exceed that number of created accounts, the program will crash. (Because I forgot to add in a check for that..
)
I'll probably remove the limit later.
If you're serious about setting up any sort of heavy traffic server, you should definitely be using the SQL version (IMHO).
**Your router will need to support loopback NAT for this to work. Check the manufacturer of your router to confirm this.
... Some updates coming soon!!
Login Server (SQL version) @ https://files.pioneer2.net/spsos_login_v.047.zip
Login Server (.DAT version) @ https://files.pioneer2.net/spsos_login_v.048_nosql.zip
Ship Server @ https://files.pioneer2.net/spsos_ship_v.143.zip
Source Code for everything @ https://files.pioneer2.net/tethealla_source_032111.zip
See the individual notes inside of each archive for details.
For those who need instructions on how to set up the login server, you basically do this:
1. If using the .DAT version, skip to step 6.
2. Install MySQL on a machine. Whether it be Linux/Unix/Windows or whatever, it needs to have MySQL running on it from an accessible port. (For security reasons, you really should have the login server and MySQL server running either on the same machine or AT LEAST on the same network... don't access a MySQL server from the internet...)
3. Add a new MySQL user (don't use root as that'd be noob)
4. Create a new database and import the tables from sql\pso_server.sql into the database.
5. Give the new MySQL user permission to read, write and delete from these tables. Also give the MySQL user access to the MySQL server through whatever host it's going to use.
6. Configure the login_server parameters by editing the tethealla.ini at ini\tethealla.ini Once done with that, copy the tethealla.ini from the ini folders into the same folder as login_server.exe and account_add.exe
7. Run account_add.exe and add the first account. (This account will, by default, be granted global GM as it's the first account on the server...)
8. Run make_key.exe to generate your first ship's key binary file. (This will also import the key into the SQL table with the appropriate index ID...)
9. The ship_key.bin file generated by make_key.exe should be copied into the folder of your first ship's ship_server.exe
10. Edit the welcome.txt in the ini folder then copy it into the same folder as patch_server.exe
11. Run patch_server.exe
12. Run login_server.exe
13. Run ship_server.exe, all should be well. (Provided you already did all the appropriate configuration of ship.ini to connect to the new login_server)
14. Download the unpacked PSOBB executables and hex edit in your IP address.
https://files.pioneer2.net/TethExes010710_PW.zip for the v1.25.10 executables for both Vista and XP. (Password for ZIP is "pioneer2". Had to put a password due to Google flagging it as malware even though it's NOT.)
https://files.pioneer2.net/TethExes12513.zip for the v1.25.13 executable compatible with both Vista/7/8 and XP.
https://files.pioneer2.net/Tethealla_PSO ... Client.rar for complete client including the v1.25.13 executable compatible with both Vista/7/8 and XP
15. Distribute modified EXE to all of your connecting clients.
16. Make sure you've opened up port 11000, 11001, 12000 and 12001 for your login server on your firewall and if you wish players to connect externally configure NAT on your router to point these ports to the IP address hosting the server.**
17. Make sure you've opened ports 5278, 5279, and 5279+the number of blocks you're hosting in succession on your firewall and if you wish players to connect externally configure NAT on your router to point these ports to the IP address hosting the server.**
18. Have clients connect!
.. Hopefully I didn't miss a step.
The .DAT version of the login server has a hardcoded limit of 2,000 accounts. I didn't code any checking but if you attempt to exceed that number of created accounts, the program will crash. (Because I forgot to add in a check for that..
I'll probably remove the limit later.
If you're serious about setting up any sort of heavy traffic server, you should definitely be using the SQL version (IMHO).
**Your router will need to support loopback NAT for this to work. Check the manufacturer of your router to confirm this.
... Some updates coming soon!!
Last edited: