[HELP] error login WOI LC

06/25/2014 16:23 yerros#1

I've tried several ways to run their own server, I get an error when logging into the game, :( i've add accont to database "PassportBOI" , but account still dont exist :(

[Only registered and activated users can see links. Click Here To Register...]

anyone know to fix this problem?

06/26/2014 12:26 GamerN#2

Quote:

Originally Posted by yerros

I've tried several ways to run their own server, I get an error when logging into the game, :( i've add accont to database "PassportBOI" , but account still dont exist :(

[Only registered and activated users can see links. Click Here To Register...]

anyone know to fix this problem?

authentication systems boi and woi very different . Don't try to run WOI to mssql ! it will not work . WOI only uses mysql

user table = user in shngue

06/26/2014 20:36 romodine#3

Cuz u use mysql not mssql tray to make account in mysql and log in

06/26/2014 22:23 shinnanaya#4

@Yerros
You can either tweak the file in authd folder on Linux side or replace it with BOI athud file it will work.

Edit: The table.xml are different path
Mysql

Code:

<connection name="auth0" poolsize="3" url="jdbc:mysql://localhost:3306/shengui?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true" username="root" password="root"/>

MSSQL

Code:

<connection name="auth0" poolsize="8" url="jdbc:microsoft:sqlserver://192.168.1.22:1433;databasename=PassporBOI" username="sa" password="123456"/>
<driver name="com.microsoft.jdbc.sqlserver.SQLServerDriver" />

Edit: and no WOI do not use "only" mysql it uses what ever the connection give it.
NanayaQ (RZ)

06/28/2014 03:57 yerros#5

thanks , working use mysql :)
now i get problem when enter the game , no npc and no monster anywhere , whats wrong ?

06/28/2014 13:52 Bingo2008#6

See what error you got from the consoles.
Also see if you find any error in the Linux terminal after you start your game.

That also could be MySql entry... if u have dumps, you may consider restoring to give a go.

I suspect your game data didn't load successfully.
Did you notice "battle team initiated" ?

06/28/2014 14:03 yerros#7

where i can view any error on linux?

this is show on linux terminal

Code:

[root@localhost ~]# load fonts file, charlib.dat
load charlib, count = 3900
size = 4114
Check database begin, please wait..........
Check end
authd:: add PollIO task.
Check database begin, please wait..........
..........
Check end
GAuthServer::OnAddSession com.goldhuman.IO.Protocol.Session@491c4c
Prepare procedure call:{call clearonlinerecords(?,?)}
GAuthServer::OnAddSession com.goldhuman.IO.Protocol.Session@1a7ddcf
Prepare procedure call:{call clearonlinerecords(?,?)}

06/28/2014 14:28 Bingo2008#8

Quote:

Originally Posted by yerros

where i can view any error on linux?

this is show on linux terminal

Code:

[root@localhost ~]# load fonts file, charlib.dat
load charlib, count = 3900
size = 4114
Check database begin, please wait..........
Check end
authd:: add PollIO task.
Check database begin, please wait..........
..........
Check end
GAuthServer::OnAddSession com.goldhuman.IO.Protocol.Session@491c4c
Prepare procedure call:{call clearonlinerecords(?,?)}
GAuthServer::OnAddSession com.goldhuman.IO.Protocol.Session@1a7ddcf
Prepare procedure call:{call clearonlinerecords(?,?)}

I see you have to double check your GAuthen (Client & Server) setting
--- > 0sec and isec.

In windows make ( isec first)
In Linux make (0sec first)

+ for logs, check the log files under each directories you used.