Installing Streams Messaging Manager
Also available as:
PDF

Configure your SMM database

You can use the following databases with SMM:

  • Postgres
  • MySQL
  • Oracle
  • MariaDB
  1. To configure a MySQL database:
    create database streamsmsgmgr;
    CREATE USER 'streamsmsgmgr'@'localhost' IDENTIFIED BY 'streamsmsgmgr';
    GRANT ALL PRIVILEGES ON streamsmsgmgr.* TO 'streamsmsgmgr'@'localhost' WITH GRANT OPTION;
    CREATE USER 'streamsmsgmgr'@'%' IDENTIFIED BY 'streamsmsgmgr';
    GRANT ALL PRIVILEGES ON streamsmsgmgr.* TO 'streamsmsgmgr'@'%' WITH GRANT OPTION;
  2. To configure a Postgres database:
    # Log in database
    sudo su postgres
    psql
    
    # Setup databases and users
    create database streamsmsgmgr;
    CREATE USER streamsmsgmgr WITH PASSWORD streamsmsgmgr;
    GRANT ALL PRIVILEGES ON DATABASE "streamsmsgmgr" to streamsmsgmgr;