Koozali.org: home of the SME Server

Horde 3.0/IMP upgrade now denying webmail login

omnicron

Horde 3.0/IMP upgrade now denying webmail login
« Reply #30 on: July 31, 2005, 10:54:38 PM »
I foudn those two rpms but whn eI run the script again a I get a couple of errors. Any ideas?

Upgrading Horde Modules only





Downloading Horde Components

Uncompressing and moving horde components







Installing base Horde configurations


cp: cannot stat /etc/e-smith/web/common/sme_logo.gif': No such file or director
y

Finishing up horde installation...


Shutting down http:                                        [ FAILED ]
Starting httpd:                                            [   OK   ]
serviceControl: Couldn't system(/etc/rc.d/rc7.d/S85httpd-e-smith, restart):
Couldn't restart httpd-e-smith at /etc/e-smith/events/actions/restart-httpd-full
 line 45.
Stopping crond:                                            [   OK   ]
Starting crond:                                            [   OK   ]

Rebuilding Web Server Manager Left Panel Cache... Can take up to a minute.

Horde 3.0 Components have been successfully installed

[root@webmail rpm]#

omnicron

Horde 3.0/IMP upgrade now denying webmail login
« Reply #31 on: July 31, 2005, 11:00:50 PM »
This is now what my /var/log/messages says:

Jul 31 14:42:03 webmail httpd-e-smith: httpd shutdown failed
Jul 31 14:42:03 webmail httpd-e-smith: httpd startup succeeded
Jul 31 14:49:20 webmail httpd-e-smith: httpd shutdown failed
Jul 31 14:49:20 webmail httpd-e-smith: httpd startup succeeded
Jul 31 14:49:29 webmail crond: crond shutdown succeeded
Jul 31 14:49:29 webmail crond: crond startup succeeded
Jul 31 14:50:00 webmail HORDE[6359]: [horde] DB Error: connect failed:  [nativecode=Access denied for user: 'horde@localhost' (Using password: YES)] ** Array [on line 1308 of "/home/httpd/html/horde/lib/Horde/DataTree/sql.php"]
Jul 31 14:55:00 webmail HORDE[6370]: [horde] DB Error: connect failed:  [nativecode=Access denied for user: 'horde@localhost' (Using password: YES)] ** Array [on line 1308 of "/home/httpd/html/horde/lib/Horde/DataTree/sql.php"]
Jul 31 14:59:15 webmail httpd-e-smith: httpd shutdown failed
Jul 31 14:59:16 webmail httpd-e-smith: httpd startup succeeded
[root@webmail root]#


Again any help would be great.

..::eric::..

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
Horde 3.0/IMP upgrade now denying webmail login
« Reply #32 on: August 01, 2005, 01:09:33 AM »
Quote from: "omnicron"
This is now what my /var/log/messages says:

Jul 31 14:42:03 webmail httpd-e-smith: httpd shutdown failed
Jul 31 14:42:03 webmail httpd-e-smith: httpd startup succeeded
Jul 31 14:49:20 webmail httpd-e-smith: httpd shutdown failed
Jul 31 14:49:20 webmail httpd-e-smith: httpd startup succeeded
Jul 31 14:49:29 webmail crond: crond shutdown succeeded
Jul 31 14:49:29 webmail crond: crond startup succeeded
Jul 31 14:50:00 webmail HORDE[6359]: [horde] DB Error: connect failed:  [nativecode=Access denied for user: 'horde@localhost' (Using password: YES)] ** Array [on line 1308 of "/home/httpd/html/horde/lib/Horde/DataTree/sql.php"]
Jul 31 14:55:00 webmail HORDE[6370]: [horde] DB Error: connect failed:  [nativecode=Access denied for user: 'horde@localhost' (Using password: YES)] ** Array [on line 1308 of "/home/httpd/html/horde/lib/Horde/DataTree/sql.php"]
Jul 31 14:59:15 webmail httpd-e-smith: httpd shutdown failed
Jul 31 14:59:16 webmail httpd-e-smith: httpd startup succeeded
[root@webmail root]#


Again any help would be great.

..::eric::..


