Setting up Aion 3.9 Private Server: Video Tutorial

[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):

To view the content, you need to sign in or register

Databases (Credits to Kreeate): http://forum.ragezone.com/f587/release-al-3-9-source-936746/index24.html#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/release-aion-lightning-3-9-a-948118/


JDK 7:

To view the content, you need to sign in or register

MySQL:

To view the content, you need to sign in or register

NavicatLite:

To view the content, you need to sign in or register

GM commands: http://forum.ragezone.com/f587/complete-aion-admin-gm-commands-793380/


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

 

[kingzxc]

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

 

[cookiehoar]

Here you go. ^_^
http://forum.ragezone.com/f587/complete-aion-admin-gm-commands-793380/

 

[kingzxc]

Here you go. ^_^
http://forum.ragezone.com/f587/complete-aion-admin-gm-commands-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/release-aion-lightning-3-9-a-948118/
and here -> http://forum.ragezone.com/f587/release-aion-nextgen-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.

View attachment 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-aion-server-setup-650150/

 

[reapertda]

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

i have to change it.

 

[TheLastAnnon]

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

i have to change it.

 

[Csak Egy Ember]

very,very helpful Video and competent comment!
Thx

 

[cookiehoar]

very,very helpful Video and competent comment!
Thx

Glad I could help you, thanks.

 

[kurtspirit]

Hi,
i'm very stupid but i don't understand how to set up the aion server on "live" server...
(i'll try to explain,sorry i'm not English :/) :
Setting up the server on 127.0.0.1 address is ok but if i want to change this ip for another address, like my box ip, i have all the time errors.

I try to change on ipconfig.xml -> bad; on database/ls_server/gameserver -> bad, and i try many change on properties files without more chance :/

Can someone help me please?

Thank you really much.

 

[reapertda]

if you are trying to make your server public,

go to AL_Game/Config/network end edit ipconfig

<ipconfig default="your external ip">

then make sure you do port forward if you are using router.