Testtube

First Let me say Thank you L.C for investing time creating the topic and looking for input. I have alot of experience with postgresql in a enterprise enviroment I work with root@scm:~# psql --version psql (PostgreSQL) 8.3.8 daily With that being said I LOVE postgres. However SSDL does not need a enterprise level stand alone postgres install. It just not get hammered enough to justify its use. Regarding file updating- This is one main issue with the current setup We are using file management system made by Bajan which isnt finished. If you add a file you cant remove it (unless you manually do it from the DB) you cant edit files. its well incomplete. I would like to start from scratch (again 3rd time) Give the site a facelift. keeping the layout Very simple. Allowing easy updating/adding of files. The only prerequisite would be being able to pull the data from the existing file descriptions and preserving it. this is key as that would be a monumental task replicating manually all the file names/descriptions/file sizes. I do feel if we get SSDL back on its feet it will have a end result of a better/larger community SSDL for the longest time and maybe up until the last month gets more generated traffic then the entire ssforum network. That's a lot of eyeballs looking at that part of the community. Helping the community and making it the best it can be has always been one of my # one goals If it means i need to spend some cash to try to get this accomplished i am willing to do so. Now is the time to step forward to help out You can reply here or add me on ICQ - 173683 we can talk about the project and figure out a game plan.

I have tried to decode it with my phone however the image quality is not good enough for it to be successful.

Hmm good to know.

The fact that you are getting from the UK to the the US server in basically 8 hops is amazing.

wow

actually some of that code was a first time for me. Other i pasted from another script from my toolbox.

If you wanted to get a bit more hard core with it. this writes to a logall log file and also sends it to you via email. #!/bin/bash ############################################################################### # This script checks the pid of a program and if its greater than 0 its # # running If not it executes the program # # # # # # # ############################################################################### # Author information ######################################################## ############################################################################### # # # Ryan C 12/30/2009 # # For General use # # # # # ############################################################################### # Change log # ############################################################################### ## # ## 1/5/2010 Initial release of code. # ## # ## # ## # ## # ## # ############################################################################### # Variable Section ########################################################## PIDOF=`pidof pico` #name of program to monitor PROGRAM='pico' #set where the program lives LOG_FILE=logall.`date +%m%d%y` ############################################################################### { if [ ${PIDOF} -gt "0" ]; then echo "$PROGRAM is running." >> ${LOG_FILE} else echo "$PROGRAM is not running $PROGRAM is being started." >> ${LOG_FILE} $PROGRAM fi } WRITE_LOG_HEADER () { echo "# Begin WRITE_LOG_HEADER function" # echo "###############################################################################" >> ${LOG_FILE} # echo "# TRANSFER LOG #" >> ${LOG_FILE} # echo "###############################################################################" >> ${LOG_FILE} # echo "Transfer log for `date`" >> ${LOG_FILE} echo >> ${LOG_FILE} # echo >> ${LOG_FILE} echo "# End WRITE_LOG_HEADER function" } # # WRITE_LOG_FOOTER () { echo "# Begin WRITE_LOG_FOOTER function" echo >> ${LOG_FILE} echo >> ${LOG_FILE} echo >> ${LOG_FILE} # echo "###############################################################################" >> ${LOG_FILE} # echo "# TRANSFER LOG COMPLETED #" >> ${LOG_FILE} # echo "###############################################################################" >> ${LOG_FILE} # echo "Transfer log for `date`" >> ${LOG_FILE} echo >> ${LOG_FILE} echo >> ${LOG_FILE} echo "# End WRITE_LOG_FOOTER function" } # # SEND_LOG () { echo "# Begin SEND_LOG function" cat ${LOG_FILE} | mail -s "Transfer Log: ${LOG_FILE}" billy@aol.com echo "# End SEND_LOG function" } WRITE_LOG_HEADER WRITE_LOG_FOOTER SEND_LOG

