look at the picture why dont show me the md5 password ?
![]()
look at the picture why dont show me the md5 password ?
![]()
Guessing that's [dbo].[account] and [dbo].[users] in which case it will always say Binary Data because that's what it is.
You can still change the passwords using Querys. But before that, you should make sure that it's actually an account issue rather than an auth issue (Connecting to DB and collecting the information is what I mean).
Run this Query
And try logging in with credentials:Code:EXEC [PassportBOI].[dbo].[adduser] 'mastertest', 0x71ae50242babce4d368423d8c03d0c13, 'question', '-', 'mastertest', '1', 'master@master.com', '0','0','0','0','0','0','0', '01-17-1937 00:00:00', '1', 0x71ae50242babce4d368423d8c03d0c13
Username: mastertest
Password: mastertest
If it still doesn't work, then it's not an account-issue. It's an issue with grabbing the information from the DB, so let me know how it works out. May also still have the "bug" (as some people like to call it) active where you can login using password "123" on every account, in which case try that as well.
don't work ...![]()
WIN XP = 192.168.1.64
LINUX = 192.168.1.109
Auagent
Auth.confCode:[AuAgentServer] zoneid = 904 aid = 9 type = tcp port = 29250 address = 192.168.1.64 so_sndbuf = 131072 so_rcvbuf = 131072 ibuffermax = 409600 obuffermax = 819200 tcp_nodelay = 1 listen_backlog = 10 mtrace = /tmp/m_trace.link [GameDBClient] type = tcp port = 29251 address = 192.168.1.109 so_sndbuf = 131072 so_rcvbuf = 131072 ibuffermax = 409600 obuffermax = 819200 tcp_nodelay = 1 ;listen_backlog = 10 mtrace = /tmp/m_trace.link cashfile = C:\SERVER\cash_backup.data [GAuthClient] type = tcp port = 29200 address = 192.168.1.109 so_sndbuf = 131072 so_rcvbuf = 131072 ibuffermax = 819200 obuffermax = 819200 so_broadcast = 1 tcp_nodelay = 1 osec = 2 oseckey = rdppjtaki1MxoHnsnaltiiwfjszs9l isec = 2 iseckey = n1hxpxztozyxnsvk6RaycpmrCnrdds shared_key = 4khdwAAcjrg0eqfzazqcemdpgulnje ;if use certverify between au,1:use,0:not use,default use issupport_cert = 0 [ThreadPool] config = (1,1)(2,4)(3,2) max_queuesize = 1048576 prior_strict = 0 [SpeedLimit] window = 20 high = 2 [TimeoutLimit] ;window > 60 window = 180 high = 200 [CouponLimit] ;GetUserCoupon limit window = 300 high = 2 [CouponExchangeLimit] ;CouponExchange limit window = 120 high = 2
Table.xmlCode:[GAuthServer] type = tcp port = 29200 address = 192.168.1.109 so_sndbuf = 131072 so_rcvbuf = 131072 ibuffermax = 819200 obuffermax = 819200 tcp_nodelay = 1 listen_backlog = 10 mtrace = /tmp/mtrace.authd osec = 2 oseckey = n1hxpxztozyxnsvk6RaycpmrCnrdds isec = 2 iseckey = rdppjtaki1MxoHnsnaltiiwfjszs9l shared_key = 4khdwAAcjrg0eqfzazqcemdpgulnje isabroad = true ismssql = true [ThreadPool] config = (1,1)(2,10)(3,1)(101,5) max_queuesize = 1048576
Code:<?xml version="1.0" encoding="ISO-8859-1"?> <?xml-stylesheet type="text/xsl" href="table.xsl"?> <application debug="false" beans="com.wanmei.db.passport" beanbase="src/beans"> <connection name="auth0" poolsize="8" url="jdbc:microsoft:sqlserver://192.168.1.64:1433;databasename=PassportBOIOLD" username="sa" password="123456789"/> <driver name="com.microsoft.jdbc.sqlserver.SQLServerDriver" /> <cache name="account_by_id" type="reference" ip="226.1.1.1" port="4444" local_ip="192.168.1.109" size="262144" partition="0"/> <cache name="account_by_name" type="reference" ip="226.1.1.1" port="4445" local_ip="192.168.1.109" size="262144" partition="0"/> <cache name="function_by_id" type="direct" ip="226.1.1.2" port="4446" local_ip="192.168.1.89" size="262144" partition="0"/> <cache name="forbid_by_id" type="direct" ip="226.1.1.3" port="4447" local_ip="192.168.1.89" size="262144" partition="0"/> <cache name="matrix_by_uid" type="direct" ip="226.1.1.4" port="4448" local_ip="192.168.1.89" size="262144" partition="0"/> <cache name="phoneuser_by_phone" type="direct" ip="226.1.1.5" port="4449" local_ip="192.168.1.89" size="262144" partition="0"/> <cache name="userinfo_by_id" type="direct" ip="226.1.1.6" port="4450" local_ip="192.168.1.89" size="131072" partition="0"/>
in your table.xml you have some Ips with 192.168.1.89 where it should be 192.168.1.109
Your configuration seems ok, you don't have exceptions in your authd.log?
Also you have to check that you can actually connect to MSSQL from linux.
i fix all error succes connct thx for help
Can you help me!
I have a problems about connect from Auagent to authd
authd.out (LINUX)
Config authd.conf (WINDOW)Code:GAuthServer.matrixValid = true GAuthServer.disable_User_Matrix = false GAuthServer.allow_all_user = true GAuthServer.allow_same_zoneid = true GAuthServer.matrixpasswd_log = false MatrixPasswd add forbidips= authd:: add PollIO task. configuring log4j with log4j.xml Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198 Protocol Decode CheckPolicy Error:type=-250933260,size=528624198
Config table.xml (WINDOW)Code:[GAuthServer] type = tcp port = 29200 address = 0.0.0.0 so_sndbuf = 131072 so_rcvbuf = 131072 ibuffermax = 819200 obuffermax = 819200 tcp_nodelay = 1 listen_backlog = 10 mtrace = /tmp/mtrace.authd osec = 2 oseckey = n1hxpxztozyxnsvk6RaycpmrCnrdds isec = 2 iseckey = rdppjtaki1MxoHnsnaltiiwfjszs9l shared_key = 4khdwAAcjrg0eqfzazqcemdpgulnje isabroad = true ismssql = true [ThreadPool] config = (1,1)(2,10)(3,1)(101,5) max_queuesize = 1048576
Code:<connection name="auth0" poolsize="8" url="jdbc:microsoft:sqlserver://192.168.0.77:1433;databasename=PassportBOI" username="sa" password="sa@12345"/> <driver name="com.microsoft.jdbc.sqlserver.SQLServerDriver" /> <cache name="account_by_id" type="reference" ip="226.1.1.1" port="4444" local_ip="192.168.0.88" size="262144" partition="0"/> <cache name="account_by_name" type="reference" ip="226.1.1.1" port="4445" local_ip="192.168.0.88" size="262144" partition="0"/> <cache name="function_by_id" type="direct" ip="226.1.1.2" port="4446" local_ip="192.168.0.88" size="262144" partition="0"/> <cache name="forbid_by_id" type="direct" ip="226.1.1.3" port="4447" local_ip="192.168.0.88" size="262144" partition="0"/> <cache name="matrix_by_uid" type="direct" ip="226.1.1.4" port="4448" local_ip="192.168.0.88" size="262144" partition="0"/> <cache name="phoneuser_by_phone" type="direct" ip="226.1.1.5" port="4449" local_ip="192.168.0.88" size="262144" partition="0"/> <cache name="userinfo_by_id" type="direct" ip="226.1.1.6" port="4450" local_ip="192.168.0.88" size="131072" partition="0"/>
Auagent (WINDOW)
auagent.conf (WINDOW)
Code:[AuAgentServer] zoneid = 904 aid = 9 type = tcp port = 29250 address = 192.168.0.77 so_sndbuf = 131072 so_rcvbuf = 131072 ibuffermax = 409600 obuffermax = 819200 tcp_nodelay = 1 listen_backlog = 10 mtrace = /tmp/m_trace.link [GameDBClient] type = tcp port = 29251 address = 192.168.0.88 so_sndbuf = 131072 so_rcvbuf = 131072 ibuffermax = 409600 obuffermax = 819200 tcp_nodelay = 1 ;listen_backlog = 10 mtrace = /tmp/m_trace.link cashfile = C:\BOIGameServer\cash_backup.data [GAuthClient] type = tcp port = 29200 address = 192.168.0.88 so_sndbuf = 131072 so_rcvbuf = 131072 ibuffermax = 819200 obuffermax = 819200 so_broadcast = 1 tcp_nodelay = 1 osec = 2 oseckey = rdppjtaki1MxoHnsnaltiiwfjszs9l isec = 2 iseckey = n1hxpxztozyxnsvk6RaycpmrCnrdds shared_key = 4khdwAAcjrg0eqfzazqcemdpgulnje ;if use certverify between au,1:use,0:not use,default use issupport_cert = 0 [ThreadPool] config = (1,1)(2,4)(3,2) max_queuesize = 1048576 prior_strict = 0 [SpeedLimit] window = 20 high = 2 [TimeoutLimit] ;window > 60 window = 180 high = 200 [CouponLimit] ;GetUserCoupon limit window = 300 high = 2 [CouponExchangeLimit] ;CouponExchange limit window = 120 high = 2
I have same error i flow this post http://forum.ragezone.com/f771/making-account-871017/ and can't login with account, master password monster @@
authd.out (LINUX)
Config authd.conf LINUXCode:GAuthServer.matrixValid = true GAuthServer.disable_User_Matrix = false GAuthServer.allow_all_user = false GAuthServer.allow_same_zoneid = false GAuthServer.matrixpasswd_log = false MatrixPasswd add forbidips= authd:: add PollIO task. configuring log4j with log4j.xml
Code:[GAuthServer] type = tcp port = 29200 address = LINUX IP so_sndbuf = 131072 so_rcvbuf = 131072 ibuffermax = 819200 obuffermax = 819200 tcp_nodelay = 1 listen_backlog = 10 mtrace = /tmp/mtrace.authd osec = 2 oseckey = n1hxpxztozyxnsvk6RaycpmrCnrdds isec = 2 iseckey = rdppjtaki1MxoHnsnaltiiwfjszs9l shared_key = 4khdwAAcjrg0eqfzazqcemdpgulnje isabroad = true ismssql = true [ThreadPool] config = (1,1)(2,10)(3,1)(101,5) max_queuesize = 1048576
Config table.xml LINUX
Code:<connection name="auth0" poolsize="8" url="jdbc:microsoft:sqlserver://WINDOWS-IP:1433;databasename=PassportBOI" username="sa" password="password"/> <driver name="com.microsoft.jdbc.sqlserver.SQLServerDriver" /> <cache name="account_by_id" type="reference" ip="226.1.1.1" port="4444" local_ip="LINUX IP" size="262144" partition="0"/> <cache name="account_by_name" type="reference" ip="226.1.1.1" port="4445" local_ip="LINUX IP" size="262144" partition="0"/> <cache name="function_by_id" type="direct" ip="226.1.1.2" port="4446" local_ip="LINUX IP" size="262144" partition="0"/> <cache name="forbid_by_id" type="direct" ip="226.1.1.3" port="4447" local_ip="LINUX IP" size="262144" partition="0"/> <cache name="matrix_by_uid" type="direct" ip="226.1.1.4" port="4448" local_ip="LINUX IP" size="262144" partition="0"/> <cache name="phoneuser_by_phone" type="direct" ip="226.1.1.5" port="4449" local_ip="192.168.0.88" size="262144" partition="0"/> <cache name="userinfo_by_id" type="direct" ip="226.1.1.6" port="4450" local_ip="LINUX IP" size="131072" partition="0"/>
B]auagent.conf (WINDOW)[/B]
[/QUOTE]Code:[AuAgentServer] zoneid = 904 aid = 9 type = tcp port = 29250 address = WINDOWS IP so_sndbuf = 131072 so_rcvbuf = 131072 ibuffermax = 409600 obuffermax = 819200 tcp_nodelay = 1 listen_backlog = 10 mtrace = /tmp/m_trace.link [GameDBClient] type = tcp port = 29251 address = LINUX IP so_sndbuf = 131072 so_rcvbuf = 131072 ibuffermax = 409600 obuffermax = 819200 tcp_nodelay = 1 ;listen_backlog = 10 mtrace = /tmp/m_trace.link cashfile = C:\BOIGameServer\cash_backup.data [GAuthClient] type = tcp port = 29200 address = LINUX IP so_sndbuf = 131072 so_rcvbuf = 131072 ibuffermax = 819200 obuffermax = 819200 so_broadcast = 1 tcp_nodelay = 1 osec = 2 oseckey = rdppjtaki1MxoHnsnaltiiwfjszs9l isec = 2 iseckey = n1hxpxztozyxnsvk6RaycpmrCnrdds shared_key = 4khdwAAcjrg0eqfzazqcemdpgulnje ;if use certverify between au,1:use,0:not use,default use issupport_cert = 0 [ThreadPool] config = (1,1)(2,4)(3,2) max_queuesize = 1048576 prior_strict = 0 [SpeedLimit] window = 20 high = 2 [TimeoutLimit] ;window > 60 window = 180 high = 200 [CouponLimit] ;GetUserCoupon limit window = 300 high = 2 [CouponExchangeLimit] ;CouponExchange limit window = 120 high = 2
[/QUOTE]
i fixed this error
xtreme17 thank you very much !![]()
![]()
Problems in oseckey reverse with iseckeyI have same error i flow this post http://forum.ragezone.com/f771/making-account-871017/ and can't login with account, master password monster @@
Thank again !
i fixed this error
xtreme17 thank you very much !![]()
![]()
Problems in oseckey reverse with iseckey
Thank again ![/QUOTE]
Now ? you can connect with account create by MSSQL ?
Auagent.conf [WINDOW] CORECT OSEC ISEC
authd.cong [LINUX] CORECT OSEC ISECCode:osec = 2 oseckey = rdppjtaki1MxoHnsnaltiiwfjszs9l isec = 2 iseckey = n1hxpxztozyxnsvk6RaycpmrCnrdds shared_key = 4khdwAAcjrg0eqfzazqcemdpgulnje
Code:osec = 2 oseckey = n1hxpxztozyxnsvk6RaycpmrCnrdds isec = 2 iseckey = rdppjtaki1MxoHnsnaltiiwfjszs9l shared_key = 4khdwAAcjrg0eqfzazqcemdpgulnje