ispconfig 3 multiserver

Discussion in 'Installation/Configuration' started by chief, Jul 18, 2018.

  1. chief

    chief Member HowtoForge Supporter

    update.
    yes, i can ping mail.tlsystems.co.uk and i can ping all servers i have setup. i have created ptr records. i used ztk.me code and found
    $config['smtp_port'] = 587; $config['smtp_user'] = '%u'; $config['smtp_pass'] = '%p'; $config['smtp_server'] = 'tls://<fqdn>'; $config['default_host'] = 'tls://<fqdn>';
    and found $config['default_host'] = 'tls://<fqdn>'; doesnt work, it has to be $config['default_host'] = 'mail.tlsystems.co.uk'; i cannot use tls://mail.tlsystems.co.uk as it gives an error ---

    Warning: stream_socket_enable_crypto(): SSL operation failed with code 1. OpenSSL Error messages: error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed in /usr/share/roundcube/program/lib/Roundcube/rcube_imap_generic.php on line 1017
    IMAP Error in /usr/share/roundcube/program/lib/Roundcube/rcube_imap.php (193): Login failed for [email protected] from 79.79.62.1. Unable to negotiate TLS
     
  2. chief

    chief Member HowtoForge Supporter

    an update..
    I can ping all my servers, i can ssh to them all, i go to mxtoolbox and it checks out ok. i send an email from gmail.com and it now appears in the mail.tlsystems.co.uk /var/vmail/tlsystems.uk/Mail../new folder. so mail gets there.
    i used ztk.me config info and im having roundcube issues there. when i use
    $config['default_host'] = 'tls://mail.tlsystems.co.uk';
    It gives the following error:

    Warning: stream_socket_enable_crypto(): SSL operation failed with code 1. OpenSSL Error messages: error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed in /usr/share/roundcube/program/lib/Roundcube/rcube_imap_generic.php on line 1017
    IMAP Error in /usr/share/roundcube/program/lib/Roundcube/rcube_imap.php (193):
    Login failed for [email protected] from 79.79.62.1. Unable to negotiate TLS
    and when i remove tls:// from the config line just leaving the mail.tlsystems.co.uk it does connect, but refuses to send an email, giving this error:
    An error occured.SMTP Error (250): Authentication failed.
    i use the following configs in /etc/roundcube/config.inc.php :
    $config['smtp_server'] = 'mail.tlsystems.co.uk';
    $config['smtp_port'] = 587;
    $config['smtp_user'] = '%u';
    $config['smtp_pass'] = '%p';

    What i want ideally is to connect via https://addomainihost/webmail , the user can login in securely and send an email all the while TLS is securely doing send/receive via roundcube.
     
  3. chief

    chief Member HowtoForge Supporter

    fixed it..
    I missed this from mail.tlsystems.co.uk, i never added web.tlsystems.co.uk IP - so it didnt trust the server.
    mynetworks = 127.0.0.0/8 79.79.62.10 [::1]/128
    i also added this to web.tlsystems.co.uk /etc/roundcube/config.inc.php
    $config['imap_conn_options'] = array('ssl' => array('verify_peer' => false,'verfify_peer_name' => false,),);
    $config['smtp_conn_options'] = array('ssl' => array('verify_peer' => false,'verify_peer_name' => false,),);
    can you advise if the server is communication via TLS port 143 ?

    here are all my settings from that file..
    $config['default_host'] = 'tls://mail.tlsystems.co.uk';
    $config['imap_conn_options'] = array('ssl' => array('verify_peer' => false,'verfify_peer_name' => false,),);
    $config['smtp_conn_options'] = array('ssl' => array('verify_peer' => false,'verify_peer_name' => false,),);
    $config['smtp_server'] = 'tls://mail.tlsystems.co.uk';
    $config['smtp_port'] = 587;
    $config['smtp_user'] = '%u';
    $config['smtp_pass'] = '%p';
    $config['support_url'] = '';
    $config['product_name'] = 'Roundcube Webmail';
    $config['des_key'] = *************
    $config['plugins'] = array();
    $config['ski n'] = 'larry';
    $config['enable_spellcheck'] = false;
     
  4. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    Is that the exact error message? Is there a typo in your config and the .co is missing from hostname?
     
  5. chief

    chief Member HowtoForge Supporter

    yes thats correct. i own the tlsystems.co.uk and the tlsystems.uk domains.
    last post i made was how i fixed it. at least for now anyways. i want to confirm that im using TLS and its secure..
     
  6. chief

    chief Member HowtoForge Supporter

    I have roundcube working now.
    I have another question, currently phpmyadmin is on web.tlsystems.co.uk and when i login it shows localhost databases (web.tlsystems.co.uk).
    I want to choose to login to db.tlsystems.co.uk when at login screem, i followed post you made 2 years ago, but it doesnt work. here is the post.
    I do see db.tlsystems.co.uk in a list, i logs in and shows web.tlsystems.co.uk databases.
    what do i need to change for it to work.

    thanks
     
  7. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    I don't quite understand what you mean in the previous post. If it is unrelatet to the previous posts in this thread, you should start a new thread.
    I gather the Roundcube problem is now solved, is that so? Care to write what was the problem and how it was fixed?
    As to the new problem, if you want to log in to PHPMyAdmin on host db.tlsystems.co.uk, and write in browser http://db.tlsystems.co.uk/phpmyadmin, are you taken to some other host? Have you changed hostnames or something, and PHPMyAdmin configuration config-db.php now points dbserver to that other host instead of localhost?
     
  8. chief

    chief Member HowtoForge Supporter

    Hi Taleman, my post above #43 says i fixed it.
    Basically, i didnt add to /etc/postfox/main.cf the IP address of the web.tlsystems.co.uk web server, plus when i added the options in #43 it all worked.
    So, my issue is. when i go to web.tlsystems.co.uk/phpmyadmin it shows the databases on web.tlsystems.co.uk. I found articles plus you article stating from 1 webserver you can view different database servers, by editing the config files. So if i select a different database server from the pull down i can login.
    I suppose i could install phpmyadmin and php to db.tlsystems.co.uk, but i wanted web.tlsystems.co.uk to hold phpmyadmin.
    I just need to edit the config files for phpmyadmin correctly.
    I edited /etc/phpmyadmin/config.inc.php and added :
    /**
    * Server(s) configuration
    */
    $i = 0;
    // The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0].
    // You can disable a server config entry by setting host to ''.
    $i++;
    //BOF adding servers here

    $cfg['Servers'][$i]['verbose'] = 'web.tlsystems.co.uk';
    $cfg['Servers'][$i]['host'] = 'localhost';
    $cfg['Servers'][$i]['port'] = 3306;
    $cfg['Servers'][$i]['socket'] = '';
    $cfg['Servers'][$i]['connect_type'] = 'tcp';
    $cfg['Servers'][$i]['extension'] = 'mysqli';
    $cfg['Servers'][$i]['auth_type'] = 'cookie';
    $cfg['Servers'][$i]['user'] = '';
    $cfg['Servers'][$i]['password'] = '';

    /* Server: db.tlsystems.co.uk [2] */
    $i++;
    $cfg['Servers'][$i]['verbose'] = 'db.tlsystems.co.uk';
    $cfg['Servers'][$i]['host'] = 'db.tlsystems.co.uk';
    $cfg['Servers'][$i]['port'] = '3306';
    $cfg['Servers'][$i]['socket'] = '';
    $cfg['Servers'][$i]['connect_type'] = 'tcp';
    $cfg['Servers'][$i]['extension'] = 'mysqli';
    $cfg['Servers'][$i]['auth_type'] = 'cookie';
    $cfg['Servers'][$i]['user'] = '';
    $cfg['Servers'][$i]['password'] = '';


    //EOF adding servers here

    my aim is to have a select box which i have from web.tlsystems.co.uk/phpmyadmin, then choose other database server (db.tlsystems.co.uk) put username and password in, then phpmyadmin accesses it and allowes me to edit create and do stuff on other server.
     

Share This Page