Hi Patrick, Just the other day we had the hard drive on our OTRS system crash. We were running backup.pl scripts daily on a CRON job and backing that whole thing up with BRU. We reinstalled the OS on a new hard drive, then restored the files created from the backup.pl script (again, using BRU), however, the restore.pl script didn't work. In-fact, nothing about the restore.pl even worked. Luckily for our knowledge of MySQL, we simply deleted the database and tables that the restore.pl script did a lousy job of trying to restore and created a fresh OTRS database without any tables. We then imported the .sql file (our was called DatabaseBackup.sql) directly into MySQL. Once we did this, we restarted MySQL, httpd, crond, and the otrs services. We had our system back in a matter of minutes once we did that process. It took us 9 hours of tinkering with it and even made attempts to modify the restore.pl script due to the same errors that you got below. The OTRS system kept calling no joy. My suggestion, leave the restore.pl script alone, import the .sql file directly into the MySQL Database and I believe that you'll find the process much easier. Good luck. -Jeff Patrick Evans wrote:
Hi,
I am getting access denied when I'm trying to run the restore.pl file. I basically installed the OTRS on a new machine and now trying to run the restore.pl of a backup. Here is the error I'm getting:
Restore scripts/backup//Config.tar.gz...
DBI connect('database=otrs;host=localhost;','otrs',...) Failed: Access denied for user 'otrs'&'localhost' (using password: XXXX) at C:/otrs/otrs/kernel/system/ DB.pm line 197 Error: OTRS-Restore-10 Perl: 5.8.8 OS: MSWin32 Time: Message: Access denied for user 'otrs'@'localhost' (using password: XXXX)
Traceback(3588) Module: Kernel::System::DB::new (v1.73) Line: 174 Module: scripts/restore.pl (v1.4) Line: 84
I know it is a new install but shouldn't it allow access after installing if it has no user information? If not how do I give the restore.pl access? Do I have to copy over the permissions from the backup and if so what file do I need to copy over?
Thanks.
_______________________________________________ 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 Support or consulting for your OTRS system? => http://www.otrs.com/