The Myth of Soma server setup guide

General assistance and guidelines for editing the server side of Soma.

The Myth of Soma server setup guide

Postby arcanine » Wed May 05, 2010 7:51 pm

The Myth of Soma Server setup guide


Software:

  1. MSSQL 2008 R2 Express (235MB x86 / 247MB x64)
  2. The Myth of Soma server files (7.3MB approx)( Extract them to c:\SERVER)
  3. XVI32 (558KB)
  4. Xampp 1.7.3 (53.7 MB)
  5. An installed Myth of Soma client (366MB)


Step One: Downloading MSSQL

  1. Download SQL Server 2008 R2 express from:
    http://www.microsoft.com/express/Database/
    get the installer for the Database and the Management Tools
  2. It will ask you whether you want x86 or x64 if you are not sure what the difference is download the x86 version of the database installer.
  3. Wait until your download is complete, and then open the installer.

Step Two: Installing MSSQL
  1. Click New Installation or add features to an existing installation.
  2. Tick I accept the license terms and press next.
  3. Ensure all tick boxes are selected and press next.
  4. Click Named instance, and press next.
  5. Press next.
  6. Press next.
  7. Select Mixed mode and enter a strong and long password and press next.
  8. Press next.
  9. After install has completed, press close.


Step Three: Configuring MSSQL
  1. Open SQL Server Management Studio, you'll find it in the start menu under 'Microsoft SQL Server 2008 R2'.
  2. Select Windows Authentication press Connect.
  3. Right click Databases and press restore Database.
  4. Select From device and click the button that says '...' to the right.
  5. Press Add, go to 'C:\SERVER\oneperone\db and select 'soma.bak' press okay.
  6. Press okay tick the tick box and type soma in the top drop down box press okay.
  7. Press okay, expand Security right click Logins and press New Login.
  8. Type soma in the login name box and select SQL Server authentication type soma into the password field, untick Enforce password policy.
  9. Change the default database to soma, press User Mapping tick soma and tick db_owner press okay.
  10. Right click the instance at the top of the object explorer and click properties and click connections and untick Allow remote connections to this server, press okay

Step Four: ODBC connector
  1. Press windows key and r together, type Odbcad32.exe and press okay. (if you are running a 64bit system type %systemdrive%\Windows\SysWoW64\Odbcad32.exe instead)
  2. Select System DSN and press Add...
  3. Scroll down the list and select SQL Server press finish.
  4. Type soma into name, a description into description and type localhost\SQLExpress
  5. Press next, select with SQL Server authentication, enter soma under login ID and enter soma under password press next.
  6. Select Change the default database to and select soma from the drop down box press next and finish.
  7. Press test data source, if you do not see TESTS COMPLETED SUCCESSFULLY! review your installation up until this point and try and figure out what is preventing you from connecting to your database.
  8. Press okay three times until the ODBC is not in view.


Step Five: Services Setup
  1. Go to C:\SERVER\services\Service Management\Service Creator
  2. Open config.ini in a text editor
  3. Change the IP line to your current LAN IP
  4. Save and close changes
  5. Open Soma Services.exe and press Create Services
  6. Check the Services by pressing View Services make sure SOMA user, SOMA game, SOMA session are running
    if not start them in the order above by selecting them and pressing start

Step Six: Start the server
  1. Go to c:\SERVER\oneperone and open sharedmem.exe
  2. Open oneperone.exe in the same folder, if you are running the latest server files you should see no errors
    Close the server by opening task manager and ending the oneperone.exe process and then closing sharedmem.exe

Step Seven: Setting up your register page
  1. Go to http://sourceforge.net/projects/xampp/f ... e/download and download the .exe 53.7mb self extracting RAR archive
  2. Run the xampp install click install, follow the command line installer
  3. When the installer has finished go to c:\SERVER\Tools\Web tools select all the files in that directory and right click them and press copy. Go to c:\xampp\htdocs and press paste.
  4. Go to c:\xampp\php\php.ini open it in a text editor, replace
    Code: Select all
    ;extension=php_mssql.dll
    with the line
    Code: Select all
    extension=php_mssql.dll
    save the file.
  5. Go to Start > Programs > Microsoft SQL Server 2008R2 > Configuration Tools > and open SQL Server Configuration Manager.
  6. Expand SQL Server Network Configuration, press Protocols for MSSQLSERVER Double-click the protocol name TCP/IP and set the property ENABLED to Yes. Double-click the protocol name Named Pipes and set the property ENABLED to Yes.
  7. Press start click run type services.msc and press enter and scroll down until you find the service called "SQL Server" select this service and press restart.
  8. Open XAMPP control panel from the start menu and click Start Apache
  9. Check the register page by opening your web browser and navigating to http://localhost/register.php


