Jump to content
TrinityCore

Starting up worldserver and immediately have 'AccountMgr' messages?


Billy
 Share

Recommended Posts

6 hours ago, Billy said:

Anybody know what this might mean?

Well, you can see in server/game/Accounts/AccountMgr.cpp that it's caused by something calling AccountMgr::HasPermission without supplying an accountId. Since that file hasn't been changed in a while, it's an issue with the caller or your databases.

I suspect that one of your accounts has somehow got a zero account id or some change to the databases is causing HasPermission to be called without a valid account, but that's just a guess. You might narrow the possibilities down by using git bisect (http://webchick.net/node/99) to figure out where the problem started.

You could also do a web search and find this (possibly related?) problem which referred to auction house code: https://community.trinitycore.org/topic/11138-account-manager/ If the auction house is to blame, you might be able to fix it by clearing the auction data.

Link to comment
Share on other sites

Thanks dane! 

Wasn't sure if it might have been something to do with the auto updating of the SQL. I only get these messages when I've updated the server and run worldserver which adds the SQL updates automatically.

I'll dig farther into it using your suggestion of git bisect.

Link to comment
Share on other sites

  • 2 weeks later...
On 10/3/2018 at 4:18 PM, dane said:

Well, you can see in server/game/Accounts/AccountMgr.cpp that it's caused by something calling AccountMgr::HasPermission without supplying an accountId. Since that file hasn't been changed in a while, it's an issue with the caller or your databases.

I suspect that one of your accounts has somehow got a zero account id or some change to the databases is causing HasPermission to be called without a valid account, but that's just a guess. You might narrow the possibilities down by using git bisect (http://webchick.net/node/99) to figure out where the problem started.

You could also do a web search and find this (possibly related?) problem which referred to auction house code: https://community.trinitycore.org/topic/11138-account-manager/ If the auction house is to blame, you might be able to fix it by clearing the auction data.

Well tried to use git bisect, didn't find anything.

So .pdumped characters, and rebuilt the databases, and am currently recompiling this morning to see if it happens again.

Did notice a lot of sql's in the pull this morning, so will see if this corrected it or not.

Nope. Damn, had fingers crossed too. LOL!

servbootup1.jpg

Link to comment
Share on other sites

On 10/12/2018 at 10:00 AM, Billy said:

Well tried to use git bisect, didn't find anything.

So .pdumped characters, and rebuilt the databases, and am currently recompiling this morning to see if it happens again.

Did notice a lot of sql's in the pull this morning, so will see if this corrected it or not.

Nope. Damn, had fingers crossed too. LOL!

If bisect didn't fix it, that suggests that your database was the problem. When you say you rebuilt it, do you mean you started with an empty database? That would be my next step (after backing up the old database, naturally). If that worked, I'd try restoring the backup and deleting all the auction data. Note that you need to remove the auction items as well as the sell data. I've done this before, but forgot to take notes on the queries I used.

If an empty database doesn't work, I'm stumped. I need to update my server and see if there are any problems.

Link to comment
Share on other sites

15 hours ago, dane said:

If bisect didn't fix it, that suggests that your database was the problem. When you say you rebuilt it, do you mean you started with an empty database? That would be my next step (after backing up the old database, naturally). If that worked, I'd try restoring the backup and deleting all the auction data. Note that you need to remove the auction items as well as the sell data. I've done this before, but forgot to take notes on the queries I used.

If an empty database doesn't work, I'm stumped. I need to update my server and see if there are any problems.

That's exactly what I did. Deleted all 3 tables and pulled fresh source code to recompile and even changed out OS back to debian stretch.

Will have to wait until my next source pull to see if it works ok now.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By Voarsh
      I suppose this is two questions in one.
      I ".reset spells", etc and now when I login to WowTLK 3.3.5A I get "can't speak that language"
      I have a macro that selects a language and then I can talk normally.... or I can just choose a language. What language is my char/client trying to use?
      I cleared my account/cache in my client. Only new chars work.
       
      I then thought, I can't solve this, all I can do is "select" a language every login... I can't even use GM commands until i do.
      So, perhaps make a new char and "copy" the quests over.... I've no idea how I might do this.
       
      Any help?
    • By ChiefMcClane
      Hello folks
      I once updated my Trinity Server (3.3.5a) to the latest version (30.09.2020), unfortunately my Draenei Warlock is now broken.  I once created one in an older version by simply changing the breed in the database. After the update I couldn't select it at first, because the combination is invalid. This message came in the console. 
      I did some research and found out that the playercreateinfo_ tables have to be filled. I did that.
      I can log in now, but it seems that I have no language. The error message "you can not speak this language" appears in the chat. I cannot select a language either. I have already tried many things, including adding the skills, but the error remains. 
      I can't remember that it was so difficult in the past, has anything been changed?
    • By shroom
      Hi,
      Following one recent commit officially adding MariaDB 10.4 support, I took this opportunity to update my database server (from MariaDB 10.1 to MariaDB 10.4) and compiled the game server with the corresponding libraries instead of MySQL 5.7.
      Everything went fine and the server runs properly.
      I had one tiny little issue though: I had to fill the MySQLExecutable variable in the conf file otherwise the worldserver executable wouldn't launch:
      Didn't find any executable MySQL binary at '/Server/Release/bin/Release' or in path, correct the path in the *.conf ("MySQLExecutable").
      I never had to fill this variable before and it was still working fine with this commit: https://github.com/TrinityCore/TrinityCore/commit/48c700347c91b1748427a8c5b09b8d4099c9a105
      I'm running with this commit at the moment: https://github.com/TrinityCore/TrinityCore/commit/43d9ffd1bc127768882711a47d5e2bae92845d04
      It's not that big of deal obviously, but the worldserver conf file states for this variable:
      If the path is left empty, built-in path from cmake is used.
      Alas, while being properly set in CMake, the path isn't used anymore.
      Is this the new expected behavior or is this a bug?
    • By leandrod
      Hello guys,
      I was wondering that would be nice if i can active the flying mounts in Azeroth allowing the players to use it in Orgrimmar for example.
      So, here's my question: is there any way to do that in the server core side? I know that the game doesnt support flying mounts in Azeroth in the retail but i would like to do it (if its possible).
      I've serched in the forum for it and didn't find anything about it.
      Thanks for the help!
    • By Billy
      Placed several items in the AH today with the 24 hour setting to check with, restarted both world and auth servers, and the items placed in AH were no longer there, nor was there any mail for items sold or returned.
      TrinityCore rev. 59682bbd9b33 2019-02-09 21:06:09 +0100 (3.3.5 branch) (Unix, RelWithDebInfo, Static) (worldserver-daemon)
       
×
×
  • Create New...