Jump to content

Question

Recommended Posts

  • 0
Posted
8 hours ago, ShadowX256 said:

Windows 7 x64 Pro

SQL Server 2008

 

Created the OBDC files with C:\Windows\SysWOW64\odbcad32.exe

Capturar.PNG

you need to paste the whole errors either from the log or maximize the window and grab a bigger screenshot, cant see what the actual sql server is from that one

  • 0
Posted
9 hours ago, Anarchy said:

you need to paste the whole errors either from the log or maximize the window and grab a bigger screenshot, cant see what the actual sql server is from that one

2

Just switched the Screenshot to a bigger one. And the L2AuthDError.txt is bloody empty.

 

1 hour ago, MasterToma said:

All possible startup SQL queries are failed. Probably this user doesn't have rights to the lin2db, or something else is wrong in DB settings

 

Where can I see the user's rights?

 

By the way, I tried to run it with SQL Express 2005, but the same errors happen.

  • 0
Posted
4 hours ago, ShadowX256 said:

Just switched the Screenshot to a bigger one. And the L2AuthDError.txt is bloody empty.

 

 

Where can I see the user's rights?

 

By the way, I tried to run it with SQL Express 2005, but the same errors happen.

looks like classic wrong default database, in the odbc dsn settings you'll want to set the default database to lin2db as shown below

 

Screenshot_10.png

  • 0
Posted (edited)
1 hour ago, Anarchy said:

looks like classic wrong default database, in the odbc dsn settings you'll want to set the default database to lin2db as shown below

 

Screenshot_10.png

 

The AuthD returns "Invalid object name 'server' ", but once I run SELECT * FROM [dbo].[server] on Management Studio it works just fine.

 

About the dsn, I just checked it again and it seems okay to me. The dsn files are down below.

 

lin2clancomm.dsn

 

[ODBC]
DRIVER=SQL Server
UID=sa
DATABASE=lin2clancomm
WSID=STRIKEX
APP=Microsoft® Windows® Operating System
SERVER=STRIKEX\SQLEXPRESS
 

lin2comm.dsn

 

[ODBC]
DRIVER=SQL Server
UID=sa
DATABASE=lin2comm
WSID=STRIKEX
APP=Microsoft® Windows® Operating System
SERVER=STRIKEX\SQLEXPRESS

 

lin2db.dsn

 

[ODBC]
DRIVER=SQL Server
UID=sa
DATABASE=lin2db
WSID=STRIKEX
APP=Microsoft® Windows® Operating System
SERVER=STRIKEX\SQLEXPRESS
 

lin2log.dsn

 

[ODBC]
DRIVER=SQL Server
UID=sa
DATABASE=lin2log
WSID=STRIKEX
APP=Microsoft® Windows® Operating System
SERVER=STRIKEX\SQLEXPRESS
 

lin2report.dsn

 

[ODBC]
DRIVER=SQL Server
UID=sa
DATABASE=lin2report
WSID=STRIKEX
APP=Microsoft® Windows® Operating System
SERVER=STRIKEX\SQLEXPRESS
 

lin2user.dsn

 

[ODBC]
DRIVER=SQL Server
UID=sa
DATABASE=lin2user
WSID=STRIKEX
APP=Microsoft® Windows® Operating System
SERVER=STRIKEX\SQLEXPRESS
 

lin2world.dsn

 

[ODBC]
DRIVER=SQL Server
UID=sa
DATABASE=lin2world
WSID=STRIKEX
APP=Microsoft® Windows® Operating System
SERVER=STRIKEX\SQLEXPRESS
 

 

authD-3.PNG

Edited by ShadowX256
Couldn't see the text
  • 0
Posted

yeah that's pretty funky it definitely looks correct, do you have multiple sql instances installed perhaps? it could be connecting to the wrong one

  • 0
Posted (edited)
59 minutes ago, Anarchy said:

yeah that's pretty funky it definitely looks correct, do you have multiple sql instances installed perhaps? it could be connecting to the wrong one

 

