Help on services please!

[balistaus]

Hey guys, I used to host a server for my friend and I but a few days ago i reformatted my pc with the same windows that I used back then and encountered a problem. My problem are AccountLog, Character & Gamelog service wont start, it gives an error 1053: The service didn't respond to the start....

I checked the debugmessage folder for the 3 and it seems to ended at

"2016-10-30 02:21:27 <NUMBER OF 40 IOCP WORKTHREAD STARTED, 8 CPU DETECTED>"

I did change the security for NT Authority\system in my db -> user mapping for accountlog and every fiesta related services. I also change the HOSTS file in system32/driver/etc. I set the ip to 127.0.0.1 and tested connection on odbc.

Is there anything I miss? thanks!

 

[ciruzziello]

Hello
Im new about creating private fiesta server, I got the same issue, I use KH database and server files, but I do not have that issue using Odin server files and database, is just strange.

I read that I need to change ip adress for kh server with HEx, but I don't know if I need to change it for that exe 3LoginServer2

so Im sorry Balistaus if I can't help u more



000029 2016-10-30 12:42:32 DB_Init FAILED = DSN=Account_CN; UID=sa; PWD=azerty
000030 2016-10-30 12:42:32 <SESSION WORKER #0 INIT DB FAILED - STOP ******>
000031 2016-10-30 12:42:32 < END OF MAIN = 0 >
000032 2016-10-30 12:42:32 <IOCP WORKTHREAD #1 FREE>
000033 2016-10-30 12:42:32 <IOCP WORKTHREAD #18 FREE>
000034 2016-10-30 12:42:32 <IOCP WORKTHREAD #0 FREE>
000035 2016-10-30 12:42:32 <IOCP WORKTHREAD #17 FREE>
000036 2016-10-30 12:42:32 <IOCP WORKTHREAD #19 FREE>
000037 2016-10-30 12:42:32 <IOCP WORKTHREAD #14 FREE>
000038 2016-10-30 12:42:32 <IOCP WORKTHREAD #13 FREE>
000039 2016-10-30 12:42:32 <IOCP WORKTHREAD #15 FREE>
000040 2016-10-30 12:42:32 <IOCP WORKTHREAD #11 FREE>
000041 2016-10-30 12:42:32 <IOCP WORKTHREAD #10 FREE>
000042 2016-10-30 12:42:32 <IOCP WORKTHREAD #9 FREE>
000043 2016-10-30 12:42:32 <IOCP WORKTHREAD #7 FREE>
000044 2016-10-30 12:42:32 <IOCP WORKTHREAD #6 FREE>
000045 2016-10-30 12:42:32 <IOCP WORKTHREAD #5 FREE>
000046 2016-10-30 12:42:32 <IOCP WORKTHREAD #16 FREE>
000047 2016-10-30 12:42:32 <IOCP WORKTHREAD #3 FREE>
000048 2016-10-30 12:42:32 <IOCP WORKTHREAD #2 FREE>
000049 2016-10-30 12:42:32 <IOCP WORKTHREAD #12 FREE>
000050 2016-10-30 12:42:32 <IOCP WORKTHREAD #8 FREE>
000000 2016-10-30 12:46:27 C:\Users\Fiesta\Documents\Story\Hunter Kingdom Files\Server\Account
000001 2016-10-30 12:46:28 -------------------------------------------------------
000002 2016-10-30 12:46:28 Launching the server.....
000003 2016-10-30 12:46:28 Local Time 30/10/2016 12:46:28
000004 2016-10-30 12:46:28 System Time(UTC) 30/10/2016 11:46:28
000005 2016-10-30 12:46:28 <SUCCESSED SCRIPTOR READ> DataServerInfo_Account.txt
000006 2016-10-30 12:46:28 <I AM THE _Villian_Account_DB, SERVER_ID_DB_ACCOUNT, WorldNo=0, ZoneNo=0>
000007 2016-10-30 12:46:28 Service start(no parameter)
000008 2016-10-30 12:46:28 <IOCP WORKTHREAD #0 RUNNING>
000009 2016-10-30 12:46:28 <IOCP WORKTHREAD #1 RUNNING>
000010 2016-10-30 12:46:28 <IOCP WORKTHREAD #2 RUNNING>
000011 2016-10-30 12:46:28 <IOCP WORKTHREAD #3 RUNNING>
000012 2016-10-30 12:46:28 <IOCP WORKTHREAD #4 RUNNING>
000013 2016-10-30 12:46:28 <IOCP WORKTHREAD #5 RUNNING>
000014 2016-10-30 12:46:28 <IOCP WORKTHREAD #6 RUNNING>
000015 2016-10-30 12:46:28 <IOCP WORKTHREAD #7 RUNNING>
000016 2016-10-30 12:46:28 <IOCP WORKTHREAD #8 RUNNING>
000017 2016-10-30 12:46:28 <IOCP WORKTHREAD #9 RUNNING>
000018 2016-10-30 12:46:28 <IOCP WORKTHREAD #10 RUNNING>
000019 2016-10-30 12:46:28 <IOCP WORKTHREAD #11 RUNNING>
000020 2016-10-30 12:46:28 <IOCP WORKTHREAD #12 RUNNING>
000021 2016-10-30 12:46:28 <IOCP WORKTHREAD #13 RUNNING>
000022 2016-10-30 12:46:28 <IOCP WORKTHREAD #14 RUNNING>
000023 2016-10-30 12:46:28 <IOCP WORKTHREAD #15 RUNNING>
000024 2016-10-30 12:46:28 <IOCP WORKTHREAD #16 RUNNING>
000025 2016-10-30 12:46:28 <IOCP WORKTHREAD #17 RUNNING>
000026 2016-10-30 12:46:29 <IOCP WORKTHREAD #18 RUNNING>
000027 2016-10-30 12:46:29 <IOCP WORKTHREAD #19 RUNNING>
000028 2016-10-30 12:46:29 <NUMBER OF 20 IOCP WORKTHREAD STARTED, 4 CPU DETECTED>
000029 2016-10-30 12:46:29 DB_Init FAILED = DSN=Account_CN; UID=sa; PWD=azerty
000030 2016-10-30 12:46:29 <SESSION WORKER #0 INIT DB FAILED - STOP ******>
000031 2016-10-30 12:46:29 < END OF MAIN = 0 >
000032 2016-10-30 12:46:29 <IOCP WORKTHREAD #17 FREE>
000033 2016-10-30 12:46:29 <IOCP WORKTHREAD #1 FREE>
000034 2016-10-30 12:46:29 <IOCP WORKTHREAD #16 FREE>
000035 2016-10-30 12:46:29 <IOCP WORKTHREAD #15 FREE>
000036 2016-10-30 12:46:29 <IOCP WORKTHREAD #0 FREE>

 

