ScreenShot of the problem.

[NoName123456]

Hallo ragezone,
Sorry for the repost but I thought this would be a clean post with ss.

My problem is that my server doesnt allow me to login before few(1-2) mins and I loose my gm power and sometimes it tells me (Server network Error)

Here is the logs.

*I got 3(they all show server network error, the second one is more accurate.
1-

http://postimg.org/image/bk29nv6i1/

2-

http://postimg.org/image/l2vi3fhy5/

3-

http://postimg.org/image/orv353w29/

They are all the same but it is just some secs diffrence, The log spams..
4-This is where I loose my gm power and take time to login

http://postimg.org/image/5qjfrqkjj/

Looking forward to any help or suggestions. Thanks.

Edit:---

I did do some researches and looks like this problem has been experienced alot by many.But I still couldn't find any answer.

[MentaL]

[argonaut]

Server network error is always a problem with AUTHD and MySQL being able to 'communicate' with each other.
Some ideas to start at:
/etc/table.xml (check this is correct password, ip and username for mysql)..or..Java is bugged, Authd is bugged, GDeliveryd isnt connecting correctly theres many.

Check: /PWServer/authd/authd
Make sure every path is correct to your java folder.
Make sure you use the right "mysql-connector-java-5.0.8-bin.jar".

You will have to dig around.

[NoName123456]

Server network error is always a problem with AUTHD and MySQL being able to 'communicate' with each other.
Some ideas to start at:
/etc/table.xml (check this is correct password, ip and username for mysql)..or..Java is bugged, Authd is bugged, GDeliveryd isnt connecting correctly theres many.

Check: /PWServer/authd/authd
Make sure every path is correct to your java folder.
Make sure you use the right "mysql-connector-java-5.0.8-bin.jar".

You will have to dig around.

I think its all fine.
(Etc/table.xml)

<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet type="text/xsl" href="table.xsl"?>

<application debug="false" >

<driver name="com.mysql.jdbc.Driver" />
<connection name="auth0" poolsize="3" url="jdbc:mysql://localhost:3306/pw?useUnicode=true&amp;characterEncoding=ascii&amp;zeroDateTimeBehavior=convertToNull&amp;transformedBitIsBoolean=true" username="root" password="root"/>

<table name="users" connection="auth0" operate="replaceA">
    <column name="id"           sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
    <column name="name"         sql-type="varchar(32)" java-type="java.lang.String"  not-null="true" />
    <column name="passwd"       sql-type="binary(16)"  java-type="java.lang.reflect.Array"  not-null="true" />
    <column name="prompt"       sql-type="varchar(32)" java-type="java.lang.String"  not-null="true" />
    <column name="answer"       sql-type="varchar(32)" java-type="java.lang.String"  not-null="true" />
    <column name="truename"     sql-type="varchar(32)" java-type="java.lang.String"  not-null="true" />
    <column name="idnumber"     sql-type="varchar(32)" java-type="java.lang.String"  not-null="true" />
    <column name="email"        sql-type="varchar(64)" java-type="java.lang.String"  not-null="true" />
    <column name="mobilenumber" sql-type="varchar(32)" java-type="java.lang.String"  not-null="false" />
    <column name="province"     sql-type="varchar(32)" java-type="java.lang.String"  not-null="false" />
    <column name="city"         sql-type="varchar(32)" java-type="java.lang.String"  not-null="false" />
    <column name="phonenumber"  sql-type="varchar(32)" java-type="java.lang.String"  not-null="false" />
    <column name="address"      sql-type="varchar(64)" java-type="java.lang.String"  not-null="false" />
    <column name="postalcode"   sql-type="varchar(8)"  java-type="java.lang.String"  not-null="false" />
    <column name="gender"       sql-type="integer"     java-type="java.lang.Integer" not-null="false" />
    <column name="birthday"     sql-type="datetime"    java-type="java.util.Date"    not-null="false" />
    <column name="creatime"     sql-type="datetime"    java-type="java.util.Date"    not-null="true" />
    <column name="qq"           sql-type="varchar(32)" java-type="java.lang.String"  not-null="false" />
    <column name="passwd2"      sql-type="binary(16)"  java-type="java.lang.reflect.Array"  not-null="false" />

    <primarykey name="pk_id" column="id" />
    <index name="ind_name" unique="true" column="name" />
    <index name="ind_creatime" column="creatime" />
</table>

<table name="iplimit" connection="auth0" operate="replaceA">
    <column name="uid"          sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
    <column name="ipaddr1"      sql-type="integer"     java-type="java.lang.Integer" not-null="false" />
    <column name="ipmask1"      sql-type="varchar(2)"  java-type="java.lang.String" not-null="false" />
    <column name="ipaddr2"      sql-type="integer"     java-type="java.lang.Integer" not-null="false" />
    <column name="ipmask2"      sql-type="varchar(2)"  java-type="java.lang.String" not-null="false" />
    <column name="ipaddr3"      sql-type="integer"     java-type="java.lang.Integer" not-null="false" />
    <column name="ipmask3"      sql-type="varchar(2)"  java-type="java.lang.String" not-null="false" />
    <column name="enable"       sql-type="char(1)"     java-type="java.lang.String" not-null="false" />
    <column name="lockstatus"   sql-type="char(1)"     java-type="java.lang.String" not-null="false" />

    <primarykey name="pk_iplimit" column="uid" />
</table>

<table name="auth" connection="auth0" operate="replaceA">
    <column name="userid"       sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
    <column name="zoneid"          sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
    <column name="rid"          sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
    <primarykey name="pk_id" column="userid, zoneid, rid" />
</table>

<table name="forbid" connection="auth0" operate="replaceA">
    <column name="userid"       sql-type="integer"      java-type="java.lang.Integer" not-null="true" />
    <column name="type"            sql-type="integer"      java-type="java.lang.Integer" not-null="true" />
    <column name="ctime"        sql-type="datetime"     java-type="java.util.Date"      not-null="true" />
    <column name="forbid_time"  sql-type="integer"      java-type="java.lang.Integer" not-null="true" />
    <column name="reason"     sql-type="varbinary(255)" java-type="java.lang.reflect.Array" not-null="true" />
    <column name="gmroleid"     sql-type="integer"      java-type="java.lang.Integer" not-null="false"/>

    <primarykey name="pk_id" column="userid,type" />
</table>

<table name="point" connection="auth0" operate="replaceA">
    <column name="uid"          sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
    <column name="aid"          sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
    <column name="time"         sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
    <column name="zoneid"       sql-type="integer"     java-type="java.lang.Integer" not-null="false" />
    <column name="zonelocalid"  sql-type="integer"     java-type="java.lang.Integer" not-null="false" />
    <column name="accountstart" sql-type="datetime"    java-type="java.util.Date"    not-null="false" />
    <column name="lastlogin"    sql-type="datetime"    java-type="java.util.Date"    not-null="false" />
    <column name="enddate"      sql-type="datetime"    java-type="java.util.Date"    not-null="false" />

    <primarykey name="pk_id" column="uid, aid" />
    <index name="ind_aid" column="aid,zoneid" />
</table>

<table name="usecashnow" connection="auth0" operate="replaceA">
    <column name="userid" sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
    <column name="zoneid" sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
    <column name="sn"     sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
    <column name="aid"    sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
    <column name="point"  sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
    <column name="cash"   sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
    <!--status 1.create; 2.get sn; 3.send addcash; 4.finish; -->
    <column name="status" sql-type="integer"  java-type="java.lang.Integer" not-null="true"/>
    <column name="creatime" sql-type="datetime" java-type="java.util.Date"  not-null="true"/>

    <primarykey name="pk_usecashnow" column="userid, zoneid, sn" />
    <index name="ind_usecashnow_status" column="status" />
    <index name="ind_usecashnow_creatime" column="creatime" />
</table>

<table name="usecashlog" connection="auth0" operate="replaceA">
    <column name="userid" sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
    <column name="zoneid" sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
    <column name="sn"     sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
    <column name="aid"    sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
    <column name="point"  sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
    <column name="cash"   sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
    <column name="status" sql-type="integer"  java-type="java.lang.Integer" not-null="true"/>
    <column name="creatime" sql-type="datetime" java-type="java.util.Date"  not-null="true"/>
    <column name="fintime" sql-type="datetime" java-type="java.util.Date"  not-null="true"/>

    <index name="ind_usecashlog_uzs" column="userid, zoneid, sn" />
    <index name="ind_usecashlog_creatime" column="creatime" />
</table>

<query name="getUserid">
    <table name="users" alias="u" />
    <column name="id" column="u.id" />
    <select name="byName" condition="WHERE u.name = ?" />
</query>

<query name="getUserInfo">
    <table name="users" alias="u" />
    <column name="id" column="u.id" />
    <column name="prompt" column="u.prompt" />
    <column name="answer" column="u.answer" />
    <column name="truename" column="u.truename" />
    <column name="idnumber" column="u.idnumber" />
    <column name="email" column="u.email" />
    <column name="mobilenumber" column="u.mobilenumber" />
    <column name="province" column="u.province" />
    <column name="city" column="u.city" />
    <column name="phonenumber" column="u.phonenumber" />
    <column name="address" column="u.address" />
    <column name="postalcode" column="u.postalcode" />
    <column name="gender" column="u.gender" />
    <column name="birthday" column="u.birthday" />
    <column name="creatime" column="u.creatime" />
    <column name="qq" column="u.qq" />
    <select name="byName" condition="WHERE u.name = ?" />
</query>

<query name="getUsername">
    <table name="users" alias="u" />
    <column name="name" column="u.name" />
    <select name="byId" condition="WHERE u.id = ?"/>
</query>

<query name="acquireIdPasswd">
    <table name="users" alias="u" />
    <column name="id" column="u.id" />
    <column name="passwd" column="u.passwd" />
    <column name="creatime" column="u.creatime" />
    <select name="byName" condition="WHERE u.name = ?"/>
</query>

<query name="acquireIdPasswd2">
    <table name="users" alias="u" />
    <column name="id" column="u.id" />
    <column name="passwd2" column="u.passwd2" />
    <select name="byName" condition="WHERE u.name = ?"/>
</query>

<query name="acquireUserCreatime">
    <table name="users" alias="u" />
    <column name="creatime" column="u.creatime" />
    <select name="byUid" condition="WHERE u.id = ?"/>
</query>

<query name="getIPLimit">
    <table name="iplimit" alias="i" />
    <column name="uid" column="i.uid" />
    <column name="ipaddr1" column="i.ipaddr1" />
    <column name="ipmask1" column="i.ipmask1" />
    <column name="ipaddr2" column="i.ipaddr2" />
    <column name="ipmask2" column="i.ipmask2" />
    <column name="ipaddr3" column="i.ipaddr3" />
    <column name="ipmask3" column="i.ipmask3" />
    <column name="enablue" column="i.enable" />
    <column name="lockstatus" column="i.lockstatus" />
    <select name="byUid" condition="WHERE i.uid = ?"/>
</query>

<query name="acquireUserPrivilege">
    <table name="auth" alias="au" />
    <column name="rid" column="au.rid" />
    <select name="byUidZid" condition="WHERE au.userid = ? AND au.zoneid = ?"/>
</query>

<query name="acquirePrivilege">
    <table name="auth" alias="au" />
    <table name="users" alias="users" />
    <column name="userid" column="au.userid" />
    <column name="zoneid" column="au.zoneid" />
    <column name="rid" column="au.rid" />
    <column name="name" column="users.name" />
    <column name="creatime" column="users.creatime" />
    <select name="byZid" condition="WHERE au.userid = users.id AND au.zoneid = ?"/>
    <select name="byUid" condition="WHERE au.userid = users.id AND au.userid = ?"/>
    <select name="byUidZid" condition="WHERE au.userid = users.id AND au.userid = ? AND au.zoneid = ?"/>
    <select name="byRidZid" condition="WHERE au.userid = users.id AND au.rid = ? AND au.zoneid = ?"/>
    <select name="byAll" condition="WHERE au.userid = users.id"/>
</query>

<query name="acquireForbid">
    <table name="forbid" alias="fb"/>
    <column name="userid" column="fb.userid"/>
    <column name="type" column="fb.type"/>
    <column name="ctime" column="fb.ctime"/>
    <column name="forbid_time" column="fb.forbid_time"/>
    <column name="reason" column="fb.reason"/>
    <column name="gmroleid" column="fb.gmroleid"/>
    <select name="byUid" condition="WHERE fb.userid = ? and time_to_sec(timediff(Now(),fb.ctime))&lt;=fb.forbid_time"/>
</query>

<query name="getUserOnlineInfo">
    <table name="point" alias="p"/>
    <column name="zoneid" column="p.zoneid"/>
    <column name="localsid" column="p.zonelocalid"/>
    <column name="aid" column="p.aid"/>
    <select name="byUid" condition="WHERE p.uid = ?"/>
</query>

<query name="getUserPoints">
    <table name="point" alias="p" />
    <column name="aid" column="p.aid" />
    <column name="time" column="p.time" />
    <column name="enddate" column="p.enddate" />
    <select name="byuid" condition="where p.uid=? and NOT p.aid=0" />
</query>

<query name="getusecashnow">
    <table name="usecashnow" alias="u"/>
    <column name="userid" column="u.userid"/>
    <column name="zoneid" column="u.zoneid"/>
    <column name="sn" column="u.sn"/>
    <column name="aid" column="u.aid"/>
    <column name="point" column="u.point"/>
    <column name="cash" column="u.cash"/>
    <column name="status" column="u.status"/>
    <column name="creatime" column="u.creatime"/>

    <select name="bystatus" condition="WHERE status = ? AND creatime &lt; date_add(now(), INTERVAL '-200' SECOND)"/>
    <select name="byuserzone" condition="WHERE u.userid = ? AND u.zoneid = ?"/>
    <select name="byuserzonesn" condition="WHERE u.userid = ? AND u.zoneid = ? AND u.sn = ?"/>
    <select name="byuser" condition="WHERE u.userid = ?"/>
</query>

<query name="getusecashlog">
    <table name="usecashlog" alias="u"/>
    <column name="userid" column="u.userid"/>
    <column name="zoneid" column="u.zoneid"/>
    <column name="sn" column="u.sn"/>
    <column name="aid" column="u.aid"/>
    <column name="point" column="u.point"/>
    <column name="cash" column="u.cash"/>
    <column name="status" column="u.status"/>
    <column name="creatime" column="u.creatime"/>
    <column name="fintime" column="u.fintime"/>

    <select name="byuserzone" condition="WHERE u.userid = ? AND u.zoneid = ?"/>
    <select name="byuserzonesn" condition="WHERE u.userid = ? AND u.zoneid = ? AND u.sn = ?"/>
    <select name="byuser" condition="WHERE u.userid = ?"/>
</query>

<procedure name="acquireuserpasswd" connection="auth0" operate="replaceA">
 <parameter name="name1"     sql-type="varchar(64)"  java-type="java.lang.String"  in="true"  out="false" />
 <parameter name="uid1"      sql-type="integer"      java-type="java.lang.Integer" in="false" out="true" />
 <parameter name="passwd1"   sql-type="varchar(64)"  java-type="java.lang.String"  in="false" out="true" />
</procedure>

<procedure name="adduser" connection="auth0" operate="replaceA">
    <parameter name="name"     sql-type="varchar(64)"  java-type="java.lang.String" in="true" out="false" />
    <parameter name="passwd"   sql-type="binary(16)"   java-type="java.lang.reflect.Array" in="true" out="false" />
    <parameter name="prompt"   sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="answer"   sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="truename" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="idnumber" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="email"    sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="mobilenumber" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="province" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="city"     sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="phonenumber"  sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="address"  sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="postalcode"   sql-type="varchar(8)"  java-type="java.lang.String" in="true" out="false" />
    <parameter name="gender"   sql-type="integer"  java-type="java.lang.Integer" in="true" out="false" />
    <parameter name="birthday" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="qq"       sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="passwd2"  sql-type="binary(16)" java-type="java.lang.reflect.Array" in="true" out="false" />
</procedure>

<procedure name="updateUserInfo" connection="auth0" operate="replaceA">
    <parameter name="name"     sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="prompt"   sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="answer"   sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="truename" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="idnumber" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="email"    sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="mobilenumber" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="province" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="city"     sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="phonenumber"  sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="address"  sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="postalcode"   sql-type="varchar(8)"  java-type="java.lang.String" in="true" out="false" />
    <parameter name="gender"   sql-type="integer"    java-type="java.lang.Integer" in="true" out="false" />
    <parameter name="birthday" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="qq"       sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
</procedure>

<procedure name="changePasswd" connection="auth0" operate="replaceA">
    <parameter name="name"   sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="passwd" sql-type="binary(16)" java-type="java.lang.reflect.Array" in="true" out="false" />
</procedure>

<procedure name="changePasswd2" connection="auth0" operate="replaceA">
    <parameter name="name" sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" />
    <parameter name="passwd2" sql-type="binary(16)" java-type="java.lang.reflect.Array" in="true" out="false" />
</procedure>

<procedure name="setiplimit" connection="auth0" operate="replaceA">
    <parameter name="uid"      sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
    <parameter name="ipaddr1"  sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
    <parameter name="ipmask1"  sql-type="varchar(2)"  java-type="java.lang.String" in="true" out="false"/>
    <parameter name="ipaddr2"  sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
    <parameter name="ipmask2"  sql-type="varchar(2)"  java-type="java.lang.String" in="true" out="false"/>
    <parameter name="ipaddr3"  sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
    <parameter name="ipmask3"  sql-type="varchar(2)"  java-type="java.lang.String" in="true" out="false"/>
</procedure>

<procedure name="enableiplimit" connection="auth0" operate="replaceA">
    <parameter name="uid"      sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
    <parameter name="enable"   sql-type="char(1)"     java-type="java.lang.String" in="true" out="false"/>
</procedure>

<procedure name="lockuser" connection="auth0" operate="replaceA">
    <parameter name="uid"      sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
    <parameter name="lockstatus"   sql-type="char(1)"     java-type="java.lang.String" in="true" out="false"/>
</procedure>

<procedure name="addUserPriv" connection="auth0" operate="replaceA">
    <parameter name="userid"   sql-type="integer"  java-type="java.lang.Integer"   in="true" out="false" />
    <parameter name="zoneid"   sql-type="integer"  java-type="java.lang.Integer"   in="true" out="false" />
    <parameter name="rid"      sql-type="integer"  java-type="java.lang.Integer"   in="true" out="false" />
</procedure>

<procedure name="delUserPriv" connection="auth0" operate="replaceA">
    <parameter name="userid"   sql-type="integer"  java-type="java.lang.Integer"   in="true" out="false" />
    <parameter name="zoneid"   sql-type="integer"  java-type="java.lang.Integer"   in="true" out="false" />
    <parameter name="rid"      sql-type="integer"  java-type="java.lang.Integer"   in="true" out="false" />
    <parameter name="deltype"  sql-type="integer"  java-type="java.lang.Integer"   in="true" out="false" />
</procedure>

<procedure name="addForbid" connection="auth0" operate="replaceA">
    <parameter name="userid"   sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
    <parameter name="type"     sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
    <!--parameter name="ctime" sql-type="datetime"    java-type="java.util.Date"     in="true" out="false"/-->
    <parameter name="forbid_time" sql-type="integer"  java-type="java.lang.Integer" in="true" out="false"/>
    <parameter name="reason"   sql-type="varbinary(255)" java-type="java.lang.reflect.Array"  in="true" out="false"/>
    <parameter name="gmroleid" sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
</procedure>

<procedure name="deleteTimeoutForbid" connection="auth0" operate="replaceA">
    <parameter name="userid"    sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/>
</procedure>

<procedure name="clearonlinerecords" connection="auth0" operate="replaceA">
    <parameter name="zoneid"   sql-type="integer"  java-type="java.lang.Integer"     in="true"  out="false" />
    <parameter name="aid"      sql-type="integer"  java-type="java.lang.Integer"     in="true"  out="false" />
</procedure>

<procedure name="recordonline" connection="auth0" operate="replaceA">
    <parameter name="uid"      sql-type="integer"  java-type="java.lang.Integer"     in="true"  out="false" />
    <parameter name="aid"      sql-type="integer"  java-type="java.lang.Integer"     in="true"  out="false" />
    <parameter name="zoneid"   sql-type="integer"  java-type="java.lang.Integer"     in="true"  out="true" />
    <parameter name="zonelocalid" sql-type="integer"  java-type="java.lang.Integer"  in="true"  out="true" />
    <parameter name="overwrite" sql-type="integer"  java-type="java.lang.Integer"    in="true"  out="true"  />
</procedure>

<procedure name="recordoffline" connection="auth0" operate="replaceA">
    <parameter name="uid"      sql-type="integer"  java-type="java.lang.Integer"     in="true"  out="false" />
    <parameter name="aid"      sql-type="integer"  java-type="java.lang.Integer"     in="true"  out="false" />
    <parameter name="zoneid"   sql-type="integer"  java-type="java.lang.Integer"     in="true"  out="true" />
    <parameter name="zonelocalid" sql-type="integer"  java-type="java.lang.Integer"  in="true"  out="true" />
    <parameter name="overwrite" sql-type="integer"  java-type="java.lang.Integer"    in="true"  out="true" />
</procedure>

<procedure name="remaintime" connection="auth0" operate="replaceA">
    <parameter name="uid"      sql-type="integer"  java-type="java.lang.Integer"    in="true"  out="false" />
    <parameter name="aid"      sql-type="integer"  java-type="java.lang.Integer"    in="true"  out="false" />
    <parameter name="remain"   sql-type="integer"  java-type="java.lang.Integer"    in="false" out="true" />
    <parameter name="freetimeleft" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" />
</procedure>

<procedure name="adduserpoint" connection="auth0" operate="replaceA">
    <parameter name="uid"      sql-type="integer"  java-type="java.lang.Integer"    in="true"  out="false" />
    <parameter name="aid"      sql-type="integer"  java-type="java.lang.Integer"    in="true"  out="false" />
    <parameter name="time"     sql-type="integer"  java-type="java.lang.Integer"    in="true"  out="false" />
</procedure>

<procedure name="usecash" connection="auth0" operate="replaceA">
    <parameter name="userid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/>
    <parameter name="zoneid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/>
    <parameter name="sn"     sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/>
    <parameter name="aid"    sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/>
    <parameter name="point"  sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/>
    <parameter name="cash"   sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/>
    <parameter name="status" sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/>
    <parameter name="error"  sql-type="integer" java-type="java.lang.Integer" in="false" out="true"/>
</procedure>

</application>

home/auth/etc/authd/conf

[GAuthServer]
type                =    tcp
port                =    29200
address                =    127.0.0.1
so_sndbuf            =    131072
so_rcvbuf            =    131072
ibuffermax            =    819200
obuffermax            =    819200
tcp_nodelay            =    1
listen_backlog        =    10
mtrace                =    /tmp/mtrace.authd
isec                =    2
iseckey                =    baxiykbpn3fxLqpsdpiodI4iazqjdl
osec                =    2
oseckey                =    baxixD0awqydOtrxjxr8uhzaslmnqh
shared_key            =    baxiIvunkjfjlj0Ckgxzzdfpess5vw

[ThreadPool]
config                =    (1,1)(2,10)(3,1)(102,1)(101,1)
max_queuesize        =    1048576

- - - Updated - - -

''Make sure you use the right "mysql-connector-java-5.0.8-bin.jar"
What do you mean by this?

[elche27]

Even could be the spec of the virtual machine or even the pc wich host the VM lack of power to run correctly the server and provoke so many unknown and known bugs!
The fact: server files 1.5.1 are working acceptably for most of the other persons, so server files (for sure) are not the real problem...some bad configuration or lack of some PW server files fact are for sure the problem.
Mr NoName if you are having too much problem, you should start from zero...if u already did it, start again and take some notes of the issues you get and how you solved it (Could you name it: Error/Solution Notes) so you dont commit again...keep it until u can get an successfull PW server files Working...then share your Notes of Error/Solution so other person as you do not have to go through the same problem :]
Remeber, if you follow step by step some guide here, you shouldn't have any issue which has not been solved before and if you want try other thing...make a back up and take notes before, to can solve it on other try or just dont do it again.
PEACE!

