Page 4 of 5

Posted: Tue 21 Feb 2006, 20:17
by Owl
Hi,

uninstall went fine, install went fine, then the error message that I earlier posted didn't come up again, so far so good.

However, I rebooted and again mysql made the computer hang.
And the ps doesn't show mysql,
and the install utility mentions again it cannot find mysql server.

So I am kind of stuck here,
regards,
Owl.

Posted: Tue 21 Feb 2006, 20:20
by MU
clicked on webenv0.5,and "uninstall".
This told me it might take some second,and another message.
After 1 minute nothing else came.
So I started it again,and chose "install".

After installation reboot,because all applications freeze.
Still no /usr/local/libexec/mysqld

So I copy it over from /.webenv/local/libexec and reboot.
Voila- mysql runs.
I think a symlink should be sufficient to save space:
ln -s /.webenv/local/libexec/mysqld /usr/local/libexec/mysqld

But not tested - go to bed now.

Will look closer tomorrow :-).

Mark

Posted: Tue 21 Feb 2006, 20:23
by costal martignier
the uninstall should work, if not you must remove all files manually, i create a list tommorow...

the freezing is caused because of the unionfs...
i dont get it why this is so...

perhaps i give up my webenv project...
to heavy for my small knowledge...

but lets see tomorrow...

cu

Posted: Tue 21 Feb 2006, 20:25
by costal martignier
it's really strange that i can't reproduce your erros..

'm using a fresh puppy live cd and a fresh puppy install (both 1.0.7)

everything is fine....

so perhaps weben will never reach productive state, because of my lacking knwoledge about unionfs problems

costal

Posted: Tue 21 Feb 2006, 20:28
by MU
No, don't give up :)
As I said, 0.4 worked ok for me (PHP).
And mysql can be solved with a simple symlink on my KDE-Puppy.

So that is ok, isn't it?
To fix this would be "a nice to have", but already now you can use it.
Much better than installing 80 MB of Xampp...

Good night, Mark

Posted: Tue 21 Feb 2006, 20:32
by MU
It might be a bug in unionfs, that the applications freeze after installation of Webenv. But after reboot, it is ok.
KDE-Puppy often does not unmount /loop1 at reboot,so there seems to be something not correct with KDE-Puppy.
Keep in mind,that KDE-Puppy is a non-optimized Alphaversion.

If Puppy107 works correct, it is just great!

Posted: Tue 21 Feb 2006, 21:03
by Owl
Hi,

I can also claim success (at least partially) after following MU's advice:
the ln -s option didn't work, but manually copying the file to the designated folder does.

my ps output now:
ps
PID Uid VmSize Stat Command
1 root 560 S init
2 root SW [keventd]
3 root SWN [ksoftirqd_CPU0]
4 root SW [kswapd]
5 root SW [bdflush]
6 root SW [kupdated]
7 root SW< [mdrecoveryd]
133 root SW [khubd]
173 root 572 S syslogd -m 0
180 root 568 S klogd
329 root SW [loop1]
414 root SW [loop0]
427 root SW [loop3]
435 root SW [loop4]
1014 root 1772 S /usr/sbin/cupsd
1053 root SW [loop7]
1081 root 608 S /bin/sh /usr/local/bin/mysqld_safe --user=root
1104 root 668 S /bin/sh /usr/X11R6/bin/xwin
1105 root 452 S /sbin/getty 38400 tty2
1118 root 1072 S /usr/local/bin/lighttpd -f /etc/lighttpd.conf
1119 root 2060 S /usr/local/bin/php
1163 root 2060 S /usr/local/bin/php
1170 root 2060 S /usr/local/bin/php
1180 root 2060 S /usr/local/bin/php
1190 root 4500 S /usr/local/libexec/mysqld --basedir=/usr/local --data
1239 root 4300 S /usr/local/bin/php
1240 root 2064 S /usr/local/bin/php
1241 root 2064 S /usr/local/bin/php
1244 root 2064 S /usr/local/bin/php
1267 root 620 S /usr/X11R6/bin/xinit /root/.xinitrc --
1268 root 9116 S < X :0
1270 root 4500 S /usr/local/libexec/mysqld --basedir=/usr/local --data
1271 root 4500 S /usr/local/libexec/mysqld --basedir=/usr/local --data
1274 root 4432 S icewm
1289 root 1420 S /usr/bin/autocutsel
1336 root 4592 S /usr/local/apps/ROX-Filer/Linux-ix86/ROX-Filer -o -p
1347 root 1264 S rxvt -sl 999
1348 root 1636 S bash
1406 root 728 R ps


As far as I know process 1081 means mysql is up and running !

Now I have to figure out why the configuration file doesn't connect to mysql yet -- but that appears to be something for tomorrow.

DON'T STOP with this marvellous project ! My puppy is becoming a wet dream -- OOo2, R, LLMP server, WOW.

More tomorrow,
Regards and thanks much for all the effort you put in it !!!

Owl.

More users for a frugal install

Posted: Tue 21 Feb 2006, 23:22
by raffy
Hey, Costal, if ever someone will really deploy webenv, most likely the client tools like OO2 and KDE will not be needed (by the server PC), so why worry, really? :)

