We're back online again., page 5
Pages: <<  2    3    4    5    6    7  >>
ATS Members have flagged this thread 0 times


reply posted on 20-4-2005 @ 10:19 PM by AlienS
Powered by AboveTop:Board v2.0
Based on XMB By Aventure Media & The XMB Group
Header data processed in 0.028 seconds
Page processed in 71.984 seconds
10 total database queries (6)

Yike. The frontpage appears to be a bit slow now. Also seeing errors at the bottom.

"Warning: file(): php_hostconnect: connect failed in /home/abovetopsecret/public_html/forum/index.php on line 468

Warning: file(
69.57.144.30...): failed to open stream: No route to host in /home/abovetopsecret/public_html/forum/index.php on line 468

Warning: implode(): Bad arguments. in /home/abovetopsecret/public_html/forum/index.php on line 468

Warning: file(): php_hostconnect: connect failed in /home/abovetopsecret/public_html/forum/index.php on line 469

Warning: file(69.57.144.30...): failed to open stream: No route to host in /home/abovetopsecret/public_html/forum/index.php on line 469

Warning: implode(): Bad arguments. in /home/abovetopsecret/public_html/forum/index.php on line 469

Warning: file(): php_hostconnect: connect failed in /home/abovetopsecret/public_html/forum/index.php on line 470

Warning: file(69.57.144.30...): failed to open stream: No route to host in /home/abovetopsecret/public_html/forum/index.php on line 470

Warning: implode(): Bad arguments. in /home/abovetopsecret/public_html/forum/index.php on line 470"


Hope it's nothing big


reply posted on 20-4-2005 @ 10:55 PM by Indy
Originally posted by smallpeeps
I've never heard of a mysql db getting corrupted.

Oh, there are MySQL virii out there for sure. More importantly, the 'bot' opening in M$'s structure makes Windows very vulnerable. As if Window$ users needed more to fear.

www.virusthreats.com...

news.com.com...

There's no solution. There is no security in the computer industry. If someone wants in, every lock can be picked. Backups are the key to surviving, long term. That and education.


It this the windows version of mysql? Also I have port 3306 firewalled on my machine. It does not accept external connections. Now I know there are some things you can do to crash a mysql db especially if the form data isn't properly cleaned up. But given the fact that someone would try it I will not mention what that way is. I found out what happens when I was testing some db work I was doing.


reply posted on 20-4-2005 @ 11:45 PM by Indy
Here is how apache/php and mysql work....

mysql opens processor threads to handle your requests. So lets say a mysql thread eats up 25 mb. If there are 10 queries then there is 250mb of ram used. Most queries are so fast they open and drop in a fraction of a second. A big query can use a bit of processor but not really that much.

Apache does the same thing mysql does. It has a thread open. I think I have mine to default to 8 or 10 idle threads. With my configuration I think they are about 16mb each. It works just like mysql. It opens a thread for each connection and closes it when the ocnnection is done. This can add up to a TON of threads because the hmtl page that gets sent plus EVERY image served counts as a connection. So 1 page + 8 images = 9 threads. It is very light on cpu but heavy on memory.

Having php compiled in effects the amount of memory apache uses. A raw apache install might require 4 to 6mb of ram while loaded apache with php and ssl might use 20+. These numbers are estimates.

CPU usage for the most part is never an issue. Dual procs are nice for extensive db use. It just allows more queries to be processed at the same time which doesnt allow the que to build up. Once a certain limit it is hit the threads will be put in a wait que. That is where the delays come in.

To help memory usage on my system I have 2 apache servers running. One is on the default port of 80 and the other is on 8080. The main one handles the display of the web pages. The one running on 8080 serves basic content like images, downloads, etc. Something where plain serving is required and no php. This saves me a great deal of memory. I can have 3 or 4 threads open and use the same as 1 thread on the main server.

Clear as mud?


reply posted on 21-4-2005 @ 04:41 AM by CPYKOmega
Originally posted by smallpeeps
Someone I know said it was web wide attack using 'packets'? or something.

Probably your friend was referring to the 'packets' that make up all the traffic on the Internet. These are the packets that TCP/IP (Transmission Control Protocol/Internet Protocol) uses to deliver everything on the web.

Basically, every 'infected' computer connected to the web will obey commands given to it. So if your computer is hijacked (by your opening an email wrongly or whatever), a hacker could use it to continuously bombard a target site with a million requests, thereby shutting it down. This is called denial of service attack and the largest documented one involved something around 30,000 computers. NOTE: That's 30,000 computers infected with a single specific program/virus which has a specific instruction that wakes it up to do it's dirty work. Maybe your friend was referring to a DOS attack?

This situation sounds different. The original post says there was massive database corruption, but what was the cause of it? It's not hard to corrupt a DB if you can trick it into overwriting certain sectors but you still have to gain accesss to the server. Every database has a sword of damocles command hanging over its head and cutting the thread is as easy as however hard it is to gain access. I'm impressed at SO's discipline in regards to backups. 24 hours of lost data is considered a major success of your backup methodology. Well done, SO.

Here's the latest threat list from Symantec. No database viruses in the last couple days, but the ATS bug could have been a program which was inserted at any time in the past. I guess it's a subject for RATS anyway.

securityresponse.symantec.com...

[edit on 20-4-2005 by smallpeeps]



If it was a DOS attack. I think alot more websites would have been effected. Everyone here remember the script kiddie who hacked yahoo, CNN, ect and shut them all down for hours about 4 times? Funny how someone with limited knowledge of a computer... using only programs given to him/her with no programming skills could take down some of the most visited sites in the world today. Here's the nostalgic link to the story

Script Kiddie Hacks CNN

Pages: <<  2    3    4    5    6    7  >>    ^^TOP^^