Cookiehoar's video guide to setting up Aion 3.9

[cookiehoar]

So here's my video tutorial on how to set up Aion 3.9 private server using AL 3.9 pre-built files. Sorry I was a wee bit drunk and sleepy but the guide pretty much sums everything that you would need to know to get started with your private server using these pre-built files. Hope you enjoy. Be sure to ask me any questions in the comments and I'll try my best to answer them. Files are attached down below.



~Cookiehoar.

Files:


Aion 3.9 pre-built server files (Credits to UnknownMan1 & Kreeate):
http://www.mediafire.com/download/h0...3.9_SOURCE.zip


Databases (Credits to Kreeate): http://forum.ragezone.com/f587/relea...ml#post7663759


For those of you extremely lazy to go through all the pain and just play around by setting up Aion server in 1 click, check out Dwarfpicker's one click AL 3.9 files (Credits to Dwarfpicker):
http://forum.ragezone.com/f587/relea...-3-9-a-948118/


JDK 7: Java SE Downloads


MySQL: mysql-5.1.26-rc-winx64 - Download - 4shared - ChristianD


NavicatLite: navicat091_lite_en - Download - 4shared


GM commands: http://forum.ragezone.com/f587/compl...mmands-793380/


Ragezone link to files: http://forum.ragezone.com/f587/relea...-3-9-a-936746/

[MentaL]

[kingzxc]

i am search for Gm commandos for this pack i didnt find it

[cookiehoar]

Here you go. ^_^
http://forum.ragezone.com/f587/compl...mmands-793380/

[kingzxc]

Here you go. ^_^
http://forum.ragezone.com/f587/compl...mmands-793380/

thanks >>

[cookiehoar]

thanks >>

No problemo.

[lethalsin]

I figured out ..I just got to see why i cannot make chars now it tells me unable to create ..

[tokomoxo]

please help...

[cookiehoar]

please help...

Follow the video mate, I didn't even use chat server console, only used Login Server and Game server. c:

[nadimo]

Hey, thanks for the tutorial it was really simple to follow :)
But I have a problem, whenever I try to enter the server I would get an error: "No game server is available to the authorization server".

I can login successfully so I don't think that the loginserver is faulty, it's probably the gameserver.

[Dwarfpicker]

nope U need the client fix files.

They are included here -> http://forum.ragezone.com/f587/relea...-3-9-a-948118/
and here -> http://forum.ragezone.com/f587/relea...-3-9-a-948089/

Also these packs are 1-Click server so you dont have to compile or set up.

Best solution 4 beginners!

[reapertda]

hi cookiehoar, i have followed your steps in building the server. I get this message when I am trying to execute my GameServer sql.

Could you please advise. Thanks

[Err] 1067 - Invalid default value for 'level_up_date'
[Err] CREATE TABLE `towns` (
`id` int(11) NOT NULL,
`level` int(11) NOT NULL DEFAULT '1',
`points` int(10) NOT NULL DEFAULT '0',
`race` enum('ELYOS','ASMODIANS') NOT NULL,
`level_up_date` timestamp NOT NULL DEFAULT '1970-01-01 07:00:01',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[cookiehoar]

hi cookiehoar, i have followed your steps in building the server. I get this message when I am trying to execute my GameServer sql.

Could you please advise. Thanks

[Err] 1067 - Invalid default value for 'level_up_date'
[Err] CREATE TABLE `towns` (
`id` int(11) NOT NULL,
`level` int(11) NOT NULL DEFAULT '1',
`points` int(10) NOT NULL DEFAULT '0',
`race` enum('ELYOS','ASMODIANS') NOT NULL,
`level_up_date` timestamp NOT NULL DEFAULT '1970-01-01 07:00:01',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

I wouldn't claim it being the exact error, but I believe your al_server_gs is, well, "spoiled" one might say? Tried redownloading / extracting / executing? Lemme know if it works.

[reapertda]

i have tried, not working. tried redownload/executing not working :(

[TheLastAnnon]

i have tried, not working. tried redownload/executing not working :(

Are you executing the empty databases? Try these. Confirmed working on my side.

Databases.zip

Databases.zip
SHA-1: 656578FD91A522ECEC924070EE7C52350FA28579
SHA-256: 6F06BF1BEB6DB2E9808D3818D8E4E95012A936649E3A17B6E931DB9C8CC90CF4

ae_server_ls.sql
SHA-1: AC07AEE6A3554018DD0BAF6AFBFB643E784EA6ED
SHA-256: 17206AEA048E980A4645B42128C0D38F891F8551BE5DFF8EA2722865798F7B50

ae_server_gs.sql
SHA-1: F2ADC97EB28C33FFF4D36E800B4BB1D9D6902BFF
SHA-256: F36CC398F085A797495445FA948F7405C45ED9F2B842771D31754428D24A1CEE

Try to execute these. If it works you have to go into the ae_server_ls database, open "gameservers" and enter:

ID: 1
Mask: 127.0.0.1
Password: 123


As posted here:
http://forum.ragezone.com/f588/guide...-setup-650150/

[reapertda]

ye it's been fixed, it was due to the timestamp and datetime thing

i have to change it.