LAMP - new version server package with Hiawatha

[growler]

I have put together a new LAMP pet with
mysql 5.1.31
php 5.2.8
hiawatha 6.11
phpMyAdmin 3.1.3.1

See
http://www.puppylinux.org/wiki/software ... h-hiawatha

This is tested with puppy 4.2 RC4 - I have not tested with 4.1.2 where the existing bundled hiawatha should be upgraded to 6.11

Let me know if you encounter any issues .. easy ones only please

This pet is 13 Meg so quite a bit smaller than the eighty odd meg of XAMP

[vtrli]

Hi Growler,

Could you help I'm new to puppylinux. I'm using puppy live CD 4.2 with usb drive and 256MB memory. pupsave and pup_40.sfs working fine on usb drive.

Just installed LAMP-6.11-5.1.31-5.2.8.pet on 4.2 and have hiawatha working but not for mysql. 404 not found for http://localhost/phpMyAdmin/index.php

Tried restart mysql and get the following error:
/etc/init.d/rc.mysqld start
09040 11:11:23 mysqld_safe Logging to '/usr/local/var/puppypc.err'.
expr: syntax error
09040 11:11:24 mysqld_safe Starting mysqld daemon with databases from /usr/local/var

Here are related logs inside puppypc.err:
090402 11:25:38 mysqld_safe Starting mysqld daemon with databases from /usr/local/var
090402 11:25:38 [Note] Event Scheduler: Loaded 0 events
090402 11:25:38 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.1.31' socket: '/tmp/mysql.sock' port: 3306 Source distribution


Thanks!

[growler]

Have you tried to run the mysql client from the command line?

open rxvt and enter

#mysql -uroot -pwoofwoof

you can then enter SQL at the mysql prompt such as

>SHOW DATABASES;

and the databases should list...

Is mysqld not showing up in the process list?

Is the mysql.sock showing when you open rox at /tmp ?

[vtrli]

Thanks a lot for your prompt reply Growler,

I have tried using the mysql client and got welcomed and connected.

"Is mysqld not showing up in the process list?"=> I founded the following 2 processes:
/bin/sh/usr/local/bin/mysqld_safe --user=nobody --pi
/usr/local/libexec/mysqld --basedir=/usr/local --data

"Is the mysql.sock showing when you open rox at /tmp ?" => Yes

I still got "404 - Not found" for http://localhost/phpadmin

[growler]

I still got "404 - Not found" for http://localhost/phpadmin

Try

Code: Select all

http://localhost/phpMyAdmin/index.php

[vtrli]

http://localhost/phpMyAdmin/index.php => "500 - Internal Server Error"
http://localhost/phpMyAdmin/ => 404 - Not Found
http://localhost/ => Hiawatha greetings and working

[growler]

I made an error on the wiki page in that the link to the new LAMP-6.11-5.1.31-5.2.8.pet was actually to the old mysql.... pet

Make sure you got the LAMP-6.11-5.1.31-5.2.8.pet file.

Can you tell me what puppy version you are running, is it a full HD install or a frugal/USB/CD/DVD and which .pet you have loaded?

[vtrli]

No problem I installed LAMP-6.11-5.1.31-5.2.8.pet cause i found out the wrong link already.

4.2 using liveCD with large USB drive for pup_save.2fs and pup_420.sfs. Most apps are running fine. Running on 256MB RAM and PIII 800M CPU.

Thanks for investigating.

[growler]

Can you check that the Fast CGI php-cgi daemons are running by entering
ps -ef|grep php - the output should be as below:

Code: Select all

# ps -ef |grep php
nobody    4384     1  0 10:00 ?        00:00:00 /usr/local/bin/php-cgi -b 127.0.0.1:2005 -c /etc/php.ini
nobody    4519  4384  0 10:00 ?        00:00:00 /usr/local/bin/php-cgi -b 127.0.0.1:2005 -c /etc/php.ini
nobody    4521  4384  0 10:00 ?        00:00:00 /usr/local/bin/php-cgi -b 127.0.0.1:2005 -c /etc/php.ini
nobody    4523  4384  0 10:00 ?        00:00:00 /usr/local/bin/php-cgi -b 127.0.0.1:2005 -c /etc/php.ini

If it's not then php is not running... try the following:

#/etc/init.d/rc.httpd stop