I'll have to re-load my test box with 6.0 and run the script again to see if I can dup the copy error.  Don't know why you are getting the errors when trying to shutdown httpd.  I'll see what my reload does on that as well.  Next, either the horde/config/conf.php file didn't expand correctly
or the horde database password was changed.  Do a /sbin/e-smith/config show horde, then edit horde/config/conf.php.  The dbpassword and $conf['sql']['password'] lines should match.  If they don't, then look here /etc/e-smith/templates-custom/home/httpd/html/horde/config/conf.php/ and make sure you have 2 files: 10AllHorde and template-begin.  If you do, then do this
/sbin/e-smith/expand-template /home/httpd/html/horde/config/conf.php and then check the horde/config/conf.php for the password value.  I don't know what was done before the upgrade to php. Did you try to do it manually? Maybe that doesn't matter.  Let me know your results and I'll work on getting a 6.0 server rebuilt and run the scrip on it.

JB
......

omnicron

Horde 3.0/IMP upgrade now denying webmail login
« Reply #33 on: August 01, 2005, 01:41:49 AM »
WOW!  Ok I have no more errors in the /var/log/messages I think it was because I deleted the subsystem lock for the httpd that was failing on the restart. Now it works but doe snot report any errors on it.  Here is what I get when I do that show horde command. I think the problem is the seondline after the DbPassword.  I may have goofed bad somewhere.

[root@webmail log]# /sbin/e-smith/config show horde
horde=service
    DbPassword=ZtempPass
    ZtempPass=horde
    access=full
    imp=installed
    kronolith=installed
    mnemo=installed
    nag=installed
    status=enabled


Sorry about all of this I just followed the scripts and then learned later that I had the wrong RPMs so I had to re-install them some of them didn.t take so I had to install them one at a time with a --force or a --nodeps. I finally have gotten rid of all of my errors but I am still having problems. I will try these other commands here and IW ill post the results. thank you so much for yor time!

-Sincerely,
..::eric::..

omnicron

Horde 3.0/IMP upgrade now denying webmail login
« Reply #34 on: August 01, 2005, 01:52:49 AM »
I do not see a dbpassword and $conf['sql']['password'] lines , well a match that is. Those 2 files do exist and they look like they are fine.

Here is my horde/config/conf.php


// $Horde: horde/config/conf.xml,v 1.74.2.5 2005/03/22 11:40:14 jan Exp $
$conf['debug_level'] = E_ALL;
$conf['max_exec_time'] = 0;
$conf['use_ssl'] = 2;
$conf['server']['name'] = $_SERVER['SERVER_NAME'];
$conf['server']['port'] = $_SERVER['SERVER_PORT'];
$conf['compress_pages'] = true;
$conf['umask'] = 077;
$conf['session']['name'] = 'Horde';
$conf['session']['cache_limiter'] = 'nocache';
$conf['session']['timeout'] = 0;
$conf['cookie']['domain'] = $_SERVER['SERVER_NAME'];
$conf['cookie']['path'] = '/horde';
$conf['sql']['phptype'] = 'mysql';
$conf['sql']['persistent'] = false;
$conf['sql']['protocol'] = 'unix';
$conf['sql']['hostspec'] = 'localhost';
$conf['sql']['username'] = 'horde';
$conf['sql']['password'] = 'ZtempPass';
$conf['sql']['database'] = 'horde';
$conf['sql']['charset'] = 'iso-8859-1';
$conf['auth']['admins'] = array('Administrator' , 'admin@yappadappa.com');
$conf['auth']['checkip'] = true;
$conf['auth']['driver'] = 'composite';
$conf['signup']['allow'] = false;
$conf['signup']['approve'] = true;
$conf['signup']['preprocess'] = false;
$conf['signup']['queue'] = false;
$conf['log']['priority'] = PEAR_LOG_NOTICE;
$conf['log']['ident'] = 'HORDE';
$conf['log']['params'] = array();
$conf['log']['name'] = LOG_SYSLOG;
$conf['log']['type'] = 'syslog';
$conf['log']['enabled'] = true;
$conf['log_accesskeys'] = false;
$conf['prefs']['params']['table'] = 'horde_prefs';
$conf['prefs']['params']['driverconfig'] = 'horde';
$conf['prefs']['driver'] = 'sql';
$conf['datatree']['params']['table'] = 'horde_datatree';
$conf['datatree']['params']['driverconfig'] = 'horde';
$conf['datatree']['driver'] = 'sql';
$conf['group']['driver'] = 'datatree';
$conf['cache']['default_lifetime'] = 1800;
$conf['cache']['params']['dir'] = Horde::getTempDir();
$conf['cache']['driver'] = 'file';
$conf['token']['driver'] = 'none';
$conf['mailer']['params']['auth'] = '0';
$conf['mailer']['type'] = 'smtp';
#$conf['mailer']['params']['sendmail_path'] = '/usr/lib/sendmail';
#$conf['mailer']['params']['sendmail_args'] = '-oi';
#$conf['mailer']['type'] = 'sendmail';
$conf['vfs']['params']['vfs_table'] = 'horde_vfs';
$conf['vfs']['params']['driverconfig'] = 'horde';
$conf['vfs']['type'] = 'sql';
$conf['sessionhandler']['type'] = 'none';
$conf['problems']['email'] = 'admin@yappadappa.com';
$conf['menu']['apps'] = array('accounts', 'imp', 'ingo', 'kronolith', 'mnemo', 'nag', 'turba');
$conf['menu']['always'] = false;
$conf['menu']['links']['help'] = 'all';
$conf['menu']['links']['options'] = 'authenticated';
$conf['menu']['links']['problem'] = 'never';
$conf['menu']['links']['login'] = 'all';
$conf['menu']['links']['logout'] = 'authenticated';
$conf['hooks']['username'] = false;
$conf['hooks']['preauthenticate'] = false;
$conf['hooks']['postauthenticate'] = false;
$conf['hooks']['authldap'] = false;
$conf['kolab']['enabled'] = false;
/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */
$conf['auth']['params']['drivers'] = array(
    'imp' => array('driver' => 'application',
                   'params' => array('app' => 'imp')),
    'mimp' => array('driver' => 'application',
                    'params' => array('app' => 'mimp')));
