PDA

View Full Version : error: 'Access denied for user 'root'@'localhost'



TimeJunky
January 13th, 2007, 03:16 PM
Hello,

after installation of zamanda 1.1.3 I got in trouble. Does anyone has a solution for that problem?

I guess, that passwords containing a '...#...' are making problems. If so, could it be a result of UTF8 on my system?

----------------

Debian Sarge 3.1
ii mysql-zrm 1.1.3 Zmanda Recovery Manager (ZRM) for MySQL is a

added lines to mysql-zrm/mysql-zrm.conf:

#my prefs
user="root"
password="....#..."
mailto="s01@.....net"
# allowed values for backup-mode are "raw" and "logical"
backup-mode=logical
retention-policy=7D
databases = games mysql egw db_ispc
comment=server 1 of r4it - backup of databases
destination = /raid/backup/web

paddy
January 14th, 2007, 03:54 PM
Password containing # might cause problems. Please file a bug in bugzilla (http://forums.zmanda.com/bugzilla)

BTW, what is your problem?

You could use my.cnf to specify in the server/user/password on the machine running ZRM for MySQL.

Paddy

kkg
January 14th, 2007, 08:13 PM
Currently if '#' is present in the password, you will get access denied. The reason for this is a bug in ZRM.

Please do open a bug report with the full mysql-zrm verbose log outout.

TimeJunky
January 14th, 2007, 11:30 PM
Thx for the reponses. Finally, it results in processing with a 'backup-user' (restricted rights) and a password providing no dash.

Using my.conf in debian is not as simple as it might be (encrypted in some way) and I am not preferring that way.