BOI files (released)

[demonlordace]

u can focus on that ill focus on what im good at if i find anything concerning the log server ill let u know

well i decompiled all the pdbs thx to Siber
and from what i can tell they all contain structures to open these and we simply put add custom stuff

[spoiler]enum eResultFilter {
eRF_Spouse = 0x0,
eRF_Brother = 0x1,
eRF_Teacher = 0x2,
eRF_Teamer = 0x3,
eRF_Guild = 0x4,
eRF_Partner = 0x5,
eRF_NotFindSrc = 0x6,
eRF_NotFindDst = 0x7,
eRF_NotFindID = 0x8,
eRF_Error = 0x9,
eRF_Pass = 0xa,
};
[spoiler]

[Siber_the_wise]

joseus34 - just looking through the AU, did you edit the connection name in table.xml?

<connection name="auth0" poolsize="8" url="jdbc:microsoft:sqlserver://serverip:1433;databasename=PassportBOI" username="sa" password=""/>

I'm mainly used to PW, and backing through the thread here I don't see anyone saying to edit that or create the "passportBOI" db

[demonlordace]

u can name the databases whatever u want rly but from what i c we dont have everything needed to make complete databases just yet that is why i wanted to decompile the pdbs but ive been looking through them and havent seen any referance to databases or tbls in these which is really odd

[Siber_the_wise]

Originally Posted by demonlordace

u can name the databases whatever u want rly but from what i c we dont have everything needed to make complete databases just yet that is why i wanted to decompile the pdbs but ive been looking through them and havent seen any referance to databases or tbls in these which is really odd

Wanmei tends to use the same Auth system on their games (JD PW have almost identical) and this looks a hell of a lot like the same from the few mins I've looked at it - it makes sense, it lets people charge an account and use the charge on any of the games they run I guess. The BOI Table.xml has the layout of the player database kinda indicated in it if someone wants to rebuild it.

Late edit: and the procedures too...unusual file that, but that file might be enough to build the playerDB from and get the Auth going properly - if it's not done already I'll give it a shot when I get up tommorrow.

[demonlordace]

yea i looked through it for the first time when u mentioned the connection string u found it does sum what id take it on myself but ive done it with rappelz 7.3 and i wont do it again as i just got screwed after i finished it

[LeRaz0r]

Where did you locate Table.xml?

[demonlordace]

authd/build

[Naicus]

DBUSER = root
DBNAME = shengui139
DBPASSWD = game

[Siber_the_wise]

Think I Found the problem with logserv

[Error :  file ./src/srv_conf.cpp:26 at 2012-7-1 3:5:18]open xml [./logsrv.xml] file error ret=-50
[Error :  file ./src/app.c:136 at 2012-7-1 3:5:18]load config file error please check file exist

Can't find that file anywhere.

DBServ and Nameserver open, create lockfiles but then the process seems to close so not sure what is wrong there. With dbserv it created it's own log directory and the log read, so looks like we need to figure out what other info it wants to start up

[2012-07-01 00:47:14] Now initialize main server, init mode = 0.
[2012-07-01 00:47:14] Try to alloc share memory of 1281905140 bytes...
[2012-07-01 00:47:14] Alloc share memory failed, id: 22 desc: Invalid argument

nameserv log

[2012-07-01 03:14:37] CNameCtrl 82755776
[2012-07-01 03:14:37] CNameHandle 201628
[2012-07-01 03:14:37] INPUTQUEUELENGTH 2097172
[2012-07-01 03:14:37] Total Handle size:  18390400
[2012-07-01 03:14:37] Alloc share memory failed, Invalid argument

Overall the process look like they are wanting for some other info at the moment.


Edit - to get gacd going you need to install libstdc++5

[joseus34]

Originally Posted by Siber_the_wise

Think I Found the problem with logserv

[Error :  file ./src/srv_conf.cpp:26 at 2012-7-1 3:5:18]open xml [./logsrv.xml] file error ret=-50
[Error :  file ./src/app.c:136 at 2012-7-1 3:5:18]load config file error please check file exist

Can't find that file anywhere.

DBServ and Nameserver open, create lockfiles but then the process seems to close so not sure what is wrong there. With dbserv it created it's own log directory and the log read, so looks like we need to figure out what other info it wants to start up

