|
|
| (52 intermediate revisions by 3 users not shown) |
| Line 2: |
Line 2: |
| == Server Setup == | | == Server Setup == |
| === Download Files === | | === Download Files === |
| * [magnet:?xt=urn:btih:938C769EC2BEEE7C7F381570B93A861A60BD4FE5&dn=i25Binaries_InsurancePolicy.7z&tr=udp%3a%2f%2ftracker.openbittorrent.com%3a80%2fannounce&tr=udp%3a%2f%2ftracker.opentrackr.org%3a1337%2fannounce i25 Binaries Torrent] | | * [[i25 Downloads]] |
| * [https://www.microsoft.com/en-gb/sql-server/sql-server-editions-express SQL Express Edition] | | |
| * [https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017 SQL Management Studio]
| | === Online Tools === |
| | * [[i25 Online Tools]] |
|
| |
|
| === Setup Local Server === | | === Setup Local Server === |
| * Install SQL Server 2017 Express Edition | | * [[I25 Server Setup]] |
| * Choose Basic when installing and when given the option choose to install SSMS.
| |
| * Open up wherever you extracted the i25 Binaries folder and navigate to data\server\db
| |
| * Open up chat_server.cfg and account_server.cfg
| |
| ; You will see something like this.
| |
| : SqlLogin "DRIVER={SQL Server Native Client 11.0};Server=NS319069\SCORE;Uid=sa;Pwd=FinallyFree!;"
| |
| ; Change this to
| |
| : SqlLogin "DRIVER={SQL Server Native Client 11.0};Server=localhost\SQLEXPRESS;Uid=sa;Pwd=password;"
| |
| * You can change the password to whatever you would like. For this example I will be just using password.
| |
| * Now open up server.cfg and change all the ips to localhost (Note : You could also set these to your local ip if you know it.)
| |
| ; At the top of the file you will see this.The IP will be set to whatever you previous set it to.
| |
| : DBServer 192.168.0.1 18717
| |
| : ShardName Bree
| |
| : AuthServer 192.168.0.1 2104
| |
| : DefaultAccessLevel 0
| |
| : NoStats 1
| |
| * Change the ShardName to whatever you would like and add 2 slashes infront of AuthServer. And add UseFakeAuth 1 under NoStats 1
| |
| ; It should now look like this
| |
| : DBServer localhost 18717
| |
| : ShardName ShardName
| |
| : //AuthServer 192.168.0.1 2104
| |
| : DefaultAccessLevel 0
| |
| : NoStats 1
| |
| : UseFakeAuth 1
| |
| * Okay now extract the dbschema.rar found in your i25 folder. We will be using these later.
| |
| * Open up SQL Server Management Studio (SSMS which you installed in the first step). Your one will look slightly different and hit Connect.
| |
| * Now we have to enable SQL logins so that the databases can connect. We need to enable them and the sa login so that user can login to the database.
| |
| * If you look to the left panel you will see the object explorer and your connection. Right click it and enter properties.
| |
| * When this window comes up hit Security to the left and enable sql server and windows authentication. Then click ok.
| |
| * In the same panel you used before navigate to Security -> Logins then right click and enter properties the sa user.
| |
| * In this window set the password to the same password you set back at step 4
| |
| * Once you are done there. Choose Status from the left panel in this same window and set login to enabled and hit ok.
| |
| * Okay now navigate back to your i25 folder and open the dbschema folder I previously had you extract and open up cohauc.sql in SQL Server Management Studio.
| |
| * You will see these 2 lines at the top of the file opened
| |
| ** ( NAME = N'cohauc', FILENAME = N'C:\mssql\MSSQL11.SCORE\MSSQL\DATA\cohauc.mdf' , SIZE = 157440KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
| |
| ** ( NAME = N'cohauc_log', FILENAME = N'C:\mssql\MSSQL11.SCORE\MSSQL\DATA\cohauc_log.ldf' , SIZE = 353216KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
| |
| * What you want to do is set the first part of these directory listings to where your SQL Server is located for example, I set my to D:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL because that is where my SQL Server is. So my would become:
| |
| ** ( NAME = N'cohauc', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA\cohauc.mdf' , SIZE = 157440KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
| |
| ** ( NAME = N'cohauc_log', FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA\cohauc_log.ldf' , SIZE = 353216KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
| |
| * Once done click the Execute button. And do this again for both the cohauth and cohchat.
| |
| * Once you have done that you can now start up your server. Navigate back to your i25 files and start up dbserver and dblauncher
| |
| ** Note : you will have to fix up these shortcuts so they point back to their intended destinations.
| |
| * Go to your City of Heroes folder and make a shortcut of score.exe adding
| |
| ** score.exe -db 127.0.0.1 -console -patchdir score -noversioncheck -project "coh"
| |
| * Login and Enjoy!
| |
|
| |
|
| == Setup Auth Server == | | == Setup Auth Server == |
| * The first thing you are going to want to do is set the ips in server.cfg to your Internal/Local ip. Then you will remove the slashes from the front of authserver and putting them infront of UseFakeAuth 1 and that is nolonger necessary. | | * [[I25_Server_Setup#Setup_Auth_Server]] |
| ** DBServer 192.168.0.48 18717
| | |
| ** ShardName Personality
| | == Setup Auction Server == |
| ** AuthServer 192.168.0.48 2104
| | * [[I25_Server_Setup#Setup_Auction_Server]] |
| ** DefaultAccessLevel 0
| | |
| ** NoStats 1
| | == Setup using Virtual Server Image == |
| ** //UseFakeAuth 1
| | * [[i25 Community Virtual Machine]] |
| * Open up ODBC Data Sources. | |
| ** Click File DSN then click add to the right.
| |
| ** Choose ODBC Driver 17 for SQL Server. Click Next.
| |
| ** Enter AuthDB into the box and hit next then finish.
| |
| ** It will then say something like ‘Which SQL Server would you like to connect to?’
| |
| *** Type localhost\SQLEXPRESS and hit next. | |
| ** Choose with SQL Auth enter sa into username and the password you use previously.
| |
| ** Tick choose change default database to and select cohauth and hit next.
| |
| ** After this hit finish then ‘Test Data source’ this will test the auth database connection to your main database if it successful congrats :D
| |
|
| |
|
| == Port Forwards == | | == Port Forwards == |
| === Port 11228(TCP) ===
| | * [[I25_Server_Setup#Port_Forwards]] |
| === Port 18718(UDP) ===
| |
| === Port 18717(UDP) ===
| |
|
| |
|
| == Common Issues == | | == Common Questions == |
| === Issue One ===
| | * [[I25 FAQ]] |