Teathella

22/11/2011 15:35
Author Message
Sodaboy
PostPosted: Tue August 26th, 2008 12:24 pm    Post subject: Newest binaries (both SQL and non-SQL versions...) Reply with quote

Site Admin

Joined: Aug 10, 2008
Posts: 1142
Location: Vallejo, California
Here's the latest binaries for the server (This post updated on a semi-regular basis...)

Login Server (SQL version) @ http://www.pioneer2.net/spsos_login_v.047.zip (Missing pso_server.sql file is now present... sorry about that.)
Login Server (.DAT version) @ http://www.pioneer2.net/spsos_login_v.048_nosql.zip
Ship Server @ http://www.pioneer2.net/spsos_ship_v.143.zip

Old version archive @ http://www.pioneer2.net/archive/

Both of these are a lot newer than the compiled code you get from the last source code release.

See the individual notes inside of each archive for details.

I'm not going to cover setting up a ship, since most people should know that already. 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.

http://www.pioneer2.net/TethExes010710.zip for the executables for both Vista 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 router or firewall.

17. Make sure you've opened ports 5278, 5279, and 5279+the number of blocks you're hosting in succesion on your router or firewall.

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.. :D)

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


Last edited by Sodaboy on Mon March 21st, 2011 8:13 pm; edited 119 times in total
Back to top
View user's profile Send private message Send e-mail    
Jon Wayne
PostPosted: Tue August 26th, 2008 12:29 pm    Post subject: Reply with quote



Joined: Aug 11, 2008
Posts: 95
Location: Georgia, USA
Quote:
am thinking about just removing the SVN, since it doesn't appear anyone uses it for anything else but downloading the source. =P (Well, with the exception of Jon Wayne that one time...)


Ha. I'll be using it again, once I get moved. Just been busy. I'll be contributing a lot more once things calm down. ha.
Back to top
View user's profile Send private message Send e-mail AIM Address MSN Messenger    
Sodaboy
PostPosted: Tue August 26th, 2008 12:33 pm    Post subject: Reply with quote

Site Admin

Joined: Aug 10, 2008
Posts: 1142
Location: Vallejo, California
Jon Wayne wrote:
Ha. I'll be using it again, once I get moved. Just been busy. I'll be contributing a lot more once things calm down. ha.


I'm not worked up about it, really.

Just hasn't been a lot of dev work from others, though I appreciate your work on the local GM thing.

It'll most likely just go to a weekly release of the source or something, though.
Back to top
View user's profile Send private message Send e-mail    
FireFox276
PostPosted: Tue August 26th, 2008 12:34 pm    Post subject: Reply with quote



Joined: Aug 11, 2008
Posts: 337
Followed it step by step and all is well!

