OSsetup /

Gusoyn

Compaq Armada M700 running Debian GNU/Linux 6.0 "Squeeze" with 320GB internal HDD.

Migration from Astaroth

2013-01-26

Rsync'ed Astaroth:/home/jared to Gusoyn:/home/jared.

2013-01-27

Rsync'ed Astaroth:/home/vdomain to Gusoyn:/home/vdomain.
Spent a few minutes trying to get a the CacheCam.com site working, then JBBooks.
Trouble was had because I need to have MySQL functional, so I created to users:
- CacheCam/summer98 with rights only to CacheCam DB.
- php/AppleRidge with rights to everything.
Resolved to go back to basics, making sure basic functionality was alive. Reminded myself that POP3 service was via QPopper, not my familiar Teapop. I tried to build the latest source of Teapop (which required that I install GCC 4.4, and supporting dev libraries), but then figured I could just install the last available Teapop DEB package (from Etch). This is my next task.

2013-01-29

Removed QPopper (previously installed by me) using Aptitude.
Installed the last Debian-style Teapop package (teapop_0.3.7-4.2_i386.deb) with the command:
- # dpkg -i teapop_0.3.7-4.2_i386.deb
Researched Exim3 vs. Exim4. Looks like Exim4 has a much more elaborate configuration arrangement, akin to the Apache2 configuration with mulitple config files instead of a single large file. I'll need to figure this out since I have a number of virtual domains, plus I need to support the 'pipe' action for incoming email to CacheCam for grabs.

2013-04-24

Found that the auto-installed package libmysql-db-perl does not include the Mysql.pm nor Mysql/Statement.pm as would be the case if I installed myself via CPAN.
- After trying to install Bundle::DBD::Mysql from CPAN (and maybe making a mish-mash of installed modules), I gave up. There was an error on build and I couldn't determine why. So, some of the dependency packages for Bundle::DBD::Mysql are now installed, even though I couldn't get the final Mysql.pm to install.
- I ended up 'stealing' Mysql.pm and Mysql/Statement.pm from my old Debian 3.0 system (astaroth) and just manually copying them to:
  - /lib/local/perl5/Mysql.pm
  - /lib/local/perl5/Mysql/Statement.pm
- Once that was done, magically my Mysql-using perl scripts work.
cachecam.com complete
jaredblaser.com complete
jblaser.org complete
- discovered that the Mysql DB files are not directly transferable from my old server. In the case of the jbbooks site, the table books was not usable, and I had to recreate it from a dump from the old system with mysqldump. However, it wasn't directly importable, and I had to remove all the comments (--) and blank lines to make it work:
  - $ mysql -uphp -p jbbooks < dumpfile
- also found, as I did with CacheCam, my old usage of the PHP function setcookie() was incorrect, and I have had to edit the PHP files to use a 0 or '0' for the expiration field, rather than the empty string '' that I was able to get away with on my old system.
rblaser.org complete
- had to perform a MySQL database dump for both RBbooks and RBvideos.
  - (astaroth) $ mysqldump -c --add-drop-table -uphp -p video > /tmp/video.sql
  - (gusoyn) $ ftp astaroth
    - ftp> get /tmp/video.sql /tmp/video.sql
  - (gusoyn) $ sed -n -e '/^$/ d ; /^--/ d ; p' /tmp/video.sql > video.sql.sql
  - (gusoyn) $ echo "create database video;" | mysql -uphp -p
  - (gusoyn) $ mysql -uphp -p video < video.sql.sql
- had to fix the setcookie() function in my PHP files
  - find the files for a particular website:
    - for file in * ; do if cat $file | grep -q setcookie ; then echo $file ; fi ; done
    - edit found files; use '0' or 0 in the third parameter instead of ''
rebeccablaser.com complete

2013-10-29

rogerwilco.org complete
- also found, as I did with CacheCam, my old usage of the PHP function setcookie() was incorrect, and I have had to edit the PHP files to use a 0 or '0' for the expiration field, rather than the empty string '' that I was able to get away with on my old system. (rectrack)
- tried to setup HTTPS for each vdomain but finally learned that is not possible using just named virtual hosts, only if separate IP addresses were used. So as with astaroth, I elected to use the documentroot from rogerwilco.org as the root for anything going HTTPS.
- had to mess with a number of things in the new apache 2.2 configuration to get HTTPS to work (rectrack needs this):
  - added 'NameVirtualHost *:443' in /etc/apache2/ports.conf
  - adjusted config parameters in /etc/apache2/sites-available/default-ssl
  - created softlink from default-ssl to /etc/apache2/sites-enabled/001-default-ssl
  - had to adjust all virtual domain configs to use '<VirtualHost *:80>' instead of '<VirtualHost *>'
thescheduler.com complete
thescheduler.net complete

2013-10-30

Wrapped up general configuration and brought Gusoyn current by again transferring all user files and DBs from Astaroth.
Updated gateway/router to now point all traffic to Gusoyn, making it live.

2013-11-15

discovered that some of my websites don't quite work correctly. It's due to the new DB server NOT having magic quotes turned on. JBBooks and RBBooks both exhibit trouble when a field contains a single quote. The update won't work. If I escape those apostrophes then all is well. I need to review the old PHP.INI versus the new one.

Task List

Configure EXIM mail server
- General
  - Plain Auth
- Local Users
- Virtual Users
  - cachecam.com director & transport
Configure Apache web server
- General
  - mm - Mail Manager (Included config)
  - /etc/php5/apache2/php.ini
    - output_buffering = Off
    - magic_quotes_gpc = On - PHP 5.4+ defaults to OFF; needed by jbbooks and rbbooks
    - register_long_arrays = On ($HTTP_SERVER_VARS, etc)
    - register_globals = On (action=pass -> $action)
  - /etc/php5/cli/php.ini
    - register_long_arrays = On ($HTTP_SERVER_VARS, etc)
    - register_globals = On (action=pass -> $action)
- Local Users
  - Jared
    - Crossword
    - DropZone
    - EpisodeScan
    - ZapScan
    - JB Wiki
- Virtual Servers
  - cachecam.com
    - (web site)
    - Perl mods
      - GD
      - Email::MIME
      - MIME::Lite
      - Mysql
  - jaredblaser.com
    - 48-State
    - Antics (Antiques?)
    - books
    - DropZone
    - Gwilliam Basement design
    - BRBFT
  - jblaser.org
    - JB Books
  - rblaser.org
    - RB Books
    - RB Videos
    - Zapscan
  - rebeccablaser.com
  - rogerwilco.org
    - DTC-520
    - DS5400
    - Funfly48
    - HP2250
    - TU58 Tape Images
    - VAX-11/750
    - DropZone
    - generic -> FSLogic snapshot
    - Mystery Boards
    - RecTrack
    - Citizen Wingman
  - thescheduler.com
    - The Scheduler
    - N993JB instantiation
  - thescheduler.net
Configure MySQL DB server
- General - magic quotes?
- Create user accounts and set privileges
- Transfer Databases
  - Antique
  - CacheCam
  - RETrack
  - RecTrack
  - jbbooks
  - rbbooks
  - video
Setup web-based email (IMP?, Squirrel?)
Setup crontabs
Setup log rotations