On my SuSe 13.2 server the user language preference for german works. On my new Mailserver debian jessie latest patches, selecting german only works for help text. Any hint? Rainer
additional question, will it be possible to install roundcube parallel to squirrelmail. To implement a password change by user, what would be better squirrelmail or roundcube. Rainer
Found https://www.howtoforge.com/tutorial/roundcube-installation-on-debian-8-jessie/ works fine so far. Installed the ISPConfig Plugin to change password etc. too. Got "Soap Error: DTD are not supported by SOAP" . I am not using https, cause mail server and admin server are private net behind firewall. Found this https://www.howtoforge.com/community/threads/soap-error-dtd-are-not-supported-by-soap.39404/ too, but seams to be quit old and an other problem too. Thank for help or hint. Rainer
Try to run: dpkg-reconfigure locales and ensure that the de_* locales are selected. yes roundcube. I did not had that problem yet. Ensure that you access the right SOAP url ( /remote/ sub folder of the ispconfig URL).
Thank you. Language in squirrelmail, now working, parallel install of roundcube too. "Ensure that you access the right SOAP url ( /remote/ sub folder of the ispconfig URL)." Can you concretize this. My ispconfig3_account/config/config.inc.php looks like <?php $rcmail_config['identity_limit'] = false; $rcmail_config['remote_soap_user'] = 'roundcube'; $rcmail_config['remote_soap_pass'] = '********'; $rcmail_config['soap_url'] = 'http://admin.gerdakloos.de:8080/remote/'; ?> It is a multiserver system with separate ISPConfig admin server, as I understood the installation of the plug should be on the mail server where postfix, dovecot and roundcube are installed. If I do not use ssl, I thnk I can skip the cerificate installation. Thanks Rainer
The plugin is part of roundcube, so you have to install it on th server wher roundcube is installed. the SOAP URL looks fine (if the URL is your ISPConfig master server). yes. If I open http://admin.gerdakloos.de:8080/ then I get a 400 bad request error, so there must be something wrong with that URL. http://admin.gerdakloos.de:8080/ should bring up your ispconfig login and http://admin.gerdakloos.de:8080/remote/ should return just a white page (without an error).
"I do not use SSL" perhaps leads wrong. I mend internally, but yes even itern teh server does not The Admin Page is secured by https. So https://admin.gerdakloos.de:8080 works, https://admin.gerdakloos.de:8080/remote brings up a blank page without error. https://smtp1.gerdakloos.de/mail brigs me to roundcube. Both Servers have valid official cerificated from startcomssl. I have changed the line in ispconfig3_account/config/config.inc.php to https//.. Now going I got the message "Soap Error: Could not connect to host" Both servers, multiserver setup as described in the manual, are on a private net behind a firewall. External access via NAT. Internet itself has mask 255.255.255.240, so each server has ist own external an internal address. Ping to admin.gerdakloos.de rom the console of smtp1.gerdakloos.de resolves in the internal address. I think/hope roudcube plugin will not resolve the external address. /etc/hosts on every server in the multiserver enviorement have all other servers internal (and only internal) addresses listet. All other communication, especially sql, between the servers works. Even openssl_ s_client -connect admin.gerdakloos.de_8080 from console of smtp1 works Any way to debug Thanks Rainer
Ok, so you use https as the remote api connects in the same way that you connect with your browser. Use the same URL plus "/remote/" for the API that you use for the normal browser connections. And I'm not sure if startssl is recognized by PHP as valid SSL authority, so you should add their ssl cert in the way that is described in the tutorial.
I think I have implemented the startssl certificates well, that means, beside the server .crt and .key files also the cain certificates too. In ispconfig-vhost on the admin server SSLCerificateFile, SSLCertificateKeyFile, and SSLCACerificateFile points to the correct Key, cert and CA bundle. Apache starts without errors. ispconfig-vhost .... # SSLCertificateFile /usr/local/ispconfig/interface/ssl/ispserver.crt SSLCertificateFile /etc/ssl/certs/admin.gerdakloos.de.crt # SSLCertificateKeyFile /usr/local/ispconfig/interface/ssl/ispserver.key SSLCertificateKeyFile /etc/ssl/private/admin.gerdakloos.de.key # #SSLCACertificateFile /usr/local/ispconfig/interface/ssl/ispserver.bundle SSLCACertificateFile /etc/ssl/certs/startssl_root_bundle.crt ... on admin server /etc/php5/apache2/php.ini I added openssl.cafile=/etc/ssl/certs/startssl_root_bundle.crt and restarted apache Still the sam error!! By the way admin server ist still an opensuse 13.2, is there an easy or even not easy way to move it to debian jessy. Thanks Rainer
Try to access the remote URL from mail server with a command line browser like lynx or wget, do you get an error? Yes, thats possible. But a bit of manual work as you have to install a new server incl. ispconfig as standalone server and then move over the dbispconfig database and mysql users to the new server.
in my eyes that looks fine " root@smtp1:~# wget https://admin.gerdakloos.de:8080/remote/ converted 'https://admin.gerdakloos.de:8080/remote/' (ANSI_X3.4-1968) -> 'https://admin.gerdakloos.de:8080/remote/' (UTF-8) --2016-05-18 12:20:24-- https://admin.gerdakloos.de:8080/remote/ Resolving admin.gerdakloos.de (admin.gerdakloos.de)... 10.10.1.10 Connecting to admin.gerdakloos.de (admin.gerdakloos.de)|10.10.1.10|:8080... connected. HTTP request sent, awaiting response... 200 OK Length: 0 [text/html] Saving to: 'index.html' index.html [ <=> ] 0 --.-KB/s in 0s 2016-05-18 12:20:24 (0.00 B/s) - 'index.html' saved [0/0] " But from Roundcube still "Soap Error: Could not connect to host" Any other things I can try? Rainer
have troubles moving admin server Did a dump of dbispconfig and user table from mysql save the ispconfig db password from config.inc.php Shut down admin server, installed a new stand alone admin server. same name same address Added "use mysql;" and "drop user;" to the dump of user.sql, both dadatbasese changed the password restored both to knew server restarted apache and mysql get the ispconfig login page but trying login I still remain in login page Any hint, idea Thanks Rainer
Works now, took another browser (safari) may the problem was chrom, having a problem with the self signed certificate Rainer P.S. sorry seams to work, can login into new admin server, all show information seams correct, but database seam not to be updated from slaves, so admin say some servers need updates, dis the updates but the new information ist not shown in monitor, add a test dns A record, job queue fills up with .... 2016-05-20 06:28 ns1.gerdakloos.de Update dns_rr ..... one server was on p8 I did an update to p9, Monitor does not show it. checked sql connection from slaves to master, works fine can conncet from each slave host to admin server with mysql -u root -p -h admin _host Need help hint urgent Services on slave run fine Rainer
I know, but it is now more than 3 hours, adding DNS A record is still int he queue, the ISPConfig update was half an hour earlyer, updateting deian servers too, the ISPConfig version still a p8, two other debian servers I did an software update this morning monitor did not jet recognize. espcially adding an A record need only some minutes. Did I forgot something by moving admin server from suse to debian, as described above.
There is most likely a mysql connection problem hen the queue does not get processed. Try to connect from slave to master with mysql command by using the exact master connection details from /usr/local/ispconfig/server/lib/config.inc.php of the slave. example: mysql -h master.server.tld -u ispcsrv2 -p dbispconfig then enter the password when requested by the command.
Ok seams to the problem, the msyql/user table has all records for the slave with name isp...x and correct IPs hostnames, should be as I copied the table. so what can be wrong, maybe the password (should not as nothing changed on the clients and problem exists on all clients) I would like to set the password new in user table, but there is a hash. I know phpmyadmin cat hash the password, but I need to known the hash algorithm MD5 or or What else could be gone wrong in the move? Rainer Please help, it is uregent. Thank you
The most likely reason are wrong hosts files, ensure that all hosts of all nodes are listed in all hosts files and that the IP addresses for these hosts in mysql match the ones from the hosts files.
host files are correct, there was no reason to change, as I wrote I checked them to match with the mysql/user table, which should be correct as it was created by dump on old master and restore on nee master. The done actions are written above. communication should not be a problem, as I can proberly connect with "mysql -uroot -p -h admin.gerdakloos.de " but I got access erro with " mysql -uispcrvX -p -h admin.gerdakloos.de dbispconfig " where X is the respective number from /usr/local/ispconfig/server/lib/config.inc.php, password taken from there. Thanks Rainer sample error ERROR 1045 (28000): Access denied for user 'ispcrv6'@'http.gerdakloos.de' (using password: YES) are the any log files or can I let create some?
Your issue is a MySQL auth issue and not an ispconfig issue, ispconfig will work again when mysql connections for the ispcsrv users are working again. Please see mysql documentation on how to enabe logging in mysql.