I have the Same Problem.Quote:
Originally Posted by Maybely
Printable View
I have the Same Problem.Quote:
Originally Posted by Maybely
Hi ,the table will be empty if you have not created an account.Quote:
Originally Posted by Maybely
The server will automatically fill in new account data in the tables once you create an account.
You need to set automatic account creation to true in the configuration files (if it is not set already).
(your loginserver folder)\config\network\network.properties
# Create accounts automatically or not?
loginserver.accounts.autocreate = true
Once you set it to true ,when you login in game ,your table should fill in the values.If nothing happens ,check if your loginserver can actually connect to the database.
If it can't ,you will usually get an error in the loginserver console.
Let me know if you still have an issue.
PS: I just noticed that you have all of your tables in one database.
Did you actually execute loginserver.sql and gameserver.sql in one database ?
You need to create two databases,gameserver and loginserver.
Check the red colored lines and change them accordingly to your MySQL databases.
Check all lines that I will post here,check if the red colored text is matching your database:
Also check this photo https://imgur.com/JvhghhM
1st. (loginserver folder)\config\network\database.properties
# This is database url.
database.url = jdbc:mysql://localhost:3306/loginserver5?useUnicode=true&characterEncoding=UTF-8
# Database password# NOTE: Change this! Root password is not safe!
database.password = password
2nd. (gameserver folder)\config\network\database.properties
# This is database url.
database.url = jdbc:mysql://localhost:3306/gameserver5?useUnicode=true&characterEncoding=UTF-8
# Database password# NOTE: Change this! Root password is not safe!
database.password = password
3rd. (gameserver folder)\config\network\network.properties
# ----------------------------#
Network Config's:
# ----------------------------#
# Password of this game server
gameserver.network.login.password = password
4th. (gameserver folder)\config\main\gameserver.properties
# Name of your loginserver database
# MySQL5AbyssRankDAO fix to exclude GM/Staff from Abyss Ranking list
# Default: al_server_ls
loginserver.database.name = loginserver5
Hello,Quote:
Originally Posted by quasaralpha
i do everything what u write and still nothing in my Navicat.
https://ibb.co/vHrXcJF
https://ibb.co/jJWfwqn
https://ibb.co/xF7twkV
Can someone help me, i dont know why Navicat not connect with my Database, i can start this server normaly und play. Everything works, but not Navicat..
Thank u
Hey,
My Navicat find now my Database but now i have new problem.
When i create a new Character, i have Error. World Database Error
23:36:58.178 ERROR[PacketProcessor:2]: - Error saving new player: 320929 Execom.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '320929' for key 'PRIMARY' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_80] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[na:1.7.0_80] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_80] at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_80] at com.mysql.jdbc.Util.handleNewInstance(Util.java:377) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.Util.getInstance(Util.java:360) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:971) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1199) ~[mysql-connector-java-5.1.33.jar:5.1.33] at com.jolbox.bonecp.PreparedStatementHandle.execute(PreparedStatementHandle.java:138) ~[bonecp-0.7.1.RELEASE.jar:0.7.1.RELEASE] at mysql5.MySQL5PlayerDAO.saveNewPlayer(MySQL5PlayerDAO.java]:269) ~[na:na] at com.aionemu.gameserver.services.player.PlayerService.storeNewPlayer(Unknown Source) [AL-Game.jar:na] at com.aionemu.gameserver.network.aion.A.qA.runImpl(Unknown Source) [AL-Game.jar:na] at com.aionemu.gameserver.network.aion.AionClientPacket.run(Unknown Source) [AL-Game.jar:na] at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:48) [al-commons.jar:na] at com.aionemu.commons.utils.concurrent.ExecuteWrapper.execute(ExecuteWrapper.java:41) [al-commons.jar:na] at com.aionemu.commons.network.PacketProcessor$PacketProcessorTask.run(PacketProcessor.java:266) [al-commons.jar:na] at java.lang.Thread.run(Thread.java:745) [na:1.7.0_80]23:37:08.741 INFO [pool-4-thread-1]: - Sending account disconnected 3
What now?
Hi.
Do a clean install . Remove all databases ,or delete all tables and execute SQL files again.
[PacketProcessor:2]: - Error saving new player: 320929 Execom.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '320929' for key 'PRIMARY' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
In the SQL file PRIMARY KEY for players table is (`id`).
Just do a fresh install.
ExECss you don't need to make changes to the server, leave as is.
to view your data in Navicat...
Connection Name: SPP-Aion-5_8
Host: localhost
Port: 3312
User Name: root
Passworld: 123456
Screenshot by Lightshot
Thank u Guy´s everyhting is working!!!
THANK U!!!
Edit: to close database correctly... Ctrl + C and then S
So I got this working rather easily with all the thread help, but was curious since I no longer see a 5.8 folder in github is there a way to get the last 5.8 fixes anywhere else? And if so do I just need to replace certain folders and not the startup .bats?
Hi.
Not sure if someone is working on or has stable source of this.
The one that was in the git repository seems to be the final thing.
I am using that same source , editing lots of files.
But if you get your hands on a new fixes:
If it's Java related ,you'll have to find out what exactly are these
files fixing and swap your old java files in the source or just copy
the changed code inside the fix file and paste it in your file.
This method won't work if the sources are not same,due to
compilation issues,unless you edit the file/code appropriately.
If it's something like SQL database update , you need to check if
that file is dropping old tables and creating new after that ,because
you will lose your stored data ,depending on the table.
If you specify what fixes you are referring to ,I might be able to
give more accurate information.
Cheers.
Well, I might be jumping the gun on it, I saw a lot of comments about bosses disappearing and drops not working so wasn't sure if they had released more fixes since the original posters one click option. I haven't jumped into the game much yet, wanted to make sure it was working first, which I did get in. I just wanted to make sure I had the best version of 5.8 I could get before I got too deep into it. If that makes any sense. Like if there were any dungeon or quest issues that were fixed later than the original release.
Yes ,I undesrstand you.
I am currently waiting for someone to post how packets are being distributed/transferred between the client and the server.
The connection between the server and the client is the most important of it all,for example if you are missing the bytes for say ,quest action ,you will never be able to make a quest or to even start it.
I have a good working 5.8 Aion client I downloaded from NotAion's website.The 64bit is working like a charm.
But I think the server is based on a different client ,because I am missing quite many things,not all of the packets match.
Between the NotAion client and the 5.8 server from AionGermany
there is a missmatch or just missing packets ,some of the dancing animations are not working,sometimes I get messages in the
console such as "unknown packet received from client".
That's killing me right now ,not knowing the distribution or flow of packets or whatever is called.
I'd rather work on one specifit client and make sure there are as many packets that match as possible and then share the client with others ,or why not work together with someone else on that.
So unless I know how to find as many packets as possible for that specific client ,I am not going to waste my time digging too deeply into the server.
However you can still fix quests and other things as long as the bytes are fine.
Drops ,missing NPCs,missing monsters,routes for walkers ,that's the easiest thing to fix.
You can make your own routes with one of the commands in the server actually.
Also the most frustrating thing is ,the geodata ,or the way NPCs move.They are just passing through walls while chasing you.I want to find out how the original thing works ,how NPSs are choosing a different path in the official server,how they are walking around obstacles ,taking decisions.
It's not fun looking at monsters chasing you and falling deep underground or just passing through walls,personally for me it killed all desire to play the game.
So many things :D.
But to sum up things ,if you have the packets ,you can build it from there and little by little it should be stable.
haha, exactly point! But yes, that is true. I guess I'll have to brave it and give the gameplay a try and hope for the best. The worst that'll happen is I'll just put it down and walk away for awhile! But thanks for your responses :)
Yeah!! much to be done in emulators, without geodata i'm also unmotivated.
Many prefer older emulators to fix, has geodata and little critical bugs, example: 3.5 or 4.0.
What about 4.6? I'd play that one if there was a fixed version of that. 5.8 is good, just got annoyed when they released the whole transformation thing which I think was right after.
Edit: Here is a source code https://mega.nz/#!dVoiVCAR!oWq_QrscC...nr8Ning6nGM4Jw
In my opinion this is better, can use and make your corrections.
These files are not my, but posted here on the forum by Shiniori.