Hudsonvalley

backup

• http://www.cenolan.com/2008/05/simple-linux-to-amazon-s3-backup-script/
• http://www.alvechurchdata.co.uk/softhanoi.htm
• http://s3tools.org/s3cmd
• http://tagmycode.com/snippet/480/backup-mysql-database-to-amazon-s3-with-s3cmd-on-debian#.UMifCoP2GSo
• http://docs.amazonwebservices.com/AmazonS3/latest/dev/object-lifecycle-mgmt.html
• http://en.wikipedia.org/wiki/Backup_rotation_scheme

S3 backup with s3napback

1. Get java working on Ubuntu 10.04 see Ubuntu 10.04 java

2. Install the other needed stuff

sudo cpan Date::Format Config::ApacheFormat Log::Log4perl

3. Download s3napback

cd /usr/local/share
lynx http://dev.davidsoergel.com/trac/s3napback/raw-attachment/wiki/Releases/s3napback-1.10.tgz
tar xvf s3napback-1.10.tgz

4. create S3 login in /usr/local/share/s3napback/key.txt containing

key=your AWS key 
secret=your AWS secret (you have to click something on the aws page to see the secret)

5. Set up mysql to not need a password to do a dump.

In order for mysql to work, the user you're running the script as must be able to mysqldump the requested databases without entering a password. This can be accomplished through by creating a .my.cnf file in the user's home directory putting in it

[mysqldump]
user=mysqluser
password=secret

Ubuntu 10.04 java

Since $ sudo add-apt-repository "deb http://archive.canonical.com/ lucid partner" DOESN'T WORK

If you need the real Sun JRE you can:

1. goto dir like /usr/local/src or wherever you put stuff you install that's not apt-get
2. download java-jre with duinsoft's install script:
3. gunzip it
4. run the install script
5. find out whereis (I found it got installed to /opt/java/32/jre1.7.0_09/bin/java)
6. link to it from /usr/local/bin
7. restart the shell so your computer can find it

# cd usr/local/src
# lynx http://www.duinsoft.nl/pkg/pool/all/update-sun-jre.bin
# gunzip update-sun-jre.bin.gz
# sh update-sun-jre.bin
# cd /usr/local/bin
# ln -s /opt/java/32/jre1.7.0_09/bin/java

php include directory

is where to put code that you want to run from multiple different directories. However it can't seem to be set in php.ini. The default is usr/share/php. In order to include files from /usr/local/share/php5/ I put a link in /usr/share/php/ to /usr/local/share/php5/chromephp/ChromePhp.php

console log with ChromePhp.php

now included in /usr/share/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) <syntaxhighlight> <?php include 'ChromePhp.php'; ChromePhp::log('hello world'); </syntaxhighlight>

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 can install it by running

$ sudo crontab -u pathbost /var/spool/cron/crontabs/pathbost

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