Step Eight: Port forwarding
  1. If you are not familiar with your own router's forward porting functionality check http://portforward.com/ for your router's model which should give you an idea of how to perform port forwarding on your particular router
  2. Forward the ports 12000, 4110 and 80 from your router to your PC, ensure windows firewall has an exception for those ports and that any third party firewalls you may have also have exceptions for those ports
  3. Go to https://www.grc.com/x/ne.dll?bh0bkyd2 press proceed and type 12000, 4110, 80 into the text field and press "User Specified Custom Port Probe" this is the result you want:
    Image
  4. If you do not get "failed", check your router forwarding settings, firewall settings and check to see whether your services, xampp and oneperone are running during the scan

Step Nine: Connecting
  1. Go to c:\SERVER\services and open dir.ini in a text editor replace the line
    Code: Select all
    SVR01_ADDR=
    with
    Code: Select all
    SVR01_ADDR=WANIPHERE
  2. type services.msc into your start menu and press enter and stop the user, game and session service, then start them in order: User, Game, Session
  3. Right click on your desktop press new > shortcut and type
    Code: Select all
    C:\Soma\Soma.exe LANIPHERE
    and press next then finish, double click the newly created shortcut


Step Ten: Gm creation
  1. Go to http://localhost/register.php make yourself an account, and log into your game, create a character and remember the character's username, once your character has been created, quit the game
  2. Open Microsoft SQL Server Management Studio and connect to your database, press new query and paste
    Code: Select all
    UPDATE GAMEUSER SET
    sLEVEL = '25', iSTR = '200000000', iDEX = '2000000000', iINT = '200000000', iCHA = '2000000000', iWIS = '2000000000', iCON = '200000000', sHP = '2500', sMAXHP = '2500', sMP = '2500', sMAXMP = '2500', sSTM = '2500', sMAXSTM = '2500', sMAXWGT = '2500', iMORAL = '7400000', iMONEY = '500000', iBANK = '50000000', sRANK = '1', iSwordEXP = '20000000', iSpearEXP = '20000000', iBowEXP = '20000000', iAxeEXP = '20000000', iKnuckleEXP = '20000000', iStaffEXP = '20000000', iWeaponMakeEXP = '20000000', iArmorMakeEXP = '20000000', iAccMakeEXP = '20000000', iPotionMakeEXP = '20000000', iCookingEXP = '20000000', iWMagicEXP = '10000000', iBMagicEXP = '10000000', iDMagicEXP = '0'
    WHERE strUserId = 'CharNameHere'
    substituting 'CharNameHere' for your character name for example = 'Arcanine'
  3. Press the green play button at the top and ensure it says one row has been affected then log back into your game to test your gm character, you can find gm commands here all gm commands are executed by typing forward slash in game and then the gm command for example:
    Code: Select all
    /rain 1
    confirm by pressing enter


Troubleshooting
Q: MSSQL says I need powershell 2.0 where can I install it from?
A:
Code: Select all
http://dl.dropbox.com/u/2104457/PowerShell_Setup_x86.msi

or search for it on google here:
Code: Select all
http://www.google.co.uk/search?hl=en&q=PowerShell_Setup_x86.msi&meta=


Q: I've broken my services and need to start again
A: Press Uninstall services on the Service Creator.exe application, close the application and then continue from step six

Q: I can connect to my server but people from outside my network cannot connect to my server, and I have forwarded my ports and allowed the right ports through the firewall
A: Ensure your server is setup to use your LAN IP and not a loopback IP (127.0.0.1) you can find your LAN IP by running Internet Protocol Two.exe in the server directory typically it will start with 192.168.1

Q: I'm trying to setup my services and when I try to connect I get the SELECT permission was denied on the object @version@ databvase @soma@ schema @dbo@. the cursor was not declared
A: Open up MSSQL go to security -> logins, open up soma and ensure db_owner is ticked, if it is already ticked try unticking and ticking it again, if all else fails, delete the soma user and follow step three section 7 - 9 of the guide.

Q: My apache service in xampp refuses to start even after trying step 8 section 7
A: http://www.apachefriends.org/en/faq-xam ... ml#nostart

Q: My oneperone is taking longer than I would usually expect for this computer
A: Enable named pipes and TCP/IP connectivity to MSSQL via the configuration manager found in the start menu under the MSSQL folder, restart the MSSQL service after changes.


Credits and Acknowledgements
Credits to every forum member that made this possible over the years in particular: Finito Rauban Remix Tiffany and Miser who have often helped me directly.