[balistaus]

Hello
Im new about creating private fiesta server, I got the same issue, I use KH database and server files, but I do not have that issue using Odin server files and database, is just strange.

I read that I need to change ip adress for kh server with HEx, but I don't know if I need to change it for that exe 3LoginServer2

so Im sorry Balistaus if I can't help u more



000029 2016-10-30 12:42:32 DB_Init FAILED = DSN=Account_CN; UID=sa; PWD=azerty
000030 2016-10-30 12:42:32 <SESSION WORKER #0 INIT DB FAILED - STOP ******>
000031 2016-10-30 12:42:32 < END OF MAIN = 0 >
000032 2016-10-30 12:42:32 <IOCP WORKTHREAD #1 FREE>
000033 2016-10-30 12:42:32 <IOCP WORKTHREAD #18 FREE>
000034 2016-10-30 12:42:32 <IOCP WORKTHREAD #0 FREE>
000035 2016-10-30 12:42:32 <IOCP WORKTHREAD #17 FREE>
000036 2016-10-30 12:42:32 <IOCP WORKTHREAD #19 FREE>
000037 2016-10-30 12:42:32 <IOCP WORKTHREAD #14 FREE>
000038 2016-10-30 12:42:32 <IOCP WORKTHREAD #13 FREE>
000039 2016-10-30 12:42:32 <IOCP WORKTHREAD #15 FREE>
000040 2016-10-30 12:42:32 <IOCP WORKTHREAD #11 FREE>
000041 2016-10-30 12:42:32 <IOCP WORKTHREAD #10 FREE>
000042 2016-10-30 12:42:32 <IOCP WORKTHREAD #9 FREE>
000043 2016-10-30 12:42:32 <IOCP WORKTHREAD #7 FREE>
000044 2016-10-30 12:42:32 <IOCP WORKTHREAD #6 FREE>
000045 2016-10-30 12:42:32 <IOCP WORKTHREAD #5 FREE>
000046 2016-10-30 12:42:32 <IOCP WORKTHREAD #16 FREE>
000047 2016-10-30 12:42:32 <IOCP WORKTHREAD #3 FREE>
000048 2016-10-30 12:42:32 <IOCP WORKTHREAD #2 FREE>
000049 2016-10-30 12:42:32 <IOCP WORKTHREAD #12 FREE>
000050 2016-10-30 12:42:32 <IOCP WORKTHREAD #8 FREE>
000000 2016-10-30 12:46:27 C:\Users\Fiesta\Documents\Story\Hunter Kingdom Files\Server\Account
000001 2016-10-30 12:46:28 -------------------------------------------------------
000002 2016-10-30 12:46:28 Launching the server.....
000003 2016-10-30 12:46:28 Local Time 30/10/2016 12:46:28
000004 2016-10-30 12:46:28 System Time(UTC) 30/10/2016 11:46:28
000005 2016-10-30 12:46:28 <SUCCESSED SCRIPTOR READ> DataServerInfo_Account.txt
000006 2016-10-30 12:46:28 <I AM THE _Villian_Account_DB, SERVER_ID_DB_ACCOUNT, WorldNo=0, ZoneNo=0>
000007 2016-10-30 12:46:28 Service start(no parameter)
000008 2016-10-30 12:46:28 <IOCP WORKTHREAD #0 RUNNING>
000009 2016-10-30 12:46:28 <IOCP WORKTHREAD #1 RUNNING>
000010 2016-10-30 12:46:28 <IOCP WORKTHREAD #2 RUNNING>
000011 2016-10-30 12:46:28 <IOCP WORKTHREAD #3 RUNNING>
000012 2016-10-30 12:46:28 <IOCP WORKTHREAD #4 RUNNING>
000013 2016-10-30 12:46:28 <IOCP WORKTHREAD #5 RUNNING>
000014 2016-10-30 12:46:28 <IOCP WORKTHREAD #6 RUNNING>
000015 2016-10-30 12:46:28 <IOCP WORKTHREAD #7 RUNNING>
000016 2016-10-30 12:46:28 <IOCP WORKTHREAD #8 RUNNING>
000017 2016-10-30 12:46:28 <IOCP WORKTHREAD #9 RUNNING>
000018 2016-10-30 12:46:28 <IOCP WORKTHREAD #10 RUNNING>
000019 2016-10-30 12:46:28 <IOCP WORKTHREAD #11 RUNNING>
000020 2016-10-30 12:46:28 <IOCP WORKTHREAD #12 RUNNING>
000021 2016-10-30 12:46:28 <IOCP WORKTHREAD #13 RUNNING>
000022 2016-10-30 12:46:28 <IOCP WORKTHREAD #14 RUNNING>
000023 2016-10-30 12:46:28 <IOCP WORKTHREAD #15 RUNNING>
000024 2016-10-30 12:46:28 <IOCP WORKTHREAD #16 RUNNING>
000025 2016-10-30 12:46:28 <IOCP WORKTHREAD #17 RUNNING>
000026 2016-10-30 12:46:29 <IOCP WORKTHREAD #18 RUNNING>
000027 2016-10-30 12:46:29 <IOCP WORKTHREAD #19 RUNNING>
000028 2016-10-30 12:46:29 <NUMBER OF 20 IOCP WORKTHREAD STARTED, 4 CPU DETECTED>
000029 2016-10-30 12:46:29 DB_Init FAILED = DSN=Account_CN; UID=sa; PWD=azerty
000030 2016-10-30 12:46:29 <SESSION WORKER #0 INIT DB FAILED - STOP ******>
000031 2016-10-30 12:46:29 < END OF MAIN = 0 >
000032 2016-10-30 12:46:29 <IOCP WORKTHREAD #17 FREE>
000033 2016-10-30 12:46:29 <IOCP WORKTHREAD #1 FREE>
000034 2016-10-30 12:46:29 <IOCP WORKTHREAD #16 FREE>
000035 2016-10-30 12:46:29 <IOCP WORKTHREAD #15 FREE>
000036 2016-10-30 12:46:29 <IOCP WORKTHREAD #0 FREE>

