[Help Thread] Please post your questions here.

[thefear511]

Hi guys i need help x.x


this happened after I edited a couple of NPCS in Npcresource, i edited only periodic tables

can anyone please help me ?

[ThunderNikk]

Did you check your server services?

[thefear511]

Originally Posted by ThunderNikk

Did you check your server services?

me ? no where can i find those ? knowing that server was running perfectly fine before i edited NPCresource

[ThunderNikk]

MSSQL configuration manager

Services

[thefear511]

Originally Posted by ThunderNikk

MSSQL configuration manager

Services

hey I justed reinstalled MySQL cuz I ****** up my username and it worked. thx anyways ^^ I hope people benefit from this solution in future, cuz I did some googling before and saw a lot of people have it but no correct solution.

[ThunderNikk]

Well reinstalling MSSQL is the long way around a user name but if you think it helps to report that here as a solution then thank you at least for the reply on what you did.

But how did just an NPC resource edit have anything to do with your user name?

[thefear511]

Originally Posted by ThunderNikk

Well reinstalling MSSQL is the long way around a user name but if you think it helps to report that here as a solution then thank you at least for the reply on what you did.

But how did just an NPC resource edit have anything to do with your user name?

well, last 2 things I did were editing that table and messing around with sysadmin properties.

was all good even after I messed around with sysadmin and permissions, so I didn't think its the reason, well just reinstalled SQL instead of digging more deep took like 20minutes xD x.x

[Charliefoxtrott]

What is the SQL-table for the altar of the goddess in database? And/Or what lua/sp is used? (Both for items only.)

[thefear511]

Originally Posted by ThunderNikk

MSSQL configuration manager

Services

Hey again , **** i got this issue again after i changed my sa password
And i dont want to reinstall mysql cuz i have important data ☹
Could you please tell me what to do in the services ?

Originally Posted by Charliefoxtrott

What is the SQL-table for the altar of the goddess in database? And/Or what lua/sp is used? (Both for items only.)

Its a script in ect_functions

[ThunderNikk]

If you changed sa password in the database did you change in in your .opt files?

I believe there are 2 different password encryption tools for the .opt files depending on whether you are working with the 9.1 files or the older file releases.

Make sure you use the correct encryption tool.

This is probably not a down service issue but more likely an .opt file issue since you have changed the database user access. The .opt files need that same access change.

[thefear511]

Originally Posted by ThunderNikk

If you changed sa password in the database did you change in in your .opt files?

I believe there are 2 different password encryption tools for the .opt files depending on whether you are working with the 9.1 files or the older file releases.

Make sure you use the correct encryption tool.

This is probably not a down service issue but more likely an .opt file issue since you have changed the database user access. The .opt files need that same access change.

Hey im using 7.2 files , i used Des generator (encryptor) . I had couple of sucessful password changes that didnt break the auth but that was waay long back like 3 weeks
Does this look suspicious ?

[ThunderNikk]

Yeah start those 2 server services that are not running.

[thefear511]

Originally Posted by ThunderNikk

Yeah start those 2 server services that are not running.

I think auth was running with them disabled no? Is there a rappelz related topic i can take instructions from to how i can activate them ? Microsoft puts al lot of junk into their topics 💔🐌

[ThunderNikk]

have you tried restarting our computer?

[thefear511]

Originally Posted by ThunderNikk

have you tried restarting our computer?

https://imgur.com/UZsgCri
I did , and also i did compress auth opt and gameserver opt after every edit .

As you can see now the error message changed after i changed Pc language.