[2012-07-01 00:47:14] Now initialize main server, init mode = 0.
[2012-07-01 00:47:14] Try to alloc share memory of 1281905140 bytes...
[2012-07-01 00:47:14] Alloc share memory failed, id: 22 desc: Invalid argument

nameserv log

[2012-07-01 03:14:37] CNameCtrl 82755776
[2012-07-01 03:14:37] CNameHandle 201628
[2012-07-01 03:14:37] INPUTQUEUELENGTH 2097172
[2012-07-01 03:14:37] Total Handle size:  18390400
[2012-07-01 03:14:37] Alloc share memory failed, Invalid argument

Overall the process look like they are wanting for some other info at the moment.


Edit - to get gacd going you need to install libstdc++5

[2012-06-30 15:12:19] CNameCtrl 82755776
[2012-06-30 15:12:19] CNameHandle 201628
[2012-06-30 15:12:19] INPUTQUEUELENGTH 2097172
[2012-06-30 15:12:19] Total Handle size:  18390400
[2012-06-30 15:12:19] Successfully alloced share memory block, key = 4200819F, id = 6520852, size = 101146204
[2012-06-30 15:12:19] DBNAME:boi
[2012-06-30 15:12:19] DBUSER:root
[2012-06-30 15:12:19] DBPASSWD:joseus
[2012-06-30 15:12:19] DBSOCKFILE:/tmp/mysql.sock
[2012-06-30 15:12:19] SERVERID:0
[2012-06-30 15:12:19] SERVICEIP:
[2012-06-30 15:12:19] SERVICEPORT:
[2012-06-30 15:12:19] PRINTSTATINTERVAL:3600
[2012-06-30 15:12:19] CHECKINTERVAL:3600
[2012-06-30 15:12:19] MANAGERSVRDNUM:0
[2012-06-30 15:12:19] Init Name Server OK, now prepare to run.
[2012-06-30 15:12:19] Set Send buf of socket is 262142.
[2012-06-30 15:12:19] Create Server succeed.
[2012-06-30 15:12:19] Successfully create 8 threads to handle request.
[2012-06-30 15:12:19] The Name server is ready.
[2012-06-30 15:12:19] error in CNameHandle::PrepareToRun, load id failed.
[2012-06-30 15:12:19] load cur role id: 0.
[2012-06-30 15:12:19] load cur guild id: 0.
[2012-06-30 15:12:19] load cur battle id: 0.

Originally Posted by Siber_the_wise

Think I Found the problem with logserv

[Error :  file ./src/srv_conf.cpp:26 at 2012-7-1 3:5:18]open xml [./logsrv.xml] file error ret=-50
[Error :  file ./src/app.c:136 at 2012-7-1 3:5:18]load config file error please check file exist

Can't find that file anywhere.

DBServ and Nameserver open, create lockfiles but then the process seems to close so not sure what is wrong there. With dbserv it created it's own log directory and the log read, so looks like we need to figure out what other info it wants to start up

When i run them they works fine, coz u cannot allocate memory, download CentOs x86_64 it works, except for logsvrd
Db log

