Re: [otrs] backup.pl password error

There's no magic in running mysqldump if you run it manually vs backup.pl. And to an icky point if you can do it manually, you could modify the script so it works the same as when you type it.. Creds and all. On May 9, 2013 9:10 PM, "Johnson, Shannon" wrote:

I checked the permissions on c:\program files\otrs (which would, I assume, be OTRS_HOME) but nothing. I'm running OTRS on Windows (so it's actually a small miracle I've gotten the script to run as far as it has.) so it's not running from /opt/otrs. Could that be my problem?

From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Gerald Young Sent: Wednesday, May 08, 2013 6:30 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] backup.pl password error

it could be possible that OTRS_HOME isn't accessible from the current user, or you're running it from other than /opt/otrs>

On Wed, May 8, 2013 at 9:05 PM, Johnson, Shannon wrote: Hello,

I am trying to get the backup.pl script to run, but am running into an error when the script attempts to run mysqldump:

"Dump MySQL rdbms ... mysqldump: Got error: 1045: Access denied for user 'otrs'@'localhost' (using password: YES) when trying to connect"

I have checked the settings in Kernel/config.pm - tried both typing the correct password in directly and also pasting the "crypted" password (obtained using otrs.CryptPassword.pl) - but to no avail.

I can successfully run mysqldump.exe directly using the same command the backup.pl script seems to want to generate: mysqldump -u otrs -p######## -h localhost OTRS > c:\otrs_backups\databasebackup.sql

It's as if the backup.pl script isn't actually consulting Config.pm for the database password or something. I'm stumped.

Help, please?

Thanks in advance, Shannon --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs