L2shaken Posted July 27, 2017 Share Posted July 27, 2017 (edited) Hello, I am configuring a server l2off on my machine, but I have a problem when creating the character, I enter login / password and the wrong password message appears and that's it, what can it be? Pack Vanganth. Print: http://imgur.com/s0tLZKm Edited July 27, 2017 by L2shaken Link to comment Share on other sites More sharing options...
0 L2shaken Posted July 27, 2017 Author Share Posted July 27, 2017 up Link to comment Share on other sites More sharing options...
0 Celestine Posted July 27, 2017 Share Posted July 27, 2017 up use bump button next time. Link to comment Share on other sites More sharing options...
0 eressea Posted July 27, 2017 Share Posted July 27, 2017 So the problem is with auth server? Which auth do you use? What kind of password hashes do you use (NCsoft, SimpleMD5 or MD5 with salt)? How did you create the account in database? Link to comment Share on other sites More sharing options...
0 L2shaken Posted July 27, 2017 Author Share Posted July 27, 2017 (edited) So the problem is with auth server? Which auth do you use? What kind of password hashes do you use (NCsoft, SimpleMD5 or MD5 with salt)? How did you create the account in database? I am very lazy in the subject l2off, but I installed the programs correctly and set the password for sa user. Edited July 27, 2017 by L2shaken Link to comment Share on other sites More sharing options...
0 etherian Posted July 27, 2017 Share Posted July 27, 2017 (edited) I am very lazy in the subject l2off, but I installed the programs correctly and set the password for sa user. beeing lazy wont help at all and that hauthd seems to be out of date http://www.hauthd.org verify your lin2db and re-check account with l2ac Edited July 27, 2017 by etherian Link to comment Share on other sites More sharing options...
0 eressea Posted July 27, 2017 Share Posted July 27, 2017 hauth.ini? how did you create the account in database? Link to comment Share on other sites More sharing options...
0 L2shaken Posted July 28, 2017 Author Share Posted July 28, 2017 hauth.ini? how did you create the account in database? beeing lazy wont help at all and that hauthd seems to be out of date http://www.hauthd.org verify your lin2db and re-check account with l2ac I just want to know why I can not log in, because of the wrong password error, can you tell me what I should do? Link to comment Share on other sites More sharing options...
0 L2shaken Posted July 28, 2017 Author Share Posted July 28, 2017 http://imgur.com/eViRR5U With the other hAuthD that the friend sent there, gives that error, but does not appear wrong password. Link to comment Share on other sites More sharing options...
0 eressea Posted July 28, 2017 Share Posted July 28, 2017 I still think you're using one hash when creating account and different hash when you try to login. Once again, how did you create that user account? Can you show me the SQL commands you used and how are variables MD5Simple and MD5Password set in hauthd.ini? Link to comment Share on other sites More sharing options...
0 L2shaken Posted July 28, 2017 Author Share Posted July 28, 2017 I still think you're using one hash when creating account and different hash when you try to login. Once again, how did you create that user account? Can you show me the SQL commands you used and how are variables MD5Simple and MD5Password set in hauthd.ini? [MSSQL] Server = WINDOWS-PC User = sa Password = Pegueivc1602 Database = lin2db SlowQuery = 100 [Tables] server = server [Main] ServerPort = 2104 ServerExPort = 2106 BlowfishKey = 6B60CB5B82CE90B1CC2B6C556C6C6C6C ;For C4: BlowfishKey = 5F3B352E5D39342D33313D3D2D257854215E5B2400 Title = [L2J] IP = Protocol = $103 FixedPorts = 1 [Log] Auth = 1 Guard = 1 All = 0 DB = 0 [Online] Multiplier = 1,0 UserCount = 5 Interval = 30 [Admin] Password = admin IP = * [Adv] EULA = 1 Test = 0 TestServers = C4 = 0 MaxConnectionsPerIP = 3 AntiDOS = 1 AntiBrute = 0 AntiBruteIP = 0 MD5Simple = 0 SHA1 = 0 Proxy = AutoReloadFiles = 0 AutoReloadServers = 0 GameProxyMasterStatus = 1 [Ext] Mask = 0 MD5Password = 0 ExecLogin = 0 Guard = 0 [AntiBrute] Interval = 90 Penalty = 180 MaxAttempts = 5 [AntiBruteIP] Interval = 90 Penalty = 300 MaxAttempts = 10 Link to comment Share on other sites More sharing options...
0 eressea Posted July 28, 2017 Share Posted July 28, 2017 So you're using old NCsoft hash. You should use at least MD5Simple, just change MD5Simple=0 to MD5Simple=1 and then you can create user account this way: INSERT INTO user_auth (account, password, quiz1, quiz2, answer1, answer2, new_pwd_flag, lastat) VALUES ('mylogin', HashBytes('MD5', 'mypassword'), '1', '1', CAST('' AS VARBINARY), CAST('' AS VARBINARY), 0, NULL); INSERT INTO user_account (account, pay_stat, login_flag, warn_flag, block_flag, block_flag2, subscription_flag) VALUES ('mylogin', 1, 0, 0, 0, 0, 0); Link to comment Share on other sites More sharing options...
0 L2shaken Posted July 29, 2017 Author Share Posted July 29, 2017 (edited) So you're using old NCsoft hash. You should use at least MD5Simple, just change MD5Simple=0 to MD5Simple=1 and then you can create user account this way: INSERT INTO user_auth (account, password, quiz1, quiz2, answer1, answer2, new_pwd_flag, lastat) VALUES ('mylogin', HashBytes('MD5', 'mypassword'), '1', '1', CAST('' AS VARBINARY), CAST('' AS VARBINARY), 0, NULL); INSERT INTO user_account (account, pay_stat, login_flag, warn_flag, block_flag, block_flag2, subscription_flag) VALUES ('mylogin', 1, 0, 0, 0, 0, 0); INSERT INTO user_auth (teste, teste123, quiz1, quiz2, answer1, answer2, new_pwd_flag, lastat) VALUES ('mylogin', HashBytes('MD5', 'mypassword'), '1', '1', CAST('' AS VARBINARY), CAST('' AS VARBINARY), 0, NULL); INSERT INTO user_account (teste, pay_stat, login_flag, warn_flag, block_flag, block_flag2, subscription_flag) VALUES ('mylogin', 1, 0, 0, 0, 0, 0); in "mylogin" and "mypassword" do I owe my login/password too? edit; My tables have different rows. CREATE TABLE [dbo].[user_auth]( [account] [varchar](14) NOT NULL, [password] [binary](16) NOT NULL, [quiz1] [varchar](255) NOT NULL, [quiz2] [varchar](255) NOT NULL, [answer1] [binary](32) NOT NULL, [answer2] [binary](32) NOT NULL, [ipcreatefrom] [varchar](50) NULL, [createdate] [varchar](50) NULL, CONSTRAINT [PK_user_auth] PRIMARY KEY CLUSTERED ( [account] ASC ) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[user_account]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN CREATE TABLE [dbo].[user_account]( [uid] [int] IDENTITY(1,1) NOT NULL, [account] [varchar](14) NOT NULL, [pay_stat] [int] NOT NULL CONSTRAINT [DF_user_account__pay_stat] DEFAULT ((0)), [login_flag] [int] NOT NULL CONSTRAINT [DF_user_account__login_flag] DEFAULT ((0)), [warn_flag] [int] NOT NULL CONSTRAINT [DF_user_account__warn_flag] DEFAULT ((0)), [block_flag] [int] NOT NULL CONSTRAINT [DF_user_account__block_flag] DEFAULT ((0)), [block_flag2] [int] NOT NULL CONSTRAINT [DF_user_account__block_flag2] DEFAULT ((0)), [block_end_date] [datetime] NULL, [last_login] [datetime] NULL, [last_logout] [datetime] NULL, [subscription_flag] [int] NOT NULL CONSTRAINT [DF_user_account_subscription_flag] DEFAULT ((0)), [last_world] [tinyint] NULL, [last_game] [int] NULL, [last_ip] [varchar](15) NULL, [hkey] [varchar](16) NULL, [cheat] [int] NOT NULL DEFAULT ((0)), [mask] [varchar](15) NULL, [lastbanaction] [char](20) NULL, [lastadmin] [char](20) NULL, [lastdate] [char](40) NULL, [reason] [char](20) NULL, [verifystring] [char](24) NULL, CONSTRAINT [PK_user_account_] PRIMARY KEY CLUSTERED ( [account] ASC ) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[ssn]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN Edited July 29, 2017 by L2shaken Link to comment Share on other sites More sharing options...
0 eressea Posted July 29, 2017 Share Posted July 29, 2017 INSERT INTO user_auth (account, password, quiz1, quiz2, answer1, answer2) VALUES ('teste', HashBytes('MD5', 'teste123'), '1', '1', CAST('' AS VARBINARY), CAST('' AS VARBINARY)); INSERT INTO user_account (account, pay_stat, login_flag, warn_flag, block_flag, block_flag2, subscription_flag) VALUES ('teste', 1, 0, 0, 0, 0, 0); Link to comment Share on other sites More sharing options...
Question
L2shaken
Hello, I am configuring a server l2off on my machine, but I have a problem when creating the character, I enter login / password and the wrong password message appears and that's it, what can it be?
Pack Vanganth.
Print: http://imgur.com/s0tLZKm
Edited by L2shakenLink to comment
Share on other sites
13 answers to this question
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now