Azerothcore, worldserver: mysql: [ERROR] Failed to open required defaults - Stack Overflow

admin管理员组

文章数量:1415684

what does the titel mean?

System is Linux 22.04 Server DBs are there and open to be written! - Authserver writes his DB without any problem, but with the Worldserver i get:

'mysql: [ERROR] Failed to open required defaults file: /root/.../azerothcore/temp/mysql_ac.conf'

So in my files and folders -looking with ssh-connection- there is not even a folder like 'temp' anywhere in 'azerothcore' ...

This fail is coming up while first starting the worldserver - so there is nothing be written in the DBs... But what file does it want, if there's not even a folder --- and of course, how to fix?

Tried to find this folder or this file to put it in manualy -but no success, install all new -- same issue

what does the titel mean?

System is Linux 22.04 Server DBs are there and open to be written! - Authserver writes his DB without any problem, but with the Worldserver i get:

'mysql: [ERROR] Failed to open required defaults file: /root/.../azerothcore/temp/mysql_ac.conf'

So in my files and folders -looking with ssh-connection- there is not even a folder like 'temp' anywhere in 'azerothcore' ...

This fail is coming up while first starting the worldserver - so there is nothing be written in the DBs... But what file does it want, if there's not even a folder --- and of course, how to fix?

Tried to find this folder or this file to put it in manualy -but no success, install all new -- same issue

• mysql
• azerothcore

Share Improve this question Follow asked Feb 4 at 18:05 CorelithCorelith 122 bronze badges 5

• Some other configuration file there is a reference to include this missing configuration file. – danblack Commented Feb 4 at 22:05
• Of course... it's searching for a file which isn' there... But i mean, should it be there, what does it do and why isn't it there, if it should - and perhaps where do i get it to put it there? – Corelith Commented Feb 5 at 6:09
• strace -fe trace=openat mysql will list the files opened. Look at the one(s) that where opened before teh failred open of mysql_ac.conf. I can't really answer the "should" questions as someone decided to make it there. I'd recommend removing the "include" to this location, and if that fails, look in other directories for mysql_ac.conf that might be for the same purpose (whatever that was). – danblack Commented Feb 6 at 1:48
• hey, ok.. so.... strace -fe trace=openat mysql shows me: openat(AT_FDCWD, "/etc/passwd", O_RDONLY|O_CLOEXEC) = 4 ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: NO) ... i think that's meaning anything about the passwort? -- the Grands for my user are working - i looked in mysql as root for this... but i don't understand why there's 'using password: NO' - of course it can't be open without password^^ --- the file mysql_ac.conf doesn't exist anywehre - and just in my Backups (that have been in funktion some time ago) there's no file like this... – Corelith Commented Feb 8 at 15:38
• ooooooookay - just funny thing... after -i think- 6times deleting and reinstalling (ever the same progress) now it's working without this failur... i don't understand why, or how - but the problem seems to be solved now... perhaps becouse i 'updated && upgraded' the server befor the last time - but i don't know.... – Corelith Commented Feb 8 at 20:23

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

I think the answer is actually in your initial posting.
"there is not even a folder like 'temp' anywhere in 'azerothcore' ..."

In worldserver.conf, there is a line whos default is "".
TempDir = ""
I suspect you actually had it set.

I did. I was doing a full reinstall and got this error. I found that line in worldserver.conf, added the directory, and off it went.

本文标签： Azerothcoreworldserver mysql ERROR Failed to open required defaultsStack Overflow