Topic: SME 5.0 and webmail

[Ari]

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

[Rich Lafferty]

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

[Ari]

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

[Steve MacGregor]

I had exactly the same problem! No horde db.

steve

[Rich Lafferty]

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

[Ari]

Yep.
Everything is fine now.

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

Thanks for the help!

Ari