DDraceNetwork - developer

I can't play on Ger, i have a rly hard slideshow becouse of antiping, players are just teleporting

08:52

ping 120

08:52

why it's happening? (edited)

08:54

played with Xola, he has same ping, but no problems for him

08:54

only on my side

sounds like packet loss

[quakenet] <Davide> Hello guys

19:26

[quakenet] <Davide> I can have help for one thing?

19:27

[quakenet] <Learath2> Davide: not if you don't ask

19:28

[quakenet] <Davide> True c.c

19:28

[quakenet] <Davide> Ok go in pvt pls

[quakenet] <Davide> root@vps2025:~/ddnet/build# cmake .. -- The C compiler identification is GNU 4.8.4 -- The CXX compiler identification is unknown -- Check for working C compiler: /usr/bin/cc -- Check for working C compiler: /usr/bin/cc -- works -- Detecting C compiler ABI info -- Detecting C compiler ABI info - done CMake Error: your CXX compiler: "CMAKE_CXX_COMPILER-NOTFOUND" was not found. P

19:53

[quakenet] <Davide> -- To run the tests, you have to install GTest -- Looking for WavpackOpenFileInputEx -- Looking for WavpackOpenFileInputEx - found CMake Warning at CMakeLists.txt:1303 (message): Cannot create CPack targets, CMake version too old. Use CMake 3.6 or newer. -- Configuring incomplete, errors occurred! See also "/root/ddnet/build/CMakeFiles/CMakeOutput.log". See also "/root/ddnet/build/CMakeFiles/CMakeError.log".

19:53

[quakenet] <Davide> Ok, i have this errors

19:53

[quakenet] <heinrich5991> mh

19:53

[quakenet] <heinrich5991> sounds like you're missing a c++ compiler

19:54

[quakenet] <Davide> Strange

19:54

[quakenet] <heinrich5991> have you installed build-essential or build-essentials?

19:54

[quakenet] <Davide> I check

19:54

[quakenet] <heinrich5991> type g++ --version into the terminal

19:54

[quakenet] <Davide> Oh, installed

19:54

[quakenet] <Davide> I try now

19:55

[quakenet] <Davide> Ok build done now

19:55

[quakenet] <Davide> Ok another thing

19:55

[quakenet] <Davide> I need to build it with Mysql enabled

19:55

[quakenet] <Davide> How i can do?

19:56

[quakenet] <heinrich5991> the general instructions are located at the bottom of https://github.com/ddnet/ddnet

ddnet/ddnet

ddnet - DDraceNetwork, a mod of Teeworlds

19:57

[quakenet] <Davide> Ok thanks

20:02

[quakenet] <Davide> Ok done, compiled with database

20:02

[quakenet] <Davide> But.. Where i need to put mysql details?

20:04

[quakenet] <Davide> mine.cfg?

mysql.cfg

20:06

sv_sql_servername "GER" sv_player_demo_record 0 add_sqlserver r teeworlds record root "password" "localhost" "3306" add_sqlserver w teeworlds record root "password" "localhost" "3306"

[quakenet] <Davide> Ok thx

20:09

[quakenet] <Davide> teeworlds is name of table?

20:11

[quakenet] <heinrich5991> it's the name of the database

20:11

[quakenet] <heinrich5991> record is the prefix of the table names

20:12

[quakenet] <Davide> Ok

how does one sell a phone?

[quakenet] <Davide> Ebay

20:29

[quakenet] <Davide> Lol

20:29

[quakenet] <Davide> root@vps2025:~/ddnet/build/ddnet-sql# mysql -u root -p'x' teeworlds < record_race.sql ERROR 1070 (42000) at line 25: Too many key parts specified; max 16 parts allowed

20:29

[quakenet] <Davide> I'm testing with ddnet db

hmm, never sold anything on ebay, might check it out

[quakenet] <Davide> But i have some errors

20:30

[quakenet] <Davide> I think is too many large the db file

20:30

[quakenet] <Davide> Right?

20:30

[quakenet] <deen> Davide: Why are you trying to import the ddnet db btw?

20:31

[quakenet] <Davide> For test the server

20:31

[quakenet] <Davide> I'm fellowing the guide

20:31

[quakenet] <Davide> https://github.com/ddnet/ddnet

ddnet/ddnet

ddnet - DDraceNetwork, a mod of Teeworlds

