Fishbowl for Linux

From Fishbowl
Jump to navigation Jump to search

Fishbowl provides a Fishbowl installer for Linux which can be downloaded here. The process for installing Fishbowl on Linux is more complicated than the Windows installer that the vast majority of customers use. Please note that Fishbowl only provides limited Linux support. 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.

Initial configuration

The following steps only need to be completed when installing Fishbowl for the first time on Linux. These instructions were created using Ubuntu 18.04. When entering commands in a terminal window, the underlined sections need to be replaced to match the specific system.

  1. MySQL 5.7 needs to be installed on the Fishbowl Server. MySQL is not required if only the Fishbowl Client is being installed.
  2. Download the MySQL DEB package from here. More information regarding the APT repository is available at dev.mysql.com.
  3. Open a terminal window and navigate to the ../Downloads folder.
  4. Enter sudo dpkg -i name.of.deb.file
  5. Change the MySQL version from 8.0 to 5.7
  6. Enter sudo apt-get update
  7. Enter sudo apt-cache policy mysql-server and verify that MySQL version 5.7 appears in the output.
  8. Enter sudo apt-get install mysql-server=5.7* mysql-community-server=5.7* mysql-client=5.7*
  9. Create a root password for MySQL and store the password securely for later use.
  10. Enter sudo mysql_secure_installation and answer the following questions:
    • Validate complex password? Yes
    • Remove anonymous users? Yes
    • Disallow root login remotely? No (optional)
    • Remove test database? Yes
    • Reload privilege tables now? Yes
  11. Log into MySQL by entering mysql -u root -p
  12. Once logged into MySQL, enter SELECT VERSION (); and verify that MySQL version 5.7 was installed
  13. Exit MySQL by typing Exit
  14. Configure MySQL for use with Fishbowl by using a text editor to add the following lines to the /etc/mysql/mysql.conf.d/mysqld.cnf file:
        lower_case_table_names=1
        sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
  15. Restart MySQL by entering sudo systemctl restart mysql
  16. Install the Java 8 JRE by entering sudo apt-get install openjdk-8-jre
  17. Verify that the system is using Java 8 by entering java -version
  18. If a different version of Java is displayed, set the default to Java 8 by using update-alternatives --config java
  19. Download the latest Linux installer for Fishbowl.
  20. Open a terminal window and navigate to the ../Downloads folder.
  21. Start the Fishbowl installer by entering sudo sh Fishbowl.version
  22. Complete the steps in the Fishbowl installer.
  23. Enter sudo chown -R username /usr/local/Fishbowl
  24. Create a MySQL configuration file inside of the Fishbowl installation by entering sudo cp /usr/local/Fishbowl/server/bin/my.cnf /etc/mysql/conf.d/mysql.conf
  25. Restart MySQL by entering sudo systemctl restart mysql
  26. Start the Fishbowl Server by navigating to usr/local/Fishbowl/server/bin and entering sudo sh eve.sh
  27. Open the Fishbowl Server Administration and create a new database.
  28. When creating a new database or restoring a database, verify that the MySQL port is set to 3306 and that the root password matches what was entered when installing MySQL.
  29. Start the Fishbowl Client by navigating to /usr/local/Fishbowl/client/bin and entering sudo sh client.sh

Start Fishbowl

Fishbowl can be started by using the shortcuts in the installation directory or by opening a terminal window.

Using the shortcuts

  1. Double-click the Fishbowl Server application shortcut in the installation directory. If a message says that the Fishbowl Server is already running, the user may need to be given permissions to modify files in the /Fishbowl/server/bin folder
  2. Double-click the Fishbowl Client application shortcut in the installation directory

From the terminal

  1. In a terminal window, 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

Database backup

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

MySQL backup.png

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

Restore database.png

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 Icon.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 Icon.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 Icon.Accounting Integration.png Accounting Integration module and run the QuickBooks Online Integration Wizard. If the connection link is not launching then certain Linux libraries might be missing. To resolve this issue, open a terminal window and enter 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 Icon.Accounting Integration.png Accounting Integration module and run the Xero Integration Wizard. If the connection link is not launching then certain Linux libraries might be missing. To resolve this issue, open a terminal window and enter sudo apt-get install libgnome2-0