Puppy Linux Discussion Forum

costal martignier · Joined: 28 Jan 2006 Posts: 197

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

costal martignier · Joined: 28 Jan 2006 Posts: 197

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

MU · Posted: 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

costal martignier · Joined: 28 Jan 2006 Posts: 197

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

Pizzasgood · Posted: 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.

bombayrockers · Joined: 24 Sep 2005 Posts: 421 Location: Mumbai, India

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 · Joined: 28 Jan 2006 Posts: 197

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 · Joined: 28 Jan 2006 Posts: 197

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

raffy · Joined: 25 May 2005 Posts: 4636 Location: Manila

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!

Flash · Posted: 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.

costal martignier · Joined: 28 Jan 2006 Posts: 197

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

MU · Posted: 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

costal martignier · Joined: 28 Jan 2006 Posts: 197

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

MU · Posted: Sun 29 Jan 2006, 05:07 Post subject:

sounds reasonable Smile

Flash · Posted: 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?