Helpful Guides

Installing Bigfish on a Single Windows Server

Assumptions

  • This deployment guide assumes a setup consisting of 1 server running MySQL, Bigfish and Apache

Conventions

blue_italics are variables - replace them with the correct information

red-text are commands - run them as they appear, including correctly replaced variables in a command prompt

Useful Commands

mysqldump db_name > /backup_path/filename.sql This will back up the mysql database to a sql file
mysql db_name > /backup_path/filename.sql This will restore a database from a backup that was made by the above command

Setting up the servers

  • Ports 80 and 443 must be open publicly on the Windows Firewall, and any network firewall if applicable.
  • The Network Administrator can set this up

MySQL setup

  • This assumes that MySQL is already installed
    • See MySQL documentation to install
  • Create Schema and Users:
    • Log in as root user and issue the MySQL command to start a MySQL session:
      • mysql
    • Create the database and users:
      • create database db_name
      • create user username identified by password
    • Grant privileges to user on the DB:
      • grant all privileges on db_name.* to 'username'@'%' identified with 'password' with grant option;

Application setup

  • Three directories get copied and installed to the same directory on the application server
  • Get the necessary files:
    • apache-ofbiz-10.04.05.zip (this is the base OFBiz install version 10.04)
    • BigFish-eCommerce-v1.10.zip (this is the BigFish project base install)
    • project.zip (this is the latest install for project specific data)
  • Copy and deploy OFBiz base install
    • Extract the apache-ofbiz-10.04.05.zip file to C:/ofbiz
  • Copy and deploy BigFish
    • Extract the BigFish-eCommerce-v1.10.zip file and copy its files into the C:/ofbiz directory. Select to overwrite all conflicts.
  • Copy and deploy client and project specific application
    • Extract the project.zip file and copy its files into the C:/ofbiz directory. Select to overwrite all conflicts

Application Server Configuration

  • In the ofbiz/osafe_deployment directory, update client-deployment.properties
    • port.jndi = 1099
    • port.https = 8443
    • port.http = 8080
    • port.ajp = 8007
    • port.beanshell = 9997
    • solr.search.port = 8080
    • solr.index.port = 8080
    • url.port.http = 80
    • url.port.https = 8443
    • xms = 2048m
    • xmx = 2048m
  • In OFBiz directory, build the property files
    • In a command prompt, move to the ofbiz base directory (cd C:/ofbiz) then run thecommand.
      • ant build
  • Create tables and seed data by running:
    • This creates the actual database tables preparing them to accept the full application data
    • Only run if the client data is ready to be loaded
      • ant run-install-seed
  • Prepare and run the startup script
    • Start OFBiz (Starts the application)
      • startofbiz.bat

Apache server configuration

  • Choose the apache version that specifies openssl
  • Install Apache to C:/Program Files (x86)/Apache_2.2
  • Configure apache property settings for main application
    • Edit file: C:/Program Files (x86)/Apache_2.2/conf/httpd.conf
    • Uncomment
      • LoadModule deflate_module modules/mod_deflate.so
      • LoadModule expires_module modules/mod_expires.so
      • LoadModule headers_module modules/mod_headers.so
      • LoadModule proxy_module modules/mod_proxy.so
      • LoadModule proxy_ajp_module modules/mod_proxy_ajp.so
      • LoadModule rewrite_module modules/mod_rewrite.so
      • LoadModule ssl_module modules/mod_ssl.so
    • Set ServerAdmin email if not set during install
    • Under #Virtual Hosts add an Include line for each server's vhost settings
      • Include conf/server_abbreviation/httpd-vhosts.conf
    • Uncomment
      • Include conf/extra/httpd-ssl.conf
    • Create a directory under the Apache_2.2/conf directory called server_abbreviation
    • Copy the httpd-vhosts.conf.example file to the directory above, and remove the .example extention
    • replace all occurrences of the following with the appropriate values for the new server
      • domain_abbreviation : (same as server_abbreviation in this document)
      • set ServerAdmin variables to the contact email address
      • www.domain.com : set to the domain name that will be used by the server
      • In the SSLCertificate section, replace both domain_abbreviation and the file names to point to the actual SSL crt, bundle.crt and key files
    • Restart apache
      • open apache manager from the taskbar, highlight apache and click restart
  • In any web browser, navigate to the site and verify page loads
    • http://apache_server_public_ip/
    • You should now see a mostly blank page with a dotted line and " Built by Solveda LLC"

Generate SOLR indexes

  • Go to the osafe-admin web page, (https://www.domain.com/osafe-admin/control/main)
    • Admin Admin Tools SOLR Indexing
    • Click on “Re-Index SOLR”
  • Wait for indexing to finish
  • You can check that indexing completed successfully by going to the server, looking for the ofbiz/hot-deploy/solr/data/index directory and seeing that there should be several files starting with an underscore '_' and 2 other files.

This process can take up to an hour, so please be patient.

Changing the Default Localization

  • If you are a non US user or need to launch a site in another language and currency you can change these settings in your store configuration.
  • Login to Catalog Manager
    • https://<yourhost.yourdomain.com>/catalog
  • Click on the “Stores” tab.
  • Select your store.
  • Expand the Localisation section.
  • Set your locale string and currency.
  • Locale string should be in the format en_US, en_GB, etc.
Back to Top

Built by Solveda