20:32

[quakenet] <deen> Hm, probably because you're using MySQL and we use MariaDB

20:32

[quakenet] <Davide> Yes

20:32

[quakenet] <Davide> D;

20:32

[quakenet] <Davide> Ok

20:32

[quakenet] <deen> Didn't know they have this limitation

20:34

[quakenet] <Davide> Yes now i try with mariadb

20:35

[quakenet] <heinrich5991> it's a bit weird that we don't have a primary key in our db ^^

20:35

[quakenet] <deen> oh, we do apparently

20:35

[quakenet] <deen> that's weird

20:35

[quakenet] <heinrich5991> huh?

20:35

[quakenet] <deen> PRIMARY KEY (Map,Name,Timestamp,Time,Server,cp1,cp2,cp3,cp4,cp5,cp6,cp7,cp8,cp9,cp10,cp11,cp12,cp13,cp14,cp15,cp16,cp17,cp18,cp19,cp20,cp21,cp22,cp23,cp24,cp25),

20:35

[quakenet] <deen> that's in our db export

20:35

[quakenet] <heinrich5991> yes

20:36

[quakenet] <heinrich5991> no explicit key = everything is key

20:36

[quakenet] <deen> maybe because we added GameID

20:36

[quakenet] <deen> GameID is missing, not everything

20:36

[quakenet] <heinrich5991> oh

20:37

[quakenet] <deen> smells like a mistake, right?

20:37

[quakenet] <heinrich5991> yes, but nothing bad

20:37

[quakenet] <deen> and I'm also not 100% happy that our keys from ddnet.tw are exported anyway

20:37

[quakenet] <deen> they are only used on ddnet.tw for website stuff, not needed generally

20:38

[quakenet] <heinrich5991> keys?

20:38

[quakenet] <deen> indices

20:38

[quakenet] <heinrich5991> ok. I think I'm too unfamiliar with DBs

20:39

[quakenet] <deen> anyway, Davide: you can try deleting line 57 in record_race.sql

20:39

[quakenet] <deen> heinrich5991: want to look for a fix for the primary key or should Iß

20:39

[quakenet] <deen> ?

20:39

[quakenet] <heinrich5991> I don't understand the problem yet tbh

20:39

[quakenet] <Davide> I've already done with mariadb

20:40

[quakenet] <deen> Davide: works with mariadb?

20:40

[quakenet] <Davide> Yes

20:40

[quakenet] <deen> ah, great

20:40

[quakenet] <deen> then I'll just "alter table record_race drop primary key;"

20:41

[quakenet] <Davide> Good xD

20:41

[quakenet] <heinrich5991> ok? ^^

20:41

[quakenet] <Davide> Notepad++ have problems with record_race.sql too many length HAHAHAHA

20:43

[quakenet] <heinrich5991> Davide: you'd need an editor specializing in huge files

20:43

[quakenet] <deen> or enough ram

20:43

[quakenet] <Davide> I know heinrich

20:43

[quakenet] <Davide> No Deen

20:43

[quakenet] <Davide> xD

20:43

[quakenet] <Davide> More ram don't help in this case

20:43

[quakenet] <deen> that's my main problem with vim and large files, filling up memory

20:44

[quakenet] <Davide> I hate vim

20:44

[quakenet] <deen> ah, and particulary long lines

20:44

[quakenet] <deen> like this file having one huge line I guess

20:44

[quakenet] <Davide> I prefer nano or ee

sublime is pretty good in loading insane files, they do some lazy loading iirc

[quakenet] <Davide> Where i can downlaod the structure of db?=

20:53

[quakenet] <Davide> Db?

20:53

[quakenet] <Davide> Without data

20:53

[quakenet] <heinrich5991> the ddnet server can initialize the db itself IIRC

20:53

[quakenet] <deen> yeah, if you don't need the data, don't need to download anything

20:54

[quakenet] <deen> just set up the mysql connection data and set sv_use_sql 1

20:58

[quakenet] <Davide> Guys?

20:58

[quakenet] <deen> yes?

20:58

[quakenet] <Davide> Oh

20:58

[quakenet] <Davide> Sorry lol

20:58

[quakenet] <Davide> Some connection problems

20:58

[quakenet] <Davide> I read now

20:58

[quakenet] <Davide> Thanks Deen

21:00