[NoName123456]

I had this error in 5 virtual servers. Every-time I got it I used to re-install my pw server to try and understand whats the problem. This time I am sure I didnot touch the server files. It was all going by smooth and then all of the sudden (after few days of the server running) the error appeared.I cannot keep installing servers causing a wipe for my players.

I have seen many people with this issue but I saw no answers. So this won't just benefit me it would also benefit who ever gets it in future time.

[argonaut]

The authd file, not the authd.conf.
My authd file:

#!/bin/sh
cd /PWServer/authd/build

while true; do

java -cp ../lib/mysql-connector-java-5.0.8-bin.jar:../lib/jio.jar:../lib/application.jar:../lib/commons-collections-3.1.jar:../lib/commons-dbcp-1.2.1.jar:../lib/commons-pool-1.2.jar:../lib/commons-logging-1.0.4.jar:../lib/log4j-1.2.9.jar:.:$CLASSPATH authd /etc/table.xml
sleep 2

done

The authd file has the pathways for the mysql.
Check that the pathway connectors are correct.
I don't ever get this problem anymore as i use my own authd and scripts for rego etc...with minor adjustments to server files of every release.

[NoName123456]

I don't have this directory, Iam using mr.killer release.

Btw Is this correct?
Table.xml
url="jdbc:mysql://localhost:3306/pw?useUnicode=true&characterEncoding=ascii&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true" username="root" password="admin"/>