then check /var/run directory in rox file manager and see if there is a stray php-fcgi.pid This can occur if you get a untimely power failure. If so delete it manually and then restart the hiawatha/php daemons with

#/etc/init.d/rc.httpd start

and then retry

#ps -ef|grep php

[vtrli]

Growler,

You've got it!

It's working now after I restart hiawatha. However, everytime I reboot the system (normal shutdown+start puppy), I still got the same problem (500 internal server err for phpadmin/index.php). I need to manually restart hiawatha to make it work.

Anyway thanks a lot!

[growler]

vtrli said:

However, everytime I reboot the system (normal shutdown+start puppy), I still got the same problem (500 internal server err for phpadmin/index.php). I need to manually restart hiawatha to make it work.

I am keen to improve the pet so other's don't have the same issues...
Could you let me know:
1. Do you have to run #/etc/init.d/rc.httpd stop then #/etc/init.d/rc.httpd start each time?
2. Did you find the file /var/run/php-fcgi.pid when hiawatha was not running and have to delete it?
3. Are you shutting down puppy by clicking menu->shutdown then clicking the shutdown or reboot button?

Appreciate the feedback.

One thing you could try is to add the line

Code: Select all

rm -f /var/run/php-fcgi.pid

in the stop section of /etc/init.d/rc.httpd

Thanks for your help with this - of course it works beautifully for me. It might also be due to you using a live CD with a USB pup_save.sfs too - perhaps /etc/init.d/rc.httpd start is not run on boot under your setup as it is on a normal frugal or full install - I'm feeling brave, I will delve into the boot scripts! If that was the case then all you'd need to do is run

#/etc/init.d/rc.httpd start

each time you boot up

[pacchiee]

Growler,

I was using your LAMP pet with apache php mysql and phpmyadmin (lamp-400.sfs) with no issues till version 4.1.2. But, it doesn't work with 4.2. I don't want hiawatha, can you tell me how I can run lamp-400.sfs on puppy 4.2?

[growler]

This sfs was made from slackware binaries - for puppy 3 series. I hadn't expected it would work with 4 series at all.

In my view hiawatha has everything apache does but works faster is more secure and uses less resources ... why would you want to use apache in preference to hiawatha?

The latest .pet works well with 4.2

ftp://puppy:puppylinux@ftp.servage.net/ ... -5.2.8.pet

[12mma10]

this link is brocken....

ftp://puppy:puppylinux@ftp.servage.net/ ... -5.2.8.pet[/quote]

does someone know an alternativ link?

thanks
martin

[growler]

Oh dear - Raffy said I could use this space - it would be great to have a central repository for pets but hey. I will pm raffy and see if he minds me reuploading it

Grrrr

[MU]

It is an open ftp space once offered by a german puppy user (germanpup).
Obviously, someone mis-used the open service, deleted everything, and uploaded some pirated files.

You may upload here:
http://murga-linux.com/puppy/viewtopic. ... 9398#99398
Then send me a PM, I then will move the file to the write protected www folders and send you a downloadlink.

Or contact caneri, he also offers free space. As you like.

Please also inform Raffy, maybe he wants to restore files on the compromized server.

Mark

[raffy]

Let us wait for growler's announcement. Meantime, we are acting on it:
http://murga-linux.com/puppy/viewtopic.php?t=41846

[MU]

http://dotpups.de/puppy4/dotpups/Intern ... -5.2.8.pet

Mark

[tlchost]

In my view hiawatha has everything apache does but works faster is more secure and uses less resources ... why would you want to use apache in preference to hiawatha?

I have a web hosting busines...the server runs Centos with Apache...so being able to have Apache, PHP and MySqL on puppy is a real advantage.

Would it be possible for you to produce an sfs file that has the above plus CGI ?

Thanks in advance

Thom

[growler]

Don't really follow Thom - you run a web-hosting business with centos as the server OS... why do you want a puppy server then?

I am not keen to roll an apache server - the advantages of hiawatha are a winner for me and I would have thought most folks. My server runs PHP as a fast CGI - running PHP as a CGI results in much worse performance since PHP has to be started each time a PHP parsing job is requested. As a Fast CGI daemon there are a bunch of PHPs already running.

There is an xampp .sfs that MU has made somewhere that contains apache, amongst a whole lot of other stuff.