[quakenet] <deen> someone should add some notes about how to set up your own server with mysql and separately how to import our db and why you probably don't want to do that

but need import database to make good fake server

[quakenet] <Davide> [2018-04-24 22:02:38][sql]: sql connection established [2018-04-24 22:02:38][sql]: MySQL Error: Table 'teeworlds.record_race' doesn't exist [2018-04-24 22:02:38][sql]: ERROR: Tables were NOT created [2018-04-24 22:02:38][sql]: FATAL ERROR: Could not init SqlScore

21:03

[quakenet] <Davide> :/

21:03

[quakenet] <Davide> Table don't exist lol

21:04

[quakenet] <deen> sv_sql_create_tables 1

21:04

[quakenet] <deen> :D

21:04

[quakenet] <Davide> Ah

21:04

[quakenet] <Davide> Ok wait

21:04

[quakenet] <Davide> xD

21:04

[quakenet] <deen> hm no

21:04

[quakenet] <deen> that doesn't exist anymore

21:05

[quakenet] <Davide> Same error

21:05

[quakenet] <deen> add_sqlserver has a parameter to set up database

21:05

[quakenet] <Davide> What?

21:05

[quakenet] <deen> Console()->Register("add_sqlserver", "s['r'|'w'] s[Database] s[Prefix] s[User] s[Password] s[IP] i[Port] ?i[SetUpDatabase ?]", CFGFLAG_SERVER|CFGFLAG_NONTEEHISTORIC, ConAddSqlServer, this, "add a sqlserver");

21:05

[quakenet] <Davide> What o.o

21:05

[quakenet] <deen> and the default should be true, not false

21:06

[quakenet] <Davide> I'm not understanding

21:06

[quakenet] <deen> add_sqlserver w teeworlds record teeworlds "PW2" "localhost" "3306" 1

21:06

[quakenet] <Davide> Yes i know

21:06

[quakenet] <Davide> There already exist

21:06

[quakenet] <deen> there's a 1 at the end :D

21:07

[quakenet] <deen> that's not documented

21:07

[quakenet] <heinrich5991> deen: db seems to have problems

21:07

[quakenet] <Davide> lol

21:07

[quakenet] <heinrich5991> you did anything in the last two minutes?

21:07

[quakenet] <deen> yeah, I guess my db fix was a bit more expensive than I expected

21:07

[quakenet] <Davide> 1 added and now work

21:07

[quakenet] <Davide> Thanks Deen

21:07

[quakenet] <heinrich5991> failed_mysql.sql, here we come ;)

def-

[ddnet:master] 1 new commit

3f7b183 Set up DB by default - def-

[quakenet] <heinrich5991> thanks for EastByte's? failsafe

21:09

[quakenet] <Davide> After first run, i need to replace 1 with 0 and remove sv_sql_create_tables 1 ?

21:09

[quakenet] <heinrich5991> no need to remove it, no

21:09

[quakenet] <Davide> Ok

21:09

[quakenet] <Davide> But.. If i re-run say me this

21:09

[quakenet] <Davide> [2018-04-24 22:08:46][sql]: sql connection established [2018-04-24 22:08:46][sql]: Tables were created successfully [2018-04-24 22:08:46][sql]: sql connection established [2018-04-24 22:08:46][sql]: Tables were created successfully

21:09

[quakenet] <Davide> Recreated? What

21:09

[quakenet] <heinrich5991> it executes a

21:10

[quakenet] <heinrich5991> "CREATE TABLES … IF NOT EXISTS"

21:10

[quakenet] <Davide> Ah

21:10

[quakenet] <Davide> Ok

21:10

[quakenet] <Davide> Good

21:10

[quakenet] <deen> so after the initial creation you can set the 1 to 0

21:10

[quakenet] <deen> or leave it, doesn't matter

21:10

[quakenet] <Davide> Yes ok :)

21:10

[quakenet] <deen> Query OK, 2936730 rows affected (27 min 37.36 sec)

21:10

[quakenet] <Davide> xD

damn, we sure have a lot of rows

21:11

@deen what was the query?

[quakenet] <deen> alter table record_race drop primary key;

21:11

[quakenet] <deen> which apparently recreates the table :D

21:11

[quakenet] <heinrich5991> query seems to be done now

if we still had CAN in the loop that query would have been quite a problem

