954

Downloads

119

Downloads of v 3.0.2

5/2/2017

Last update

Firebird Database Server

3.0.2

This package was approved by moderator flcdrg on 6/7/2017.

Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers.

Package Parameters

The following package parameters can be set:

/SuperClassic - Installs Firebird SuperClassic (default: SuperServer)
/Classic - Installs Firebird Classic
/ClientOnly - Installs client .DLLs only
/ClientAndDevTools - Installs client .DLLs and development tools

These parameters can be passed to the installer with the use of -params.
For example: -params '/SuperClassic'.

To install Firebird Database Server, run the following command from the command line or from PowerShell:

C:\> choco install firebird

To upgrade Firebird Database Server, run the following command from the command line or from PowerShell:

C:\> choco upgrade firebird

Files

Hide

tools\chocolateyInstall.ps1 Show

$packageName = 'firebird'

$version = '3.0.2'
$url = 'https://downloads.sourceforge.net/project/firebird/firebird-win32/3.0.2-Release/Firebird-3.0.2.32703_0_Win32.exe'
$url64 = 'https://downloads.sourceforge.net/project/firebird/firebird-win64/3.0.2-Release/Firebird-3.0.2.32703_0_x64.exe'
$checksum = 'DC2250C8740ADFE1F0936A90102CC1546A189FFD2500984A90AD28EEDC4257CB'
$checksum64 = 'BBECFA0DA9DE5CFA52269A07EBDBC3A0C4D68BC028D0511CCEE3EB89FEECD07C'
$checksumType = 'sha256'
$installerName = 'Firebird-3.0.2.32703_0.exe'

$installerType = 'exe'
$installerFullName = Join-Path $env:TEMP $installerName

function Get-FirebirdPath
{
    $HKLMFirebirdInstancesKey = 'HKLM:\Software\Firebird Project\Firebird Server\Instances'
    $instances = Get-ItemProperty -Path "$HKLMFirebirdInstancesKey" -ErrorAction SilentlyContinue

    if (-not $instances) {
        # Not found. Try to search for a 32-bit install in a 64-bit architecture.

        $HKLMFirebirdInstancesKey = 'HKLM:\Software\Wow6432Node\Firebird Project\Firebird Server\Instances'
        $instances = Get-ItemProperty -Path "$HKLMFirebirdInstancesKey" -ErrorAction SilentlyContinue
    }

    if ($instances) {
        Write-Host "Firebird installation path: $($instances.DefaultInstance)"
        $instances.DefaultInstance
    } else {
        Write-Host "Firebird is NOT installed."
        $null
    }
}

function Download-FirebirdInstaller
{
    Write-Host "Downloading installer file: $installerFullName"
    Get-ChocolateyWebFile -PackageName $packageName -FileFullPath $installerFullName `
                          -Url $url -Url64bit $url64 `
                          -Checksum $checksum -ChecksumType $checksumType -Checksum64 $checksum64 -ChecksumType64 $checksumType
}

