hi
fist step let mysql listen on: 0.0.0.0
therefore verify your /etc/mysql/my.cnf
cat /etc/mysql/my.cnf | grep bind #bind-address = 127.0.0.1
(should be done @ispconfig install)
create a mysql database and a user and grant all privileges to that user
CREATE USER 'sogo'@'1.1.1.1' IDENTIFIED BY '***'; GRANT USAGE ON * . * TO 'sogo'@'1.1.1.1' IDENTIFIED BY '***' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; CREATE DATABASE IF NOT EXISTS `sogo` ; GRANT ALL PRIVILEGES ON `sogo` . * TO 'sogo'@'1.1.1.1;
use mysql database as root and create special view
use sogo;
CREATE VIEW sogo_auth_view AS SELECT email AS c_uid, email AS c_name, password AS c_password, name AS c_cn, email AS mail FROM dbispconfig.mail_user WHERE disableimap='n' AND postfix ='y';
in your sogo config set the following lines:
<key>userPasswordAlgorithm</key> <string>crypt</string>
<key>viewURL</key> <string>mysql://sogo:yourpass@1.1.1.2:3306/sogo/sogo_auth_view</string>
Have Fun!