[OFCBINS]Corsair ODBC correct setup order?

[Momoka Hiroka]

Tryna setup Corsair on a VM and I am stuck at this part of the setup:

"Step 8: Now you will open ODBC (32bit) to recover the dsn files. Run %windir%\system32\odbcad32.exe Step 9: Select your Corsair

Server Field like the Picture From tutorial "DSN1 Corsair Field.png" to "DSN7 Corsair Field.png"

Step 10: Repeat the process for files that are marked with a red line on IMAGE "DSN1 Corsair Field.png"

No images were attached to these instructions afaik and I have forgotten since the last time I setup corsair which was like back in March.

I think more people than just me would be grateful for this information as it is pretty vital, thank you.

 

[Archgeus]

There's no need for you to do that, the dsn's already exist in \Corsair_*\GameServerData\

Being * both Login and Field folders

Just edit with a notepad the MSSQL server and you're gtg

 

[Momoka Hiroka]

Ahhh ok, tysm, when I first setup the server on my VPS I manually added them to the file dsn. But if you don't have to do that then that's even better.

 

[Archgeus]

Ahhh ok, tysm, when I first setup the server on my VPS I manually added them to the file dsn. But if you don't have to do that then that's even better.

Yep, just don't move the dsn's files from "GameServerData", leave it there

 

[finaln1]

There's no need for you to do that, the dsn's already exist in \Corsair_*\GameServerData\

Being * both Login and Field folders

Just edit with a notepad the MSSQL server and you're gtg

hello. I really don't know how to set up world.dsn.
Below is the contents of the file.

Corsair_FieldClear\GameServerData\world.dsn
[ODBC]
DRIVER=ODBC Driver 17 for SQL Server
UID=CrimsonDesert
TrustServerCertificate=No
DATABASE=SA_BETA_WORLDDB_0002
WSID=DEVKIT
APP=PearlAbyss_BlackDesert_Real
Trusted_Connection=No
SERVER=127.0.0.1,4566

CorsairLogin\GameServerData\world.dsn
[ODBC]
DRIVER=ODBC Driver 17 for SQL Server
UID=CrimsonDesert
TrustServerCertificate=No
DATABASE=SA_BETA_WORLDDB_0002
WSID=DEVKIT
APP=PearlAbyss_BlackDesert_Real
Trusted_Connection=No
SERVER=127.0.0.1,4566


But when I run the server, the following error occurs.