pdf and doc versions included below:
The Myth of Soma guide.zip
You do not have the required permissions to view the files attached to this post.
Last edited by arcanine on Fri Mar 30, 2012 3:17 am, edited 87 times in total.
User avatar
arcanine
SD Pro 5 Star
SD Pro 5 Star
 
Posts: 1056
Joined: Mon Apr 21, 2008 2:53 pm

Re: The Server Setup Guide 2 (work in progress)

Postby StarLite » Thu May 06, 2010 12:29 pm

im having trouble with this when i come to connect to server it comes up with this error
Untitled.jpg



any help on this please
StarLite
SD Two Star
SD Two Star
 
Posts: 53
Joined: Tue Apr 20, 2010 6:45 pm

Re: The Server Setup Guide 2 (work in progress)

Postby arcanine » Fri May 07, 2010 4:33 pm

what login are you trying to use?

if you can't login through windows authentication and don't have a soma account you can use your sa account to log in
User avatar
arcanine
SD Pro 5 Star
SD Pro 5 Star
 
Posts: 1056
Joined: Mon Apr 21, 2008 2:53 pm

Re: The Server Setup Guide 2 (work in progress)

Postby Tiffany » Fri May 07, 2010 8:25 pm

You can get errors like this if you have previously created a mssql server instance, partly uninstalled and then reinstalled a named instance. What can happen is that you leave the default instance with the old sa name / pass but the new named instance has a new sa / pass.

The only real way out of this is removing via regedit if the add/remove programs options are not completely removing. There is some help available for removing MSSQL instances... just use a search engine to easily find the help.
Tiffany
SD Pro 2 Star
SD Pro 2 Star
 
Posts: 428
Joined: Sat Jan 12, 2008 1:17 pm

Re: The Server Setup Guide 2 (work in progress)

Postby StarLite » Sat May 08, 2010 12:44 am

ok ive done that all now works fine but whats after that do i just do the same service manager??
StarLite
SD Two Star
SD Two Star
 
Posts: 53
Joined: Tue Apr 20, 2010 6:45 pm

Re: The Server Setup Guide 2 (work in progress)

Postby Tiffany » Sat May 08, 2010 9:05 am

StarLite wrote:ok ive done that all now works fine but whats after that do i just do the same service manager??

The main issue I tend to find is the key bit is the setup of the ODBC service link (after the installation of MSSQL is ok - this can take some time if your MSDAC service pack is too old or wrong version). A lot of people choose the wrong ODBC driver to try to connect to a specific MSSQL version and care needs to be exercised to choose wisely.

An easy check can be made since the ODBC version starts with the MSSQL name or version group, so when you click add System Data source in ODBC DAta Source Administrator make sure the driver you highlight is the right version by scrolling to the right as the version is hidden. IF your version of MSSQL is 2005 DONT choose the 6.blah blah, choose the 2005.blah.blah instead.
Tiffany
SD Pro 2 Star
SD Pro 2 Star
 
Posts: 428
Joined: Sat Jan 12, 2008 1:17 pm

Re: The Server Setup Guide 2 (work in progress)

Postby StarLite » Sun May 09, 2010 10:10 am

the problem im faced with now is i cant seem to get the game service running :/
StarLite
SD Two Star
SD Two Star
 
Posts: 53
Joined: Tue Apr 20, 2010 6:45 pm

Re: The Server Setup Guide 2 (work in progress)

Postby Tiffany » Sun May 09, 2010 10:30 am

StarLite wrote:the problem im faced with now is i cant seem to get the game service running :/

Are you absolutely certain that the game.exe application has the correct hexed values for your ODBC connection (e.g. DSN=soma;UID=soma;PWD=soma) in it as you will not be able to start it if the connection does not work.
Tiffany
SD Pro 2 Star
SD Pro 2 Star
 
Posts: 428
Joined: Sat Jan 12, 2008 1:17 pm

Re: The Server Setup Guide 2 (work in progress)

Postby deccy » Wed May 12, 2010 5:44 pm

hi there i have tried to instal sql and when installing it i get a error of windows powershell could someone enlighten me on what that is and how to fix the problem it says its not installed i had a look on the microsoft site but could not find the right thing http://www.microsoft.com/downloads/en/r ... layLang=en thats the link and what i typed in but i didnt know what i was downloading could someone be of some help to me please thankyou
deccy
SD Two Star
SD Two Star
 
Posts: 68
Joined: Tue Nov 18, 2008 3:36 am

Re: The Server Setup Guide 2 (work in progress)

Postby Reflex » Wed May 12, 2010 10:35 pm

ive got powershell do u want me to upload it for u?
Reflex
SD One Star
SD One Star
 
Posts: 14
Joined: Sun May 09, 2010 9:33 pm

Next

Return to Server Development

Who is online

Users browsing this forum: No registered users and 1 guest

cron