Sourcemod plugins not able to post to database

moxie2020 · **Author**

I have 4 databases that I moved to a new SQL server.
2 of them post new data fine 2 do not at all...

They are using the exact same settings as each other and the database names have been verified. The user has the same priveleges on all the schemas.

It seems like this has to be some thing very simple.

YamiKaitou · 06-21-2013 , 22:06 Re: Sourcemod plugins not able to post to database

Anything in the logs?

moxie2020 · 06-21-2013 , 23:00

Quote:

Originally Posted by YamiKaitou

Anything in the logs?

Not a thing... I can see them connected in status.. Nothing comes through.

finally able to get an error:

error: [1045]: Access denied for user 'USER'

moxie2020 · 06-23-2013 , 14:16 Re: Sourcemod plugins not able to post to database

It turns out after 72 hours of pulling my hair out its a simple but puzzling issue.
All the plugins weren't sending data because sourcemod never loaded the admins. I have to manually do sm_reloadadmins on each server. The second I do the servers work fine.

The odd thing is I manually executed the commands with rcon but 3 separate plugins would not send any information to the database until I reloaded the admins.

Can someone explain whats happening and how I might prevent it in the future?