<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
    <entry key="mongoaddress">mongodb://localhost:27017/wifi-customer-cab</entry>
    <entry key="nbiaddress">http://localhost:8080/axis2/services/RadiusNbiService?wsdl</entry>
    <entry key="nbi.serviceLogin.user">softwlc_service</entry>
    <entry key="nbi.serviceLogin.password">111213141516</entry>
    <entry key="nbi.serviceLogin.requestTimeout.sec">120</entry>

    <!--Bonnie or NBI-->
    <entry key="data.service.type">NBI</entry>
    <entry key="bonnie.service.host">localhost</entry>
    <entry key="bonnie.service.port">9070</entry>

    <!--Bruce-->
    <entry key="bruce.service.host">localhost</entry>
    <entry key="bruce.service.port">8008</entry>

    <!--Jobs-->
    <entry key="jobs.service.host">localhost</entry>
    <entry key="jobs.service.port">9696</entry>

admin@ubuntu:~# sudo systemctl restart eltex-wifi-cab.service

"sql.auth.service" : {
    "url": "jdbc:mysql://localhost/eltex_auth_service?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf8&connectTime$
    "user": "javauser",
    "password": "javapassword",
    "max_pool_size": 4
  },

  "language" : "en",

  "radius.nbi" : {
    "wdsl.url" : "http://localhost:8080/axis2/services/RadiusNbiService?wsdl",
    "username" : "softwlc_service",
    "password" : "111213141516",
    "connection.timeout.ms" : 30000,
    "request.timeout.ms" : 120000
  },

  "tariffs.update.interval" : {
    "interval" : 1,
    "unit" : "hours",
    "apb_enabled": false,
    "apb_host": "localhost",
    "apb_port": 8090
  },

admin@ubuntu:~# sudo systemctl restart eltex-pcrf.service

