Hudsonvalley

php include directory

can't seem to be set in php.ini. So put a link in /usr/share/php/ to /usr/local/share/php5/chromephp/ChromePhp.php which you include in php files to see in console whatever you put in ChromePhp::log('hello world'); BTW tutn php consol logging on in top right of browser (blue is on)

php error reporting to browser

/etc/php5/apache2/php.ini links to development version that logs errors to browser.

allowing www-data user to write to directory

usermod -a -G group1,group2 username

Where username is the user you want to modify and group1 and group2 are the new groups you want that user to join. Running the command without the -a argument will remove that user from all groups except group1 and group2.

groups sitebuil
members cando
chgrp -Rv cando /home/pathbost/public_html/ystill

locate

but first updatedb

cron and backups

backup to S3 code

cron tutorial another

Re: Where is crontab stored?

Root-level crontab should be in /etc/crontab.

Root-level anacron and periodics should be in /etc/cron*

User-level crontabs should be in /var/spool/cron/crontabs - they are listed by user, pathbost isactually a chrontab

select-editor

even after you change it by yourself you still have to run crontab -e to install it

vi with crontab 101

• su to user then 'crontab -e'
• 'i' to insert text
• 'esc :wq to save change, and quit
  • then crontab is installed
• 'esc :q!' exits without saving (or installing)
• you can kill your crontab with crontab -r
• you can list the installed crontab with crontab -l

password protecting directories

Directories that are password protected are in /etc/apache2/sites-avalable pathbost and sitebuil

visitor statistics

http://www.hping.org/visitors/doc.html

visitors --output text -A -m 30 /var/log/apache2/access.log -o html >home/sitebuil/public_html/files/webstats.html
visitors --output text -A -m 30 /var/log/apache2/other_vhosts_access.log --trails --prefix http://sitebuilt.net -o html > /home/sitebuil/public_html/files/webstatsSBS.html
visitors --output text -A -m 30 /var/log/apache2/other_vhosts_access.log --trails --prefix http://pathbost.com -o html > /home/sitebuil/public_html/files/webstatsPATH.html
visitors --output text -A -m 30 /var/log/apache2/other_vhosts_access.log --trails --prefix http://levelthefield.us -o html > /home/sitebuil/public_html/files/webstatsLTF.html

other software

that doesn't get put somewhere automatically

Put source.taz.gz under /usr/local/src

From /usr/local/bin creagte a link

ln -s ../src/srcdir/compiledbin

securing phpmyadmin

http://paynedigital.com/2011/09/setting-up-and-securing-a-phpmyadmin-install-on-ubuntu-10-04

1. setting up ssl certificate

mkdir /etc/apache2/ssl
openssl req -new -x509 -days 365 -nodes -out /etc/apache2/ssl/apache.pem -keyout /etc/apache2/ssl/apache.key

2. mv phpmyadmin.conf inside a virtual host and put it in sites-available

mv /etc/apache2/conf.d/phpmyadmin.conf /etc/apache2/sites-available/

3. edit take out Alias, add virtual host and put in new credentials (pem and key)

4. got /etc/apache2/sites-enables and enable it

ln -s ../sites-available/phpmyadmin.conf

5. goto /etc/apache2/ports.conf and add

NameVirtualHost 198.23.156.78:443

6. restart apache

/usr/sbin/apache2ctl restart

put a host file entry in windows or from wherever you wan to get to this host

/windows/system32/drivers/etc/hosts  198.23.156.78 nearwater

moving databases

copies as of 12/2012 of databases are on windows machine /documents/sites/mysqldumps

In phpmyadmin of the target mnachine create a user with same nae as source user and put the source ip as host. Create the (empty)databases on the target

root@server1 /var/backups# mysql -u root -p  -h localhost pathbost_assess < pathbost_assess.sql
root@10.194.101.169: home$  mysqldump -utim -pnji9ol pathbost_h409 | mysql -h198.23.156.78 -utim -pnji9ol pathbost_h409
mysqldump -utim -pnji9ol pathbost_poets | mysql -h198.23.156.78 -utim -pnji9ol pathbost_poets

To copy directories from old vps to new

root@10.194.101.169: home$  rsync -aHvz /home/pathbost/public_html root@198.23.156.78:/home/pathbost

installed lamp stack using https://help.ubuntu.com/community/ApacheMySQLPHP

Run, Stop, Test, And Restart Apache Use the following command to run Apache :

$ sudo /usr/sbin/apache2ctl start
$ sudo /usr/sbin/apache2ctl stop
$ sudo /usr/sbin/apache2ctl configtest
$ sudo /usr/sbin/apache2ctl restart

Mysql

Commented out # bind-address = 127.0.0.1 in /etc/mysql/my.cnf so as to access db from any server

$ restart mysql