yeah!, i propose Zanthyn for mod :laugh:Quote:
Originally Posted by MentaL
Printable View
yeah!, i propose Zanthyn for mod :laugh:Quote:
Originally Posted by MentaL
how i can set that ip? or manually added?Quote:
IP's to change:
Code:
"192.168.1.100" = WINDOWS IP
"192.168.1.109" = LINUX IP
EDIT : Solved Thx NanayaQ for ifconfig
Sorry if I being rude but I try really hard not to laugh.Quote:
Originally Posted by gigok
The IP are what you need to replace with yours you can find your IP on the command prompt by typing ipconfig /all.
Then on your linux os on vbox go to the terminal and type in ifconfig that should give you.. your linux IP.
you replace it where Zanthyn show you on the conf files.
I wrote the code myself, BOIWAR was hacked long ago before these files were leaked, much longer.Quote:
Originally Posted by zanthyn
Also a quick note, you do not even have to use MSSQL for the server, you can assign it to use MYSQL for all databases including account verification.
Omg that was what I was thinking.. but I never tried it.. because I thought .bak file wont ever work for it. Only reason was because I thought it might conflict with shijie mysql server.Quote:
Originally Posted by reflax
I don't know what files or packs were released but you should be able to come up with the correct tables for MYSQL from this or another game.Quote:
Originally Posted by NanayaQ
I was thinking of connecting mssql on mysql see if that will work.Quote:
Originally Posted by reflax
Edit: never thought that converting .bak to .sql would be this hard....
If you don't mind me asking what would be the best route to take here?Quote:
Originally Posted by reflax
Well idk if I convert it right or not but here the sql file of the .bak passportboi.sql
I'lll test it tomorrow I'm hitting the sack now need to change all configs to point to mysql instead of mssql now if it works correctly
Good to know.. I change the table.xml to my mysql but that didn't do nothing since that matrixpass still enableQuote:
Originally Posted by zanthyn
You will still have to deal with authorization no mater if you use mssql or mysql, the database and table structure is different for the two.Quote:
Originally Posted by NanayaQ
yup thats trueQuote:
Originally Posted by reflax
So how should we go about disabling this "authorization" that is preventing is from using real accounts?
please help me!!!
where i can increase tech point?
I can use Tech Stone of Power but it limited use three time a day.
Where I can edit file?
Sorry, my bad English:?:
Find the item ID then go look for it in Script folder then once you find it you can change whatever you need in there
thank zanthyn, I edited. It's very easy if know
could you by any chance give us the files that only needs mysql databases(mssql)
I think dont change
<!-- MYSQL -->
<!--
<driver name="com.mysql.jdbc.Driver" />
<connection name="auth0" poolsize="3" url="jdbc:mysql://dbserver:3306/passport?useUnicode=true&characterEncoding=utf8" username="root" password="chenqi"/>
-->
<!-- MSSQL -->
<driver name="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
<connection name="auth0" poolsize="8" url="jdbc:microsoft:sqlserver://192.168.200.1:1314;databasename=wm" username="sa" password="123456"/>
FROM Jade Dynasty's AUTHD FILE:
Can u see some simular java apps?Quote:
#!/bin/sh
cd /usr/rain/authd/build
export HOME=/usr/java/jdk1.6.0_12/
export PATH=$HOME/bin:$PATH
#export PATH=$PATH:$HOME/bin:/usr/java/jdk1.6.0_12/bin
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:/usr/java/msSQLjdbc/lib/msbase.jar:/usr/java/msSQLjdbc/lib/mssqlserver.jar:/usr/java/msSQLjdbc/lib/msutil.jar
export JAVA_HOME=/usr/java/jdk1.6.0_12/
while true; do
java -cp ../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:. authd /etc/table.xml &> authd.out
sleep 2
done
It's starting the Java JDK first then the MSSQL. :)
(Don't forget: change the directories and java files!!)
Hi, I'm a developer/programmer in RL and I do this only for a hobby (not interested in private servers or getting money out of it).
Using wireshark to see where the packets where going and also decompiling the .class files I noticed that the linux auth was never called, also you can guess this by the name of "compactau" and if you look in the conf file you can see that compactau and authd are using the same port but in different platforms. So my guess is that compactau is only used for testing
It doesn't matter if you change the authd to use mssql or mysql because is never being used or called.
You have to change the auagent.conf in windows to connect to the linux auth:
[GAuthClient]
type = tcp
port = 29200
address = LINUX IP
and also you have to configure both to use the same oseckey and iseckey parameters or it won't work.
With this, the authd(linux) starts to get called, mine is working (sends packet to mssql) but I always get password incorrect,
I didn' like perfect world so I guess I'm a little behind than everyone but the algorythm 0x(md5(user.pass)) doesn't seem to work for me. Decoding the algorythm is posible but I'm still routing the class files, you can route the process in this files:
AuAgentServer.class
AgentMatrixPassw.class
MatrixPasswd.class
Passwd.class
Also you can check the code for the rpc calls inside the jio.jar packages.
Hope this helps someone, if I get auth to work with mssql I'll post again.
Sorry for my english.
Attachment 111168
Linux connected to MSSQL!
After i reinstalled VirtualBox, some errors start to appear when i use install_db.sh ..maybe any of you can give me a opinion, please :)..i attached a print screen with errors...thx Attachment 111171
the databases are already installed so move on to next steps :)
If u are using my Centos, u have to install nothing!Quote:
Originally Posted by Pufulici
