+- Community Support for OpenDocMan (Deprecated) (https://forum.opendocman.com)
+-- Forum: OpenDocMan Community Discussion (https://forum.opendocman.com/forum-5.html)
+--- Forum: OpenDocMan Support - Community Based (https://forum.opendocman.com/forum-6.html)
+--- Thread: SOLVED MySQL Error 1067 (/thread-302.html)
SOLVED MySQL Error 1067 - danswan - 08-09-2010
Hi
I did post a question a couple of days ago which I guess still hasn't been approved. This query is similar, but not the same.
After having issues getting the latest opendocman to work with MySQL 5.1.49 on a windows XP SP3 machine, I tried MySQL 4.1.22 instead. This enabled me to get opendocman up and running and I had a bit of a play with it. It seems excellent and I want to deploy it at my workplace. Unfortunately I experienced an issue, one which I can recreate on another Windows XP machine:
Once Opendocman is installed, if I stop the MySQL service, I get a MySQL error 1067 when I start it again. This happens regular as clockwork on the two machines I have used for testing so far, so I guess it's something I'm doing wrong.
To recreate it I just install MySQL > Service can be started & stopped no problems
Run the Opendocman installer, stop the MySQL service, on restart I get error 1067.
On checking the MySQL Error file I see the line: 'Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist'.
I appreciate this is a MySQL error, but it only happens after installing opendocman. Any ideas?
SOLVED Re: MySQL Error 1067 - danswan - 08-09-2010
OK I think I get it..
I was just using the default MySQL database for opendocman, when opendocman installs it seems to wipe the tables within. So when the service starts, it checks the default MySQL DB, can't find the table and errors out.
Anyway this is now working, so please disregard. I could use some help on my other thread though!