Adoptable Cookbooks List

Looking for a cookbook to adopt? You can now see a list of cookbooks available for adoption!
List of Adoptable Cookbooks

Supermarket Belongs to the Community

Supermarket belongs to the community. While Chef has the responsibility to keep it running and be stewards of its functionality, what it does and how it works is driven by the community. The chef/supermarket repository will continue to be where development of the Supermarket application takes place. Come be part of shaping the direction of Supermarket by opening issues and pull requests or by joining us on the Chef Mailing List.

Select Badges

Select Supported Platforms

RSS

arcgis-egdb (2) Versions 1.0.1

Creates enterprise geodatabases in SQL Server or PostgreSQL DBMS and registers them with ArcGIS Server.

Berkshelf
Policyfile
Knife
cookbook 'arcgis-egdb', '~> 1.0.1'
cookbook 'arcgis-egdb', '~> 1.0.1', :supermarket
knife supermarket install arcgis-egdb
knife supermarket download arcgis-egdb
README
Dependencies
Changelog
Quality 38%

arcgis-egdb

arcgis-egdb cookbook creates enterprise geodatabases in SQL Server or PostgreSQL DBMS and registers them with ArcGIS Server.

Platforms

  • Windows 7
  • Windows 8 (8.1)
  • Windows 10
  • Windows Server 2008 (R2)
  • Windows Server 2012 (R2)
  • Windows Server 2016
  • Windows Server 2019
  • Ubuntu 14.04, 16.04, 18.04
  • RHEL 6.5, 7.0

Database Servers

The cookbook was tested with:

  • Amazon RDS for SQL Server
  • Amazon RDS for PostgerSQL
  • Amazon Aurora PostgerSQL-compatible

Dependencies

The following cookbooks are required:

  • arcgis-enterprise

The cookbook uses ArcPy to create and enable geodatabases. ArcPy is installed by ArcGIS Server setup.

ArcPy does not support creating databases in Amazon RDS database servers. The cookbook uses sqlcmd and pqsl utility for SQL Server and PostgreSQL database servers to create the databases. 'sqlcmd' and 'psql' recipes could be used to install these utilities. ArcGIS DataStore and Portal for ArcGIS include embedded PostgreSQl client with psql utility, that can be used by arcgis-egdb cookbook.

Attributes

  • node['arcgis']['egdb']['engine'] = DB engine <nil|postgres|sqlserver-se>. Default DB engine is nil.
  • node['arcgis']['egdb']['endpoint'] = DB instance endpoint domain name. Default endpoint is nil.
  • node['arcgis']['egdb']['keycodes'] = Geodatabase license file path. Default path is node['arcgis']['server']['keycodes'].
  • node['arcgis']['egdb']['master_username'] = RDS DB instance master username. Default username is EsriRDSAdmin.
  • node['arcgis']['egdb']['master_password'] = RDS DB instance master user password. Default password is nil.
  • node['arcgis']['egdb']['db_username'] = Geodatabase username. Default username is sde.
  • node['arcgis']['egdb']['db_password'] = Geodatabase user password. Default password is node['arcgis']['egdb']['master_password'].
  • node['arcgis']['egdb']['postgresbin'] = Path to PostgreSQL client bin directory. Default path s C:\Program Files\ArcGIS\DataStore\framework\runtime\pgsql\bin on wondows and /arcgis/datastore/framework/runtime/pgsql/bin on Linux.
  • node['arcgis']['egdb']['connection_files_dir'] = Directory path for geodatabase connection files created by the recipes. Default directory is node['arcgis']['misc']['scripts_dir']/connection_files.
  • node['arcgis']['egdb']['data_items'] = Array with properties of geodatabases. Default value is
  [{
    "database" : "egdb",
    "data_item_path" : "/enterpriseDatabases/registeredDatabase",
    "connection_file": "C:\\chef\\msic_scripts\\connection_files\\RDS_egdb.sde",
    "is_managed" : true,
    "connection_type" : "shared"
  }]

Recipes

arcgis-egdb::default

Creates EGDBs and registers them with ArcGIS Server.

arcgis-egdb::sql_alias

Creates EGDBHOST alias for SQL Server endpoint domain.

arcgis-egdb::egdb_postgres

Creates EGDBs in PostgreSQL.

arcgis-egdb::egdb_sqlserver

Creates EGDBs in SQL Server.

arcgis-egdb::register_egdb

Registers EGDBs with ArcGIS Server.

arcgis-egdb::sqlcmd

Installs sqlcmd utility used by SQL Server EGDB configuration scripts.

Usage

{
  "arcgis": {
    "version": "10.7",
    "server": {
      "private_url": "https://domain.com:6443/arcgis",
      "admin_username": "admin",
      "admin_password": "changeit"
    },
    "python": {
      "runtime_environment": "C:\\Python27\\ArcGISx6410.7"
    },
    "misc": {
      "scripts_dir": "C:\\chef\\misc_scripts"
    },
    "egdb": {
      "engine": "postgres",
      "endpoint": "xxx.cluster-yyy.us-east-2.rds.amazonaws.com",
      "keycodes": "C:\\Program Files\\ESRI\\License10.7\\sysgen\\keycodes",
      "master_username": "EsriRDSAdmin",
      "master_password": "changeit",
      "db_username": "sde",
      "db_password": "changeit",
      "connection_files_dir": "C:\\chef\\misc_scripts\\connection_files",
      "data_items": [{
        "database": "egdb",
        "data_item_path": "/enterpriseDatabases/registeredDatabase",
        "connection_file": "C:\\chef\\msic_scripts\\connection_files\\RDS_egdb.sde",
        "is_managed": true,
        "connection_type": "shared"
      }]
    }
  },
  "run_list": [
    "recipe[arcgis-egdb]"
  ]
}

See wiki pages for more information about using ArcGIS cookbooks.

Issues

Find a bug or want to request a new feature? Please let us know by submitting an issue.

Contributing

Esri welcomes contributions from anyone and everyone. Please see our guidelines for contributing.

Licensing

Copyright 2019 Esri

Licensed under the Apache License, Version 2.0 (the "License"); You may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

A copy of the license is available in the repository's License.txt file.

[](Esri Tags: ArcGIS GeoDatabase Server Chef Cookbook) [](Esri Language: Ruby)

Dependent cookbooks

arcgis-enterprise ~> 3.4

Contingent cookbooks

There are no cookbooks that are contingent upon this one.

arcgis-egdb cookbook CHANGELOG

This file is used to list changes made in each version of the arcgis-egdb cookbook.

1.0.1

  • Updated and locked versions of dependent cookbooks.

1.0.0

  • Initial release of the cookbook.

Collaborator Number Metric
            

1.0.1 failed this metric

Failure: Cookbook has 0 collaborators. A cookbook must have at least 2 collaborators to pass this metric.

Contributing File Metric
            

1.0.1 failed this metric

Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must contain a CONTRIBUTING.md file

Foodcritic Metric
            

1.0.1 failed this metric

FC069: Ensure standardized license defined in metadata: arcgis-egdb/metadata.rb:1
Run with Foodcritic Version 14.3.0 with tags metadata,correctness ~FC031 ~FC045 and failure tags any

No Binaries Metric
            

1.0.1 passed this metric

Publish Metric
            

1.0.1 passed this metric

Supported Platforms Metric
            

1.0.1 passed this metric

Testing File Metric
            

1.0.1 failed this metric

Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must contain a TESTING.md file

Version Tag Metric
            

1.0.1 failed this metric

Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must include a tag that matches this cookbook version number