#!/bin/bash ############################################################################### # This script checks the pid of a program and if its greater than 0 its # # running If not it executes the program # # # # # # # ############################################################################### # Author information ######################################################## ############################################################################### # # # Testtube 12/30/2009 # # For General use # # # # # ############################################################################### # Change log # ############################################################################### ## # ## 1/5/2010 Initial release of code. # ## # ## # ## # ## # ## # ############################################################################### # Variable Section ########################################################## PIDOF=`pidof konsole` #name of program PROGRAM=/home/ofprogram #set where the program lives ############################################################################### if [ ${PIDOF} -gt "0" ]; then echo Program is running else echo Program is not running Program is being started #$PROGRAM fi

monit anyone? http://mmonit.com/monit/

I joined up Last time i checked we are up to 142 members how does this attract more people to the game though?

WHen you finish early do you lose your job?

If you had a txt file with all of the non converted barcodes like barcode.txt with the following info in it f109030 f109014 f109012 f109042 f111974 f111881 f103142 f123059 f113410 f113411 f109025 f109015 f113408 f109024 f111966 f113409 f109183 f111208 You could put this in a script cat barcode | sed "s/f/0000/" | sort -n >> results And your output would be in the results file 0000109030 0000109014 0000109012 0000109042 0000111974 0000111881 0000103142 0000123059 0000113410 0000113411 0000109025 0000109015 0000113408 0000109024 0000111966 0000113409 0000109183 0000111208 or make a file named barcode.sh and put this in it. #!/bin/bash echo Please, enter your barcode to be coverted read barcode clear echo Converted bar code $barcode | sed "s/f/0000/" Does this help?

That would be pretty easy to do with a linux script

Thank you for your post LC better late than never... I feel better about the situation.

swift go ahead and give him his access back please.

