Spotter-VM/lxc-apps/ushahidi/install/adminpwd.sql

9 lines
900 B
MySQL
Raw Permalink Normal View History

2017-10-26 22:50:04 +02:00
UPDATE users SET email = '${USHAHIDI_ADMIN_USER}', password = '${USHAHIDI_ADMIN_HASH}', updated = created WHERE realname = 'admin';
2018-02-03 10:06:16 +01:00
INSERT INTO `config` (`group_name`, `config_key`, `config_value`) VALUES
('site', 'name', '"Spotter Cluster"'),
('site', 'email', '"admin@example.com"'),
('site', 'language', '"cs"'),
2018-09-14 11:24:04 +02:00
('data-provider','email','{\"incoming_type\":\"IMAP\",\"incoming_server\":\"localhost\",\"incoming_port\":143,\"incoming_security\":\"None\",\"incoming_username\":\"ushahidi@spotter.ngo\",\"incoming_password\":\"password\",\"outgoing_type\":\"SMTP\",\"outgoing_server\":\"host\",\"outgoing_port\":25,\"outgoing_security\":\"None\",\"outgoing_username\":\"ushahidi@spotter.ngo\",\"outgoing_password\":\"password\",\"from\":\"ushahidi@spotter.ngo\",\"from_name\":\"Ushahidi\"}'),
('data-provider','url','\"https:\\/\\/ush.spotter.vm\\/platform\\/api\\/v3\\/config\\/data-provider\"');