$conf['auth']['params']['loginscreen_switch'] = '_horde_select_loginscreen';

if (!function_exists('_horde_select_loginscreen')) {
    function _horde_select_loginscreen()
    {
        require_once 'Horde/Browser.php';
        $browser = &new Browser();
        if ($browser->isMobile()) {
            return 'mimp';
        }
        return 'imp';
    }
}


Thanks again,
..::eric::..

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
Horde 3.0/IMP upgrade now denying webmail login
« Reply #35 on: August 01, 2005, 01:54:06 AM »
Quote from: "omnicron"
WOW!  Ok I have no more errors in the /var/log/messages I think it was because I deleted the subsystem lock for the httpd that was failing on the restart. Now it works but doe snot report any errors on it.  Here is what I get when I do that show horde command. I think the problem is the seondline after the DbPassword.  I may have goofed bad somewhere.

[root@webmail log]# /sbin/e-smith/config show horde
horde=service
    DbPassword=
    ZtempPass=horde
    access=full
    imp=installed
    kronolith=installed
    mnemo=installed
    nag=installed
    status=enabled


Sorry about all of this I just followed the scripts and then learned later that I had the wrong RPMs so I had to re-install them some of them didn.t take so I had to install them one at a time with a --force or a --nodeps. I finally have gotten rid of all of my errors but I am still having problems. I will try these other commands here and IW ill post the results. thank you so much for yor time!

-Sincerely,
..::eric::..


Sorry, I didn't really mean for you to paste your dbpassword. You might go and edit your post and remove that since you said it was a semi-production machine. Now that all of the errors are gone, is  webmail still failing?  Did you look in /horde/config/conf.php for the password line to make sure that it matches the dbpassword value, and it not re-expand the template?  The additional line shouldn't get used because nothing should call for it.

JB
......

omnicron

Horde 3.0/IMP upgrade now denying webmail login
« Reply #36 on: August 01, 2005, 02:02:25 AM »
How do I know if my php/horde is working I tried to do the following.

http://website.website.com/horde/test1.php

but nothing shows up. My firewall reports that:
 The system returned:

    (111) Connection refused


Does this help anyone else in figuring this out as well?

I have read and re-read many of the post son these forums.  This problem is similar to a few other posts but I feel it is still a little bit different because of the no-errors and the results returning nothing.

-sincerely,
..::eric::..

omnicron

Horde 3.0/IMP upgrade now denying webmail login
« Reply #37 on: August 01, 2005, 02:03:38 AM »
that was a temp pass I placed in there it is not real.
Thank you for that.

sincerely,
..::eric::..

omnicron

Horde 3.0/IMP upgrade now denying webmail login
« Reply #38 on: August 01, 2005, 02:09:49 AM »
Notice how the password was displayed and then it was displayed again and it equal to horde.