The plot thickens a bit..... From what i understand and the logs show Cre is the one that executed the script and was downloading the content 69.113.210.18--- This traces to a optonline.net Which as many of you know is one of the leaders in break kneck speeds ISP providers I have also found out it appears he has a business account. For the base pacakge of 30 dollars a month he has a 15 meg download connection. If he has the 45 dollar a month plan hes now up to 30 meg download and if hes really hard core it gets him 101 megabits per second 10 times the amount i have for my dedicated server. 67.54.231.207 - after researching this ip address i have found there is no way this IP had anything to do with the downtime of my server. 147.143.252.2** - Is LYNX which i dont believe caused any issues. I would also like to attach comments from a recent instant message convo i had with LC. Normally i attest people who post instant messaging logs. but i wanted to let the fucking truth be known. What was done. And everything that i said was 100 percent factual. The people that fell and jumped on the bandwagon You also look like a moron.. [20:57] testtube302: Was cre the one that downloaded the files [20:57] testtube302: The reason why i ask. [20:57] testtube302: I found his ip.... [20:57] testtube302: And its associated with a optounum online account. [20:58] testtube302: The reason why thats of importance [20:58] testtube302: Is i think the lowest package they offer is like ~10 mbps [20:58] hlrsecom: Cre was the one who downloaded the files, and he executed the script from his own machine using his own hardware and internet. [20:59] testtube302: i have never heard blueyonder [20:59] testtube302: 67.54.231.207 [20:59] hlrsecom: He has a business subscription (allowed to host servers) I believe. [20:59] testtube302: or whatever. [20:59] hlrsecom: BlueYonder I believe is a gaming ISP or something. [20:59] testtube302: wildblue i am sorry [20:59] hlrsecom: I recognize the name from the Half-Life environment [20:59] hlrsecom: Ah [20:59] hlrsecom: Wildblue is my Internet. [20:59] testtube302: but i dont believe they offer speeds that he was pulling [20:59] hlrsecom: They provide Satellite. [21:00] hlrsecom: Haha, no way. Maximum I could have pulled at best conditions is 128 KB/s [21:00] hlrsecom: It usually isn't in best conditions [21:00] testtube302: is cre online? [21:00] hlrsecom: He disappeared. [21:00] testtube302: Can you see now how the issues with my server [21:00] testtube302: could of happened? [21:01] hlrsecom: I am beginning to see your situation more clearly, I'm still curious about how a script could have done it. [21:01] testtube302: You have a person with at the very min. a 10 meg connection if its bussiness class i am sure its more. [21:01] testtube302: My latest reply to Lynx had this in it. [21:01] testtube302: Could you please paste the part of the code in the script that waits until the file is completely downloaded before moving on. Can you also provide proof that it never moved on without first completing the file that it was on.. [21:02] testtube302: Can you provide the code to the script that shows it waits before it moves on. [21:02] hlrsecom: If all the files were downloaded on a 100mbit connection through Firefox, one file at a time, do you think the load would be the same on your servers as result of this event with script? [21:02] hlrsecom: By the way, I did suggest to L Y N X that he provide a copy of the full script as poroof of its functionality [21:02] hlrsecom: I suggested this at the beginning of the thread before he and Cre made replies [21:03] hlrsecom: I told them to provide the script to eliminate the accusation that the script may contain bugs or potential malfunctions that would pull extra bandwidth [21:03] hlrsecom: They, at least L Y N X, said he won't do it because they shouldn't have to...or something along these lines [21:05] hlrsecom: Also, at the beginning of the thread when you first made your reply, I have considered the possibility of server loads coincidentally already being high or experiencing a higher traffic than usual, possibly contributing to the 'server crash' [21:06] hlrsecom: I do not quite recall noticing the server crash, assuming SSDL and SSF are on the same server, as I was refreshing SSF for new posts frequently....I only noticed that IPBB locked me out due to high server loads. [21:07] hlrsecom: I remember complaining to Cre that SSF is "down" due to high server loads [21:07] hlrsecom: This was while he was downloading. [21:08] hlrsecom: I do not think Cre really had intentions to be malicious or cause this problem -- although using a script to do this in one sitting in just common knowledge, I think, should clearly have been a stupid and childish thing. Unfortunately, I must admit, I think I would have fallen into the same trap without giving it a second thought if I knew how to program in Python [21:09] hlrsecom: As soon as 'legal' and 'DMCA' entered the picture, Cre was freaking out a lot [21:10] testtube302: are you fucking serious [21:10] testtube302: You have known this the entire time [21:10] testtube302: but you let your friends [21:10] testtube302: verbally beat the shit out of me on ssforum [21:10] hlrsecom: I didn't tell them to do it. [21:10] hlrsecom: I told them to stop actually [21:11] hlrsecom: And over the past cfew days I have been constantly trying to write a reply, for which I have always found myself at a deadlock in trying to write an appropriate one. [21:12] testtube302: You have lost alot of respect from me. [21:13] testtube302: i am pretty blown away. [21:13] testtube302: As you have seen me defending the stance that i took [21:13] testtube302: You kept this out of the picture [21:13] testtube302: And allowed them to do this on the forum with the replies knowing [21:13] testtube302: What you know. [21:13] hlrsecom: How about this: [21:14] testtube302: even after i told you to please get involed.

