Difference between revisions of "Fishbowl for Mac"

From Fishbowl
Jump to navigation Jump to search
m (Text replacement - "|link=" to "")
 
(28 intermediate revisions by the same user not shown)
Line 1: Line 1:
Fishbowl provides a Fishbowl installer for Mac which can be downloaded [http://www.fishbowlinventory.com/support/updates/ here]. Both the Fishbowl Client and the Fishbowl Server can run on Mac. Fishbowl integrates with QuickBooks Online and Xero, making it possible to run Fishbowl and an accounting package entirely on Apple computers, or on any combination of [[Supported_Operating_Systems|supported operating systems]]. The Fishbowl Server on a Mac can also [[#Integrate_with_QuickBooks|integrate with QuickBooks Desktop running on a Windows computer]].
+
{{CategoryBox|Other}}
 +
Fishbowl provides a Fishbowl installer for Mac which can be downloaded [https://www.fishbowlinventory.com/support/updates/download/ here]. Both the Fishbowl Client and the Fishbowl Server can run on Mac. Fishbowl integrates with QuickBooks Online and Xero, making it possible to run Fishbowl and an accounting package entirely on Apple computers, or on any combination of [[Supported_Operating_Systems|supported operating systems]]. The Fishbowl Server on a Mac can also [[#Integrate_with_QuickBooks|integrate with QuickBooks Desktop running on a Windows computer]].
  
== Install Fishbowl {{top}} ==
+
==Apple M1 chip==
  
The Fishbowl installer includes a copy of Java, so in most cases, it is not necessary to install Java separately.
+
* To install the Fishbowl Server on a Mac with the M1 chip, follow the additional instructions listed in [[Homebrew]].
 +
* For Macs with the M1 chip that will only be using the Fishbowl Client, the [[#Install_Fishbowl|standard installation]] will work.
 +
* If the Fishbowl Installer fails to install Java on a Mac with the M1 chip, the installer for Java 8 on ARM processors can be downloaded by clicking [https://cdn.azul.com/zulu/bin/zulu8.52.0.23-ca-jdk8.0.282-macosx_aarch64.dmg here].
  
# '''NOTE:''' If the Fishbowl Server 2017.1 or higher is being installed for the first time on a Mac, MySQL will need to be configured by following the steps [[#Install MySQL for Fishbowl Server|here]]. MySQL does not need to be installed if only the Fishbowl Client is being installed.
+
==Install Fishbowl==
# Download the Mac installer for Fishbowl by clicking [http://www.fishbowlinventory.com/support/updates/ here].
 
# Select '''14 Day Fishbowl Trial''' or  '''Current Fishbowl User''' and then complete the [[Getting_Started#1._Install_Fishbowl|installation wizard]].<br>[[File:Current Fishbowl User.png]]
 
# In '''Finder''', open the '''Applications''' folder. Right-click the '''Fishbowl''' folder and select '''Get Info'''. Click the lock icon and then assign the '''Read & Write''' privilege to all users listed. Then click the gear icon and select '''Apply to enclosed items'''.<br>[[File:Fishbowl Permissions for Mac.png]]
 
# Start Fishbowl using the shortcuts created on the desktop. Fishbowl can also be opened with '''Applications/Fishbowl/server/bin/Fishbowl Server''' and  '''Applications/Fishbowl/client/bin/Fishbowl Client'''.
 
  
== Install MySQL for Fishbowl Server {{top}} ==
+
The Fishbowl installer includes a copy of Java, so in most cases, it is not necessary to install Java separately. For newer Macs with the M1 processor, see [[#Apple_M1_chip|Apple M1 chip]].
  
'''NOTE:''' If the Fishbowl Server 2017.1 or higher is being installed for the first time on a Mac, 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.
+
# '''NOTE:''' If the Fishbowl Server is being installed for the first time on a Mac, MySQL will need to be configured by following the steps [[#Install MySQL for Fishbowl Server|here]]. MySQL does not need to be installed if only the Fishbowl Client is being installed.
 +
# Download the Fishbowl Installer for Mac by clicking [https://www.fishbowlinventory.com/support/updates/download/ here].
 +
# Right-click the Fishbowl Installer and select '''Open'''. <br>[[File:Mac right-click.png]]
 +
# When asked if you want to open the Fishbowl Installer, click '''Open'''.<br>[[File:Mac open installer.png]]<br>If the '''Open''' button is not visible, repeat step 3 or adjust your security preferences for installing apps.
 +
# You will be asked to enter your password to run the installer. If that doesn't work, you can run the installer as the '''root''' user as described [https://support.apple.com/en-us/HT204012 here].
 +
# Select '''14 Day Fishbowl Trial''' or '''Current Fishbowl User''' and then complete the [[Getting_Started#1._Install_Fishbowl|installation wizard]].<br>[[File:Current Fishbowl User.png]]
 +
# '''NOTE: This step is not necessary for Fishbowl 2021.6 or greater'''<br>In '''Finder''', open the '''Applications''' folder. Right-click the '''Fishbowl''' folder and select '''Get Info'''. Click the lock icon and then assign the '''Read & Write''' privilege to all users listed. Then click the gear icon and select '''Apply to enclosed items'''.<br>[[File:Fishbowl Permissions for Mac.png]]
 +
# Start Fishbowl using the shortcuts created on the desktop. Fishbowl can also be opened with '''Applications/Fishbowl/server/bin/Fishbowl Server''' and '''Applications/Fishbowl/client/bin/Fishbowl Client'''.
  
Follow the steps below to install MySQL on the Fishbowl Server for the first time. Alternatively, [[Homebrew|MySQL can be installed from Terminal using Homebrew]].
+
==Install MySQL for Fishbowl Server==
 +
 
 +
If the Fishbowl Server is being installed for the first time on a Mac, MySQL will need to be installed and configured. MySQL does '''not''' need to be installed if only the Fishbowl Client is being installed.
 +
 
 +
'''We recommend installing MySQL with [[Homebrew]] by following the instructions [[Homebrew|here]]'''.
 +
 
 +
If [[Homebrew]] doesn't work, the installer can be manually downloaded and and configured using the instructions below.
  
 
# Complete the [[Fishbowl_for_Mac#Install_Fishbowl|Fishbowl installation for Mac]].
 
# Complete the [[Fishbowl_for_Mac#Install_Fishbowl|Fishbowl installation for Mac]].
# Have your IT administrator install and configure MySQL 5.7 or higher on the Mac that will be running the Fishbowl Server. The MySQL 5.7 installer can be opened from '''Applications/Fishbowl/database/mysql-5.7.17-macos10.12-x86_64.pkg'''
+
# Click [https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.17-macos10.12-x86_64.dmg here] to download the MySQL installer.
 +
# Have your IT administrator install and configure MySQL 5.7 on the Mac that will be running the Fishbowl Server.
 
# During installation, a temporary password will be created. Save this password for use in later steps.<br>[[File:MySQL temporary password.png]]
 
# During installation, a temporary password will be created. Save this password for use in later steps.<br>[[File:MySQL temporary password.png]]
 
# Open '''System Preferences''', click '''MySQL''', and then click '''Start MySQL Server'''.<br>[[File:Start MySQL Mac.png]]
 
# Open '''System Preferences''', click '''MySQL''', and then click '''Start MySQL Server'''.<br>[[File:Start MySQL Mac.png]]
# Download '''MySQLWorkbench''' from [https://dev.mysql.com/downloads/workbench/ here].
+
# Download '''MySQLWorkbench 8.0.21'''. Click [https://downloads.mysql.com/archives/workbench/ here] and select '''8.0.21'''.
 
# Open the downloaded '''.dmg''' file and double-click '''MySQLWorkbench'''. Moving the application to the '''Applications''' folder is optional.
 
# Open the downloaded '''.dmg''' file and double-click '''MySQLWorkbench'''. Moving the application to the '''Applications''' folder is optional.
 
# Click '''Local Instance 3306'''. If '''Local Instance 3306''' is not listed, click the '''+''' icon to create a new MySQL connection.<br>[[File:MySQL Instance.png]]
 
# Click '''Local Instance 3306'''. If '''Local Instance 3306''' is not listed, click the '''+''' icon to create a new MySQL connection.<br>[[File:MySQL Instance.png]]
 
# Enter the temporary password and then create a new secure password.<br>[[File:New MySQL password.png]]
 
# Enter the temporary password and then create a new secure password.<br>[[File:New MySQL password.png]]
#* Sometimes MySQLWorkbench won't prompt to reset the password or the new password may not save correctly. If that is the case and you still can't restore/create a new database in the '''Fishbowl Server Administration''' window, then follow the '''MySQL password reset''' instructions in the [[#Troubleshooting|Troubleshooting]] section.
+
#* Sometimes MySQLWorkbench won't prompt to reset the password or the new password may not save correctly. If that is the case and you still can't restore/create a new database in the [[Fishbowl Server Administration]] window, then follow the '''MySQL password reset''' instructions in the [[#Troubleshooting|Troubleshooting]] section.
  
== Configure my.cnf file {{top}} ==
+
Follow the steps below to configure the '''my.cnf''' file. NOTE: These steps are '''not''' necessary if you followed the [[Homebrew|Homebrew instructions]]'''.
  
 
# Stop the MySQL service either through command line or by clicking '''Apple''' > '''System Preferences''' > '''MySQL''' and click '''Stop MySQL Server'''.
 
# Stop the MySQL service either through command line or by clicking '''Apple''' > '''System Preferences''' > '''MySQL''' and click '''Stop MySQL Server'''.
Line 42: Line 55:
 
# Place a checkmark next to '''default-time-zone''' and enter your timezone ('''-07:00''' for MST, '''-08:00''' for PST, '''-06:00''' for CST, '''-05:00''' for EST, etc.)<br>[[File:MySQL Timezone.png]]
 
# Place a checkmark next to '''default-time-zone''' and enter your timezone ('''-07:00''' for MST, '''-08:00''' for PST, '''-06:00''' for CST, '''-05:00''' for EST, etc.)<br>[[File:MySQL Timezone.png]]
 
# Click '''Apply''' and then and close '''MySQLWorkbench'''.
 
# Click '''Apply''' and then and close '''MySQLWorkbench'''.
# [[#Create a new database|Create a new MySQL database]] or [[#Migrate a Firebird database|migrate a Firebird database]].
+
# [[#Create a new database|Create a new MySQL database]].
  
== Create a new database {{top}} ==
+
==Create a new database==
  
 
Follow the instruction below to create a new MySQL database on a Mac.
 
Follow the instruction below to create a new MySQL database on a Mac.
Line 54: Line 67:
 
# Click the Fishbowl Server tray icon and select '''Start'''.
 
# Click the Fishbowl Server tray icon and select '''Start'''.
  
== Migrate a Firebird database {{top}} ==
+
==Database backup==
 
 
'''NOTE:''' This section is only for users that are updating from Fishbowl 2016 to Fishbowl 2017. The [[Updating_to_2017|migration tool]] does not currently work on macOS and will need to be done on a Windows computer. Follow the steps below to complete this process.
 
 
 
# Transfer the '''.FDB''' database file to a Windows computer running Fishbowl 2017.1 or greater.
 
# Open '''C:\Program Files\Fishbowl\server\bin\Database Migration.exe''' and select the '''.FDB''' database file that was transferred.<br>[[File:Data_Migration.png]]
 
# Verify the database name and then click '''OK'''.<br>[[File:Migration Complete.png]]
 
# Double-click the Fishbowl Server icon in the system tray and then click the '''Stop''' button.
 
# Click the '''Tools''' menu and then select '''Options'''.<br>[[File:Server options stop.png]]
 
# Right-click the migrated database and select '''Backup Database'''.<br>[[File:MySQL backup.png]]
 
# Browse to '''C:\Program Files\Fishbowl\data\backups''' and copy the most recent '''.sql''' file to the Mac.
 
# Open the Fishbowl Server Administration ('''/Applications/Fishbowl/server/bin/Fishbowl Server Administration.app''') on the Mac and click the '''Restore''' tab. If the '''Restore''' tab is not visible, download and reinstall the [http://www.fishbowlinventory.com/support/updates/ most recent version] of Fishbowl.
 
# Change the port number to 3306 and enter the secure password that was created earlier.
 
# Select the '''.sql''' file and enter a database name. If the database name already exists, it will be overwritten by the restore.<br>[[File:MySQL Mac restore.png]]
 
# Click the '''Restore''' button.
 
# Click '''OK''' and then start the Fishbowl Server on the Mac.
 
 
 
== Database backup {{top}} ==
 
  
 
A database backup can be created in the {{Module|Schedule}} or by right-clicking the database name in the Fishbowl Server options.
 
A database backup can be created in the {{Module|Schedule}} or by right-clicking the database name in the Fishbowl Server options.
  
[[File:MySQL backup Mac.png]]
+
[[File:MySQL backup.png]]
  
 
The '''.sql''' file created during the backup can then be restored on the '''Restore''' tab.
 
The '''.sql''' file created during the backup can then be restored on the '''Restore''' tab.
  
[[File:MySQL Mac restore.png]]
+
[[File:Restore database.png]]
  
== Troubleshooting {{top}} ==
+
==Troubleshooting==
  
 
Because there are many version combinations for Mac OS X, Fishbowl, and Java, Fishbowl recommends installing the latest version of Fishbowl on the latest version of Mac OS X. If Fishbowl isn't running correctly, some of the steps below may be helpful in troubleshooting.
 
Because there are many version combinations for Mac OS X, Fishbowl, and Java, Fishbowl recommends installing the latest version of Fishbowl on the latest version of Mac OS X. If Fishbowl isn't running correctly, some of the steps below may be helpful in troubleshooting.
  
 
* The MySQL installer will set the port to 3306. When opening database windows, Fishbowl may default to port 3305. Whenever a database window is displayed on a Mac, verify that the port has been changed to 3306 and then enter the secure password that was created during installation.
 
* The MySQL installer will set the port to 3306. When opening database windows, Fishbowl may default to port 3305. Whenever a database window is displayed on a Mac, verify that the port has been changed to 3306 and then enter the secure password that was created during installation.
* '''INSTALL JAVA''' - If Fishbowl isn't running at all, it may be necessary to install Java 8 which can be downloaded by clicking [http://www.oracle.com/technetwork/java/javase/downloads/jre8-downloads-2133155.html#jre-8u121-oth-JPRXXXjre-8u121-macosx-x64.dmg here] and selecting '''jre-8u121-macosx-x64.dmg'''
+
* '''INSTALL JAVA''' - If Fishbowl isn't running at all, it may be necessary to install Java 8 which can be downloaded by clicking [https://www.oracle.com/technetwork/java/javase/downloads/jre8-downloads-2133155.html#jre-8u121-oth-JPRXXXjre-8u121-macosx-x64.dmg here] and selecting '''jre-8u121-macosx-x64.dmg'''
* '''FISHBOWL ANYWHERE''' - To use [[Fishbowl Anywhere]], replace '''Applications/Fishbowl/webclient/bin/start.sh''' with the file in [http://www.fishbowlinventory.com/w/files/Start%20Fishbowl%20Anywhere.zip this zip file]. Follow the instructions above for fixing permissions. Open the Fishbowl Client to enable Fishbowl Anywhere, and set the password. Open the terminal and execute '''start.sh''' using the commands below.
+
* '''FISHBOWL ANYWHERE''' - To use [[Fishbowl Anywhere]], replace '''Applications/Fishbowl/webclient/bin/start.sh''' with the file in [https://www.fishbowlinventory.com/w/files/Start%20Fishbowl%20Anywhere.zip this zip file]. Follow the instructions above for fixing permissions. Open the Fishbowl Client to enable Fishbowl Anywhere, and set the password. Open the terminal and execute '''start.sh''' using the commands below.
 
:'''cd /Applications/Fishbowl/webclient/bin'''
 
:'''cd /Applications/Fishbowl/webclient/bin'''
 
:'''sh /Applications/Fishbowl/webclient/bin/start.sh'''
 
:'''sh /Applications/Fishbowl/webclient/bin/start.sh'''
Line 102: Line 98:
 
# Click '''Local Instance 3306'''. If it prompts to reset the password, enter the password chosen above and verify that it is working correctly.
 
# Click '''Local Instance 3306'''. If it prompts to reset the password, enter the password chosen above and verify that it is working correctly.
  
== Integrate with QuickBooks {{top}} ==
+
==Integrate with QuickBooks==
  
 
QuickBooks Desktop only runs on Windows computers. The Mac version of the Fishbowl Server can integrate with QuickBooks on a Windows computer, or a Mac 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.
 
QuickBooks Desktop only runs on Windows computers. The Mac version of the Fishbowl Server can integrate with QuickBooks on a Windows computer, or a Mac 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.
Line 113: Line 109:
 
# Open the {{Module|Property}} in the Fishbowl Client and double-click '''FBNexusURL''' in the search pane.
 
# Open the {{Module|Property}} in the Fishbowl Client and double-click '''FBNexusURL''' in the search pane.
 
# 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'''.
 
# 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'''.
# Open the {{Module|Accounting}} and run the [[QuickBooks#Integration|QuickBooks Integration Wizard]].
+
# Open the {{Module|Accounting Integration}} and run the [[QuickBooks#Integration|QuickBooks Integration Wizard]].
  
 
You should now be able to export from the Fishbowl Server on Mac to the QuickBooks installation on Windows.
 
You should now be able to export from the Fishbowl Server on Mac to the QuickBooks installation on Windows.
  
== Integrate with QuickBooks Online {{top}} ==
+
==Integrate with QuickBooks Online==
  
Because QuickBooks Online is web-based, integration is not dependent on the operating system. Simply open the {{Module|Accounting}} and run the [[QuickBooks Online#Integration|QuickBooks Online Integration Wizard]].
+
Because QuickBooks Online is web-based, integration is not dependent on the operating system. Simply open the {{Module|Accounting Integration}} and run the [[QuickBooks Online#Integration|QuickBooks Online Integration Wizard]].
  
== Integrate with Xero {{top}} ==
+
==Integrate with Xero==
  
Because Xero is web-based, integration is not dependent on the operating system. Simply open the {{Module|Accounting}} and run the [[Xero#Integration|Xero Integration Wizard]].
+
Because Xero is web-based, integration is not dependent on the operating system. Simply open the {{Module|Accounting Integration}} and run the [[Xero#Integration|Xero Integration Wizard]].

Latest revision as of 18:43, 23 August 2021

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

Apple M1 chip

  • To install the Fishbowl Server on a Mac with the M1 chip, follow the additional instructions listed in Homebrew.
  • For Macs with the M1 chip that will only be using the Fishbowl Client, the standard installation will work.
  • If the Fishbowl Installer fails to install Java on a Mac with the M1 chip, the installer for Java 8 on ARM processors can be downloaded by clicking here.

Install Fishbowl

The Fishbowl installer includes a copy of Java, so in most cases, it is not necessary to install Java separately. For newer Macs with the M1 processor, see Apple M1 chip.

  1. NOTE: If the Fishbowl Server is being installed for the first time on a Mac, 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.
  2. Download the Fishbowl Installer for Mac by clicking here.
  3. Right-click the Fishbowl Installer and select Open.
    Mac right-click.png
  4. When asked if you want to open the Fishbowl Installer, click Open.
    Mac open installer.png
    If the Open button is not visible, repeat step 3 or adjust your security preferences for installing apps.
  5. You will be asked to enter your password to run the installer. If that doesn't work, you can run the installer as the root user as described here.
  6. Select 14 Day Fishbowl Trial or Current Fishbowl User and then complete the installation wizard.
    Current Fishbowl User.png
  7. NOTE: This step is not necessary for Fishbowl 2021.6 or greater
    In Finder, open the Applications folder. Right-click the Fishbowl folder and select Get Info. Click the lock icon and then assign the Read & Write privilege to all users listed. Then click the gear icon and select Apply to enclosed items.
    Fishbowl Permissions for Mac.png
  8. Start Fishbowl using the shortcuts created on the desktop. Fishbowl can also be opened with Applications/Fishbowl/server/bin/Fishbowl Server and Applications/Fishbowl/client/bin/Fishbowl Client.

Install MySQL for Fishbowl Server

If the Fishbowl Server is being installed for the first time on a Mac, MySQL will need to be installed and configured. MySQL does not need to be installed if only the Fishbowl Client is being installed.

We recommend installing MySQL with Homebrew by following the instructions here.

If Homebrew doesn't work, the installer can be manually downloaded and and configured using the instructions below.

  1. Complete the Fishbowl installation for Mac.
  2. Click here to download the MySQL installer.
  3. Have your IT administrator install and configure MySQL 5.7 on the Mac that will be running the Fishbowl Server.
  4. During installation, a temporary password will be created. Save this password for use in later steps.
    MySQL temporary password.png
  5. Open System Preferences, click MySQL, and then click Start MySQL Server.
    Start MySQL Mac.png
  6. Download MySQLWorkbench 8.0.21. Click here and select 8.0.21.
  7. Open the downloaded .dmg file and double-click MySQLWorkbench. Moving the application to the Applications folder is optional.
  8. Click Local Instance 3306. If Local Instance 3306 is not listed, click the + icon to create a new MySQL connection.
    MySQL Instance.png
  9. Enter the temporary password and then create a new secure password.
    New MySQL password.png
    • Sometimes MySQLWorkbench won't prompt to reset the password or the new password may not save correctly. If that is the case and you still can't restore/create a new database in the Fishbowl Server Administration window, then follow the MySQL password reset instructions in the Troubleshooting section.

Follow the steps below to configure the my.cnf file. NOTE: These steps are not necessary if you followed the Homebrew instructions.

  1. Stop the MySQL service either through command line or by clicking Apple > System Preferences > MySQL and click Stop MySQL Server.
  2. Open Finder and press command + shift + g (or click the Go menu > Go to Folder). Type /usr/local/mysql/support-files and then click Go.
  3. Copy the my-default.cnf file.
  4. Press command + shift + g again, type /etc and then click Go. Paste the my-default.cnf file that was copied in the previous step.
  5. Rename the file to my.cnf.
  6. Right-click the /etc/my.cnf file, click Get Info, and then change the permissions to Read Only for everything but System.
  7. Start the MySQL service.
  8. Open MySQLWorkbench and click the wrench icon.
    MySQL wrench.png
  9. Select the connection on the left and click the System Profile tab. Type the configuration file path as shown below.
    MySQL System Profile.png
  10. Click Test Connection and then click Close.
  11. Open Local Instance 3306 and click Options File on the left side.
  12. Place a checkmark next to default-time-zone and enter your timezone (-07:00 for MST, -08:00 for PST, -06:00 for CST, -05:00 for EST, etc.)
    MySQL Timezone.png
  13. Click Apply and then and close MySQLWorkbench.
  14. Create a new MySQL database.

Create a new database

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

  1. Click the Fishbowl Server tray icon and select Options.
  2. Click the New Icon Button.png New button and enter a new database name
  3. Change the port number to 3306 and enter the secure password that was created earlier.
    New MySQL database Mac.png
  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 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

Troubleshooting

Because there are many version combinations for Mac OS X, Fishbowl, and Java, Fishbowl recommends installing the latest version of Fishbowl on the latest version of Mac OS X. If Fishbowl isn't running correctly, some of the steps below may be helpful in troubleshooting.

  • The MySQL installer will set the port to 3306. When opening database windows, Fishbowl may default to port 3305. Whenever a database window is displayed on a Mac, verify that the port has been changed to 3306 and then enter the secure password that was created during installation.
  • INSTALL JAVA - If Fishbowl isn't running at all, it may be necessary to install Java 8 which can be downloaded by clicking here and selecting jre-8u121-macosx-x64.dmg
  • FISHBOWL ANYWHERE - To use Fishbowl Anywhere, replace Applications/Fishbowl/webclient/bin/start.sh with the file in this zip file. Follow the instructions above for fixing permissions. Open the Fishbowl Client to enable Fishbowl Anywhere, and set the password. Open the terminal and execute start.sh using the commands below.
cd /Applications/Fishbowl/webclient/bin
sh /Applications/Fishbowl/webclient/bin/start.sh

MySQL password reset

Sometimes MySQLWorkbench won't prompt to reset the password or the new password may not save correctly. If that is the case, follow the instructions below to reset the password using the Terminal application.

  1. Open Terminal and enter the following command.
    sudo /usr/local/mysql/support-files/mysql.server stop
  2. Restart the MySQL server with permissions by entering the following command.
    sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables
  3. Open a new Terminal window by pressing command + n.
  4. In the new Terminal window, reset the MySQL password by replacing NewPassword with your own password in the following command.
    sudo /usr/local/mysql/bin/mysql -u root
    UPDATE mysql.user SET authentication_string=PASSWORD('NewPassword') WHERE User='root';
    FLUSH PRIVILEGES;
    \q
  5. Close both Terminal windows and open MySQLWorkbench.
  6. Click Local Instance 3306. If it prompts to reset the password, enter the password chosen above and verify that it is working correctly.

Integrate with QuickBooks

QuickBooks Desktop only runs on Windows computers. The Mac version of the Fishbowl Server can integrate with QuickBooks on a Windows computer, or a Mac 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 a Mac to communicate with a Windows QuickBooks installation.

  1. Copy Fishbowl Nexus.exe from the Mac (Applications/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 Mac.
  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 Mac 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.

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.