it looks like your database name not matching your db config file? I managed to "fix" my problem, it seems that it loaded very2 slow(5 mnts+), once it loaded though i got and authentication failed which i fixed by unchecking db_deny something, its on faq. I dont think it's related to your problem and i still have to figure out why it start sooo slow.

 

[Rakinare]

The error you are getting says that it can't connect to the database. So either your login is wrong or the database is named wrong ot ODBC isn't setup correctly.

 

[ciruzziello]

hey thank you guys, Im sorry for be being late, I didn't check the page. thank again
actually that problem is solved, but I have another seriously problem, is Odinserver doest launch in services.msc I have

[2] [11/6/2016 4:43:32 AM] :: Start MSSQL Connect: [Fiesta-PC\SQLEXPRESS].[OdinAccounts]
[3] [11/6/2016 4:43:32 AM] :: ******DATABASE CONNECT FAIL******
[3] [11/6/2016 4:43:32 AM] :: Cannot open database "OdinAccounts" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\SYSTEM'.

NT AUTHORITY\SYSTEM' has been changed for odinaccount ( all case selected) I did all over scratch 4 times, and windows 7 reinstalled included. I really dont know what's wrong, nly hk files works on my computer.

thank you for helping.
my shype is sheider05 if someone would like to check ty a lot



