webenvironment 0.4 (webserver,php,mysql,phpmyadmin)

Stuff that has yet to be sorted into a category.
Message
Author
User avatar
Owl
Posts: 64
Joined: Sat 24 Dec 2005, 15:35
Location: Kirchroa, the Netherlands

#61 Post 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.
________________________
Soooooooo happy with Puppy !

User avatar
MU
Posts: 13649
Joined: Wed 24 Aug 2005, 16:52
Location: Karlsruhe, Germany
Contact:

#62 Post 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

costal martignier
Posts: 198
Joined: Sat 28 Jan 2006, 15:55

#63 Post 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

costal martignier
Posts: 198
Joined: Sat 28 Jan 2006, 15:55

#64 Post 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

User avatar
MU
Posts: 13649
Joined: Wed 24 Aug 2005, 16:52
Location: Karlsruhe, Germany
Contact:

#65 Post 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

User avatar
MU
Posts: 13649
Joined: Wed 24 Aug 2005, 16:52
Location: Karlsruhe, Germany
Contact:

#66 Post 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!

User avatar
Owl
Posts: 64
Joined: Sat 24 Dec 2005, 15:35
Location: Kirchroa, the Netherlands

#67 Post 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.
________________________
Soooooooo happy with Puppy !

raffy
Posts: 4798
Joined: Wed 25 May 2005, 12:20
Location: Manila

More users for a frugal install

#68 Post 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:

costal martignier
Posts: 198
Joined: Sat 28 Jan 2006, 15:55

#69 Post by costal martignier »

@raffy,

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


regards
costal

User avatar
Owl
Posts: 64
Joined: Sat 24 Dec 2005, 15:35
Location: Kirchroa, the Netherlands

#70 Post 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.
________________________
Soooooooo happy with Puppy !

User avatar
Owl
Posts: 64
Joined: Sat 24 Dec 2005, 15:35
Location: Kirchroa, the Netherlands

#71 Post 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 ?
________________________
Soooooooo happy with Puppy !

User avatar
MU
Posts: 13649
Joined: Wed 24 Aug 2005, 16:52
Location: Karlsruhe, Germany
Contact:

#72 Post by MU »


costal martignier
Posts: 198
Joined: Sat 28 Jan 2006, 15:55

#73 Post 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

GuestToo
Puppy Master
Posts: 4083
Joined: Wed 04 May 2005, 18:11

#74 Post 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

User avatar
MU
Posts: 13649
Joined: Wed 24 Aug 2005, 16:52
Location: Karlsruhe, Germany
Contact:

#75 Post 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

costal martignier
Posts: 198
Joined: Sat 28 Jan 2006, 15:55

#76 Post 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

jwishnie
Posts: 2
Joined: Sun 23 Apr 2006, 19:24

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

#77 Post 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

raffy
Posts: 4798
Joined: Wed 25 May 2005, 12:20
Location: Manila

Help

#78 Post 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
Last edited by raffy on Tue 25 Apr 2006, 08:08, edited 1 time in total.

jwishnie
Posts: 2
Joined: Sun 23 Apr 2006, 19:24

oh man...

#79 Post 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...

costal martignier
Posts: 198
Joined: Sat 28 Jan 2006, 15:55

#80 Post 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

Post Reply