Page 1 of 7

Several Problems while creating a DDNet based server

Posted: Sat Sep 19, 2015 2:03 pm
by FlushA
Hello,
I have a problem with sql_score for use from points in ddnet.
I don't know anything about sql and how to make a sql file.
please help me to enable sql in my DDNet server.

Re: sql file for DDNet

Posted: Sat Sep 19, 2015 7:17 pm
by Ryozuki
https://en.wikipedia.org/wiki/SQL

maybe this program helps too: http://sqlitebrowser.org/

i rly don't know but maybe this helps (?)

Re: sql file for DDNet

Posted: Sat Sep 19, 2015 7:58 pm
by deen
You need MySQL, first learn how that works.
Then you can use mysql database < sql_score to load the scores into your DB.

Building instructions here: https://github.com/ddnet/ddnet#building
SQL settings here (search for sql): http://ddnet.org/settingscommands/

Re: sql file for DDNet

Posted: Sat Sep 19, 2015 8:45 pm
by FlushA
So what you mean is that DDNet does not need import a .sql file to a mysql database?

Re: sql file for DDNet

Posted: Sat Sep 19, 2015 8:46 pm
by deen
right, DDNet SQL server can create its own database and table. I assumed you want to import the official DDNet database.

Re: sql file for DDNet

Posted: Sat Sep 19, 2015 8:55 pm
by FlushA
Cool and wonderful

Re: sql file for DDNet

Posted: Mon Sep 21, 2015 10:25 pm
by Chairn
Is there any reason for not including MySQL server in the binary releases?

Re: sql file for DDNet

Posted: Mon Sep 21, 2015 10:40 pm
by deen
Chairn wrote:Is there any reason for not including MySQL server in the binary releases?
Most don't need it and it's ~30 MB that you would have to download with every update. If you can't compile the SQL server, you'll have even bigger trouble using it.

Re: sql file for DDNet

Posted: Tue Sep 22, 2015 11:01 am
by FlushA
Hello again,
I am get some error in bam server_sql_release
errors
other/mysql/include\cppconn/connection.h(31) : fatal error C1083: Cannot open in
clude file: 'boost/variant.hpp': No such file or directory
bam: 'objs/game/server/gamecontext_sql.obj' error 2
and 31 line is #include <boost/variant.hpp>
how fix this error?

Re: sql file for DDNet

Posted: Tue Sep 22, 2015 11:48 am
by deen
apt-get install libboost-dev