[hrace009]

I don't have this directory, Iam using mr.killer release.

Btw Is this correct?
Table.xml

<connection name="auth0" password="DBPASSWORD" poolsize="3" url="jdbc:mysql://127.0.0.1:DBPORT/DBNAME?useUnicode=true&amp;characterEncoding=ascii" username="DBUSERNAME"/>

Try that.

or remove the authd, and use authd from 1.4.4

[NoName123456]

<connection name="auth0" password="DBPASSWORD" poolsize="3" url="jdbc:mysql://127.0.0.1:DBPORT/DBNAME?useUnicode=true&amp;characterEncoding=ascii" username="DBUSERNAME"/>

Try that.

or remove the authd, and use authd from 1.4.4

[QUOTE=hrace009;8072521]

<connection name="auth0" password="DBPASSWORD" poolsize="3" url="jdbc:mysql://127.0.0.1:DBPORT/DBNAME?useUnicode=true&amp;characterEncoding=ascii" username="DBUSERNAME"/>

(localhost:DBPORT)=127.0.0.1/3306 right?

Still same problem.

or remove the authd, and use authd from 1.4.4

Where might my authd be located?

- - - Updated - - -

Is it the one in cd /home/auth/build/authd.sh

Looks like it is, here is what I see inside it

#!/bin/shcd /home/auth/build


