Open main menu

Fishbowl β

Fishbowl 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

NOTE: If the Fishbowl Server 2017.1 or higher is being installed for the first time on Linux, MySQL will need to be configured by following the steps here. MySQL does not need to be installed if only the Fishbowl Client is being installed. For Firebird instructions (Fishbowl 2016.14 or earlier) see the archived article.

Ubuntu Desktop or Ubuntu Server

  1. 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
  2. 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)
  3. Restart the computer and log in as an admin user.
  4. Download the Fishbowl installer.
  5. Open xterm and run the installer.
    sudo sh /path/to/Fishbowl/installer/fbWarehouse-2018.10.sh
  6. Grant the admin user (or whichever user will be running Fishbowl) rights to the Fishbowl files.
    sudo chown -R username /path/to/Fishbowl/folder
  7. Restart the computer and log in as a user with access to Fishbowl.
  8. Launch the Fishbowl Server and Client with the installed shortcuts.

Other Linux Distributions

  1. Make sure the Java 8 JDK is installed.
  2. In the terminal, navigate to the directory of the downloaded installer. Below is an example.
    cd /home/yourUsername/Downloads/
  3. Run the installer with root priveleges. Below is an example.
    sudo sh fbManufacturing-2018.10.sh
    • Depending on your Linux distribution, you may need to use the tarball installer rather than the above shell script.
      tar -xvf fbManufacturing-2018.10.tar.gz
  4. Follow the installer steps (not needed if using the tarball).

Install MySQL for Fishbowl Server

NOTE: If the Fishbowl Server 2017.1 or higher is being installed for the first time on Linux, MySQL will need to be configured by following the steps below. MySQL does not need to be installed if only the Fishbowl Client is being installed.

Follow the steps below to install MySQL 5.7 or higher on the Fishbowl Server for the first time.

  1. Run this command in terminal to install MySQL Server (if needed, additional repository downloads and terminal instructions can be found the MySQL website).
    sudo apt-get install mysql-server
  2. Record the MySQL Server root password entered during the install.
  3. Download MySQL Workbench from here. It can be used to reset the root password if needed.
  4. Install Fishbowl for Linux.
  5. Grant the admin user (or whichever user will be running Fishbowl) rights to the Fishbowl files.
    sudo chown -R username /path/to/Fishbowl/folder
  6. Right-click db-migration.sh in /server/bin, click the Permissions tab and change all to Read-Write. Also select Allow executing file as program. This will allow the Fishbowl Server to run the migration tool.
  7. Open the my.cnf file, add the following lines under the mysqld section, and then save.
    lower_case_table_names=1
    sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

NOTE: The MySQL installer will set the port to 3306. Whenever a database window is displayed on Linux, verify that the port has been changed to 3306 and the secure password has been entered.

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

Create a new database

Follow the instruction below to create a new MySQL database on Linux.

  1. Click the Fishbowl Server tray icon and select Options.
  2. Click the   New button and enter a new database name
  3. Change the port number to 3306 and enter the secure password that was created earlier.
     
  4. Click Connect, choose a costing method, and then click OK.
  5. Click the Fishbowl Server tray icon and select Start.

Database backup

A database backup can be created in the   Schedule module or by right-clicking the database name in the Fishbowl Server options.

 

The .sql file created during the backup can then be restored on the Restore tab.

 

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   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   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   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   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