function Uninstall-Firebird
{
    $firebirdPath = Get-FirebirdPath

    if ($firebirdPath) {
        if (Get-Service -Name FirebirdServerDefaultInstance -ErrorAction SilentlyContinue) {
            Write-Host "Stopping Firebird service..."
            Stop-Service -Name FirebirdServerDefaultInstance
        }

        $uninstallers = Join-Path $firebirdPath 'unins*.exe'
        $lastUninstaller = Get-Item $uninstallers | Sort-Object LastWriteTime | Select-Object -Last 1
        $uninstallerArgs = '/VERYSILENT',
                           '/NORESTART',
                           '/SUPPRESSMSGBOXES'
        
        Write-Host "Calling uninstaller: $($lastUninstaller.FullName)"
        Uninstall-ChocolateyPackage -PackageName $packageName -FileType $installerType `
                                    -SilentArgs $uninstallerArgs -File $lastUninstaller.FullName
    }
}

function Install-Firebird
{
    Download-FirebirdInstaller

    Uninstall-Firebird

    if ($env:chocolateyPackageParameters -contains '/ClientOnly') {
        Write-Host 'Installing Firebird Client...'
        $serverTypeComponent = 'ClientComponent,'
        $serverTypeTask = ''
    } elseif ($env:chocolateyPackageParameters -contains '/ClientAndDevTools') {
        Write-Host 'Installing Firebird Client and Development tools...'
        $serverTypeComponent = 'ClientComponent,DevAdminComponent,'
        $serverTypeTask = ''
    } else {
        if ($version -lt '3') {
            # Firebird <= 2.5
            if ($env:chocolateyPackageParameters -contains '/SuperClassic') {
                Write-Host 'Installing Firebird SuperClassic...'
                $serverTypeComponent = 'ServerComponent\ClassicServerComponent,'
                $serverTypeTask = 'SuperClassicTask,'
            } elseif ($env:chocolateyPackageParameters -contains '/Classic') {
                Write-Host 'Installing Firebird Classic...'
                $serverTypeComponent = 'ServerComponent\ClassicServerComponent,'
                $serverTypeTask = ''
            } else {
                Write-Host 'Installing Firebird SuperServer...'
                $serverTypeComponent = 'ServerComponent\SuperServerComponent,'
                $serverTypeTask = ''
            }
        } else {
            # Firebird >= 3.0        
            if ($env:chocolateyPackageParameters -contains '/SuperClassic') {
                Write-Host 'Installing Firebird SuperClassic...'
                $serverTypeComponent = 'ServerComponent,'
                $serverTypeTask = 'UseSuperClassicTask,'
            } elseif ($env:chocolateyPackageParameters -contains '/Classic') {
                Write-Host 'Installing Firebird Classic...'
                $serverTypeComponent = 'ServerComponent,'
                $serverTypeTask = 'UseClassicServerTask,'
            } else {
                Write-Host 'Installing Firebird SuperServer...'
                $serverTypeComponent = 'ServerComponent,'
                $serverTypeTask = 'UseSuperServerTask,'
            }
        }

        # Server installation: always with admin components.
        $serverTypeComponent += 'DevAdminComponent,'
    }

    # Install server with legacy client authentication (3.0+) and copy fbclient.dll & gds32.dll into System folder.
    $installerArgs = '/SP-', 
                     '/VERYSILENT', 
                     '/NORESTART',
                     '/NOICONS',
                     '/SUPPRESSMSGBOXES',
                     '/COMPONENTS="' + $serverTypeComponent + 'ClientComponent"',
                     '/TASKS="' + $serverTypeTask + 'UseServiceTask,AutoStartTask,|UseGuardianTask,|InstallCPLAppletTask,|MenuGroupTask,CopyFbClientToSysTask,CopyFbClientAsGds32Task,EnableLegacyClientAuth"'

    Install-ChocolateyInstallPackage -PackageName $packageName -FileType $installerType `
                                     -SilentArgs $installerArgs -File $installerFullName
}


Install-Firebird

tools\chocolateyUninstall.ps1 Show

$packageName = 'firebird'

$version = '3.0.2'
$url = 'https://downloads.sourceforge.net/project/firebird/firebird-win32/3.0.2-Release/Firebird-3.0.2.32703_0_Win32.exe'
$url64 = 'https://downloads.sourceforge.net/project/firebird/firebird-win64/3.0.2-Release/Firebird-3.0.2.32703_0_x64.exe'
$checksum = 'DC2250C8740ADFE1F0936A90102CC1546A189FFD2500984A90AD28EEDC4257CB'
$checksum64 = 'BBECFA0DA9DE5CFA52269A07EBDBC3A0C4D68BC028D0511CCEE3EB89FEECD07C'
$checksumType = 'sha256'
$installerName = 'Firebird-3.0.2.32703_0.exe'

$installerType = 'exe'
$installerFullName = Join-Path $env:TEMP $installerName

function Get-FirebirdPath
{
    $HKLMFirebirdInstancesKey = 'HKLM:\Software\Firebird Project\Firebird Server\Instances'
    $instances = Get-ItemProperty -Path "$HKLMFirebirdInstancesKey" -ErrorAction SilentlyContinue

    if (-not $instances) {
        # Not found. Try to search for a 32-bit install in a 64-bit architecture.

        $HKLMFirebirdInstancesKey = 'HKLM:\Software\Wow6432Node\Firebird Project\Firebird Server\Instances'
        $instances = Get-ItemProperty -Path "$HKLMFirebirdInstancesKey" -ErrorAction SilentlyContinue
    }

    if ($instances) {
        Write-Host "Firebird installation path: $($instances.DefaultInstance)"
        $instances.DefaultInstance
    } else {
        Write-Host "Firebird is NOT installed."
        $null
    }
}

function Download-FirebirdInstaller
{
    Write-Host "Downloading installer file: $installerFullName"
    Get-ChocolateyWebFile -PackageName $packageName -FileFullPath $installerFullName `
                          -Url $url -Url64bit $url64 `
                          -Checksum $checksum -ChecksumType $checksumType -Checksum64 $checksum64 -ChecksumType64 $checksumType
}

function Uninstall-Firebird
{
    $firebirdPath = Get-FirebirdPath

    if ($firebirdPath) {
        if (Get-Service -Name FirebirdServerDefaultInstance -ErrorAction SilentlyContinue) {
            Write-Host "Stopping Firebird service..."
            Stop-Service -Name FirebirdServerDefaultInstance
        }

        $uninstallers = Join-Path $firebirdPath 'unins*.exe'
        $lastUninstaller = Get-Item $uninstallers | Sort-Object LastWriteTime | Select-Object -Last 1
        $uninstallerArgs = '/VERYSILENT',
                           '/NORESTART',
                           '/SUPPRESSMSGBOXES'
        
        Write-Host "Calling uninstaller: $($lastUninstaller.FullName)"
        Uninstall-ChocolateyPackage -PackageName $packageName -FileType $installerType `
                                    -SilentArgs $uninstallerArgs -File $lastUninstaller.FullName
    }
}

function Install-Firebird
{
    Download-FirebirdInstaller

    Uninstall-Firebird

    if ($env:chocolateyPackageParameters -contains '/ClientOnly') {
        Write-Host 'Installing Firebird Client...'
        $serverTypeComponent = 'ClientComponent,'
        $serverTypeTask = ''
    } elseif ($env:chocolateyPackageParameters -contains '/ClientAndDevTools') {
        Write-Host 'Installing Firebird Client and Development tools...'
        $serverTypeComponent = 'ClientComponent,DevAdminComponent,'
        $serverTypeTask = ''
    } else {
        if ($version -lt '3') {
            # Firebird <= 2.5
            if ($env:chocolateyPackageParameters -contains '/SuperClassic') {
                Write-Host 'Installing Firebird SuperClassic...'
                $serverTypeComponent = 'ServerComponent\ClassicServerComponent,'
                $serverTypeTask = 'SuperClassicTask,'
            } elseif ($env:chocolateyPackageParameters -contains '/Classic') {
                Write-Host 'Installing Firebird Classic...'
                $serverTypeComponent = 'ServerComponent\ClassicServerComponent,'
                $serverTypeTask = ''
            } else {
                Write-Host 'Installing Firebird SuperServer...'
                $serverTypeComponent = 'ServerComponent\SuperServerComponent,'
                $serverTypeTask = ''
            }
        } else {
            # Firebird >= 3.0        
            if ($env:chocolateyPackageParameters -contains '/SuperClassic') {
                Write-Host 'Installing Firebird SuperClassic...'
                $serverTypeComponent = 'ServerComponent,'
                $serverTypeTask = 'UseSuperClassicTask,'
            } elseif ($env:chocolateyPackageParameters -contains '/Classic') {
                Write-Host 'Installing Firebird Classic...'
                $serverTypeComponent = 'ServerComponent,'
                $serverTypeTask = 'UseClassicServerTask,'
            } else {
                Write-Host 'Installing Firebird SuperServer...'
                $serverTypeComponent = 'ServerComponent,'
                $serverTypeTask = 'UseSuperServerTask,'
            }
        }

        # Server installation: always with admin components.
        $serverTypeComponent += 'DevAdminComponent,'
    }

    # Install server with legacy client authentication (3.0+) and copy fbclient.dll & gds32.dll into System folder.
    $installerArgs = '/SP-', 
                     '/VERYSILENT', 
                     '/NORESTART',
                     '/NOICONS',
                     '/SUPPRESSMSGBOXES',
                     '/COMPONENTS="' + $serverTypeComponent + 'ClientComponent"',
                     '/TASKS="' + $serverTypeTask + 'UseServiceTask,AutoStartTask,|UseGuardianTask,|InstallCPLAppletTask,|MenuGroupTask,CopyFbClientToSysTask,CopyFbClientAsGds32Task,EnableLegacyClientAuth"'

    Install-ChocolateyInstallPackage -PackageName $packageName -FileType $installerType `
                                     -SilentArgs $installerArgs -File $installerFullName
}


Uninstall-Firebird

Virus Scan Results

firebird.3.0.2.nupkg (5b303070e31a) - ## / 59 - Log in or click on link to see number of positives
Firebird-3.0.2.32703_0_x64.exe (bbecfa0da9de) - ## / 62 - Log in or click on link to see number of positives
Firebird-3.0.2.32703_0_Win32.exe (dc2250c8740a) - ## / 62 - Log in or click on link to see number of positives

In cases where actual malware is found, the packages are subject to removal. Software sometimes has false positives. Moderators do not necessarily validate the safety of the underlying software, only that a package retrieves software from the official distribution point and/or validate embedded software against official distribution point (where distribution rights allow redistribution).

Chocolatey Pro provides runtime protection from possible malware.

Dependencies

This package has no dependencies.

Maintainer(s)

fdcastel

Software Author(s)

Firebird Project

Release Notes

http://www.firebirdsql.org/file/documentation/releasenotes/html/en/30/rlsnotes30.html

Version History

Version	Downloads	Last updated	Status
Firebird Database Server 3.0.2	119	Tuesday, May 2, 2017	approved
Firebird Database Server 3.0.1.1000	126	Saturday, February 4, 2017	approved
Firebird Database Server 2.5.7.1000	52	Monday, February 27, 2017	approved
Firebird Database Server 2.5.6.1000	28	Saturday, February 4, 2017	approved
Firebird Database Server 2.1.7.1000	42	Saturday, February 4, 2017	approved

Discussion for the Firebird Database Server Package

Ground rules:

This discussion is only about Firebird Database Server and the Firebird Database Server package. If you have feedback for Chocolatey, please contact the google group.
This discussion will carry over multiple versions. If you have a comment about a particular version, please note that in your comments.
The maintainers of this Chocolatey Package will be notified about new comments that are posted to this Disqus thread, however, it is NOT a guarantee that you will get a response. If you do not hear back from the maintainers after posting a message below, please follow up by using the link on the left side of this page or follow this link to contact maintainers. If you still hear nothing back, please follow the package triage process.
Tell us what you love about the package or Firebird Database Server, or tell us what needs improvement.
Share your experiences with the package, or extra configuration or gotchas that you've found.
If you use a url, the comment will be flagged for moderation until you've been whitelisted. Disqus moderated comments are approved on a weekly schedule if not sooner. It could take between 1-5 days for your comment to show up.