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