Re: [Request] Atlantica online files
This is HighGamer owner of
You must be registered to see links
biggest gold seller in AO..
I wrote a whole tutorial here to help you guys out
First of all rename authserver folder to AuthServer
save in the directory where all the folders are a file call it like "Run Servers.cmd"
Inside put
Code:
cd AccountDBManager
START AccountDBManager.exe
cd ..
cd AtlanticaDBManager
START AtlanticaDBManager.exe
cd ..
cd AuthServer
START AuthServer.exe
cd ..
cd CommunityServer
START CommunityServer.exe
START CommunityDBManager.exe
cd ..
cd FrontServer
START FrontServer.exe
cd ..
cd LogDBManager
START LogDBManager.exe
cd ..
cd MasterServer
START MasterServer.exe
cd ..
cd NGMDBManager
START NGMDBManager.exe
cd ..
cd NGMServer
START NGMServer.exe
cd ..
cd ServerAgent
START ServerAgent.exe
cd ..
cd Atlantica
START Atlantica.exe
Here are some screenshots how all the servers should look if everything is running properly!
Here is the tutorial!
Step 1)
If you installed SQL Server 2014 Express From here
You must be registered to see links
Step 2)
This youtube video is for a different game server (MUOnline), but the process is the same for atlantica server this should fix all SQL errors.
You must be registered to see links
Step 3)
After connecting to SQL with the SQL Server Management Studio, you'll have to setup from Windows Authentication to Mixed-mode authentication, because the Atlantica server uses the database username 'sa' and password 'qweQWE123'
Step 4)
You'll have to open TCP/IP also allow IP 127.0.0.1 to Listen on port 1433 You just need to set TCP/IP from Disabled to Enabled, this is done by this link
You must be registered to see links
you'll just need to open another program that comes installed with SQL server called "SQL Server Configuration Manager" for sql server to be reached by the atlantica server files. (Restart SQL Server in SQL Server Configuration Manager) or SQL Server Management Studio.
Here is Copy/Paste of the link above
What To Do
[*=left]On the SQL Server, open 'SQL Server Configuration Manager'.
Note: This can typically be found linked from the 'Start' menu. For example: Start | All Programs | Microsoft SQL Server 2008 R2 | Configuration Tools | SQL Server Configuration Manager.
[*=left]Expand 'SQL Server Network Configuration' and highlight the 'Protocols for [InstanceName]' option.
[*=left]In the right-hand window, if 'TCP/IP' currently has the 'status' of 'Disabled', right click on 'TCP/IP' and select 'Enable'.
Note: You will be requested to restart the SQL Server service to complete the configuration change.
[*=left]To restart the service, you can use the same Microsoft Management Console (MMC) window. To do so, highlight the 'SQL Server Services' option at the top of the tree. In the right-hand window, you can then right click on the 'SQL Server [Instance]' entry and choose 'Restart'.
The SQL instance has now been configured to accept TCP/IP connections from remote computers.
Step 5)
Open SQL Server Management Studio click Security folder then click Logins folder right click sa user then click Properties then click Status and click Login: Enabled also in General set the SQL Server authentication and password to qweQWE123 also you may click Specift old password and put same password qweQWE123 this will ensure any problems.. maybe not needed but I did it anyways.
Restart the SQL Server by right clicking the green arrow on the whole tree the first item in the tree that loads up all the folders it'll have a [Start , Stop, Resume Restart], click Restart.
Step 6)
You have to edit the MasterServer open serverinfo.txt file and fix all the ExecFile to the proper paths, this is the main reason everyone fails to run the server!, Also change the IP's all to "127.0.0.1"
Step 7)
In SQL Server Management Studio Press "New Query" button or just use hotkey CTRL+N, inside paste this in
Code:
USE [AT_AccountDB]
GO
INSERT INTO [dbo].[tbl_MasterIP]
([IP])
VALUES
('127.0.0.1')
GO
USE [AT_AccountDB]
GO
INSERT INTO [dbo].[tbla_ManagerIP]
([IP])
VALUES
('127.0.0.1')
GO
USE [AT_AccountDB]
GO
INSERT INTO [dbo].[tbla_masterip]
([IP])
VALUES
('127.0.0.1')
GO
Press Execute and that should fix the IP issue (Not even sure if this is necessary but it will help and ensure other troubles in the future)
Step 8)
Now you have to make a account properly right? maybe.. but here are a few default ones
ID: archonus PW: 9444
ID: testacc PW: asdfqwerty
If you are interested in the GM Tool, it won't work as it tries to login Nexon Europe servers
Midgard - AT_Midgard 109.234.77.81 : 9201
Niflheim - AT_Niflheim 109.234.77.82 : 9201
Thanatos - AT_Thanatos - 109.234.77.84 : 9201
Titan - AT_Titan - 109.234.77.83 : 9201
I'll release one that connects to these private servers soon, (if it will even connect? not sure)
EDIT: GM_TOOL kinda works, but not completely
Here is GMTool attached on bottom of forum how far I got on it.. if someone gets it working, write about it!
Step 8)
Now everything should work properly!
Step 9)
Client fix by downloading attachment ServerIP.zip replace in OGRealms client, this will allow only you to connect to it assuming you run server from same computer you run game.. I cannot fix this for everything as everyone has a different IP address.. fix it yourself get a ndt decoder/encoder I posted one on progamercity ages ago
You must be registered to see links
Step 10)
To Unblock server from maintenance mode
run this database script
Code:
USE [AT_AccountDB]
GO
UPDATE [dbo].[tbl_Account]
SET
[MasterLevelExpireTime] = '2100-12-06 21:33:00.000',
[MasterLevelValue] = 120
WHERE ID = 'testacc' OR ID = 'archonus'
GO
You cannot edit the MasterLevel as it's read only it gets generated from MasterLevelValue which is only used if MasterLevelExpireTime has still not past.. I set it to year 2100 it should not expire for a while.
If you have a database not initialized error.. remove Titan server from serverinfo.txt in MasterServer folder as said by Lana Balode
If anyone has issues restoring BAK files to older SQL Server's like SQL Server 2008 you can use ATDB Scripts.zip to install this on older SQL Server 2008 / 2001 whatever.
To avoid using /unblock each time run these files I created, they come with a readme.
Atlantica Excellent.exe (This starts the server in Excellent mode)
You must be registered to see links
Atlantica Normal.exe (This starts the server in Nomral mode)
You must be registered to see links
After you run /unblock it should look like this