{"Date":"2024-01-17 15:08:36","ThreadId":"0x359C","LogType":"00","ServiceLogLevel":"0","LogLevel":"6", "ErrorNo":"eErrNoSqlCantOpenDbSession","ErrorString":"Cannot initialize DB Session.","Log":"c:/bdo free/corsair/corsair_login/corsairlogin/GameServerData/world.dsn(CrimsonDesert:BlackNo. 1Game#^%):08001:[Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Wait operation timed out.
" }
{"Date":"2024-01-17 15:08:36","ThreadId":"0x359C","LogType":"00","ServiceLogLevel":"0","LogLevel":"6", "ErrorNo":"eErrNoThreadStorageCantOpen","ErrorString":"Could not initialize thread storage.","Log":"(Authentication_ReleaseOp_x64_unpack):ErrNo(2532724686)" }

I created a user by executing the query below in MSSQL Server 2019 and confirmed that it logged in to the server normally.

USE [master]
GO
CREATE LOGIN CrimsonDesert WITH PASSWORD = 'BlackNo.1Game#^%';
GO
CREATE LOGIN CrimsonTool WITH PASSWORD = 'BlackNo.1Game#^%';

And I changed the sa user's password to BlackNoDesert1# and confirmed that it also logged in normally.

I want to solve it myself, but the installation manual is missing picture files (.png), so I just can't figure out how to do it.

If you don't mind, please help.
thank you

 

[Archgeus]

hello. I really don't know how to set up world.dsn.
Below is the contents of the file.

Corsair_FieldClear\GameServerData\world.dsn
[ODBC]
DRIVER=ODBC Driver 17 for SQL Server
UID=CrimsonDesert
TrustServerCertificate=No
DATABASE=SA_BETA_WORLDDB_0002
WSID=DEVKIT
APP=PearlAbyss_BlackDesert_Real
Trusted_Connection=No
SERVER=127.0.0.1,4566

CorsairLogin\GameServerData\world.dsn
[ODBC]
DRIVER=ODBC Driver 17 for SQL Server
UID=CrimsonDesert
TrustServerCertificate=No
DATABASE=SA_BETA_WORLDDB_0002
WSID=DEVKIT
APP=PearlAbyss_BlackDesert_Real
Trusted_Connection=No
SERVER=127.0.0.1,4566


But when I run the server, the following error occurs.

{"Date":"2024-01-17 15:08:36","ThreadId":"0x359C","LogType":"00","ServiceLogLevel":"0","LogLevel":"6", "ErrorNo":"eErrNoSqlCantOpenDbSession","ErrorString":"Cannot initialize DB Session.","Log":"c:/bdo free/corsair/corsair_login/corsairlogin/GameServerData/world.dsn(CrimsonDesert:BlackNo. 1Game#^%):08001:[Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Wait operation timed out.
" }
{"Date":"2024-01-17 15:08:36","ThreadId":"0x359C","LogType":"00","ServiceLogLevel":"0","LogLevel":"6", "ErrorNo":"eErrNoThreadStorageCantOpen","ErrorString":"Could not initialize thread storage.","Log":"(Authentication_ReleaseOp_x64_unpack):ErrNo(2532724686)" }

I created a user by executing the query below in MSSQL Server 2019 and confirmed that it logged in to the server normally.

USE [master]
GO
CREATE LOGIN CrimsonDesert WITH PASSWORD = 'BlackNo.1Game#^%';
GO
CREATE LOGIN CrimsonTool WITH PASSWORD = 'BlackNo.1Game#^%';

And I changed the sa user's password to BlackNoDesert1# and confirmed that it also logged in normally.

I want to solve it myself, but the installation manual is missing picture files (.png), so I just can't figure out how to do it.

If you don't mind, please help.
thank you

Hi,

Currently your error is

TCP Provider: Wait operation timed out.

Unless you have your sqlserver serving on port 4566, if not then that's your error.

By default sqlserver serves as port 1433, so change

SERVER=127.0.0.1,4566

To

SERVER=127.0.0.1,1433

 

[finaln1]

Hi,

Currently your error is



Unless you have your sqlserver serving on port 4566, if not then that's your error.

By default sqlserver serves as port 1433, so change

SERVER=127.0.0.1,4566

To

SERVER=127.0.0.1,1433

Thank you.
The previous problem was solved thanks to you.

I ran 1. Auth.cmd and checked 'good luck'.
I ran the next 2. Manager.cmd, but now I get the following error.

I don't understand why the manager failed when the auth was successful.


{"Date":"2024-01-18 04:09:11","ThreadId":"0x46E4","LogType":"00","ServiceLogLevel":"0","LogLevel":"1","ErrorNo":"eErrNoGameContentsOptionIsClosed","ErrorString":"게임컨텐츠옵션에서 닫혔습니다.","Log":" FuelInsertInfo: _characterKey 에 걸린 contentGroup(31089)가 (로컬라이징때문인지) 존재하지 않기에, 해당 기능이 모두 지원되지 않습니다." }
{"Date":"2024-01-18 04:09:11","ThreadId":"0x46E4","LogType":"00","ServiceLogLevel":"0","LogLevel":"6","ErrorNo":"eErrNoStaticStatusNotExistColumn","ErrorString":"고정 정보의 컬럼이 없습니다.","Log":"시트명=[Tutorial_Start_Event_Table]:없는열제목=[SelectedPanel]" }
{"Date":"2024-01-18 04:09:12","ThreadId":"0x46E4","LogType":"00","ServiceLogLevel":"0","LogLevel":"6","ErrorNo":"eErrNoCantLoadParameter","ErrorString":"Parameter를 가져올 수 없습니다.","Log":"ErrNo(eErrNoStaticStatusNotExistColumn(837199619):[고정 정보의 컬럼이 없습니다.])" }
{"Date":"2024-01-18 04:09:12","ThreadId":"0x46E4","LogType":"00","ServiceLogLevel":"0","LogLevel":"6","ErrorNo":"eErrNoTimerDaemonFailInitializeFunction","ErrorString":"Timer데몬이 초기화 함수 호출에 실패했다.","Log":"ErrNo(3407982563)" }
{"Date":"2024-01-18 04:09:12","ThreadId":"0x46E4","LogType":"00","ServiceLogLevel":"0","LogLevel":"6","ErrorNo":"eErrNoTimerDaemonCantStart","ErrorString":"Timer데몬을 시작할 수 없습니다.","Log":"ErrNo(2051413970)" }

 

[Archgeus]

Thank you.
The previous problem was solved thanks to you.

I ran 1. Auth.cmd and checked 'good luck'.
I ran the next 2. Manager.cmd, but now I get the following error.

I don't understand why the manager failed when the auth was successful.


{"Date":"2024-01-18 04:09:11","ThreadId":"0x46E4","LogType":"00","ServiceLogLevel":"0","LogLevel":"1","ErrorNo":"eErrNoGameContentsOptionIsClosed","ErrorString":"게임컨텐츠옵션에서 닫혔습니다.","Log":" FuelInsertInfo: _characterKey 에 걸린 contentGroup(31089)가 (로컬라이징때문인지) 존재하지 않기에, 해당 기능이 모두 지원되지 않습니다." }
{"Date":"2024-01-18 04:09:11","ThreadId":"0x46E4","LogType":"00","ServiceLogLevel":"0","LogLevel":"6","ErrorNo":"eErrNoStaticStatusNotExistColumn","ErrorString":"고정 정보의 컬럼이 없습니다.","Log":"시트명=[Tutorial_Start_Event_Table]:없는열제목=[SelectedPanel]" }
{"Date":"2024-01-18 04:09:12","ThreadId":"0x46E4","LogType":"00","ServiceLogLevel":"0","LogLevel":"6","ErrorNo":"eErrNoCantLoadParameter","ErrorString":"Parameter를 가져올 수 없습니다.","Log":"ErrNo(eErrNoStaticStatusNotExistColumn(837199619):[고정 정보의 컬럼이 없습니다.])" }
{"Date":"2024-01-18 04:09:12","ThreadId":"0x46E4","LogType":"00","ServiceLogLevel":"0","LogLevel":"6","ErrorNo":"eErrNoTimerDaemonFailInitializeFunction","ErrorString":"Timer데몬이 초기화 함수 호출에 실패했다.","Log":"ErrNo(3407982563)" }
{"Date":"2024-01-18 04:09:12","ThreadId":"0x46E4","LogType":"00","ServiceLogLevel":"0","LogLevel":"6","ErrorNo":"eErrNoTimerDaemonCantStart","ErrorString":"Timer데몬을 시작할 수 없습니다.","Log":"ErrNo(2051413970)" }

TimeZone error

eErrNoTimerDaemonCantStart

 

[finaln1]

TimeZone error

I found the cause.
Auth runs normally, but it was strange for the Manager to get an error, so I reviewed it again from the beginning.
It was caused by overwriting the contents of service.ini shown in the installation manual on my service.ini. So, when I changed the IP address to the original service.ini content, all servers ran fine.

Thank you for your response.