Koozali.org: home of the SME Server

Obsolete Releases => SME Server 9.x => Topic started by: mophilly on August 19, 2017, 09:27:17 PM

Title: webmail login page does not load in browser
Post by: mophilly on August 19, 2017, 09:27:17 PM
Posting here first in case of PBCAK.

We set up SME9 on a new server in gateway/server mode; currently running SME 9.2. It has been working well for months. In that time we did not test to see if webmail was working as the server needed only to send advice via email, not act as an email server.

This week we began moving users off an older SME8 server and we are testing to see if email is working on the new SME9 system. When I attempt to load webmail in the browser I get a blank page.
    http://myserver.mydomain.com/webmail/

In the http log I can see the request for the page. No other entries. In http error log I found this:
Code: [Select]
PHP Warning:  require_once(/home/httpd/html/horde/imp/lib/../../lib/core.php) [<a href='function.require-once'>function.require-once</a>]: failed to open stream: No such file or directory in /home/httpd/html/horde/imp/lib/base.php on line 32
PHP Fatal error:  require_once() [<a href='function.require'>function.require</a>]: Failed opening required '/home/httpd/html/horde/imp/lib/../../lib/core.php' (include_path='/usr/share/pear-addons:/usr/share/pear') in /home/httpd/html/horde/imp/lib/base.php on line 32

Continuing to search for clues.

suggestions and pointers warmly accepted.
Title: Re: webmail login page does not load in browser
Post by: mmccarn on August 19, 2017, 10:01:57 PM
When I setup 9.2 I webmail was disabled by default.

My notes say that I enabled it in server-manager -> E-mail -> Change e-mail access settings -> Webmail settings
Title: Re: webmail login page does not load in browser
Post by: mophilly on August 19, 2017, 10:12:32 PM
Thank you. I checked and our server is set to allow webmail via HTTPS.
Title: Re: webmail login page does not load in browser
Post by: Jean-Philippe Pialasse on August 19, 2017, 11:10:20 PM
How did you restore from sme 8. To sme9?

Is it core horde or horde 5 has been installed?

Is there any template custom?


rpm -qa horde
/sbin/e-smith/auditools/templates
Title: Re: webmail login page does not load in browser
Post by: mophilly on August 21, 2017, 12:37:55 AM
Here is more info in answer of Jean-Philippe's questions.

We built the SME9 from the iso image. We moved users, groups, pseudonyms and passwords from SME8 to SME9 using LATools. We can see the accounts, passwords are working (we checked a small number). groups and pseudonyms are present.

Horde 5 has not been installed. I don't believe we have added any custom templates, although odoo, owncloud and postgres have been installed.

>> rpm -qa horde
Code: [Select]
# rpm -qa horde
# rpm -q horde
package horde is not installed

>>/sbin/e-smith/auditools/templates
Code: [Select]
# /sbin/e-smith/audittools/templates
/etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/99allow_url_fopen: MANUALLY_ADDED, ADDITION
/etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/20LoadModule80PHP: OWNED_BY_RPM, OVERRIDE
/etc/e-smith/templates-custom/var/lib/pgsql/data/postgresql.conf: MANUALLY_ADDED, OVERRIDE
/etc/e-smith/templates-custom/var/lib/pgsql/data/pg_hba.conf: MANUALLY_ADDED, OVERRIDE
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/template-begin: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/02ServerName: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/template-end: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/30WebmailAliases: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/40ApacheIconAlias: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/20IbayContent: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/04StrictTransportSecurity: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/25SSLDirectives: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/27ManagerProxyPass: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/00Setup: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/03ServerAlias: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/40ServerResources: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/Owncloud/26RewriteTraceAndTrack: MANUALLY_ADDED
/etc/e-smith/templates/etc/httpd/conf/httpd.conf/VirtualHosts/04StrictTransportSecurity: MANUALLY_ADDED
/etc/e-smith/templates/var/lib/pgsql/data/postgresql.conf: MANUALLY_ADDED
/etc/e-smith/templates/var/lib/pgsql/data/pg_hba.conf: MANUALLY_ADDED
Title: Re: webmail login page does not load in browser
Post by: gsimpson on August 21, 2017, 12:53:01 AM
So, Mark and I were not communicating, in fact, I thought he was enjoying his day off. It turns out that as soon as he did that particular command, the server was coming down after I did a "yum install horde". This is now installed and working.