export HOME=/usr/lib/jvm/java-6-sun-1.6.0.26
export PATH=$HOME/bin:$PATH


export CLASSPATH=.:/usr/lib/jvm/java-6-sun-1.6.0.26/lib/dt.jar:/usr/lib/jvm/java-6-sun-1.6.0.26/lib/tools.jar:/usr/lib/jvm/java-6-sun-1.6.0.26/lib/mysql-connector-java-3.0.16-ga-bin.jar


export JAVA_HOME=/usr/lib/jvm/java-6-sun-1.6.0.26/


java -cp ../lib/mysql-connector-java-5.1.7-bin.jar:.:../lib/jio.jar:../lib/application.jar:../lib/commons-collections-3.1.jar:../lib/commons-dbcp-1.2.1.jar:../lib/commons-pool-1.2.jar:../lib/commons-logging-1.0.4.jar:../lib/log4j-1.2.9.jar:.:$CLASSPATH authd /etc/table.xml

- - - Updated - - -

Hrace@ can you please share the 1.4.4 authd that I might want to replace?

- - - Updated - - -

I just noticed something in the build folder. There is 4 authd files and they don't all have the same configuration of etc/table.xml

authd.eac

http://postimg.org/image/eybhaghz7/

http://postimg.org/image/6wook5y8x/

