Authd (unknown sources) and GameDb (Protocol unknown) - roles access problem

[shadowvzs]

Useing:
- ubuntu 12.04 64bit
- java packages: /usr/java/jdk1.6.0_12 and /usr/java/jre1.6.0_12
- all files there what needed for authd
- xampp at /opt/lampp/
- role table added
- game itself running if start from .sh but problem is cant access the game database/roles from web (and these must work)

Authd - running if i start from .sh but not running if i start from pwAdmin, but if was started from shell script its show correctly in pwAdmin about its running, guess problem with role import is related with authd and mysql somehow.


this is when i start authd first time:

authd:: add PollIO task.
...........................................................................................
java.sql.SQLException: Callable statments not supported.
at com.mysql.jdbc.Connection.prepareCall(Connection_java:1282)
at application.procedure.handler.execute(handler_java: 189)
at com.goldhuman.account.storage.clearOnlineRecordsOpen(storage.java:849)
at protocol.AnnounceZoneid.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(Unknown Source)

when i stop server and start again its different (but i guess because i not killed java in stop.sh):

java.net.BindException: Address already in use
at sun.nio.ch.Net.Bind(Native Method)
at sun.nio.ch.ServerSocketChannelImpl.bind(Unknown Source)
at sun.nio.ch.ServerSocketAdaptor.bind(Unknown Source)
at com.goldhuman.IO.PassiveIO.Open(Unknown Source)
at com.goldhuman.IO.Protocol.Protocol.Server(Unknown Source)
at authd.main(Unknown Source)
authd:: add PollIO task.

authd path is: /root/authd/build/

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


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


sleep 5

tryed different authd but similiar result

#!/bin/shcd /root/mauthd/build


export HOME=/usr/java/jdk1.6.0_12
export PATH=$HOME/bin:$PATH


export CLASSPATH=.:/usr/java/jdk1.6.0_12/lib/dt.jar:/usr/java/jdk1.6.0_12/lib/tools.jar:/usr/java/jdk1.6.0_12/lib/mysql-connector-java-3.0.16-ga-bin.jar


export JAVA_HOME=/usr/java/jdk1.6.0_12/


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 org.mono.Authd

When i try import roles in pwAdmin i get this after 5-7 second wait:

Importing Roles to MySQL Failed

and in virtualbox i see this

info : GameDBServer:: OnAddSession, sid=10.
err : Protocol Unknown . sid=10, type=3032,size=8,acceptsize=116
info : GameDBServer:: OnDelSession, sid=10.

if i search after a char id then role page in pwAdmin loading loading then no conent below header menu and banner picture.


.profile - i guess few thing wrong there but i doubt the reason is there

# ~/.profile: executed by Bourne-compatible login shells.


if [ "$BASH" ]; then
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
fi


mesg n


# User specific environment and startup programs


PATH=$PATH:$HOME/bin:/usr/java/jre1.6.0_12/bin
BASH_ENV=$HOME/.bashrc
USERNAME="root"
PATH=$PATH:$HOME/bin:/opt/lampp/bin/
BASH_ENV=$HOME/.bashrc
USERNAME="root"


export USERNAME BASH_ENV PATH
export CLASSPATH=.:/usr/java/jdk1.6.0_12/lib/dt.jar:/usr/java/jdk1.6.0_12/lib/tools.jar:/usr/java/jdk1.6.0_12/lib/mysql-connector-java-3.0.16-ga-bin.jar


export PATH=$JAVA_HOME/bin:$PATH
export JAVA_HOME=/usr/java/jdk1.6.0_12


export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib

attached the screenshot belows