Topic: Webmail not working after YUM update

[jhirizarry]

All,

I realize this topic has already been discussed. I have reviewed the topics as well as the bug report for this problem. After hours of review I am still not able to login to my webmail. The following error is displayed.

The requested URL /webmail//imp/redirect.php was not found on this server.

I do not have a custom template, rather just the original template in

/etc/e-smith/templates/home/httpd/html/horde/config/registry.php

I modified 110AppRegistryHorde as suggested to the following:

// 110AppRegistryHorde
$this->applications['horde'] = array(
    'fileroot' => dirname(__FILE__) . '/..',
    'webroot' => _detect_webroot (),
    'initial_page' => 'login.php',
    'name' => _("Horde"),
    'status' => 'active',
    'templates' => dirname(__FILE__) . '/../templates',
    'provides' => 'horde'
);
//

I have rebooted/reconfigured several times with no luck.

registry.php is being changed to reflect the change I made in 110AppRegistryHorde, however, when I bring up webmail, I receive the same error message.

Also, the nice color scheme is gone from the main login page.

I have also renamed registry.php.dist back to registry.php... same problem.

What am I missing.

Thanks so much!!

john

[jfarschman]

John,

  A couple of things.  First, this problem is cause by a template in templates-customer not templates.  Generally, it's a bad idea to modify anything in the templates directory.  Templates is where they developers (who build the rpm) place their work.  

If you or I want to do work we would create a similar directory structure in templates-custom and make the modifications there.  This way if new updates are loaded and you have a problem (like you do today) you can just delete the templates-custom directory and things will work again.  When the actual config files are being built from the templates... the templates-custom files (if they exist) will be used over the templates (default) files.

Let me recap on this will real examples.  The template that is causing you grief is not here:

/etc/e-smith/templates/home/httpd/html/horde/config/registry.php

but here:

/etc/e-smith/templates-custom/home/httpd/html/horde/config/registry.php

#2  I would try using this in the 110AppRegistryHorde webroot entry

'webroot' => '/horde',

rather than this

 'webroot' => _detect_webroot (),

I hope I made this clear.  It seems to me you are just working in the wrong place and hopefully, after reading this you will have an AHA moment.  Good luck.

[jhirizarry]

That make perfect sence. I went ahead and followed your instructions to the letter. The registry.php file now has "/horde' as webroot and the webmail login displays correctly with the blue bar at the top and the Horde icon. NOW for the weird thing...

I cannot login!!!  I used my user name and password and it fails. I then tried the user admin, same thing login failed!

https://mydomain/horde/imp/login.php?imapuser=admin&logout_reason=failed

What the heck is that all about?

I'm almost there.. I can feel it!

Any ideas?

Thanks for the explanation on the templates.

John

[jfarschman]

Hmmm,

  Try starting over with the 10AppRegistryHorde files from the templates directory.  Maybe you are using the old one.  Try starting with a fresh one.

  I had this problem and this did fix it.

[jhirizarry]

Ok. I did that... same thing happens. SO.. I decided to look further and review the logs. By the looks of it, it appears as though sme is trying to do an update on horde but it is failing the root password. Take a look at this and tell me what you think.

