Sorry I've been caught up with other projects lately and I just flashed my development tablet into Diablo oblivion so I've got to re-install the dev tools on it (hopefully in the next few days?).

What exactly is required to compile PHP with sqlLite3 instead of sqlLite2? I don't remember seeing any compile directives for that, but I could be wrong...

Thanks,
-Rob

Anyone had any luck with getting lighthttpd to run as the user nobody insted of root like it does out the box.

Since I have been useing the N800 for a webserver now an then I would much rather not have it running as root, when I tel it to run as nobody I get a error an then it closes down.

@jolouis:

Thanks a lot for the package! It saved my life

Ok, i just come in this thread.

I tested php5 + nginx + sqlite in native Maemo environment, but that wasn' sufficient for me.

I think php5-cgi package with mysql support would be very nice...
But i really needed a lamp server running on my N810, as a webdev.

As an alternative, i installed :
- easy debian turbo-charged edition
- in the chroot environment, i installed package "phpmyadmin"
#apt-get install phpmyadmin
which installed all needed stuff : apache2+php5+mysql.

So i run the servers after chrooting each time i restart (twice a month) my tablet :
- /etc/init.d/apache2 start
- /etc/init.d/mysql start

And, when i'm back in microb, browing http://127.0.0.1/phpmyadmin/ this works !!!
could install typo3 for example.

I know it's quite "huge" but i don't have big slowness.
Having a such environment (php5 mysql support) would be nice, even with lighttpd or nginx, but i couldn't find how to cross-compile php5 on Maemo OS2008...

@benohit: Interesting, I'll have to reinstall qole's debian turbo and try this out.
Do you have the chroot terminal window open for the servers to be functional, or can the windows be closed down after restarting the server daemons?

@EIPI : keeping terminal open isn't necessary ! daemons are running, because it's daemon, you can close chrooted terminal
moreover, i installed "bluefish" in order to edit web html & php & css pages,...

i made a script in debian :
#nano /usr/local/sbin/lamp_start.sh :
_______________
#!/bin/bash
/etc/init.d/apache2 start
/etc/init.d/mysql start
_______________
then
#chmod u+x /usr/local/sbin/lamp_start.sh

back in Maemo,
you can put in /etc/init.d/rcS or something like this, before exit 0 at the very end of the file :
________________
...

sudo debian lamp_start.sh

exit 0
________________

benohit,

Do I need to install a repository?

Here is what I get:

[root@Debian: /]apt-get install phpmyadmin
Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Couldn't find package phpmyadmin

@bizshop :

as i said earlier in this thread, you have to follow these steps :

1 / Install easy debian turbo-charged edition
2 / Install phpmyadmin in a chrooted debian terminal

Have you done an "apt-get update" first? That's probably your problem.

Thanks to both qole and benohit, got phpmyadmin installed, but I have no mysql in the /etc/init.d/ directory. Trying to search all directories to see if mysql got installed or not, but no success yet. Tried ap-get install mysql-server and got out of space on device error