Helpful Links:
https://forum.ragezone.com/f587/aion–4–6–retail–server–1197401/
https://forum.ragezone.com/f587/aion-pts-4-6-files-1174077/
https://forum.ragezone.com/f587/aion-4-6-retail-vm-1197600/
Clients 4.6:
Aion Brasil 4.6 https://onedrive.live.com/?authkey=%21AGfXnNP7%2DKwdpr8&cid=7D5EE7A159572096&id=7D5EE7A159572096%21185508&parId=root&action=defaultclick
(NOT GOOD) EuroAion(4.6): https://euroaion.com/files/euroaion.exe
AionEU 4.6: https://drive.google.com/drive/u/0/folders/0B27KLpQaM5paYVdzNmpxekZNNzA?resourcekey=0-lACBS1q1CsbzZLebFq4nbA
Requirements:
-Windows
-4 CPU
–16GB Ram
-16GB Swap
-atleast 50gb storagespace
Download PTS Files: https://disk.yandex.ru/d/x7a11c-a6A4zsw
Disclimer:
Don’t change paths or/and passwords without understanding how it works or you catch some gliches and troubles in work
Database/Game/Login/NPC/Chat/Petition/Cache/Auth/AuthGate Server
Install SQL server 2019 : https://go.microsoft.com/fwlink/?linkid=866662
How to install :https://computingforgeeks.com/instal…indows-server/a.
Set SQL Server to Mixed Mode Auth and give SA:U6SjJk3ZyQhrv5tqb.
1.
Install SSMS : https://aka.ms/ssmsfullsetup2.
Best is keep that File Structure:
D:AiON_SERVER1.
3.
Open SSMS and login with “sa” account, and in “Properties” of SQL Server in section “Advanced” change “Max Text Replication Size” to “65664” and restart SQL Server.4.
In SSMS restore from “AiON_SERVERSQLDATA” folder databases:
– AccountCacheD
– aion_log
– aionaccounts
– aionworld_110
– bkpetitiondb
– petitiondb
5.
run “ODBC Data Sources (64-bit)” and in section “File DSN” press folder icon on right side of “Look in:” and listen to “D:AiON_SERVERODBC”
remember – SQL connection parameters and other setting possible stores in registry sections “HKLMSOFTWARENC Soft” and “HKCUSOFTWARENC Soft”1.
6.
Open SQL Server Config Manager and enable tcp/ip, Named Pipes and Shared Memory
Set IP Address to 127.0.0.1 or LAN Address
i.
1.
7.
Go to “AiON_SERVER_SERVERChannelChattingServer”, edit “ChatServerList_Server.xml” then replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>), leave ports as is8.
Go to “AiON_SERVER_SERVERMainServer”, edit “common.xml” then replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>), leave ports as is9.
Go to “AiON_SERVER_SERVERMainServer”, edit “config.xml” then replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>), leave ports as is10.
Go to “AiON_SERVER_SERVERPetitionServer”, edit “AppConfigForServiceCode.xml” then replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>), leave ports as is11.
Go to “AiON_SERVER_SERVERPetitionServerDB”, edit “codec.txt” then replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>), leave ports as is12.
Go to “AiON_SERVER_SERVERPetitionServer”, edit “PetitionD_Integration.exe.config” then replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>),
and U must correcting string at line 16 – “<add key=”DatabaseConnString” value=” by copy in clipboard string between “”, then launch “AiON_SERVER_SERVERPetitionServerDBcodec.exe”,1.
and in section over “Decrypt” button paste copied data, then press “Decrypt” button, after thet select and copy to clippboard text from “Output” section,
and in section over “Encrypt” button paste copied data, replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>), then press “Decrypt” button, after thet select and copy to clippboard text from
“Output”,
and in file “AiON_SERVER_SERVERPetitionServerPetitionD_Integration.exe.config” at line 16 – “<add key=”DatabaseConnString” value=” paste from clipboard string by replace text between “”
13.
In SSMS open database “aionaccounts” and in table “dbo.server” change paramer “ip” to your’s server IP14.
In SSMS open database “aion_log” and in table “aiongm_ur.TBL_WORLD_SERVER_INFO” and table “dbo.TBL_WORLD_SERVER_INFO” change paramers in “SERVER_URL” by correctin password for DB connection
string it’s enought for start all servers include GM part
15.
IIS/GM Server Installation:
If U needed GM Web console, so install IIS with ASP .NET 4.x & .NET 4.7 or above1.
– Enable “HTTP Activation feature” for IIS
– In SSMS create in MS SQL User name “aiongm_ur” with password “aiongm_ur00” and give him full acces to “aion_log” DB if not have yet or edit file “d:AiON_SERVER_AION_WEBconfexternal_config.xml” and
replace connection string.
Aion 4.6 PTS SetupGuide
Mittwoch, 16. März 2022 21:52
Aion Seite 1
https://forum.ragezone.com/f587/aion–4–6–retail–server–1197401/
https://forum.ragezone.com/f587/aion-pts-4-6-files-1174077/
https://forum.ragezone.com/f587/aion-4-6-retail-vm-1197600/
Clients 4.6:
Aion Brasil 4.6 https://onedrive.live.com/?authkey=%21AGfXnNP7%2DKwdpr8&cid=7D5EE7A159572096&id=7D5EE7A159572096%21185508&parId=root&action=defaultclick
(NOT GOOD) EuroAion(4.6): https://euroaion.com/files/euroaion.exe
AionEU 4.6: https://drive.google.com/drive/u/0/folders/0B27KLpQaM5paYVdzNmpxekZNNzA?resourcekey=0-lACBS1q1CsbzZLebFq4nbA
Requirements:
-Windows
-4 CPU
–16GB Ram
-16GB Swap
-atleast 50gb storagespace
Download PTS Files: https://disk.yandex.ru/d/x7a11c-a6A4zsw
Disclimer:
Don’t change paths or/and passwords without understanding how it works or you catch some gliches and troubles in work
Database/Game/Login/NPC/Chat/Petition/Cache/Auth/AuthGate Server
Install SQL server 2019 : https://go.microsoft.com/fwlink/?linkid=866662
How to install :https://computingforgeeks.com/instal…indows-server/a.
Set SQL Server to Mixed Mode Auth and give SA:U6SjJk3ZyQhrv5tqb.
1.
Install SSMS : https://aka.ms/ssmsfullsetup2.
Best is keep that File Structure:
D:AiON_SERVER1.
3.
Open SSMS and login with “sa” account, and in “Properties” of SQL Server in section “Advanced” change “Max Text Replication Size” to “65664” and restart SQL Server.4.
In SSMS restore from “AiON_SERVERSQLDATA” folder databases:
– AccountCacheD
– aion_log
– aionaccounts
– aionworld_110
– bkpetitiondb
– petitiondb
5.
run “ODBC Data Sources (64-bit)” and in section “File DSN” press folder icon on right side of “Look in:” and listen to “D:AiON_SERVERODBC”
remember – SQL connection parameters and other setting possible stores in registry sections “HKLMSOFTWARENC Soft” and “HKCUSOFTWARENC Soft”1.
6.
Open SQL Server Config Manager and enable tcp/ip, Named Pipes and Shared Memory
Set IP Address to 127.0.0.1 or LAN Address
i.
1.
7.
Go to “AiON_SERVER_SERVERChannelChattingServer”, edit “ChatServerList_Server.xml” then replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>), leave ports as is8.
Go to “AiON_SERVER_SERVERMainServer”, edit “common.xml” then replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>), leave ports as is9.
Go to “AiON_SERVER_SERVERMainServer”, edit “config.xml” then replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>), leave ports as is10.
Go to “AiON_SERVER_SERVERPetitionServer”, edit “AppConfigForServiceCode.xml” then replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>), leave ports as is11.
Go to “AiON_SERVER_SERVERPetitionServerDB”, edit “codec.txt” then replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>), leave ports as is12.
Go to “AiON_SERVER_SERVERPetitionServer”, edit “PetitionD_Integration.exe.config” then replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>),
and U must correcting string at line 16 – “<add key=”DatabaseConnString” value=” by copy in clipboard string between “”, then launch “AiON_SERVER_SERVERPetitionServerDBcodec.exe”,1.
and in section over “Decrypt” button paste copied data, then press “Decrypt” button, after thet select and copy to clippboard text from “Output” section,
and in section over “Encrypt” button paste copied data, replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>), then press “Decrypt” button, after thet select and copy to clippboard text from
“Output”,
and in file “AiON_SERVER_SERVERPetitionServerPetitionD_Integration.exe.config” at line 16 – “<add key=”DatabaseConnString” value=” paste from clipboard string by replace text between “”
13.
In SSMS open database “aionaccounts” and in table “dbo.server” change paramer “ip” to your’s server IP14.
In SSMS open database “aion_log” and in table “aiongm_ur.TBL_WORLD_SERVER_INFO” and table “dbo.TBL_WORLD_SERVER_INFO” change paramers in “SERVER_URL” by correctin password for DB connection
string it’s enought for start all servers include GM part
15.
IIS/GM Server Installation:
If U needed GM Web console, so install IIS with ASP .NET 4.x & .NET 4.7 or above1.
– Enable “HTTP Activation feature” for IIS
– In SSMS create in MS SQL User name “aiongm_ur” with password “aiongm_ur00” and give him full acces to “aion_log” DB if not have yet or edit file “d:AiON_SERVER_AION_WEBconfexternal_config.xml” and
replace connection string.
Aion 4.6 PTS SetupGuide
Mittwoch, 16. März 2022 21:52
Aion Seite 1
1.
Open IIS Manager and Rightclick “Sites” and “Add Website”
Site Name: AionGM1.
Pysical Path: D:AiON_SERVER_AION_WEB2.
2.
Add Alias to “AionGM” Website
Rightclick on AionGM > Add Application > Alias:1.
wldpatltmxpa
2.
3.
Bind Website to port 80 or desired port
1.
4.
For GMServer IIS has to work and “AionGM” Website to be correct:5.
Test connection: http://127.0.0.1/wldpatltmxpa/dkdldhswldpatltmxpa.aspx or correct IP/Host
1.
6.
Default GM: superuser admin8887.
USE 127.0.0.1 TO CONNECT, LOCALHOST OR ANY OTHER8.
Make GM Account:
https://forum.ragezone.com/f588/id-gm-aion-4-6-a-1198207/
How to make ID GM
1. Open database : aionaccounts and edit below.
2. Create a new charector that you want to be GM.(Remember name)
3. Run D:_aion_SERVERGMServerGMServer.exe
Aion Seite 2
Open IIS Manager and Rightclick “Sites” and “Add Website”
Site Name: AionGM1.
Pysical Path: D:AiON_SERVER_AION_WEB2.
2.
Add Alias to “AionGM” Website
Rightclick on AionGM > Add Application > Alias:1.
wldpatltmxpa
2.
3.
Bind Website to port 80 or desired port
1.
4.
For GMServer IIS has to work and “AionGM” Website to be correct:5.
Test connection: http://127.0.0.1/wldpatltmxpa/dkdldhswldpatltmxpa.aspx or correct IP/Host
1.
6.
Default GM: superuser admin8887.
USE 127.0.0.1 TO CONNECT, LOCALHOST OR ANY OTHER8.
Make GM Account:
https://forum.ragezone.com/f588/id-gm-aion-4-6-a-1198207/
How to make ID GM
1. Open database : aionaccounts and edit below.
2. Create a new charector that you want to be GM.(Remember name)
3. Run D:_aion_SERVERGMServerGMServer.exe
Aion Seite 2
4. Go to http://127.0.0.1/wldpatltmxpa/dkdldhswldpatltmxpa.aspx
5. Follow below.
6. Set “0” to “1”
Have fun !!!
**** Ingame GM panel = Shift +F1
Aion Seite 3
5. Follow below.
6. Set “0” to “1”
Have fun !!!
**** Ingame GM panel = Shift +F1
Aion Seite 3
Aus <https://forum.ragezone.com/f588/id-gm-aion-4-6-a-1198207/>
Start the Servers
1. “AiON_SERVER01.AccountCacheServer.lnk” to start “Account Cache Server”
– in first start it’s request SQL database connection parameters trought “SQL Login” window:
– “File DB” – default request “aion_accoutdb” .dsn-file U need post like “d:AiON_SERVERODBCAccountCacheD.dsn”
– “Login Name” – U need post “sa”
– “Password” – U need post “U6SjJk3ZyQhrv5tq”
Then press “OK” button
– wait till in log writes “* server ready on port” and port number set in “d:AiON_SERVER_SERVERAccountCacheServercommon.xml” config file
2. “AiON_SERVER 2.CAPTCHAImageServer.lnk” to start “CAPTCHA Image Server” – wait till in log writes “CAPTCHAImageServer started.”
3. “AiON_SERVER 3.ChannelChattingServer.lnk” to start “Channel Chatting Server” – wait till in log writes “A2GServer::NEW succeeded.”
4. “AiON_SERVER04.ICServer.lnk” to start “InterChange Server” – wait till in log writes “* main server ready on port” and “* cache server ready on port” and port numbers set in “AiON_SERVER_SERVERICServer
common.xml” config file
5. “AiON_SERVER 5.AuthServer.lnk” to start “Auth Server”
– We dont have Serial number (not nedded), click cancel
– on DSN Access insert these into the Fields:
– “File DB” – default request “L2Conn” .dsn-file U need post like “d:AiON_SERVERODBCAionAccounts.dsn”
– “Login Name” – U need post “sa”
́- “Password” – U need post “U6SjJk3ZyQhrv5tq”
– wait till in log writes “server ready on port”, “service ready on port”, and “interactive server ready on port” and “monitor server ready on port” and port numbers set in “AiON_SERVER_SERVERAuthServeretc
config.txt” config file
6. “AiON_SERVER 6.AuthGateServer.lnk” to start “Auth Gate Server” – wait till in log writes “AuthGateD Service Running…” and “*new authd connection from” and IP “Auth Server”
7. “AiON_SERVER 7.CacheServer.lnk” to start “Cache Server”
7.1 “AiON_SERVER08.1.ShopAgentServer.ink” to start “Shop Server”
– you have to add a new Database to the SQL Server named “SADB”
8. “AiON_SERVER 8.NPCServer.lnk” to start “NPC Server” – wait till in log writes “message: SERVER DATA LOAD COMPLETED IN”, “Connected to DB” and repeating message “warning: failed to make connection. code=
10061” – it’s says about “NPC Server loaded needed data and wait connection from Main server”
9. “AiON_SERVER 9.MainServer.lnk” to start “Main Server”
– wait till in log writes “Connected to AuthServer: Auth server at”
– and check in “Auth Server” log mesage “*new world server connection from”
10. “AiON_SERVER10.LogServer.lnk” to start “Log Server”, but it not work with Euro country code(2)
If U needed “Log Server” run – Switch Regional settings in system for “non-Unicode programs” into CP 936(“Chinese(Simplefied, China)”) and modify string “<country>2</country>”(EUR) to “<country>5</country>”
(Chinese) in .xml files of setttings and U needed Chinese AiON Client
1.
11. “Petition Server” no need to work
12. .XML-files have more errors, if U need U can fix it by read logs of “NPC Server” and “Main Server”
13 “AiON_SERVER11.GMServer.lnk” to start GMServer
14: “AiON_SERVER12.GMShop.lnk” to start GMShop
GM WebAccess:
Default GM: superuser Admin8888.
http://127.0.0.1/wldpatltmxpa/dkdldhswldpatltmxpa.aspx or correct IP/Host
You can add “alias” like “aion-webgm” to IIS Site “AionGM”, same as with alias: wldpatltmxpa1.
9.
Make sure to user Aion Client 4.6 in CC=2
IP Change:
External:
D:AiON_SERVER_SERVERPetitionServerPetitionD_Integration.exe.config + Codec
D:AiON_SERVER_SERVERPetitionServerDBcodec.txt
D:AiON_SERVER_SERVERPetitionServerAppConfigForServiceCode.xml
D:AiON_SERVER_SERVERGMServerGM_SERVER.txt
D:AiON_SERVER_SERVERChannelChattingServerChatServerList_Server.xml
D:AiON_SERVER_SERVERMainServerconfig.xml
D:AiON_SERVER_SERVERMainServercommon.xml
DB>AionAccounts>dbo.server
They are set to 127.0.0.1
DB>aion_log>aiongm_ur.TBL_WORLD_SERVER_INFO
DB>aion_log>dbo.TBL_WORLD_SERVER_INFO
Ports need to be open:
Register Account:
Aion Seite 4
Start the Servers
1. “AiON_SERVER01.AccountCacheServer.lnk” to start “Account Cache Server”
– in first start it’s request SQL database connection parameters trought “SQL Login” window:
– “File DB” – default request “aion_accoutdb” .dsn-file U need post like “d:AiON_SERVERODBCAccountCacheD.dsn”
– “Login Name” – U need post “sa”
– “Password” – U need post “U6SjJk3ZyQhrv5tq”
Then press “OK” button
– wait till in log writes “* server ready on port” and port number set in “d:AiON_SERVER_SERVERAccountCacheServercommon.xml” config file
2. “AiON_SERVER 2.CAPTCHAImageServer.lnk” to start “CAPTCHA Image Server” – wait till in log writes “CAPTCHAImageServer started.”
3. “AiON_SERVER 3.ChannelChattingServer.lnk” to start “Channel Chatting Server” – wait till in log writes “A2GServer::NEW succeeded.”
4. “AiON_SERVER04.ICServer.lnk” to start “InterChange Server” – wait till in log writes “* main server ready on port” and “* cache server ready on port” and port numbers set in “AiON_SERVER_SERVERICServer
common.xml” config file
5. “AiON_SERVER 5.AuthServer.lnk” to start “Auth Server”
– We dont have Serial number (not nedded), click cancel
– on DSN Access insert these into the Fields:
– “File DB” – default request “L2Conn” .dsn-file U need post like “d:AiON_SERVERODBCAionAccounts.dsn”
– “Login Name” – U need post “sa”
́- “Password” – U need post “U6SjJk3ZyQhrv5tq”
– wait till in log writes “server ready on port”, “service ready on port”, and “interactive server ready on port” and “monitor server ready on port” and port numbers set in “AiON_SERVER_SERVERAuthServeretc
config.txt” config file
6. “AiON_SERVER 6.AuthGateServer.lnk” to start “Auth Gate Server” – wait till in log writes “AuthGateD Service Running…” and “*new authd connection from” and IP “Auth Server”
7. “AiON_SERVER 7.CacheServer.lnk” to start “Cache Server”
7.1 “AiON_SERVER08.1.ShopAgentServer.ink” to start “Shop Server”
– you have to add a new Database to the SQL Server named “SADB”
8. “AiON_SERVER 8.NPCServer.lnk” to start “NPC Server” – wait till in log writes “message: SERVER DATA LOAD COMPLETED IN”, “Connected to DB” and repeating message “warning: failed to make connection. code=
10061” – it’s says about “NPC Server loaded needed data and wait connection from Main server”
9. “AiON_SERVER 9.MainServer.lnk” to start “Main Server”
– wait till in log writes “Connected to AuthServer: Auth server at”
– and check in “Auth Server” log mesage “*new world server connection from”
10. “AiON_SERVER10.LogServer.lnk” to start “Log Server”, but it not work with Euro country code(2)
If U needed “Log Server” run – Switch Regional settings in system for “non-Unicode programs” into CP 936(“Chinese(Simplefied, China)”) and modify string “<country>2</country>”(EUR) to “<country>5</country>”
(Chinese) in .xml files of setttings and U needed Chinese AiON Client
1.
11. “Petition Server” no need to work
12. .XML-files have more errors, if U need U can fix it by read logs of “NPC Server” and “Main Server”
13 “AiON_SERVER11.GMServer.lnk” to start GMServer
14: “AiON_SERVER12.GMShop.lnk” to start GMShop
GM WebAccess:
Default GM: superuser Admin8888.
http://127.0.0.1/wldpatltmxpa/dkdldhswldpatltmxpa.aspx or correct IP/Host
You can add “alias” like “aion-webgm” to IIS Site “AionGM”, same as with alias: wldpatltmxpa1.
9.
Make sure to user Aion Client 4.6 in CC=2
IP Change:
External:
D:AiON_SERVER_SERVERPetitionServerPetitionD_Integration.exe.config + Codec
D:AiON_SERVER_SERVERPetitionServerDBcodec.txt
D:AiON_SERVER_SERVERPetitionServerAppConfigForServiceCode.xml
D:AiON_SERVER_SERVERGMServerGM_SERVER.txt
D:AiON_SERVER_SERVERChannelChattingServerChatServerList_Server.xml
D:AiON_SERVER_SERVERMainServerconfig.xml
D:AiON_SERVER_SERVERMainServercommon.xml
DB>AionAccounts>dbo.server
They are set to 127.0.0.1
DB>aion_log>aiongm_ur.TBL_WORLD_SERVER_INFO
DB>aion_log>dbo.TBL_WORLD_SERVER_INFO
Ports need to be open:
Register Account:
Aion Seite 4
Register Account:
Start: D:AiON_SERVER_SERVERAccountCacheServerRegisterAccount.exe
Auto Account Creation is “ON” by default (Create account while login with Client)
Server Automatic Account Creation
Disable:
I have only a question: Where can I disable the automatic account creation? When I try to login with a not registered account, the server does not pop any error, it creates the account instead. How can I disable
that?
To disable the automatic account creation, you must change your ap_GPwdWithFlag at AionAccounts database to the following:
Code:
ALTER PROCEDURE [dbo].[ap_GPwdWithFlag] @account varchar(14)
, @PWD binary(16) output
, @flag tinyint output
—, @otpflag tinyint = 0 output
AS
SELECT @PWD=password
, @flag=new_pwd_flag
— , @otpflag = otp_flag
FROM user_auth with (nolock)
WHERE account @account
Aus <https://forum.ragezone.com/f588/id-gm-aion-4-6-a-1198207/#post9083631>
Enable:
ALTER PROCEDURE [dbo].[ap_GPwdWithFlag]
@account varchar(14)
, @pwd binary(16) output
, @flag tinyint output
–, @otpflag tinyint = 0 output
AS
if(not exists(select account from user_auth where account=@account)) begin
if(@account not like ‘%[^a-zA-Z0-9]%’) begin
SELECT @pwd=0x00000000000000000000000000000000, @flag=3
exec ap_AutoReg @account
end
end else begin
SELECT @pwd=password
, @flag=new_pwd_flag
— , @otpflag = otp_flag
FROM user_auth with (nolock)
WHERE account=@account
End
Shop Agent Server
Create New Database named “SADB”1.
Lock/Unlock Classes:
Go to AION_LIVE_MAP/map.45039/XML/ and edit file “Createchainfo.xml” then uncomment it.
Aus <https://forum.ragezone.com/f587/aion-4-6-retail-server-1197401/index4.html>
Change Rates:
For exp you can change that by editing the file: …_AIONServerMainServercommon.xml.
There you will find these lines:
Aus <https://forum.ragezone.com/f587/aion-4-6-retail-server-1197401/index4.html>
Change Drop:
D:AiON_SERVER_SERVERNPCServercommon.xml
FIX Instance Server:
Use Server64.exe from this pack and replace it with yours: (from AionBrasil) full Source
https://onedrive.live.com/?cid=7d5ee7a159572096&id=7D5EE7A159572096%21185509&authkey=%21AANmoLUTIPc3hHI
Server64.exe only: https://drive.google.com/file/d/1eCKBYPa1-ysHkCM8eXJszyII8lMXFgDs/view
ORGINAL SETUP CONTEXT:
Prepare:
1. Windows Server 2012R2
3. SQL Server 2017 (no express) and SSMS or above
4. Complementary tools (Notepad ++, 7zip, VC, .NET Framework 3.5, HeidiSQL, etc)
Disclimer:
Don’t change paths or/and passwords without understanding how it works or you catch some gliches and troubles in work
Correction:
1. If U needed GM Web console, so install IIS with ASP .NET 4.x & .NET 4.7 or above
– Enable “HTTP Activation feature” for IIS
– In SSMS create in MS SQL User name “aiongm_ur” with password “aiongm_ur00” and give him full acces to “aion_log” DB if not have yet or edit file “d:AiON_SERVER_AION_WEBconfexternal_config.xml” and
replace connection string.
2. If U needed “Log Server” run – Switch Regional settings in system for “non–Unicode programs” into CP 936(“Chinese(Simplefied, China)”) and modify string “<country>2</country>”(EUR) to “<country>5</country>”
(Chinese) in .xml files of setttings and U needed Chinese AiON Client
3. Unpack “AiON_SERVER.rar” archive to a root folder in drive you select for use “C:”, “D:” or other(by default in configs figured “D:”)
4. Switch SQL Server into mixed mode and set “sa” password as “U6SjJk3ZyQhrv5tq”
5. Open SSMS and login with “sa” account, and in “Properties” of SQL Server in section “Advanced” change “Max Text Replication Size” to “65664” and restart SQL Server.
6. In SSMS restore from “AiON_SERVERSQLDATA” folder databases:
– AccountCacheD
– aion_log
– aionaccounts
– aionworld_110
– bkpetitiondb
– petitiondb
7. check path in .ini, .xml and .txt files it must include “AiON_SERVER”
Aion Seite 5
Start: D:AiON_SERVER_SERVERAccountCacheServerRegisterAccount.exe
Auto Account Creation is “ON” by default (Create account while login with Client)
Server Automatic Account Creation
Disable:
I have only a question: Where can I disable the automatic account creation? When I try to login with a not registered account, the server does not pop any error, it creates the account instead. How can I disable
that?
To disable the automatic account creation, you must change your ap_GPwdWithFlag at AionAccounts database to the following:
Code:
ALTER PROCEDURE [dbo].[ap_GPwdWithFlag] @account varchar(14)
, @PWD binary(16) output
, @flag tinyint output
—, @otpflag tinyint = 0 output
AS
SELECT @PWD=password
, @flag=new_pwd_flag
— , @otpflag = otp_flag
FROM user_auth with (nolock)
WHERE account @account
Aus <https://forum.ragezone.com/f588/id-gm-aion-4-6-a-1198207/#post9083631>
Enable:
ALTER PROCEDURE [dbo].[ap_GPwdWithFlag]
@account varchar(14)
, @pwd binary(16) output
, @flag tinyint output
–, @otpflag tinyint = 0 output
AS
if(not exists(select account from user_auth where account=@account)) begin
if(@account not like ‘%[^a-zA-Z0-9]%’) begin
SELECT @pwd=0x00000000000000000000000000000000, @flag=3
exec ap_AutoReg @account
end
end else begin
SELECT @pwd=password
, @flag=new_pwd_flag
— , @otpflag = otp_flag
FROM user_auth with (nolock)
WHERE account=@account
End
Shop Agent Server
Create New Database named “SADB”1.
Lock/Unlock Classes:
Go to AION_LIVE_MAP/map.45039/XML/ and edit file “Createchainfo.xml” then uncomment it.
Aus <https://forum.ragezone.com/f587/aion-4-6-retail-server-1197401/index4.html>
Change Rates:
For exp you can change that by editing the file: …_AIONServerMainServercommon.xml.
There you will find these lines:
Aus <https://forum.ragezone.com/f587/aion-4-6-retail-server-1197401/index4.html>
Change Drop:
D:AiON_SERVER_SERVERNPCServercommon.xml
FIX Instance Server:
Use Server64.exe from this pack and replace it with yours: (from AionBrasil) full Source
https://onedrive.live.com/?cid=7d5ee7a159572096&id=7D5EE7A159572096%21185509&authkey=%21AANmoLUTIPc3hHI
Server64.exe only: https://drive.google.com/file/d/1eCKBYPa1-ysHkCM8eXJszyII8lMXFgDs/view
ORGINAL SETUP CONTEXT:
Prepare:
1. Windows Server 2012R2
3. SQL Server 2017 (no express) and SSMS or above
4. Complementary tools (Notepad ++, 7zip, VC, .NET Framework 3.5, HeidiSQL, etc)
Disclimer:
Don’t change paths or/and passwords without understanding how it works or you catch some gliches and troubles in work
Correction:
1. If U needed GM Web console, so install IIS with ASP .NET 4.x & .NET 4.7 or above
– Enable “HTTP Activation feature” for IIS
– In SSMS create in MS SQL User name “aiongm_ur” with password “aiongm_ur00” and give him full acces to “aion_log” DB if not have yet or edit file “d:AiON_SERVER_AION_WEBconfexternal_config.xml” and
replace connection string.
2. If U needed “Log Server” run – Switch Regional settings in system for “non–Unicode programs” into CP 936(“Chinese(Simplefied, China)”) and modify string “<country>2</country>”(EUR) to “<country>5</country>”
(Chinese) in .xml files of setttings and U needed Chinese AiON Client
3. Unpack “AiON_SERVER.rar” archive to a root folder in drive you select for use “C:”, “D:” or other(by default in configs figured “D:”)
4. Switch SQL Server into mixed mode and set “sa” password as “U6SjJk3ZyQhrv5tq”
5. Open SSMS and login with “sa” account, and in “Properties” of SQL Server in section “Advanced” change “Max Text Replication Size” to “65664” and restart SQL Server.
6. In SSMS restore from “AiON_SERVERSQLDATA” folder databases:
– AccountCacheD
– aion_log
– aionaccounts
– aionworld_110
– bkpetitiondb
– petitiondb
7. check path in .ini, .xml and .txt files it must include “AiON_SERVER”
Aion Seite 5
7. check path in .ini, .xml and .txt files it must include “AiON_SERVER”
8. run “ODBC Data Sources (64-bit)” and in section “File DSN” press folder icon on right side of “Look in:” and listen to “D:AiON_SERVERODBC”
9. remember – SQL connection parameters and other setting possible stores in registry sections “HKLMSOFTWARENC Soft” and “HKCUSOFTWARENC Soft”
10. Go to “AiON_SERVER_SERVERChannelChattingServer”, edit “ChatServerList_Server.xml” then replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>), leave ports as is
11. Go to “AiON_SERVER_SERVERMainServer”, edit “common.xml” then replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>), leave ports as is
12. Go to “AiON_SERVER_SERVERMainServer”, edit “config.xml” then replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>), leave ports as is
13. Go to “AiON_SERVER_SERVERPetitionServer”, edit “AppConfigForServiceCode.xml” then replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>), leave ports as is
14. Go to “AiON_SERVER_SERVERPetitionServerDB”, edit “codec.txt” then replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>), leave ports as is
15. Go to “AiON_SERVER_SERVERPetitionServer”, edit “PetitionD_Integration.exe.config” then replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>),
and U must correcting string at line 16 – “<add key=”DatabaseConnString” value=” by copy in clipboard string between “”, then launch “AiON_SERVER_SERVERPetitionServerDBcodec.exe”,
and in section over “Decrypt” button paste copied data, then press “Decrypt” button, after thet select and copy to clippboard text from “Output” section,
and in section over “Encrypt” button paste copied data, replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>), then press “Decrypt” button, after thet select and copy to clippboard text from “Output”,
and in file “AiON_SERVER_SERVERPetitionServerPetitionD_Integration.exe.config” at line 16 – “<add key=”DatabaseConnString” value=” paste from clipboard string by replace text between “”
16. In SSMS open database “aionaccounts” and in table “dbo.server” change paramer “ip” to your’s server IP
17. In SSMS open database “aion_log” and in table “aiongm_ur.TBL_WORLD_SERVER_INFO” and table “dbo.TBL_WORLD_SERVER_INFO” change paramers in “SERVER_URL” by correctin password for DB connection string
it’s enought for start all servers include GM part
18. If U plane use GM options U need launch “IIS Manager” and in it in section “Sites” disable/stop “Default Web Site”
19. In “Application pools” add application pool “AionGM” with parameters:
– “Application pool” set as “AionGM”
– “.NET CLR version” set as “.NET CLR version v4.0.30319”
– all other settings keep by default
20. In “Sites” add website “AionGM” with parameters:
– “Site name” set as “AionGM”
– “Application pool” set as “AionGM” by choose in list
– “Physical path” set as “D:AiON_SERVER_AION_WEB”
– all other settings keep by default
Start the servers for playing and questing
1. “AiON_SERVER 1.AccountCacheServer.lnk” to start “Account Cache Server”
– in first start it’s request SQL database connection parameters trought “SQL Login” window:
– “File DB” – default request “aion_accoutdb” .dsn–file U need post like “d:AiON_SERVERODBCAccountCacheD.dsn”
– “Login Name” – U need post “sa”
– “Password” – U need post “U6SjJk3ZyQhrv5tq”
Then press “OK” button
– wait till in log writes “* server ready on port” and port number set in “d:AiON_SERVER_SERVERAccountCacheServercommon.xml” config file
2. “AiON_SERVER 2.CAPTCHAImageServer.lnk” to start “CAPTCHA Image Server” – wait till in log writes “CAPTCHAImageServer started.”
3. “AiON_SERVER03.ChannelChattingServer.lnk” to start “Channel Chatting Server” – wait till in log writes “A2GServer::NEW succeeded.”
4. “AiON_SERVER 4.ICServer.lnk” to start “InterChange Server” – wait till in log writes “* main server ready on port” and “* cache server ready on port” and port numbers set in “AiON_SERVER_SERVERICServer
common.xml” config file
5. “AiON_SERVER05.AuthServer.lnk” to start “Auth Server”
– when start it’s post “Error” window with message “Registry dosen’t have valid serial number” to continue just click “OK” button
– wait till in log writes “server ready on port”, “service ready on port”, and “interactive server ready on port” and “monitor server ready on port” and port numbers set in “AiON_SERVER_SERVERAuthServeretc
config.txt” config file
6. “AiON_SERVER 6.AuthGateServer.lnk” to start “Auth Gate Server” – wait till in log writes “AuthGateD Service Running…” and “*new authd connection from” and IP “Auth Server”
7. “AiON_SERVER 7.CacheServer.lnk” to start “Cache Server”
– in first start it’s request SQL database connection parameters trought “SQL Login” window:
– “File DB” – default request “aionworld_new” .dsn-file U need post like “d:AiON_SERVERODBCAionWorld_110.dsn”
– “Login Name” – U need post “sa”
– “Password” – U need post “U6SjJk3ZyQhrv5tq”
Then press “OK” button
– wait till in log writes “*interactive socked ready on port” twice and “*cache server ready on port” and port number set in “d:AiON_SERVER_SERVERCacheServercommon.xml” config file
8. “AiON_SERVER08.NPCServer.lnk” to start “NPC Server” – wait till in log writes “message: SERVER DATA LOAD COMPLETED IN”, “Connected to DB” and repeating message “warning: failed to make connection. code=
10061” – it’s says about “NPC Server loaded needed data and wait connection from Main server”
9. “AiON_SERVER 9.MainServer.lnk” to start “Main Server”
– wait till in log writes “Connected to AuthServer: Auth server at”
– and check in “Auth Server” log mesage “*new world server connection from”
10. “AiON_SERVER10.LogServer.lnk” to start “Log Server”, but it not work with Euro country code(2)
11. “Petition Server” no need to work
12. .XML-files have more errors, if U need U can fix it by read logs of “NPC Server” and “Main Server”
Start the GMServers for administrating and ruling
1. In SSMS open database “aionaccounts” and in table “dbo.user_account” change paramer “login_flag” to “16” for user who will GameMaster
2. Create a new charector that you want to be GM.(Remember name)
2. before start GMServer be sure thet IIS is started and web server “AionGM” to, for test launch in broser url “http://127.0.0.1/wldpatltmxpa/dkdldhswldpatltmxpa.aspx” and U must seen welcome and logon dialogue
3. Launch “AiON_SERVER11.GMServer.lnk” to start “GM Server” it’s requares IIS with .NET 4.7
4. “AiON_SERVER12.GMShop.lnk” to start “GM Shop Server” it’s requares IIS with .NET 4.7
5. after starting GMs in “http://127.0.0.1/wldpatltmxpa/dkdldhswldpatltmxpa.aspx” use Login:“superuser” add Password:“admin888” it’s presets for intering into GM webpanel
6.
“”
This is minimad modding of leaked archives and it’s work
Thanks to @TieLay @sthaporn12 @gondracorn and many more, that i forgot to add…
Aion Seite 6
8. run “ODBC Data Sources (64-bit)” and in section “File DSN” press folder icon on right side of “Look in:” and listen to “D:AiON_SERVERODBC”
9. remember – SQL connection parameters and other setting possible stores in registry sections “HKLMSOFTWARENC Soft” and “HKCUSOFTWARENC Soft”
10. Go to “AiON_SERVER_SERVERChannelChattingServer”, edit “ChatServerList_Server.xml” then replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>), leave ports as is
11. Go to “AiON_SERVER_SERVERMainServer”, edit “common.xml” then replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>), leave ports as is
12. Go to “AiON_SERVER_SERVERMainServer”, edit “config.xml” then replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>), leave ports as is
13. Go to “AiON_SERVER_SERVERPetitionServer”, edit “AppConfigForServiceCode.xml” then replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>), leave ports as is
14. Go to “AiON_SERVER_SERVERPetitionServerDB”, edit “codec.txt” then replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>), leave ports as is
15. Go to “AiON_SERVER_SERVERPetitionServer”, edit “PetitionD_Integration.exe.config” then replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>),
and U must correcting string at line 16 – “<add key=”DatabaseConnString” value=” by copy in clipboard string between “”, then launch “AiON_SERVER_SERVERPetitionServerDBcodec.exe”,
and in section over “Decrypt” button paste copied data, then press “Decrypt” button, after thet select and copy to clippboard text from “Output” section,
and in section over “Encrypt” button paste copied data, replace the IP “172.16.200.119” by your’s server IP(<SERVERIP>), then press “Decrypt” button, after thet select and copy to clippboard text from “Output”,
and in file “AiON_SERVER_SERVERPetitionServerPetitionD_Integration.exe.config” at line 16 – “<add key=”DatabaseConnString” value=” paste from clipboard string by replace text between “”
16. In SSMS open database “aionaccounts” and in table “dbo.server” change paramer “ip” to your’s server IP
17. In SSMS open database “aion_log” and in table “aiongm_ur.TBL_WORLD_SERVER_INFO” and table “dbo.TBL_WORLD_SERVER_INFO” change paramers in “SERVER_URL” by correctin password for DB connection string
it’s enought for start all servers include GM part
18. If U plane use GM options U need launch “IIS Manager” and in it in section “Sites” disable/stop “Default Web Site”
19. In “Application pools” add application pool “AionGM” with parameters:
– “Application pool” set as “AionGM”
– “.NET CLR version” set as “.NET CLR version v4.0.30319”
– all other settings keep by default
20. In “Sites” add website “AionGM” with parameters:
– “Site name” set as “AionGM”
– “Application pool” set as “AionGM” by choose in list
– “Physical path” set as “D:AiON_SERVER_AION_WEB”
– all other settings keep by default
Start the servers for playing and questing
1. “AiON_SERVER 1.AccountCacheServer.lnk” to start “Account Cache Server”
– in first start it’s request SQL database connection parameters trought “SQL Login” window:
– “File DB” – default request “aion_accoutdb” .dsn–file U need post like “d:AiON_SERVERODBCAccountCacheD.dsn”
– “Login Name” – U need post “sa”
– “Password” – U need post “U6SjJk3ZyQhrv5tq”
Then press “OK” button
– wait till in log writes “* server ready on port” and port number set in “d:AiON_SERVER_SERVERAccountCacheServercommon.xml” config file
2. “AiON_SERVER 2.CAPTCHAImageServer.lnk” to start “CAPTCHA Image Server” – wait till in log writes “CAPTCHAImageServer started.”
3. “AiON_SERVER03.ChannelChattingServer.lnk” to start “Channel Chatting Server” – wait till in log writes “A2GServer::NEW succeeded.”
4. “AiON_SERVER 4.ICServer.lnk” to start “InterChange Server” – wait till in log writes “* main server ready on port” and “* cache server ready on port” and port numbers set in “AiON_SERVER_SERVERICServer
common.xml” config file
5. “AiON_SERVER05.AuthServer.lnk” to start “Auth Server”
– when start it’s post “Error” window with message “Registry dosen’t have valid serial number” to continue just click “OK” button
– wait till in log writes “server ready on port”, “service ready on port”, and “interactive server ready on port” and “monitor server ready on port” and port numbers set in “AiON_SERVER_SERVERAuthServeretc
config.txt” config file
6. “AiON_SERVER 6.AuthGateServer.lnk” to start “Auth Gate Server” – wait till in log writes “AuthGateD Service Running…” and “*new authd connection from” and IP “Auth Server”
7. “AiON_SERVER 7.CacheServer.lnk” to start “Cache Server”
– in first start it’s request SQL database connection parameters trought “SQL Login” window:
– “File DB” – default request “aionworld_new” .dsn-file U need post like “d:AiON_SERVERODBCAionWorld_110.dsn”
– “Login Name” – U need post “sa”
– “Password” – U need post “U6SjJk3ZyQhrv5tq”
Then press “OK” button
– wait till in log writes “*interactive socked ready on port” twice and “*cache server ready on port” and port number set in “d:AiON_SERVER_SERVERCacheServercommon.xml” config file
8. “AiON_SERVER08.NPCServer.lnk” to start “NPC Server” – wait till in log writes “message: SERVER DATA LOAD COMPLETED IN”, “Connected to DB” and repeating message “warning: failed to make connection. code=
10061” – it’s says about “NPC Server loaded needed data and wait connection from Main server”
9. “AiON_SERVER 9.MainServer.lnk” to start “Main Server”
– wait till in log writes “Connected to AuthServer: Auth server at”
– and check in “Auth Server” log mesage “*new world server connection from”
10. “AiON_SERVER10.LogServer.lnk” to start “Log Server”, but it not work with Euro country code(2)
11. “Petition Server” no need to work
12. .XML-files have more errors, if U need U can fix it by read logs of “NPC Server” and “Main Server”
Start the GMServers for administrating and ruling
1. In SSMS open database “aionaccounts” and in table “dbo.user_account” change paramer “login_flag” to “16” for user who will GameMaster
2. Create a new charector that you want to be GM.(Remember name)
2. before start GMServer be sure thet IIS is started and web server “AionGM” to, for test launch in broser url “http://127.0.0.1/wldpatltmxpa/dkdldhswldpatltmxpa.aspx” and U must seen welcome and logon dialogue
3. Launch “AiON_SERVER11.GMServer.lnk” to start “GM Server” it’s requares IIS with .NET 4.7
4. “AiON_SERVER12.GMShop.lnk” to start “GM Shop Server” it’s requares IIS with .NET 4.7
5. after starting GMs in “http://127.0.0.1/wldpatltmxpa/dkdldhswldpatltmxpa.aspx” use Login:“superuser” add Password:“admin888” it’s presets for intering into GM webpanel
6.
“”
This is minimad modding of leaked archives and it’s work
Thanks to @TieLay @sthaporn12 @gondracorn and many more, that i forgot to add…
Aion Seite 6
声明：本站所有文章，如无特殊说明或标注，均为本站原创发布。任何个人或组织，在未征得本站同意时，禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益，可联系我们进行处理。