# Mysql datasource properties
database {
  host = localhost
  port = 3306
  name = eltex_doors
  user = javauser
  password = passwd

{
  "auth.address" : "0.0.0.0",
  "auth.port" : 31812,
  "auth.mac.open.timeout.s" : 3600,
  "auth.mac.welcome.service" : "WELCOME",

  "acct.address" : "0.0.0.0",
  "acct.ports" : [1813, 31813],

  "lease.saver.address" : "0.0.0.0",
  "lease.saver.port" : 4381,

  "acct.sorm.address" : "localhost",
  "acct.sorm.port" : 41813,
  "acct.sorm.mirroring.enabled" : false,

  "aaa.instances" : 5,
  "aaa.host" : "127.0.0.1",
  "aaa.secret" : "testing123",
  "aaa.auth.port" : 1812,
  "aaa.acct.port" : 1813,
  "aaa.rest.port" : 7080,
  "aaa.timeout" : 10,
  "aaa.attempts" : 1,

  "web.monitoring.port" : 7070,

  "cluster.enable" : false,
  "cluster.eventBusPort" : 5801,

  "radius" : {
    "url": "jdbc:mysql://localhost/radius?useUnicode=true&characterEncoding=utf8&connectTimeout=5000&socketTimeout=5000&autoReconnect=true&useSSL=false",
    "user": "javauser",
    "password": "passwd",
    "max_pool_size": 16
  },

  "session.storage" : {
    "session.check.period.s" : 300,
    "unauth.store.time.s" : 600,
    "interval.number.expired" : 3,
    "min.interval.s" : 45,
    "default.interval.s" : 600
  },

  "bras.coa" : {
    "coa.timeout" : 10,
    "coa.attempts" : 1,
    "coa.secret" : "testing123",
    "remote.coa.port" : 3799,
    "log.clean.period.s" : 604800,
    "log.store.period" : {
      "period" : 14,
      "unit" : "D"
    },
    "worker.pool.size": 20
  },

  "sql.ems" : {
    "url": "jdbc:mysql://localhost/eltex_ems?useUnicode=true&characterEncoding=utf8&connectTimeout=5000&socketTimeout=5000&autoReconnect=true&useSSL=false",
    "user": "javauser",
    "password": "passwd",
    "max_pool_size": 16
  },

  "sql.wireless" : {
    "url": "jdbc:mysql://localhost/wireless?useUnicode=true&characterEncoding=utf8&connectTimeout=5000&socketTimeout=5000&autoReconnect=true&useSSL=false",
    "user": "javauser",
    "password": "passwd",
    "max_pool_size": 16
  },

  "sql.auth.service" : {
    "url": "jdbc:mysql://localhost/eltex_auth_service?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf8&connectTimeout=5000&socketTimeout=5000&useSSL=false",
    "user": "javauser",
    "password": "passwd",
    "max_pool_size": 4
  },

  "sql.pcrf" : {
    "url": "jdbc:mysql://localhost/eltex_pcrf?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000&socketTimeout=5000&useSSL=false",
    "user": "javauser",
    "password": "passwd",
    "max_pool_size": 60
  },

  "sql.ott" : {
    "url": "jdbc:mysql://localhost/eltex_ott?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000&socketTimeout=5000&useSSL=false",
    "user": "javauser",
    "password": "passwd",
    "max_pool_size": 32
  },

  "language" : "en",

  "radius.nbi" : {
    "wdsl.url" : "http://localhost:8080/axis2/services/RadiusNbiService?wsdl",
    "username" : "softwlc_service",
    "password" : "password",
    "connection.timeout.ms" : 30000,
    "request.timeout.ms" : 120000
  },

  "tariffs.update.interval" : {
    "interval" : 1,
    "unit" : "hours",
    "apb_enabled": false,
    "apb_host": "localhost",
    "apb_port": 8090
  },

  "bras.cron.update.interval": {
    "interval" : 1,
    "unit": "hours"
  },

  "filters.cache.dir" : "/var/lib/eltex-pcrf/filters/",

  "clickhouse": {
    "url": "jdbc:clickhouse://localhost:8123/radius",
    "user_name": "javauser",
    "user_password": "passwd",
    "actualization_period_ms": 15000
  },

server.port=9696
spring.batch.job.enabled=false

spring.flyway.enabled=true
spring.flyway.url=jdbc:mysql://localhost:3306/eltex_jobs
spring.flyway.user=javauser
spring.flyway.password=passwd

spring.datasource.jdbcUrl=jdbc:h2:mem:testdb;DB_CLOSE_ON_EXIT=FALSE
spring.datasource.driverClassName=org.h2.Driver
spring.datasource.username=sa
spring.datasource.password=
spring.datasource.maximum-pool-size=200
spring.datasource.poolName=h2-pool
spring.h2.console.enabled=false

spring.jobsdatasource.jdbcUrl=jdbc:mysql://127.0.0.1/eltex_jobs?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000
spring.jobsdatasource.driverClassName=com.mysql.cj.jdbc.Driver
spring.jobsdatasource.poolName=jobs-pool
spring.jobsdatasource.username=javauser
spring.jobsdatasource.password=passwd

spring.emsdatasource.jdbcUrl=jdbc:mysql://127.0.0.1/eltex_ems?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000&useSSL=false
spring.emsdatasource.driverClassName=com.mysql.cj.jdbc.Driver
spring.emsdatasource.username=javauser
spring.emsdatasource.password=passwd
# ConnectionTimeout property controls the maximum number of milliseconds that a client (that's you) will wait for a connection from the pool.
spring.emsdatasource.connection-timeout=15000
# ValidationTimeout property controls the maximum amount of time that a connection will be tested for aliveness.
spring.emsdatasource.validation-timeout=3000
# IdleTimeout property controls the maximum amount of time that a connection is allowed to sit idle in the pool.
spring.emsdatasource.idle-timeout=30000
# MinimumIdle property controls the minimum number of idle connections that HikariCP tries to maintain in the pool.
spring.emsdatasource.minimum-idle=1
# Maximum size of connection pool
spring.emsdatasource.maximum-pool-size=48
spring.emsdatasource.poolName=ems-pool

services.nbi.wsdl=http://localhost:8080/axis2/services/RadiusNbiService?wsdl
services.nbi.login=admin
services.nbi.password=password
services.nbi.requestTimeout=0
services.nbi.connectionTimeout=60000

services.ngw.host=127.0.0.1
services.ngw.port=8040
services.ngw.retries=1
services.ngw.attachment.maxSize=10000000

services.report.allSessions.compress=true

#spring.radiusdatasource.jdbcUrl=jdbc:clickhouse://localhost:8123/radius?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000
#spring.radiusdatasource.driverClassName=ru.yandex.clickhouse.ClickHouseDriver
spring.radiusdatasource.jdbcUrl=jdbc:mysql://127.0.0.1/radius?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000&useSSL=false
spring.radiusdatasource.driverClassName=com.mysql.cj.jdbc.Driver
spring.radiusdatasource.username=javauser
spring.radiusdatasource.password=passwd
spring.radiusdatasource.poolName=radius-pool
server.port=9696
spring.batch.job.enabled=false

spring.flyway.enabled=true
spring.flyway.url=jdbc:mysql://localhost:3306/eltex_jobs
spring.flyway.user=javauser
spring.flyway.password=passwd

spring.datasource.jdbcUrl=jdbc:h2:mem:testdb;DB_CLOSE_ON_EXIT=FALSE
spring.datasource.driverClassName=org.h2.Driver
spring.datasource.username=sa
spring.datasource.password=
spring.datasource.maximum-pool-size=200
spring.datasource.poolName=h2-pool
spring.h2.console.enabled=false

spring.jobsdatasource.jdbcUrl=jdbc:mysql://127.0.0.1/eltex_jobs?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000
spring.jobsdatasource.driverClassName=com.mysql.cj.jdbc.Driver
spring.jobsdatasource.poolName=jobs-pool
spring.jobsdatasource.username=javauser
spring.jobsdatasource.password=passwd

spring.emsdatasource.jdbcUrl=jdbc:mysql://127.0.0.1/eltex_ems?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000&useSSL=false
spring.emsdatasource.driverClassName=com.mysql.cj.jdbc.Driver
spring.emsdatasource.username=javauser
spring.emsdatasource.password=passwd
# ConnectionTimeout property controls the maximum number of milliseconds that a client (that's you) will wait for a connection from the pool.
spring.emsdatasource.connection-timeout=15000
# ValidationTimeout property controls the maximum amount of time that a connection will be tested for aliveness.
spring.emsdatasource.validation-timeout=3000
# IdleTimeout property controls the maximum amount of time that a connection is allowed to sit idle in the pool.
spring.emsdatasource.idle-timeout=30000
# MinimumIdle property controls the minimum number of idle connections that HikariCP tries to maintain in the pool.
spring.emsdatasource.minimum-idle=1
# Maximum size of connection pool
spring.emsdatasource.maximum-pool-size=48
spring.emsdatasource.poolName=ems-pool

services.nbi.wsdl=http://localhost:8080/axis2/services/RadiusNbiService?wsdl
services.nbi.login=admin
services.nbi.password=password
services.nbi.requestTimeout=0
services.nbi.connectionTimeout=60000

services.ngw.host=127.0.0.1
services.ngw.port=8040
services.ngw.retries=1
services.ngw.attachment.maxSize=10000000

services.report.allSessions.compress=true

#spring.radiusdatasource.jdbcUrl=jdbc:clickhouse://localhost:8123/radius?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000
#spring.radiusdatasource.driverClassName=ru.yandex.clickhouse.ClickHouseDriver
spring.radiusdatasource.jdbcUrl=jdbc:mysql://127.0.0.1/radius?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000&useSSL=false
spring.radiusdatasource.driverClassName=com.mysql.cj.jdbc.Driver
spring.radiusdatasource.username=javauser
spring.radiusdatasource.password=passwd
spring.radiusdatasource.poolName=radius-pool

# DB radius(alias=radius)
radius.jdbc.driver=org.gjt.mm.mysql.Driver
radius.jdbc.dbUrl=jdbc:mysql://localhost/radius?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000
radius.jdbc.username=javauser
radius.jdbc.password=passwd
radius.jdbc.maxPoolSize=48
radius.jdbc.inUse=yes

# DB radius replica(alias=radiusReplicaPool)
#TODO: Change it to replica url
radius.jdbc.replica.driver=org.gjt.mm.mysql.Driver
radius.jdbc.replica.dbUrl=jdbc:mysql://localhost/radius?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000
radius.jdbc.replica.username=javauser
radius.jdbc.replica.password=passwd
radius.jdbc.replica.maxPoolSize=48
radius.jdbc.replica.inUse=yes

# DB ems(alias=ems)
ems.jdbc.driver=org.gjt.mm.mysql.Driver
ems.jdbc.dbUrl=jdbc:mysql://localhost/eltex_ems?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000&noAccessToProcedureBodies=true
ems.jdbc.username=javauser
ems.jdbc.password=passwd
ems.jdbc.maxPoolSize=48
ems.jdbc.inUse=yes

# DB wireless (alias=wireless)
wireless.jdbc.driver=org.gjt.mm.mysql.Driver
wireless.jdbc.dbUrl=jdbc:mysql://localhost/wireless?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000
wireless.jdbc.username=javauser
wireless.jdbc.password=passwd
wireless.jdbc.maxPoolSize=48
wireless.jdbc.inUse=yes

# DB logs (alias=logs)
logs.jdbc.driver=org.gjt.mm.mysql.Driver
logs.jdbc.dbUrl=jdbc:mysql://localhost/eltex_alert?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000
logs.jdbc.username=javauser
logs.jdbc.password=passwd
logs.jdbc.maxPoolSize=48
logs.jdbc.inUse=yes

# DB logs (alias=eltex_auth_service)
eltex_auth_service.jdbc.driver=org.gjt.mm.mysql.Driver
eltex_auth_service.jdbc.dbUrl=jdbc:mysql://localhost/eltex_auth_service?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000
eltex_auth_service.jdbc.username=javauser
eltex_auth_service.jdbc.password=passwd
eltex_auth_service.jdbc.maxPoolSize=48
eltex_auth_service.jdbc.inUse=yes

# адрес ems-northbound
ems.nbi.host=100.111.123.3
ems.nbi.port=8080
ems.nbi.path=northbound
ems.nbi.protocol=http

# tomcat url
tomcat.host=100.111.123.5
tomcat.port=8080

# pcrf stuff
pcrf.enabled=true
pcrf.url=http://localhost:7070
pcrf.username=admin
pcrf.password=password
pcrf.readtimeout=11
pcrf.writetimeout=11

# pcrf mysql
pcrf.jdbc.driver=org.gjt.mm.mysql.Driver
pcrf.jdbc.dbUrl=jdbc:mysql://localhost:3306/eltex_pcrf?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000
pcrf.jdbc.username=javauser
pcrf.jdbc.password=passwd
pcrf.jdbc.maxPoolSize=48
pcrf.jdbc.inUse=yes

# wifi-customer-cab mysql
wifi_cab.jdbc.driver=org.gjt.mm.mysql.Driver
wifi_cab.jdbc.dbUrl=jdbc:mysql://localhost:3306/eltex_wifi_customer_cab?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000
wifi_cab.jdbc.username=javauser
wifi_cab.jdbc.password=passwd
wifi_cab.jdbc.maxPoolSize=48
wifi_cab.jdbc.inUse=yes

# Eltex.SORM2.replicator MariaDB 'sorm2' connect
sorm2.jdbc.driver=org.gjt.mm.mysql.Driver
sorm2.jdbc.dbUrl=jdbc:mysql://localhost:3306/eltex_sorm2?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000
sorm2.jdbc.username=javauser
sorm2.jdbc.password=passwd
sorm2.jdbc.maxPoolSize=48
sorm2.jdbc.inUse=no

# wifi-customer-cab request settings
wificab.timeout=90000

# Eltex.SORM2.replicator host to use API
sorm2.enabled=false
sorm2.url=http://localhost:7071
sorm2.username=admin
sorm2.password=password

#It enables records export to SORM3 while editing wifi users
sorm3.enabled=false

# ott mysql
ott.jdbc.driver=org.gjt.mm.mysql.Driver
ott.jdbc.dbUrl=jdbc:mysql://localhost:3306/eltex_ott?zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000
ott.jdbc.username=javauser
ott.jdbc.password=passwd
ott.jdbc.maxPoolSize=48
ott.jdbc.inUse=yes

portal.db.driver=com.mysql.jdbc.Driver
portal.db.url=jdbc:mysql://localhost:3306/ELTEX_PORTAL?max_allowed_packet=32362048&useUnicode=true&characterEncoding=utf8
portal.db.username=javauser
portal.db.password=passwd

database {
    host = localhost
    port = 3306
    name = ELTEX_PORTAL
    user = javauser
    password = passwd

    pool {
        # Time to wait for a connection
        connectionTimeout = 10s
        # Time to wait for connection validation
        validationTimeout = 3s

        min = 1
        max = 10
    }

login {
    # Количество попыток входа в панель администратора до наступления блокировки
    maxAttemptsLogin = 3
    maxAttemptsIP = 5
    # Количество минут блокировки после достижения максимального числа попыток входа в панель администратора
    blockTime = 5m
}

database {
    host = localhost
    port = 3306
    name = ELTEX_PORTAL
    user = javauser
    password = passwd

    pool {
        # Time to wait for a connection
        connectionTimeout = 10s
        # Time to wait for connection validation
        validationTimeout = 3s

        min = 1
        max = 10
    }

database {
  host = localhost
  port = 3306
  name = radius
  user = javauser
  password = passwd

  readOnly = false

  pool {
    maxPoolSize = 20
    minimumIdle = 1
    connectionTimeout = 5000
  }

}

jdbc {
  properties {
    useSSL = false
  }
}

sorm3Enabled = false

logging {
  host = localhost
  port = 9099
}

}

email {
    // Outgoing (service to user) email config
    outgoing.config = ""

}

database {
    host = localhost
    port = 3306
    name = eltex_ngw
    user = javauser
    password = passwd     

    pool {
        // Time to wait for a connection
        connectionTimeout = 10s
        // Time to wait for connection validation
        validationTimeout = 3s

        min = 1
        max = 10
    }

server.servlet.context-path=/wifi-cab
server.port=8083
server.servlet.context-parameters.productionMode=true
server.servlet.context-parameters.heartbeatInterval=30
server.servlet.context-parameters.closeIdleSessions=true
server.servlet.session.timeout=60

vaadin.servlet.production-mode=true
vaadin.servlet.close-idle-sessions=true
vaadin.servlet.heartbeat-interval=30
wifi.cab.production.dir=/usr/lib/eltex-wifi-cab
wifi.cab.config.dir=/etc/eltex-wifi-cab
jetty.sessionScavengeInterval.seconds=60

spring.profiles.include=templated

spring.datasource.url=jdbc:mysql://localhost:3306/eltex_wifi_customer_cab
spring.datasource.username=javauser
spring.datasource.password=passwd

management.server.port=8085
management.health.defaults.enabled=true
management.endpoints.web.exposure.include=health, prometheus, metrics
management.endpoint.health.enabled=true

USER=javauser
PASS=passwd
HOST=localhost

serviceConfiguration = {
  ApplicationConfiguration = {
    ServicePort = 9095 // service listen port

    // if this environment equals to 'production', all logs will transmit to graylog
    // else if this environment equals to 'k8s', all logs will be written to stdout
    Environment = "production" 

    SleepDaemonQueueTime = 5 // time for sleep (unit: milliseconds)
    FoulTime = 60 // time of raw event, they disappear (unit: seconds)
    
    GelfEnabled = false // inclusion of sending logs to graylog

    mysqlConfiguration = {
        ConnectionString = "tcp(127.0.0.1:3306)"
        DBName = "eltex_wids"
        Login = "javauser"
        Password = "passwd"
    }
  }
}

server {
  port = 9099
}

eventlog {
  enabled = true
}

sorm {
  enabled = false
  dir = /var/log/eltex-logging-service/sorm3/
}

database {
  jdbcUrl = "jdbc:mysql://localhost:3306/eltex_wifi_customer_cab"
  username = "javauser"
  password = "passwd"
}

server.port=8008
server.address.jobs=http://localhost:9696

spring.datasource.url=jdbc:mysql://localhost:3306/eltex_bruce
spring.datasource.username=javauser
spring.datasource.password=passwd
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

spring.flyway.url=${spring.datasource.url}
spring.flyway.user=${spring.datasource.username}
spring.flyway.password=${spring.datasource.password}

CREATE DATABASE IF NOT EXISTS `eltex_wids` DEFAULT CHARACTER SET utf8;

GRANT ALL ON `eltex_wids`.* TO 'javauser'@'localhost' IDENTIFIED BY 'passwd';
GRANT ALL ON `eltex_wids`.* TO 'javauser'@'%' IDENTIFIED BY 'passwd';
FLUSH PRIVILEGES;

CREATE DATABASE IF NOT EXISTS `eltex_sorm2` DEFAULT CHARACTER SET utf8;

GRANT ALL ON `eltex_sorm2`.* TO 'javauser'@'localhost' IDENTIFIED BY 'passwd';
GRANT ALL ON `eltex_sorm2`.* TO 'javauser'@'%' IDENTIFIED BY 'passwd';
FLUSH PRIVILEGES;

CREATE DATABASE IF NOT EXISTS `eltex_pcrf` DEFAULT CHARACTER SET utf8;

GRANT ALL ON `eltex_pcrf`.* TO 'javauser'@'localhost' IDENTIFIED BY 'passwd';
GRANT ALL ON `eltex_pcrf`.* TO 'javauser'@'%' IDENTIFIED BY 'passwd';
FLUSH PRIVILEGES;

CREATE DATABASE IF NOT EXISTS `eltex_jerry` DEFAULT CHARACTER SET utf8;

GRANT ALL ON `eltex_jerry`.* TO 'javauser'@'localhost' IDENTIFIED BY 'passwd';
GRANT ALL ON `eltex_jerry`.* TO 'javauser'@'%' IDENTIFIED BY 'passwd';
FLUSH PRIVILEGES;

CREATE DATABASE IF NOT EXISTS `eltex_wifi_customer_cab` DEFAULT CHARACTER SET utf8;

GRANT ALL ON `eltex_wifi_customer_cab`.* TO 'javauser'@'localhost' IDENTIFIED BY 'passwd';
GRANT ALL ON `eltex_wifi_customer_cab`.* TO 'javauser'@'%' IDENTIFIED BY 'passwd';
FLUSH PRIVILEGES;

CREATE DATABASE IF NOT EXISTS `eltex_jobs` DEFAULT CHARACTER SET utf8;

GRANT ALL ON `eltex_jobs`.* TO 'javauser'@'localhost' IDENTIFIED BY 'passwd';
GRANT ALL ON `eltex_jobs`.* TO 'javauser'@'%' IDENTIFIED BY 'passwd';
FLUSH PRIVILEGES;

CREATE DATABASE IF NOT EXISTS `eltex_ott` DEFAULT CHARACTER SET utf8;

GRANT ALL ON `eltex_ott`.* TO 'javauser'@'localhost' IDENTIFIED BY 'passwd';
GRANT ALL ON `eltex_ott`.* TO 'javauser'@'%' IDENTIFIED BY 'passwd';
FLUSH PRIVILEGES;

# При необходимосте, нужно заменить пароль подключения к БД

LOGIN="javauser"
PASS="passwd"
OUT_FILE1="ont-doubles-list1.txt"
OUT_FILE2="ont-doubles-list2.txt"

SQL="insert SSID (name, domain_name) values ('ELTEXTESTPERCONA', 'root');\
update SSID set descr='new' where name='ELTEXTESTPERCONA';\
insert SSID_PARAMS (parent_id, param_name, param_value) \
values (@@IDENTITY, 'ELTEXTESTPERCONA', 'value');\
update SSID_PARAMS set param_value='new' where param_name='ELTEXTESTPERCONA';\
delete from SSID_PARAMS where param_name='ELTEXTESTPERCONA';\
delete from SSID where name='ELTEXTESTPERCONA';"

for i in {1..1000}
do
   mysql -ujavauser -ppasswd -h127.0.0.1 wireless -e "$SQL"
done

# For EMS access
GRANT ALL on eltex_auth_service.* TO 'javauser'@'%' IDENTIFIED BY 'passwd';

# For EMS access
GRANT ALL on eltex_auth_service.* TO 'javauser'@'localhost' IDENTIFIED BY 'passwd';
GRANT ALL on eltex_auth_service.* TO 'javauser'@'127.0.0.1' IDENTIFIED BY 'passwd';

conf = ConfigFactory.parse_file('application.conf')

# mongo
mongo_host: str = conf.get('mongodb.host', 'localhost')
mongo_port: str = conf.get('mongodb.port', '27017')

# mysql
mysql_host: str = conf.get('mysql.host', 'localhost')
mysql_port: int = int(conf.get('mysql.port', 3306))
mysql_user: str = conf.get('mysql.username', 'javauser')
mysql_password: str = conf.get('mysql.password', 'passwd')
bruce_charset: str = conf.get('mysql.charset', 'utf8')

# Mysql
mysql: {
    host: "localhost",
    port: "3306",
    username: "javauser",
    password: "passwd",
    charset: "utf8",
}

#скрипт подсчета максимальной длины домена eltex_ems.DOMAINS
## a=( $RESULT )
## num=$((${a[2]} + ${a[3]}))
#mysql login and password
LOGIN=javauser
PASSWD=passwd

#скрипт периодического тестирования таблиц EMS БД mysql.

# Скрипт возвращает 0 в случае корректного выполнения всех тестов
# Скрипт позвращает 1 в случае любой ошибки и посылает сообщение админу системы

#mysql login and password
LOGIN=javauser
PASSWD=passwd
HOST=localhost

# TreeDBUtils.ACTUAL_VERSION must have the same value!
SCHEMA_VERSION=61

SCHEMA_HAS_WIRELESS=1

SCRIPT_DIR=$(dirname $0)
MYSQL_USER="root"
MYSQL_PASS="root"
EMS_USER="javauser"
EMS_PASSWORD="passwd"
BACKUP_DIR=/tmp/ems_install_backup
BACKUP_FILE=$BACKUP_DIR/ems_full_backup.sql
BACKUP_DATABASES="eltex_ems eltex_ont wireless"

CREATE DATABASE IF NOT EXISTS `eltex_jobs` DEFAULT CHARACTER SET utf8;

GRANT ALL ON `eltex_jobs`.* TO 'javauser'@'localhost' IDENTIFIED BY 'passwd';
GRANT ALL ON `eltex_jobs`.* TO 'javauser'@'%' IDENTIFIED BY 'passwd';
FLUSH PRIVILEGES;

CREATE DATABASE IF NOT EXISTS `eltex_wifi_customer_cab` DEFAULT CHARACTER SET utf8;

GRANT ALL ON `eltex_wifi_customer_cab`.* TO 'javauser'@'localhost' IDENTIFIED BY 'passwd';
GRANT ALL ON `eltex_wifi_customer_cab`.* TO 'javauser'@'%' IDENTIFIED BY 'passwd';
FLUSH PRIVILEGES;

CREATE DATABASE IF NOT EXISTS `eltex_jerry` DEFAULT CHARACTER SET utf8;

GRANT ALL ON `eltex_jerry`.* TO 'javauser'@'localhost' IDENTIFIED BY 'passwd';
GRANT ALL ON `eltex_jerry`.* TO 'javauser'@'%' IDENTIFIED BY 'passwd';
FLUSH PRIVILEGES;

CREATE DATABASE IF NOT EXISTS `eltex_ott` DEFAULT CHARACTER SET utf8;

GRANT ALL ON `eltex_ott`.* TO 'javauser'@'localhost' IDENTIFIED BY 'passwd';
GRANT ALL ON `eltex_ott`.* TO 'javauser'@'%' IDENTIFIED BY 'passwd';
FLUSH PRIVILEGES;

CREATE DATABASE IF NOT EXISTS `eltex_pcrf` DEFAULT CHARACTER SET utf8;

GRANT ALL ON `eltex_pcrf`.* TO 'javauser'@'localhost' IDENTIFIED BY 'passwd';
GRANT ALL ON `eltex_pcrf`.* TO 'javauser'@'%' IDENTIFIED BY 'passwd';
FLUSH PRIVILEGES;

CREATE DATABASE IF NOT EXISTS `eltex_sorm2` DEFAULT CHARACTER SET utf8;

GRANT ALL ON `eltex_sorm2`.* TO 'javauser'@'localhost' IDENTIFIED BY 'passwd';
GRANT ALL ON `eltex_sorm2`.* TO 'javauser'@'%' IDENTIFIED BY 'passwd';
FLUSH PRIVILEGES;

CREATE DATABASE IF NOT EXISTS `wireless` DEFAULT CHARACTER SET utf8;

GRANT ALL ON wireless.* TO 'javauser'@'localhost' IDENTIFIED BY 'passwd';

USE `wireless`;

GRANT ALL ON `eltex_bruce`.* TO 'javauser'@'localhost' IDENTIFIED BY 'passwd';
GRANT ALL ON `eltex_bruce`.* TO 'javauser'@'%' IDENTIFIED BY 'passwd';
FLUSH PRIVILEGES;

CREATE DATABASE IF NOT EXISTS `eltex_wids` DEFAULT CHARACTER SET utf8;

GRANT ALL ON `eltex_wids`.* TO 'javauser'@'localhost' IDENTIFIED BY 'passwd';
GRANT ALL ON `eltex_wids`.* TO 'javauser'@'%' IDENTIFIED BY 'passwd';
FLUSH PRIVILEGES;

# For EMS access

GRANT ALL on radius.* TO 'javauser'@'%' IDENTIFIED BY 'passwd';
GRANT ALL on radius.* TO 'javauser'@'localhost' IDENTIFIED BY 'passwd';
GRANT ALL on radius.* TO 'javauser'@'127.0.0.1' IDENTIFIED BY 'passwd';

CRON_D=/etc/cron.d

AUTH_SERVICE_DB_BACKUP=/etc/cron.d/auth-service-db-backup
BACKUP_CRON="# 20 02 2 * * root /usr/lib/eltex-auth-service-db/auth-service-dump-rotate-all.sh localhost 3306 javauser passwd eltex_auth_service /var/lib/eltex-auth-service-backup eltex-auth-service-backup 31"

def main():
    parser = argparse.ArgumentParser(
        description="NGW MongoDB to MySQL migrator")

    parser.add_argument("--mysql-url",
                        help="MySQL connection URL (e.g mysql://javauser:passwd@localhost:3306/eltex_ngw)")

    parser.add_argument("--mongodb-url",
                        help="MongoDB connection URL (e.g mongodb://localhost:27017/notification-gw"
                             + " or mongodb://user@localhost:27017/notification-gw"
                             + " or mongodb://user:password@localhost:27017/notification-gw)")

    parser.add_argument("--skip",
                        help="Skip certain collections during migration process.\n"
                        + "Available collections: outgoingSms, emails, fsfiles, incomingEvents.\n"
                        + "Should be a list of collections divided by  \",\". Names are case sensitive.")

    if len(sys.argv) < 3:
        parser.print_help(sys.stderr)
        sys.exit(1)

    args = parser.parse_args()
    mysql_url = urlparse(args.mysql_url)
    mysql_username = mysql_url.username
    mysql_password = mysql_url.password

    if not mysql_url.netloc:
        print("Invalid MySQL URL. Should be: mysql://javauser:passwd@localhost:3306/eltex_ngw)")
        sys.exit(-1)

    try:
        mysql_host = mysql_url.netloc.split("@")[1].split(":")[0]
        mysql_db = mysql_url.path.strip("/")
    except (AttributeError, IndexError):
        print("Invalid MySQL URL. Should be: mysql://javauser:passwd@localhost:3306/eltex_ngw)")

RC_LOCAL=/etc/rc.local
CREATE_PARTITIONS=/etc/cron.daily/radius-db-partitions
CREATE_PARTITIONS_ECRANE=\\/etc\\/cron.daily\\/radius-db-partitions

RADIUS_DB_BACKUP=/etc/cron.d/radius-db-backup
BACKUP_CRON="# 20 02 2 * * root /usr/lib/eltex-radius-db/radius-dump-rotate-all.sh localhost 3306 javauser passwd radius /var/lib/eltex-radius-backup radius-backup 31"

# DB Event
poolName1=event
event.jdbc.driver=org.gjt.mm.mysql.Driver
event.jdbc.dbUrl=jdbc:mysql://localhost/eltex_alert?useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000&useSSL=false
event.jdbc.username=javauser
event.jdbc.password=passwd
event.jdbc.maxPoolSize=32
event.jdbc.inUse=yes
# remote db host access with su privileges
# event.ssh.login=
# event.ssh.password=
# event.ssh.port=

# DB Tree
poolName2=tree
tree.jdbc.driver=org.gjt.mm.mysql.Driver
tree.jdbc.dbUrl=jdbc:mysql://localhost/eltex_ems?useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000&noAccessToProcedureBodies=true&useSSL=false
tree.jdbc.username=javauser
tree.jdbc.password=passwd
tree.jdbc.maxPoolSize=20
tree.jdbc.inUse=yes

# DB Ont
poolName3=ont
ont.jdbc.driver=org.gjt.mm.mysql.Driver
ont.jdbc.dbUrl=jdbc:mysql://localhost/eltex_ont?useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000&useSSL=false
ont.jdbc.username=javauser
ont.jdbc.password=passwd
ont.jdbc.maxPoolSize=40
ont.jdbc.inUse=yes

# DB Syslog
poolName4=syslog
syslog.jdbc.driver=org.gjt.mm.mysql.Driver
syslog.jdbc.dbUrl=jdbc:mysql://localhost/Syslog?useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000&useSSL=false
syslog.jdbc.username=javauser
syslog.jdbc.password=passwd
syslog.jdbc.maxPoolSize=4
syslog.jdbc.inUse=yes
# remote db host access with su privileges
# syslog.ssh.login=
# syslog.ssh.password=
# syslog.ssh.port=

# DB acsmain (alias=cpe)
poolName5=cpe
cpe.jdbc.driver=org.gjt.mm.mysql.Driver
cpe.jdbc.dbUrl=jdbc:mysql://localhost/acsmain?useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000&useSSL=false
cpe.jdbc.username=javauser
cpe.jdbc.password=passwd
cpe.jdbc.maxPoolSize=2
cpe.jdbc.inUse=yes

# DB acscmds(alias=cmds)
poolName6=cmds
cmds.jdbc.driver=org.gjt.mm.mysql.Driver
cmds.jdbc.dbUrl=jdbc:mysql://localhost/acscmds?useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000&useSSL=false
cmds.jdbc.username=javauser
cmds.jdbc.password=passwd
cmds.jdbc.maxPoolSize=2
cmds.jdbc.inUse=yes

# DB acsinf(alias=inf)
poolName7=inf
inf.jdbc.driver=org.gjt.mm.mysql.Driver
inf.jdbc.dbUrl=jdbc:mysql://localhost/acsinf?useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000&useSSL=false
inf.jdbc.username=javauser
inf.jdbc.password=passwd
inf.jdbc.maxPoolSize=2
inf.jdbc.inUse=yes

# DB acscache(alias=cache)
poolName8=cache
cache.jdbc.driver=org.gjt.mm.mysql.Driver
cache.jdbc.dbUrl=jdbc:mysql://localhost/acscache?useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000&useSSL=false
cache.jdbc.username=javauser
cache.jdbc.password=passwd
cache.jdbc.maxPoolSize=2
cache.jdbc.inUse=yes

# DB radius(alias=radius)
poolName9=radius
radius.jdbc.driver=org.gjt.mm.mysql.Driver
radius.jdbc.dbUrl=jdbc:mysql://localhost/radius?useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000&useSSL=false
radius.jdbc.username=javauser
radius.jdbc.password=passwd
radius.jdbc.maxPoolSize=40
radius.jdbc.inUse=yes
# remote db host access with su privileges
# radius.ssh.login=
# radius.ssh.password=
# radius.ssh.port=

# ------------------------------------------- SSID ---------------------------------------------
# DB wireless (alias=wireless)
poolName10=wireless
wireless.jdbc.driver=org.gjt.mm.mysql.Driver
wireless.jdbc.dbUrl=jdbc:mysql://localhost/wireless?useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000&useSSL=false
wireless.jdbc.username=javauser
wireless.jdbc.password=passwd
wireless.jdbc.maxPoolSize=30
wireless.jdbc.inUse=yes

# DB ott
poolName11=ott
ott.jdbc.driver=org.gjt.mm.mysql.Driver
ott.jdbc.dbUrl=jdbc:mysql://localhost/eltex_ott?useUnicode=true&characterEncoding=utf8&relaxAutoCommit=true&connectTimeout=5000&useSSL=false
ott.jdbc.username=javauser
ott.jdbc.password=passwd
ott.jdbc.maxPoolSize=48
ott.jdbc.inUse=yes

SET PASSWORD FOR javauser@127.0.0.1 = PASSWORD('passwd');
SET PASSWORD FOR javauser@'%' = PASSWORD('passwd');
SET PASSWORD FOR 'javauser'@'localhost' = PASSWORD('passwd');

ALTER USER 'root'@'localhost' IDENTIFIED BY 'passwd';
ALTER USER 'root'@'127.0.0.1' IDENTIFIED BY 'passwd';

FLUSH PRIVILEGES;

# Ports on which the server will listen
auth_port=1812
#acct_port=1813
inner_tunnel_port=18121

# MySQL database
db_host="localhost"
db_port=3306
db_login="radius"
db_password="123123"
db_name="radius"

# PCRF
# If you setting pcrf_enabled=0, then you also should enable accounting port listening in "default" server
pcrf_host="127.0.0.1"
pcrf_port=7080
pcrf_enabled=1

SET PASSWORD FOR 'radius'@'127.0.0.1' = PASSWORD('passwd');
SET PASSWORD FOR 'radius'@'localhost' = PASSWORD('passwd');
SET PASSWORD FOR 'radius'@'%' = PASSWORD('passwd');

FLUSH PRIVILEGES;

admin@ubuntu:~# sudo systemctl restart eltex-*.service

admin@ubuntu:~# sudo service tomcat8 restart

admin@ubuntu:~# sudo service mysql restart