Several Problems while creating a DDNet based server

Request help for teeworlds-related subjects (mapping, servers, ..).
For client issues, see our repositories (https://github.com/ddnet/ddnet/issues).
Post Reply
FlushA
Posts: 57
Joined: Mon Jul 13, 2015 1:43 pm
Location: IR
Player profile: http://ddnet.tw/players/Sv3N/
Mapper profile: http://ddnet.tw/mappers/FlushA/
Clan: I.R.T

Several Problems while creating a DDNet based server

Post 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.
✟Տ℣ʒN✟
User avatar
Ryozuki
Posts: 1748
Joined: Tue Feb 24, 2015 7:28 am
Location: Catalonia
Player profile: http://ddnet.tw/players/Ryozuki/
Mapper profile: http://ddnet.tw/mappers/Ryozuki/
Clan: Unique
Website: https://edgarluque.com
Discord: Ryozuki#2188

Re: sql file for DDNet

Post 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 (?)
User avatar
deen
TECHNICAL Team
Posts: 3576
Joined: Mon May 05, 2014 2:30 pm
Player profile: https://ddnet.org/players/deen/
Discord: deen#5910

Re: sql file for DDNet

Post 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.tw/settingscommands/
FlushA
Posts: 57
Joined: Mon Jul 13, 2015 1:43 pm
Location: IR
Player profile: http://ddnet.tw/players/Sv3N/
Mapper profile: http://ddnet.tw/mappers/FlushA/
Clan: I.R.T

Re: sql file for DDNet

Post by FlushA »

So what you mean is that DDNet does not need import a .sql file to a mysql database?
✟Տ℣ʒN✟
User avatar
deen
TECHNICAL Team
Posts: 3576
Joined: Mon May 05, 2014 2:30 pm
Player profile: https://ddnet.org/players/deen/
Discord: deen#5910

Re: sql file for DDNet

Post by deen »

right, DDNet SQL server can create its own database and table. I assumed you want to import the official DDNet database.
FlushA
Posts: 57
Joined: Mon Jul 13, 2015 1:43 pm
Location: IR
Player profile: http://ddnet.tw/players/Sv3N/
Mapper profile: http://ddnet.tw/mappers/FlushA/
Clan: I.R.T

Re: sql file for DDNet

Post by FlushA »

Cool and wonderful
✟Տ℣ʒN✟
Chairn
Posts: 400
Joined: Sat Apr 11, 2015 5:05 pm
Player profile: http://ddnet.tw/players/Chairn/
Clan: QuintessenZ

Re: sql file for DDNet

Post by Chairn »

Is there any reason for not including MySQL server in the binary releases?
User avatar
deen
TECHNICAL Team
Posts: 3576
Joined: Mon May 05, 2014 2:30 pm
Player profile: https://ddnet.org/players/deen/
Discord: deen#5910

Re: sql file for DDNet

Post 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.
FlushA
Posts: 57
Joined: Mon Jul 13, 2015 1:43 pm
Location: IR
Player profile: http://ddnet.tw/players/Sv3N/
Mapper profile: http://ddnet.tw/mappers/FlushA/
Clan: I.R.T

Re: sql file for DDNet

Post 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?
✟Տ℣ʒN✟
User avatar
deen
TECHNICAL Team
Posts: 3576
Joined: Mon May 05, 2014 2:30 pm
Player profile: https://ddnet.org/players/deen/
Discord: deen#5910

Re: sql file for DDNet

Post by deen »

apt-get install libboost-dev
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests