Fishbowl for Linux archive

From Fishbowl
Jump to: navigation, search

NOTE: This is an archive page with instructions for Firebird, which is used for Fishbowl 2016.14 or earlier. For Fishbowl 2017.1 or later, see Fishbowl for Linux and MySQL for Linux.

Fishbowl provides a Fishbowl installer for Linux which can be downloaded here. Both the Fishbowl Client and the Fishbowl Server can run on Linux. Fishbowl integrates with QuickBooks Online and Xero, making it possible to run Fishbowl and an accounting package entirely on Linux computers, or on any combination of supported operating systems. The Fishbowl Server on Linux can also integrate with QuickBooks Desktop running on a Windows computer.

Install Fishbowl

Ubuntu Desktop or Ubuntu Server

  1. Install Firebird on the Fishbowl Server computer (not needed for only a Fishbowl Client).
    sudo apt-get install firebird2.5-superclassic
    Enter masterkey as the password
  2. Double check the password was set to masterkey (there is a bug in the firebird installer).
    sudo nano /etc/firebird/2.5/SYSDBA.password
  3. If the password is wrong, set it again.
    sudo dpkg-reconfigure firebird2.5-superclassic
  4. Install Oracle Java 8.
    sudo apt-get install python-software-properties
    sudo add-apt-repository ppa:webupd8team/java
    sudo apt-get update
    sudo apt-get install oracle-java8-installer
    sudo apt-get install oracle-java8-set-default
  5. Skip this step for Ubuntu Desktop. For Ubuntu Server, a Window manager must be installed. LXDE is recommended.
    sudo apt-get install lubuntu-core
    sudo apt-get install firefox --no-install-recommends
    (optional, but useful for downloading Fishbowl)
  6. Restart the computer and log in as an admin user.
  7. Download the Fishbowl installer.
  8. Open xterm and run the installer.
    sudo sh /path/to/Fishbowl/installer/fbWarehouse-2019.7.sh
  9. Grant the admin user (or whichever user will be running Fishbowl) rights to the Fishbowl files.
    sudo chown -R username /path/to/Fishbowl/folder
  10. Grant Firebird access to the database.
    sudo chown firebird /path/to/Fishbowl/folder/database/data/*.FDB
  11. Restart the computer and log in as a user with access to Fishbowl.
  12. Launch the Fishbowl Server and Client with the installed shortcuts.
Troubleshooting
  • Server is already running error
    Make sure the user running the Fishbowl Server has been granted access (see step 9).
  • Cannot Access Database error
    Make sure the firebird SYSDBA password is masterkey (see steps 2 & 3) and the firebird user can access the database file (see step 10).

Other Linux Distributions

  1. Make sure the Java 8 JDK is installed.
  2. Install and configure Firebird (only needed if you want to run the Fishbowl Server from Linux)
    • Set the Firebird SYSDBA password to masterkey.
    • Start Firebird
  3. In the terminal, navigate to the directory of the downloaded installer. Below is an example.
    cd /home/yourUsername/Downloads/
  4. Run the installer with root priveleges. Below is an example.
    sudo sh fbManufacturing-2019.7.sh
    • Depending on your Linux distribution, you may need to use the tarball installer rather than the above shell script.
      tar -xvf fbManufacturing-2019.7.tar.gz
  5. Follow the installer steps (not needed if using the tarball).
  6. In the terminal, navigate to the Fishbowl database directory and change the file ownership of all Fishbowl databases with the following commands.
    cd /yourInstallationFolder/Fishbowl/database/data/
    sudo chown firebird *.FDB

Start Fishbowl

Fishbowl can be run using the program shortcuts, or from the terminal.

Using the shortcuts

  1. Double-click the Fishbowl Server application shortcut in the install directory.
    • Note: If a message says that the Fishbowl Server is already running, the user needs to be given permissions to modify files in the /fishbowl/server/bin folder.
  2. Double-click the Fishbowl Client application shortcut in the install directory.

From the terminal

  1. In the terminal, navigate to /fishbowl/server/bin/ and type sudo sh eve.sh
  2. In another terminal window, navigate to /fishbowl/client/bin/ and type sudo sh client.sh

Integrate with QuickBooks

QuickBooks Desktop only runs on Windows computers. The Linux version of the Fishbowl Server can integrate with QuickBooks on a Windows computer, or a Linux computer running Windows as a virtual machine. NOTE: If the Fishbowl Server is running on a Windows computer, these steps are not necessary. Alternatively, Fishbowl can integrate with QuickBooks Online or Xero, which don't require a Windows computer

Complete the steps below to allow the Fishbowl Server on Linux to communicate with a Windows QuickBooks installation.

  1. Copy Fishbowl Nexus.exe from the Linux computer (/Fishbowl/server/bin/) to a folder located on the Windows computer. Fishbowl Nexus must be running for the export to work. Placing the program in the Startup folder will allow the program to start automatically when the computer reboots.
  2. Run Fishbowl Nexus.exe on the Windows computer. The Fishbowl Nexus icon will appear on the taskbar.
  3. Open the Fishbowl Server and the Fishbowl Client on the Linux computer.
  4. Open the Small.Property.png Property module in the Fishbowl Client and double-click FBNexusURL in the search pane.
  5. Change the Value of the property from localhost to the IP address of the Windows computer (for example, 192.168.2.100) and then click Save.
  6. Open the Small.Accounting Integration.png Accounting Integration module and run the QuickBooks Integration Wizard.

You should now be able to export from the Fishbowl Server on Linux to the QuickBooks installation on Windows.

Integrate with QuickBooks Online

Because QuickBooks Online is web-based, integration is not dependent on the operating system. Simply open the Small.Accounting Integration.png Accounting Integration module and run the QuickBooks Online Integration Wizard.

  • Note: If the connection link is not launching then certain linux libraries are missing, to resolve run in terminal (Ubuntu version) :
    sudo apt-get install libgnome2-0

Integrate with Xero

Because Xero is web-based, integration is not dependent on the operating system. Simply open the Small.Accounting Integration.png Accounting Integration module and run the Xero Integration Wizard.

  • Note: If the connection link is not launching then certain linux libraries are missing, to resolve run in terminal (Ubuntu version) :
    sudo apt-get install libgnome2-0

Database backup

A backup can be created by copying the database file or by using the nbackup utility.

  • In the terminal as sudo run: /usr/bin/nbackup -B 0 <full database path> <full backup database path>
Example: /usr/bin/nbackup -B 0 "/Fishbowl/database/data/EXAMPLE.FDB" "usr/fishbowl/Desktop/backupFiles/EXAMPLE.bck"

For a scheduled backup example, click here.