Is this ship_key (or w/e it was) the ship lockout thing (ie if no key then the ship can't connect)?
Back to top
View user's profile Send private message    
Jon Wayne
PostPosted: Tue August 26th, 2008 12:34 pm    Post subject: Reply with quote



Joined: Aug 11, 2008
Posts: 95
Location: Georgia, USA
Sodaboy wrote:
Jon Wayne wrote:
Ha. I'll be using it again, once I get moved. Just been busy. I'll be contributing a lot more once things calm down. ha.


I'm not worked up about it, really.

Just hasn't been a lot of dev work from others, though I appreciate your work on the local GM thing.

It'll most likely just go to a weekly release of the source or something, though.


It's all good, I'll start contributing more here soon.
Back to top
View user's profile Send private message Send e-mail AIM Address MSN Messenger    
Sodaboy
PostPosted: Tue August 26th, 2008 12:37 pm    Post subject: Reply with quote

Site Admin

Joined: Aug 10, 2008
Posts: 1142
Location: Vallejo, California
FireFox276 wrote:
Followed it step by step and all is well!

Is this ship_key (or w/e it was) the ship lockout thing (ie if no key then the ship can't connect)?


Basically, yes.

You generate keys for every ship you want to connect on your gate. They're automatically added to the SQL server, you just need to distribute each ship_key.bin to the ship owners.

ship_server.exe won't start without a ship_key.bin

If a ship connects with a ship_key.bin which isn't in your database, the login_server will reject them from joining your ship list.

Also, a key in use cannot be used more than once.

There will be some additional changes to that, like adding hardware info on it, but as it stands right now... if you give someone a ship_key.bin and they distribute it to someone else, that person can also run a ship on your gate... but only if the other ship is down. (Two ships can't be running simultaneously with the same key...)

If a key gets leaked and someone keeps preventing a ship from joining the gate because they're hording the key, you can always delete that key from your table and generate a new key for that person. (Though people shouldn't be giving out their ship_key.bin anyway... so it's whatever...)
Back to top
View user's profile Send private message Send e-mail    
FireFox276
PostPosted: Tue August 26th, 2008 12:38 pm    Post subject: Reply with quote



Joined: Aug 11, 2008
Posts: 337
A very nice system if I may say so, nice work Smile
Back to top
View user's profile Send private message    
FireFox276
PostPosted: Tue August 26th, 2008 12:49 pm    Post subject: Reply with quote



Joined: Aug 11, 2008
Posts: 337
Double Postz0rz!

If you try and use "add_account.exe" and "make_key.exe" you'll get an error saying the config file is missing, do either one of 2 things:

1. Move both add_account.exe and make_key.exe" into the same folder as login_server.exe
OR
2. Move a copy of "tethealla.ini" into the "other" folder

Whichever you want.

I know this seems obvious but there'll be some people who won't have a clue!
Back to top
View user's profile Send private message    
Sodaboy
PostPosted: Tue August 26th, 2008 1:00 pm    Post subject: Re: Newest binaries (login_server included and how to set up Reply with quote

Site Admin

Joined: Aug 10, 2008
Posts: 1142
Location: Vallejo, California
Sodaboy wrote:
5. 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 folder into the same folder as login_server.exe and account_add.exe


Guess I should have typed "folders"...?

*edits*
Back to top
View user's profile Send private message Send e-mail    
FireFox276
PostPosted: Tue August 26th, 2008 1:02 pm    Post subject: Reply with quote



Joined: Aug 11, 2008
Posts: 337
ugh, I feel stupid now! I was kinda going of my old one, I already had account_add.exe in the same folder as login_server.exe you see, I just got confuzzled!
Back to top
View user's profile Send private message    
Moofey
PostPosted: Tue August 26th, 2008 1:18 pm    Post subject: Reply with quote



Joined: Aug 16, 2008
Posts: 40
I can't seem to get my ship to connect to my login server, even after generating the key and placing it in my ship's folder.

Also checked the SQL database and the key was successfully registered in there, too.

Nothing changed aside from updating both servers and generating/adding the key. Everything was working fine before.
Back to top
View user's profile Send private message    
Sodaboy
PostPosted: Tue August 26th, 2008 1:20 pm    Post subject: Reply with quote

Site Admin

Joined: Aug 10, 2008
Posts: 1142
Location: Vallejo, California
Welp, try trashing your table, making a new key then making sure you copy that key into your ship's folder immediately.

It should work fine, I've tested it.
Back to top
View user's profile Send private message Send e-mail    
Moofey
PostPosted: Tue August 26th, 2008 1:23 pm    Post subject: Reply with quote



Joined: Aug 16, 2008
Posts: 40
EDIT: Pfft. I'm officially a programming retard. I compiled the old source over the binary. Go me.

A quick re-extract fixed things of course.

ProTip: It's called binary and not source for a reason.


Last edited by Moofey on Tue August 26th, 2008 1:32 pm; edited 2 times in total
Back to top
View user's profile Send private message    
Nyao
PostPosted: Tue August 26th, 2008 1:29 pm    Post subject: Reply with quote



Joined: Aug 16, 2008
Posts: 307
Location: In a place far far away
Lol I'm the only one that can make it work?

Emmm Moofey compiling? WTF?....i don't think soda updated the sauce.
Back to top
View user's profile Send private message    
Moofey
PostPosted: Tue August 26th, 2008 1:32 pm    Post subject: Reply with quote



Joined: Aug 16, 2008
Posts: 40
Piro wrote:
Lol I'm the only one that can make it work?

Emmm Moofey compiling? WTF?....i don't think soda updated the sauce.


^He didn't. That's why I'm an idiot. lol
Back to top
View user's profile Send private message    
Nyao
PostPosted: Tue August 26th, 2008 1:51 pm    Post subject: Reply with quote



Joined: Aug 16, 2008
Posts: 307
Location: In a place far far away
Waits for lee.....nah..nvm xD
LOL NUB!

Anyway: *Gets killed by soda* For those people who don't want to play/test in Tethealla T.T and don't want (because they are lazy, stupid etc) I'll be leaving Sylvarant as a login server, so anyone who wants to put their ship in there just bump me via Pm, and i'll gib you a Ship key / Account ;P

I'll personally stay in Thethe....Need...to...beat...anh....(You turned it epic Lee)
Back to top
View user's profile Send private message    
Sodaboy
PostPosted: Tue August 26th, 2008 3:45 pm    Post subject: Reply with quote

Site Admin

Joined: Aug 10, 2008
Posts: 1142
Location: Vallejo, California
New version of login already...

http://www.pioneer2.net/spsos_login_v.006.zip


Quote:
version 0.006 8/26/2008
-----------------------
- Changed order of operations during ship registration to try to connect
to the ship as the last thing to do. (Prevents ships with bad encryption
and so on from lagging up the login process...)
- Now displays key index of registering ship.
- Now gets the maximum number of keys from the SQL table and will ignore
all other indexes higher than this range.


version 0.005 8/26/2008
-----------------------
- Initial public release
Back to top
View user's profile Send private message Send e-mail    
Nyao
PostPosted: Tue August 26th, 2008 4:02 pm    Post subject: Reply with quote



Joined: Aug 16, 2008
Posts: 307
Location: In a place far far away
Sodaboy wrote:
New version of login already...

http://www.pioneer2.net/spsos_login_v.006.zip


Quote:
version 0.006 8/26/2008
-----------------------
- Changed order of operations during ship registration to try to connect
to the ship as the last thing to do. (Prevents ships with bad encryption
and so on from lagging up the login process...)
- Now displays key index of registering ship.
- Now gets the maximum number of keys from the SQL table and will ignore
all other indexes higher than this range.


version 0.005 8/26/2008
-----------------------
- Initial public release



:3 Btw..somehow you fixed my loginstuck bug on tethealla ;P (Went to need 15 logins to log to 1-2)

Err can i beg you something?....."Gib php file xD"
Back to top
View user's profile Send private message    
Sodaboy
PostPosted: Tue August 26th, 2008 4:08 pm    Post subject: Reply with quote

Site Admin

Joined: Aug 10, 2008
Posts: 1142
Location: Vallejo, California
Piro wrote:
:3 Btw..somehow you fixed my loginstuck bug on tethealla ;P (Went to need 15 logins to log to 1-2)

Err can i beg you something?....."Gib php file xD"


There was some faggot trying to register a ship repeatedly and it kept making the login server try the connection test on him before it checked his key data.

That's why the connection test is the last check now before authenticating a ship.

And PHP file? I'm guessing you're trying to be cute because you said C and PHP look similar... so you must be meaning the source.

NOT YET
Back to top
View user's profile Send private message Send e-mail    
Nyao
PostPosted: Tue August 26th, 2008 4:17 pm    Post subject: Reply with quote



Joined: Aug 16, 2008
Posts: 307
Location: In a place far far away
Source? i meant the signup page on php xD,

For the source don't worry i can't wait till saturday for the next source update :3 *is learnin a lot of C thx to it xD*
Back to top
View user's profile Send private message    
s0me0ne
PostPosted: Tue August 26th, 2008 4:47 pm    Post subject: Reply with quote



Joined: Aug 11, 2008
Posts: 73
lol im fucked if i know why i cant get account_add to work coz make_key inserts keys into the db just fine and they both use the same tethealla.ini
Back to top
View user's profile Send private message    
Nyao
PostPosted: Tue August 26th, 2008 4:57 pm    Post subject: Reply with quote



Joined: Aug 16, 2008
Posts: 307
Location: In a place far far away
s0me0ne wrote:
lol im fucked if i know why i cant get account_add to work coz make_key inserts keys into the db just fine and they both use the same tethealla.ini


Damaged Db? try making the Db,...or you could join Sylvanet ;P xD
Back to top
View user's profile Send private message    
Sodaboy
PostPosted: Tue August 26th, 2008 5:27 pm    Post subject: Reply with quote

Site Admin

Joined: Aug 10, 2008
Posts: 1142
Location: Vallejo, California
He probably didn't execute the commands in pso_server.sql right to even build the database.
Back to top
View user's profile Send private message Send e-mail    
Sodaboy
PostPosted: Tue August 26th, 2008 9:51 pm    Post subject: Reply with quote

Site Admin

Joined: Aug 10, 2008
Posts: 1142
Location: Vallejo, California
Found a small bug.

Just posted the new version of ship to correct it. (See top post...)


Quote:
version 0.039 8/26/2008
-----------------------
- Fixed a bug with loading the wrong maps for Seabed 1 & 2 for one
person mode.


This version will need to be used if anyone plans to play a non-quest run of Episode 2 in One Person. Otherwise you'll get the wrong experience and also disconnected at the bosses.
Back to top
View user's profile Send private message Send e-mail    
Nyao
PostPosted: Wed August 27th, 2008 8:08 am    Post subject: Reply with quote



Joined: Aug 16, 2008
Posts: 307
Location: In a place far far away
You should say to update the login server too ;P
Back to top
View user's profile Send private message  

 

—————

Voltar