Topic: Webmail problem

[John]

I've restricted access to mysql - every account needs password to connect.
I've created database for horde with tables.
Also account hordemgr created and assigned permission for that database.
In file "db_mysql.inc" added info like this
/* public: connection parameters
  var $Host     = "localhost";
  var $Database = "horde";
  var $User     = "hordemgr";
  var $Password = "pass";

But I get this 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

Line 73 looks like ti gets data from example abobe ($host, $database...)
Am I far off track here?

Thanks for any help.
John

[Gman]

Can you log into the db manually ?  

mysql -u hordemgr -p
pass

What do you get ?

What type of permissions did you give the db for the user hordemgr ?  After you added the user and password, did you "FLUSH PRIVILEGES"

~g

[John]

Thank you for your reply.
Yes I can connect to mysql using ssh, without any problem.
I also did permissions as  *.* for user hordemgr (i dont like this, but just to test it)
Again I can connect manually, but through browser i get same error.
SME server 5.1.2 with update 1.
mysql v3.23.36

Printing, samba & squid are stopped

Thanks,
John

[Alex Henriksen]

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

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

[John]

THANK YOU ALEX! Is there any more info on this subject. sme docs are just basic stuff. I haven't seen any references to 30mysql.create.horde.sql. Only thing that I had to change is get rid of @ =  mysql -p < /etc/e-smith/sql/init/30mysql.create.horde.sql
Password: and hit - Just in case someone else needs it.

regards,
John