COMPAQ LAPTOP - WEB SERVER and MYSQL WITH PHP
Forum: User Feedback
Topic: COMPAQ LAPTOP - WEB SERVER and MYSQL WITH PHP
started by: NewDude
Posted by NewDude on Mar. 30 2006,18:16
Hey everyone,Just wanted to tell everyone that I have taken my Compaq LTE 5380 P133mhz, 48MB, 2.1HD, in a docking station and have gotten it to run my PHPBB forum and website.
It is running an HD install DSL 2.2B. I stalled XAMPP on it, and last night I install PHPBB forum on it. I port forwarded port 80 on router to the Compaq Laptop and running some tests over the internet.
It is slick... it is actually running very well. I am going max out the memory on the system to 80mb in a week, but even with 48mb, it is running good. I am going to migrate my MySQL DB on my server that running my PHPBB forum right now, to the laptop. I am hoping with in 2 weeks I will be able to turn off my Poweredge Dell server in the garage and use the laptop over that summer in my room to run my forum and website and email server. Still trying to find a good light weight email server to run on my laptop.
Just letting you guys know that when running DSL you don't need a real powerful machine to run a MySQL, APACHE, PHP..etc... to get good performance. So blow the dust off those old system and put them to work.
Posted by AwPhuch on Mar. 31 2006,00:30
Hell yah! Glad you got it working man!drop us a url so we can check it out
Welcome to the Revolution!!!
Brian
AwPhuch
Posted by brianw on Mar. 31 2006,01:25
Not sure if this is applicible to your laptop or not but on my Armada 7800 I had to go into the setup and disable acpi in the bios to get the fan to work. Before that the only way I could get the fan on was to reboot. The fan would come on and stay at the same speed (so if the system was real hot when I rebooted the fan would be super fast and I would have to reboot several times until the spedd was acceptable) until a reboot was done. Disabling acpi in the bios has made the fan work properly (comes on when needed and goes off when cooled down).To add to your comments about the server speed ...
My armada is a 266 and I have kdm installed. The other day I threw the dsl 2.2 CD in my wife's machine and booted without X started. I then issued the command Xvesa -ac and a kdm login was displayed from my laptop. I logged in and was presented with my display and could do anything as if I was at the laptop. My freesco floppy died though so I set that back up and didn't get back to play with the xterminal login.
The moral ... The possibilities are virtually endless with DSL.
Posted by NewDude on Mar. 31 2006,03:50
Hey guys, the forum I run is a poltical/military/hiking/computer/space stuff/ 4x4, etc.I mainly set it up for me and my friends... but all are welcome... My hobbies include beer making, backpacking and day hiking, mountain biking, lifting weights,4x4 (JEEP) and of course computers I also work full time as a computer programmer/DBA/ Oracle Discoverer Administrator. So I am always wanting to chat with people with the same interests as me. So if you guys want to check out my forum here is the URL
< PLANETX APPLICATIONS FORUM >
Currently though, it is still running on my Dell Poweredge Server. I am still testing it on the old compaq laptop, last night I port forwarded 80 to the laptop to run tests... I won't put the compaq as full time server until I have the email server put on it fully running the way I want. I figure in 2 weeks...only.. 2 weeks I will have it fully running and ready to serve the world. Planetxapps is my domain. It is a name I call my side business that my friend and I do building small business networks on the side away from our full time jobs. About 7 months ago, something hit me... I got really tried of Microsoft... this has been coming slowly for the last few years, but 7 months ago that was it... I started looking into flavors of Linux... I messed with SuSE, Fedora, Ubuntu. I ended up really liking Ubuntu because it was only 1 CD to worry about... Then I stumbled on DSL and Puppy Linux and my world changed over night... I quickly ditched Puppy and went head over heals for DSL...
DSL has given me a new drive for computers because I can do just about everything I need with it on a system that is 10 years old. I don't have to spend lots of cash to keep up with the hardware. And when I did run DSL on my new system, it was incredible... I still get amazed at the speed.
I am still learning Linux, but since I bought a couple of books, things are getting more clear and I am doing well with it. It makes sense and searching the forum has answered so many questions. Most people asked the same questions.
ALL I HAVE TO SAY IS: WHEN YOU CAN HOST A MYSQL FORUM, WEBSITE, AND EMAIL SERVER ON A 10 YEAR OLD MACHINE THAT HAS ONLY 48MB(SOON TO BE 80mb) THEN YOU HAVE FOUND ONE DAMN KILLER OS...
I will keep you guys upto date. I am also going to post my procedures of setting up the whole thing. So if a newbe (Like me) wants to setup a website and/or Mysql DB and/or etc... they will be able to.
It really hasn't been that hard... I have made a few mistakes, but between DSL being awesome and XAMPP being easy, it has been easier so far than setting it up on WIN2K...
I am starting to try to learn Mosix to. I have been reading and trying to learn it and I want to get Mosix running on my network as a test. Maybe this summer I can get 2 test boxes together and test Mosix and try to get it going with DSL.
< MOSIX >
Posted by NewDude on Mar. 31 2006,04:01
brain...I had no idea that you could control the fan like that...
See... this forum is great.. everything I log on here I learn something new...
I will have to check out my laptop and see it that will effect my laptop... fans are important... eventhough my laptop will be inside and out of the heat during the summer, while I am gone away from home, the house will still get warm because I turn off the AC... so this is worth investigating...
Thanks
Posted by NewDude on April 06 2006,14:18
Another update:I bought more ram for my laptop. it is maxed out at 80mb.
I even noticed a good increase in sleep because of the extra ram.
I have my PHPBB forum running on it good now, but still having problems with the restore of the DB. Having weird SQL errors... I am working on that though.
Anyways, when I get it fully up and going with the laptop running DSL as my web, email, and DB server I will let you guys know.
Also, I will post from start to finish what I had to do so others can learn from my mistakes and continue on for the quest to run fast web, email, DB servers with old hardware.
Posted by AwPhuch on April 07 2006,02:23
I wonder if you could incorporate squirrelmail into your XAMPP install?Perhaps that is what make it worth while
Brian
AwPhuch
Posted by NewDude on April 13 2006,14:30
< My Forum running PHPBB, MySQL, PHP >All I have to say is: Why does anyone need a super fast machine to run a website, unless you are getting massive hits a day and have a ton of bandwidth, a low end pentium 1 with Damn Small Linux can handle it. My next test will be running a web server using a 486 and DSL 2.3 TALK TO ME!!! I bet a 486 with 64mb and a 500mb HD will be all I need.
My Compaq 5380 laptop is running as my web server at home now.
System Stats:
Operating System = Damn Small Linux 2.2B
Web server = Apache
Database = MySQL v5.0
Web scripting = PHP v5
= Perl
FTP Server = ProFTP
CPU Model = Compaq 5380 Laptop built in 1995 in docking station(Runs quiet)
CPU speed = P133mhz
RAM = 80mb
Hard drive = 2.1 GB / with Win98 on hda1 taking 700mb, so actually only using 1.4GB with 250mb swap and 400mb
of free space to play with and DB growth
Swap file = 250mb
***********************************************************************
Installing PostFix this weekend to run as my email server. Deleting Win98 partition to make more room. Does the new version of Partition Magic resize Linux partitions using free space, like it did in windows?
Or is there another good partitions resizing program that could help me out. If not, I could take that nuked HDA1 partition and start using it as email inbox space...
Posted by cbagger01 on April 13 2006,17:38
Try Parted from the mydsl repository:< http://distro.ibiblio.org/pub....ted.dsl >
< http://distro.ibiblio.org/pub....sl.info >
Posted by NewDude on April 13 2006,20:03
THANKS cbagger01, this will work...I will be installing this over the weekend and deleting and resizing that win98 partition... Thanks a lot, I think this will do the trick...
Posted by AwPhuch on April 13 2006,22:49
| Quote (NewDude @ April 13 2006,10:30) |
| < My Forum running PHPBB, MySQL, PHP > |
So this is your site you are running directly from that laptop using DSL and XAMPP?
Apache/2.2.0 (Unix) mod_ssl/2.2.0 OpenSSL/0.9.8a DAV/2 PHP/5.1.1 mod_apreq2-20050712/2.1.3-dev mod_perl/2.0.2 Perl/v5.8.7 Server at www.planetxapps.com Port 80
Brian
AwPhuch
Posted by NewDude on April 19 2006,15:57
Hey Brian...Yeah, that is it... We already talked on my forum, but I didn't want to leave this question hanging out there.
As I posted eariler, you can see my hardware list for that machine and my software list.
The only thing that is different now is I have added ProjectZen webmail and it is grabbing mail of my email Win2k server. I still haven't gotten postfix setup because I was in need of accessing my email from work, so I started trying out PHP webmail clients.
ProjectZen works great. Had to create another database in MySQL and run ProjectZen SQL script, configure the config.php file, and that was it. It was very easy to setup. Although, isn't quite what I am looking for, but it works for now.
My next hurdle is: Get postfix installed and configured and getting keep trying out different webmail programs until I find one the fits. ProjectZen might be ok once I get PostFix going, not sure yet.
My main hurdle is: I moved the laptop with docking station into my bedroom. It is quiet, the wife got upset and said she can still hear it and it bugs her. So I have to figure out where I am going to put it in the house. The garage is just going to get to hot in a month or so. I tried researching ways to keep it in the garage and cooling it off, but haven't found anything yet. Everything is geared toward tower PC's, not laptops...
I am considering buying a mini ITX computer that runs silent and run my forum and website off that, but that takes $$.... I have considered buying one off this site that is preconfigured with DSL. They are cheap on this site.
I don't need a lot of power. P133mhz laptop running MySQL, PHP, Apache, forum, website, etc... is running outstanding.
I have looked on Ebay at some older mini's made by HP and they seems like they would be fine, but I just need to figure out away to quiet the laptop down a little so I can hide it in our room without the wife hearing it, I don't want to transfer the forum db over to a new system. Also, it is cool and gives you bragging rights when you say you are running a full blown forum and website using DSL on a P133mhz(A system the was built by Compaq in 1995) 11 years old and running great.
I rub that into my coworkers face daily, as these guys think they have to have the latest and greatest hardware to run their sites using evil Windoze.... How ignorant they all are.
Posted by NewDude on April 19 2006,16:04
I guess I didn't state this eariler:Yes, I am using XAMPP.... XAMPP was a little more than what I needed, but Linux being fairly new to me, it was the easiest way to go.
When I get every going in the next week or so, I will sit and finishing documenting what I did, and post it. If any new poeple to Linux want to do what I did, they can go off what I wrote to help them through the process. But so far, it hasn't been that hard.
The hardest thing so far was figuring out why APACHE wasn't post my gifs and jpegs correctly. That was an easy fix in the httpd.conf file.
Posted by AwPhuch on April 19 2006,23:22
See if you can get eAccelerator running...find the .dep package and get it installed | Quote |
| Description eAccelerator is a free open-source PHP accelerator, optimizer, encoder and dynamic content cache. It increases the performance of PHP scripts by caching them in their compiled state, so that the overhead of compiling is almost completely eliminated. It also optimizes scripts to speed up their execution. eAccelerator typically reduces server load and increases the speed of your PHP code by 1-10 times. |
I noticed an instant change in my phpbb when I installed it on my server!
Brian
AwPhuch
Posted by lovdsl on April 22 2006,03:02
well..I can't read this, see your forum, and not say...something.That is totally excellent..was going to post but not sure you want dsl noobs floating over..I would really like to do that so thanks for posting the specs etc..I do not think it will be so easy as you say but..HELLYA
Posted by NewDude on April 22 2006,18:04
All are welcome, the more the better...You can post whatever you want... there is only one rule, don't use terrorist threats against the USA government.
I would rather not attract attention. But whatever else you want to chat about, that is fine.
I got the Berkley DB package installed last night, it took while to make. I tried installing PostFix and it still stays it can't find db.h file... it is there, it is part of the Berkley DB package.. I think the Berkley directory needs to be on the path.
So I have a question. How to you put something on the command path in Linux?
Again, all are welcome. If you aren't political wennie, there are other topic's like guns and backpacking etc... Have fun....
It is a good feeling to be hosting a full forum website on a P133MHZ laptop running DSL.
Posted by NewDude on April 24 2006,02:35
BIG PROBLEM... CAN YOU GUYS HELP>
Last night I started the Berkley DB package make install, it was going fine. I left it alone to finish. I tried getting to my forum to check it to see who or if anyone added anything. I got the Apache error saying file not found....
I couldn't get to my forum, website or anything...so I went and checked the server(Laptop).... Guess what? The /opt directory had been complete deleted.
Now, I wouldn't this it was the Berkley software that did it, I think it was probably hacked. Has this ever happened?I I am not sure what happened, all I know if I have to start all over. Is there something that I need to do to tighten up security? I am not 100% sure it was a hacker, but the whole /opt directory is gone. There is no /opt directory...
Is there anyway to get the opt directory back? I know it is still out there on the disk.... Does linux have a restore command?
The forum was running so well and I was talking so much smack to the Windoze users....
Maybe I need more experience with setting up security Linux before I run my website...
Any input will be great appreicated...
(BTW,,, if you try to hit my site right now, it is up, but running on my Win2k machine... it is the old website and forum.)
Posted by cbagger01 on April 24 2006,05:26
Does the Berkley DB software come packaged in a .tar.gz file and with a /opt directory inside the .tar.gz?If so, untarring it could have overwritten your /opt directory with a new one.
Posted by AwPhuch on April 24 2006,06:50
So did you do the persistant /opt directory on the hd?Hmmm...very very very wierd..I saw your site go down the other day too...is wierd....
I doubt you got hacked...but loosing the entire /opt dir is a bad thing
Brian
AwPhuch
Posted by NewDude on April 24 2006,13:56
cbagger01 said, "Does the Berkley DB software come packaged in a .tar.gz file and with a /opt directory inside the .tar.gz?If so, untarring it could have overwritten your /opt directory with a new one."
No, that didn't happen because I would still have an /opt directory...
There is no more /opt directory, it is totally gone.
AwPhunch, explain to my persistant please.... does that make it not able to delete? Or back it up or something?
Talk to me Brian, I need to know... I am will be repairing the system. In fact, I have a P166 Compaq desktop (Deskpor 2000) with 128mb and it is all SCSI, I am think of using it instead. But I will probably mess around with the compaq.
Good thing is, I documented everything, so this next time around it should be quicker to setup.
Posted by NewDude on April 24 2006,14:36
Anyways, I will get the DSL machine back up and working as the web server. In the mean time, here is the link to my Win2k server forum.
< http://www.planetxapps.com/new_forum/index.php >
Awphuch, you will have to register since this is a different MySQL DB....
Posted by AwPhuch on April 26 2006,00:49
Yes doing a "frugal" install you tell it to put /home and /opt on a directory completely separate from the OS dirSuch as
/dev/hda1 [55 MB] Frugal image
/dev/hda2 [whateverMB] SWAP
/dev/hda3 [the rest MB] the /opt /home dir
Then using the cheatcodes boot something like this
| Quote |
| dsl 2 root=/dev/hda1 frugal vga=normal atapicd noideraid nosound noapic noacpi acpi=off noscsi noapm nousb nopcmcia nofirewire noagp nomce home=/dev/hda3 opt=/dev/hda3 |
< http://damnsmalllinux.org/wiki/index.php/Cheat_codes >
Just do a search for frugal (thats one thing I notice that is lacking is a more in depth frugal explanation/HOWTO)
< http://damnsmalllinux.org/cgi-bin....+frugal >
< http://distro.ibiblio.org/pub....wto.pdf > <--BEST ONE YET!!!! DUH forgot that was there!
Brian
AwPhuch
Posted by NewDude on April 26 2006,14:09
Brian, Here is an update:
Because my wife is giving me problems with placing the laptop in our room, and I deleted the /opt directory (Like an idiot) and messed up my system. I decided to take my P166mhz, Compaq Deskpro 2000 and use it instead. Because it will take that PCI wireless card I have and see it, also Linux doesn't drop my wireless connection like windoze does, so running my web server over the wireless should work good and I can hide the PC anywhere in the house. Still would like to do the fixed cat-5 cable to the machine though, but for now, until summer is over, this will work.
Here is the link:< Planetxapps Forum >
I promiss from the bottom of my heart, I won't drink beer and mess with my computers half buzzed. That is what happened, there was no hacker, just a guy drinking beers, feeling good, and playing around and not paying attention. I was very mad at myself once I figured out what I did, and I apoligize to all hackers and Berkley DB people. Because I pointed the finger at them all first, when it was me.
The forum runs 50% faster on the actual desktop computer, rather than using the laptop. Probably because laptop running a little slower.
So again, I have a Compaq Deskpro 2000, P166mhz CPU, 128mb, 2.1 gb HD, 1 mb video running the forum now. Used XAMPP and PHPBB to get everything going. It took all of 2.5 hours last night to get it going, and that includes CFDISKing the system to kill the old DSL 2.2B OS that was on it, repartitioning and installing the new 2.3 DSL version, XAMPP and PHPBB.
Hats off again to Robert and John, v2.3 is awesome and I love Saturn....
Posted by NewDude on April 26 2006,14:15
Brian, thanks for the info...I did frugal installs in the past, and I happen to just like the full HD install.
Thanks again for the info and come join the forum again. The other guys enjoying you political stance.
Posted by AwPhuch on April 26 2006,22:43
P.S. Extract/backup your old phpbb database and import on this one so people wont loose all that they have postedotherwise..the attack cat will have atcha!
Brian
AwPhuch
Posted by NewDude on April 27 2006,01:29
I have tried and have run into lots of problems with sql errors.It seems phpbb doesn't create and good backup script.
When I tried importing it in, I run into several SQL Insert command errors. I got tired of messing with it.
Don't worry, I won't make the same mistake again...
The forum that is up is the forum that will always be....
Posted by charliez on April 28 2006,14:02
phpBB backup from their control panel only backs up the tables that are native to the phpBB distribution package.When you do customizations to your phpBB that add new tables you need to use alternate methods to get a fully restorable db backup.
There are mods you can use to capture additional tables you add.
There is phpMyAdmin for smaller db's but is mention phpMyAdmin fails after a certain size. My db is just under 50 MB's and I restore frequently with no posts loss. (fyi - I'm not running phpMyAdmin under DSL but am in debian)
Or there is the native mysql command line arguments that will give you a full insert dump.
Posted by NewDude on April 28 2006,17:12
I didn't customize my phpbb db at all. Never added more tables. I first tried the phpbb admin restore feature and couldn't restore it...got a lot of SQL errors..Then I tried the phpadmin, it failed to. I probably could have done it if I was so impatient... I was getting mainly insert errors...
I am very good with SQL. I work with Oracle for work at day long, so it wasn't that I don't know SQL. I just got tired of messing with it.
The DB was only 1.4mb compressed...I think the limit with phpadmin is 2mb...so I was underthe limit.
Posted by hs7sv on July 07 2006,07:07
I'm testing XAMPP-1.5.3a and PHP-Nuke on DSL-2.4. phpmyadmin works fine. I can create, export and import database.I'm using GRUB Frugal with option: opt=hda3.
Folder /tmp needs to be able to Read/Write for XAMPP. Then, I added the following into /opt/bootlocal.sh
| Code Sample |
| sudo chmod go+rw /tmp sudo /opt/lampp/lampp start |
Posted by newby on July 10 2006,16:45
| Quote (NewDude @ Mar. 30 2006,22:50) |
| I am starting to try to learn Mosix to. I have been reading and trying to learn it and I want to get Mosix running on my network as a test. Maybe this summer I can get 2 test boxes together and test Mosix and try to get it going with DSL. < MOSIX > |
Definately keep us updated on Mosix. Whether one wants to take part in SETI or has a cool distributed app they want to write, I'm sure there are a number of us who are interested.
BTW, it looks like Mosix will require some mods to the kernel. Fortunately, it's the same version.
Posted by NewDude on Oct. 16 2006,03:34
After doing research on Mosix...You can download a flavor of Linux that already has Mosix built into it. I think it is called Clusterix... Go to the Linux Distro, doing a search on google for linux distro and you will get the linux distro...
do a search on Clustering... Clusterix and another one comes up... they both over clustering built into them already with rebuilting the kernel...