When the Fishbowl Server is installed, the Fishbowl Server Administration application is also installed. This application provides an interface for creating databases, modifying server settings, changing the license key, and performing database maintenance.
Stop the Fishbowl Server
If the Fishbowl Server is started, the Fishbowl Server Administration can be viewed, but changes cannot be made. To make changes, first stop the Fishbowl server using one of the methods below.
- Right-click the Fishbowl Server icon in the system tray and click Stop.
- Double-click the Fishbowl Server icon in the system tray and then click the Stop button.
Start Fishbowl Server Administration
Below are are several ways to start the Fishbowl Server Administration.
- Click the Start menu, select the Fishbowl program folder, and then click Fishbowl Server Administration.
- Browse to C:\Program Files\Fishbowl\server\bin\ and then double-click Fishbowl Server Administration.exe.
- Right-click the Fishbowl Server icon in the system tray and choose Options.
- Double-click the Fishbowl Server icon in the system tray, click the Tools menu, and then select Options.
This tab provides access to several database features.
- Create a new database
- Connect to an existing database
- Perform database maintenance
- Create a database backup
- Rebuild Database
When using Fishbowl for the first time, many companies will create a sandbox database to help train their employees. They may import their actual data (customers, users, parts, etc.) and then decide they want to use this same data in their live database. The Rebuild Database tool allows companies to create a new database with all of that data, but exclude the inventory and orders that were created during the training period.
To rebuild a database, you must first stop the Fishbowl Server. Then on the Database tab, you can right-click the database and select Rebuild Database. Depending on the size of your database, it could take several minutes to copy all of the data over into a new database.
- The Server Port can be changed to a different port number. This can also allow multiple Fishbowl Servers to run on the same computer.
- Inactivity time can be extended as described here.
- Broadcast Server Location allows the Fishbowl Server to be found by clicking the Find Fishbowl Servers button from the login window.
- To prevent a user from logging in on multiple computers, enable Users can only be logged in once.
- Server memory can be adjusted as described here.
- More information about Auto Updates is available here.
- The Web Port is used for the Fishbowl web server that allows REST API access. The REST API is in beta.
- API documentation can only be accessed when the Fishbowl Server is running.
- To see the documentation on the Fishbowl Server computer, click the following link: http://localhost:80/apidocs
- To see the documentation from other computers on the network, enter the IP address of the Fishbowl Server computer, replacing 80 with your Web Port. For example: 192.168.29.37:80/apidocs
- To use a Secure Web Connection, select a .JKS certificate file. The certificate can be self-signed or purchased online from a Certificate Authority.
- This tab is used to enter or change a license key.
- This tab provides the ability to restore a database backup and adjust the MySQL settings.