Topic: Webmail no longer works

[ritterhaus]

Running SME 6.01-01. After cleaning up some custom MySql databases webmail no longer functions (obviously cleaned up more than we intended.) Everything else seems to be working. Is there a way to get webmail back, perhaps an "upgrade" procedure that will rebuild the webmail tables in MySql as needed?

[ritterhaus]

I should say I'm perfectly willing to restore the necessary data from backups, but I'm not sure what to restore and I don't want to blow away anyone's mail. Any ideas??

[ergozd]

You will dins sql file at
/home/httpd/html/horde/scripts/db

What you could do is
1 - Backup your existing horde-db
# mysqldump -c horde > /path/to/horde.sql

2 - find out MySQL user for horde (OBS!!! output from command below will show MySQL password for user horde
# /sbin/e-smith/config show horde

3 - Run mysql_create.sql
# mysql --user=horde --password=<MySQL-password> < mysql_create.sql

[ritterhaus]

3 - Run mysql_create.sql
# mysql --user=horde --password=<MySQL-password> < mysql_create.sql

When I do that I get the following:

Code: [Select]

ERROR 1044 at line 16: Access denied for user: 'horde@localhost' to database 'mysql'

Not looking too good. The error I get when accessing the webmail site is 403 (Forbidden) even before I'm prompted to login.[/quote]

[ergozd]

Hi!

1 - Do you have phpmyadmin contrib installed? If you did creating a new database will be easier?

2 - Another possible way to re-configuring your webmail
# /etc/e-smith/events/post-install/S55conf-horde-startup
# /etc/e-smith/events/post-install/S60conf-horde
# /sbin/e-smith/signal-event reboot

3 - If none of above helps pls contact me off-list with an e-mail...

[CharlieBrady]

Running SME 6.01-01. After cleaning up some custom MySql databases webmail no longer functions (obviously cleaned up more than we intended.) Everything else seems to be working. Is there a way to get webmail back, perhaps an "upgrade" procedure that will rebuild the webmail tables in MySql as needed?

/sbin/e-smith/signal-event post-upgrade
/sbin/e-smith/signal-event reboot

[ritterhaus]

None of these things has worked. Should I bite the bullet and pull out the backups or is there some other way? Would an upgrade to 6.5 help?