Yes maybe the port 4502 is the listening port of LS that waiting connection from GS. Of course we are far away from this step.Finaly i follow your way Tetris and i managed to change the port of the client using MHS. Here is the offsets ->
-----Client OFFSETS----
LS AUTH PORT: sframe.exe+30722A
1ST IN THE LIST GAMESERVER IP: sframe.exe+8081A8
1ST IN THE LIST GAMESERVER PORT: sframe.exe+808228
------------------------
How i know these offsets. I have an account on official server. I used a proxy+packets capturer(handmade by me) app and i captured all the packets that client exchanges with LS and GS during a normal logon.I have all the sequence step by step. We may need it for later use.
So now i can simulate a rappelz logon offline
if anyone need this packet array i can send it.Maybe a good packet decoding guy can help us this way.
Now about the ...db.auth.port:4500...
If i understand right what you mean, why i have to set this port to 4500 since [db.auth.port] is for the SQL listening port 1433,34 or if you have express sql its 1039. So in my opt files i have to set this at 1039. Normaly princessaurora should listen at 4500-clients,4501-console,4502-GS. So something is wrong here.
About GameServer + SQl connection. Gameserver attempts to connect to cadb.nflavor.com but using the right way we redirect it localy. The problem is the port:1433,34. for me because as i said i use Express SQL is 1039. I used the same app as before for packets capture in order to redirect the connection from 1433 to 1039 and i captured the exchanged packets in order to try find out the problem. Here i share the packets with you:
-Packets Exchanged During CaptainHerlock Attempts a Connection with SQL-
PACKET FROM CLIENT TO SERVER
PacketID:1<>127.0.0.1 ----> 127.0.0.1---- Size:41
)UT
------------------------------------------------------
PACKET FROM SERVER TO CLIENT
PacketID:2<>127.0.0.1 ----> 127.0.0.1---- Size:37
%@
------------------------------------------------------
PACKET FROM CLIENT TO SERVER
PacketID:3<>127.0.0.1 ----> 127.0.0.1---- Size:78
NA=Lv7a/`AGwEˆ'%
dbc
------------------------------------------------------
PACKET FROM SERVER TO CLIENT
PacketID:4<>127.0.0.1 ----> 127.0.0.1---- Size:610
bUFL*..*t0ӪH*]
Oi/ۦM=9A}00b* OU
0 *H0;1907U0SSL_Self_Signed_Fallback01 00912034816Z400912034816Z0;1907U0SSL_Self_Si gned_Fallback00 *H0ʾЬ|99XPq8r %lc HT1i/T )r+dh%MWq0>n*MU~箘x* `.F?%@5Fm{rl0 *H\!%ʈ Pґ.)#C;.:dQgeVS9Ob ҊU_:J"I9zYQx킧A_fǤY$DB:ݳwF t.ȏl igKL
------------------------------------------------------
PACKET FROM CLIENT TO SERVER
PacketID:5<>127.0.0.1 ----> 127.0.0.1---- Size:190
+c~0bygZĮN}\8]})S qvHtHwTEoEcC
a'zK+qѩE%1#~P%_P($>
E9g;G Y EN~`gjrރ*܇(%鹶
------------------------------------------------------
PACKET FROM SERVER TO CLIENT
PacketID:6<>127.0.0.1 ----> 127.0.0.1---- Size:51
3 U>Ғ55}{ A``R'@
------------------------------------------------------
PACKET FROM CLIENT TO SERVER
PacketID:7<>127.0.0.1 ----> 127.0.0.1---- Size:199
{jGK%qčу
L@]5K$ap:R- jzFǎ)Y[>^jҙ479PڔqjA{ʗNX-}JېѪ L^,?^]̫f?]>Z?*6I-(Ft\vt7TXZ!7v u`y톿SLq,v
------------------------------------------------------
PACKET FROM SERVER TO CLIENT
PacketID:8<>127.0.0.1 ----> 127.0.0.1---- Size:421
3#
Telecastermaster|E)Changed database context to 'Telecaster'.VMPC\SQLEXPRESS
us_englishxG'Changed language setting to us_english.VMPC\SQLEXPRESS*6qMicrosoft SQL Server
@40964096
------------------------------------------------------
In our case: CLIENT=CaptainHerlock and SERVER=SQL
------------------------------------------------------
then i get the error message from GS:''[DBNETLIB][ConnectionOpen(Connect()). Access Denied or SQL Server does not exists.''