[Guide] Jade Dynasty - Ubuntu, MySQL - On a Remote Server

[steel97]

how to start this server on windows

 

[xAtticusx]

how to start this server on windows

You can't.

 

[SLIPLV]

And where do i get a client for this, read that TTGN client should work on this but i can't find it.

 

[Beloved]

there is something wrong with links >.<

 

[xAtticusx]

Links were deleted by Dropbox, I don't have replacements.

 

[xAtticusx]

Files re-uploaded! Enjoy [:

 

[Abuhda]

I just bought a vps and tried to transfer my server files using your guide for somehow keep getting this error.

authd:: add PollIO task.
Cannot load common data automation crontab. check file commondataauto.txt.
District id is 0
TRACE : gdeliveryd::Max player allowed is 10000
zoneid=1  aid=11
TRACE : ContestManager initialized
info : logclienttcp: OnAbortSession
TRACE : gdelivery::connect to gauthd successfully.
info : logclient: OnAddSession
TRACE : ganticheatclient:: connect gacd successfully!
err : gdelivery:: connect GameDB failed
GAuthServer::OnAddSession com.goldhuman.IO.Protocol.Session@1a06e38
gauthd: 03 May 2011 12:55:09,158  INFO GAuthServer:? - AnnounceZoneid2, clear all online records on zone 1
Prepare procedure call:{call clearonlinerecords(?,?)}
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: FUNCTION clearonlinerecords does not exist
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3206)
        at com.mysql.jdbc.Statement.executeQuery(Statement.java:1232)
        at com.mysql.jdbc.DatabaseMetaData.getCallStmtParameterTypes(DatabaseMetaData.java:1607)
        at com.mysql.jdbc.DatabaseMetaData.getProcedureColumns(DatabaseMetaData.java:4034)
        at com.mysql.jdbc.CallableStatement.determineParameterTypes(CallableStatement.java:709)
        at com.mysql.jdbc.CallableStatement.<init>(CallableStatement.java:513)
        at com.mysql.jdbc.Connection.parseCallableStatement(Connection.java:4583)
        at com.mysql.jdbc.Connection.prepareCall(Connection.java:4657)
        at com.mysql.jdbc.Connection.prepareCall(Connection.java:4631)
        at application.procedure.handler.execute(handler.java:189)
        at com.goldhuman.account.storage.clearOnlineRecords(storage.java:849)
        at protocol.AnnounceZoneid2.Process(Unknown Source)
        at com.goldhuman.IO.Protocol.Task.run(Unknown Source)
        at com.goldhuman.Common.ThreadPool.run(Unknown Source)
        at java.lang.Thread.run(Thread.java:619)
gauthd: 03 May 2011 12:55:09,186  INFO GAuthServer:? - AnnounceZoneid2, zone 1  aid 11 announced.
info : logclienttcp: OnAbortSession
err : gdelivery:: connect GameDB failed
./stinfo : logclienttcp: OnAbortSession
info : logclient: OnAddSession
operr : gdelivery:: connect GameDB failed                                    info : logclienttcp: OnAbortSession
info : logclienttcp: OnAbortSession
err : gdelivery:: connect GameDB failed
err : Initialize storage environment failed.
err : gdelivery:: connect GameDB failed
info : logclienttcp: OnAbortSession
err : gdelivery:: connect GameDB failed
Bye.
err : Disconnect from linkserver sid=23, drop 0 users
err : gdelivery:: connect GameDB failed

 

[xAtticusx]

Update your JDK.

 

[Abuhda]

fix it I notice my db.sql is the one having the problem so i download a new one and upload it to database

right now im having this problem

Spoiler