[quakenet] <deen> isn't that whywe removed it?

21:13

[quakenet] <deen> not enough disk for any fun

yeah, I think it was stuck on some query

[quakenet] <Davide> Anyway, server work good

21:16

[quakenet] <Davide> Thanks Deen

21:16

[quakenet] <Davide> Deen

21:16

[quakenet] <Davide> You know where i can download all Gores maps?

21:17

[quakenet] <deen> from KoG?

21:17

[quakenet] <Davide> On KoG site download of Maps zip is broken

21:17

[quakenet] <deen> or the ones we have on ddnet?

21:17

[quakenet] <Davide> Kog

@qshar please fix ^

[quakenet] <Davide> xD

21:17

[quakenet] <deen> or manually here: https://maps.ddnet.tw/

21:17

[quakenet] <Davide> D;

21:18

[quakenet] <Davide> But i need gores maps c.c

http://www.qshar.com/#mapss

Teeworlds ranks for QshaR's servers

QshaR's website

[quakenet] <deen> wait for qshar to fix the maps zip

http://www.qshar.com/maps.zip

21:19

404

[quakenet] <Davide> Ok deen

^^

21:19

I'll send you tomorrow

@qshar where do you host qshar.com?

21:19

it doesn't have https

nfo

[quakenet] <Davide> i don't like nfo lol

I know, I'm lazy :)

@qshar I'd help you set it up if you want

21:20

– can I also have a copy of your maps?

21:20

for the map collection

y, sure - I'll update the maps zip file on the website tomorrow

cool

[quakenet] <Davide> Good xD

and yes, I think its time to implement https certificate ;) I delayed this task for too long

Davide: nfo is the only people who will take us tw guys, no-one else wants to take our ddos

21:23

@qshar letsencrypt is quite simple

[quakenet] <Davide> Learath2, if you want you can try my hosting company

Well, I'm going to check this out tomorrow )

Davide: doubt they'll want us with our 24/365 ddos

[quakenet] <Davide> I want

21:25

[quakenet] <Davide> I love improve my protection with tests

21:26

[quakenet] <Davide> For now it is impenetrable as far as I know

nfo has a great separate firewall and my server scripts set it up automatically. I helps to filter up to 70% of ddos attacks (edited)

we'd just take down all your customers with us and we'd all be yelled at

[quakenet] <Davide> Learath2, this is not possible

you have infinite bandwidth? nothing is impossible to take down

[quakenet] <Davide> Try

21:27

[quakenet] <Davide> Lowhosting.org

21:27

[quakenet] <Davide> Try to get down

is that yours?

[quakenet] <Davide> Yes :)

I mean, we could try

not like I have a botnet

(we could try hosting ddnet servers there)

[quakenet] <Davide> I've no problems if you want to try

Feel free to ask our resident criminals vali, sp someone and ezy they all are well equipped to give it a try

xD

you're reselling OVH vps?

21:29

we've had problems there before

Didn't you try OVH servers?

[quakenet] <Davide> I'm partner of OVH

21:29

[quakenet] <Davide> :)

ah

[quakenet] <Davide> My server are on OVH datacenter, firewall done by me.

I think we dropped OVH after they null routed us a couple times and didn't respond to deen's support requests on time

[quakenet] <Davide> Try my server lol

we could try hosting GER2 on it

[quakenet] <Davide> Okay

but that would be up to deen

21:31

maybe we should wait until we get some better protection against reflection

[quakenet] <Davide> Reflection is not an problem

21:32

[quakenet] <Davide> Reflection is not a problem

21:32

[quakenet] <Davide> (For my servers)

of course it's a problem it amplifies any kind of attack

why don't you like NFO? they null-routed me only few times for a short period

unless you have some tech from asgard that we missed

[quakenet] <Davide> Nfo is bypassable

@qshar I don't think nfo ever null routed us

you are lucky. I even got a message from them that they are sorry about that ;)

My mailbox is full of "(D)DoS attack against your service (for ddnetger/virtual)"

[quakenet] <Davide> Lol

nfo has a firewall that can handle with filtering some packets

[quakenet] <Davide> Qshar

21:35

[quakenet] <Davide> I don't like Nfo because there are very very very much method to bypass it

21:35

[quakenet] <Davide> methods*

bypass what? their firewall?

to bypass what

[quakenet] <Davide> Yes

