Puppy Linux Discussion Forum Forum Index Puppy Linux Discussion Forum
Puppy HOME page : puppylinux.com
"THE" alternative forum : puppylinux.info
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

The time now is Mon 24 Nov 2014, 03:09
All times are UTC - 4
 Forum index » Advanced Topics » Additional Software (PETs, n' stuff) » Unsorted
small webserver mysql/php/lighttpd (not yet) available
Moderators: deshlab, Flash, GuestToo, Ian, JohnMurga, Lobster
Post new topic   Reply to topic View previous topic :: View next topic
Page 1 of 3 [35 Posts]   Goto page: 1, 2, 3 Next
Author Message
costal martignier

Joined: 28 Jan 2006
Posts: 197

PostPosted: Sat 28 Jan 2006, 12:08    Post subject:  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 Wink
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 Smile
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 Smile

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, 18:58; edited 1 time in total
Back to top
View user's profile Send private message 
costal martignier

Joined: 28 Jan 2006
Posts: 197

PostPosted: Sat 28 Jan 2006, 13:08    Post subject: 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 Smile
Back to top
View user's profile Send private message 
MU


Joined: 24 Aug 2005
Posts: 13644
Location: Karlsruhe, Germany

PostPosted: Sat 28 Jan 2006, 13:37    Post subject:  

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

Mark
Back to top
View user's profile Send private message Visit poster's website 
costal martignier

Joined: 28 Jan 2006
Posts: 197

PostPosted: Sat 28 Jan 2006, 14:10    Post subject:  

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 Smile

please help..

regards
costal
Back to top
View user's profile Send private message 
Pizzasgood


Joined: 04 May 2005
Posts: 6270
Location: Knoxville, TN, USA

PostPosted: Sat 28 Jan 2006, 14:24    Post subject:  

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.
_________________
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

Back to top
View user's profile Send private message Visit poster's website 
bombayrockers


Joined: 24 Sep 2005
Posts: 427
Location: Mumbai, India

PostPosted: Sat 28 Jan 2006, 14:40    Post subject:  

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
Back to top
View user's profile Send private message Yahoo Messenger 
costal martignier

Joined: 28 Jan 2006
Posts: 197

PostPosted: Sat 28 Jan 2006, 15:25    Post subject: 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
Back to top
View user's profile Send private message 
costal martignier

Joined: 28 Jan 2006
Posts: 197

PostPosted: Sat 28 Jan 2006, 18:56    Post subject:  

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/trac.cgi/wiki/EnFeatures

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

regards
costal
Back to top
View user's profile Send private message 
raffy

Joined: 25 May 2005
Posts: 4796
Location: Manila

PostPosted: Sat 28 Jan 2006, 20:26    Post subject: 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 Smile

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!
Back to top
View user's profile Send private message 
Flash
Official Dog Handler


Joined: 04 May 2005
Posts: 11157
Location: Arizona USA

PostPosted: Sun 29 Jan 2006, 00:30    Post subject:  

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.
Back to top
View user's profile Send private message 
costal martignier

Joined: 28 Jan 2006
Posts: 197

PostPosted: Sun 29 Jan 2006, 04:47    Post subject:  

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...
Back to top
View user's profile Send private message 
MU


Joined: 24 Aug 2005
Posts: 13644
Location: Karlsruhe, Germany

PostPosted: Sun 29 Jan 2006, 04:54    Post subject:  

Perl:
http://www.murga.org/~puppy/viewtopic.php?t=4193

Ruby:
http://www.murga.org/~puppy/viewtopic.php?t=4338
Mark
Back to top
View user's profile Send private message Visit poster's website 
costal martignier

Joined: 28 Jan 2006
Posts: 197

PostPosted: Sun 29 Jan 2006, 05:01    Post subject:  

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 Smile

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
Back to top
View user's profile Send private message 
MU


Joined: 24 Aug 2005
Posts: 13644
Location: Karlsruhe, Germany

PostPosted: Sun 29 Jan 2006, 05:07    Post subject:  

sounds reasonable Smile
Back to top
View user's profile Send private message Visit poster's website 
Flash
Official Dog Handler


Joined: 04 May 2005
Posts: 11157
Location: Arizona USA

PostPosted: Sun 29 Jan 2006, 12:29    Post subject:  

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?
Back to top
View user's profile Send private message 
Display posts from previous:   Sort by:   
Page 1 of 3 [35 Posts]   Goto page: 1, 2, 3 Next
Post new topic   Reply to topic View previous topic :: View next topic
 Forum index » Advanced Topics » Additional Software (PETs, n' stuff) » Unsorted
Jump to:  

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum


Powered by phpBB © 2001, 2005 phpBB Group
[ Time: 0.0789s ][ Queries: 11 (0.0047s) ][ GZIP on ]