| | |
| | | if(!$this->dbmaster->query($query)) { |
| | | $this->warning('Unable to set rights of user in master database: '.$value['db']."\n Query: ".$query."\n Error: ".$this->dbmaster->errorMessage); |
| | | } |
| | | |
| | | $query = "GRANT SELECT, UPDATE ON ".$value['db'].".`aps_instances` TO '".$value['user']."'@'".$host."' "; |
| | | if ($verbose){ |
| | | echo $query ."\n"; |
| | | } |
| | | if(!$this->dbmaster->query($query)) { |
| | | $this->warning('Unable to set rights of user in master database: '.$value['db']."\n Query: ".$query."\n Error: ".$this->dbmaster->errorMessage); |
| | | } |
| | | |
| | | } |
| | | |
| | | /* |
| | |
| | | 'virtual_mailbox_base = '.$cf['vmail_mailbox_base'], |
| | | 'virtual_uid_maps = static:'.$cf['vmail_userid'], |
| | | 'virtual_gid_maps = static:'.$cf['vmail_groupid'], |
| | | 'inet_protocols=all', |
| | | 'smtpd_sasl_auth_enable = yes', |
| | | 'broken_sasl_auth_clients = yes', |
| | | 'smtpd_sasl_authenticated_header = yes', |
| | |
| | | |
| | | public function configure_saslauthd() { |
| | | global $conf; |
| | | |
| | | //* Get saslsauthd version |
| | | exec('saslauthd -v 2>&1',$out); |
| | | $parts = explode(' ',$out[0]); |
| | | $saslversion = $parts[1]; |
| | | unset($parts); |
| | | unset($out); |
| | | |
| | | |
| | | $configfile = 'sasl_smtpd.conf'; |
| | | if(version_compare($saslversion , '2.1.23') > 0) { |
| | | //* Configfile for saslauthd versions 2.1.24 and newer |
| | | $configfile = 'sasl_smtpd2.conf'; |
| | | } else { |
| | | //* Configfile for saslauthd versions up to 2.1.23 |
| | | $configfile = 'sasl_smtpd.conf'; |
| | | } |
| | | |
| | | if(is_file($conf['postfix']['config_dir'].'/sasl/smtpd.conf')) copy($conf['postfix']['config_dir'].'/sasl/smtpd.conf',$conf['postfix']['config_dir'].'/sasl/smtpd.conf~'); |
| | | if(is_file($conf['postfix']['config_dir'].'/sasl/smtpd.conf~')) chmod($conf['postfix']['config_dir'].'/sasl/smtpd.conf~', 0400); |
| | | $content = rf('tpl/'.$configfile.'.master'); |
| | |
| | | $content = str_replace('{mysql_server_ispconfig_user}',$conf['mysql']['ispconfig_user'],$content); |
| | | $content = str_replace('{mysql_server_ispconfig_password}',$conf['mysql']['ispconfig_password'], $content); |
| | | $content = str_replace('{mysql_server_database}',$conf['mysql']['database'],$content); |
| | | $content = str_replace('{mysql_server_ip}',$conf['mysql']['host'],$content); |
| | | $content = str_replace('{mysql_server_ip}',$conf['mysql']['ip'],$content); |
| | | } |
| | | wf($conf['vlogger']['config_dir'].'/'.$configfile,$content); |
| | | chmod($conf['vlogger']['config_dir'].'/'.$configfile, 0600); |
| | |
| | | } |
| | | } |
| | | } |
| | | |
| | | //* Make the APS directories group writable |
| | | exec("chmod -R 770 $install_dir/interface/web/sites/aps_meta_packages"); |
| | | exec("chmod -R 770 $install_dir/server/aps_packages"); |
| | | |
| | | //* make sure that the server config file (not the interface one) is only readable by the root user |
| | | chmod($install_dir.'/server/lib/'.$configfile, 0600); |