sme1 20mysql_migrate_horde: ERROR
Aug  8 20:58:44 sme1 20mysql_migrate_horde:  ): Access denied for user 'root'@'localhost' (using password: YES)
Aug  8 20:58:44 sme1 mysql.init: Loading 20mysql_migrate_horde into mysql failed
Aug  8 20:58:44 sme1 21horde.mysql_set_password: ERROR
Aug  8 20:58:44 sme1 21horde.mysql_set_password:  ): Access denied for user 'root'@'localhost' (using password: YES)
Aug  8 20:58:44 sme1 mysql.init: Loading 21horde.mysql_set_password into mysql failed
Aug  8 20:58:44 sme1 30horde_mysql_create_tables: ERROR ): Access denied for user 'root'@'localhost' (using password: YES)
Aug  8 20:58:44 sme1 mysql.init: Loading 30horde_mysql_create_tables into mysql failed
Aug  8 20:58:46 sme1 40horde_mysql_create_indexes: DBI connect('horde','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /etc/e-smith/events/actions/horde_create_indexes line 46
Aug  8 20:58:46 sme1 mysql.init: Loading 40horde_mysql_create_indexes into mysql failed
Aug  8 20:58:47 sme1 50turba_upgrade: DBI connect('horde','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /etc/e-smith/events/actions/turba_upgrade line 44
Aug  8 20:58:47 sme1 55horde-3.0_to_3.1: ERROR
Aug  8 20:58:47 sme1 55horde-3.0_to_3.1:  ): Access denied for user 'root'@'localhost' (using password: YES)
Aug  8 20:58:47 sme1 mysql.init: Loading 55horde-3.0_to_3.1 into mysql failed
Aug  8 20:58:48 sme1 56horde-3.1_alter_table: DBI connect('horde','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /etc/e-smith/events/actions/horde_alter_table line 46
Aug  8 20:58:48 sme1 mysql.init: Loading 56horde-3.1_alter_table into mysql failed
Aug  8 20:58:48 sme1 77horde_mysql_update_privs: ERROR
Aug  8 20:58:48 sme1 77horde_mysql_update_privs:  ): Access denied for user 'root'@'localhost' (using password: YES)
Aug  8 20:58:48 sme1 mysql.init: Loading 77horde_mysql_update_privs into mysql failed
Aug  8 21:09:09 sme1 20mysql_migrate_horde: ERROR
Aug  8 21:09:09 sme1 20mysql_migrate_horde:  ): Access denied for user 'root'@'localhost' (using password: YES)
Aug  8 21:09:09 sme1 mysql.init: Loading 20mysql_migrate_horde into mysql failed
Aug  8 21:09:09 sme1 21horde.mysql_set_password: ERROR
Aug  8 21:09:09 sme1 21horde.mysql_set_password:  ): Access denied for user 'root'@'localhost' (using password: YES)
Aug  8 21:09:09 sme1 mysql.init: Loading 21horde.mysql_set_password into mysql failed
Aug  8 21:09:09 sme1 30horde_mysql_create_tables: ERROR
Aug  8 21:09:09 sme1 30horde_mysql_create_tables:  ): Access denied for user 'root'@'localhost' (using password: YES)
Aug  8 21:09:09 sme1 mysql.init: Loading 30horde_mysql_create_tables into mysql failed
Aug  8 21:09:11 sme1 40horde_mysql_create_indexes: DBI connect('horde','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /etc/e-smith/events/actions/horde_create_indexes line 46
Aug  8 21:09:12 sme1 mysql.init: Loading 40horde_mysql_create_indexes into mysql failed
Aug  8 21:09:13 sme1 50turba_upgrade: DBI connect('horde','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /etc/e-smith/events/actions/turba_upgrade line 44
Aug  8 21:09:13 sme1 55horde-3.0_to_3.1: ERROR ): Access denied for user 'root'@'localhost' (using password: YES)
Aug  8 21:09:13 sme1 mysql.init: Loading 55horde-3.0_to_3.1 into mysql failed
Aug  8 21:09:14 sme1 56horde-3.1_alter_table: DBI connect('horde','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /etc/e-smith/events/actions/horde_alter_table line 46
Aug  8 21:09:14 sme1 mysql.init: Loading 56horde-3.1_alter_table into mysql failed
Aug  8 21:09:14 sme1 77horde_mysql_update_privs: ERROR
Aug  8 21:09:14 sme1 77horde_mysql_update_privs:  ): Access denied for user 'root'@'localhost' (using password: YES)
Aug  8 21:09:14 sme1 mysql.init: Loading 77horde_mysql_update_privs into mysql failed
Aug  8 21:42:58 sme1 HORDE[4389]: [imp] FAILED LOGIN 192.168.0.100 to imap.example.com:143[imap/notls] as john [on line 258 of "/home/httpd/html/horde/imp/lib/Auth/imp.php"]
Aug  8 21:43:07 sme1 HORDE[4389]: [imp] FAILED LOGIN 192.168.0.100 to imap.example.com:143[imap/notls] as john [on line 258 of "/home/httpd/html/horde/imp/lib/Auth/imp.php"]
Aug  8 21:43:28 sme1 HORDE[4386]: [imp] FAILED LOGIN 192.168.0.100 to imap.example.com:143[imap/notls] as john [on line 258 of "/home/httpd/html/horde/imp/lib/Auth/imp.php"]
Aug  8 21:43:35 sme1 HORDE[4386]: [imp] FAILED LOGIN 192.168.0.100 to imap.example.com:143[imap/notls] as john [on line 258 of "/home/httpd/html/horde/imp/lib/Auth/imp.php"]
Aug  8 21:43:53 sme1 HORDE[4387]: [imp] FAILED LOGIN 192.168.0.100 to imap.example.com:143[imap/notls] as admin [on line 258 of "/home/httpd/html/horde/imp/lib/Auth/imp.php"]
Aug  8 21:44:02 sme1 HORDE[4388]: [imp] FAILED LOGIN 192.168.0.100 to imap.example.com:143[imap/notls] as admin [on line 258 of "/home/httpd/html/horde/imp/lib/Auth/imp.php"]
Aug  9 11:25:14 sme1 20mysql_migrate_horde: ERROR ): Access denied for user 'root'@'localhost' (using password: YES)
Aug  9 11:25:14 sme1 mysql.init: Loading 20mysql_migrate_horde into mysql failed
Aug  9 11:25:14 sme1 21horde.mysql_set_password: ERROR
Aug  9 11:25:14 sme1 21horde.mysql_set_password:  ): Access denied for user 'root'@'localhost' (using password: YES)
Aug  9 11:25:14 sme1 mysql.init: Loading 21horde.mysql_set_password into mysql failed
Aug  9 11:25:14 sme1 30horde_mysql_create_tables: ERROR
Aug  9 11:25:14 sme1 30horde_mysql_create_tables:  ): Access denied for user 'root'@'localhost' (using password: YES)
Aug  9 11:25:14 sme1 mysql.init: Loading 30horde_mysql_create_tables into mysql failed
Aug  9 11:25:16 sme1 40horde_mysql_create_indexes: DBI connect('horde','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /etc/e-smith/events/actions/horde_create_indexes line 46
Aug  9 11:25:16 sme1 mysql.init: Loading 40horde_mysql_create_indexes into mysql failed
Aug  9 11:25:17 sme1 50turba_upgrade: DBI connect('horde','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /etc/e-smith/events/actions/turba_upgrade line 44
Aug  9 11:25:17 sme1 55horde-3.0_to_3.1: ERROR
Aug  9 11:25:19 sme1 55horde-3.0_to_3.1:  ): Access denied for user 'root'@'localhost' (using password: YES)
Aug  9 11:25:20 sme1 mysql.init: Loading 55horde-3.0_to_3.1 into mysql failed
Aug  9 11:25:21 sme1 56horde-3.1_alter_table: DBI connect('horde','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /etc/e-smith/events/actions/horde_alter_table line 46
Aug  9 11:25:21 sme1 mysql.init: Loading 56horde-3.1_alter_table into mysql failed
Aug  9 11:25:22 sme1 77horde_mysql_update_privs: ERROR
Aug  9 11:25:22 sme1 77horde_mysql_update_privs:  ): Access denied for user 'root'@'localhost' (using password: YES)
Aug  9 11:25:23 sme1 mysql.init: Loading 77horde_mysql_update_privs into mysql failed
Aug  9 11:44:49 sme1 20mysql_migrate_horde: ERROR
Aug  9 11:44:49 sme1 20mysql_migrate_horde:  ): Access denied for user 'root'@'localhost' (using password: YES)
Aug  9 11:44:49 sme1 mysql.init: Loading 20mysql_migrate_horde into mysql failed
Aug  9 11:44:49 sme1 21horde.mysql_set_password: ERROR
Aug  9 11:44:49 sme1 21horde.mysql_set_password:  ): Access denied for user 'root'@'localhost' (using password: YES)
Aug  9 11:44:49 sme1 mysql.init: Loading 21horde.mysql_set_password into mysql failed
Aug  9 11:44:49 sme1 30horde_mysql_create_tables: ERROR
Aug  9 11:44:49 sme1 30horde_mysql_create_tables:  ): Access denied for user 'root'@'localhost' (using password: YES)
Aug  9 11:44:49 sme1 mysql.init: Loading 30horde_mysql_create_tables into mysql failed
Aug  9 11:44:51 sme1 40horde_mysql_create_indexes: DBI connect('horde','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /etc/e-smith/events/actions/horde_create_indexes line 46
Aug  9 11:44:52 sme1 mysql.init: Loading 40horde_mysql_create_indexes into mysql failed
Aug  9 11:44:52 sme1 50turba_upgrade: DBI connect('horde','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /etc/e-smith/events/actions/turba_upgrade line 44
Aug  9 11:44:53 sme1 55horde-3.0_to_3.1: ERROR
Aug  9 11:44:53 sme1 55horde-3.0_to_3.1:  ): Access denied for user 'root'@'localhost' (using password: YES)
Aug  9 11:44:53 sme1 mysql.init: Loading 55horde-3.0_to_3.1 into mysql failed
Aug  9 11:44:53 sme1 56horde-3.1_alter_table: DBI connect('horde','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /etc/e-smith/events/actions/horde_alter_table line 46
Aug  9 11:44:53 sme1 mysql.init: Loading 56horde-3.1_alter_table into mysql failed
Aug  9 11:44:53 sme1 77horde_mysql_update_privs: ERROR
Aug  9 11:44:53 sme1 77horde_mysql_update_privs:  ): Access denied for user 'root'@'localhost' (using password: YES)
Aug  9 11:44:53 sme1 mysql.init: Loading 77horde_mysql_update_privs into mysql failed
Aug  9 11:48:48 sme1 HORDE[4397]: [imp] FAILED LOGIN 66.159.217.2 to imap.example.com:143[imap/notls] as john [on line 258 of "/home/httpd/html/horde/imp/lib/Auth/imp.php"]
Aug  9 11:48:59 sme1 HORDE[4398]: [imp] FAILED LOGIN 66.159.217.2 to imap.example.com:143[imap/notls] as john [on line 258 of "/home/httpd/html/horde/imp/lib/Auth/imp.php"]
Aug  9 11:49:12 sme1 HORDE[4397]: [imp] FAILED LOGIN 66.159.217.2 to imap.example.com:143[imap/notls] as admin [on line 258 of "/home/httpd/html/horde/imp/lib/Auth/imp.php"]
Aug  9 11:49:48 sme1 HORDE[4399]: [imp] FAILED LOGIN 66.159.217.2 to imap.example.com:143[imap/notls] as admin [on line 258 of "/home/httpd/html/horde/imp/lib/Auth/imp.php"]
Aug  9 12:22:45 sme1 HORDE[4398]: [imp] FAILED LOGIN 66.159.217.2 to imap.example.com:143[imap/notls] as admin [on line 258 of "/home/httpd/html/horde/imp/lib/Auth/imp.php"]
Aug  9 12:22:58 sme1 HORDE[4398]: [imp] FAILED LOGIN 66.159.217.2 to imap.example.com:143[imap/notls] as john [on line 258 of "/home/httpd/html/horde/imp/lib/Auth/imp.php"]
Aug  9 19:53:35 sme1 HORDE[4400]: [imp] FAILED LOGIN 192.168.0.1 to imap.example.com:143[imap/notls] as john [on line 258 of "/home/httpd/html/horde/imp/lib/Auth/imp.php"]

Ok, so what is imap.example.com?? What file is that in? Also, I checked in mysql and looked at the horde database. There is no data in the horde_users table!

I'm stuck!!  

[pfloor]

sme1 20mysql_migrate_horde: ERROR
Aug  8 20:58:44 sme1 20mysql_migrate_horde:  ): Access denied for user 'root'@'localhost' (using password: YES)

You have changed the root password to mysql. The root password is automatically generated and is 76 char long.  You need to sort that out before going any further.  See these instructions:

http://wiki.contribs.org/MySQL#Resetting_the_MySQL_root_password

After re-setting the password, you should probably also run:

signal-event post-upgrade
signal-event reboot

[jhirizarry]

You guys are great!! That did it! I'm back in.  Are there 2 root users on the system? I noticed in the user table in the mysql database that there are 2 root users. 1 for localhost and the other for the sme server itself.