err : gdelivery:: connect GameDB failed
err : gdelivery:: connect GameDB failed
err : gdelivery:: connect GameDB failed
err : gdelivery:: connect GameDB failed
err : gdelivery:: connect GameDB failed
TRACE : checkpoint begin.
TRACE : checkpoint end.
err : gdelivery:: connect GameDB failed
err : gdelivery:: connect GameDB failed
err : gdelivery:: connect GameDB failed
err : gdelivery:: connect GameDB failed
TRACE : GetWeeklyTop: received, index=0
TRACE : GetDailyTop: received, index=1
err : gamed: GetWeekTop err, retcode=1, index=0
TRACE : GetWeeklyTop: received, index=1
err : gamed: GetWeekTop err, retcode=1, index=1
TRACE : GetWeeklyTop: received, index=2
err : gamed: GetWeekTop err, retcode=1, index=2
TRACE : GetWeeklyTop: received, index=3
err : gamed: GetWeekTop err, retcode=1, index=3
TRACE : GetWeeklyTop: received, index=4
err : gamed: GetWeekTop err, retcode=1, index=4
TRACE : GetWeeklyTop: received, index=5
err : gamed: GetWeekTop err, retcode=1, index=5
TRACE : GetWeeklyTop: received, index=6
err : gamed: GetWeekTop err, retcode=1, index=6
TRACE : GetWeeklyTop: received, index=7
err : gamed: GetWeekTop err, retcode=1, index=7
TRACE : GetWeeklyTop: received, index=8
err : gamed: GetWeekTop err, retcode=1, index=8
TRACE : GetWeeklyTop: received, index=9
err : gamed: GetWeekTop err, retcode=1, index=9
TRACE : GetWeeklyTop: received, index=10
err : gamed: GetWeekTop err, retcode=1, index=10
TRACE : GetWeeklyTop: received, index=11
err : gamed: GetWeekTop err, retcode=1, index=11
TRACE : GetWeeklyTop: received, index=12
err : gamed: GetWeekTop err, retcode=1, index=12
TRACE : GetWeeklyTop: received, index=13
err : gamed: GetWeekTop err, retcode=1, index=13
TRACE : GetWeeklyTop: received, index=14
err : gamed: GetWeekTop err, retcode=1, index=14
TRACE : GetWeeklyTop: received, index=15
err : gamed: GetWeekTop err, retcode=1, index=15
TRACE : GetWeeklyTop: received, index=16
err : gamed: GetWeekTop err, retcode=1, index=16
TRACE : GetWeeklyTop: received, index=17
err : gamed: GetWeekTop err, retcode=1, index=17
TRACE : GetWeeklyTop: received, index=18
err : gamed: GetWeekTop err, retcode=1, index=18
TRACE : GetWeeklyTop: received, index=19
err : gamed: GetWeekTop err, retcode=1, index=19
TRACE : GetWeeklyTop: received, index=20
err : gamed: GetWeekTop err, retcode=1, index=20
TRACE : GetWeeklyTop: received, index=21
err : gamed: GetWeekTop err, retcode=1, index=21
TRACE : GetWeeklyTop: received, index=22
err : gamed: GetWeekTop err, retcode=1, index=22
TRACE : GetWeeklyTop: received, index=23
err : gamed: GetWeekTop err, retcode=1, index=23
TRACE : GetWeeklyTop: received, index=24
err : gamed: GetWeekTop err, retcode=1, index=24
TRACE : GetWeeklyTop: received, index=25
err : gamed: GetWeekTop err, retcode=1, index=25
TRACE : GetWeeklyTop: received, index=26
err : gamed: GetWeekTop err, retcode=1, index=26
TRACE : GetWeeklyTop: received, index=27
err : gamed: GetWeekTop err, retcode=1, index=27
TRACE : GetWeeklyTop: received, index=28
err : gamed: GetWeekTop err, retcode=1, index=28
TRACE : GetWeeklyTop: received, index=29
err : gamed: GetWeekTop err, retcode=1, index=29
TRACE : GetWeeklyTop: received, index=30
err : gamed: GetWeekTop err, retcode=1, index=30
TRACE : GetWeeklyTop: received, index=31
err : gamed: GetWeekTop err, retcode=1, index=31
TRACE : GetWeeklyTop: received, index=32
err : gamed: GetWeekTop err, retcode=1, index=32
TRACE : GetWeeklyTop: received, index=33
err : gamed: GetWeekTop err, retcode=1, index=33
TRACE : GetWeeklyTop: received, index=34
err : gamed: GetWeekTop err, retcode=1, index=34
TRACE : GetWeeklyTop: received, index=35
err : gamed: GetWeekTop err, retcode=1, index=35
TRACE : GetWeeklyTop: received, index=36
err : gamed: GetWeekTop err, retcode=1, index=36
TRACE : GetWeeklyTop: received, index=37
err : gamed: GetWeekTop err, retcode=1, index=37
TRACE : GetWeeklyTop: received, index=38
err : gamed: GetWeekTop err, retcode=1, index=38
TRACE : GetWeeklyTop: received, index=39
err : gamed: GetWeekTop err, retcode=1, index=39
TRACE : GetWeeklyTop: received, index=40
err : gamed: GetWeekTop err, retcode=1, index=40
TRACE : GetWeeklyTop: received, index=41
err : gamed: GetWeekTop err, retcode=1, index=41
TRACE : GetWeeklyTop: received, index=42
err : gamed: GetWeekTop err, retcode=1, index=42
TRACE : GetWeeklyTop: received, index=43
err : gamed: GetWeekTop err, retcode=1, index=43
TRACE : GetWeeklyTop: received, index=44
err : gamed: GetWeekTop err, retcode=1, index=44
err : gdelivery:: connect GameDB failed
err : gdelivery:: connect GameDB failed
err : gdelivery:: connect GameDB failed
err : gdelivery:: connect GameDB failed