[1st point] Addressed The question whether or not you had managed to take personal files came when i was at work paying for the server i donate to this community. It was not immediately clear how this happened as i was working from a cell phone or from work. (As i made mention to LC) both the fact that i was at work and the fact that i was not certain if my personal files had been harvested during this pillage of my site. It was not until later that night that i had time to go over the Apache logs to see what you guys have done. (also the same time that i told cre that i wasnt going to pursue anything legally) I think think this over explains your first point but sometimes you have to dumb things down. [2nd point] Addressed * The fact that you didn't write the script makes no difference You are part of the group that took part in this situation. Congrats on making a additional script * I am glad that you did not use the script. however after the comments made in this forum and your opinion on the matter lumps you into a particular group i would rather not associate or waste my resources on. * You did not intend to download any files from me? huh? what? * regarding not giving a shit? Well i would think you should After all we are all trying to help the same community. I wouldn't hurt you and say HAHA i don't give a shit. I dont have 70 business on this machine the majority are non critical sites that i host to help others out. Well shit you should know you asked me for hosting only a couple of months ago??. Maybe if i wasn't so busy and was able to catch each other online around the same time i could of set that account up for you. Perhaps maybe even then you would care if someone was fucking with the server you had your personal shit on. Now to bring up the point you make about my server hardware. I am not rich. I have a family to feed and to take care of we are going into the Christmas season and America is facing one of the worst depressions ever. Her in the area i am in over 10.5 percent unemployment numbers and still rising. When you are in the business of helping people and times are tough you have to make sacrifices and cut backs. SSFORUM and SSDL enjoyed several years on a enterprise class server which i payed for out of my pocket. With the huge decrease in population over a couple of years it made more than enough sense to move it to a VPS. The VPS is with a very reputable company in the industry and i pay very well for the bandwidth that i do consume. But it allowed me to cut some costs and continue to offer free services to friends family's local business and a couple that pay regularly that don't want see taking anything free in life. With that being said the main server that hosts several virtual private servers i am sure at this point has reached its capacity after being on the server for atleast a year now or close to it. I am also given limits to how much ram and cpu of the main server i have access to. This has never been a issue until you guys used your script on my site. The fact that you say that its poor server administration is complete and total bullshit. Its called getting by with whats needed under normal use. You and your friends put abnormal use on the server. I can show you where the site gets hit frequently with stats going back a long time. And this has never happened before. I did not make the site another community member and friend Thebajan made the site. And we both understand that its not the best it has issues and needs to be re-made. I have made several posts requesting help in that effort several times over the years. Again this is not poor server administrating. And lastly to finish this point up the site was being used fine for atleast a year on this particular server. However when you abused the site that's when we started having issues. * Thats sad * I see good to know * To address this point i would like to remind you This is the internet You have 0 clue who i am what i do or anything about me. And the same goes for me not knowing shit about you. The world is a crazy place and i am sure life will treat you better if you keep that in mind. [third point] Addressed I am spending additional money to aquire additional bandwidth capacity from my provider. I am having to do this because you and your friends pillaged the SSDL website by using a script which consumed ~80 percent of the total bandwidth available leaving at best 20 percent for the 69 other sites on the account. For several hours. No one has ever done this before. a 10 meg pipe is about 8 times more than what SSDL used to have at its peak. back when it was first brought online. in any event this does not show poor server management this shows poor judgment on a handful of people. The ability to do what you have done has always been there you didnt invent some super script to pillage my site People could of done this years and years and years ago. The fact that no one has done it until now if anything should show that its a bad idea. Lastly I host a lot of people that do different things with their account in fact i signed up syrus and i am hosting a couple of active sites for him. I never receive complaints mainly because how well i run things.. Your assertions are false and unfounded. Could you please paste the part of the code in the script that waits until the file is completely downloaded before moving on. Can you also provide proof that it never moved on without first completing the file that it was on..

First of all this has never happened in all of the years i have hosted the website 6+? Nor has it happened in the one year+ i have had it on the the VPS it does not have a damn thing to do with traffic patterns or how the server is managed but everything to do with the script harvesting files from my site. They did not use the site as its intended. It is not intended to have a non human raping the site for its content. If they had not used a script and had they not disrupted service this would be a non issue. (going on the assumption only SS content was taken) The entire last part of your point is worthless I didnt have a issue with the site I didnt need it to be mirrored. I didnt have a resource issue I didnt have a issue spending the money i was spending for the site to be online. Only until i have idiots running the scripts to harvest content from the site do i start to have a problem. Dont fuck up my server and i wont have a issue. PROBLEM SOLVED and simple enough.

