Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: Ari on October 30, 2001, 05:53:14 PM

Title: SME 5.0 and webmail
Post by: Ari on October 30, 2001, 05:53:14 PM

I seem to have uncovered a unique problem (probably not, but here goes):

Constants:
I have a fresh install of SME 5.0 with update 2 running.
I have upgraded PHP to 4.06
phpMyAdmin shows the following databases:
mysql
test
I'm at an off-site location, logging in through https to get my mail.

Problem:
I point my browser to https://www.myservername.com/webmail
I log in as per nomal with the correct username and password.
I am then shown the contents of my mailbox
I click on a message and I get booted out to the login screen again.

Any ideas?

Ari

Title: Re: SME 5.0 and webmail
Post by: Rich Lafferty on October 30, 2001, 07:02:43 PM

Your Horde database has disappeared somehow. You need it because
the active_sessions table within is what keeps track of your
IMAP authentication information during a webmail session.

You can reload the database by disabling and then re-enabling webmail in the server-manager.

Hope this helps,

  -Rich

Title: Re: SME 5.0 and webmail
Post by: Ari on October 30, 2001, 08:32:52 PM

Went into the manager, disabled webmail, re-enabled it and it brought down the http services!

After a server re-boot, still no horde database and, sadly, still the same problem.

I believe that you're on the right path though... Horde is necessary in order to retain the IMAP authentication during webmail sessions.

So... any other ideas (short of yet another completely clean re-installation)

Ari

Title: Re: SME 5.0 and webmail
Post by: Steve MacGregor on October 30, 2001, 08:35:20 PM

I had exactly the same problem! No horde db.

steve

Title: Re: SME 5.0 and webmail
Post by: Rich Lafferty on October 30, 2001, 09:33:16 PM

Well, Horde is already there (else webmail wouldn't be working at all) -- you're just missing that particular database.

Since you've got phpMyAdmin there, you may wish to just
create the database yourself. The schema is listed in

/home/httpd/html/horde/scripts/database/mysql_create.sql

Cheers,

  -Rich

Title: Re: SME 5.0 and webmail
Post by: Ari on October 30, 2001, 11:02:08 PM

Yep.
Everything is fine now.

# mysql -u root < /home/httpd/html/horde/scripts/database/mysql_create.sql

Thanks for the help!

Ari