Part 4: Opening Ports for the Firebird Database

Part 4: Opening Ports for the Firebird Database

Option 1

  • Copy the text below into a text file and name it “FirebirdPorts.bat
  • Right Click the file and Run as Administrator

ECHO OFF
set PORT=3050
set RULE_NAME="Firebird Primary"

netsh advfirewall firewall show rule name=%RULE_NAME% >nul
if not ERRORLEVEL 1 (
    rem Rule %RULE_NAME% already exists.
    echo There is already a rule by that name, you cannot put another one in!
) else (
    echo Rule %RULE_NAME% does not exist. Creating...
    netsh advfirewall firewall add rule name=%RULE_NAME% dir=in action=allow protocol=TCP localport=%PORT%
)

set PORT1=4560
set RULE_NAME1="Firebird Guardian"

netsh advfirewall firewall show rule name=%RULE_NAME1% >nul
if not ERRORLEVEL 1 (
    rem Rule %RULE_NAME1% already exists.
    echo There is already a rule by that name, you cannot put another one in!
) else (
    echo Rule %RULE_NAME1% does not exist. Creating...
    netsh advfirewall firewall add rule name=%RULE_NAME1% dir=in action=allow protocol=TCP localport=%PORT1%
)
PAUSE

Alternatively, download the attached FirebirdPorts.bat file and Run as Administrator

Option 2

  • Go to Control Panel\System and Security\Windows Firewall
  • Click Check on Firewall Status.
  • Click on Advanced Settings
  • Click on Inbound Rules

  • Click on New Rule
  • The dialogue box will open.
  • Click on Port, then click next.
  • Tick TCP, then Specific Port. Type, “3050” then hit next
  • Click “Allow the Connection” then “Next”
  • Leave Domain, Private, Public all ticked.
  • Click Next
  • Name the firewall exception Firebird Primary and select finish.
  • The Port is now excepted.
  • Add another inbound rule named “Firebird Guardian”, with a Port number of “4560”

Once Firebird Guardian is made an exception through the firewall.

  • Navigate to C:\Program Files (x86)\Firebird\Firebird_*_*\Firebird.conf
  • Right click Firebird.conf and Select Open

 

  • Select Notepad to open the File and View.
  • Click Edit & Find, Type 3050 & Click Find Next
  • You will see 3050 highlight and the line stating “#RemoteServicePort = 3050
  • Remove the # from the line.
  • Line should now read RemoteServicePort = 3050
  • Scroll down in the file and find #RemoteAuxPort = 0
  • Rename this line to “RemoteAuxPort = 4560”
  • You will need to do this on each PC running Focus suite.

 

You have now allowed exceptions for the Firebird ports.


Continue to Part 5 Registering the Firebird database

PART 1: Installing Firebird Database

https://help.idealpos.co/part-1-installing-firebird-database


PART 2: Installing Focus Suite

https://help.idealpos.co/part-2-installing-focus-suite


PART 3: Grant Windows permissions on Idealpos & POSTEC Related Folders

https://help.idealpos.co/part-3-grant-windows-permissions-on-idealpos-postec-related-folders


PART 4: Opening Ports for the Firebird Database | Specify Ports for Firebird

https://help.idealpos.co/part-4-opening-ports-for-the-firebird-database


PART 5: Registering the Firebird Database

https://help.idealpos.co/part-5-registering-the-firebird-database


PART 6: PCC Network Setup & Connection Wizard (Single and MultiPOS)

https://help.idealpos.co/part-6-pcc-network-setup-connection-wizard


PART 7: Request Forecourt Configuration from the PCC

https://help.idealpos.co/part-7-request-forecourt-configuration-from-the-pcc


PART 8: Installing POSTEC License file

https://help.idealpos.co/part-8-installing-postec-licence-file


PART 9: Forecourt Manager- Add User Profiles & Attendants

https://help.idealpos.co/part-9-forecourt-manager-add-user-profiles-attendants


PART 10: Setting up Integration Mode / Adjusting Visual Console Appearance 

https://help.idealpos.co/part-10-setting-up-integration-mode-/-adjusting-visual-console-appearance


PART 11: Idealpos Configuration and Start up sequence.

https://help.idealpos.co/part-11-idealpos-configuration-and-start-up-sequence


PART 12: Configuring the Master Database
https://help.idealpos.co/configuring-postec-master-database

PART 13: Setting up Windows Sharing for Master Database Configuration
https://help.idealpos.co/setting-up-windows-sharing-for-master-database-configuration

 

FirebirdPorts.bat