Actually removing your ability to access the servers. Will ensure this type of behavior from repeating in the future. Not concerned about you having the files now. I am more worried about future offenses I wont go into the other points that you have made as its a simple repeat of what i have already stated. Whether you understand it or believe it happened I cant help that. I don't think you are a criminal I think you might be a idiot with to much time on your hands. Which has caused downtime and damages which has caused me money.

Its pretty amazing you admit what you did. You admit that you downloaded the entire site in one sitting. But deny the server having issues was because of what you done. You sir are a moron. I believe i have had all these sites hosted on this server for almost a year now and this has never happened before. Then you say "ok" if we did cause your server to go down its because your server sucks and the other reason you give is I should have given LC FTP access so he could of sucked it clean via a ftp client What i should have done at the start of this. After supplying the logs Instead of trying to reason with idiots is just ban the people involved from my webserver and any and all game servers i have access to. and just been done with it and move on. I dont think its to much for you to one admit you screwed up in the manner you obtained the files and to understand why i am pissed regarding what you did to my server while retrieving the files

Cerium this last reply was a bit more constructive I think what your still missing is this.. I am hosting 69 sites on the server i mentioned including SSDL on the 10 meg pipe In the past YEAR i have had these account on this particular server there has been 0 problems Until ~November 30th If i have 69 sites fighting for resources and then another person slamming it with another 6 to 8 megabits will make the server appear offline. the same way if i was hitting your 2 meg connection with downloads and then had another handful of people trying to access the same server. I think the reason this happened was a combination of bad timming on THIER part to attempt this while the server was already using X amount of its potential 10 megabits and then the other piece of the pie was the script using X amount of resources Again there is no question whether or not what they did affected myself my server and the community websites here. There is also no question how they went about it was improper and not acceptable. You also make the assertion that i shouldnt get upset that people use the site as its intended. The site is not intended to be downloaded in one sitting. That is abusive I also dont care that they have the content that they have. I HAVE IT ON LINE FOR PEOPLE TO DOWNLOAD FOR FREE what i do have a problem with is how they went about it and how they abused a free service. I also had issues if they retained data that was not theirs to download. Please argue with me on these points. I have made changes to my setup to soften the blow if shit like this happens again. But then again its at my expense. This has a direct impact on this game. It limits what else i could be spending that very same dollars on on advertising or something else for this game. One last edit Your knowledge as it pertains to VPS and VPS servers as it relates to webhosting i can only imagine is shitty at best. Most VPS environments only guarantee X amount of resources from the HOST. whether that be CPU or memory once you hit that limits your SOL. It really depends on the package the person is on and the type of VPS they are offering you.

