Re: [otrs] Backup restore error ERROR 1045: Access denied for user:'otrs@localhost'

Thank you Robert for your answer OK you''re right. my former explantion was a bit shorten ... 1) I have an OTRS 1.1.2 working on a little RH8 bos since 2 month, with the pop fct to get the tickets 2) i upgraded this installation to otrs 1.1.3 , OK ( rpm -U otrs.1.1.3.rpm) 3) i want to migrate it to a better server , which is in RH9 4) on the little RH8 box ,i did a .scripts/backup.sh OK 5) tar the backuped data on the old RH8 box 6) copy the tarred data files to the new RH9 server 7) Install OTRS on the RH9 with your OTRS113 RPM for RH8 . - Smile: every perl and mysql package needed for OTRS is present in the RH9 distrib!. so the install process is straight forward, before the Web browser part. 8) httpd://myhost/otrs/installer.pl : Error 403 , do'not have permission ... -> ~otrs/ was forbidden for apache so chgrp -R apache ~otrs , and chmod 750 ~otrs/ 9) Web part install: i did not remember that if you try to change the root@localhost password you do nothing since : "Access denied for user:'root@localhost' ". So I left it empty for the moment. 10 ) the creation of the database occured . 11 ) otrs working on the new server. The step you asked me. Now restore the tarred files to the new OTRS server 11) detar 12) ./scripts/restores.sh ... -> the database OTRS already exists ! -> so i dropped it with a shell "mysql -u root -e 'drop ...' 13) again /scripts/restores.sh ... OK 14) I can log in with my username, I see the Queues and so on but the pop service doesnt work . I think I have to recutomize Config.pm and var/cron Do you confirm ? Thank a lot for this fine work . Jerome Robert Kehl wrote:

----- Original Message ----- From: Sent: Saturday, September 13, 2003 6:59 PM

...

1) OTRS 1.1.3 installed ok on the new server , but i stopped before otrs/install.pl the original otrs was 1.1.2 , and was upgraded ok

I don't fully understand this. You updgraded a (preinstalled) 1.1.2 by installing 1.1.3, but stopped before install.pl could run? And 1.1.3 did work?!?

Now you want to restore from a 1.1.3 backup? Try to complete the whole installation process including install.pl, and then perform the restore action. Let us know if you succeed.

hth,

Robert Kehl

_______________________________________________ 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