SOMA SERVER HOW TO!!!! : Myth of Soma - Submissions

BaDgErr - Soma Moderator, Pirate Server last Edit September 14, 2005
Before starting, get the server files from this thread: SERVER - These are the ones I will be referring to in the guide

IF YOUR SERVER "DOESNT WORK" AFTER FOLLOWING THIS, THEN YOU DID SOMETHING WRONG. DON'T MAKE NEW THREADS SAYING "IT WONT WORK, I SEARCHED AND FOUND NOTHING". JUST START AGAIN AND DO IT RIGHT! /rant

If this is not your first time setting up a server, it is recommended that you uninstall any existing services before continuing. You can do this by going to Start>Run, typing cmd.exe, and then these 4 commands:

sc delete "FM_SOMA"
sc delete "UM_SOMA"
sc delete "GS_SOMA_SOMA Game"
sc delete "SM_SOMA_0"

Before I begin: Thanks to everyone who's contributed something to the community - a lot of it will be in this guide somewhere, there's just too many of you to name.


Step 1
Download SQL from HERE (download & extract all three SQLEVAL files) or go on Microsoft MSSQL download site to get an Evaluation copy.

Step 2
Install SQL:

First open autorun.exe in the SQLEVAL folder, then
a. Select "SQL Server 2000 Components"
b. Click "Install Database Server"
c. Click Next
d. Select "Local Computer" and click Next
e. Select "Create a new instance of SQL Server, or install Client Tools" and click Next
f. Put name and/or company and click Next
g. Click Yes to agreement
h. Select "Server and Client Tools" and click Next
i. Make sure "Default" is ticked, and click Next
j. Select "Typical" and click Next
k. Select "Use the same account for each service. Auto start SQL Server Service"
l. Select "Use the Local System Account" and click Next
m. Select "Mixed Mode Authentication" and enter a suitable SA password.
n. Click Next
o. Click Next again and install.

(Source: SQL setup guide from PDF)

Step 3
Extract the serverfiles. I recommend to C:\. References I use here will refer to this path.

Step 4
Restore database

If you haven't already done so, click the little + next to Microsoft SQL Servers, then keep clicking the little +'s as you go down, until you are inside a folder called Databases.

Now you need to open “Restore database…” in enterprise manager.


Select “From device” and then “Select devices…”


Select ”Disk” and then ”Add...”.


Select “File name:”, then “…” and browse database backup file. If you extracted the Server Files to C:\, this file will be C:\ServerFiles\Server\db\Euro.Bak.


Then click ”Ok” and on next window ”Ok”.
Next change “Restore as database” to “soma”.


And then open ”Options” page and check that file paths are suitable for your computer. Leaving them as they are should be fine also, but if they don't work, change them to C:\soma.mdf and C:\soma_log.mdf.
[img]http://i15.photobucket.com/albums/a393/Epoledra/soma/dbpath.jpg[/img

Then click ”Ok” and database should be restored from backup.

Step 5
Setup database login

Open users under soma database and remove all except dbo.


Then open logins in security and add new login.


Use name "soma", password "soma" and default database "soma". Set owner rights to soma database.




Click ok and confirm password.

Step 6
ODBC setup

Open Data Sources(ODBC) (Can be found under administrative tools in control panel on most new windows versions)

Add new System DSN(Not user or file dsn)

Select "SQL Server" as driver. On next page name is "soma" and type (local) in the Server box. Then on next page select sql authentication and username "soma" and password "soma". Then just click next until DSN gets created.





Step 7
Starter service

Run INSTALLSTARTER.BAT in service folder.
It installs starter service and starts it.

Step 8
Other services

Start servicemanager.exe

Then add new server "soma" with your LAN IP. If you do not have a LAN IP, then use your WAN IP, which can be found at http://www.showmyip.com/



Cancel sql server login window if it opens.

Then connect your server.
Write "soma" in all fields. First one is actully DSN and two next are username and password.



If you get a "Connection in Use" error, then go to File>Save, and save your configs. Then close ServiceManager.exe, and run it again. Then quickly reopen the config you just saved (it will be on the recent file list, just above the Exit button on the File menu. Now try and connect again. If you still get connection in use, you didn't do it fast enough, so try again.

Then configure services. Check settings from screenshots - Where the images say C:\soma, use to C:\services.



After the two above, you should click OK - it will ask if you want to install file/user manager. Now that this is done you can continue setting up these:



You also need to set main address to your LAN IP (or WAN IP if you're using that).



Now select SOMA User Manager, and Set the Value GSAddr as your IP address. Then do it again, and set GSPort (you will need to overwrite the value in the box, don't worry, it won't erase it).





Edit services\dir.ini in notepad. Change the line SVR01_ADDR=127.0.0.1 so it reads SVR01_ADDR=your.ip.address

Now you can try to start services.
Start them in order: User, Game, Session, File

Step 9
Starting server

First start sharedmem.exe and then oneperone.exe... You should see no errors.

Congratulations. You have running Myth of Soma server.

(Source: MMans original guide)

To connect to your server, right click your Myth of Soma shortcut on your desktop, look in the Target box and change "session.mythofsoma.net" to your IP address.

To create an account to play on, Open Enterprise Manager again, and go into your Database (this will save you manually connecting in Query Analyzer). Go to the Tools menu, and click SQL Query Analyzer. Now in the big white box, type:

exec createaccount username password
NB: If using Query Analyzer then use exec createaccount "username","password"

Obviously substituting "username" and "password" for your desired login details.
-----------------------------------

If you want to play from LAN and WAN at same time, then you should use SomaProxy.

If you have a router (that means you have a LAN too), then you need to be using SomaProxy to allow others to connect. You will also need to forward two ports on your router. The first is 12000. The second is whichever port you specify in SomaProxy - default is 5110. Instructions on port forwarding for pretty much all routers can be found at http://www.portforward.com/

If you get any "Data source not found or no default driver specified" errors along the way in this guide, then you've set up the ODBC wrong. Make sure it's an SQL Server ODBC, in the SYSTEM DSN tab. Setting a User DSN or File DSN will not work. If you are getting this error and you're not using the files recommended in this thread, then I'm not going to help you. Just use the ones in this thread if you're not sure what you're doing quite yet.

If you get a "Open RollBack Shared Memory Fail!!, GetLastError = 2", then you haven't started sharedmem.exe before trying to start Oneperone.

If you get a "No Authority" error, then you haven't run INSTALLSTARTER.BAT. Even if you have, and you still get the error, run UNINSTALLSTARTER.BAT, then run INSTALLSTARTER.BAT again and it should be fine.

If you have any other problems or questions you can look at somadev.com!!!!!

latest server setup guide