thanks for replaying,..

 

[john007]

Okay I am noob with Ubuntu, before I am setting up this, i have all the downloaded files needed. now i burn that Ubuntu iso into and cd and start install it on another partitions. so, I have to install Mysql, and put those winscp and putty on my Utubun OS? does Ubuntu can plays Jade Dynasty client oo? or just act as a server? lol I am planning to host and play at the same time here. if any helps would be great.

EDIT: nvm i did some research on google and found the answers to how to play JD on Ubuntu with Wine installed it lol.

EDIT2: should i get MYSQL for mac/linux instead of windows when installing on Utuntu?

 

[xAtticusx]

When installing MySQL use the command:

apt-get install mysql5

If you don't know what I'm talking about, then you're using ubuntu desktop.

 

[OldSchool]

When installing MySQL use the command:
apt-get install mysql5

to make it simple in order to use commands like these you would need to be in a terminal etc.so dont even think about playing with Linux terminals as it might be tricky and ubuntu updates are tricky therefore simply use 1 of 2 methods.

Synaptic package manager (u can type what u need) and hit all dependencies related to the aplication u need installed.

Or

On newer versions of ubuntu simply do the same as windows (add apps on main menu)


Regarding Playing the game the only way to emulate the game is by using software like Wine (emulates windows ability of running executable files) keep in mind tho that the FPS will never be the same.

Have fun.

 

[Abuhda]

From somehow on ubuntu realm name are not working anyway to fix this?

 

[xAtticusx]

From somehow on ubuntu realm name are not working anyway to fix this?

I have a feeling it's something to do with the files, not distro.

 

[Abuhda]

i did check the file there seems nothing to be wrong
I also seen some other people having problem the same as mine

 

[john007]

so, we can use 1.3.6 client with this server files? and I am just wondering why there isn't any English one on this forum lol. but maybe there's will be one on google from the official server.

 

[xAtticusx]

As I said, I was working on a compatible client for these files, but because of other commitments, I've had to discontinue my work. You should, however, be able to adapt the Celestial Destroyer client to work, but it'll take a lot of trial and error to get the files to work with each other.

 

[flyingwater]

chmod -R 0755 /usr/rain won't work, it keeps saying directory not found. and i'm using putty, i found out i don't really need to do that

now how do i connect navicat to my ubuntu mysql, cuz its not working, do i go to the ssh tab, tried it didn't work

 

[xAtticusx]

You have to allow external connections to your MySQL server. This guide should work:

You must be registered to see links

 

[araycool7]

errrr...how to create character in game?