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 Thu 02 Oct 2014, 11:08
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 Posts_count   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

Edited_time_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: 13642
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_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_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 YIM 
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: 4765
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: 11083
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: 13642
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_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: 13642
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_website 
Flash
Official Dog Handler


Joined: 04 May 2005
Posts: 11083
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:   Sort by:   
Page 1 of 3 Posts_count   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:  

Rules_post_cannot
Rules_reply_cannot
Rules_edit_cannot
Rules_delete_cannot
Rules_vote_cannot
You cannot attach files in this forum
You can download files in this forum


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