how

[quakenet] <Davide> Ok

a firewall is a firewall is a firewall, it's as good as the rules you craft

yep

[quakenet] <Davide> Use synack purple with 1/1.5Gbps (Of TCP) and nfo fall

21:37

[quakenet] <Davide> Easy

21:38

[quakenet] <Davide> With good 2Gbps spoofed server and good script like synack purple nfo fall on every case

did you try it with the firewall that disables all tcp connections?

[quakenet] <Davide> Same thing, try with good UDP script and it fall

Well, its not perfect for huge DoS attacks, I know. but for most others it handle well

[quakenet] <Davide> With 5-6 Gbps of Spoofed UDP and about 4-5kk of pps

21:40

[quakenet] <Davide> And it fall

21:41

[quakenet] <Davide> Yes qshar

21:42

[quakenet] <Davide> Ok i've done one server with ddnet maps (for testing)

21:42

[quakenet] <Davide> 37.59.160.156

How would you filter that out without filtering out all udp? unless it's some set pattern any firewall protecting a game server will have a hard time with it

21:46

besides nfo handles udp floods just fine (no idea what you mean by spoofed btw) , catches similar lengths, attributes, types pretty well

[quakenet] <Davide> All filters are preimposted on slave server and on firewall, if you need (I think you don't need this) you can add custom rules on our firewall with the panel or with iptables/others like this

21:46

[quakenet] <Davide> Learath2

21:47

[quakenet] <Davide> Spoofed = Header IP modification on packets

on the ip layer?

[quakenet] <Davide> I speak about attackers

21:47

[quakenet] <Davide> All (Good) attacks are spoofed (obv)

21:48

[quakenet] <Davide> And need one spoofed server for do this

21:48

[quakenet] <Davide> I don't speak about botnet

21:48

[quakenet] <Davide> Botnet is shit (For me)

21:50

[quakenet] <Davide> more powerful attacks are done by spoofed servers not botnet

actually the record attacks are all reflection/amplification attacks rather then spoofed attacks, rarely does a server have enough bandwidth to pull off an attack itself

[quakenet] <Davide> ..

21:52

[quakenet] <Davide> Learath2..

21:52

[quakenet] <Davide> For do amplified attack you need one spoofed server..

and the biggest recorded attack that doesn't involve a reflection/amplification is iirc by Mirai at 300gbps

[quakenet] <Davide> Without spoofing you can't do reflected attack!

ofc, but flooding from one server is quite inefficient

[quakenet] <Davide> You understand me ?

21:53

[quakenet] <Davide> Anyway, now you can't do good mirai :/

21:53

[quakenet] <Davide> 2-3 years ago yes

21:53

[quakenet] <Davide> Now no

21:53

[quakenet] <Davide> Now you've more difficulty to do good botnet

also besides I don't see how you can tell apart a reflection attack from a botnet flooding except by analysing the source of the flood and applying some heuristics, all of which are irrelevant during an attack as traffic is traffic is traffic

[quakenet] <Davide> Yes don't care

21:56

[quakenet] <Davide> Anyway

anyways, if deen feels up to it we might give one of your servers a go on GER2

[quakenet] <Davide> Learath2, you can join on test server and tell me if is all ok?

I don't have tw on this computer and have a ripping headache, can't look at screens for more then 10s at a time

I can try

21:58

name?

37.59.160.156

[quakenet] <Davide> Yes 37.59.160.156

port?

[quakenet] <Davide> Default

can't connect

[quakenet] <Davide> 8303

21:58

[quakenet] <Davide> Oh

21:58

[quakenet] <Davide> 8303 is udb?

21:58

[quakenet] <Davide> udp

yes

[quakenet] <Davide> ?

21:59

[quakenet] <Davide> Oh, wait

21:59

[quakenet] <Davide> I'm with company vpn network

@heinrich5991 when someone says these numbers are within 3% of one another, does it mean 3% of x or 3% of y or does it need to apply both ways?

[quakenet] <Davide> I bypass all rules on firewall

21:59

[quakenet] <Davide> Lol

21:59

[quakenet] <Davide> Wait i open the port

@Learath2 I'd say: not really well-defined

thought so :/

Davide: not your fault, kicked myself

22:03

good night

[quakenet] <Davide> Good night Heinrich

[quakenet] <Davide> Deen