small webserver mysql/php/lighttpd (not yet) available

Stuff that has yet to be sorted into a category.
Message
Author
costal martignier
Posts: 198
Joined: Sat 28 Jan 2006, 15:55

small webserver mysql/php/lighttpd (not yet) available

#1 Post by costal martignier »

hello @all,

first sorry for my really bad bad english, i never had some english lessons in school ;)
second let me say that i love puppy (besides some little things *), it's really great, thanks to barry and every other involved in this sweet project!

i'm playing now some days with puppy, and and crated some live cd's to test, and installed it on a testlaptop :)
now i just created a full webserver environment, including mysql, php and lighttpd...
the totalsize installed on my harddisk is 16MB.

now i'm asking if someone is interssted in this, so i can create my first dotpup and host it on my server...
i never created a dotpup, so perhaps you must wait some days until it's finished...

if no one is interssted i dont't create one, because for me its ok to have it liyng around on the harddisk in a tar.gz
i've done this because i need a livecd/usb with webserver database and php for presenting my selfmade wiki when i am on tour :)

i'm using puppy with the quemu edition, so i can boot natevley in it or run it from every running linux oder winblows... really coooool..

ok, let me know if there is a need for this dotpup!

best regards an keep up the good work
costal

* the thins i don't like in puppy are:
- working as root
- the idea about the not yet existing pup_safe (!)
- the logo and the name of puppy linux
- there are two packagemanager bt not one real packagemanager
Last edited by costal martignier on Sat 28 Jan 2006, 22:58, edited 1 time in total.

costal martignier
Posts: 198
Joined: Sat 28 Jan 2006, 15:55

kan get it even smaller :)

#2 Post by costal martignier »

ok, i think i can get the size of all down to aprox. 10-11MB..

i just need to find out which mysql binarys are really needed..
there are plenty mysqlbins, and some of them are really big...

i allready striped all binarys...

keep you informed :)

User avatar
MU
Posts: 13649
Joined: Wed 24 Aug 2005, 16:52
Location: Karlsruhe, Germany
Contact:

#3 Post by MU »

that would be great, some people already asked for a small mysql-dotpup.
There already is Xampp, but it is quite huge.

Mark

costal martignier
Posts: 198
Joined: Sat 28 Jan 2006, 15:55

#4 Post by costal martignier »

ok, i try to create a dotpup...

on my local install i've installed everything in /opt

/opt/php
/opt/mysql
/opt/lighttpd

what do you think, is this ok, or should i put the files directly under /usr/ or /usr/local..

i prefer /usr/local, because it's the linux way of doing it :)

please help..

regards
costal

User avatar
Pizzasgood
Posts: 6183
Joined: Wed 04 May 2005, 20:28
Location: Knoxville, TN, USA

#5 Post by Pizzasgood »

It needs to be somewhere in /usr or /root, because Puppy doesn't save the /opt directory unless you have an option 2 harddrive install. Probably /usr/local would work best.
[size=75]Between depriving a man of one hour from his life and depriving him of his life there exists only a difference of degree. --Muad'Dib[/size]
[img]http://www.browserloadofcoolness.com/sig.png[/img]

User avatar
bombayrockers
Posts: 427
Joined: Sat 24 Sep 2005, 16:47
Location: Mumbai, India
Contact:

#6 Post by bombayrockers »

KDE usr_more.sfs uses /opt by editing the rc.local as follows

Some KDE files are stored in /root/.opt
At bootup it does the following
rm -f /opt
ln -s /root/.opt /opt

costal martignier
Posts: 198
Joined: Sat 28 Jan 2006, 15:55

wooowwww

#7 Post by costal martignier »

i would integrate pgpMyAdmin in the dotpup, but it's amazing how big this thing is..
after removing all documentation, themes and other crap, the size is ~4MB

this is really hard, because php mysql and the webserver take only ~13MB!!!

so, i don't think i can include phpMyAdmin, but i really like to include some frontend for managing databases..

someone knows a good and *small* replacement for phpMyAdmin?

hope to get some hints..

regards
costal

costal martignier
Posts: 198
Joined: Sat 28 Jan 2006, 15:55

#8 Post by costal martignier »

hmmm, someone change my posts subject?!?!?!?

the dotpup is not available like the subject is now mentioning...
i'm on the way to create it...

something other, i found two small mysql gui's, one can be found @ http://www.turboajax.com/turbodbadmin.html it's a ajax based webfrontend, really cool, but lacks many features...

the other one is gmysqlcc, a really small gtk frontend, but i'm having trouble to compile it on puppy -> http://gmysqlcc.thepozer.org/cgi-bin/tr ... EnFeatures

on my other computers it compile fine... i'l investigate in this...
someone has other ideas for a (small) mysql gui?

regards
costal

raffy
Posts: 4798
Joined: Wed 25 May 2005, 12:20
Location: Manila

phpmyadmin optional

#9 Post by raffy »

First, let me tell you that there is great interest here in what you're doing! Many teachers can benefit from a portable server on CD.

As to phpmyadmin, it is not that essential - a little readme on how to launch the mysql command line will be what's needed to "creata database", which is all that's needed to do in many situations. Of course the full-access user and password should also be in that readme :)