Actually everything you posted cerium is based on best guess. #1 You dont know what i run how much i run Who i run how much capacity total how much capcity left over how much cre is able to download per mbps everything you listed is based on a assumption You also have no idea what type of server i have whether its shared or dedicated. The resources i have dedicated to these sites. Everything you have said is based on pure assumption and completely worthless and holds no weight anywhere but in your imagination. You also have 0 idea what the scripts did as far as load memory usage apache threads and have no idea what type of load it put on SQL due to queries and threads. To be honest I don't have a exact answer on that either because i was not sitting in front of the machine during the time frame they did this shit. However i do know it had a detrimental effect based on what others have said to me during the time frame this happened. And by looking at how long SQL requests took to process and uptime reports showing downtime. Not only are you calling me a liar but everyone else who noticed it as well a liar. There where no threats made over IM infact i welcome anyone who has them to post any logs of chats i have had with them regarding this matter. However i am very upset regarding what they did. WHICH i have EVERY RIGHT TO BE I DID SAY that if something like this happens again. and it has a negative impact i would pursue it further. The fact that i am going to compile a archive list of files and give to LC to use is not being given to him because of this INFACT it would be really stupid to do so after you have the entire contents already. I am doing it in hopes of making something actual meaningful other than a exact replica of SSDL which serves 0 purpose at the time of this writing. over the 5-6 years as you put it that i have ran the show for SSDL it has been on a couple of servers. ALL OF WHICH HAS BEEN FULLY CAPABLE OF RUNNING THE SITE BASED ON ITS NORMAL AND PEAK TRAFFIC PATTERNS This was not normal or ordinary. Thus the failures that occurred. I did let LC know that i would be checking the files and if any of MY Content was taken then i would be sending a DMCA letter to his Datacenter. I did it in the nicest way possible and i have every legal right under the sun to do so. When i spoke with Cre in subspace and if he logged the conversation it would show that i said i was not going to pursue any legal action. and under the circumstances was completely friendly with everyone that has been involved Cerium you are a pretty smart guy but based on your reply shows your lack of understanding on how servers work. One can not make a informed opinion without knowing some very crucial facts as i mentioned above The server connection/port speed The server hardware/Ram/cpu/disk Whether or not the server is dedicated or shared This particular server is running on a shared 10 megabit pipe (WHICH I have a lower commit rate based on 95th percentile) this server is a VPS running on a very busy HOST server. Disk I/O is definitely a issue. I have shared Memory and Shared CPU and works perfect for the current needs. I host (As of today 69 shared hosting sites) on the server Hopefully with this additional level of information you can make a more educated assumption of what happened. Thanking them for abusing something that i give for free wont happen you live in a fantasy world. I have made some adminstrative changes to limit my liability for hosting these community websites is this something that should of already been done? Maybe it SHOULDN'T have to be i have increased port speed and also my comit on bandwidth usage (mbps) which in the end costs me more money and you nothing. WIN WIN for all.

I can promise you everything you just said in this reply is false/incorrect I can attest to this as having first hand knowledge.

Let me sum up what happened and what they dispute even though there is evidence to support it. 1) Downtime They caused downtime to the web community that i host I believe that the downtime was caused for a couple of contributing factors A) there was a download lasting several hours using nearly all of the bandwidth resources of the port. The server load was MUCH higher than normal causing issues with SQL database connections which is a requirement for most sites. 2) The additional costs associated with higher 95th percentile billing. This may or may not be a issue the fact that it happened on the last day of my billing month may get me a free pass to this incident that is still under investigation. 3)The abuse of resources on accounts they had access to and given to for free. The fact that you think your scripts could not cause the problems i have indicated is irrelevant as I have proof to show other wise as well as "eye" witnesses of members of community that you brought down can attest to. I understand very well your opinion on how you did nothing wrong by taking the files you did as it cant be stealing. And in essence i guess you are right. I never said that it was. I did say i had personal content on that domain that was not ss related and if that content was removed then it was stealing. However the matter that you have not addressed which i can prove is the physical damages. That being the increased cost of bandwidth and the downtime your script caused to my server which also can be proved By individuals and uptime monitoring services. What you don't know is the monetary value your actions has caused me due to the downtime of my server/services i provide other people on my server. As i do use this server to provide services for others. I can only imagine you dont care. And thats fine. I have spoken further with LC and i will be making my own archive of files he can have and mirror and we will leave it at that. However i want to make it clear If you do anything else malicious to my server whether you "meant" to do it or not or you have any further negative effects on this community or sites that i host. I will bring this to a level i can promise you it would be better to advoid. This is not a statement to try and scare you or to make you think i am all big and bad or to prove that i am some sort of a elitist. Its a promise I have to protect what i am responsible for and i will. Please do not abuse my kindness and my good will for this community and don't turn something that involves a game and make it into something border line criminal. My hopes are not to try and covert your backwards way of thinking as i have found in life that's impossible to directly effect someones opinion but it usually changes with time. But to assert while i am not pursing anything this time next time I will. I have no problem working with people in this community to help make Subspace better What you guys approached me which you have linked to in another thread there was no reason for other than "you wanted to do it" Thats not reason enough in my book if i was approached with a real reason and how it would help the community i would of helped with open arms. That never happened. I think that covers everything i needed to say.