zombienerd
-
Posts
2 -
Joined
-
Last visited
Posts posted by zombienerd
-
-
I have followed all the guides closely. I created a new SQL user with root-level permissions and seemed to get Trinity to talk to SQL.
However, when I try to start worldserver for the first time, so it can install the databases, I get the following:
Using configuration file /home/server/server/etc/worldserver.conf.
Using SSL version: OpenSSL 1.0.1f 6 Jan 2014 (library: OpenSSL 1.0.1f 6 Jan 2014)
Using Boost version: 1.55.0
Could not connect to MySQL database at 192.168.1.101: Unknown database 'auth'
Database "auth" does not exist, do you want to create it? [yes (default) / no]:
yes
Creating database "auth"...
Applying of file 'create_table.sql' to database 'auth' failed! If you are an user pull the latest revision from the repository. If you are a developer fix your sql query.
Failed to create database auth! Has the user `CREATE` priviliges?DatabasePool Login NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors.
I am not seeing any errors in my MySQL error.log Any ideas? I extracted the latest TDB (TDB_full_world_335.59_2015_07_14.sql) from the ZIP and placed it in the /bin folder. Am I missing something? Did I skip a step? Any help is appreciated!
"unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page
in Help and Support
Posted
I found two issues. 1st, I created the 3 databases manually through the mysql CLI. Then, I tried starting worldserver again, it threw an error stating it didn't have the location of the mysql CLI in the worldserver.conf Once I remedied that, it seemed to go through and populate the databases as expected.