Re: [otrs] backup/restore
Hi Michiel I just test the restore ( erase all data in mysql ) with new script restore.pl, and work just fine. Now I will test the restore from scratch ( Repalce OS, apache perl mysql ) and then restore.pl Many thanks to you. Great Replay. Best Regards. On Mon, Oct 26, 2009 at 4:16 PM, Michiel Beijen m...@otrs.org wrote: Hi fenixport, You're right, this is an issue with the restore.pl script. If you'd use the latest version from CVS here: http://source.otrs.org/viewvc.cgi/otrs/scripts/restore.pl?revision=1.10.2.2view=markuppathrev=rel-2_4 you won't have this issue anymore. See also http://bugs.otrs.org/show_bug.cgi?id=4454 ((enjoy)) - Michiel Beijen RD OTRS AG Norsk-Data-Str 1. 61352 Bad Homburg Deutschland T: +31 (0) 6457 42418 F: +49 (0) 9421 56818-18 I: http://www.otrs.com/ Business Location: Bad Homburg, Country Court: Bad Homburg, Commercial register: 10751, Tax ID: 003 240 97505 Chairman of the Board: Burchard Steinbild, Managing Board: André Mindermann (CEO), Martin Edenhofer CU@ IIR Service Desk Forum in Mainz (Germany)http://www.otrs.com/en/news-and-press/news-details/article/translate-to-english-otrs-at-the-13th-iir-service-desk-forum-2009/?tx_ttnews%5BbackPid%5D=51cHash=ef91fa143eand get to know more about OTRS at booth no. 12 from Nov 24-25, 2009! On Mon, Oct 26, 2009 at 3:25 PM, as as fenixp...@gmail.com wrote: Hi All I want to backup my OTRS. And I want to use the scripts backup.pl and recover.pl. My OTRS system is in Ubuntu 2.6.28-11-server the version of OTRS is 2.4.5. When I do a backup all went fine: Backup /backupotrs/2009-10-26_14-23/Config.tar.gz ... done Backup /backupotrs/2009-10-26_14-23/Application.tar.gz ... done Dump MySQL rdbms ... done Compress SQL-file... done But, when I try the restore I get the following error: Restore /backupotrs/2009-10-26_12-39/Config.tar.gz ... Got no EncodeObject! at /opt/otrs/Kernel/System/DB.pm line 96. Any ideas ? .. Can anyone Help me on this one. Best Regards. - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
[otrs] backup/restore
Hi All I want to backup my OTRS. And I want to use the scripts backup.pl and recover.pl. My OTRS system is in Ubuntu 2.6.28-11-server the version of OTRS is 2.4.5. When I do a backup all went fine: Backup /backupotrs/2009-10-26_14-23/Config.tar.gz ... done Backup /backupotrs/2009-10-26_14-23/Application.tar.gz ... done Dump MySQL rdbms ... done Compress SQL-file... done But, when I try the restore I get the following error: Restore /backupotrs/2009-10-26_12-39/Config.tar.gz ... Got no EncodeObject! at /opt/otrs/Kernel/System/DB.pm line 96. Any ideas ? .. Can anyone Help me on this one. Best Regards. - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Re: [otrs] Backup/Restore
Hi Maurice, backup.pl (and restore.pl) should enable you to do a full rebuild. I have used it to setup a shadow/test system. However you have to make sure that: - The backup.pl script runs without ANY errors! - To use '-t fullbackup' when do a backup to get ALL data - The database is empty (dropped) when restoring I usually use: # ./backup.pl -d /opt/otrs/restore -r 20 -t fullbackup Check the files in the output directory (-d), what files do you have? Check the contents of the 'DatabaseBackupo.sql.gz' file, of the backup. Here is how to check what tables are in the sql data file (gzip -cd DatabaseBackup.sql.gz | more): # cd /opt/otrs/your restore dir/the backup data dir # gzip -cd DatabaseBackup.sql.gz | grep 'CREATE TABLE' gr, Frans From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Maurice James Sent: dinsdag 5 mei 2009 03:47 To: otrs@otrs.org Subject: [otrs] Backup/Restore Isnt the backup/restore script supposed to back the entire OTRS installation up? I recently had a server crash and had to rebuild my OTRS installation from scratch. When I restored the the OTRS installation using the resotre.pl script, the only tables that got restored was the article tables. All of the other data is gone i.e users, queues etc. Did I do something wrong or is backup.pl not meant to perform a complete OTRS system backup? Any help is appreciated - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Re: [otrs] Backup/Restore
Hi, we were able to perform a full restore executing these steps: 1. Perform a full new OTRS install including the step through the browser (i.e: http://newserver/otrs/installer.pl). In this step, it can be informed the correct root password that was in use in the production OTRS that crashed or let it for step 4 2. Set correct owner and group of directory /opt/otrs 3. Drop otrs database created on step 1. In our case, through mysql prompt linux mysql -u root -p mysql drop database otrs; 4. Reset otrs root password for the one used in production environment that crashed if not did in step 1 mysql SET PASSWORD FOR 'otrs'@'newserver' = PASSWORD('the production password'); 5. Recreate otrs database mysql create database otrs; 6. Perform restore linux /opt/otrs/scripts/restore.pl -b backup dir -d /opt/otrs Where backup dir is the path until the directory whose name is the timestamp of the backup generated, i.e, /tmp/2009-03-13_11-49 This was how we were able to do it without any errors in the restore , there may be others. Hope this helps. From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Maurice James Sent: segunda-feira, 4 de maio de 2009 22:47 To: otrs@otrs.org Subject: [otrs] Backup/Restore Isnt the backup/restore script supposed to back the entire OTRS installation up? I recently had a server crash and had to rebuild my OTRS installation from scratch. When I restored the the OTRS installation using the resotre.pl script, the only tables that got restored was the article tables. All of the other data is gone i.e users, queues etc. Did I do something wrong or is backup.pl not meant to perform a complete OTRS system backup? Any help is appreciated - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Re: [otrs] Backup/Restore
You should backup also the article dir in otrs/var directory if you separated the attachment storage from DB, otherwise all your messages will not have the attachments. Use something like: start_time=$(/bin/date +%F.%T | /usr/bin/tr -s : _) /bin/tar -cpjSf $start_time-otrsarticles.tar.bz2 /opt/otrs/var/article Make a cron job of this in conjuction to the backup.pl and you are done. Greetings, Stefano Coletta Unidata S.p.a. Via Portuense, 1555 - 00143 Roma Commercity - Modulo M25 Tel +39 06404041 Fax +39 0640404002 E-mail s.cole...@unidata.it Maurice James wrote: Isnt the backup/restore script supposed to back the entire OTRS installation up? I recently had a server crash and had to rebuild my OTRS installation from scratch. When I restored the the OTRS installation using the resotre.pl script, the only tables that got restored was the article tables. All of the other data is gone i.e users, queues etc. Did I do something wrong or is backup.pl not meant to perform a complete OTRS system backup? Any help is appreciated - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Re: [otrs] Backup/Restore
Yes, you are right. Sorry. Frans Stekelenburg wrote: Maybe a OTRS version thing, but our backup.pl (v2.3.3) _does_ include this var/article dir when '-t fullbackup' is specified; [r...@otrs restore]# ls -1 2009-05-05_08-42/ Application.tar.gz Config.tar.gz DatabaseBackup.sql.gz r...@otrs restore]# tar tvzf 2009-05-05_08-42/Application.tar.gz |more drwxr-xr-x otrs/apache 0 2009-05-05 00:56:44 ./ -rw-rw-r-- apache/apache 7395 2008-10-02 04:06:45 ./TODO drwxrwxr-x otrs/apache 0 2009-03-21 01:37:23 ./var/ drwxrwsr-x otrs/apache 0 2009-04-25 14:50:03 ./var/article/ drwxrwsr-x otrs/apache 0 2009-04-01 00:00:04 ./var/article/2009/ drwxrwsr-x otrs/apache 0 2009-01-31 00:00:01 ./var/article/2009/01/ drwxrwsr-x otrs/apache 0 2009-01-19 23:50:02 ./var/article/2009/01/19/ drwxrwsr-x otrs/apache 0 2009-01-19 12:21:39 ./var/article/2009/01/19/132/ -rwxrwsr-x otrs/apache 636 2009-01-19 12:21:39 ./var/article/2009/01/19/132/plain.txt ... gr, Frans -Original Message- From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Stefano Coletta Sent: dinsdag 5 mei 2009 15:24 To: User questions and discussions about OTRS. Subject: Re: [otrs] Backup/Restore You should backup also the article dir in otrs/var directory if you separated the attachment storage from DB, otherwise all your messages will not have the attachments. Use something like: start_time=$(/bin/date +%F.%T | /usr/bin/tr -s : _) /bin/tar -cpjSf $start_time-otrsarticles.tar.bz2 /opt/otrs/var/article Make a cron job of this in conjuction to the backup.pl and you are done. Greetings, Stefano Coletta Unidata S.p.a. Via Portuense, 1555 - 00143 Roma Commercity - Modulo M25 Tel +39 06404041 Fax +39 0640404002 E-mail s.cole...@unidata.it Maurice James wrote: Isnt the backup/restore script supposed to back the entire OTRS installation up? I recently had a server crash and had to rebuild my OTRS installation from scratch. When I restored the the OTRS installation using the resotre.pl script, the only tables that got restored was the article tables. All of the other data is gone i.e users, queues etc. Did I do something wrong or is backup.pl not meant to perform a complete OTRS system backup? Any help is appreciated - --- - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ -- Saluti, Stefano Coletta Unidata S.p.a. Via Portuense, 1555 - 00143 Roma Commercity - Modulo M25 Tel +39 06404041 Fax +39 0640404002 E-mail s.cole...@unidata.it - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Re: [otrs] Backup/Restore
All of my articles and attachments are stored in the database. Would I still have to perform this step? -Original Message- From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Stefano Coletta Sent: Tuesday, May 05, 2009 9:24 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Backup/Restore You should backup also the article dir in otrs/var directory if you separated the attachment storage from DB, otherwise all your messages will not have the attachments. Use something like: start_time=$(/bin/date +%F.%T | /usr/bin/tr -s : _) /bin/tar -cpjSf $start_time-otrsarticles.tar.bz2 /opt/otrs/var/article Make a cron job of this in conjuction to the backup.pl and you are done. Greetings, Stefano Coletta Unidata S.p.a. Via Portuense, 1555 - 00143 Roma Commercity - Modulo M25 Tel +39 06404041 Fax +39 0640404002 E-mail s.cole...@unidata.it Maurice James wrote: Isnt the backup/restore script supposed to back the entire OTRS installation up? I recently had a server crash and had to rebuild my OTRS installation from scratch. When I restored the the OTRS installation using the resotre.pl script, the only tables that got restored was the article tables. All of the other data is gone i.e users, queues etc. Did I do something wrong or is backup.pl not meant to perform a complete OTRS system backup? Any help is appreciated - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/ - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
Re: [otrs] Backup/Restore
Hi, Is this all of the out put that I should see from the gzip command? #gzip -cd DatabaseBackup.sql.gz | grep 'CREATE TABLE' CREATE TABLE `article` ( CREATE TABLE `article_attachment` ( CREATE TABLE `article_flag` ( CREATE TABLE `article_plain` ( CREATE TABLE `article_search` ( CREATE TABLE `article_sender_type` ( CREATE TABLE `article_type` ( CREATE TABLE `auto_response` ( CREATE TABLE `auto_response_type` ( CREATE TABLE `bench_test` ( CREATE TABLE `calendar_event` ( CREATE TABLE `calendar_event_involved` ( CREATE TABLE `customer_company` ( CREATE TABLE `customer_preferences` ( CREATE TABLE `customer_user` ( CREATE TABLE `faq_attachment` ( CREATE TABLE `faq_category` ( CREATE TABLE `faq_category_group` ( CREATE TABLE `faq_history` ( CREATE TABLE `faq_item` ( CREATE TABLE `faq_language` ( CREATE TABLE `faq_log` ( CREATE TABLE `faq_state` ( CREATE TABLE `faq_state_type` ( CREATE TABLE `faq_voting` ( CREATE TABLE `follow_up_possible` ( CREATE TABLE `generic_agent_jobs` ( CREATE TABLE `group_customer_user` ( CREATE TABLE `group_role` ( CREATE TABLE `group_user` ( CREATE TABLE `groups` ( CREATE TABLE `link_object` ( CREATE TABLE `link_relation` ( CREATE TABLE `link_state` ( CREATE TABLE `link_type` ( CREATE TABLE `mail_account` ( CREATE TABLE `notifications` ( CREATE TABLE `object_link` ( CREATE TABLE `package_repository` ( CREATE TABLE `personal_queues` ( CREATE TABLE `postmaster_filter` ( CREATE TABLE `process_id` ( CREATE TABLE `queue` ( CREATE TABLE `queue_auto_response` ( CREATE TABLE `queue_preferences` ( CREATE TABLE `queue_standard_response` ( CREATE TABLE `role_user` ( CREATE TABLE `roles` ( CREATE TABLE `salutation` ( CREATE TABLE `search_profile` ( CREATE TABLE `service` ( CREATE TABLE `service_customer_user` ( CREATE TABLE `service_sla` ( CREATE TABLE `sessions` ( CREATE TABLE `signature` ( CREATE TABLE `sla` ( CREATE TABLE `standard_attachment` ( CREATE TABLE `standard_response` ( CREATE TABLE `standard_response_attachment` ( CREATE TABLE `support_bench_test` ( CREATE TABLE `system_address` ( CREATE TABLE `theme` ( CREATE TABLE `ticket` ( CREATE TABLE `ticket_history` ( CREATE TABLE `ticket_history_type` ( CREATE TABLE `ticket_index` ( CREATE TABLE `ticket_lock_index` ( CREATE TABLE `ticket_lock_type` ( CREATE TABLE `ticket_loop_protection` ( CREATE TABLE `ticket_priority` ( CREATE TABLE `ticket_state` ( CREATE TABLE `ticket_state_type` ( CREATE TABLE `ticket_type` ( CREATE TABLE `ticket_watcher` ( CREATE TABLE `time_accounting` ( CREATE TABLE `user_preferences` ( CREATE TABLE `users` ( CREATE TABLE `valid` ( CREATE TABLE `web_upload_cache` ( CREATE TABLE `xml_storage` ( From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Frans Stekelenburg Sent: Tuesday, May 05, 2009 5:42 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Backup/Restore Hi Maurice, backup.pl (and restore.pl) should enable you to do a full rebuild. I have used it to setup a shadow/test system. However you have to make sure that: - The backup.pl script runs without ANY errors! - To use '-t fullbackup' when do a backup to get ALL data - The database is empty (dropped) when restoring I usually use: # ./backup.pl -d /opt/otrs/restore -r 20 -t fullbackup Check the files in the output directory (-d), what files do you have? Check the contents of the 'DatabaseBackupo.sql.gz' file, of the backup. Here is how to check what tables are in the sql data file (gzip -cd DatabaseBackup.sql.gz | more): # cd /opt/otrs/your restore dir/the backup data dir # gzip -cd DatabaseBackup.sql.gz | grep 'CREATE TABLE' gr, Frans From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Maurice James Sent: dinsdag 5 mei 2009 03:47 To: otrs@otrs.org Subject: [otrs] Backup/Restore Isnt the backup/restore script supposed to back the entire OTRS installation up? I recently had a server crash and had to rebuild my OTRS installation from scratch. When I restored the the OTRS installation using the resotre.pl script, the only tables that got restored was the article tables. All of the other data is gone i.e users, queues etc. Did I do something wrong or is backup.pl not meant to perform a complete OTRS system backup? Any help is appreciated - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
[otrs] Backup/Restore
Isnt the backup/restore script supposed to back the entire OTRS installation up? I recently had a server crash and had to rebuild my OTRS installation from scratch. When I restored the the OTRS installation using the resotre.pl script, the only tables that got restored was the article tables. All of the other data is gone i.e users, queues etc. Did I do something wrong or is backup.pl not meant to perform a complete OTRS system backup? Any help is appreciated - 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
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 [EMAIL PROTECTED] password you do nothing since : "Access denied for user:'[EMAIL PROTECTED]' ". 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: [EMAIL PROTECTED] 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 ___ 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
Re: [otrs] Backup restore error ERROR 1045: Access denied for user:'otrs@localhost'
Am Mon, 2003-09-15 um 13.17 schrieb [EMAIL PROTECTED]: 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 ? No, Config.pm should be the same as you had on the former box, but you probably have to install cron jobs again. Do a crontab -u otrs -l to see what's there. Do this as Root. If the CRON jobs are pretending to be running, have a look at syslog, which probably is your logging mechanism. Watch for output from OTRS itself as well as from your MTA (sendmail,postfix,exim and the like). The last thing: POP3PostMaster.pl is an outgoing process - could be the firewall mechanism on the new box doesn't allow this? You should see this in the firewall's logs, usually located in syslog, too. At last, is the new box capable of actually resolving the POP server's name? Some new system are correctly set up to see everything in the internal network, but have no clue of what outside servers are named. Look in your system configuration and issue a host my.popserver.example to see if the box can resolve it. If not, play with /etc/resolv.conf anbd your network setup. No, you need not have a DNS server running on the otrs box, although you may do so. htht, 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
Re: [otrs] Backup restore error ERROR 1045: Access denied for user:'otrs@localhost'
- Original Message - From: [EMAIL PROTECTED] 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
[otrs] Backup restore error ERROR 1045: Access denied for user: 'otrs@localhost'
Hello everybody I am trying to move otrs to a new server (new apache,otrs,mysql...) the old one is a RedHat8 rhe new one is a RedHat9 OTRS is 1.1.3 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 2) backup Otrs on the old server , and tar the data : ok 3) untar the data ok on the new server 4) i tried to restore the data into the new otrs server httpd-2.0.40-21 perl-DBD-MySQL-2.1021-3 mysql-3.23.54a-11 mysql-server-3.23.54a-11 ./scripts/restore.sh /opt/otrs/bin /opt/otrs/Kernel/ /opt/otrs-backup/2003-. restore.sh - a restore script for OTRS $Revision: 1.5 $ Copyright (c) 2002 Martin Edenhofer [EMAIL PROTECTED] create database otrs ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) what to do ? of course i am a mysql newbie! thank for your help ... Jerome ___ 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