I don't think so, removed everything from the 2008 Installation before installing the 2005 Express one. Here is a screenshot of the Configuration Manager.

 

 

authD-4.PNG

Edited by ShadowX256
  • 0
Posted
On 2/27/2019 at 4:42 PM, MasterToma said:

Try to remove everything under 


Software\\NCSoft\\L2AUTHD

And start again (remember, there might be few keys Software\\NCSoft\\L2AUTHD  in registry)

 

Yeah, I just tried that. It asks for the l2comm dsn file, but still doesn't work.

  • Like 1
  • 0
Posted (edited)
26 minutes ago, MasterToma said:

Why does it ask for l2comm... Write lin2db after cleaning the registry.

 

Thanks a lot, it totally worked, you and Anarchy were very kind to help me with this. I wish luck for both of you.

Please mark the problem solved, SOLUTION: link to lin2db instead of lin2comm, no idea why it asks for L2Conn.

authD-5.PNG

Edited by ShadowX256
  • Thanks 1
  • 0
Posted
On 27/02/2019 at 16:42, MasterToma said:

Tente remover tudo em 


E comece novamente (lembre-se, pode haver poucas chaves  Software \\ NCSoft \\ L2AUTHD   no registro)

Hello, how are you?

 

What is the way to reach this record and delete them? I am unable to perform this task. Can someone help me?

 

 

I thank you in advance.

 

erro.jpg.51c71c477eed081704566592436b7b5a.jpg

  • 0
Posted
55 minutes ago, looklin said:

Hello, how are you?

 

What is the way to reach this record and delete them? I am unable to perform this task. Can someone help me?

 

 

I thank you in advance.

 

erro.jpg.51c71c477eed081704566592436b7b5a.jpg


I don't think you've installed the databases properly...

  • Like 1
  • 0
Posted

This I managed to fix. Now I find the following error. Right after the server.exe closes.

 

err1.thumb.jpg.89f4369497b16169615dd097969df9fe.jpg

 

 

I get the following error in my LinError.txt

A:I:S:E:PE:DI:DE:BO=50.000000:4.000000:1.000000:25.000000:2.000000:0:0:0
L:Y:X:H=0:0:0:0:0
Crashed Thread[0].
CRASH
Server Up Time : Mon Apr 06 16:10:54 2020
Current Time : Mon Apr 06 16:11:26 2020
Elapsed Time : 0 days 0 hours 0 minutes 32 seconds
IOBufferPool - 19999 / 20000,  PendingWrite 10 bytes [0] 
=============== object report
user[0/0], npc[0/0], item[0/0], usersocket[0]
=============== npc server connection log 
no connect

[(568) 2020/04/06 16:11:26]: =======================
an Access Violation in module L2Server.exe at 0033:0054a6b8.
start at 2020/4/6 16:10:53
Write to location 00000000 caused an access violation.

Registers:
EAX=00000000 CS=0033 EIP=0054a6b8 EFLGS=00010246
EBX=00000000 SS=002b ESP=6d40fc20 EBP=0004c158
ECX=3f6ec8d0 DS=002b ESI=00400000 FS=0053
EDX=00000000 ES=002b EDI=00000000 GS=002b
Bytes at CS:EIP:
c6 03 01 65 48 8b 04 25 58 00 00 00 48 8b 0c f8 
Stack dump:
6d40fc20: 7850c084 00000000 0004c158 00000000 009d0560 00000000 00063244 00000000
6d40fc40: 7850c084 00000000 00002745 00000000 fffffffe ffffffff 00355480 00000000
6d40fc60: 0004c158 00000000 0061e5f9 00000000 7850c084 00000000 00400000 00000000
6d40fc80: 00000000 00000000 00063244 00000000 6d40fe50 00000000 00000000 00000000
6d40fca0: 407b4088 00000000 fffffffe ffffffff 00004000 00000000 00000000 00000000
6d40fcc0: 407b4088 00000000 1ca72b9c 00000000 7850c084 00000000 0000000b 00000000
6d40fce0: 7183e89c 00000000 7850c084 00000000 6d40fd58 00000000 7850c0d4 00000000
6d40fd00: 00000000 00000000 77d60780 00000000 00004000 00000000 407b4098 00000000
6d40fd20: 00670140 00000000 00000002 00000000 00000002 00000000 7183e89c 00000000
6d40fd40: 0000000b 00000000 1ca71fac 00000000 00000000 00000000 00000000 00000000
6d40fd60: 00000000 00000000 0000000b 00000000 3c900064 00000000 3c900044 00000000
6d40fd80: fffffffe ffffffff 77d6b910 00000000 00063234 00000000 016648d6 00000000
6d40fda0: 00000001 00000000 00000000 00000000 00400000 00000000 1ca732bd 00000000
6d40fdc0: 7183e89c 00000000 7850c084 00000000 00000000 00000000 00a05220 00000000
6d40fde0: fffffffe ffffffff 00400000 00000000 00977230 00000000 0062501b 00000000