http://postimg.org/image/coqoebz7x/

http://postimg.org/image/kzkm0lz1r/

http://postimg.org/image/70a9tdxpf/

http://postimg.org/image/48t74ggsj/

Is this ok?

[argonaut]

Hrace@ can you please share the 1.4.4 authd that I might want to replace?

This is the one i have been using ...forever...
authd
This authd is set to 0xmd5, so your scripts will have to be this way also.
I noticed your last authd was set to username"root" password"root" so i have set this one to reflect your own settings.
Good luck :)

[NoName123456]

Thanks, Am trying it now.

- - - Updated - - -

Btw, I used to start my server from a script located at cd / . Would that be the problem?

- - - Updated - - -

I wasnt starting it from the one that came with the server.

- - - Updated - - -

Now I get incorrect username or password as replacing ur auth and restarting the server.

- - - Updated - - -

http://postimg.org/image/d198pnjjj/

[argonaut]

Probably because the authd looks for an 0xmd5 hash in the database to which your script is probably not encoding this way...unfortunately i have to go off to work, however if you still have problems later then i can upload my scripts...either that or use an authd that looks for base64 or the other (i only use 0xmd5)

[NoName123456]

I will try several things and post my feedback soon.

[argonaut]

Fyi, i used a registration script written by Renan, it's available on the forums..now i use any old script and just change the hash coding to 0xmd5.
I'm not a coder so it's quite easy to accomplish.
You may need to wipe your database if you use hashing that is different to what you are using now.
The authd and the scripts you use must be compatible, ie the same hashing eg 0xmd5.

[NoName123456]

I would wipe my server, I already did that 4 times but I am sure I will still get the same problem because even after using your authd I still get the problem

- - - Updated - - -

I was wondering why is it only me who gets this error using Mr.Killer release?.

I mean if everyone else gets it working fine then it shouldn't be files problem right?

- - - Updated - - -

Now I restored my old auth folder and this is the error I am getting now (couldn't retrieve characters list)