small webserver mysql/php/lighttpd (not yet) available
-
- Posts: 198
- Joined: Sat 28 Jan 2006, 15:55
small webserver mysql/php/lighttpd (not yet) available
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
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.
-
- Posts: 198
- Joined: Sat 28 Jan 2006, 15:55
kan get it even smaller :)
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
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
-
- Posts: 198
- Joined: Sat 28 Jan 2006, 15:55
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
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
- Pizzasgood
- Posts: 6183
- Joined: Wed 04 May 2005, 20:28
- Location: Knoxville, TN, USA
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]
[img]http://www.browserloadofcoolness.com/sig.png[/img]
- bombayrockers
- Posts: 427
- Joined: Sat 24 Sep 2005, 16:47
- Location: Mumbai, India
- Contact:
-
- Posts: 198
- Joined: Sat 28 Jan 2006, 15:55
wooowwww
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
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
-
- Posts: 198
- Joined: Sat 28 Jan 2006, 15:55
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
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
phpmyadmin optional
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!
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!
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.
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.
-
- Posts: 198
- Joined: Sat 28 Jan 2006, 15:55
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...
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...
-
- Posts: 198
- Joined: Sat 28 Jan 2006, 15:55
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
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
-
- Posts: 198
- Joined: Sat 28 Jan 2006, 15:55
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
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
-
- Posts: 198
- Joined: Sat 28 Jan 2006, 15:55
wooowwww
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
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
User nobody
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)?
Now, as you have mentioned user, does the htppd run as user "nobody" (this seems to be a general practice)?
-
- Posts: 198
- Joined: Sat 28 Jan 2006, 15:55
-
- Posts: 198
- Joined: Sat 28 Jan 2006, 15:55