Picture Placemat

version 2.0 (2011)

---

Installation onto a Personal Computer or a Home Web Server

   Main Page

Distribution Types

1. Debian Based Systems
2. Red Hat Based Systems

• Notes:
  • if using a separate home web server, access the server via an ssh session
    • this will present itself just like a local computer so all commands will be the same
    • you may need to ssh in as a regular user then 'su -' or sudo to root
  
  
• Before you begin, you should be prepared to provide a few bits of information.
  All these items are references only, your choice of names does not impact picture presentation.
  1. Directory that will hold all your images. A default name is provided.   More Information on Image File & Directory Layout  (link)
  2. Database Name to be created -no default value
  3. Database Table -a smaller area within the database, a default is provided
  4. Database User Name -used by scripts to access the database
  5. Database User's Password
     this should be 5 to 10 characters long. Letters and Numbers only, no special characters

---

• Debian Based Systems

  Assumptions:
  • web service user is 'www-data'
  • cgi-bin directory is at '/usr/lib/cgi-bin'
  • DocumentRoot is at '/var/www'
  • all steps performed as 'root'
  
  
  
  1. Ensure you have Apache Web Server, MySQL Database Server, Image Magick (image utilities) and Curl installed
     • if you're not sure, you can just test for Apache and MySQL. The install will check the rest anyway.
     • look in '/etc/rc.d/init.d' for apache2 and mysql
  2. Make sure Apache and MySQL Services are running (should work on many distros)

       service apache2 status
       service mysql status
             

  3. run these two commands, replacing 'new_db_name' (twice in 2nd command) 'dbuser' and 'password'

        mysqladmin create new_db_name
        echo "grant all on new_db_name.* to 'dbuser'@'localhost' identified by 'password';" | mysql new_db_name
              

  4. copy or move the Picture Placement tar archive (ppm-v2.0.tgz or similar name) into the cgi-bin directory
  5. untar it
  6. from /usr/lib/ run

       chown www-data cgi-bin
           

  7. cd into cgi-bin and run

       chown www-data ppm*
       chmod 500 ppm_home.sh ppm_libs-f.sh ppm_libs-v.sh ppm_setup-env.sh
           

  8. cd to /var/ and run

       chown www-data www
           

  9. disable the Apache Deflate Module.
     Left enabled in Debian based systems (maybe not all, and maybe others) the deflate module causes the slide-show to fail and can cause problems with some tools. The issue is that it will stop the page from loading until it is completely generated, like after the very last slide in a slide show!
     
     you can test for it by running

       apachectl -M 2> /dev/null | grep deflate
           

     To Disable it run

       a2dismod deflate
       service apache2 restart
           

  10. in your web browser enter:

        http://localhost.localdomain/cgi-bin/ppm_home.sh
            

      • this starts the setup program
      • most fields are prepopulated but must be confirmed
      • you must provide:
        • 'Database Name', 'DB User-name' and 'DB User Password'
        • you must provide the path to DocumentRoot which should be at /var/www
          but the script cannot confirm it because it only looks parallel to cgi-bin, which in Debian is /usr/lib/cgi-bin
          • there is a field for the basic directory name and a second one which must include the full path
      • complete all steps, including setting Administrator password, and ending in the Admin Tools area
  11. 
      
      next step is Set Up the Images Area

TOP

---

• Red Hat Based Systems

  Assumptions:
  • web service user is 'apache'
  • cgi-bin directory is at '/var/www/cgi-bin'
  • DocumentRoot is at '/var/www/html'
  • all steps performed as 'root'
  
  
  
  1. Ensure you have Apache Web Server, MySQL Database Server, Image Magick (image utilities) and Curl installed
     • if you're not sure, you can just test for Apache and MySQL. The install will check the rest anyway.
     • look in '/etc/rc.d/init.d' for mysqld, and either httpd or apache2
       
       
  2. Make sure Apache and MySQL Services are running (should work on many distros)

       service mysqld status
       service httpd status
             

  3. run these two commands, replacing 'new_db_name' (twice in 2nd command) 'dbuser' and 'password'

        mysqladmin create new_db_name
        echo "grant all on new_db_name.* to 'dbuser'@'localhost' identified by 'password';" | mysql new_db_name
              

  4. copy or move the Picture Placement tar archive (ppm-v2.0.tgz or similar name) into the cgi-bin directory
     
     
  5. untar it
     
     
  6. from /var/www/ run

       chown apache cgi-bin
           

  7. cd into cgi-bin and run

       chown apache ppm*
       chmod 500 ppm_home.sh ppm_libs-f.sh ppm_libs-v.sh ppm_setup-env.sh
           

  8. cd back to /var/www/ and run

       chown apache html
           

  9. in your web browser enter:

       http://localhost.localdomain/cgi-bin/ppm_home.sh
           

     • this starts the setup program
     • most fields are prepopulated but must be confirmed
     • you must provide:
       'Database Name', 'DB User-name' and 'DB User Password'
     • complete all steps, including setting Administrator password, and ending in the Admin Tools area
       
       
  10. next step is Set Up the Images Area

TOP

---

powerd by: Pete's Code