AION 4.6 retail server file (Re-post)

[I_Satelite_I]

So me get MS SQL 2017 backups of AiON 4.6 PTS databases, partially clean and with worked aion_log for GM
It's in one archive SQLDATA.RAR in folder "Server 4.6" at

You must be registered to see links

So worked, but me catch error 20, when try login into game, more info in THIS tread
P.S. MS SQL backup of database makes not me from SQL SERVER 2019

some accounts i tried to login get this system error 20 for some reason, i had to create new accounts and it worked, but sometimes those new accounts will get error 20.

 

[sthaporn12]

So me get MS SQL 2017 backups of AiON 4.6 PTS databases, partially clean and with worked aion_log for GM
It's in one archive SQLDATA.RAR in folder "Server 4.6" at

You must be registered to see links

So worked, but me catch error 20, when try login into game, more info in THIS tread
P.S. MS SQL backup of database makes not me from SQL SERVER 2019

try this :

You must be registered to see links

 

[TieLay]

try this :

You must be registered to see links

"AuthD.exe" Unworked from link. or need some manipulations with registry and regional settings?

 

[gondracorn]

Why is my aionaccounts not active/running properly? When I used akiix's jetweb, it would not connect to Aion Accounts. Ever since, I think I uninstalled something because I needed 127.0.0.1 for something else, and now, I can't figure out what I uninstalledt

Also, what program is this your using to edit this?

EDIT 2: Ok, the exact program he was using was navicat premium.

I also have this error:

[h=1]Server Error in '/' Application.

---

[/h][h=2]Could not find a part of the path 'D:\_aion\_AION_WEB\conf\world'.[/h]Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.DirectoryNotFoundException: Could not find a part of the path 'D:\_aion\_AION_WEB\conf\world'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[DirectoryNotFoundException: Could not find a part of the path 'D:\_aion\_AION_WEB\conf\world'.] gmbiz.da.TblWorldServerInfoDA.SrchAllServerAddress() in G:\Work\Aion\_RESTORED\Common\gmbiz\da\TblWorldServerInfoDA.cs:103 gmbiz.da.TblWorldServerInfoDA.SetLoadingAllServerAddress() in G:\Work\Aion\_RESTORED\Common\gmbiz\da\TblWorldServerInfoDA.cs:26 gm.common.CommonBiz.ConfLoader() +49 AionGM.Global.Application_Start(Object sender, EventArgs e) +232 [HttpException (0x80004005): Could not find a part of the path 'D:\_aion\_AION_WEB\conf\world'.] System.Web.HttpApplicationFactory.EnsureAppStartCalledForIntegratedMode(HttpContext context, HttpApplication app) +546 System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +171 System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +173 System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +255 System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +347 [HttpException (0x80004005): Could not find a part of the path 'D:\_aion\_AION_WEB\conf\world'.] System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +552 System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +122 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +737

What does this mean?

 

[gondracorn]

CPerfmon::Init () Fail. m_nCheckPerfMon == 0

Is this a normal error message?



Can I/is it possible to run this on Windows 10 Pro with SQL Server 2019

 

[cinus]

CPerfmon::Init () Fail. m_nCheckPerfMon == 0

Is this a normal error message?



Can I/is it possible to run this on Windows 10 Pro with SQL Server 2019

Only sql server 2017 ! . Windows 10 its ok.

 

[gondracorn]

Then I'll need sql server 2017, as I don't have. Where can I get this for free? Also, CPerfmon init fail. Is that just a normal error?



I keep trying to post my problem today, but I have a cold or something and my computer is not responding (cursor jitters, due to website, only happens when on this website). the back button is problematic as well, as I keep exiting out of the friggin reply post, it's driving me insane.

I will thus make my post simple and short.

I need a full video tutorial.

That's it! No beating around the bush, no extra explaining involved. I just need a video tutorial because I'm a visual, not textual, learner.

 

[cinus]

Then I'll need sql server 2017, as I don't have. Where can I get this for free? Also, CPerfmon init fail. Is that just a normal error?



I keep trying to post my problem today, but I have a cold or something and my computer is not responding (cursor jitters, due to website, only happens when on this website). the back button is problematic as well, as I keep exiting out of the friggin reply post, it's driving me insane.

I will thus make my post simple and short.

I need a full video tutorial.

That's it! No beating around the bush, no extra explaining involved. I just need a video tutorial because I'm a visual, not textual, learner.

Tutorial here

You must be registered to see links

Credits to TidalPoo for upload but for make this tut to Xren

 

[gondracorn]