It was a comedy of timing is all.

I spotted some interesting thing in the logs and as soon as Mark and I look a them, we will post our findings here.
Title: Re: webmail login page does not load in browser
Post by: mophilly on August 21, 2017, 02:06:30 AM
well, that was quite a surprise! And, with horde re-installed, the original topic of this thread is satisfied. Nonetheless, there are a couple of questions outstanding.

First, did all that SME needs get installed by running "yum install horde"? Since horde was deleted in error, I wonder else might be missing... is there a way to update SME9 without performing a backup/re-install/restore?

We, that is Greg and I, are now running an rsync script now to keep the two servers up to date until we are ready to modify the zone record MX values.

Code: [Select]
#!/bin/sh
RSYNC=/usr/bin/rsync
SSH=/usr/bin/ssh
KEY=/root/cron/new-server-rsync-key
RUSER=root
RHOST=10.10.10.1
RPATH=/home/e-smith/files/users/
LPATH=/home/e-smith/files/users/
$RSYNC -az -e "$SSH -i $KEY" $RUSER@$RHOST:$RPATH $LPATH

The second question is this: are the rsync parameters set correctly for moving the files and "status of mail" in horde.
We are noticing differences between the webmail on the old server and that on the new server. For example, the mail marked as read. On the new server all is unread, while on the old server only a very few mails are unread.
Title: Re: webmail login page does not load in browser
Post by: ReetP on August 23, 2017, 01:13:44 AM
Have a look at unison for sync

You can choose to sync user/group permissions and a plethora of other options

http://www.cis.upenn.edu/~bcpierce/unison/download.html
Title: Re: webmail login page does not load in browser
Post by: mophilly on August 23, 2017, 04:03:51 AM
Thank you, ReetP, for the suggestion.

I read through the site and it looks pretty good. My question is does it detect and preserve any indications necessary so that the mail clients connecting to the new server reflect the unread/read status, etc., seen on the old server?
Title: Re: webmail login page does not load in browser
Post by: Jean-Philippe Pialasse on August 23, 2017, 04:53:29 AM
You might have some issue as long as you will have two accessible versions. 
The read status is encoded in the filename. So you might end up with double emails because of the rsync if it has been read on one and then sync again, unless you use the delete flag for rsync.... however you will have then issues if you try then to modify on the  new and rsync fron the old, it will erase modification.

Unison or freefilesync might help as they will allow bilateral sync, but conflicts might still occurs at moment and will need manual resolution...

In other words, solve rather sooner the two servers situation to one only.


See 
https://wiki2.dovecot.org/MailboxFormat/Maildir
Title: Re: webmail login page does not load in browser
Post by: mophilly on August 23, 2017, 05:50:13 AM
Thank you for the info. I will review the dovecot link.

The current plan is update the MX record this weekend, and end the rsync as soon as possible.
Title: Re: webmail login page does not load in browser
Post by: ReetP on August 23, 2017, 10:46:22 AM
Unison can be set as a "1 way sync only" if you are effectively just running a continual backup.
Title: Re: webmail login page does not load in browser
Post by: mophilly on August 27, 2017, 08:32:46 PM
The switch over went pretty well. We learned a bit, but it appears the end user mail is working fine. Tomorrow, Monday, will be the proof when the business offices open.

Next up: reestablish security and anti-spam measures, e.g. fail2Ban, enabling blacklist and dmarc

Thanks for all of the suggestions. They really helped us a lot.