Install Driver Manager (in Terminal) brew update & brew install unixODBC Install driver manager (iodbc, unixodbc).Grant the new user privileges to the database.Install PostgreSQL via Installer (MacOS), hombrew (MacOS) or apt-get (Ubuntu).PostgreSQL Install and Run PostgreSQL (MacOS/Ubuntu) In R install.packages(c('jsonlite', 'mongolite')) In Terminal (if necessary) sudo apt-get libssl-dev Require or library jsonlite and mongolite.# pin the current version so that it doesn't auto-updateĮcho 'mongodb hold' | sudo dpkg -set-selectionsĮcho 'mongodb-server hold' | sudo dpkg -set-selections Sudo apt-key adv -keyserver hkp://:80 -recv 7F0CEB10Įcho 'deb '$(lsb_release -sc)'/mongodb-org/3.0 multiverse' This is also in the Terminal # get a public key from MongoDB Sudo chown $(whoami):admin /usr/local & sudo chown -R $(whoami):admin /usr/local This is all in the Terminal # give yourself ownership of /usr/local Give yourself ownership of the /usr/local folder againĬreate a data directory and give proper permissions Calling from and saving to your DB from Shiny.Shiny + Databases Shiny + Databases MongoDB and PostgreSQLĬhristina Brady Data Scientist, World Bank Shiny + Databases create /Users/_mongod PrimaryGroupID 400 Once done, we create a new user (we use the same id as we did for the group) - no shell is needed for daemon users: $ sudo dscl. create /Groups/_mongod PrimaryGroupID 400

Please note, on OS X, by convention, all daemon users are prefixed with an underscore, such as _daemon.īefore creating a user, we create a group choosing an unused group id: # Create _mongod group Therefore, here we will use 400 (make sure it is not taken).

list /Groups PrimaryGroupID | tr -s ' ' | sort -n -t ' ' -k2,2 $ dscacheutil -q group | grep gid | tail -n 1 Get the last used GID: # Get the last used GID We never want to run as super user but create a special daemon _mongod for this. # MongoDB export PATH= '/usr/local/mongodb/bin: $PATH ' 4. # in replica set configuration, specify the name of the replica set # Slave only: specify a single database to replicate # in master/slave replicated mongo databases, specify here whether # Ping interval for Mongo monitoring server. # Server name for Mongo monitoring server. # Accout token for Mongo monitoring server. Any query that would do a table scan fails. # Disable the HTTP interface (Defaults to localhost:28017). # Inspect all client data for validity on receipt (useful for # Enables periodic logging of CPU utilization and I/O wait # e.g., if the parent directory isn't mutable by the mongodb user. # need to create and set permissions for this directory manually, # Note: if you run mongodb as a non-root user (recommended) you may

Macos download mongodb