About unionfs, am reminded by the Xampp technique of putting all files in one folder. Will this produce a very large folder? If not, then perhaps we can avoid the unionfs problem by using uncompressed files? :oops:

Posted: Wed 22 Feb 2006, 07:00
by costal martignier
@raffy,

i also thinked aubout this yesterday, and i think i will go this way...


regards
costal

Posted: Wed 22 Feb 2006, 09:40
by Owl
Hi,

just to let you know that I can now also contact mysql server, everything is up and running now.

(just installed PhPWebsite, seems to run OK now).

Thanks much,
Owl.

Posted: Fri 24 Feb 2006, 19:23
by Owl
Hi Costal,

2 questions;

1. regarding the plans with empty crust and webserver: would it be a disadvantage to have puppy running as root ?

2. I have my server up and running now, I have a php and mysql enabled site, but now I am wondering what it takes to have it publicly accessible. I have read through 2 Linux webservers books, and did some googling but this is a bit more difficult to understand for me.

THanks much,
Owl.

PS: would you like it if I help you with a bit of polishing up on your webserver startpage (version number, English etc) as a return of all the work you put in this project ?

Posted: Fri 24 Feb 2006, 19:38
by MU

Posted: Fri 24 Feb 2006, 19:55
by costal martignier
Owl wrote: 1. regarding the plans with empty crust and webserver: would it be a disadvantage to have puppy running as root ?
no no noooooooooo, running a webserver as root is a no go...
you can see a few post before this what i did with mu's little website? this was not real hacking, this was jost guessing the simplest method to "hack" a server.. php is not really secure, no webserver is really secure, no (most) coder is coding secure, there are tons of points where an attacker or just a tired scriptkiddy can attack your little webserver/website....

if the attacker finds a hole, he has root access, because all application running as root in puppy... imagine a

Code: Select all

rm -rf /
from an attacker on your website...

see the messages from the last days, about a linux virus? not really a virus (or it is!?!?!?) but something simmilar that uses bugs in well known phpwebapplications...

so, never make your puppy with a webserver available to the internet.

IMHO
Owl wrote:2. I have my server up and running now, I have a php and mysql enabled site, but now I am wondering what it takes to have it publicly accessible. I have read through 2 Linux webservers books, and did some googling but this is a bit more difficult to understand for me.
same answer to this as to the first question...

Owl wrote: PS: would you like it if I help you with a bit of polishing up on your webserver startpage (version number, English etc) as a return of all the work you put in this project ?
please go ahead, you can do with it what you want...

regards

Posted: Sat 25 Feb 2006, 02:58
by GuestToo
would it be a disadvantage to have puppy running as root ?
Xampp requires that it starts running as root ... the Apache web server automatically runs as user "nobody", not root ... if anyone gets in through Apache, he should have the privileges of user "nobody", and should not be able to su to root ... try typing su nobody then type su root

costal's web server may work the same way

Posted: Sat 25 Feb 2006, 03:49
by MU
edit /etc/lighttpd.conf

Code: Select all

## change uid to <uid> (default: don't care)
#server.username            = "wwwrun"
server.username            = "spot"

## change uid to <uid> (default: don't care)
#server.groupname           = "wwwrun"
server.groupname           = "spot"
then run
# killall lighttpd
# lighttpd -f /etc/lighttpd.conf &

This will give some errors, forexample that PHP cannot be executed, so
chmod 755 /usr/local/bin/php

And set the needed rights to /root/www
Mark

Posted: Sat 25 Feb 2006, 09:36
by costal martignier
MU wrote:edit /etc/lighttpd.conf

Code: Select all

## change uid to <uid> (default: don't care)
#server.username            = "wwwrun"
server.username            = "spot"

## change uid to <uid> (default: don't care)
#server.groupname           = "wwwrun"
server.groupname           = "spot"
ohh cool, i implement this in the next (and last) version of webenv...

regards
costal

Two requests: MySQL 'old passwords', php w/iconv

Posted: Sun 23 Apr 2006, 19:31
by jwishnie
First off, thank you for this great .pup.

I am using it to run Ampache (http://www.ampache.org) on PuppyLinux.

Two requests for version 0.5:

1. Upgrade MySql client:
The PHP included exhibits the 'old password' problem where the linked mysqlclient library expects pre-Mysql 4.1 style passwords. But the MySql included uses new passwords by default.

This means, among other things, that phpmyadmin fails if you set a password on the MySql admin ('root') user.

Details here:
http://www.openwin.org/mike/index.php/f ... requested/

2. Compile PHP with iconv support
The included PHP does not have the iconv extension needed for proper handling of unicode and charset translation. This would be very handy!

Thanks!

- Jeff

Help

Posted: Sun 23 Apr 2006, 23:56
by raffy
Hi, J,

Welcome to Puppy! You seem to know how to handle this. Costal has been silent since, and we will appreciate your reactivating this very interesting package. :)

Cheers!

Edit: Here is the Puppy compiling environment: http://puppylinux.org/wikka/Compiling

oh man...

Posted: Tue 25 Apr 2006, 07:36
by jwishnie
there I go opening my mouth :-)

As soon as I get a Vector/Slackware build env set-up I'll look at this...

Posted: Tue 25 Apr 2006, 15:57
by costal martignier
sorry,

but i don't have any interests in this package, because i don't have anymore interests to puppy...

have fun...
costal