Mangos One Mysql Help!!

[swifteye]

Ok I have all the files from github i need to make the server and have compiled the server. Then putting the data base into mysql is where I'm stuck, the readme in the database file says to

"In order to use this database repository, you will have to edit `mysql_info`,and edit in the desired username, hostname, and password."

I open the file and edit the details and when i use sqlyog to input the script it says

"Query: #!/bin/bash # # This file contains login/password information for accessing the MySQL database # and is used by all the mysql_* ...

Error Code: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USER=root

PASS=mangos

HOST=localhost

#SOCK=/var/lib/mysql/mysql.sock

OPTS=' at line 8"

Their is only the user "root" on the server, i suspect that I'm missing a step or that im meant to use a different program.

i have a Mangos 11811 Server running on another mechine on the network

I am also using a 32bit Windows 7

[Skirnir]

The reason why your stuck is, mysql_info and all the other mysql_* files are GNU/Linux bash files. If you look at the first line of each file it contains: "#!/bin/bash". This tells your *nix system to run this file with /bin/bash. As windows user you have to check if you somehow can run bash files or have to import each file hand by hand (alternative: write yourself a batch file to import all sql files).

Regards

Skirnir

[Edit] At github you'll find a link to X-Saviors Full Database [1]. Maybe you are lucky and it's only one file

[1] http://tbc-db.svn.sourceforge.net/viewvc/tbc-db/1.1.0/Full_DB/

[swifteye]

First, you are a lifesaver

and yes i was lucky it was one file that did everything for me, didn't even think that mangos-one files were Linux.

also i had to do this on my older 32bit pc but was wondering if their is a 64bit compile somewhere for mangos-one?

Thanks again for any help.

*Edit* i should mention i have tried to compile into 64bit but come up with the following error

11>LINK : fatal error LNK1181: cannot open input file 'ws2_32.lib'

========== Build: 5 succeeded, 6 failed, 0 up-to-date, 0 skipped ==========

I've recloned and cleaned the build a few times but still get that error. I am running \\server\\win mangosdVC100 and release is selected with x64

[Skirnir]

You have to compile it on your Windows 64-Bit machine, with all the required 64-Bit libs. There was a trick how you can avoid buying VS Pro to get the required files, but I can not remember it (never used it since I use GNU/Linux). Forum search surely will help.

Regards

Skirnir

[swifteye]

I'm getting 5 errors they are:

Error 77 error C1083: Cannot open include file: 'revision.h': No such file or directory C:\\Source\\server\\src\\realmd\\Main.cpp 31 1 realmd

Error 79 error C1083: Cannot open include file: 'revision.h': No such file or directory C:\\Source\\server\\src\\shared\\WheatyExceptionReport.cpp 17 1 realmd

Error 80 error C1083: Cannot open include file: 'revision.h': No such file or directory C:\\Source\\server\\src\\game\\Level0.cpp 30 1 game

Error 87 error C1083: Cannot open include file: 'revision.h': No such file or directory C:\\Source\\server\\src\\mangosd\\Main.cpp 31 1 mangosd

Error 90 error C1083: Cannot open include file: 'revision.h': No such file or directory C:\\Source\\server\\src\\shared\\WheatyExceptionReport.cpp 17 1 mangosd

I'm using VS Pro that i received from Uni, compiling in 64bit on a 64bit machine all errors refer to 'revision.h' and i can not locate the file myself

[Skirnir]

revision.h is created during compilation by this file [1]. Other than that I can't help. I don't have a Windows machine with Visual Studio.

Regards

Skirnir

[1] https://github.com/mangos/mangos/blob/master/src/tools/genrevision/genrevision.cpp