ver = Dec 16 2005_22:03:13


GuardInfo : 

IOThread [0][16] (ahehe):  void IOThread_common(void *arglist) -> void CIOSocket::Close() -> void CDBSocket::OnClose() -> CacheSocket Closed
    Lock Stack  : 

IOThread [1][16] (good):  void IOThread_common(void *arglist)
    Lock Stack  : 

ListenThread [13][23480500] (good):  void ListenThread_common() -> void CJobFinishSignal::Init() -> bool CJobFinishSignal::WaitFinish(JobFinishType JobType, unsigned int nTimeOutSec)
    Lock Stack  : 

MainThread [12][16] (good):      Lock Stack  : 

GuardInfo end 



[(568) 2020/04/06 16:11:26]: *.\ioc.cpp:648(Tue Dec 13 02:52:40 2005) exception

I did a lot of research but I didn't find the solution.

I appreciate anyone who can help me.

Guest
This topic is now closed to further replies.


  • Posts

    • pm me your discord or write it in comments.  buying through paypal. depending on the price around 5kk or item worth 5kk - both are good. 
    • We're looking for an experienced Java developer with deep knowledge of Lineage 2 private servers (L2J, Lucera, aCis, etc.). The ideal candidate has 5+ years of Java experience and has previously worked on customizing server mechanics, fixing bugs, and implementing new game features. Must be comfortable working independently and have a strong understanding of game systems like skills, classes, and PvP balance.
    • Hello, contact me on telegram Williams0ff
    • I have not touched a L2J style server in probably 13-14 years, as part of my "re-education" on server stuff I decided to build a installation script, hope some of you find it useful. NOTE: This script should only be run on a fresh Ubuntu 22/24 install, must be ran as root. I have only tested on 22 so far. What it does: - Checks to make sure you are root and are using Ubuntu 22/24 - Creates a system user for running aCis - Installs java jdk 21, Mariadb, Apache2 + PHP, Adminer, Ant - Created user and database for gameserver and login server - Creates user for Adminer - Adds second layer of security for Adminer (apache2 auth) - Runs secure_installation on Mariadb - Makes all .sh files executeable - Fills in Mariadb database information in database_installer.sh, config/server.properties, config/loginserver.properties - Runs database_installer.sh - Fetches aCis repository and builds it (supports public and private repo) - Moves all needed files into <user>/acis-built - Enables UFW and opens needed ports: 22, 80, 2106, 7777 - Installs fail2ban and configures protection for sshd (max 3 fails) - Retrieves geodata from http://anothercrappyinterludeserver.com/files/ and unpacks it in correct place - Fills in server IP in loginserver.properties Script is here: https://github.com/Salty-Dragon/aCis-installer-ubuntu   Help etc hop on Discord: https://discord.gg/QuZTw8pn3E    
    • Do your self a favour and keep your mouth shut up. I'm really getting tired of people like you. It seems like this forum has the most toxic members.  Can you share those „unsolved“ bugs? Just bla, bla, bla, but nothing to prove, right? Always the same with you  when you see my project name and always you got what to say bad about me or my project. This is your plan write something bad about others just to get more customers to yourself? Ah, those rotten people everywhere around us.
  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock