DDraceNetwork

Development / developer

Development discussion. Logged to https://ddnet.tw/irclogs/ Connected with DDNet's IRC channel, Matrix room and GitHub repositories — IRC: #ddnet on Quakenet | Matrix: #ddnet-developer:matrix.org GitHub: https://github.com/ddnet

Between 2018-08-03 00:00:00Z and 2018-08-04 00:00:00Z

[ddnet/ddnet] Pull request opened: #1243 Fix crash when deleting layer

evidently someone found a crash in the multi-layer thingie

[ddnet:master] 2 new commits

a7a8db4 fix crash when deleting layer - Aerll 006aac8 Merge #1243 - bors[bot]

13:00

[ddnet/ddnet] Pull request closed: #1243 Fix crash when deleting layer

Hello, guys. Im trying to set up DDnet server on ubuntu to play with my friends. sv_register 1. Port forwarding is enabled in router 8303 with internal ip 192.168 etc But when I ran my DDnet-server via termianl it shows only in LAN tab. I cant find it in Browser.

13:09

Can you tell me what problem is ?

13:11

btw, ni firewall/nat problems detected

13:11

server registered.

13:13

but my ip shows like [ge24:0;0;0;0;acfa04;4343]:8303 maybe that is the problem ?

nah it should print [0:0:0:0:0:0:0:1]:8303

13:24

which is simply the lo IP

13:24

cuz you're connected on your own server in your PC directly

13:24

this is normal

13:26

normally tw doesn't support ipv6 (if I don't say any shit), so you shouldn't see something like that, you can see it only if you do the command "status" while your inside your server

13:26

@Profile just ask a friend to search your server, they should see it

Did you forward UDP?

13:45

Check your external ip address and try accessing it through that

13:46

@Profile ^

adjustment with UPD

and when you run the server it should tell you something about whether it's reachable from outside or not

13:49

but maybe master servers are under attack again, who knows

13:49

in that case, just give your friends your external ip address

ye I know that way by giving them my IP, also master servers are well I checked it

13:51

@deen "and when you run the server it should tell you something about whether it's reachable from outside or not" where should it tell me and how ?

on the terminal

13:52

"no firewall problems detected" or sth

there is no that problems

13:53

can you check it in Browser "MISASERVER"

13:53

?

13:53

map just2easy

Nope, maybe someone else can help you

When I tried to run server from Windows it was okay, but with linux I got that weird thing that it dispalys in LAN tab

Maybe you#re running some firewall on linux?

13:56

that's blocking external ips

idk, but no firewall/nat problems detected (in termianl)

13:57

server registered thats what terminal tells

13:58

also I just asked my friend tofind my server in Browser, he doesnt see it.

how much servers can he see in the browser list

I fixed that

14:06

if someone will face problem -

14:07

You need to check your local ip carefully. Because my lan IP was different on the second PC and port forwarding should be for different local ip

if you had the "no fw/nat problem detected" that means you forwarded to the correct lan IP

teeworlds master servers are getting ddosed right now and arent showing the full list of servers

yep

ye

17:52

which commands connects mysql to server ?

17:52

I mean autoexe.cfg

add_sqlserver s['r'|'w'] s[Database] s[Prefix] s[User] s[Password] s[IP] i[Port] ?i[SetUpDatabase ?]

can you give me an example of working command line ?

add_sqlserver r teeworlds record root "password" "localhost" "3306"
add_sqlserver w teeworlds record root "password" "localhost" "3306"

193.70.81.201:8302 it running as DDNet GER instead of FRA (edited)

@ZombieToad is dis for linux or windows ?

@Profile its for ddnet servers

Who knows how to fix that error ? - message(SEND_ERROR "You must install MySQL to compile the DDNet server with MySQL support")

Install MySQL maybe

thats the problem cuz MySql is installed

19:36

Image attachment

Did u run the server

yes

19:38

I was talking to ZombieToad about the problem, so We have no idea whats wrong

So u can access to sql console and connect to it

can I have a way of How to ?

U should have an exec

Is the MySQL connector installed?

In your file

mysql connector net ?

No

19:45

Try sql in cmd

ql' is not recognized as an internal or external command, operable program or batch file.

19:45

sql' is not recognized as an internal or external command, operable program or batch file.

19:45

I typed in CMD

So u didn't added sql to Path during install

At least for linux, you need MySQL (or MariaDB), MySQL Connector/C++ (connector-cpp), and boost (from boost.org).

MySQL shell

19:48

It the exe u have to run

https://monosnap.com/file/RclwX6gPIRnu9oD6MlH58j4WUbSz3M

Screenshot "Edit environment variable 2018-08-03 22.48.41.png"

19:49

https://monosnap.com/file/MFGYsa2K7ppuEwWHGXt2QTgV7SgeiG

Screenshot "Select MySQL Shell 2018-08-03 22.49.28.png"

Oh ok

so I did smth wrong with installation ?

19:50

and what should I add to path ? (which exactly line) ?

'mysql -h' ?

Image attachment

Look fine for the installation

yeah.. I passed the wrong command-line, but it replied an error indicating the mysql binary was found.

@Amu~Cookie Im not sure what should I look fine there

19:53

can I have clues ?

I'm not sure I know some common mistake like

19:57

Port 80 is free?

how can I check it ?

Port 80 ? If MySQL is in the same computer as DDNet, port shouldn't be a problem. And MySQL port should be 3306.

19:59

We definitively should have a "Build DDNet +MySQL on Windows" instructions.

yeah 100%

20:00

but whats wrong with my sql ?

When building DDNet with "-DMYSQL=ON", DDNet checks if the following are available: 1) MySQL, 2) Mysql Connector C++ (which depends on Boost lib, at least on linux)

20:03

So I suggestion checking the logs for something more obvious, like "mysql connector c++" not found

where should I get that specific logs ? my visual studio gave me line 362

20:04

362

20:04

You must install MySQL to compile the DDNet server with MySQL support

line 362 from which file, or 362 lines?

https://monosnap.com/file/qvFEWp3JlznCZQGN8g0qyWkO30Hcs0

Screenshot "LastAttempt - Microsoft Visual Studio 2018-08-03 23.06...

@heinrich5991 Is it feasible to set 'cmake/FindMySQL.cmake' or 'CMakeLists.txt' to separate the missing MySQL warning from the MySQL Connector C++ warning, so it makes clearer where is the cause of no-go ?

20:10

@Profile that line is the one that print this message - didn't help

I guess so

20:11

I was trying to solve that problem at least 1 week

20:11

cmake shows weird things to me

like?

like line 362

20:11

because I did install mysql

20:11

and turned on preferrences in cmakelists

20:12

option(MYSQL "Enable mysql support" ON)

20:12

then i tried to compile it

20:12

and got that error

CMakeLists.txt is the main build file, which calls 'FindMySQL.cmake' to run some checks. If MySQL or MySQL Connector C++ is missing, the same error is returned. That's why is not easy to know whether you installed MySQL correctly or not, or the connector is missing

20:14

Anyway, install the connector. Try looking for instructions in https://dev.mysql.com/doc/connector-cpp/8.0/en/ or searching the web.

20:15

"MySQL Installer. The simplest and recommended method for installing Connector/C++ on Windows platforms is to download MySQL Installer and let it install and configure all the MySQL products on your system" -

20:16

https://dev.mysql.com/doc/refman/8.0/en/mysql-installer.html Maybe you need to click on a checkbox to enable connector c++ during the install of MySQL.

well I downloaded the connector

20:17

where should I place it ?

Its

20:18

MySQL connector I guess from your screenshot

Image attachment

20:19

https://monosnap.com/file/3yKeq0KUIVcHpo8lWN7clUFSD4Hvj2

Screenshot "MySQL Installer 2018-08-03 23.19.27.png"

20:19

so I guess its installed

It seems so.

it feels like we are gonna to set up spaceship fly

Please open the prompt command and run 'mysql_config' and let us know the output

https://monosnap.com/file/q1WoWMJbJ7817Uqh8Wc0ZDCMTbFUdv

Screenshot "Administrator_ C__Windows_System32_cmd.exe 2018-08-03 ...

It seems MySQL indeed is not in the path, as Amu~Cookie guessed.

what should I add there ?

Please try to running mysql_config from its path. Go inside the install folder if you need. Should be something like "C:\Program Files\MySQL\MySQL Server 8.2\bin\mysql_config"

20:26

You can replace c:\Program Files with %ProgramFiles%

https://monosnap.com/file/9OfPuZocPpA9nf6oBSunsd8WGeEIIJ

Screenshot "bin 2018-08-03 23.27.57.png"

Possibly.

by what I need to run it ?

Please try to run it from command prompt

20:30

Just to check if it runs fine

20:30

try something like 'mysql_config.pl --help'

https://monosnap.com/file/8BG5SAy6rUUkMTF5L1eZGGUGxUrMJQ

Screenshot "Administrator_ C__Windows_System32_cmd.exe 2018-08-03 ...

please use quotes around it

https://monosnap.com/file/kd1kPwO5B7lBN3ybChuiZF2IFuCWm6

Screenshot "Administrator_ C__Windows_System32_cmd.exe 2018-08-03 ...

or go 'cd' into the bin folder...

20:33

do not quote the --help flag

https://monosnap.com/file/F5jpl8blEWxRpSCDHqtRNH1QgFiM2W

Screenshot "Administrator_ C__Windows_System32_cmd.exe 2018-08-03 ...

20:34

https://monosnap.com/file/xGc0ncmmGqgf4vWbKtI0jri6Rh7d1q

Screenshot "Administrator_ C__Windows_System32_cmd.exe 2018-08-03 ...

Weird. It has different options from Linux's 'mysql_config' script

