So I have the server up and working. It's suppose to auto create accounts? But it isn't. And idk what to use for the username now. Thanks for any help! :D.
Printable View
So I have the server up and working. It's suppose to auto create accounts? But it isn't. And idk what to use for the username now. Thanks for any help! :D.
Two approaches to this issue:
1.) Ensure that network.properties in <SERVER>\Login\config\network has the following line:
loginserver.accounts.autocreate = true
If that is set to false, you will need to manually create any accounts. Which brings us to step two
2.) Check the database XXXX_server_ls for the table "account_data"
This will show you all created accounts on your server, as well as a hash of the password (not sure what is used to hash or encode the password. Looks like base64 but it's not. Probably MD5)
Enable the "loginserver.accounts.autocreate" option, or find an already created account and blank the password hash in the database. Either method should get you logged in. Let me know if this works for you.
So apparently i was missing the network.properties. I downloaded aion.core(or w.e. it's called) earlier and just took the file from that and added the line you told me to. testing it now.
- - - Updated - - -
oh so, it still says invalid id and password. im not even really sure what the username/password should be lol. How does the 'loginserver.accounts.autocreate = true' work? Am I suppose to be able to just create an account at the login screen? if that's the case, it isn't letting me lol.
Just reread what you wrote, and I haven't created an account yet x.x. and making a new one in account_data isn't working either.
There isn't supposed to be a pre-configured user. The account_data table should be empty. Here is a screenshot of my network.properties for the login server:
Imgur: The most awesome images on the Internet
Manually creating accounts using SQL might be buggy, as Aion hashes the password and unless you know HOW it hashes the password, it might not read the password correctly. Which might be the problem you're having. You're entering a password for an account in plain text and the game thinks it's a hash and tries to decode it.
With loginserver.accounts.autocreate set to "true", you're supposed to be able to enter any username and password, and the game will check the DB and if the account name doesn't exist, it creates an entry for it using the name and password you used.
Edit: One thing I would suggest (This is my problem with my Aion server) check to see if, in your login folder, you have a "build" folder. If you don't, disregard the next part of my post.
If you do, open it to see if you have a "dist" folder in there, then open the "dist" folder to see if you have a copy of your login server folder in there. In my Aion server, for some reason unbeknown to myself or even the gods, I have two separate configs for everything. Any modifications to game files I want to make, I have to make them twice: One in the normal location, and one nested in the "build\dist" folder If you have this duplicated folder, make sure you make the settings changes inside there as well.
Yup that's what my network.properties looks like. I do have a dist folder, i'll change the settings there too and try again.
*Also, I didn't know that about manually creating account. I deleted it, also im using navicat.. if that makes a difference lol.
- - - Updated - - -
still says id/pass do not match T.T
The Giga files suggest Heidi SQL. I've used both Heidi and manual SQL commands. It shouldn't matter. Only real difference is the GUI.
If your server setup is like mine (Two sets of configs) you'll need to go back and make all of the configuration changes you made when you initially set the server up again in the "dist" configs as well. I've tried making changes to only one or the other, and the server NEVER worked until I made changes to both sets of configs. Not sure why, and since I was able to get the server working, never bothered to ask about it.
well all the guides had navicat x.x. But any other ideas as to why it's still not letting me create my own account? Cuz I can't think of any. Is there a way around it? Like adding in an account someway?
Are you planning on using this server as a public-facing application, or is it private for your own use?
If it's private, I can log in on mine and create an account, then post the SQL results here and have you add them to your accounts_data table manually.
Did you have a separate set of configs in the dist folder?
Also, is the username you're trying to create all lowercase? I thought I remembered reading somewhere that Aion is picky and requires account names to be all lowercase.
This should get you up and running:
Enter this information into the account_data table using Navicat:
id: 1
name: test
password: W6ph5Mm5Pz8GgiULbPgzG37mj9g= (This is "password" when you try to log in)
activated: 1
access_level: 3 (GM access)
Leave the rest of the columns blank, they should auto populate
It's a private server. and no i just copy and pasted the configs from the dublicate folder outside dist.
I edited my post to include a test account you can enter into the database manually
- - - Updated - - -
If all else fails, I know the Gigatroon 4.7.5.18 is working. It's the server I use.
So i tried it, doesn't work. But under 'ae_server_gs' >> 'players'. There's a spot for 'account_name' could 'test' not be working cuz it's an in navicat it's an in-game name and not the account name?
- - - Updated - - -
i'd fill it out but idk wt to put for loc/heading/ect x.x
Any of the changes we are making, need to go into the "ls" database, as that's the db for the login server. The "gs" database is for the actual players on each account. If you added test to the gs database under players, then you would be correct.
In the "ls" database, is the account_data table empty?
No I did everything you told me in the ls database, I just had an idea is all lol. But everything I did was/is under the ls database. Didn't work btw.
- - - Updated - - -
Are there any options left? I'd love to exhaust them all before I go and try to create a new private server. D:
Wait, after you changed the network.properties, did you restart the server?
if by restart the server you mean exit from the game? Yes. i also re-executed the sql files just to be safe. But if you mean something else by restart the server than prob not :/.
There were batch files you needed to run to start the server. Those batch files look at the configs only once. Which means any changes you make to them, you need to stop the services started by the batches, and restart them. This may be why the changes to the network configs are not working.
Okay so the batch files didn't really do much.. opened up a black screen for a sec, and then shut down? Lol.. is that bad? X.X
What server are you using, also what guide did you follow?
There should have been a way to start the server.
well actually, i already downloaded heidi, so just what's the gigatoon you were talking about lol. I feel that that actually might be easier than this x.x. is it this?
http://forum.ragezone.com/f587/aion-...7-5-a-1072930/
Yeah that's the one I use.
Honestly, though, the issue you had is bothering me. I actually might lose sleep tonight because we weren't able to fix it. I'll get over it I guess lol.
As far as SQL clients, Navicat or Heidi doesn't matter. They do the same thing, they just look different and may have a few features the other doesn't.
Make sure you use this tutorial: http://forum.ragezone.com/f588/aion-...7-5-a-1073648/
Okay, But i kind of like heidi better lol. Although.. Why can't I import x.x. it's not working D:.
And apparently there's an error with the .sql file. T.T. Idk maybe i wasn't meant for this x.x.
What is x.x.?
You mean the databases?
idk... the guide says to import, but nothing happens, and so I try and execute it, but then there's an error.. im so lost XD
Ahh. This part fucked me up too.
In Heidi, left click on the master database icon on the left and then right click. Select "Create New" and the "Database"
(The icon probably looks like a dolphin)
Name it ac47_server_ls
Do it again for ac47_server_gs
Once you have those two new databases, click on one of them, and hit Ctrl+O (Or File > Load SQL file) Find the SQL file with the same name as the database you've clicked onto. Select it then hit "Open"
From here, hit the blue play button at the top to execute the SQL file (or hit F9). It should begin importing. When it's done, do the same thing for the other database. Make sure the name for the target DB (you new one) matches the source DB (what you're importing)
It's probably going to give you some warnings. Disregard this.
When both of these are done, close Heidi and re-open it and reconnect. You should see the database information populated.
when i execute it, an error pops up and says SQL Error (1064) you have an error in your SQL syntax; 'KEY_BLOCK_SIZE=16' at line 7
Which SQL file were you importing, GS or LS?
The syntax error message indicates that something isn't right with the spelling or the commands used.
gs. ls worked fine.
Find the gs sql file (SERVER>GAME>SQL) right click it and select "Edit"
This should open the SQL file in notepad. Screenshot the window without scrolling and post the link. Something seems off about the SQL file. Mine makes no mention of KEY_BLOCK_SIZE in line 7
idk how to screenshot T.T
/*
Navicat MySQL Data Transfer
by GiGatR00n v4.7.5.x
Source Server : Localhost
Source Server Version : 50616
Source Host : 127.0.0.1:3306
Source Database : ac47_server_gs
Target Server Type : MYSQL
Target Server Version : 50616
File Encoding : 65001
Date: 2015-05-11 19:21:17
*/
SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `abyss_rank`;
CREATE TABLE `abyss_rank` (
`player_id` int(11) NOT NULL,
`daily_ap` int(11) NOT NULL,
`daily_gp` int(11) NOT NULL,
`weekly_ap` int(11) NOT NULL,
`weekly_gp` int(11) NOT NULL,
`ap` int(11) NOT NULL,
`gp` int(11) NOT NULL,
`rank` int(2) NOT NULL DEFAULT '1',
`top_ranking` int(4) NOT NULL,
`daily_kill` int(5) NOT NULL,
`weekly_kill` int(5) NOT NULL,
`all_kill` int(4) NOT NULL DEFAULT '0',
`max_rank` int(2) NOT NULL DEFAULT '1',
`last_kill` int(5) NOT NULL,
`last_ap` int(11) NOT NULL,
`last_gp` int(11) NOT NULL,
`last_update` decimal(20,0) NOT NULL,
`rank_pos` int(11) NOT NULL DEFAULT '0',
`old_rank_pos` int(11) NOT NULL DEFAULT '0',
`rank_ap` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`player_id`),
CONSTRAINT `abyss_rank_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
Did you get that information when you opened the sql file in notepad, or is that a log from navicat?
notepad
That's odd. That's not the data I have.
Here's the SQL files from my repository. I kept a copy of the entire server download on ice in the event that something happened. These might work. I'm not sure what all that nonsense is in your SQL file as it's been branded by Gigatroon.
https://drive.google.com/open?id=0B1...zBsak82TlNjZ0k
(These SQL files shouldn't contain any character or configuration data as they come from my repo.)
Edit: Someone may demand this, so here's the virustotal result of the file. To confirm, feel free to submit the file to virustotal and confirm that the SHA256 hash matches.
https://www.virustotal.com/en/file/6...is/1483401094/
lol, so... what launcher do you use? There isn't one in the guide.
Somewhere on the board is a launcher that Giga links to called "AionRdy.7z" I can't seem to find it right now, but that's the version of the game I use.
I found it, but when I try and start all 3 servers it says StartLS, StartCS and ect not found? I extraced them and ran them in production mode, is there something more i was suppose to do?
Check in the Build\Dist\Login folders for the StartLS.bat
Check in the Build\Dist\Game folders for the StartGS.bat
Check in the Build\Dist\Chat folders for the StartCS.bat
If they don't exist, I can link you the code to make them yourself
They're there. It's saying java isn't recognizable as a command, operable program, or batch file T.T.
- - - Updated - - -
omg I feel like it shoudn't be this hard D:. I've been doing this for like 2 days XD
Did you use the Java SDK link in the guide?
If you did, Oracle gave you the wrong file. I did this exact same thing.
Look at the link, it's for the Java Runtime Environment (JRE) where as the guide calls for Java Development Kit (JDK)
You need the JDK 7u80. Try this link. Java™ SE Development Kit 7 Update 80 Release Notes
Also make sure you're setting the Java Home and Variables (Step 2 of the guide)
- - - Updated - - -
Don't fret man. It took me three days to get this right. Aion was the first MMO server I got working. There are so many little moving pieces to this that anything can go wrong.
lol thanks. honestly thinking of wiping all the junk i've downloaded trying to do this and restarting lol. i have sql, mysql, the cat thing, heidisql, hamachi, virtualbox, zend optimizer, slikconversion. all from trying to put a server up lmfao.
That's honestly a good idea.
1.) Uninstall and wipe everything out (Save the downloaded source files, though)
2.) Try again from the beginning.
You honestly don't need anything for the Aion server but JDK 7u80, MySQL, and Heidi. SQL is just another type of database, Navicat is the same as heidi (except it's not free), Hamachi, zend optimizer silkconversion and virtualbox are all unnecessary.
Unless you're using virtualbox to create a VM to run the server on, then I can see why you have it.
Everything else can go.
- - - Updated - - -
During the three days it took me to get up and running, I probably did this like five times.
lol okay i'll try that. and no i had virtual box cuz i tryed hosting ragnarok first, but that was an epic failure too T.T.
Honestly, some MMOs go super smooth, and some are like pulling teeth. Aion and Fiesta were a pain in the ass. Ether Saga was just difficult and Aura Kindgom went pretty smoothly.
WoW was way too fucking hard. I tried to compile my own server using Mangos and nothing worked ever. I eventually gave up (After four and a half days of no sleep) and went with single player project.
lol wow. apparently fiesta doesn't work with win10, so I gave that up lol... too lazy to figure out VM. Gave up ragnarok when I hear aion could be hosted. Now I'm trying to figure out aion lol. btw the guide that you gave me, he didn't mention anything about the build folders and running the batch files.
Yeah. It came with a "Launcher.bat" and I just created shortcuts to the individual batch files instead. I am not a fan of simple things. I overcomplicate shit.
I installed Win7 on my physical server that I run Fiesta on because of the Win10 thing. VMs aren't TOO complicated if you can get over thinking of them as actual computers, and more like emulated computers. Once you can get over that, VM is pretty straight forward. If you ever want to set up a Fiesta server as well, let me know. That's another one that I had to redo multiple times so I am pretty familiar with it.
lol@fiesta. But not the launcher, i mean the startGS/startLS ect batch files.
Yeah. I think Giga assumed you would use the Launcher.bat. The launcher is a simple batch file that just calls to all three batch files when you select "run all servers". The launcher didn't work for me, so I went to the individual batch files instead and have used them ever since.
Fiesta was a game I played since the end of Closed Beta (2007) until a couple years ago. Right before Gamigo took over. Spent a lot of time in that (god forsaken) game.
Ohh okay. So I dont have to extract them from the build folder>>zip? and lol i kinda enjoyed it for a while. never spent much time on it though.
- - - Updated - - -
what collation should i be in? unicode? or the default?
No. You can leave them in the build folder. I wouldn't move those scripts anywhere. Create shortcuts to the scripts and use those instead.
How is it that im getting errors x.x if you used the same files lol. says SQL Error (1115): Unknown character set: 'utf8mb4'
What version of heidi did you use?
Just leave everything as is unless the guide specifically says to set it to something.
- - - Updated - - -
Heidi 9.2.0.4947
I wonder if Giga updated the files. The release post was updated a week ago.
My Databases are utf8_general_ci
so i just did the, run with errors option? They had like 14 at most, but i got the files XD
- - - Updated - - -
im using 9.4. Do you think it will make a difference?
- - - Updated - - -
it says it can't find StartCS,StartLS, or StartGS when I run the launcher. What did you do?
I think this is why I didn't use the launcher. Try locating those individual files and manually running them.
I did try, says Java is not a recognizable program, batch or w.e... like i told u b4. And I downloaded the right java x.x.
Did you set the environment variables?
yeah, the JAVA_HOME thing?
- - - Updated - - -
oh i have JRE7 :O.
Your variables should look like this
Imgur: The most awesome images on the Internet
That's what I did too! It took me over a day to figure it out because I kept telling myself "They wouldn't put the wrong java link in the tutorial, would they?" So I kept trying to make it work with JRE and not JDK.
Make sure you set BOTH Java and Java Home
OKAY. So I got it working at least lol.. but then this comes up?:
Error: Could not find or load main class com.aionemu.loginserver.LoginServer
Error: Could not find or load main class com.aionemu.chatserver.ChatServer
on the cmd boxes.
- - - Updated - - -
also says cannot load chat server configuration? is that the chatserver.properties?
Look in <SERVER>\Login\libs and see if "AC-Login.jar" exists.
If it does not, check the <SERVER>\build\dist\Login\libs folder.
It should exist in one of those two. Do the same thing for Game server and Chat server. (AC-chat.jar, AC-game.jar)
I suspect your batch files are in the wrong location
(Sounds like you now have that issue where you have double the game config locations)
- - - Updated - - -
I believe so, yeah
- - - Updated - - -
I'm hoping that the long silence means you got your server up and running. Though, it probably means you just gave up for the night.
Let me know if you need any further help man.
Okay, im at work rn but when i get home ill try that. What do I do with them if yheyre doubled?
- - - Updated - - -
Oh hell no lmao. I've gotten this far, im not giving up yet! And i would never dissapear without thanking you for being such a huge help! I never would have made it this far without you lol.
- - - Updated - - -
Ohh and what spot are they suppose to be in? The main folder?
Whatever libs folder contains the AC-<server>.jar file is where the Start<SERVER>.bat files should go.
For example:
If AC-Game.jar lives in SERVER\AC-Game\build\dist\AC-Game\libs
Then your StartGS.bat should be in: Aion\AC-Game\build\dist\AC-Game\
If AC-Game.jar lives in Aion\AC-Game\libs
Then your StartGS.bat should be in: Aion\AC-Game\
(If your setup is like mine, your server jar files will be in the <SERVER>\build\dist\<XX>\libs directory)
I was just hoping that maybe you got it to work. Don't need to thank me, I'm not here doing this enough.
okay im going to try and make this easy to read lol...
AC-login.jar is in-->
C:>>Aion>>trunk>>AC-Login>>Build
but it's also in
C:>>Aion>>trunk>>AC-Login>>Build>>dist>>AC-Login>>libs
the StartLS.bat is only in
C:>>Aion>>trunk>>AC-Login>>Build>>dist>>AC-Login
i hope that makes sense!! And that's the same for AC-Game and AC-Chat
- - - Updated - - -
StartLS.bat is also in C:>>Aion>>trunk>>AC-Login>>dist. They everywhere T.T.
- - - Updated - - -
okay good news, i got
StartGS.batch
and
StartLS.batch
to work by deleting the extra .jar files and the StartX.batch files.
The only problem now is I can't get the chat one (StartCS) to work. I did notice that I'm missing the StopCS.sh file though... which is in the 2 other folders. Not suer what it does.. but I'm gonna try the build.chatserver.bat batch file again see if it shows up.
- - - Updated - - -
I get this when I run the StarCS.bat file.
Starting Aion-Core Chat in DEVELOPMENT mode.
Listening for transport dt_socket at address: 8997
08:20:16.927 INFO [main]: - Loading: mycs.properties
08:20:16.931 INFO [main]: - No override properties found
08:20:16.942 INFO [main]: - Loading: commons.properties
08:20:16.951 INFO [main]: - Loading: chatserver.properties
08:20:16.953 ERROR[main]: - Can't transform field CHAT_ADDRESS of class class com.aionemu.chatserver.configs.Config
08:20:16.956 ERROR[main]: - Can't load chatserver configuration
java.lang.RuntimeException: null
at com.aionemu.commons.configuration.ConfigurableProcessor.processField(ConfigurableProcessor.java:155) ~[al-commons-1.3.jar:na]
at com.aionemu.commons.configuration.ConfigurableProcessor.processFields(ConfigurableProcessor.java:122) ~[al-commons-1.3.jar:na]
at com.aionemu.commons.configuration.ConfigurableProcessor.process(ConfigurableProcessor.java:76) ~[al-commons-1.3.jar:na]
at com.aionemu.commons.configuration.ConfigurableProcessor.process(ConfigurableProcessor.java:61) ~[al-commons-1.3.jar:na]
at com.aionemu.chatserver.configs.Config.load(Config.java:119) ~[AC-Chat.jar:na]
at com.aionemu.chatserver.ChatServer.main(ChatServer.java:120) [AC-Chat.jar:na]
Exception in thread "main" java.lang.Error: Can't load chatserver configuration
at com.aionemu.chatserver.configs.Config.load(Config.java:122)
at com.aionemu.chatserver.ChatServer.main(ChatServer.java:120)
Caused by: java.lang.RuntimeException
at com.aionemu.commons.configuration.ConfigurableProcessor.processField(ConfigurableProcessor.java:155)
at com.aionemu.commons.configuration.ConfigurableProcessor.processFields(ConfigurableProcessor.java:122)
at com.aionemu.commons.configuration.ConfigurableProcessor.process(ConfigurableProcessor.java:76)
at com.aionemu.commons.configuration.ConfigurableProcessor.process(ConfigurableProcessor.java:61)
at com.aionemu.chatserver.configs.Config.load(Config.java:119)
... 1 more
Chat Server has terminated abnormaly!
Press any key to continue . . .
- - - Updated - - -
lol okay, so I keep making progress... I got chat to work.. didn't set the localhost/127.0.0.1/LANIP..
So I set anything that had to do with ips.. to localhost, in all config files.. but now I keep getting this:
========================[ ===========NETWORK========= ]========================
09:16:35.524 INFO [main]: - Server listening on IP: localhost Port 7777 for Game Connections
09:16:35.525 INFO [main]: - Connecting to LoginServer: localhost/127.0.0.1:9014
09:16:35.531 INFO [main]: - Connected to LoginServer!
09:16:35.532 INFO [main]: - Connecting to ChatServer: localhost/127.0.0.1:9021
09:16:35.537 INFO [main]: - Connected to ChatServer!
========================[ =========================== ]========================
09:16:35.540 ERROR[InstantPool-8]: - GameServer is not authenticated at LoginServer side, shutting down!
09:16:35.542 WARN [pool-4-thread-1]: - Connection with LoginServer lost...
09:16:35.542 INFO [main]: - FACTIONS RATIO : E 50.0 % / A 50.0 %
09:16:35.543 INFO [Thread-25]: - Runtime is shutting down now ...
09:16:35.544 INFO [Thread-25]: - GameServer disconnected from the Login Server...
09:16:35.544 INFO [Thread-25]: - All players are disconnected...
09:16:35.546 INFO [Thread-26]: - Garbage Collector is scheduled at duration: 1800000 in milliseconds.
09:16:35.548 INFO [InstantPool-10]: - GameServer authed successfully IP : 127.0.0.1 Port: 10241
09:16:35.557 INFO [Thread-25]: - Starting data save on shutdown.
09:16:35.557 INFO [Thread-25]: - Legion WH update task started.
09:16:35.557 INFO [Thread-25]: - Legion WH update: 0 ms, legions: 0.
09:16:35.557 INFO [Thread-25]: - Data successfully saved.
09:16:35.557 INFO [Thread-25]: - Game time saved...
09:16:35.634 INFO [Thread-25]: - Scheduler QuartzScheduler_$_NON_CLUSTERED shutting down.
09:16:35.634 INFO [Thread-25]: - Scheduler QuartzScheduler_$_NON_CLUSTERED paused.
09:16:35.635 INFO [Thread-25]: - Scheduler QuartzScheduler_$_NON_CLUSTERED shutdown complete.
09:16:35.635 INFO [Thread-25]: - ThreadPoolManager: Shutting down.
09:16:35.636 INFO [Thread-25]: - ... executing 3647 scheduled tasks.
09:16:35.636 INFO [Thread-25]: - ... executing 1 instant tasks.
09:16:35.636 INFO [Thread-25]: - ... executing 0 long running tasks.
09:16:35.636 INFO [Thread-25]: - ... 0 forking tasks left.
09:16:40.545 INFO [pool-2-thread-15]: - Connecting to LoginServer: localhost/127.0.0.1:9014
09:16:40.546 INFO [pool-2-thread-15]: - Connected to LoginServer!
09:16:40.548 WARN [pool-4-thread-1]: - Connection with LoginServer lost...
not sure where the 127.0.0.1 is coming from.. I thought I got rid of them all T.T
Remember, any changes to config files you make, you'll need to make them twice, as you now have double the config files and I am not sure which config files are live. So it's faster to make changes to both sets, as opposed to figuring which configs are live and sorting them out.
Another thing, localhost is the named version of 127.0.0.1. In your hosts file (C:\Windows\System32\drivers\etc) you should see two commented out entries like this:
#127.0.0.1 localhost
#::1 localhost
127.0.0.1 is IPv4 and ::1 is IPv6 for 127.0.0.1. But notice how they both resolve through "localhost". What this means is, if you type "ping localhost" in a command prompt, the computer translates that to "ping 127.0.0.1"
While you're in the hosts file, make sure that your hosts file has those same two entries but NOT commented out. If it doesn't, you'll need to open notepad as administrator, File > Open, select "All file types" then navigate to the above directory, open the hosts file, and add those entries.
Quote:
09:16:35.540 ERROR[InstantPool-8]: - GameServer is not authenticated at LoginServer side, shutting down!
This seems to be the beginning of your issues. Check the login server config files and ensure that you have the password entered correctly. Remember, in the ac47_settings_ls SQL file, in the game servers table, you need to set your server IP and database password. This same password needs to be in the config files (both sets) or things won't authenticate.
- - - Updated - - -
The configs you need to check are in:
Code:C:\Aion\trunk\AC-Login\config\network
C:\Aion\trunk\AC-Login\build\dist\AC-Login\config\network
C:\Aion\trunk\AC-Game\config\network
C:\Aion\trunk\AC-Game\build\dist\AC-Game\config\network
Sorry, fell asleep lol. Still human T.T. So, I have been changing both, and also I've checked ALL the passwords, they are the same. And in the database 'gameserver' I have
1
127.0.0.1
'password' <--- same for all files.
- - - Updated - - -
As a default, some things like
loginserver.network.client.host = *
have that asterik... is that normal? Or should I change them all to 127.0.0.1?
- - - Updated - - -
okay lol so all my servers are connecting! But idk how to startup the actual game T.T lmao.
Okay, so now is when you create the aion batch file.
Create a text document, place it in your Aion game install. The one you're going to use as your client. open the text document and paste:
If you're using the same machine as a server and running the game, the server ip is going to be 127.0.0.1. If you're running your server on a separate physical (or virtual) machine, set the machine IP here.Code:@Echo off
start bin32\aion.bin -ip:<SERVER IP HERE> -port:2106 -cc:2 -lang:enu -nowebshop -nokicks -ncg -noauthgg -ls -charnamemenu -ingameshop -DEVMODE "con_disable_console 0" -DEVMODE "g_chatlog 1" -DEVMODE "g_freefly 1" -DEVMODE "g_auto_disconnect 0"
Save the notepad document. Then in the folder, right-click on the text file and select "Rename". Rename it to <whatever>.bat
It will give you an error about changing the extension, say yes to change it.
Run that batch file and it should run the game and connect to the server IP specified.
okay. I had like 3 different versions of mysql so i deleted them all lol, now I have to redownload mysql and do all that stuff so it connects, then i'll do the batch file thing.
- - - Updated - - -
apparently uninstalling mysql was a bad idea x.x. Cuz now I can't get it to install!
- - - Updated - - -
So it still isn't connecting to loginserver D:
- - - Updated - - -
do you use mysql workbench? cuz I literally hate that thing.
No I didn't. I don't even know that that is. Is it the same authentication error connecting to the login server?
Well actually.. I'm onto another error T.T. It's telling me I need more memory even though I have 12gb of ram D:.
01:04:55.272 ERROR[main]: - Critical Error - Thread: main terminated abnormaly: java.lang.OutOfMemoryError: Java heap space
java.lang.OutOfMemoryError: Java heap space
at javolution.util.FastMap.setup(FastMap.java:257) ~[javolution-5.5.1.jar:na]
at javolution.util.FastMap.<init>(FastMap.java:249) ~[javolution-5.5.1.jar:na]
at javolution.util.FastMap.<init>(FastMap.java:218) ~[javolution-5.5.1.jar:na]
at com.aionemu.gameserver.controllers.CreatureController.<init>(Unknown Source) ~[AC-Game.jar:na]
at com.aionemu.gameserver.controllers.NpcController.<init>(Unknown Source) ~[AC-Game.jar:na]
at com.aionemu.gameserver.spawnengine.VisibleObjectSpawner.spawnNpc(Unknown Source) ~[AC-Game.jar:na]
at com.aionemu.gameserver.spawnengine.SpawnEngine.getSpawnedObject(Unknown Source) ~[AC-Game.jar:na]
at com.aionemu.gameserver.spawnengine.SpawnEngine.spawnObject(Unknown Source) ~[AC-Game.jar:na]
at com.aionemu.gameserver.spawnengine.SpawnEngine.spawnInstance(Unknown Source) ~[AC-Game.jar:na]
at com.aionemu.gameserver.spawnengine.SpawnEngine.spawnInstance(Unknown Source) ~[AC-Game.jar:na]
at com.aionemu.gameserver.spawnengine.SpawnEngine.spawnBasedOnTemplate(Unknown Source) ~[AC-Game.jar:na]
at com.aionemu.gameserver.spawnengine.SpawnEngine.spawnAll(Unknown Source) ~[AC-Game.jar:na]
at com.aionemu.gameserver.GameServer.main(Unknown Source) ~[AC-Game.jar:na]
01:05:00.602 ERROR[main]: - Out of memory! You should get more memory!
- - - Updated - - -
Can we skype or something? Cuz this is really awful T.T. We have the same stuff so idk why this isn't working lol.
- - - Updated - - -
lol not skype, prob teamviewer. idk wt else works.
- - - Updated - - -
just fixed memory problem by editing the .bat files to allow more memory.. now the gameserver wont connect to the loginserver lmao. fml
- - - Updated - - -
===============================[ GameServerLog ]===============================
01:42:34.124 INFO [main]: - AC GameServer started in 31 seconds.
========================[ ===========NETWORK========= ]========================
01:42:34.141 INFO [main]: - Server listening on all available IPs on Port 7777 for Game Connections
01:42:34.141 INFO [main]: - Connecting to LoginServer: localhost/127.0.0.1:9014
01:42:34.141 INFO [main]: - Connected to LoginServer!
01:42:34.141 INFO [main]: - Connecting to ChatServer: localhost/127.0.0.1:9021
01:42:34.157 INFO [main]: - Connected to ChatServer!
========================[ =========================== ]========================
01:42:34.157 INFO [main]: - FACTIONS RATIO : E 50.0 % / A 50.0 %
01:42:34.157 INFO [Thread-26]: - Garbage Collector is scheduled at duration: 1800000 in milliseconds.
01:42:34.157 ERROR[InstantPool-8]: - GameServer is not authenticated at LoginServer side, shutting down!
01:42:34.157 WARN [pool-4-thread-1]: - Connection with LoginServer lost...
01:42:34.157 INFO [Thread-25]: - Runtime is shutting down now ...
01:42:34.157 INFO [Thread-25]: - GameServer disconnected from the Login Server...
01:42:34.157 INFO [Thread-25]: - All players are disconnected...
01:42:34.157 INFO [InstantPool-9]: - GameServer authed successfully IP : 127.0.0.1 Port: 10241
01:42:34.188 INFO [Thread-25]: - Starting data save on shutdown.
01:42:34.188 INFO [Thread-25]: - Legion WH update task started.
01:42:34.188 INFO [Thread-25]: - Legion WH update: 0 ms, legions: 0.
01:42:34.188 INFO [Thread-25]: - Data successfully saved.
01:42:34.188 INFO [Thread-25]: - Game time saved...
01:42:34.272 INFO [Thread-25]: - Scheduler QuartzScheduler_$_NON_CLUSTERED shutting down.
01:42:34.272 INFO [Thread-25]: - Scheduler QuartzScheduler_$_NON_CLUSTERED paused.
01:42:34.272 INFO [Thread-25]: - Scheduler QuartzScheduler_$_NON_CLUSTERED shutdown complete.
01:42:34.272 INFO [Thread-25]: - ThreadPoolManager: Shutting down.
01:42:34.272 INFO [Thread-25]: - ... executing 5964 scheduled tasks.
01:42:34.272 INFO [Thread-25]: - ... executing 1 instant tasks.
01:42:34.272 INFO [Thread-25]: - ... executing 0 long running tasks.
01:42:34.272 INFO [Thread-25]: - ... 0 forking tasks left.
01:42:39.177 INFO [pool-2-thread-17]: - Connecting to LoginServer: localhost/127.0.0.1:9014
01:42:39.177 INFO [pool-2-thread-17]: - Connected to LoginServer!
01:42:39.177 WARN [pool-4-thread-1]: - Connection with LoginServer lost...
01:42:49.302 INFO [Thread-25]: - ... success: false in 15030 msec.
01:42:49.302 INFO [Thread-25]: - ... 0 scheduled tasks left.
01:42:49.302 INFO [Thread-25]: - ... 1 instant tasks left.
01:42:49.302 INFO [Thread-25]: - ... 0 long running tasks left.
01:42:49.302 INFO [Thread-25]: - ... 0 forking tasks left.
Game Server is terminated!
Press any key to continue . . .
We can if you want. PM me the team viewer info.
- - - Updated - - -
In the interest of disclosure, because I detest fixing things behind closed doors, here's a quick rundown of the TeamViewer session.
We were tight for time, but from what little time I was able to take a look at OPs configs, there were a few things missing here and there. Mostly addresses. Those were corrected. The gameserver database table in ac47_server_ls had incorrect information in the column names, and the db password or IP was not set. This was also corrected. We ran out of time, and after testing the gameserver, and confirming that it works (in theory) we have come across another issue. The SQL databases didn't import correctly and tables are missing. I didn't have enough time to build the tables by hand, and using the CREATE command contained within the .sql file in a new query returned a syntax error, we had to end there.
Once we get the missing tables built (by hand, most likely) I am pretty confident that the server will be up and running.
Well you were right! I finished the inventory table and then put the launcher in my client folder and started everything up and it worked! :D. Thanks for everything! I wouldn't have been able to finish this without you Pagefault!!
I just saw this. Awesome man! I'm sorry I missed the team viewer PM but I am glad you got the game up and running. All it was missing was the gameserver inventory table?
Yup! Actually the inventory had something wrong in it.. ill post the exact code later... on my phone atm but i deleted some line in the inventory section of the .sql file with 'hash' at the end of it. Idk what the purpose of it was but after i deleted that line it executed perfectly, didnt have to make it from scratch! Havent found any problems with my inventory either! When i get home ill post the line i deleted so other people with this problem will have a solution.
Okay so for anybody else having a problem with inventory not showing up(ac47_server_gs DB>>inventory table)
Just open ac47_server_gs.sql in notepad, and search(ctrl+F) for inventory. When you find it look for this line
KEY `item_location` (`item_location`) USING HASH,
and delete the 'USING HASH' so it looks like this
KEY `item_location` (`item_location`),
and then just re-execute the ac47_server_gs.sql, and hopefully it works!! Good luck everyone!^^.
pagefault404 please can you assist with this issue
all 3 servers are running fine(chat,log,game)
i have checked sqldatabase to make sure account was autocreated. That works fine.I can login to the game but when i get to choose a server i get this message
Screenshot by Lightshot
can you help at all on this?
I replied to your PM, but what you should do is create a new post in the Aion Help section so we don't pile several issues into one post. Helps to minimize confusion
Edit: Disregard this. I just saw your post. I will address the issue there. Sorry about that.