Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: ritterhaus on November 03, 2005, 03:30:02 AM

Title: Webmail no longer works
Post by: ritterhaus on November 03, 2005, 03:30:02 AM: 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? :-(
Title: Restoring from backups
Post by: ritterhaus on November 03, 2005, 02:49:43 PM: 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??
Title: Webmail no longer works
Post by: ergozd on November 03, 2005, 04:34:28 PM: 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
Title: Webmail no longer works
Post by: ritterhaus on November 04, 2005, 01:47:23 AM: Quote
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]
Title: Webmail no longer works
Post by: ergozd on November 04, 2005, 07:16:15 AM: 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...
Title: Re: Webmail no longer works
Post by: CharlieBrady on November 04, 2005, 11:31:36 PM: Quote from: "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? :-(

/sbin/e-smith/signal-event post-upgrade
/sbin/e-smith/signal-event reboot
Title: Webmail no longer works
Post by: ritterhaus on November 12, 2005, 01:22:57 AM: 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?