Hi,

A few day ago, I discovered that the restore.pl script ran the following command:
mysql -f -u$DatabaseUser $DatabasePw -h$DatabaseHost $Database < $Opts{b}/DatabaseBackup.sql
Which on my system wouldn't work I believe.

On my system, I ran the following command to restore the database on another server:
 mysql -f -u $DatabaseUser -pDatabasePw -h $DatabaseHost $Database < $Opts{b}/DatabaseBackup.sql
Maybe there's a bug, and you might want to try and hack the restore.pl script accordingly.

Best regards,

Cyrille

Le 16/07/2013 06:49, Andrew S. Meyer a écrit :

I need some help restoring OTRS.  I have an old config that I would like to put on a test server and then upgrade.  I’m not sure what version of OTRS it was running.  1) how do I find this out 2) when I use the restore script, I come up with these errors:

 

[root@helpdesk ~]# /opt/otrs/scripts/restore.pl -b /home/andrew.meyer/ -d /opt/otrs/

Restore /home/andrew.meyer//Config.tar.gz ...

DBI connect('database=otrs;host=localhost;','otrs',...) failed: Access denied for user 'otrs'@'localhost' (using password: YE

.pm line 256

ERROR: OTRS-Restore-10 Perl: 5.10.1 OS: linux Time: Tue Jul 16 00:35:00 2013

 

Message: Access denied for user 'otrs'@'localhost' (using password: YES)

 

Traceback (14115):

   Module: Kernel::System::DB::new (v1.144) Line: 227

   Module: /opt/otrs/scripts/restore.pl (v1.14) Line: 90

 

Restore /home/andrew.meyer//Application.tar.gz ...

create MySQL

[root@helpdesk ~]#

 

What am I doing wrong?  I’ve tried changing the mysql options for the user to allow ALL permissions, but it doesn’t like that.

 

Thank you,

Andrew Meyer.



---------------------------------------------------------------------
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