Topic: email prop in MySqL :(

[Speedy]

i just enabled webmail and tried step II... but i cant go any further here's  what i get

note... i have changed root password... to a 8 digit.. so if i have to change something plz reply me in with ******** can u??

o well.. i get the following error

Warning: Access denied for user: 'hordemgr@localhost' (Using password: YES) in /home/httpd/horde-phplib/db_mysql.inc on line 73

Warning: Access denied for user: 'hordemgr@localhost' (Using password: YES) in /home/httpd/horde-phplib/db_mysql.inc on line 73

Warning: Access denied for user: 'hordemgr@localhost' (Using password: YES) in /home/httpd/horde-phplib/db_mysql.inc on line 73
 
further of all i looked at h=the user for mysql and i cant find a hordemgr for localhost

current settings : public https only standard (and all of the standard conf )
pop works just fine...

[Dan Brown]

You're saying you've changed the mysql root password?  Very bad idea.  Take a look at http://www.familybrown.org/howtos/mysql-password-howto.html for some information about why.

If there's really no hordemgr user (don't know why, but I guess it's possible), you'll need to create one.  Start mysql, then run

mysql> grant all on horde.* to hordemgr@localhost identified by 'hordemgr';

I'm 99% sure that SME 5.1.2 keeps the default password for hordemgr as hordemgr, but if it doesn't work that way, change the end to

    identified by 'horde';

[John]

I wouldn't say that assinging password to the root for mysql is bad idea. I think is other way around. Just my opinion.
Anyhow to fix you problem run this:

mysql -p < /etc/e-smith/sql/init/30mysql.create.horde.sql

[Dan Brown]

The mysql root already has a password, and, as I mentioned in the above-referenced howto, it's a 76-character random string.  There's no good reason (at least not that I've seen) to change it on an SME box.