Topic: broken webmail

[stocky]

Hi All,

Ran latest updates on one of my SME 6 boxes today and now webmail is broken!

The "Welcome to Webmail" now reads "Welcome to Horde" and I can't login.

It just returns to the webmail login screen and nothing else.

Any ideas?

[CharlieBrady]

Any ideas?

Report all problems, in detail, via the Bug Tracker.

[mrjhb3]

Any ideas?

Where you by chance running horde 3 instead of horde 2?

JB

[Agent86]

Hi all

I just updated via the SME server-manager selected all updates
And actually got some type of error.The updates appear to be finished and the list is now empty from within the server-manager

My mail client software is working fine via thunderbird etc.but the Horde webmail cannot login
I am getting Login Failed message in yellow at the webmail screen.

Also the server log has this entry when attempting to login:
Dec 26 16:57:43 auction HORDE[31231]: [imp] FAILED LOGIN 10.x.xx.xxx to localhost:143[imap/notls] as icl [on line 237 of "/home/httpd/html/horde/imp/lib/Auth/imp.php"]

All users login to webmail have the same effect and similar server log error

Anyone know how to fix ?

[edb]

Just did an yum update for SME6.0.1.
I was running Horde 3 prior to the update.
After the update I was getting a blank page which is why I tried doing a restore of the /home/httpd/html/horde folder from backup and also doing a retore of the horde database.

Now when I try to go to https://www.xyz.com/webmail I get the following error:
A fatal error has occurred
DB Error: connect failed
Details have been logged for the administrator.

I also get the following errors in the boot log.

Mar 14 16:14:01 mail mysql.init: Loading 20horde.mysql_update_privs.sql into mysql succeeded
Mar 14 16:14:01 mail mysql.init: Loading 20mysql_migrate_horde.sql into mysql succeeded
Mar 14 16:14:02 mail mysql.init: Loading 21horde.mysql_set_password.sql into mysql succeeded
Mar 14 16:14:02 mail mysql.init: Loading 30mysql_create_tables.sql into mysql succeeded
Mar 14 16:14:02 mail 50turba_upgrade_1.1_to_1.2: DBI->connect(horde) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at /etc/e-smith/sql/init/50turba_upgrade_1.1_to_1.2 line 43
Mar 14 16:14:02 mail mysql.init: Loading 50turba_upgrade_1.1_to_1.2 into mysql failed
Mar 14 16:14:03 mail mysql.init: Loading 60migrate-imp-to-turba into mysql succeeded

I noticed that the file "50turba_upgrade_1.1_to_1.2" doesn't exist in the path /etc/e-smith/sql/init/50turba_upgrade_1.1_to_1.2 as it is an empty folder.
Also, are there files locate somewhere else that I should have restored?

[edb]

Ok, I got it fixed finally.

Here is what I had to do:

You need to dump and drop the horde database, remove the horde directory, re-run the script, re-import your horde data, reset the perms.

Here is how:

mysqldump --opt horde > /root/horde_30.sql

mysqladmin drop horde
mv /home/httpd/html/horde /home/httpd/html/horde.30.old
run horde script
mysql horde < /root/horde30.sq
cd /home/httpd/html/horde
sh scripts/set_horde_perms.sh

Instructions from John Bennett as it is his script
http://mirror.contribs.org/smeserver/contribs/jbennett/install_horde30.sh

After this is complete you may still see the DB Connect Error ... if so do this at the console:

1) mysql

2) use mysql

3) UPDATE user SET Password=OLD_PASSWORD('horde') WHERE User='horde';

4) FLUSH PRIVILEGES;

I thought I remembered having to do this once before a long time ago so I did a search on my own previous contribs posts and low & behold I found one of my old posts which was my answer. It has something to do with the way the newer MySQL version handles passwords.

Hope this will help someone else still using SME6x....

edb