Knindza Posted June 1, 2017 Report Share Posted June 1, 2017 Greetings, After few years of using Trinity on my home PC, i decided to get dedicated machine based on Linux. (Suggested version of Debian) I'm total newbie on Linux, and i keep failing to download client and to setup mysql. Used official TrinityCore setup guide. apt-get install git cmake make gcc g++ libmysqlclient-dev libssl-dev libbz2-dev libreadline-dev libncurses-dev libboost-all-dev mysql-server p7zip sudo adduser knindza sudo su - knindza cd ~/ git clone -b 3.3.5 git://github.com/TrinityCore/TrinityCore.git cd TrinityCore mkdir build cd build cmake ../ -DCMAKE_INSTALL_PREFIX=/home/knindza/server make make install cd ~/TrinityCore/ git pull origin 3.3.5 0 errors everything is ok so far - Trying to setup MySql databases with following (Changed info in config files to match user root and my password - instead of trinity/trinity mysql -u root -p mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'my_password'; mysql> FLUSH PRIVILEGES; cd mysql -u root -p mysql> CREATE DATABASE IF NOT EXISTS auth; mysql> CREATE DATABASE IF NOT EXISTS characters; mysql> CREATE DATABASE IF NOT EXISTS world; cd ~/TrinityCore/sql/base mysql -u root -p auth < auth_database.sql mysql -u root -p characters < characters_database.sql Now, since it's my first time to use Linux, i have no idea how to download client for maps and etc. Also, when i try to connect to server via HeidiSql - Server not found. Do i need to grant privileges on user i created while compiling which will require to change info into configs as well? Any help about what commands to use for download and link if possible would help a lot. Regards, Knindza. Link to comment Share on other sites More sharing options...
skipperheartbeat Posted June 1, 2017 Report Share Posted June 1, 2017 You need to re-read the wiki and follow step by step. If you want to build maps, vmaps etc. then you need to build with -DTOOLS=1. You don't need to git pull again as you've already cloned the latest repo. You've skipped to keeping the the build up to date. You need to put the database SQL into the server folder where the worldserver binary is, and start the server .. It will auto populate the database. Don't know what you are doing with Heidi,are you running that via wine on the Linux PC or from a different machine? Assuming its a different machine since you've granted privileges to *.* If you are connecting from a different machine, you need to change the bind address in my.cnf to 0.0.0.0 instead of the local host address. You'll need to restart mysql after that. Link to comment Share on other sites More sharing options...
Knindza Posted June 2, 2017 Author Report Share Posted June 2, 2017 Hey, It's not problem to move dbc, maps and or etc - I have no idea how to download client with wget from torrent (error magnet link not found) cause i'm unable to find any other. Creating DB and importing SQL is not prob, i found info for that - When i try to connect from my home pc to Linux one (Remote) there's error "Server not found on IP" Will check my.cnf today once i come home from job. PS. Can i use dbc, maps, mmaps and vmaps which i have already? I think someone told me they are different cause i 'made' them on Windows and on Linux they might fail? Regards, Knindza. Link to comment Share on other sites More sharing options...
codeman3518 Posted June 2, 2017 Report Share Posted June 2, 2017 You can use the same files from windows to Linux as long as you are using the same branch like 3.3.5 because I run a server on my Linux server and windows server all the time with the same files that I extract from one to another. 1 Link to comment Share on other sites More sharing options...
Knindza Posted June 2, 2017 Author Report Share Posted June 2, 2017 That's good to know. Gonna upload dbc and all maps via WinScp. Still, problem remain with MySql - I have no idea what to do. Checked if there are dbs, auth, world and characters -Everything is ok. Changed bind IP to 0.0.0.0 but still not able to connect via Heidi. Link to comment Share on other sites More sharing options...
Aokromes Posted June 2, 2017 Report Share Posted June 2, 2017 It's a really bad idea to give remote access to mysql. Link to comment Share on other sites More sharing options...
Knindza Posted June 2, 2017 Author Report Share Posted June 2, 2017 It's my first time to have server on 'dedicated' machine. Since it's bad idea, best option is to upload my 'custom' sql files to machine and run them directly via Putty? Link to comment Share on other sites More sharing options...
Recommended Posts