hey thank you guys, Im sorry for be being late, I didn't check the page. thank again
actually that problem is solved, but I have another seriously problem, is Odinserver doest launch in services.msc I have

[2] [11/6/2016 4:43:32 AM] :: Start MSSQL Connect: [Fiesta-PC\SQLEXPRESS].[OdinAccounts]
[3] [11/6/2016 4:43:32 AM] :: ******DATABASE CONNECT FAIL******
[3] [11/6/2016 4:43:32 AM] :: Cannot open database "OdinAccounts" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\SYSTEM'.

NT AUTHORITY\SYSTEM' has been changed for odinaccount ( all case selected) I did all over scratch 4 times, and windows 7 reinstalled included. I really dont know what's wrong, nly hk files works on my computer.

thank you for helping.
my shype is sheider05 if someone would like to check ty a lot

 

[aqua512]

Set the permissions in SQL.

 

[ciruzziello]

hey aqua THe permission was fixed and didn't work too, so I disabled sql server reporting service (is a good to to that?)
Odinserver launched now, but I havent tryed yet to open client.



and thank you answering me, is nice from you, thank you again

 

[aqua512]

It won't hurt anything, it's just the report server keeps track of errors and such.

 

[ciruzziello]

awww ok ty, so now I have contection to the server failed, all my services work. my client is Oxion,



is all ok thank you, I found. as a jerk I forgot the - letter XD I wish you a good sunday