Gerald, You're a star. I just removed the "if" clause that was referencing $DatabasePw and simply pasted the command (creds and all, which kinda sucks, but oh well) and it ran fine.
Thanks for your help, Shannon From: [email protected] [mailto:[email protected]] On Behalf Of Gerald Young Sent: Thursday, May 09, 2013 6:17 PM To: User questions and discussions about OTRS. Subject: 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" <[email protected]> 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: [email protected] [mailto:[email protected]] 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 <[email protected]> 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 --------------------------------------------------------------------- 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