Database operations are usually done by the PHP scripts, and if somebody uses PHP and MySQL, very likely s/he also has access to a LAMP server that has a full PHPMyAdmin install. S/He can use that for constructing PHP code for manipulating his/her data.

Many applications in php can settle for PHP 4.3+ and MySQL 3.23+.

Cheers!

User avatar
Flash
Official Dog Handler
Posts: 13071
Joined: Wed 04 May 2005, 16:04
Location: Arizona USA

#10 Post by Flash »

How hard would it be to put your server OS on the same CD or DVD as the files it serves? If that can be done, and configured so that booting the CD or DVD is all that is required to make the files on the CD or DVD available, the server would not require a hard drive. If it didn't run from a CD or DVD burner, the files on the CD or DVD would be impossible for an attacker to infect or modify. Just reboot on a schedule and any malware that might have been put in the memory would be flushed.

Seems to me this could be an ideal way for a school to make things that rarely change, like grades and lesson plans, available online without worrying about security. Rebooting on a schedule would erase vandalism.

costal martignier
Posts: 198
Joined: Sat 28 Jan 2006, 15:55

#11 Post by costal martignier »

yes, i'm thinking in this direction...

i have plans to use the multisession feature from puppy to add webserver and database content to it..
so let's imaginate, you have puppy with my sebwerver ennvironment on it, how you can add and/or change the databases and the webcontent!

i'm planning a simple method.
you create two files:

www.tar.bz2
db.tar.bz2

the first file has the complete structure from the serverroot with all needed files in it, and the second one has the complete mysql database in it in form of a sqldump...

ok, now you put these files in the same directory then your pup100 file and start puppy. i will create a startroutine that extract the whole content of www.tar.bz2 into the webserver root, and then execute the sql and add it so to the mysqlserver...
when you need to change the content of the servers, you only need to change this two files, restart puppy and your done!

i'm integrating *gmysqlcc* as a frontend, it has only ~600KB and is really nice.. perhaps we can do some further packages, with "perl", "ruby" or "postgres" as optional packages..

i think this should be fairly easy, but it will extend the develtime of my project...

what do you think, i think it's really nice idea...

User avatar
MU
Posts: 13649
Joined: Wed 24 Aug 2005, 16:52
Location: Karlsruhe, Germany
Contact:

#12 Post by MU »


costal martignier
Posts: 198
Joined: Sat 28 Jan 2006, 15:55

#13 Post by costal martignier »

thx, i'm aware of them, but i think i must repackage them, because i need them to inetgrate correctly in the webenvironment..
let us take that as milestone 3 :)

MS 1:
have a working wenenvironment with php mysql and lighttpd (wich lacks nothing that apache has) and package this as a dotpup

MS 2:
db content and www content changeble like i mentioned in my previous post

MS 3:
additional packages for the webenvironment, like "perl", "ruby", "phpMyAdmin", "postgres", ..., ... (someone has ideas for more?)


regards
costal

User avatar
MU
Posts: 13649
Joined: Wed 24 Aug 2005, 16:52
Location: Karlsruhe, Germany
Contact:

#14 Post by MU »

sounds reasonable :)

User avatar
Flash
Official Dog Handler
Posts: 13071
Joined: Wed 04 May 2005, 16:04
Location: Arizona USA

#15 Post by Flash »

Does the server software you're proposing allow for access control, such as secure login to the server for instance? Also, would it allow a student to view only his or her grades?

costal martignier
Posts: 198
Joined: Sat 28 Jan 2006, 15:55

#16 Post by costal martignier »

i haven't compiled it with open ssl support, but yes it is capable..

lighttpd is a complete replacement of apache, has plenty of modules, like rewrite, proxy and so on...

please go look @ http://lighttpd.net

and its size is striped down olny ~500KB

regards
costal

costal martignier
Posts: 198
Joined: Sat 28 Jan 2006, 15:55

wooowwww

#17 Post by costal martignier »

just to tell you what is going on...

at the moment i have a ~4MB big usr_webenv.sfs, yes, 4MB :)
included the ful webserver, full mysql, full php, and a mysql gui/frontend..

i'm really happy with that..

there are some problems, i need to work arround them...
mysql is running as root, this is not a good idea.

the configuration is done at bootup with some lines in rc.local..

keep you informed about the process..

regards
costal

raffy
Posts: 4798
Joined: Wed 25 May 2005, 12:20
Location: Manila

User nobody

#18 Post by raffy »

That's really cool - a webserver environment for 4 MB!

Now, as you have mentioned user, does the htppd run as user "nobody" (this seems to be a general practice)?

costal martignier
Posts: 198
Joined: Sat 28 Jan 2006, 15:55

#19 Post by costal martignier »

at the moment everything is running as root :(

im looking forward to find a good solution....

costal martignier
Posts: 198
Joined: Sat 28 Jan 2006, 15:55

#20 Post by costal martignier »

ok, now you can't say i'm only talking about creating this stuff :)
take a look at the picture, it shows firefox (on crustpuppy) with the default site on localhost..
in the terminal you see the size of the whole webenvironment :)

8)

Image

Post Reply