[2012-06-30 15:56:24] Now initialize main server, init mode = 0.
[2012-06-30 15:56:24] Try to alloc share memory of 1281905140 bytes...
[2012-06-30 15:56:24] Successfully alloced share memory block, key = 42008106, id = 7372821, size = 1281905140, initflag = 0
[2012-06-30 15:56:24] in CSharedMem::CSharedMem, key = 1107329286, shmkey = 0, size = 1281905140, shmsize = 0
[2012-06-30 15:56:26] Construct db handle in init mode.
[2012-06-30 15:56:27] Construct db handle in init mode.
[2012-06-30 15:56:27] Construct other handle in init mode.
[2012-06-30 15:56:27] Construct other handle in init mode.
[2012-06-30 15:56:27] DBSOCKFILE:
[2012-06-30 15:56:27] SERVERID:1
[2012-06-30 15:56:27] SERVICEPORT:10080
[2012-06-30 15:56:27] SERVICEIP:192.168.1.110
[2012-06-30 15:56:27] DBOPERMODE:0
[2012-06-30 15:56:27] CPTINTERVAL:30
[2012-06-30 15:56:27] TOINTERVAL:60
[2012-06-30 15:56:27] PRINTSTATINTERVAL:300
[2012-06-30 15:56:27] COUNTLOGINTERVAL:300
[2012-06-30 15:56:27] TODBNUMONCE:20
[2012-06-30 15:56:27] RECYCLENUMONCE:30
[2012-06-30 15:56:27] MAXRECYCLETIME:900
[2012-06-30 15:56:27] MANAGERSVRDNUM:1
[2012-06-30 15:56:27] [MANAGERSVRD.1]
[2012-06-30 15:56:27] SERVERID:1
[2012-06-30 15:56:27] SERVICEIP:192.168.1.110 
[2012-06-30 15:56:27] SERVICEPORT: 
[2012-06-30 15:56:27] [AUAGENT]
[2012-06-30 15:56:27] SERVERID:0
[2012-06-30 15:56:27] SERVICEPORT:
[2012-06-30 15:56:27] SERVICEIP:
[2012-06-30 15:56:27] [LOGSVRD]
[2012-06-30 15:56:27] SERVERID:0
[2012-06-30 15:56:27] SERVICEPORT:
[2012-06-30 15:56:27] SERVICEIP:
[2012-06-30 15:56:27] [OTHER]
[2012-06-30 15:56:27] BEGINDATE:20091215
[2012-06-30 15:56:27] ENDDATE:20150105
[2012-06-30 15:56:27] BEGINDATES:20100127
[2012-06-30 15:56:27] ENDDATES:20150105
[2012-06-30 15:56:27] BEGINDATENOBLE:20100420
[2012-06-30 15:56:27] ENDDATENOBLE:20150105
[2012-06-30 15:56:27] VALIDDAYS:365
[2012-06-30 15:56:27] Init DB Server OK, now prepare to run.
[2012-06-30 15:56:27] Bind failed, Address already in use.
[2012-06-30 15:56:27] Error: in CDBCtrl::PrepareToRun, Create Server failed.
[2012-06-30 15:56:27] DB control prepare failed.
[2012-06-30 15:56:27] Remove shared memory(id = 7372821, key = 0X42008106) succeed.
[2012-06-30 23:54:04] Now initialize main server, init mode = 0.
[2012-06-30 23:54:04] Try to alloc share memory of 1281905140 bytes...
[2012-06-30 23:54:04] Successfully alloced share memory block, key = 42008106, id = 5472274, size = 1281905140, initflag = 0
[2012-06-30 23:54:04] in CSharedMem::CSharedMem, key = 1107329286, shmkey = 0, size = 1281905140, shmsize = 0
[2012-06-30 23:54:07] Construct db handle in init mode.
[2012-06-30 23:54:09] Construct db handle in init mode.
[2012-06-30 23:54:09] Construct other handle in init mode.
[2012-06-30 23:54:09] Construct other handle in init mode.
[2012-06-30 23:54:09] DBSOCKFILE:
[2012-06-30 23:54:09] SERVERID:1
[2012-06-30 23:54:09] SERVICEPORT:10080
[2012-06-30 23:54:09] SERVICEIP:192.168.1.110
[2012-06-30 23:54:09] DBOPERMODE:0
[2012-06-30 23:54:09] CPTINTERVAL:30
[2012-06-30 23:54:09] TOINTERVAL:60
[2012-06-30 23:54:09] PRINTSTATINTERVAL:300
[2012-06-30 23:54:09] COUNTLOGINTERVAL:300
[2012-06-30 23:54:09] TODBNUMONCE:20
[2012-06-30 23:54:09] RECYCLENUMONCE:30
[2012-06-30 23:54:09] MAXRECYCLETIME:900
[2012-06-30 23:54:09] MANAGERSVRDNUM:1
[2012-06-30 23:54:09] [MANAGERSVRD.1]
[2012-06-30 23:54:09] SERVERID:1
[2012-06-30 23:54:09] SERVICEIP:192.168.1.110 
[2012-06-30 23:54:09] SERVICEPORT: 
[2012-06-30 23:54:09] [AUAGENT]
[2012-06-30 23:54:09] SERVERID:0
[2012-06-30 23:54:09] SERVICEPORT:
[2012-06-30 23:54:09] SERVICEIP:
[2012-06-30 23:54:09] [LOGSVRD]
[2012-06-30 23:54:09] SERVERID:0
[2012-06-30 23:54:09] SERVICEPORT:
[2012-06-30 23:54:09] SERVICEIP:
[2012-06-30 23:54:09] [OTHER]
[2012-06-30 23:54:09] BEGINDATE:20091215
[2012-06-30 23:54:09] ENDDATE:20150105
[2012-06-30 23:54:09] BEGINDATES:20100127
[2012-06-30 23:54:09] ENDDATES:20150105
[2012-06-30 23:54:09] BEGINDATENOBLE:20100420
[2012-06-30 23:54:09] ENDDATENOBLE:20150105
[2012-06-30 23:54:09] VALIDDAYS:365
[2012-06-30 23:54:09] Init DB Server OK, now prepare to run.
[2012-06-30 23:54:09] Set Send buf of socket is 262142.
[2012-06-30 23:54:09] connect manager server end
[2012-06-30 23:54:09] connect log server end
[2012-06-30 23:54:09] Pair Socket Send buf of  is 262142.
[2012-06-30 23:54:09] Pair Socket Receive buf of  is 262142.
[2012-06-30 23:54:09] Pair Socket Send buf of  is 262142.
[2012-06-30 23:54:09] Pair Socket Receive buf of  is 262142.
[2012-06-30 23:54:09] Handles initialized OK, now begin to create handle threads.
[2012-06-30 23:54:09] Successfully create 2 handle threads.
[2012-06-30 23:54:09] Other Handles initialized OK, now begin to create other handle threads.
[2012-06-30 23:54:09] Successfully create 2 other handle threads.
[2012-06-30 23:54:09] The DB server is ready.

