change to 10406
... posted by devils phone ...
Printable View
change to 10406
... posted by devils phone ...
After change it says server in maintance.Quote:
Originally Posted by fgru
Any other solve?
gs01.log?
I Have the same problem.Quote:
Hello there,
So i used Mr. Killer's files for creating server. Server seems online problem is: When i try login client says "Wrong account or Password" incorrect account or password. I'm able to see my account on users table. When i try login my consol says:
Code:
GQueryPasswd:account is **** , login ip is -************
Sending query to acquire password
Prepare procedure call:{call acquireuserpasswd(?,?,?)}
Received acquired password
Returning acquired password
Prepare procedure call:{call deleteTimeoutForbid(?)}
TRACE : matrixpasswd NOT usbbind user **
Have a nice days and thank you for reading :)
I downloaded the auth posted bu fgru and take the same problem than Latyos "server network error".Quote:
change to 10406
where I change the glink? I don´t tried this yet, so I don´t know if this step will work to me or if I´ll take the third error like Latyos in last post him.
the Auth log register this:
authd:: add PollIO task.
gauthd: 17 Jul 2013 22:19:45,214 INFO GAuthServer:44 - authd:: add PollIO task.
gauthd: 17 Jul 2013 22:20:03,411 INFO GAuthServer:? - GAuthServer::OnAddSession com.goldhuman.IO.Protocol.Session@7c4c51
gauthd: 17 Jul 2013 22:20:03,944 INFO GAuthServer:? - AnnounceZoneid3, clear all online records on zone 1
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: FUNCTION pw.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:3283)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:882)
at com.mysql.jdbc.CallableStatement.execute(CallableStatement.java:759)
at application.procedure.handler.execute(Unknown Source)
at com.goldhuman.account.storage.clearOnlineRecords(Unknown Source)
at protocol.AnnounceZoneid3.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:679)
gauthd: 17 Jul 2013 22:20:04,023 INFO GAuthServer:? - AnnounceZoneid3, aid=1,zoneid=1,ip1=0.0.0.0,ip2=0.0.0.0,ip3=0.0.0.0
ThreadPool thread LinkedList == null: no Match priority(101)
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: FUNCTION pw.usecash 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:3283)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:882)
at com.mysql.jdbc.CallableStatement.execute(CallableStatement.java:759)
at application.procedure.handler.execute(Unknown Source)
at com.goldhuman.account.storage.useCash(Unknown Source)
at protocol.GAuthServer$1.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
gauthd: 17 Jul 2013 22:24:44,181 INFO GAuthServer:? - UseCashTimerTask: status=0,userid=32,zoneid=1,sn=-1,ret=-1
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: FUNCTION pw.usecash 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:3283)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:882)
at com.mysql.jdbc.CallableStatement.execute(CallableStatement.java:759)
at application.procedure.handler.execute(Unknown Source)
at com.goldhuman.account.storage.useCash(Unknown Source)
at protocol.GAuthServer$1.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
gauthd: 17 Jul 2013 22:24:44,189 INFO GAuthServer:? - UseCashTimerTask: status=0,userid=48,zoneid=1,sn=-1,ret=-1
How can you see in image, in mysql pw database the procedure usecash exists.
Attachment 134857
this your problemQuote:
Originally Posted by EndyBH
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: FUNCTION pw.clearonlinerecords does not exist
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: FUNCTION pw.usecash does not exist
You saw the photo of my mysql procedures? please pay attention before giving vague answer. Although I was careful to post the picture of the list of existing procedures in my database, for a member not bother to look for it. Someone would have something better to say? all the evidence contained in my post, if you need more evidence please tell me where so I can PROVIDENCE them. thank youQuote:
Originally Posted by ninekinsen
so, why you got that's error?? if you're correctly??Quote:
Originally Posted by EndyBH
check all configuration, host, authd.conf, table.xml , etc
Because I've checked all these things. So I'm here at RaGEZONE for help. Also I do not understand why I'm having these problems.Quote:
Originally Posted by ninekinsen
@EndyBH
When you change 10406 it will say server maintance instead of wrong password. When i change authd i got same error too. I'm waiting newer files to build new server.
Edit: If you still want to try solution just go Services>glinkd and there must be a config file. Open it and version must be 10407 change it to 10406.
You only need to reset the server. it works fine
@Latyos, thank you for shared information,
I tried, but don´t work yet. You´re right.
After restarting server it waits Logging in Server and after that says Server Network Error. Server still seems online but authd still has problems.Quote:
Originally Posted by Psytrac
I did some changes now i don't get error but still can't connect
no error as you seeCode:-----> Starting service authd. <-----
----->The service has started successfully!<-----
... " Server Network Error " ... 100% table.xml db / user / passwd problem
- 343 says
Spoiler:
The auth one you gave me hasn't got table.xml. I included it myselfQuote:
Originally Posted by fgru
