[otrs] restoring OTRS to a new server

[Andrew S. Meyer]

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.

[Cyrille Bollu]

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

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

[Florian Edlhuber]

Hi

unzip and untar your backup. see in RELEASE file, there should be your version.

See Config.pm and search for your db password. This should match to your new restore database.

good luck :-)


Florian

16.07.2013 08:06 - Andrew S. Meyer schrieb:
s