[Howto] Mk4 Lamp Stack (Usb Required)

[DJJeff]

INSTALL THESE

opkg install apache --dest usb
opkg install php5-cgi php5-cli php5-mod-mysql --dest usb
opkg install mysql-server --dest usb[/CODE]

[b]HOW TO SYMLINK[/b]

root@Pineapple:/# [b]ln -s /usb/usr/bin/mysqld /usr/bin/mysqld[/b]

root@Pineapple:/# [b]ln -s /usb/usr/share/mysql/ /usr/share/mysql[/b]

root@Pineapple:/# [b]ln -s /usb/etc/my.cnf /etc/my.cnf[/b]

root@Pineapple:/# [b]ln -s /usb/etc/init.d/mysqld /etc/init.d/mysqld[/b]

root@Pineapple:/# [b]ln -s /usb/usr/bin/my_print_defaults /usr/bin/my_print_defaults[/b]

root@Pineapple:/# [b]ln -s /usb/etc/php5/ /etc/php5[/b]

root@Pineapple:/# [b]ln -s /usb/usr/lib/php/ /usr/lib/php[/b]

root@Pineapple:/# [b]ln -s /usb/etc/apache/ /etc/apache[/b]

root@Pineapple:/# [b]ln -s /usb/usr/sbin/httpd /usr/sbin/httpd[/b]

[b]CREATE THESE[/b]

root@Pineapple:/# [b]mkdir /usb/data[/b]

root@Pineapple:/# [b]mkdir /usb/data/mysql[/b]

[b]TIME TO EDIT[/b]

CTRL+X to Save & Press Y for Yes & Press Enter To Save

root@Pineapple:/# [b]nano /etc/apache/httpd.conf[/b]

[b]Listen 80[/b] to [b]Listen 0.0.0.0:[some other port][/b]

ErrorDocument 404 /error.php

root@Pineapple:/# [b]nano /etc/my.cnf[/b]

datadir = /usb/data/mysql

tmpdir = /tmp

root@Pineapple:/# [b]mysql_install_db --force[/b]

Installing MySQL system tables...

OK

Filling help tables...

OK

[b]START THE SERVICES[/b]

root@Pineapple:/# [b]mysqld[/b]

to put in the background run

root@Pineapple:/# [b]mysqld &[/b]

root@Pineapple:/# [b]mysqladmin -u root password 'new-password'[/b]

root@Pineapple:/# [b]apachectl start[/b]

[b]ERRORS / FAQ[/b]

[b]httpd: apr_sockaddr_info_get() failed for Pineapple[/b]

Check /etc/apache/httpd.conf

Listen 0.0.0.0:PORT

[b]httpd: Could not reliably determine the server's fully qualified domain name, using 127.0.0.1 for ServerName[/b]

Check /etc/apache/httpd.conf

Uncomment ServerName and set to something else

[b]Where Are My Logs!!!!!![/b]

/var/log has been linked to /tmp/log check in here :)

[b]How do I check to see if its running[/b]

[CODE]root@Pineapple:/# netstat -npltuw
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN [ PID ]/mysqld
tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN [ PID ]/uhttpd
tcp 1 0 0.0.0.0:[ PORT ] 0.0.0.0:* LISTEN [ PID ]/httpd
tcp 0 0 0.0.0.0:1471 0.0.0.0:* LISTEN [ PID ]/uhttpd[/CODE]

Edited September 20, 2012 by DJJeff

[loozr]

Nice guide! B)

But could you please explain to me why I should do this? Why would I need a LAMP server when the pineapples builtin alternative doe's the work for me?

[DJJeff]

its optional todo this, I find I have more features with this setup the pineapple uses PHP4 this allows for PHP5

also you can have some mysql to php interactions with this setup