Is there a way to blow up the configuration on my old config directory? Everything's located under Q:/Downloads/Aion_Server/_aion, and I need to relocate to D:/_aion.

However, I know that just moving the folders won't be enough, I will have to repoint everything to that folder. So, this means the ODBC, the Microsoft SQL Server 2019/2017 (If I can even find 2017 still), and the IIS webpage thing.

What else do I need to destroy to reinstall?

Also, do I need SQL Server 2017 Express, Developer, Standard, or Enterprise?

 

[gondracorn]

Anyone know the translation for the select boxes for Microsoft SQL Server 2017 MSSQLSERVER creation?

Sorry, best quality I can get these images, due to poor forum design. Anyway, setting up an entirely new server, do I need to direct my shared folders to E:\\ directory, or is my installation path good on the Q:\ directory for MSSQLSERVER01, Shared Folders, and Xtra Folders?

Also, note that I cannot change the 2nd and 3rd directory options, as seen and marked in the first image like the guy did in the tutorial. I cannot understand what he's saying nor read chinese.

 

[TieLay]

DB's folder place no matter if MSSQL Server account can get full access into it and enough free space for DB grow.
coz SERVER works with DB by name, not by path

 

[gondracorn]

See in the following image that he names Aion_gm_2014... backup as aion_log. I don't understand why he did this when we already have a log backup! He didn't even use the log_backup.




Also, where did he get the file sadb?




Seen there, he has the file, but as seen here:




I am missing the file.

Not sure, but I might've also got the files from yandex, like Tielay. :/

 

[gondracorn]

Do I need the sadb file to do this? If so, does anyone have this file? Waiting for an answer to continue with setup... Sorry for all the questions, I'm a slow learner and it appears that the file structure, language, and whatnot are different than what I have...

 

[SirThomasLipton]

Do I need the sadb file to do this? If so, does anyone have this file? Waiting for an answer to continue with setup... Sorry for all the questions, I'm a slow learner and it appears that the file structure, language, and whatnot are different than what I have...

SADB stands for “Shop Agent DB”, you do not need if you are setting up a server for fun purposes. Basically, you require only 4 databases (AccountCacheD, aionaccounts, aionworld_110 and aion_log(or aion_gm) for gm server)

 

[gondracorn]

Yet again, ran into another problem. My SQL server syntax is different from the tutorial's, and my script changes do NOT match what's in the tables. My tables is from "tmp@kamael.ru", apparently, an RU server, while the script links to "xrenorg@aionchs.com". What do I do with this?

 

[gondracorn]

Umm, hey, I think the server's successfully up and running, but I can't log into an account, I can only log into EuroAion's servers with my EuroAion client.

Tell me what I need to change to make logging into my own server possible?


Whoops, spoke too soon. Cannot access AionServer's Webpage. Thrown this error. Can't understand what it's trying to tell me.

Can't change or add users on the server without it.

[h=1]Server Error in '/wldpatltmxpa' Application.

---

[/h][h=2]Could not find stored procedure 'TblAdminUserDA_SrchByLoginID'.[/h]Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'TblAdminUserDA_SrchByLoginID'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Could not find stored procedure 'TblAdminUserDA_SrchByLoginID'.] gmbiz.da.TblAdminUserDA.SrchByLoginID(String& login_id) in G:\Work\Aion\_RESTORED\Common\gmbiz\da\TblAdminUserDA.cs:112 gm.dkdldhswldpatltmxpa.TryToLogin(String login_id, String login_pw) +103 gm.dkdldhswldpatltmxpa.TryToLogin() +274 gm.dkdldhswldpatltmxpa.OnClickLogin(Object sender, EventArgs e) +85 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +11595936 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +274 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1890

 

[TieLay]

U need correct DB for this...

 

[gondracorn]

U need correct DB for this...

So, by db, you mean the database...

I am currently using Microsoft SQL Server 2019 to utilize an older database. Which database is working atm?

 

[SirThomasLipton]

So, by db, you mean the database...

I am currently using Microsoft SQL Server 2019 to utilize an older database. Which database is working atm?

The server works perfectly with SQL 2019. Your only problem is that you cannot connect correctly your server to the database. Please check your connections to the database and remember that Gm server and Innova admin connection needs to be encrypted in .bin files (gm.bin, egm.bin and world .bins. You can find the tutorial at yandex of TieLay.

 

[TieLay]

So, by db, you mean the database...

[SqlException (0x80131904): Could not find stored procedure 'TblAdminUserDA_SrchByLoginID'.]

In your's DB not exists needed procedures, download correct data from my

You must be registered to see links

on Server section file SQLDATA.RAR U need "aion_log.bak" for implementation