DbPassword=ZtempPass
ZtempPass=horde


Is this normal?

-Sincerely,
..::eric::..

omnicron

Horde 3.0/IMP upgrade now denying webmail login
« Reply #39 on: August 01, 2005, 02:21:15 AM »
Are my rghts wrong?
shouldn.t they be 744 for everything?

drwxr-x---    9 root     www          4096 Feb 12 04:15 accounts
drwxr-x---    5 root     www          4096 Mar 29 04:01 admin
drwxr-x---    2 root     www          4096 Jul 31 17:47 config
-rw-r-----    1 root     www         25275 Feb 11  2000 COPYING
drwxr-x---    2 root     www          4096 Mar 29 04:01 docs
drwxr-x---   10 root     www          4096 Jul 31 17:05 imp
-rw-r-----    1 root     www          2229 Mar  2 00:10 index.php
drwxr-x---   10 root     www          4096 Jan 25  2005 ingo
drwxr-x---    2 root     www          4096 Mar 29 04:01 js
drwxr-x---   10 root     www          4096 May  1 09:06 kronolith
drwxr-x---    9 root     www          4096 Mar 29 04:01 lib
drwxr-x---   39 root     www          4096 Mar 29 04:01 locale
-rw-r-----    1 root     www          5842 Jan 31 09:44 login.php
drwxr-x---   12 root     www          4096 Mar  4 21:01 mimp
drwxr-x---   10 root     www          4096 Jan 25  2005 mnemo
drwxr-x---   10 root     www          4096 Jan 27  2005 nag
drwxr-x---    2 root     www          4096 Mar 29 04:01 po
-rw-r-----    1 root     www          3032 Sep 24  2004 README
-rw-r-----    1 root     www          2359 Jan  3  2005 rpc.php
drwxr-x---    5 root     www          4096 Jul 31 17:05 scripts
drwxr-x---    9 root     www          4096 Mar 29 04:01 services
-rw-r-----    1 root     www          2545 Jan  3  2005 signup.php
drwxr-x---   18 root     www          4096 Jul 31 17:05 templates
----------    1 root     www         13287 Mar  7 04:56 test.php
drwxr-x---   26 root     www          4096 Mar 29 04:01 themes
drwxr-x---   10 root     www          4096 Feb 13 06:13 turba
drwxr-x---    2 root     www          4096 Mar 29 04:01 util


-Sincerely,
..::eric::..

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
Horde 3.0/IMP upgrade now denying webmail login
« Reply #40 on: August 01, 2005, 02:22:57 AM »
Quote from: "omnicron"
I do not see a dbpassword and $conf['sql']['password'] lines , well a match that is. Those 2 files do exist and they look like they are fine.

$conf['sql']['password'] = 'password_removed';

..::eric::..


They do match.  This is the line from your conf.php
file:
$conf['sql']['password'] = 'password_removed';
and the value of your dbpassword
[root@webmail log]# /sbin/e-smith/config show horde
horde=service
DbPassword=password_removed

So, that is good.  Just caught your latest posts.  OK on the password stuff.  My test.php didn't work as well.  The default SME install denies access to test.php files.  Here is what I do:
Go to /home/httpd/html/horde and copy test.php to test1.php.
chown root.www test1.php
chmod 444 test1.php
open browser to myserver/horde/test1.php
remove test1.php when finished.

The extra line in the horde file should't cause any entries because nothing should be trying to look up that property or value.  You can remove this by:
/sbin/e-smith/config delprop horde ZtempPass
Then you should end up with something like:
[root@testmy60 horde]# /sbin/e-smith/config show horde
horde=service
    DbPassword=password
    access=full
    imp=installed
    status=enabled

What do you get when you try to go to webmail?  Still a db error?

JB
......

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
Horde 3.0/IMP upgrade now denying webmail login
« Reply #41 on: August 01, 2005, 02:26:50 AM »
Quote from: "omnicron"
Are my rghts wrong?
shouldn.t they be 744 for everything?

drwxr-x---    9 root     www          4096 Feb 12 04:15 accounts
drwxr-x---    5 root     www          4096 Mar 29 04:01 admin
drwxr-x---    2 root     www          4096 Jul 31 17:47 config
-rw-r-----    1 root     www         25275 Feb 11  2000 COPYING
drwxr-x---    2 root     www          4096 Mar 29 04:01 docs
drwxr-x---   10 root     www          4096 Jul 31 17:05 imp
-rw-r-----    1 root     www          2229 Mar  2 00:10 index.php
drwxr-x---   10 root     www          4096 Jan 25  2005 ingo
drwxr-x---    2 root     www          4096 Mar 29 04:01 js
drwxr-x---   10 root     www          4096 May  1 09:06 kronolith
drwxr-x---    9 root     www          4096 Mar 29 04:01 lib
drwxr-x---   39 root     www          4096 Mar 29 04:01 locale
-rw-r-----    1 root     www          5842 Jan 31 09:44 login.php
drwxr-x---   12 root     www          4096 Mar  4 21:01 mimp
drwxr-x---   10 root     www          4096 Jan 25  2005 mnemo
drwxr-x---   10 root     www          4096 Jan 27  2005 nag
drwxr-x---    2 root     www          4096 Mar 29 04:01 po
-rw-r-----    1 root     www          3032 Sep 24  2004 README
-rw-r-----    1 root     www          2359 Jan  3  2005 rpc.php
drwxr-x---    5 root     www          4096 Jul 31 17:05 scripts
drwxr-x---    9 root     www          4096 Mar 29 04:01 services
-rw-r-----    1 root     www          2545 Jan  3  2005 signup.php
drwxr-x---   18 root     www          4096 Jul 31 17:05 templates
----------    1 root     www         13287 Mar  7 04:56 test.php
drwxr-x---   26 root     www          4096 Mar 29 04:01 themes
drwxr-x---   10 root     www          4096 Feb 13 06:13 turba
drwxr-x---    2 root     www          4096 Mar 29 04:01 util


-Sincerely,
..::eric::..


Your above matches what I have on my 2 test servers and production server.

JB
......

omnicron

Horde 3.0/IMP upgrade now denying webmail login
« Reply #42 on: August 01, 2005, 02:41:50 AM »
Where can I look for additional log errors? I am only looking in the /var/log/messages

I do not see anything that is out of the ordinary I don.t even see any horde errors any more.

Any suggestions.

Oh my test1.php does not seem to work either. I followed your instructions and still have nothing to show for.

-Sincerely,
..::eric::..

omnicron

Horde 3.0/IMP upgrade now denying webmail login
« Reply #43 on: August 01, 2005, 02:50:04 AM »
I am still receiving the following:


[root@webmail horde]# /etc/e-smith/events/actions/restart-httpd-full
Shutting down http:                                        [ FAILED ]
Starting httpd:                                            [   OK   ]
serviceControl: Couldn't system(/etc/rc.d/rc7.d/S85httpd-e-smith, restart):
Couldn't restart httpd-e-smith at /etc/e-smith/events/actions/restart-httpd-full line 45.
[root@webmail horde]#


When I ssh in as admin to the console menu I am not able to access the "Access Server Manager" menu once I enter in my password it drops me back to the first menu.

I think it is somehting with the php RPM install that was performed.  

Now I have backed up my horde.sql and everything but being that I am this far in I'm unsure as to whether I shoudl turn back.. I have faith in the community to help an admin out. So I think I will just trudge fourth and see what is suggested next for this scenario.

-Sincerely,
..::eric::..

Offline mrjhb3

  • *
  • 1,188
  • +0/-0
    • John Bennett Services
Horde 3.0/IMP upgrade now denying webmail login
« Reply #44 on: August 01, 2005, 02:55:12 AM »
Quote from: "omnicron"
Where can I look for additional log errors? I am only looking in the /var/log/messages

I do not see anything that is out of the ordinary I don.t even see any horde errors any more.

Any suggestions.

Oh my test1.php does not seem to work either. I followed your instructions and still have nothing to show for.

-Sincerely,
..::eric::..


Try looking in /var/log/httpd/access_log, and/or error_log.  When you try to access webmail, what error do you get in the browser and in your logs?  I am running out of ideas.  I don't like the fact that some of the php rpm's had to be installed using --nodeps or --force.  Here is all I got left:

1.  You could try a reboot to see if that fixes it.

2.  You can do a /sbin/e-smith/signal-event post-upgrade then /sbin/e-smith/signal-event reboot
This will do all sorts of things, one of which is re-expanding a bunch of templates.

3. You can try to revert back to horde 2.0 using the script in /root/horde20-restore.  I have tested this many times and it has never failed for me, but the one other person that I know that ran this, had a few issues.

JB
......