[Naicus]

Can u post a simple tutorial to install database on centos os?

[Siber_the_wise]

When i run them they works fine, coz u cannot allocate memory, download CentOs x86_64 it works, except for logsvrd
Db log

[2012-06-30 15:56:24] Now initialize main server, init mode = 0.
[2012-06-30 15:56:24] Try to alloc share memory of 1281905140 bytes...
[2012-06-30 15:56:24] Successfully alloced share memory block, key = 42008106, id = 7372821, size = 1281905140, initflag = 0
[2012-06-30 15:56:24] in CSharedMem::CSharedMem, key = 1107329286, shmkey = 0, size = 1281905140, shmsize = 0
[2012-06-30 15:56:26] Construct db handle in init mode.
[2012-06-30 15:56:27] Construct db handle in init mode.
[2012-06-30 15:56:27] Construct other handle in init mode.
[2012-06-30 15:56:27] Construct other handle in init mode.
[2012-06-30 15:56:27] DBSOCKFILE:
[2012-06-30 15:56:27] SERVERID:1
[2012-06-30 15:56:27] SERVICEPORT:10080
[2012-06-30 15:56:27] SERVICEIP:192.168.1.110
[2012-06-30 15:56:27] DBOPERMODE:0

I read how you were using a modified version of the cardserv.conf - seems like it works well, I think you might need to change that port though - Managerserver.ini lists the ports for the the other instances. That might be why you couldn't get them running at the same time before?

edit: downloading centos now, but heading out for a while - will try later - can you put the modified conf files you're using up somewhere pls?

[joseus34]

Originally Posted by Naicus

Can u post a simple tutorial to install database on centos os?

the DB files that makes tables and server are : namesrvd,cardsvrd,authd,dbsvrd and logsvrd
When they run , they install, make and manage the database, u just have to create .cfg(config files) to make them connect to you mysql db like mine (boi with root user and joseus pass) after that when u run, they connect to my db and refill the db with the temp files.
the second way is decopile all of exeutables(logsvrd) and install db tables they have inside manually and after that run the mysql server, but its the hardest way but more powerfull.
The CentOs x86_64 is the OS working for now except to run logsrvd, but we need to get libs and rpm that logsvrd need to run.So dont worry when we found them well run the server ^^

[joseus34]

put them in config folder

[LeRaz0r]

I have a list of packages that would be essential in order to boot Logsrv, tried installing them, but some of them don't even exist.. You'd need to use commands like

yum whatprovides PackageNameHere
yum install WhateverProvidesThePackageName

Which is what I've been doing but half of the packages from my list doesn't even exist. They're supposed to, I mean you can download them manually, as rpm, but you can't install them, due to missing components. It's really annoying.

It's 294 Packages in my list that are required to run Logsrv, but I can't manage to install them.

I also tried this command after putting the list in a text document called work:

yum install $(cat work)

Basically what that does is it uses

yum install PackageName

On each line from the text file called "Work", which holds the list of packages. But then again, majority of the packages don't exist in Yum for some stupid reason, so I'm unsure as to how to proceed.