1    LNK2019    Fehler    Verweis auf nicht aufgel├Àstes externes Symbol ""public: __cdecl CFlag::CFlag(class CGameWorld *,int)" (??0CFlag@@QEAA@PEAVCGameWorld@@H@Z)" in Funktion ""public: virtual bool __cdecl CGameControllerDDRace::OnEntity(int,class vector2_base<float>)" (?OnEntity@CGameControllerDDRace@@UEAA_NHV?$vector2_base@M@@@Z)".

(edited)

20:36

defuq

you got the same problem ?

Me? No, It builds fine for me with MySQL, in Linux.

I mean fokkobot

20:38

rafaelFF i do also have it on linux

20:38

Im sitting here by 2 PC

which distro?

@Profile whats the problem?

Image attachment

20:39

@fokkonaut I cant add sql DB on windows

UBUNTU

GWqlabsFeelsGoodMan

GWqlabsFeelsGoodMan

GWqlabsFeelsGoodMan

feelsamazingman

tKonsti we are discussing serious things man

20:39

very serious

@Profile Take at the instructions for MySQL, including the package names, in https://github.com/ddnet/ddnet

ddnet - DDraceNetwork, a mod of Teeworlds

Hui raffaelff alive GWqlabsFeelsGoodMan

GWqlabsFeelsGoodMan

feelsamazingman

The main page (README.md) has some instructions.

@Rafael Fontenelle I did try to use them but some infstructions there are for arch

arch linux?

ye

@Profile this Moment when u press t to chat in discord

20:40

xF

konsti plz dont spam

2

2

banhammer

2

no, arch is in ArchWiki. In the README it mentions: MySQL (or MariaDB) support in the server is not included in the binary releases but it can be built by specifying -DMYSQL=ON, like cmake -DMYSQL=ON ... It requires libmariadbclient-dev, libmysqlcppconn-dev and libboost-dev, which are also bundled for the common platforms. Note that the bundled MySQL libraries might not work properly on your system. If you run into connection problems with the MySQL server, for example that it connects as root while you chose another user, make sure to install your system libraries for the MySQL client and C++ connector. Make sure that the CMake configuration summary says that it found MySQL libs that were not bundled (no "using bundled libs").

@Profile i dont try to add sql

"libmariadbclient-dev libmysqlcppconn-dev libboost-dev"

@Bojidar Marinov do you know what this means?

1    LNK2019    Fehler    Verweis auf nicht aufgel├Àstes externes Symbol ""public: __cdecl CFlag::CFlag(class CGameWorld *,int)" (??0CFlag@@QEAA@PEAVCGameWorld@@H@Z)" in Funktion ""public: virtual bool __cdecl CGameControllerDDRace::OnEntity(int,class vector2_base<float>)" (?OnEntity@CGameControllerDDRace@@UEAA_NHV?$vector2_base@M@@@Z)".

i cant manage my mariaDB on linux there is nothing happens

i can only see 80 servers on the internet tab, but 190 servers on ddnet tab and i cant join a hidden server by typing the IP

I guess that master servers are under DDOS

(edited)

ye they are

@Profile Oh, so you did successfully build DDNet with MySQL support in Ubuntu?

@Rafael Fontenelle I did succesfuly complied it in Ubuntu

20:44

but

20:45

I cant Add DB of DDnet to my server cuz I dont udnerstand the commands properly

20:45

for example I face first problem with that line yaourt -S mariadb mysql-connector-c++

20:45

faced* (edited)

20:46

and then with that line - ariaDB [(none)]> create database teeworlds; create user 'teeworlds'@'localhost' identified by 'PW2'; grant all privileges on teeworlds.* to 'teeworlds'@'localhost'; flush privileges;

this takes a while, you can remove the KEYs in record_race.sql to trade performance in queries

$ mysql -u teeworlds -p'PW2' teeworlds < ddnet-sql/record_*.s

20:46

when I tried to type them nothing happened

20:46

just new whole line

oh, that's awkward: "yaourt -S" should NOT be listed for general distro instructions, as it is arch-specific. That's a bug.

that mixed up the things

Is mariadb daemon up?

idk

20:48

a command to check it ?

On this subject, I suggest doing some reading on https://mariadb.com/kb/en/library/starting-and-stopping-mariadb-automatically/

Starting and Stopping MariaDB Automatically

Starting MariaDB automatically, keeping it running, shutting down gracefully

20:49

Please try 'mysql.server start'

oh command not found

maybe 'systemctl start mariadb' ?

asked for PW after its typing nothing happened

20:52

Image attachment

systemctl status mariadb - this should tell if it is up or not

Image attachment

awesome, mysql should be responsive now.

20:54

Got to go. Try the instructions again and some googling around, in case of errors..

20:54

cya

thanks cya

@fokkonaut looks like a linker failiure, try to rebuild the whole thing or something

21:00

I don't understand the language the error message is in tho

got it somehow

21:02

really weird

linkers are weird :]

[ddnet:master] 1 new commit

0518769 fix cl_show_nameplates_own with antiping off ingame - def-

Exported 209 message(s)