[otrs] Backup and Restore pearl script - success? failure?
Has anybody successfully used the 'backup.pl' and 'restore.pl'? If so what preparation did you do before running the scripts? - new PostgreSQL database? - from template 0? - load schema before - create user, role? - etc The documentation is a little light on the preceding steps Regard ___ Paul Simons Disclaimer: This e-mail (and any attachments to it) is confidential and intended solely for the named person/s to whom it is addressed. If you are not an intended recipient, please notify us immediately and delete the email from your system. Any review, dissemination or other use of it in these circumstances is prohibited. - 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 and Restore pearl script - success? failure?
Not used Postgres but with MySQL you need to prep the environment for the database i.e. create the user and database and assign permissions. Then the restore will create all the tables and restore the data. Can't say I've ever liked the idea of an all in one backup/restore script. I have MySQL backups nightly with transaction logs every 6 hours so can roll the database back/forward to when needed and I take snapshot backups of the /opt/otrs filesystem to be able to restore. For ease of management we store the attachments in the database. Steve On 10 June 2013 16:10, Paul Simons paul.sim...@onair.aero wrote: Has anybody successfully used the 'backup.pl' and 'restore.pl'? If so what preparation did you do before running the scripts? - new PostgreSQL database? - from template 0? - load schema before - create user, role? - etc The documentation is a little light on the preceding steps Regard ___ Paul Simons Disclaimer: This e-mail (and any attachments to it) is confidential and intended solely for the named person/s to whom it is addressed. If you are not an intended recipient, please notify us immediately and delete the email from your system. Any review, dissemination or other use of it in these circumstances is prohibited. - 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 and Restore pearl script - success? failure?
Hum nice idea for the attachments - I'll look closely at that. Could you expand on your 'permissions' - which permissions - I thought they were restored from the SQL file. Regards ___ Paul Simons -Original Message- From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Steven Carr Sent: Monday, June 10, 2013 5:25 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] Backup and Restore pearl script - success? failure? Not used Postgres but with MySQL you need to prep the environment for the database i.e. create the user and database and assign permissions. Then the restore will create all the tables and restore the data. Can't say I've ever liked the idea of an all in one backup/restore script. I have MySQL backups nightly with transaction logs every 6 hours so can roll the database back/forward to when needed and I take snapshot backups of the /opt/otrs filesystem to be able to restore. For ease of management we store the attachments in the database. Steve On 10 June 2013 16:10, Paul Simons paul.sim...@onair.aero wrote: Has anybody successfully used the 'backup.pl' and 'restore.pl'? If so what preparation did you do before running the scripts? - new PostgreSQL database? - from template 0? - load schema before - create user, role? - etc The documentation is a little light on the preceding steps Regard ___ Paul Simons Disclaimer: This e-mail (and any attachments to it) is confidential and intended solely for the named person/s to whom it is addressed. If you are not an intended recipient, please notify us immediately and delete the email from your system. Any review, dissemination or other use of it in these circumstances is prohibited. - 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 Disclaimer: This e-mail (and any attachments to it) is confidential and intended solely for the named person/s to whom it is addressed. If you are not an intended recipient, please notify us immediately and delete the email from your system. Any review, dissemination or other use of it in these circumstances is prohibited. - 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 and Restore pearl script - success? failure?
Permissions as in the permissions on the user account to access the actual database, in MySQL these are stored in separate system tables, don't know where or how PG stores that information. OTRS permissions are stored in the OTRS tables, so they will be backed up/restored. On 10 June 2013 16:41, Paul Simons paul.sim...@onair.aero wrote: Hum nice idea for the attachments - I'll look closely at that. Could you expand on your 'permissions' - which permissions - I thought they were restored from the SQL file. Regards ___ Paul Simons -Original Message- From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Steven Carr Sent: Monday, June 10, 2013 5:25 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] Backup and Restore pearl script - success? failure? Not used Postgres but with MySQL you need to prep the environment for the database i.e. create the user and database and assign permissions. Then the restore will create all the tables and restore the data. Can't say I've ever liked the idea of an all in one backup/restore script. I have MySQL backups nightly with transaction logs every 6 hours so can roll the database back/forward to when needed and I take snapshot backups of the /opt/otrs filesystem to be able to restore. For ease of management we store the attachments in the database. Steve On 10 June 2013 16:10, Paul Simons paul.sim...@onair.aero wrote: Has anybody successfully used the 'backup.pl' and 'restore.pl'? If so what preparation did you do before running the scripts? - new PostgreSQL database? - from template 0? - load schema before - create user, role? - etc The documentation is a little light on the preceding steps Regard ___ Paul Simons Disclaimer: This e-mail (and any attachments to it) is confidential and intended solely for the named person/s to whom it is addressed. If you are not an intended recipient, please notify us immediately and delete the email from your system. Any review, dissemination or other use of it in these circumstances is prohibited. - 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 Disclaimer: This e-mail (and any attachments to it) is confidential and intended solely for the named person/s to whom it is addressed. If you are not an intended recipient, please notify us immediately and delete the email from your system. Any review, dissemination or other use of it in these circumstances is prohibited. - 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 on OTRS
Quoting Adi Ariyanto (aariya...@binus.edu): I decide to change backup path and it works hahahaha.. Why I am so stupid ?? push backup path must on /otrs/scripts ?? I doubt it needs to be within /otrs/scripts. But perhaps you need to give the *absolute* path to the script, not a relative one. HTH, Susan - 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 on OTRS
Hi, did someone ever meet this case ? I try to backup my otrs with this command ./backup.pl -d /backup/ But I got ERROR: No Such directory: /backup/ I google and found an post that said backup.pl not work on debian, my OTRS run on Debian, then I try install OTRS on CentOS then I try run backup.pl but found the same error. What I have try 1. Try to change group permission (chown) a. On Debian : chown otrs www-data /backup/ b.On CentOS : chown otrs apache /backup/ Any idea ? This email and its attachments may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Bina Nusantara. If you are not the intended recipient of this email and its attachments, you must take no action based upon them, nor must you copy or show them to anyone. Please contact the sender if you believe you have received this email in error. - 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 on OTRS
On 07/24/2012 05:16 AM, Adi Ariyanto wrote: Hi, did someone ever meet this case ? I try to backup my otrs with this command ./backup.pl -d /backup/ But I got ERROR: No Such directory: /backup/ I google and found an post that said backup.pl not work on debian, my OTRS run on Debian, then I try install OTRS on CentOS then I try run backup.pl but found the same error. What I have try 1.Try to change group permission (chown) a.On Debian : chown otrs www-data /backup/ b.On CentOS : chown otrs apache /backup/ Any idea ? Hmm... On CentOS 5.x I use a shell script from a root cron job that has #!/bin/sh /opt/otrs/scripts/backup.pl -d /opt/backups/ and it work just fine. -- Stephen Clark *NetWolves* Director of Technology Phone: 813-579-3200 Fax: 813-882-0209 Email: steve.cl...@netwolves.com http://www.netwolves.com - 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 on OTRS
If you received such an error, it is likely not lying to you that there is no writable directory named backup in the root / of your filesystem. Either create it or specify an alternate path to dump the backup. On Tue, Jul 24, 2012 at 7:18 AM, Steve Clark scl...@netwolves.com wrote: On 07/24/2012 05:16 AM, Adi Ariyanto wrote: Hi, did someone ever meet this case ? ** ** I try to backup my otrs with this command ./backup.pl -d /backup/ ** ** But I got “ERROR: No Such directory: /backup/ ** ** I google and found an post that said backup.pl not work on debian, my OTRS run on Debian, then I try install OTRS on CentOS then I try run backup.pl but found the same error. ** ** What I have try 1. Try to change group permission (chown) a. On Debian : chown otrs www-data /backup/ b.On CentOS : chown otrs apache /backup/ ** ** Any idea ? Hmm... On CentOS 5.x I use a shell script from a root cron job that has #!/bin/sh /opt/otrs/scripts/backup.pl -d /opt/backups/ and it work just fine. -- Stephen Clark *NetWolves* Director of Technology Phone: 813-579-3200 Fax: 813-882-0209 Email: steve.cl...@netwolves.com http://www.netwolves.com - 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 on OTRS
Dear Gerald This is screen capture on Debian, Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent permitted by applicable law. Last login: Tue Jul 24 16:45:54 2012 root@ticketing:~# cd /opt/otrs/scripts/ root@ticketing:/opt/otrs/scripts# ls | more apache2-httpd.include.conf apache2-perl-startup.pl auto_build auto_build.sh auto_docbuild.sh backup -- see I already make a folder name backup backup.pl for folder permission root@ticketing:/opt/otrs/scripts# ls -a -l | more total 572 drwxrwxr-x 7 otrs www-data 4096 Jul 25 09:08 . drwxrwxrwx 8 root root 4096 Jul 20 16:46 .. -rw-rw-r-- 1 otrs www-data 2099 Nov 6 2011 apache2-httpd.include.conf -rwxrwxr-x 1 otrs www-data 7360 Dec 13 2011 apache2-perl-startup.pl drwxrwxr-x 2 otrs www-data 4096 Jun 4 14:31 auto_build -rw-rw-r-- 1 otrs www-data 10568 Feb 9 19:33 auto_build.sh -rw-rw-r-- 1 otrs www-data 4047 Feb 26 2009 auto_docbuild.sh drwxr-xr-x 2 otrs www-data 4096 Jul 25 09:08 backup -rwxrwxr-x 1 otrs www-data 7721 Jan 10 2011 backup.pl drwxrwxr-x 3 otrs www-data 4096 Jun 4 14:31 database when I execute backup.pl root@ticketing:/opt/otrs/scripts# bash root@ticketing:/opt/otrs/scripts# ./backup.pl -d backup/ ERROR: Can't create directory: backup//2012-07-25_09-36: No such file or directory root@ticketing:/opt/otrs/scripts# This is from my Centos 6 Machine (correction I used CentOS 6 Minimal) :) [root@localhost scripts]# ls -a -l | more total 572 drwxrwxr-x 7 otrs apache 4096 Jul 24 23:02 . drwxr-xr-x 8 root root 4096 Jul 24 05:30 .. -rw-rw-r-- 1 otrs apache 2099 Jun 4 14:36 apache2-httpd.include.conf -rwxrwxr-x 1 otrs apache 7360 Jun 4 14:36 apache2-perl-startup.pl drwxrwxr-x 2 otrs apache 4096 Jul 24 05:30 auto_build -rw-rw-r-- 1 otrs apache 10568 Jun 4 14:36 auto_build.sh -rw-rw-r-- 1 otrs apache 4047 Jun 4 14:36 auto_docbuild.sh drwxr-xr-x 2 otrs apache 4096 Jul 24 23:02 backup -rwxrwxr-x 1 otrs apache 7721 Jun 4 14:36 backup.pl drwxrwxr-x 3 otrs apache 4096 Jul 24 05:30 database This I when I try run backup.pl [root@localhost scripts]# bash [root@localhost scripts]# ./backup.pl -d backup/ ERROR: Can't create directory: backup//2012-07-25_16-47: No such file or directory [root@localhost scripts]# Any idea :( hiks hiks.. From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Gerald Young Sent: Tuesday, July 24, 2012 6:57 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] Backup on OTRS If you received such an error, it is likely not lying to you that there is no writable directory named backup in the root / of your filesystem. Either create it or specify an alternate path to dump the backup. On Tue, Jul 24, 2012 at 7:18 AM, Steve Clark scl...@netwolves.commailto:scl...@netwolves.com wrote: On 07/24/2012 05:16 AM, Adi Ariyanto wrote: Hi, did someone ever meet this case ? I try to backup my otrs with this command ./backup.plhttp://backup.pl -d /backup/ But I got ERROR: No Such directory: /backup/ I google and found an post that said backup.plhttp://backup.pl not work on debian, my OTRS run on Debian, then I try install OTRS on CentOS then I try run backup.plhttp://backup.pl but found the same error. What I have try 1. Try to change group permission (chown) a. On Debian : chown otrs www-data /backup/ b.On CentOS : chown otrs apache /backup/ Any idea ? Hmm... On CentOS 5.x I use a shell script from a root cron job that has #!/bin/sh /opt/otrs/scripts/backup.plhttp://backup.pl -d /opt/backups/ and it work just fine. -- Stephen Clark NetWolves Director of Technology Phone: 813-579-3200tel:813-579-3200 Fax: 813-882-0209tel:813-882-0209 Email: steve.cl...@netwolves.commailto:steve.cl...@netwolves.com http://www.netwolves.com - 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 This email and its attachments may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Bina Nusantara. If you are not the intended recipient of this email and its attachments, you must take no action based upon them, nor must you copy or show them to anyone. Please contact the sender if you believe you have received this email in error. This email and its attachments may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Bina Nusantara. If you are not the intended recipient of this email and its attachments, you must take no action based upon them, nor must you copy or show them to anyone
Re: [otrs] Backup on OTRS
Did you try it without the trailing slash? On Tue, Jul 24, 2012 at 10:48 PM, Adi Ariyanto aariya...@binus.edu wrote: Dear Gerald ** ** *This is screen capture on Debian,* ** ** *Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent* *permitted by applicable law.* *Last login: Tue Jul 24 16:45:54 2012* *root@ticketing:~# cd /opt/otrs/scripts/* *root@ticketing:/opt/otrs/scripts# ls | more* *apache2-httpd.include.conf* *apache2-perl-startup.pl* *auto_build* *auto_build.sh* *auto_docbuild.sh* *backup **à** see I already make a folder name backup* *backup.pl* ** ** *for folder permission* *root@ticketing:/opt/otrs/scripts# ls -a -l | more* *total 572* *drwxrwxr-x 7 otrs www-data 4096 Jul 25 09:08 .* *drwxrwxrwx 8 root root 4096 Jul 20 16:46 ..* *-rw-rw-r-- 1 otrs www-data 2099 Nov 6 2011 apache2-httpd.include.conf* *-rwxrwxr-x 1 otrs www-data 7360 Dec 13 2011 apache2-perl-startup.pl* *drwxrwxr-x 2 otrs www-data 4096 Jun 4 14:31 auto_build* *-rw-rw-r-- 1 otrs www-data 10568 Feb 9 19:33 auto_build.sh* *-rw-rw-r-- 1 otrs www-data 4047 Feb 26 2009 auto_docbuild.sh* *drwxr-xr-x 2 otrs www-data 4096 Jul 25 09:08 backup* *-rwxrwxr-x 1 otrs www-data 7721 Jan 10 2011 backup.pl* *drwxrwxr-x 3 otrs www-data 4096 Jun 4 14:31 database* * * *when I execute backup.pl* *root@ticketing:/opt/otrs/scripts# bash* *root@ticketing:/opt/otrs/scripts# ./backup.pl -d backup/* *ERROR: Can't create directory: backup//2012-07-25_09-36: No such file or directory* *root@ticketing:/opt/otrs/scripts#* * * ** ** *This is from my Centos 6 Machine (correction I used CentOS 6 Minimal) **J *** *[root@localhost scripts]# ls -a -l | more* *total 572* *drwxrwxr-x 7 otrs apache 4096 Jul 24 23:02 .* *drwxr-xr-x 8 root root 4096 Jul 24 05:30 ..* *-rw-rw-r-- 1 otrs apache 2099 Jun 4 14:36 apache2-httpd.include.conf* *-rwxrwxr-x 1 otrs apache 7360 Jun 4 14:36 apache2-perl-startup.pl* *drwxrwxr-x 2 otrs apache 4096 Jul 24 05:30 auto_build* *-rw-rw-r-- 1 otrs apache 10568 Jun 4 14:36 auto_build.sh* *-rw-rw-r-- 1 otrs apache 4047 Jun 4 14:36 auto_docbuild.sh* *drwxr-xr-x 2 otrs apache 4096 Jul 24 23:02 backup* *-rwxrwxr-x 1 otrs apache 7721 Jun 4 14:36 backup.pl* *drwxrwxr-x 3 otrs apache 4096 Jul 24 05:30 database* * * * * *This I when I try run backup.pl * *[root@localhost scripts]# bash* *[root@localhost scripts]# ./backup.pl -d backup/* *ERROR: Can't create directory: backup//2012-07-25_16-47: No such file or directory* *[root@localhost scripts]#* * * Any idea L hiks hiks.. *From:* otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] *On Behalf Of *Gerald Young *Sent:* Tuesday, July 24, 2012 6:57 PM *To:* User questions and discussions about OTRS. *Subject:* Re: [otrs] Backup on OTRS ** ** If you received such an error, it is likely not lying to you that there is no writable directory named backup in the root / of your filesystem. Either create it or specify an alternate path to dump the backup. On Tue, Jul 24, 2012 at 7:18 AM, Steve Clark scl...@netwolves.com wrote: On 07/24/2012 05:16 AM, Adi Ariyanto wrote: Hi, did someone ever meet this case ? I try to backup my otrs with this command ./backup.pl -d /backup/ But I got “ERROR: No Such directory: /backup/ I google and found an post that said backup.pl not work on debian, my OTRS run on Debian, then I try install OTRS on CentOS then I try run backup.pl but found the same error. What I have try 1. Try to change group permission (chown) a. On Debian : chown otrs www-data /backup/ b.On CentOS : chown otrs apache /backup/ Any idea ? ** ** Hmm... On CentOS 5.x I use a shell script from a root cron job that has #!/bin/sh /opt/otrs/scripts/backup.pl -d /opt/backups/ and it work just fine. -- Stephen Clark *NetWolves* Director of Technology Phone: 813-579-3200 Fax: 813-882-0209 Email: steve.cl...@netwolves.com http://www.netwolves.com - 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 ** ** -- This email and its attachments may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Bina Nusantara. If you are not the intended recipient of this email and its attachments, you must take no action based upon them, nor must you copy or show them to anyone. Please contact the sender if you believe you have received this email in error
Re: [otrs] Backup on OTRS
Just try :(, fyi I am use OTRS 3.1.6 [root@localhost scripts]# ./backup.pl -d backup ERROR: Can't create directory: backup/2012-07-25_17-05: No such file or directory [root@localhost scripts]# Fyi the located of perl is correct also in backup.pl file #!/usr/bin/perl -w From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Gerald Young Sent: Wednesday, July 25, 2012 10:05 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Backup on OTRS Did you try it without the trailing slash? On Tue, Jul 24, 2012 at 10:48 PM, Adi Ariyanto aariya...@binus.edumailto:aariya...@binus.edu wrote: Dear Gerald This is screen capture on Debian, Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent permitted by applicable law. Last login: Tue Jul 24 16:45:54 2012 root@ticketing:~# cd /opt/otrs/scripts/ root@ticketing:/opt/otrs/scripts# ls | more apache2-httpd.include.conf apache2-perl-startup.plhttp://apache2-perl-startup.pl auto_build auto_build.sh auto_docbuild.sh backup -- see I already make a folder name backup backup.plhttp://backup.pl for folder permission root@ticketing:/opt/otrs/scripts# ls -a -l | more total 572 drwxrwxr-x 7 otrs www-data 4096 Jul 25 09:08 . drwxrwxrwx 8 root root 4096 Jul 20 16:46 .. -rw-rw-r-- 1 otrs www-data 2099 Nov 6 2011 apache2-httpd.include.conf -rwxrwxr-x 1 otrs www-data 7360 Dec 13 2011 apache2-perl-startup.plhttp://apache2-perl-startup.pl drwxrwxr-x 2 otrs www-data 4096 Jun 4 14:31 auto_build -rw-rw-r-- 1 otrs www-data 10568 Feb 9 19:33 auto_build.sh -rw-rw-r-- 1 otrs www-data 4047 Feb 26 2009 auto_docbuild.sh drwxr-xr-x 2 otrs www-data 4096 Jul 25 09:08 backup -rwxrwxr-x 1 otrs www-data 7721 Jan 10 2011 backup.plhttp://backup.pl drwxrwxr-x 3 otrs www-data 4096 Jun 4 14:31 database when I execute backup.plhttp://backup.pl root@ticketing:/opt/otrs/scripts# bash root@ticketing:/opt/otrs/scripts# ./backup.plhttp://backup.pl -d backup/ ERROR: Can't create directory: backup//2012-07-25_09-36: No such file or directory root@ticketing:/opt/otrs/scripts# This is from my Centos 6 Machine (correction I used CentOS 6 Minimal) :) [root@localhost scripts]# ls -a -l | more total 572 drwxrwxr-x 7 otrs apache 4096 Jul 24 23:02 . drwxr-xr-x 8 root root 4096 Jul 24 05:30 .. -rw-rw-r-- 1 otrs apache 2099 Jun 4 14:36 apache2-httpd.include.conf -rwxrwxr-x 1 otrs apache 7360 Jun 4 14:36 apache2-perl-startup.plhttp://apache2-perl-startup.pl drwxrwxr-x 2 otrs apache 4096 Jul 24 05:30 auto_build -rw-rw-r-- 1 otrs apache 10568 Jun 4 14:36 auto_build.sh -rw-rw-r-- 1 otrs apache 4047 Jun 4 14:36 auto_docbuild.sh drwxr-xr-x 2 otrs apache 4096 Jul 24 23:02 backup -rwxrwxr-x 1 otrs apache 7721 Jun 4 14:36 backup.plhttp://backup.pl drwxrwxr-x 3 otrs apache 4096 Jul 24 05:30 database This I when I try run backup.plhttp://backup.pl [root@localhost scripts]# bash [root@localhost scripts]# ./backup.plhttp://backup.pl -d backup/ ERROR: Can't create directory: backup//2012-07-25_16-47: No such file or directory [root@localhost scripts]# Any idea :( hiks hiks.. From: otrs-boun...@otrs.orgmailto:otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.orgmailto:otrs-boun...@otrs.org] On Behalf Of Gerald Young Sent: Tuesday, July 24, 2012 6:57 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] Backup on OTRS If you received such an error, it is likely not lying to you that there is no writable directory named backup in the root / of your filesystem. Either create it or specify an alternate path to dump the backup. On Tue, Jul 24, 2012 at 7:18 AM, Steve Clark scl...@netwolves.commailto:scl...@netwolves.com wrote: On 07/24/2012 05:16 AM, Adi Ariyanto wrote: Hi, did someone ever meet this case ? I try to backup my otrs with this command ./backup.plhttp://backup.pl -d /backup/ But I got ERROR: No Such directory: /backup/ I google and found an post that said backup.plhttp://backup.pl not work on debian, my OTRS run on Debian, then I try install OTRS on CentOS then I try run backup.plhttp://backup.pl but found the same error. What I have try 1. Try to change group permission (chown) a. On Debian : chown otrs www-data /backup/ b.On CentOS : chown otrs apache /backup/ Any idea ? Hmm... On CentOS 5.x I use a shell script from a root cron job that has #!/bin/sh /opt/otrs/scripts/backup.plhttp://backup.pl -d /opt/backups/ and it work just fine. -- Stephen Clark NetWolves Director of Technology Phone: 813-579-3200tel:813-579-3200 Fax: 813-882-0209tel:813-882-0209 Email: steve.cl...@netwolves.commailto:steve.cl...@netwolves.com http://www.netwolves.com - 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 This email and its attachments may be confidential
Re: [otrs] Backup on OTRS
The error message isn't related to the version of OTRS. It's a permission
error.
The code that makes the error is this:
193my $Directory = $Opts{d}/$Y-$M-$D . _ . $h-$m; 194if (
!mkdir($Directory) ) { 195 print STDERR ERROR: Can't create directory:
$Directory: $!\n; 196 exit 1; 197} So, if *you* can't mkdir
backup/2012-07-25_17-05, then neither can OTRS.
On Tue, Jul 24, 2012 at 11:11 PM, Adi Ariyanto aariya...@binus.edu wrote:
Just try L, fyi I am use OTRS 3.1.6
** **
[root@localhost scripts]# ./backup.pl -d backup
ERROR: Can't create directory: backup/2012-07-25_17-05: No such file or
directory
[root@localhost scripts]#
** **
Fyi the located of perl is correct also in backup.pl file
#!/usr/bin/perl -w
** **
*From:* otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] *On Behalf
Of *Gerald Young
*Sent:* Wednesday, July 25, 2012 10:05 AM
*To:* User questions and discussions about OTRS.
*Subject:* Re: [otrs] Backup on OTRS
** **
Did you try it without the trailing slash?
On Tue, Jul 24, 2012 at 10:48 PM, Adi Ariyanto aariya...@binus.edu
wrote:
Dear Gerald
*This is screen capture on Debian,*
*Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent*
*permitted by applicable law.*
*Last login: Tue Jul 24 16:45:54 2012*
*root@ticketing:~# cd /opt/otrs/scripts/*
*root@ticketing:/opt/otrs/scripts# ls | more*
*apache2-httpd.include.conf*
*apache2-perl-startup.pl*
*auto_build*
*auto_build.sh*
*auto_docbuild.sh*
*backup **à** see I already make a folder name backup*
*backup.pl*
*for folder permission*
*root@ticketing:/opt/otrs/scripts# ls -a -l | more*
*total 572*
*drwxrwxr-x 7 otrs www-data 4096 Jul 25 09:08 .*
*drwxrwxrwx 8 root root 4096 Jul 20 16:46 ..*
*-rw-rw-r-- 1 otrs www-data 2099 Nov 6 2011
apache2-httpd.include.conf*
*-rwxrwxr-x 1 otrs www-data 7360 Dec 13 2011 apache2-perl-startup.pl**
***
*drwxrwxr-x 2 otrs www-data 4096 Jun 4 14:31 auto_build*
*-rw-rw-r-- 1 otrs www-data 10568 Feb 9 19:33 auto_build.sh*
*-rw-rw-r-- 1 otrs www-data 4047 Feb 26 2009 auto_docbuild.sh*
*drwxr-xr-x 2 otrs www-data 4096 Jul 25 09:08 backup*
*-rwxrwxr-x 1 otrs www-data 7721 Jan 10 2011 backup.pl*
*drwxrwxr-x 3 otrs www-data 4096 Jun 4 14:31 database*
* *
*when I execute backup.pl*
*root@ticketing:/opt/otrs/scripts# bash*
*root@ticketing:/opt/otrs/scripts# ./backup.pl -d backup/*
*ERROR: Can't create directory: backup//2012-07-25_09-36: No such file or
directory*
*root@ticketing:/opt/otrs/scripts#*
* *
*This is from my Centos 6 Machine (correction I used CentOS 6 Minimal) **J
*
*[root@localhost scripts]# ls -a -l | more*
*total 572*
*drwxrwxr-x 7 otrs apache 4096 Jul 24 23:02 .*
*drwxr-xr-x 8 root root 4096 Jul 24 05:30 ..*
*-rw-rw-r-- 1 otrs apache 2099 Jun 4 14:36 apache2-httpd.include.conf*
*-rwxrwxr-x 1 otrs apache 7360 Jun 4 14:36 apache2-perl-startup.pl
*
*drwxrwxr-x 2 otrs apache 4096 Jul 24 05:30 auto_build*
*-rw-rw-r-- 1 otrs apache 10568 Jun 4 14:36 auto_build.sh*
*-rw-rw-r-- 1 otrs apache 4047 Jun 4 14:36 auto_docbuild.sh*
*drwxr-xr-x 2 otrs apache 4096 Jul 24 23:02 backup*
*-rwxrwxr-x 1 otrs apache 7721 Jun 4 14:36 backup.pl*
*drwxrwxr-x 3 otrs apache 4096 Jul 24 05:30 database*
* *
* *
*This I when I try run backup.pl *
*[root@localhost scripts]# bash*
*[root@localhost scripts]# ./backup.pl -d backup/*
*ERROR: Can't create directory: backup//2012-07-25_16-47: No such file or
directory*
*[root@localhost scripts]#*
* *
Any idea L hiks hiks..
*From:* otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] *On Behalf
Of *Gerald Young
*Sent:* Tuesday, July 24, 2012 6:57 PM
*To:* User questions and discussions about OTRS.
*Subject:* Re: [otrs] Backup on OTRS
If you received such an error, it is likely not lying to you that there is
no writable directory named backup in the root / of your filesystem.
Either create it or specify an alternate path to dump the backup.
On Tue, Jul 24, 2012 at 7:18 AM, Steve Clark scl...@netwolves.com wrote:
On 07/24/2012 05:16 AM, Adi Ariyanto wrote:
Hi, did someone ever meet this case ?
I try to backup my otrs with this command
./backup.pl -d /backup/
But I got “ERROR: No Such directory: /backup/
I google and found an post that said backup.pl not work on debian, my
OTRS run on Debian, then I try install OTRS on CentOS then I try run
backup.pl but found the same error.
What I have try
1. Try to change group permission (chown)
a. On Debian : chown
Re: [otrs] Backup on OTRS
Hi Gerald
I decide to change backup path and it works hahahaha..
Why I am so stupid ?? push backup path must on /otrs/scripts ??
Thanks a lot man..
From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Gerald
Young
Sent: Wednesday, July 25, 2012 11:09 AM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] Backup on OTRS
The error message isn't related to the version of OTRS. It's a permission error.
The code that makes the error is this:
193
my $Directory = $Opts{d}/$Y-$M-$D . _ . $h-$m;
194
if ( !mkdir($Directory) ) {
195
print STDERR ERROR: Can't create directory: $Directory: $!\n;
196
exit 1;
197
}
So, if *you* can't mkdir backup/2012-07-25_17-05, then neither can OTRS.
On Tue, Jul 24, 2012 at 11:11 PM, Adi Ariyanto
aariya...@binus.edumailto:aariya...@binus.edu wrote:
Just try :(, fyi I am use OTRS 3.1.6
[root@localhost scripts]# ./backup.plhttp://backup.pl -d backup
ERROR: Can't create directory: backup/2012-07-25_17-05: No such file or
directory
[root@localhost scripts]#
Fyi the located of perl is correct also in backup.plhttp://backup.pl file
#!/usr/bin/perl -w
From: otrs-boun...@otrs.orgmailto:otrs-boun...@otrs.org
[mailto:otrs-boun...@otrs.orgmailto:otrs-boun...@otrs.org] On Behalf Of
Gerald Young
Sent: Wednesday, July 25, 2012 10:05 AM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] Backup on OTRS
Did you try it without the trailing slash?
On Tue, Jul 24, 2012 at 10:48 PM, Adi Ariyanto
aariya...@binus.edumailto:aariya...@binus.edu wrote:
Dear Gerald
This is screen capture on Debian,
Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
permitted by applicable law.
Last login: Tue Jul 24 16:45:54 2012
root@ticketing:~# cd /opt/otrs/scripts/
root@ticketing:/opt/otrs/scripts# ls | more
apache2-httpd.include.conf
apache2-perl-startup.plhttp://apache2-perl-startup.pl
auto_build
auto_build.sh
auto_docbuild.sh
backup -- see I already make a folder name backup
backup.plhttp://backup.pl
for folder permission
root@ticketing:/opt/otrs/scripts# ls -a -l | more
total 572
drwxrwxr-x 7 otrs www-data 4096 Jul 25 09:08 .
drwxrwxrwx 8 root root 4096 Jul 20 16:46 ..
-rw-rw-r-- 1 otrs www-data 2099 Nov 6 2011 apache2-httpd.include.conf
-rwxrwxr-x 1 otrs www-data 7360 Dec 13 2011
apache2-perl-startup.plhttp://apache2-perl-startup.pl
drwxrwxr-x 2 otrs www-data 4096 Jun 4 14:31 auto_build
-rw-rw-r-- 1 otrs www-data 10568 Feb 9 19:33 auto_build.sh
-rw-rw-r-- 1 otrs www-data 4047 Feb 26 2009 auto_docbuild.sh
drwxr-xr-x 2 otrs www-data 4096 Jul 25 09:08 backup
-rwxrwxr-x 1 otrs www-data 7721 Jan 10 2011 backup.plhttp://backup.pl
drwxrwxr-x 3 otrs www-data 4096 Jun 4 14:31 database
when I execute backup.plhttp://backup.pl
root@ticketing:/opt/otrs/scripts# bash
root@ticketing:/opt/otrs/scripts# ./backup.plhttp://backup.pl -d backup/
ERROR: Can't create directory: backup//2012-07-25_09-36: No such file or
directory
root@ticketing:/opt/otrs/scripts#
This is from my Centos 6 Machine (correction I used CentOS 6 Minimal) :)
[root@localhost scripts]# ls -a -l | more
total 572
drwxrwxr-x 7 otrs apache 4096 Jul 24 23:02 .
drwxr-xr-x 8 root root 4096 Jul 24 05:30 ..
-rw-rw-r-- 1 otrs apache 2099 Jun 4 14:36 apache2-httpd.include.conf
-rwxrwxr-x 1 otrs apache 7360 Jun 4 14:36
apache2-perl-startup.plhttp://apache2-perl-startup.pl
drwxrwxr-x 2 otrs apache 4096 Jul 24 05:30 auto_build
-rw-rw-r-- 1 otrs apache 10568 Jun 4 14:36 auto_build.sh
-rw-rw-r-- 1 otrs apache 4047 Jun 4 14:36 auto_docbuild.sh
drwxr-xr-x 2 otrs apache 4096 Jul 24 23:02 backup
-rwxrwxr-x 1 otrs apache 7721 Jun 4 14:36 backup.plhttp://backup.pl
drwxrwxr-x 3 otrs apache 4096 Jul 24 05:30 database
This I when I try run backup.plhttp://backup.pl
[root@localhost scripts]# bash
[root@localhost scripts]# ./backup.plhttp://backup.pl -d backup/
ERROR: Can't create directory: backup//2012-07-25_16-47: No such file or
directory
[root@localhost scripts]#
Any idea :( hiks hiks..
From: otrs-boun...@otrs.orgmailto:otrs-boun...@otrs.org
[mailto:otrs-boun...@otrs.orgmailto:otrs-boun...@otrs.org] On Behalf Of
Gerald Young
Sent: Tuesday, July 24, 2012 6:57 PM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] Backup on OTRS
If you received such an error, it is likely not lying to you that there is no
writable directory named backup in the root / of your filesystem. Either
create it or specify an alternate path to dump the backup.
On Tue, Jul 24, 2012 at 7:18 AM, Steve Clark
scl...@netwolves.commailto:scl...@netwolves.com wrote:
On 07/24/2012 05:16 AM, Adi Ariyanto wrote:
Hi, did someone ever meet this case ?
I try to backup my otrs with this command
./backup.plhttp://backup.pl -d /backup/
But I got ERROR: No Such directory: /backup/
I google and found an post that said backup.plhttp://backup.pl not work on
debian, my OTRS run on Debian, then I try install OTRS
[otrs] Backup OTRS running on SQL Server 2005 and Windows Server 2003
Hi OTRS community, is it possible to use the backup.pl script to backup my OTRS system? Or does someone have a modified version oft he script which works with this configuration? Is there anything specific I have to take care of? Johannes - 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 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/
[otrs] Backup/archivng/dump of OTRS data
We have a live version of OTRS 2.2.5 running on Apache. We want to be able to periodically (maybe once every 3 months) dump all the data to a local version (2.3.3) of OTRS running on Windows. 1) What is the procedure? 2) Does it import queue structure, states etc or do we need to replicate ths structure before importing? 3) How long does it take to do? 4) Does it replace exisiting data, or append with new data? 5) How does it append to existing, yet closed tickets? 6) Are there any issues regarding the fact that the live version is different, with a different platform, from the local version? Any kind help you could offer me would be gratefully appreciated. Lev - 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/
[otrs] backup error, Application.tar.gz: file changed as we read it, failed
Hi I'm trying out the backup script in otrs/scripts, but I get this error message: otrs:/usr/share/otrs/backup# /usr/share/otrs/scripts/backup.pl -d /usr/share/otrs/backup done Backup /usr/share/otrs/backup/2008-06-04_09-27/Config.tar.gz ... done Backup /usr/share/otrs/backup/2008-06-04_09-27/Application.tar.gz ... tar: ./backup/2008-06-04_09-27/Application.tar.gz: file changed as we read it failed Dump MySQL rdbms ... done Compress SQL-file... done -- Does anyone know how to fix Backup /usr/share/otrs/backup/2008-06-04_09-27/Application.tar.gz ... tar: ./backup/2008-06-04_09-27/Application.tar.gz: file changed as we read it failed? I still get some data into the archive though: -rw-r--r-- 1 root root 9910285 Jun 4 09:27 Application.tar.gz -rw-r--r-- 1 root root 12604 Jun 4 09:27 Config.tar.gz -rw-r--r-- 1 root root 16493 Jun 4 09:27 DatabaseBackup.sql.gz -rw-r--r-- 1 root root 224 Jun 4 09:27 SymLinks.tar.gz Thanks in advance! _ Utmana dina kompisar i Sten, sax, påse! http://www.live.msn.se/messenger/#/News/___ 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/
Re: [otrs] backup error, Application.tar.gz: file changed as we read it, failed
Hi Friedrich, You're placing your backup in the OTRS tree, and then backing up the backup as it is being written.. Place the backup somewhere else: backup.pl -d /var/otrs-backup -- Lars From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Friedrich Nietzsche Sent: Wednesday, June 04, 2008 9:31 AM To: otrs@otrs.org Subject: [otrs] backup error, Application.tar.gz: file changed as we read it, failed Hi I'm trying out the backup script in otrs/scripts, but I get this error message: otrs:/usr/share/otrs/backup# /usr/share/otrs/scripts/backup.pl -d /usr/share/otrs/backup done Backup /usr/share/otrs/backup/2008-06-04_09-27/Config.tar.gz ... done Backup /usr/share/otrs/backup/2008-06-04_09-27/Application.tar.gz ... tar: ./backup/2008-06-04_09-27/Application.tar.gz: file changed as we read it failed Dump MySQL rdbms ... done Compress SQL-file... done -- Does anyone know how to fix Backup /usr/share/otrs/backup/2008-06-04_09-27/Application.tar.gz ... tar: ./backup/2008-06-04_09-27/Application.tar.gz: file changed as we read it failed? I still get some data into the archive though: -rw-r--r-- 1 root root 9910285 Jun 4 09:27 Application.tar.gz -rw-r--r-- 1 root root 12604 Jun 4 09:27 Config.tar.gz -rw-r--r-- 1 root root 16493 Jun 4 09:27 DatabaseBackup.sql.gz -rw-r--r-- 1 root root 224 Jun 4 09:27 SymLinks.tar.gz Thanks in advance! Den perfekta mixen av nöjesnyheter livekonserter! MSN Videohttp://video.se.msn.com/v/sv-se/v.htm ___ 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/
Re: [otrs] OTRS backup failure question...
Hi Craig, On Apr 10, 2008, at 19:19 , Craig Meirick wrote: I am trying to get our OTRS system backed up using the instructions provided in the manual using the backup.pl script. Here is what I am getting when this is ran: nagios:/opt/otrs/scripts # ./backup.pl -d /backup/ Backup /backup//2008-04-10_11-56/Config.tar.gz ... done Backup /backup//2008-04-10_11-56/Application.tar.gz ... done Dump MySQL rdbms ... mysqldump: Got error: 1045: Access denied for user 'otrs'@'localhost' (using password: YES) when trying to connect failed Compress SQL-file... done nagios:/opt/otrs/scripts # How can I fix this? The backup.pl tries to dump the database by using the user, pw and database settings from Kernel/Config.pm. It looks like the config settings from Kernel/Config.pm are not working to get the database connect. Greetings, -Martin -- ((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! Address of record: Bad Homburg Local Court: Bad Homburg, HRB 10751 Tax number: 003/240/97505 Chairman: Burchard Steinbild Chief Executive Officer: André Mindermann ___ 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/
[otrs] OTRS backup failure question...
I am trying to get our OTRS system backed up using the instructions provided in the manual using the backup.pl script. Here is what I am getting when this is ran: nagios:/opt/otrs/scripts # ./backup.pl -d /backup/ Backup /backup//2008-04-10_11-56/Config.tar.gz ... done Backup /backup//2008-04-10_11-56/Application.tar.gz ... done Dump MySQL rdbms ... mysqldump: Got error: 1045: Access denied for user 'otrs'@'localhost' (using password: YES) when trying to connect failed Compress SQL-file... done nagios:/opt/otrs/scripts # How can I fix this? Thank you, ~~~ Craig Meirick, Help Desk/PC Support Northeast Iowa Community College -- http://www.nicc.edu ~~~ ___ 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/
[otrs] Backup MySQL Cron
Hello, I have a question concerning database backup. I want a weekly backup with a cron, but I don't know where integrate my backup script (shell). Do you have an idea ? Thanks for your help. Benoit DAVAUT Adoptez l'éco-attitude. N'imprimez ce mail que si c'est vraiment nécessaire. image001.gif___ 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/
Re: [otrs] Backup MySQL Cron
DAVAUT Benoit wrote: I have a question concerning database backup. I want a weekly backup with a cron, but I don’t know where integrate my backup script (shell). Do you have an idea ? The Linux distributions that we use have /etc/cron.weekly, if you have that you could place your script in there (or create a symlink) to have it run weekly as root. See 'man crontab' for more info on crontabs. Nils Breunese.___ 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/
RE: [otrs] Backup MySQL Cron
Thank you for your answer, but is it possible to OTRS internally ? I saw that there were folders and files of cron ... Benoit DAVAUT -Original Message- From: Nils Breunese (Lemonbit) [mailto:[EMAIL PROTECTED] Sent: mardi 25 mars 2008 14:18 To: User questions and discussions about OTRS.org Subject: Re: [otrs] Backup MySQL Cron DAVAUT Benoit wrote: I have a question concerning database backup. I want a weekly backup with a cron, but I don't know where integrate my backup script (shell). Do you have an idea ? The Linux distributions that we use have /etc/cron.weekly, if you have that you could place your script in there (or create a symlink) to have it run weekly as root. See 'man crontab' for more info on crontabs. Nils Breunese.___ 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/ ___ 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/
Re: [otrs] Backup MySQL Cron
Op 25 mrt 2008, om 14:27 heeft DAVAUT Benoit het volgende geschreven: Thank you for your answer, but is it possible to OTRS internally ? I saw that there were folders and files of cron ... The OTRS user run some cronjobs, yes. But they aren't any more 'internal' than any other cronjobs as far as I know. Nils Breunese. ___ 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/
[otrs] Backup MySQL Cron
You can configure a weekly mysql backup with cron #crontab -e And insert the following command: 30 3 * * 1 mysqldump -uroot -pyourpassword --all-databases | gzip backup.sql.gz This command would backup your database to /root every Monday at 3:30. ___ 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/
RE: [otrs] Backup MySQL Cron
Thank you for your help ! Benoit DAVAUT -Original Message- From: Simon Pearce [mailto:[EMAIL PROTECTED] Sent: mardi 25 mars 2008 15:07 To: User questions and discussions about OTRS.org Subject: [otrs] Backup MySQL Cron You can configure a weekly mysql backup with cron #crontab -e And insert the following command: 30 3 * * 1 mysqldump -uroot -pyourpassword --all-databases | gzip backup.sql.gz This command would backup your database to /root every Monday at 3:30. ___ 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/ ___ 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/
[otrs] OTRS Backup for Windows
Can anyone comment on the following? We were trying to run the backup
script (OTRS is installed on a Windows box) and had to make the
following changes to get it to work properly. We changed the process
for directory change as noted below. Is there another way we should be
getting backups to run? Will this cause issues for us in the future?
Thanks in advance.
Steve
From: Fisher, Michael
Sent: Thursday, March 20, 2008 5:26 PM
To: Clary, Steve; Pulver, Steve
Subject: OTRS Backup Changes
Steve, Steve--
I changed the backup script from doing the directory change in the
subshell (system) process to directly from perl, and this helped,
because Perl can interpret the hybrid DOS/UNIX-style paths (i.e.
C:/OTRS/otrs) better than the DOS shell can:
C:\OTRScd c:/otrs/otrs
The system cannot find the path specified.
This corrected the failure we had--there might be a cleaner way to put
it into the script, but I was just moving quickly.
--- backup.pl.orig 2008-03-20 17:16:07.716496300 -0400
+++ backup.pl 2008-03-20 17:15:15.795618200 -0400
@@ -182,7 +183,8 @@
# backup Kernel/Config.pm
print Backup $Directory/Config.tar.gz ... ;
-if (!system(cd $Home tar -czf $Directory/Config.tar.gz
Kernel/Config.pm Kernel/Config/Files/ZZZA*.pm
Kernel/Config/GenericAgen*.pm)) {
+chdir($Home);
+if (!system(tar -czf $Directory/Config.tar.gz Kernel/Config.pm
Kernel/Config/Files/ZZZA*.pm Kernel/Config/GenericAgen*.pm)) {
print done\n;
}
else {
@@ -192,7 +194,8 @@
# backup application
if ($FullBackup) {
print Backup $Directory/Application.tar.gz ... ;
-if (!system(cd $Home tar -czf $Directory/Application.tar.gz
)) {
+chdir($Home);
+if (!system(tar -czf $Directory/Application.tar.gz .)) {
print done\n;
}
else {
--
Mike Fisher [EMAIL PROTECTED] 585-275-6884
University of Rochester School of
Nursing
___
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/
[otrs] backup
I am getting this when trying to run the backup script. [EMAIL PROTECTED]:/var/www/otrs2$ /usr/share/otrs/scripts/backup.pl --help Can't locate /etc/otrs/database.pm in @INC (@INC contains: /usr/share/otrs/Kernel/cpan-lib /usr/share/otrs /etc/perl /usr/local/lib/perl/5.8.8 /usr/local/share/perl/5.8.8 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl .) at /usr/share/otrs/Kernel/Config.pm line 24. BEGIN failed--compilation aborted at /usr/share/otrs/Kernel/Config.pm line 34. Compilation failed in require at /usr/share/otrs/scripts/backup.pl line 36. BEGIN failed--compilation aborted at /usr/share/otrs/scripts/backup.pl line 36. Andrew Meyer Unix Systems Administrator 314-787-0681 x39 314-565-0868 (cell) 1300 Hampton Ave. Ste. 200 Saint Louis, MO 63139 http://www.precisionpractice.com/ ___ 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/
Re: [otrs] backup
Andrew Meyer пишет: I am getting this when trying to run the backup script. [EMAIL PROTECTED]:/var/www/otrs2$ /usr/share/otrs/scripts/backup.pl --help Can't locate /etc/otrs/database.pm in @INC (@INC contains: /usr/share/otrs/Kernel/cpan-lib /usr/share/otrs /etc/perl /usr/local/lib/perl/5.8.8 /usr/local/share/perl/5.8.8 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl .) at /usr/share/otrs/Kernel/Config.pm line 24. BEGIN failed--compilation aborted at /usr/share/otrs/Kernel/Config.pm line 34. Compilation failed in require at /usr/share/otrs/scripts/backup.pl line 36. BEGIN failed--compilation aborted at /usr/share/otrs/scripts/backup.pl line 36. It is in my opinion better to do backup not by means most OTRS, and scripts which simply would carry out dump databases and the files necessary to you. It can be put on automatic performance and you will not have similar problems. It is possible to write a script on sh. -- swood begin:vcard fn:Anton swood n:swood;Anton org:Peterhost;VH email;internet:[EMAIL PROTECTED] title:support tel;work:89052338027 tel;cell:89052338027 x-mozilla-html:FALSE version:2.1 end:vcard ___ 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/
[otrs] Backup and Restore - OTRS running on FreeBSD
The instructions on the OTRS website provides Linux commands for Backup and Restoring Application and Data files. Could anyone provide the instructions on the FreeBSD platform? Thanks Bob Please be advised that no quotes, agreements or understandings involving Schuco will be binding unless and until codified in a written document signed by an officer of the company. The information transmitted by this email is intended only for the use of the addressee(s) and may contain confidential and/or privileged information. Any interception, review, retransmission, dissemination, or other use of, or taking any action upon this information by persons or entities other than the intended recipient(s) is prohibited by law and may subject them to criminal or civil liability. If you have received this communication in error, please contact us immediately at 877-472-4826 and delete the message from any computer or other storage system. ___ 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/
Re: [otrs] Backup and Restore - OTRS running on FreeBSD
What?? Are you saying the backup¹ script isn¹t working under freebsd? What shell are you using? -Andy On 11/13/07 2:47 PM, Swearsky, Robert [EMAIL PROTECTED] wrote: The instructions on the OTRS website provides Linux commands for Backup and Restoring Application and Data files. Could anyone provide the instructions on the FreeBSD platform? Thanks Bob Please be advised that no quotes, agreements or understandings involving Schüco will be binding unless and until codified in a written document signed by an officer of the company. The information transmitted by this email is intended only for the use of the addressee(s) and may contain confidential and/or privileged information. Any interception, review, retransmission, dissemination, or other use of, or taking any action upon this information by persons or entities other than the intended recipient(s) is prohibited by law and may subject them to criminal or civil liability. If you have received this communication in error, please contact us immediately at 877-472-4826 and delete the message from any computer or other storage system. ___ 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/ ___ 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/
RE: [otrs] Backup and Restore - OTRS running on FreeBSD
Andy, I was just looking for confirmation that the same scripting provided for Linux will work for FreeBSD. We are going to try the process tomorrow. Thanks Robert Swearsky IT Project Manager SCHÜCO -USA 860-616-0132 [EMAIL PROTECTED] From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Lubel Sent: Tuesday, November 13, 2007 3:45 PM To: User questions and discussions about OTRS.org Subject: Re: [otrs] Backup and Restore - OTRS running on FreeBSD What?? Are you saying the 'backup' script isn't working under freebsd? What shell are you using? -Andy On 11/13/07 2:47 PM, Swearsky, Robert [EMAIL PROTECTED] wrote: The instructions on the OTRS website provides Linux commands for Backup and Restoring Application and Data files. Could anyone provide the instructions on the FreeBSD platform? Thanks Bob Please be advised that no quotes, agreements or understandings involving Schüco will be binding unless and until codified in a written document signed by an officer of the company. The information transmitted by this email is intended only for the use of the addressee(s) and may contain confidential and/or privileged information. Any interception, review, retransmission, dissemination, or other use of, or taking any action upon this information by persons or entities other than the intended recipient(s) is prohibited by law and may subject them to criminal or civil liability. If you have received this communication in error, please contact us immediately at 877-472-4826 and delete the message from any computer or other storage system. ___ 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/ Please be advised that no quotes, agreements or understandings involving Schüco will be binding unless and until codified in a written document signed by an officer of the company. The information transmitted by this email is intended only for the use of the addressee(s) and may contain confidential and/or privileged information. Any interception, review, retransmission, dissemination, or other use of, or taking any action upon this information by persons or entities other than the intended recipient(s) is prohibited by law and may subject them to criminal or civil liability. If you have received this communication in error, please contact us immediately at 877-472-4826 and delete the message from any computer or other storage system. ___ 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/
AW: Antwort: AW: AW: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux
Neenee, deswegen ja, ich hatte meinen Custom Theme auf 2.2.2 ja auch schon am laufen, nur nach dem Update auf 2.2.3 ging er eben nicht mehr...auch eben nicht mit der Methode die hier jemand vorgeschlagen hat. Die modifizierten Files sind CustomerHeader customer...css usw. Aber danke für eure Hilfe ;) -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Auftrag von Marina Henn Gesendet: Mittwoch, 10. Oktober 2007 08:34 An: User questions and discussions about OTRS.org in German Betreff: Antwort: AW: AW: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux Ich verstehe die Verwirrung nicht ganz. in dem Standard-Ordner sind alle Files, sowohl die für Supporter (fangen meistens mit Agent an) als auch die für die Kunden (beginnen meist mit Customer). Die für die Kunden haben zwar einen anderen (Vor-)Namen, funktionieren aber ganz genauso wie die für Agenten. Da du danach immernoch den grünen Look hattest, könntes es sein, daß du nur die Agent...dtl angepasst hast? Mit freundlichen Grüßen Marina Henn Netzlink Informationstechnik GmbH Heinrich-Büssing-Ring 42 D-38102 Braunschweig Telefon: 0531-7073430 Telefax: 0531-7073459 eMail: [EMAIL PROTECTED] http://www.netzlink.com/ www.netzlink.com Geschäftsführung: Harald Lies, Tamara Ostermann, Sven-Ove Wähling Amtsgericht Braunschweig HR B 4896, USt-IdNr. DE 202670390 Veranstaltungen: 10.10.. http://www.netzlink.com/de/Aktuelles/Veranstaltungen/Citrix/ CITRIX Solutions Seminar Braunschweig 17.10.. http://www.netzlink.com/de/Aktuelles/Veranstaltungen/IT_Themenabend/ Themenabend Hamburg Revisionssichere Archivierung 18.10.. http://www.netzlink.com/de/Aktuelles/Veranstaltungen/IT_Themenabend/ Themenabend Hannover Revisionssichere Archivierung Matthias Schojohann [EMAIL PROTECTED] Gesendet von: [EMAIL PROTECTED] 09.10.2007 16:15 Bitte antworten an User questions and discussions about OTRS.org in German otrs-de@otrs.org An User questions and discussions about OTRS.org in German otrs-de@otrs.org Kopie Thema AW: AW: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux Ja das kenne ich ja auch alles, einen Theme für die Agenten habe ich ja auch schon erstellt usw. aber für das Kundenportal funktioniert das eben nicht...bzw. wo kann man denn Themes fürs Kundenportal auswählen? In der Sysconfig hatte ich einen Punkt gefunden unter dem man einen Default-Theme auswählen kann, da hab ich dann meinen custom theme eingetragen doch das Kundenportal hatte den Default grünen Look. Naja ich hab jetzt einfach die entsprechenden Files ersetzt und habe wieder mein Custom Portal. Vielen Dank trotzdem, matthias -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Auftrag von Stefan Rother Gesendet: Dienstag, 9. Oktober 2007 15:46 An: User questions and discussions about OTRS.org in German Betreff: Re: AW: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux Hallo Herr Schojohann, Ich wusste nicht, dass das auch mit dem Kundenportal funktioniert, ich dachte da gäbe es nur einen Theme. Kannst du das bitte etwas genauer erklären? Es gibt hierzu einen Artikel in unserem Admin Handbuch unter: http://doc.otrs.org/2.2/de/html/c1899.html ((enjoy) -- Stefan Rother Support Director ((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/ Virus checked by G DATA AntiVirusKit Version: AVKA 17.445 from 08.10.2007 Virus news: www.antiviruslab.com ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/ ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/
Antwort: AW: AW: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux
Ich verstehe die Verwirrung nicht ganz. in dem Standard-Ordner sind alle Files, sowohl die für Supporter (fangen meistens mit Agent an) als auch die für die Kunden (beginnen meist mit Customer). Die für die Kunden haben zwar einen anderen (Vor-)Namen, funktionieren aber ganz genauso wie die für Agenten. Da du danach immernoch den grünen Look hattest, könntes es sein, daß du nur die Agent...dtl angepasst hast? Mit freundlichen Grüßen Marina Henn Netzlink Informationstechnik GmbH Heinrich-Büssing-Ring 42 D-38102 Braunschweig Telefon: 0531-7073430 Telefax: 0531-7073459 eMail: [EMAIL PROTECTED] www.netzlink.com Geschäftsführung: Harald Lies, Tamara Ostermann, Sven-Ove Wähling Amtsgericht Braunschweig HR B 4896, USt-IdNr. DE 202670390 Veranstaltungen: 10.10..CITRIX Solutions Seminar Braunschweig 17.10..Themenabend Hamburg Revisionssichere Archivierung 18.10..Themenabend Hannover Revisionssichere Archivierung Matthias Schojohann [EMAIL PROTECTED] Gesendet von: [EMAIL PROTECTED] 09.10.2007 16:15 Bitte antworten an User questions and discussions about OTRS.org in German otrs-de@otrs.org An User questions and discussions about OTRS.org in German otrs-de@otrs.org Kopie Thema AW: AW: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux Ja das kenne ich ja auch alles, einen Theme für die Agenten habe ich ja auch schon erstellt usw. aber für das Kundenportal funktioniert das eben nicht...bzw. wo kann man denn Themes fürs Kundenportal auswählen? In der Sysconfig hatte ich einen Punkt gefunden unter dem man einen Default-Theme auswählen kann, da hab ich dann meinen custom theme eingetragen doch das Kundenportal hatte den Default grünen Look. Naja ich hab jetzt einfach die entsprechenden Files ersetzt und habe wieder mein Custom Portal. Vielen Dank trotzdem, matthias -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Auftrag von Stefan Rother Gesendet: Dienstag, 9. Oktober 2007 15:46 An: User questions and discussions about OTRS.org in German Betreff: Re: AW: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux Hallo Herr Schojohann, Ich wusste nicht, dass das auch mit dem Kundenportal funktioniert, ich dachte da gäbe es nur einen Theme. Kannst du das bitte etwas genauer erklären? Es gibt hierzu einen Artikel in unserem Admin Handbuch unter: http://doc.otrs.org/2.2/de/html/c1899.html ((enjoy) -- Stefan Rother Support Director ((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/ Virus checked by G DATA AntiVirusKit Version: AVKA 17.445 from 08.10.2007 Virus news: www.antiviruslab.com ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/ ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/
[otrs-de] Ein sauberes OTRS Backup unter Linux
Wie funktioniert ein sauberes Backup? Ich finde überall nur Informationen zum Update von 2.1 auf 2.2, aber wie mache ich eins von 2.2.2 auf 2.2.3? Gruß, matthias Virus checked by G DATA AntiVirusKit Version: AVKA 17.445 from 08.10.2007 Virus news: www.antiviruslab.com ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/
Re: [otrs-de] Ein sauberes OTRS Backup unter Linux
Sehr geehrter Herr Schojohann, Wie funktioniert ein sauberes Backup? Im OTRS_Home Verzeichnis unter scripts/ befindet sich ein Script mit dem Namen backup.pl. Dieses Script kann für Backups verwendet werden. Die genaue Syntax: ./backup.pl -d /data_backup_dir/ [-c gzip|bzip2] [-r 30] [-t fullbackup|nofullbackup] Weiterhin existiert ein Script restore.pl, um Backups im System wieder einzuspielen. Die genaue Syntax: restore.pl -b /data_backup/TIME/ -d /opt/otrs/ Ich finde überall nur Informationen zum Update von 2.1 auf 2.2, aber wie mache ich eins von 2.2.2 auf 2.2.3? Im OTRS_Home Verzeichnis befindet sich die Datei Upgrading. Bitte gehen Sie so vor wie in der Datei beschrieben. Den Teil Update the database changes können Sie überspringen, da kein Datenbank Update von 2.2.2 auf 2.2.3 notwendig ist. Ich hoffe ich konnte Ihnen helfen! ((enjoy)) -- Stefan Rother Support Director ((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/
AW: [otrs-de] Ein sauberes OTRS Backup unter Linux
Die Scripts sind mir soweit bekannt...nur bzgl. des UPGRADING Dokuments: These instructions are for people upgrading OTRS from 2.1 to 2.2. Aber im Prinzip könnte man doch nach dieser Reihenfolge vorgehen: backup.pl /OTRS_HOME/ mit otrs-2.2.3.tar.gz überschreiben/ersetzen restore.pl oder? -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Auftrag von Stefan Rother Gesendet: Dienstag, 9. Oktober 2007 13:06 An: User questions and discussions about OTRS.org in German Betreff: Re: [otrs-de] Ein sauberes OTRS Backup unter Linux Sehr geehrter Herr Schojohann, Wie funktioniert ein sauberes Backup? Im OTRS_Home Verzeichnis unter scripts/ befindet sich ein Script mit dem Namen backup.pl. Dieses Script kann für Backups verwendet werden. Die genaue Syntax: ./backup.pl -d /data_backup_dir/ [-c gzip|bzip2] [-r 30] [-t fullbackup|nofullbackup] Weiterhin existiert ein Script restore.pl, um Backups im System wieder einzuspielen. Die genaue Syntax: restore.pl -b /data_backup/TIME/ -d /opt/otrs/ Ich finde überall nur Informationen zum Update von 2.1 auf 2.2, aber wie mache ich eins von 2.2.2 auf 2.2.3? Im OTRS_Home Verzeichnis befindet sich die Datei Upgrading. Bitte gehen Sie so vor wie in der Datei beschrieben. Den Teil Update the database changes können Sie überspringen, da kein Datenbank Update von 2.2.2 auf 2.2.3 notwendig ist. Ich hoffe ich konnte Ihnen helfen! ((enjoy)) -- Stefan Rother Support Director ((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/ Virus checked by G DATA AntiVirusKit Version: AVKA 17.445 from 08.10.2007 Virus news: www.antiviruslab.com ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/
Re: [otrs-de] Ein sauberes OTRS Backup unter Linux
Guten Tag Stefan Rother. Im OTRS_Home Verzeichnis unter scripts/ befindet sich ein Script mit dem Namen backup.pl. Dieses Script kann für Backups verwendet werden. Hält das Backup Script die Daten aus DB und FS eigentlich auch konsistent? Was passiert, wenn die Daten aus dem FS gesichert sind, neue Daten (Mails) hinzukommen und dann das Backup der DB beginnt? Gibts dann einen Unterschied zwischen DB und FS Backup? -- Mit freundlichen Grüssen André Bauer System: Ubuntu Server 6.06.1 LTS / Apache 2.0.55 - MOD_PERL 2.0.2 / MySQL 5.0.21 / OTRS 2.2.3 Sehr geehrter Herr Schojohann, Wie funktioniert ein sauberes Backup? Die genaue Syntax: ./backup.pl -d /data_backup_dir/ [-c gzip|bzip2] [-r 30] [-t fullbackup|nofullbackup] Weiterhin existiert ein Script restore.pl, um Backups im System wieder einzuspielen. Die genaue Syntax: restore.pl -b /data_backup/TIME/ -d /opt/otrs/ Ich finde überall nur Informationen zum Update von 2.1 auf 2.2, aber wie mache ich eins von 2.2.2 auf 2.2.3? Im OTRS_Home Verzeichnis befindet sich die Datei Upgrading. Bitte gehen Sie so vor wie in der Datei beschrieben. Den Teil Update the database changes können Sie überspringen, da kein Datenbank Update von 2.2.2 auf 2.2.3 notwendig ist. Ich hoffe ich konnte Ihnen helfen! ((enjoy)) ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/
Re: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux
Sehr geehrter Herr Schojohann, Die Scripts sind mir soweit bekannt...nur bzgl. des UPGRADING Dokuments: These instructions are for people upgrading OTRS from 2.1 to 2.2. Aber im Prinzip könnte man doch nach dieser Reihenfolge vorgehen: backup.pl /OTRS_HOME/ mit otrs-2.2.3.tar.gz überschreiben/ersetzen restore.pl oder? Nein, so geht das nicht. Wenn Sie restore.pl ausführen, überschreiben Sie Ihr Update in diesem Moment wieder... Ich kenne leider Ihre Installation nicht genau, aber in der Regel würde ich so vorgehen: 1.) Stoppen Sie die Datenbank, Cron und den Webserver. Sichern Sie die Datenbank und das OTRS_Home Verzeichnis. 2.) Löschen Sie das OTRS_Home Verzeichnis. 3.) Entpacken Sie die neue OTRS Version nach OTRS_Home. 4.) Kopieren Sie alle Konfigurationsdateien von der Sicherung in das neue OTRS. (Kernel/Config.pm und Kernel/Config/Files/ZZZAuto.pm) 5.) Übernehmen Sie das gesamte var/ Verzeichnis aus dem Backup in das neue System. 6.) Führen Sie das Script bin/SetPermission.sh aus. 7.) Reinstallieren Sie alle Installierten opm Pakete. 8.) Starten Sie die Dienste wieder. ((enjoy)) -- Stefan Rother Support Director ((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/
Re: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux
Hallo, OTRS besteht ja nur aus den Dateien unter dem Verzeichnis otrs und der Datenbank. Daher bin ich bei allen bisherigen updates - und so auch zuletzt beim Update von Version 2.2.2 auf 2.2.3 - immer folgendermaßen vorgegangen: Das komplette otrs Verzeichnis sichern. Unter linux # cp -RP otrs/ otrs.bak Die Datenbank sichern. Unter MySQL # mysqldump --opt otrs -p otrs.sql Dann die neue Version über die vorherige kopieren. Wenn man keine Änderungen an den templates vorgenommen hat, bspw. um das Aussehen von otrs zu ändern, sollte alles auf Anhieb funktionieren und vor allem ein restore.pl wäre nicht nur überflüssig, sondern auch schadhaft, da es ja vorherige Versionen wieder herstellt. Hth EDV Tekomedia Markus Nagel Tekomedia GmbH Castroper Str.12 D-44791 Bochum T: +49 (0)234 8939-0 F: +49 (0)234 8939-28 --- Tekomedia GmbH Castroper Str. 12, 44791 Bochum Reg.-gericht Bochum HRB 6537 St.- Nr.: 306 5867 0873 Geschäftsführung: Hans-Günter Oberlindober Matthias Schojohann schrieb: Die Scripts sind mir soweit bekannt...nur bzgl. des UPGRADING Dokuments: These instructions are for people upgrading OTRS from 2.1 to 2.2. Aber im Prinzip könnte man doch nach dieser Reihenfolge vorgehen: backup.pl /OTRS_HOME/ mit otrs-2.2.3.tar.gz überschreiben/ersetzen restore.pl oder? -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Auftrag von Stefan Rother Gesendet: Dienstag, 9. Oktober 2007 13:06 An: User questions and discussions about OTRS.org in German Betreff: Re: [otrs-de] Ein sauberes OTRS Backup unter Linux Sehr geehrter Herr Schojohann, Wie funktioniert ein sauberes Backup? Im OTRS_Home Verzeichnis unter scripts/ befindet sich ein Script mit dem Namen backup.pl. Dieses Script kann für Backups verwendet werden. Die genaue Syntax: ./backup.pl -d /data_backup_dir/ [-c gzip|bzip2] [-r 30] [-t fullbackup|nofullbackup] Weiterhin existiert ein Script restore.pl, um Backups im System wieder einzuspielen. Die genaue Syntax: restore.pl -b /data_backup/TIME/ -d /opt/otrs/ Ich finde überall nur Informationen zum Update von 2.1 auf 2.2, aber wie mache ich eins von 2.2.2 auf 2.2.3? Im OTRS_Home Verzeichnis befindet sich die Datei Upgrading. Bitte gehen Sie so vor wie in der Datei beschrieben. Den Teil Update the database changes können Sie überspringen, da kein Datenbank Update von 2.2.2 auf 2.2.3 notwendig ist. Ich hoffe ich konnte Ihnen helfen! ((enjoy)) ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/
Re: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux
Hallo Herr Nagel, OTRS besteht ja nur aus den Dateien unter dem Verzeichnis otrs und der Datenbank. Daher bin ich bei allen bisherigen updates - und so auch zuletzt beim Update von Version 2.2.2 auf 2.2.3 - immer folgendermaßen vorgegangen: Das komplette otrs Verzeichnis sichern. Unter linux # cp -RP otrs/ otrs.bak Die Datenbank sichern. Unter MySQL # mysqldump --opt otrs -p otrs.sql Dann die neue Version über die vorherige kopieren. Wenn man keine Änderungen an den templates vorgenommen hat, bspw. um das Aussehen von otrs zu ändern, sollte alles auf Anhieb funktionieren und vor allem ein restore.pl wäre nicht nur überflüssig, sondern auch schadhaft, da es ja vorherige Versionen wieder herstellt. Ja, in 99% aller Fälle funktioniert das Vorgehen so auch. Allerdings kann es dann passieren, das Leichen in Form von Dateien im System verbleiben die nicht mehr verwendet werden. Auch können Probleme entstehen, wenn opm Pakete installiert sind. Beispiel: Es ist auf OTRS 2.2.2 ein OPM Paket installiert, das die Datei Kernel/System/CustomerUser.pm verändert. In diesem Moment kopiert der OPM Mechanismus die original Datei CustomerUser.pm als CustomerUser.pm.save weg. Jetzt führen Sie ein Update wie von Ihnen beschrieben aus; merken das Sie das OPM Paket nicht mehr benötigen und deinstallieren es. Somit wird die Datei CustomerUser.pm.save wiederhergestellt aber aus der Version 2.2.2! Und dann ist es meist viel schwieriger den Fehler zu finden, falls geringe Modifikationen an der Datei vorgenommen wurden... ((enjoy)) -- Stefan Rother Support Director ((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/
AW: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux
Das hat wunderbar funktioniert, vielen Dank! Jetzt halten sich die Eskalationszeiten auch endlich an die WorkingHours ;) -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Auftrag von Stefan Rother Gesendet: Dienstag, 9. Oktober 2007 13:24 An: User questions and discussions about OTRS.org in German Betreff: Re: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux Sehr geehrter Herr Schojohann, Die Scripts sind mir soweit bekannt...nur bzgl. des UPGRADING Dokuments: These instructions are for people upgrading OTRS from 2.1 to 2.2. Aber im Prinzip könnte man doch nach dieser Reihenfolge vorgehen: backup.pl /OTRS_HOME/ mit otrs-2.2.3.tar.gz überschreiben/ersetzen restore.pl oder? Nein, so geht das nicht. Wenn Sie restore.pl ausführen, überschreiben Sie Ihr Update in diesem Moment wieder... Ich kenne leider Ihre Installation nicht genau, aber in der Regel würde ich so vorgehen: 1.) Stoppen Sie die Datenbank, Cron und den Webserver. Sichern Sie die Datenbank und das OTRS_Home Verzeichnis. 2.) Löschen Sie das OTRS_Home Verzeichnis. 3.) Entpacken Sie die neue OTRS Version nach OTRS_Home. 4.) Kopieren Sie alle Konfigurationsdateien von der Sicherung in das neue OTRS. (Kernel/Config.pm und Kernel/Config/Files/ZZZAuto.pm) 5.) Übernehmen Sie das gesamte var/ Verzeichnis aus dem Backup in das neue System. 6.) Führen Sie das Script bin/SetPermission.sh aus. 7.) Reinstallieren Sie alle Installierten opm Pakete. 8.) Starten Sie die Dienste wieder. ((enjoy)) -- Stefan Rother Support Director ((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/ Virus checked by G DATA AntiVirusKit Version: AVKA 17.445 from 08.10.2007 Virus news: www.antiviruslab.com ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/
Re: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux
Hallo Herr Rother, ok, das ist einleuchtend. Hatte bislang dann wohl Glück. Werd mir für die Zukunft Ihre Anleitung zu Herzen nehmen. Gruß EDV Tekomedia Markus Nagel Tekomedia GmbH Castroper Str.12 D-44791 Bochum T: +49 (0)234 8939-0 F: +49 (0)234 8939-28 --- Tekomedia GmbH Castroper Str. 12, 44791 Bochum Reg.-gericht Bochum HRB 6537 St.- Nr.: 306 5867 0873 Geschäftsführung: Hans-Günter Oberlindober Stefan Rother schrieb: Hallo Herr Nagel, OTRS besteht ja nur aus den Dateien unter dem Verzeichnis otrs und der Datenbank. Daher bin ich bei allen bisherigen updates - und so auch zuletzt beim Update von Version 2.2.2 auf 2.2.3 - immer folgendermaßen vorgegangen: Das komplette otrs Verzeichnis sichern. Unter linux # cp -RP otrs/ otrs.bak Die Datenbank sichern. Unter MySQL # mysqldump --opt otrs -p otrs.sql Dann die neue Version über die vorherige kopieren. Wenn man keine Änderungen an den templates vorgenommen hat, bspw. um das Aussehen von otrs zu ändern, sollte alles auf Anhieb funktionieren und vor allem ein restore.pl wäre nicht nur überflüssig, sondern auch schadhaft, da es ja vorherige Versionen wieder herstellt. Ja, in 99% aller Fälle funktioniert das Vorgehen so auch. Allerdings kann es dann passieren, das Leichen in Form von Dateien im System verbleiben die nicht mehr verwendet werden. Auch können Probleme entstehen, wenn opm Pakete installiert sind. Beispiel: Es ist auf OTRS 2.2.2 ein OPM Paket installiert, das die Datei Kernel/System/CustomerUser.pm verändert. In diesem Moment kopiert der OPM Mechanismus die original Datei CustomerUser.pm als CustomerUser.pm.save weg. Jetzt führen Sie ein Update wie von Ihnen beschrieben aus; merken das Sie das OPM Paket nicht mehr benötigen und deinstallieren es. Somit wird die Datei CustomerUser.pm.save wiederhergestellt aber aus der Version 2.2.2! Und dann ist es meist viel schwieriger den Fehler zu finden, falls geringe Modifikationen an der Datei vorgenommen wurden... ((enjoy)) ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/
AW: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux
Ich sehe gerade dass mein Kundenportal wieder den Default-Look hat, kann ich /OTRS_HOME/Kernel/Output/HTML/Standard ebenfalls komplett rüberkopieren? -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Auftrag von Stefan Rother Gesendet: Dienstag, 9. Oktober 2007 13:24 An: User questions and discussions about OTRS.org in German Betreff: Re: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux Sehr geehrter Herr Schojohann, Die Scripts sind mir soweit bekannt...nur bzgl. des UPGRADING Dokuments: These instructions are for people upgrading OTRS from 2.1 to 2.2. Aber im Prinzip könnte man doch nach dieser Reihenfolge vorgehen: backup.pl /OTRS_HOME/ mit otrs-2.2.3.tar.gz überschreiben/ersetzen restore.pl oder? Nein, so geht das nicht. Wenn Sie restore.pl ausführen, überschreiben Sie Ihr Update in diesem Moment wieder... Ich kenne leider Ihre Installation nicht genau, aber in der Regel würde ich so vorgehen: 1.) Stoppen Sie die Datenbank, Cron und den Webserver. Sichern Sie die Datenbank und das OTRS_Home Verzeichnis. 2.) Löschen Sie das OTRS_Home Verzeichnis. 3.) Entpacken Sie die neue OTRS Version nach OTRS_Home. 4.) Kopieren Sie alle Konfigurationsdateien von der Sicherung in das neue OTRS. (Kernel/Config.pm und Kernel/Config/Files/ZZZAuto.pm) 5.) Übernehmen Sie das gesamte var/ Verzeichnis aus dem Backup in das neue System. 6.) Führen Sie das Script bin/SetPermission.sh aus. 7.) Reinstallieren Sie alle Installierten opm Pakete. 8.) Starten Sie die Dienste wieder. ((enjoy)) -- Stefan Rother Support Director ((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/ Virus checked by G DATA AntiVirusKit Version: AVKA 17.445 from 08.10.2007 Virus news: www.antiviruslab.com ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/
AW: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux
Am besten belässt man den Standrad-ordner und erstellt für sein Design einen eigenenen Unterordner im Verzeichnis HTML. Dieses muss man dann noch in die Themes-Tabelle eintragen und in der Sysconfig als Defaulttheme setzen. Freundliche Grüße i. A. Thomas Büchling Praktikant / IT-Services Tel +49 (0)561/ 4991 -125 Fax +49 (0)561/ 4991 -93125 [EMAIL PROTECTED] http://www.rudolph-log.de http://www.logeon.net -- Rudolph Logistik Gruppe -- Rudolph Holding GmbH Harzweg 10 D 34225 Baunatal Amtsgericht Kassel HRB 6548 Geschäftsführer: Jürgen Rudolph, Werner Rudolph, Torsten Rudolph, Peter Malkomeß - Abonnieren Sie unseren Newsletter RudolphREPORT unter http://www.rudolph-log.de/aktuelles/aktuelles.cfm -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Auftrag von Matthias Schojohann Gesendet: Dienstag, 9. Oktober 2007 14:17 An: User questions and discussions about OTRS.org in German Betreff: AW: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux Ich sehe gerade dass mein Kundenportal wieder den Default-Look hat, kann ich /OTRS_HOME/Kernel/Output/HTML/Standard ebenfalls komplett rüberkopieren? -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Auftrag von Stefan Rother Gesendet: Dienstag, 9. Oktober 2007 13:24 An: User questions and discussions about OTRS.org in German Betreff: Re: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux Sehr geehrter Herr Schojohann, Die Scripts sind mir soweit bekannt...nur bzgl. des UPGRADING Dokuments: These instructions are for people upgrading OTRS from 2.1 to 2.2. Aber im Prinzip könnte man doch nach dieser Reihenfolge vorgehen: backup.pl /OTRS_HOME/ mit otrs-2.2.3.tar.gz überschreiben/ersetzen restore.pl oder? Nein, so geht das nicht. Wenn Sie restore.pl ausführen, überschreiben Sie Ihr Update in diesem Moment wieder... Ich kenne leider Ihre Installation nicht genau, aber in der Regel würde ich so vorgehen: 1.) Stoppen Sie die Datenbank, Cron und den Webserver. Sichern Sie die Datenbank und das OTRS_Home Verzeichnis. 2.) Löschen Sie das OTRS_Home Verzeichnis. 3.) Entpacken Sie die neue OTRS Version nach OTRS_Home. 4.) Kopieren Sie alle Konfigurationsdateien von der Sicherung in das neue OTRS. (Kernel/Config.pm und Kernel/Config/Files/ZZZAuto.pm) 5.) Übernehmen Sie das gesamte var/ Verzeichnis aus dem Backup in das neue System. 6.) Führen Sie das Script bin/SetPermission.sh aus. 7.) Reinstallieren Sie alle Installierten opm Pakete. 8.) Starten Sie die Dienste wieder. ((enjoy)) -- Stefan Rother Support Director ((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/ Virus checked by G DATA AntiVirusKit Version: AVKA 17.445 from 08.10.2007 Virus news: www.antiviruslab.com ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? =http://www.otrs.com/ ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/
AW: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux
Ich wusste nicht, dass das auch mit dem Kundenportal funktioniert, ich dachte da gäbe es nur einen Theme. Kannst du das bitte etwas genauer erklären? Gruß, M. Schojohann -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Auftrag von Buechling, Thomas Gesendet: Dienstag, 9. Oktober 2007 14:19 An: User questions and discussions about OTRS.org in German Betreff: AW: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux Am besten belässt man den Standrad-ordner und erstellt für sein Design einen eigenenen Unterordner im Verzeichnis HTML. Dieses muss man dann noch in die Themes-Tabelle eintragen und in der Sysconfig als Defaulttheme setzen. Freundliche Grüße i. A. Thomas Büchling Praktikant / IT-Services Tel +49 (0)561/ 4991 -125 Fax +49 (0)561/ 4991 -93125 [EMAIL PROTECTED] http://www.rudolph-log.de http://www.logeon.net -- Rudolph Logistik Gruppe -- Rudolph Holding GmbH Harzweg 10 D 34225 Baunatal Amtsgericht Kassel HRB 6548 Geschäftsführer: Jürgen Rudolph, Werner Rudolph, Torsten Rudolph, Peter Malkomeß - Abonnieren Sie unseren Newsletter RudolphREPORT unter http://www.rudolph-log.de/aktuelles/aktuelles.cfm -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Auftrag von Matthias Schojohann Gesendet: Dienstag, 9. Oktober 2007 14:17 An: User questions and discussions about OTRS.org in German Betreff: AW: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux Ich sehe gerade dass mein Kundenportal wieder den Default-Look hat, kann ich /OTRS_HOME/Kernel/Output/HTML/Standard ebenfalls komplett rüberkopieren? -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Auftrag von Stefan Rother Gesendet: Dienstag, 9. Oktober 2007 13:24 An: User questions and discussions about OTRS.org in German Betreff: Re: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux Sehr geehrter Herr Schojohann, Die Scripts sind mir soweit bekannt...nur bzgl. des UPGRADING Dokuments: These instructions are for people upgrading OTRS from 2.1 to 2.2. Aber im Prinzip könnte man doch nach dieser Reihenfolge vorgehen: backup.pl /OTRS_HOME/ mit otrs-2.2.3.tar.gz überschreiben/ersetzen restore.pl oder? Nein, so geht das nicht. Wenn Sie restore.pl ausführen, überschreiben Sie Ihr Update in diesem Moment wieder... Ich kenne leider Ihre Installation nicht genau, aber in der Regel würde ich so vorgehen: 1.) Stoppen Sie die Datenbank, Cron und den Webserver. Sichern Sie die Datenbank und das OTRS_Home Verzeichnis. 2.) Löschen Sie das OTRS_Home Verzeichnis. 3.) Entpacken Sie die neue OTRS Version nach OTRS_Home. 4.) Kopieren Sie alle Konfigurationsdateien von der Sicherung in das neue OTRS. (Kernel/Config.pm und Kernel/Config/Files/ZZZAuto.pm) 5.) Übernehmen Sie das gesamte var/ Verzeichnis aus dem Backup in das neue System. 6.) Führen Sie das Script bin/SetPermission.sh aus. 7.) Reinstallieren Sie alle Installierten opm Pakete. 8.) Starten Sie die Dienste wieder. ((enjoy)) -- Stefan Rother Support Director ((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/ Virus checked by G DATA AntiVirusKit Version: AVKA 17.445 from 08.10.2007 Virus news: www.antiviruslab.com ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? =http://www.otrs.com/ ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? =http://www.otrs.com/ Virus checked by G DATA AntiVirusKit Version: AVKA 17.445 from 08.10.2007 Virus news: www.antiviruslab.com ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/
AW: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux
Nein soweit ich weiss regelt ein Theme das gesamte Aussehen, man kann also sowohl Kundenansicht als auch Supporteransicht ändern.. eben alle Dateien die sich in HTML/Standard befinden... einfach in zb HTML/MeinDesign kopieren und verändern.. Freundliche Grüße i. A. Thomas Büchling Praktikant / IT-Services Tel +49 (0)561/ 4991 -125 Fax +49 (0)561/ 4991 -93125 [EMAIL PROTECTED] http://www.rudolph-log.de http://www.logeon.net -- Rudolph Logistik Gruppe -- Rudolph Holding GmbH Harzweg 10 D 34225 Baunatal Amtsgericht Kassel HRB 6548 Geschäftsführer: Jürgen Rudolph, Werner Rudolph, Torsten Rudolph, Peter Malkomeß - Abonnieren Sie unseren Newsletter RudolphREPORT unter http://www.rudolph-log.de/aktuelles/aktuelles.cfm -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Auftrag von Matthias Schojohann Gesendet: Dienstag, 9. Oktober 2007 14:24 An: User questions and discussions about OTRS.org in German Betreff: AW: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux Ich wusste nicht, dass das auch mit dem Kundenportal funktioniert, ich dachte da gäbe es nur einen Theme. Kannst du das bitte etwas genauer erklären? Gruß, M. Schojohann -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Auftrag von Buechling, Thomas Gesendet: Dienstag, 9. Oktober 2007 14:19 An: User questions and discussions about OTRS.org in German Betreff: AW: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux Am besten belässt man den Standrad-ordner und erstellt für sein Design einen eigenenen Unterordner im Verzeichnis HTML. Dieses muss man dann noch in die Themes-Tabelle eintragen und in der Sysconfig als Defaulttheme setzen. Freundliche Grüße i. A. Thomas Büchling Praktikant / IT-Services Tel +49 (0)561/ 4991 -125 Fax +49 (0)561/ 4991 -93125 [EMAIL PROTECTED] http://www.rudolph-log.de http://www.logeon.net -- Rudolph Logistik Gruppe -- Rudolph Holding GmbH Harzweg 10 D 34225 Baunatal Amtsgericht Kassel HRB 6548 Geschäftsführer: Jürgen Rudolph, Werner Rudolph, Torsten Rudolph, Peter Malkomeß - Abonnieren Sie unseren Newsletter RudolphREPORT unter http://www.rudolph-log.de/aktuelles/aktuelles.cfm -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Auftrag von Matthias Schojohann Gesendet: Dienstag, 9. Oktober 2007 14:17 An: User questions and discussions about OTRS.org in German Betreff: AW: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux Ich sehe gerade dass mein Kundenportal wieder den Default-Look hat, kann ich /OTRS_HOME/Kernel/Output/HTML/Standard ebenfalls komplett rüberkopieren? -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Auftrag von Stefan Rother Gesendet: Dienstag, 9. Oktober 2007 13:24 An: User questions and discussions about OTRS.org in German Betreff: Re: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux Sehr geehrter Herr Schojohann, Die Scripts sind mir soweit bekannt...nur bzgl. des UPGRADING Dokuments: These instructions are for people upgrading OTRS from 2.1 to 2.2. Aber im Prinzip könnte man doch nach dieser Reihenfolge vorgehen: backup.pl /OTRS_HOME/ mit otrs-2.2.3.tar.gz überschreiben/ersetzen restore.pl oder? Nein, so geht das nicht. Wenn Sie restore.pl ausführen, überschreiben Sie Ihr Update in diesem Moment wieder... Ich kenne leider Ihre Installation nicht genau, aber in der Regel würde ich so vorgehen: 1.) Stoppen Sie die Datenbank, Cron und den Webserver. Sichern Sie die Datenbank und das OTRS_Home Verzeichnis. 2.) Löschen Sie das OTRS_Home Verzeichnis. 3.) Entpacken Sie die neue OTRS Version nach OTRS_Home. 4.) Kopieren Sie alle Konfigurationsdateien von der Sicherung in das neue OTRS. (Kernel/Config.pm und Kernel/Config/Files/ZZZAuto.pm) 5.) Übernehmen Sie das gesamte var/ Verzeichnis aus dem Backup in das neue System. 6.) Führen Sie das Script bin/SetPermission.sh aus. 7.) Reinstallieren Sie alle Installierten opm Pakete. 8.) Starten Sie die Dienste wieder. ((enjoy)) -- Stefan Rother Support Director ((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/ Virus checked by G DATA AntiVirusKit Version: AVKA 17.445 from 08.10.2007 Virus news: www.antiviruslab.com ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org
Re: AW: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux
Hallo Herr Schojohann, Ich wusste nicht, dass das auch mit dem Kundenportal funktioniert, ich dachte da gäbe es nur einen Theme. Kannst du das bitte etwas genauer erklären? Es gibt hierzu einen Artikel in unserem Admin Handbuch unter: http://doc.otrs.org/2.2/de/html/c1899.html ((enjoy) -- Stefan Rother Support Director ((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/
AW: AW: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux
Ja das kenne ich ja auch alles, einen Theme für die Agenten habe ich ja auch schon erstellt usw. aber für das Kundenportal funktioniert das eben nicht...bzw. wo kann man denn Themes fürs Kundenportal auswählen? In der Sysconfig hatte ich einen Punkt gefunden unter dem man einen Default-Theme auswählen kann, da hab ich dann meinen custom theme eingetragen doch das Kundenportal hatte den Default grünen Look. Naja ich hab jetzt einfach die entsprechenden Files ersetzt und habe wieder mein Custom Portal. Vielen Dank trotzdem, matthias -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Auftrag von Stefan Rother Gesendet: Dienstag, 9. Oktober 2007 15:46 An: User questions and discussions about OTRS.org in German Betreff: Re: AW: AW: [otrs-de] Ein sauberes OTRS Backup unter Linux Hallo Herr Schojohann, Ich wusste nicht, dass das auch mit dem Kundenportal funktioniert, ich dachte da gäbe es nur einen Theme. Kannst du das bitte etwas genauer erklären? Es gibt hierzu einen Artikel in unserem Admin Handbuch unter: http://doc.otrs.org/2.2/de/html/c1899.html ((enjoy) -- Stefan Rother Support Director ((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/ Virus checked by G DATA AntiVirusKit Version: AVKA 17.445 from 08.10.2007 Virus news: www.antiviruslab.com ___ OTRS-de Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/
[otrs] backup on server 2003
Dear list, I am running OTRS on a Windows Server 2003 machine and want to make a backup on my windows machine. I have been thinking about making a batch file which executes perl and calls the /scripts/backup.pl. But isn't there an easier way to backup OTRS?? Thanks, Peter ___ 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/
Re: [otrs] backup on server 2003
Peter Hoogkamer wrote: I am running OTRS on a Windows Server 2003 machine and want to make a backup on my windows machine. I have been thinking about making a batch file which executes perl and calls the /scripts/backup.pl. But isn't there an easier way to backup OTRS?? What's not easy about that? Nils Breunese. PGP.sig Description: Dit deel van het bericht is digitaal ondertekend ___ 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/
Re: [otrs] backup on server 2003
Hello Nils, Maybe there could be a build in windows backup script of which I am not aware of. That's why. Peter 2007/8/22, Nils Breunese (Lemonbit) [EMAIL PROTECTED]: Peter Hoogkamer wrote: I am running OTRS on a Windows Server 2003 machine and want to make a backup on my windows machine. I have been thinking about making a batch file which executes perl and calls the /scripts/backup.pl. But isn't there an easier way to backup OTRS?? What's not easy about that? Nils Breunese. ___ 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/ ___ 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/
Re: [otrs] backup on server 2003
Peter Hoogkamer wrote: Maybe there could be a build in windows backup script of which I am not aware of. That's why. I don't understand what you mean. But we don't run Windows servers, so maybe that's why. Nils Breunese. PGP.sig Description: Dit deel van het bericht is digitaal ondertekend ___ 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/
Re: [otrs] backup on server 2003
Hello Nils, We run Linux servers as well as Windows servers. But we installed on Windows. There could be commands in the backup.pl used from linux that are available on Windows. So that's why I asked. But I'll figure it out. Peter 2007/8/22, Nils Breunese (Lemonbit) [EMAIL PROTECTED]: Peter Hoogkamer wrote: Maybe there could be a build in windows backup script of which I am not aware of. That's why. I don't understand what you mean. But we don't run Windows servers, so maybe that's why. Nils Breunese. ___ 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/ ___ 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/
Re: [otrs] backup on server 2003
Peter Hoogkamer wrote: We run Linux servers as well as Windows servers. But we installed on Windows. There could be commands in the backup.pl used from linux that are available on Windows. So that's why I asked. But I'll figure it out. Ah ok, so you're saying backup.pl is not working by default under Windows? I wouldn't know, we use a different backup solution: we just dump all databases daily and rsync the complete filesystems off to a remote machine running BackupPC. Nils Breunese. PGP.sig Description: Dit deel van het bericht is digitaal ondertekend ___ 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/
Re: [otrs] backup on server 2003
Hello Nils, Here is what I thought. When I run backup.pl under Windows it cannot find which and that's a typical linux command for finding something in the linux system. Windows does not understand this. Oke, different solution then. Peter 2007/8/22, Nils Breunese (Lemonbit) [EMAIL PROTECTED]: Peter Hoogkamer wrote: We run Linux servers as well as Windows servers. But we installed on Windows. There could be commands in the backup.pl used from linux that are available on Windows. So that's why I asked. But I'll figure it out. Ah ok, so you're saying backup.pl is not working by default under Windows? I wouldn't know, we use a different backup solution: we just dump all databases daily and rsync the complete filesystems off to a remote machine running BackupPC. Nils Breunese. ___ 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/ ___ 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/
Re: [otrs] backup on server 2003
Peter Hoogkamer wrote: Here is what I thought. When I run backup.pl under Windows it cannot find which and that's a typical linux command for finding something in the linux system. Windows does not understand this. Oke, different solution then. Ok yeah, then backup.pl won't work under Windows. I recommend backing up your servers anyways, so OTRS would just be backed up with the rest of the machine. Nils Breunese. PGP.sig Description: Dit deel van het bericht is digitaal ondertekend ___ 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/
RE: [otrs] backup on server 2003
Here's what you need to do in order to get backup.pl running on windows. First, install cygwin unix tools for windows. Second, I created a batch file to run the backup.pl... Here's what the batchfile looks like -- set path=%path%;c:\otrs\mysql\bin; cd otrs perl scripts\mybackup.pl -d \\backupserver\backupdata\otrs cd .. I named mine OTRS_Backup.bat and put it in the otrs directory with the other start/stop batch files. I run it with c:\otrs as my current directory. Note that it changes to the c:\otrs\otrs directory in order for the tar commands in the backup.pl to work right. This backs up the mysql data to another machine along with the config data. I only get one error that I haven't been able to resolve yet.. tar: Kernel/Config/GenericAgen*.pm: Cannot stat: No such file or directory Not sure why that's failing, but I'm getting the Application data and the mysql data backed up regularly. Good Luck -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nils Breunese (Lemonbit) Sent: Wednesday, August 22, 2007 9:28 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] backup on server 2003 Peter Hoogkamer wrote: Here is what I thought. When I run backup.pl under Windows it cannot find which and that's a typical linux command for finding something in the linux system. Windows does not understand this. Oke, different solution then. Ok yeah, then backup.pl won't work under Windows. I recommend backing up your servers anyways, so OTRS would just be backed up with the rest of the machine. Nils Breunese. ___ 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/
Re: [otrs] backup on server 2003
Hello Ron, Thanks for the information. I was looking for this. It is a simple implementation. Did you customize the backup.pl file since I see mybackup.pl?? Could you're mistake be here: Kernel/Config/GenericAgen*.pm should be: Kernel/Config/GenericAgen[t]*.pm So a t behind the GenericAgen Peter 2007/8/22, Ron DeFulio [EMAIL PROTECTED]: Here's what you need to do in order to get backup.pl running on windows. First, install cygwin unix tools for windows. Second, I created a batch file to run the backup.pl... Here's what the batchfile looks like -- set path=%path%;c:\otrs\mysql\bin; cd otrs perl scripts\mybackup.pl -d \\backupserver\backupdata\otrs cd .. I named mine OTRS_Backup.bat and put it in the otrs directory with the other start/stop batch files. I run it with c:\otrs as my current directory. Note that it changes to the c:\otrs\otrs directory in order for the tar commands in the backup.pl to work right. This backs up the mysql data to another machine along with the config data. I only get one error that I haven't been able to resolve yet.. tar: Kernel/Config/GenericAgen*.pm: Cannot stat: No such file or directory Not sure why that's failing, but I'm getting the Application data and the mysql data backed up regularly. Good Luck -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nils Breunese (Lemonbit) Sent: Wednesday, August 22, 2007 9:28 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] backup on server 2003 Peter Hoogkamer wrote: Here is what I thought. When I run backup.pl under Windows it cannot find which and that's a typical linux command for finding something in the linux system. Windows does not understand this. Oke, different solution then. Ok yeah, then backup.pl won't work under Windows. I recommend backing up your servers anyways, so OTRS would just be backed up with the rest of the machine. Nils Breunese. ___ 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/ ___ 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/
RE: [otrs] backup on server 2003
Peter,
Oh you are right, I did tweak the backup script.
Here's the old code --
# backup application
if ($FullBackup) {
print Backup $Directory/Application.tar.gz ... ;
if (!system(cd $Home tar -czf $Directory/Application.tar.gz .)) {
print done\n;
}
else {
print failed\n;
}
}
And here's the new code --
# backup application
if ($FullBackup) {
print Backup $Directory/Application.tar.gz ... ;
if (!system(tar -czf $Directory/Application.tar.gz $Home/.)) {
print done\n;
}
else {
print failed\n;
}
}
Your suggestion got me taking a closer look at what was going on with the
genericagent backup..
It appears that the genericagent files I need to backup are in kernel/system
not kernel/config ... See below.
[c:\otrs\otrs]dir *genericagent* /s/b/a
C:\otrs\otrs\bin\GenericAgent.pl
C:\otrs\otrs\Kernel\Config\GenericAgent.pm.dist (this wont
match *.pm since its .dist)
C:\otrs\otrs\Kernel\Config\GenericAgent.pm.examples (this wont
match *.pm since its .examples)
C:\otrs\otrs\Kernel\Modules\AdminGenericAgent.pm
C:\otrs\otrs\Kernel\Output\HTML\otter\AdminGenericAgent.dtl
C:\otrs\otrs\Kernel\Output\HTML\Standard\AdminGenericAgent.dtl
C:\otrs\otrs\Kernel\System\GenericAgent (this appears to contain my
agents)
C:\otrs\otrs\Kernel\System\GenericAgent.pm
C:\otrs\otrs\scripts\test\GenericAgent.t
So here's my additional changes --
Before --
# backup Kernel/Config.pm
print Backup $Directory/Config.tar.gz ... ;
if (!system(cd $Home tar -czf $Directory/Config.tar.gz Kernel/Config.pm
Kernel/Config/Files/ZZZA*.pm Kernel/Config/GenericAgen*.pm)) {
print done\n;
}
else {
print failed\n;
}
After --
# backup Kernel/Config.pm
print Backup $Directory/Config.tar.gz ... ;
if (!system(tar -czf $Directory/Config.tar.gz $Home/Kernel/Config.pm
$Home/Kernel/Config/Files/ZZZA*.pm $Home/Kernel/System/GenericAgent*)) {
print done\n;
}
else {
print failed\n;
}
This seems to work now. Thanks for prodding me to fix this :)
I'm not sure why the script doesn't just backup up the entire OTRS/Kernel
folder. I might change this later to do so.
Ron
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Peter Hoogkamer
Sent: Wednesday, August 22, 2007 10:24 AM
To: User questions and discussions about OTRS.org
Subject: Re: [otrs] backup on server 2003
Hello Ron,
Thanks for the information. I was looking for this. It is a simple
implementation.
Did you customize the backup.pl file since I see mybackup.pl??
Could you're mistake be here:
Kernel/Config/GenericAgen*.pm
should be:
Kernel/Config/GenericAgen[t]*.pm
So a t behind the GenericAgen
Peter
2007/8/22, Ron DeFulio [EMAIL PROTECTED]:
Here's what you need to do in order to get backup.pl running on windows.
First, install cygwin unix tools for windows.
Second, I created a batch file to run the backup.pl... Here's what the
batchfile looks like --
set path=%path%;c:\otrs\mysql\bin;
cd otrs
perl scripts\mybackup.pl -d \\backupserver\backupdata\otrs cd ..
I named mine OTRS_Backup.bat and put it in the otrs directory with the
other start/stop batch files. I run it with c:\otrs as my current
directory.
Note that it changes to the c:\otrs\otrs directory in order for the
tar commands in the backup.pl to work right.
This backs up the mysql data to another machine along with the config
data.
I only get one error that I haven't been able to resolve yet.. tar:
Kernel/Config/GenericAgen*.pm: Cannot stat: No such file or directory
Not sure why that's failing, but I'm getting the Application data and
the mysql data backed up regularly.
Good Luck
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Nils Breunese (Lemonbit)
Sent: Wednesday, August 22, 2007 9:28 AM
To: User questions and discussions about OTRS.org
Subject: Re: [otrs] backup on server 2003
Peter Hoogkamer wrote:
Here is what I thought. When I run backup.pl under Windows it cannot
find which and that's a typical linux command for finding
something in the linux system. Windows does not understand this.
Oke, different solution then.
Ok yeah, then backup.pl won't work under Windows. I recommend backing
up your servers anyways, so OTRS would just be backed up with the rest
of the machine.
Nils Breunese.
___
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/
___
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
[otrs] Backup script fails under Windows - solution
the backup script fails under Windows because it relies on 'which' and 'cp', neither of which are provided by Windows. Solution: install cygwin. Then, add the \cygwin\bin folder to your PATH environment variables. Also add \otrs\mysql\bin to the PATH so that the mysqldump command can be found. cheers Stewart __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ 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 orr consulting for your OTRS system? = http://www.otrs.com/
FW: [otrs] Backup and restore OTRS on windows 2003
Hi, Im still waiting for a response to this question. Thanks, David From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Young Sent: Tuesday, September 26, 2006 8:24 AM To: otrs@otrs.org Subject: [otrs] Backup and restore OTRS on windows 2003 Hi, I need to move (migrate) OTRS and database to a new server and did not see any documentation for this processfor windows server. Any help would be greatly appreciated. Thank You, David Young ___ 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 orr consulting for your OTRS system? = http://www.otrs.com/___ 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 orr consulting for your OTRS system? = http://www.otrs.com/
RE: [otrs] Backup and restore OTRS on windows 2003
Take a look at the mysql documentation, how to backup and restore (mysqldump) the (otrs) database. I moved OTRS before as: - backup the original OTRS database - install OTRS on the new server - rename the installed OTRS database - create an empty database (OTRS) - restore the backuped data (.sql file) in de OTRS database For backup, moving, rename, you can use a good MySQL tool like Navicat or SQLGate (30-day full function trials available!) It worked for me (on Linux, but Im pretty sure it will work on Windows as well) Regards, Peter Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens David Young Verzonden: maandag 2 oktober 2006 21:02 Aan: otrs@otrs.org Onderwerp: FW: [otrs] Backup and restore OTRS on windows 2003 Hi, Im still waiting for a response to this question. Thanks, David From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Young Sent: Tuesday, September 26, 2006 8:24 AM To: otrs@otrs.org Subject: [otrs] Backup and restore OTRS on windows 2003 Hi, I need to move (migrate) OTRS and database to a new server and did not see any documentation for this processfor windows server. Any help would be greatly appreciated. Thank You, David Young ___ 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 orr consulting for your OTRS system? = http://www.otrs.com/
[otrs] Backup and restore OTRS on windows 2003
Hi, I need to move (migrate) OTRS and database to a new server and did not see any documentation for this processfor windows server. Any help would be greatly appreciated. Thank You, David Young___ 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 orr consulting for your OTRS system? = http://www.otrs.com/
RE: [otrs] Backup
Can some please advise me, I need to do backup on the system and I do not know how or where to start. I tried using the OTRS backup, the backup.pl but it does not work please help me Thanks -Original Message- From: Mamakwa M. Sefiri Sent: 19 May 2006 08:46 AM To: User questions and discussions about OTRS.org Subject: RE: [otrs] Backup Yes I did -Original Message- From: Richard Hinkamp - BeSite [mailto:[EMAIL PROTECTED] Sent: 19 May 2006 08:12 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] Backup So did you create /backup? (not /opt/otrs/scripts/backup!) Richard Mamakwa M. Sefiri wrote: I am running otrs on SUSE Linux. ___ 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 oder Consulting für Ihr OTRS System? = http://www.otrs.de/ ___ 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 oder Consulting für Ihr OTRS System? =http://www.otrs.de/ ___ 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 orr consulting for your OTRS system? = http://www.otrs.com/
Re: [otrs] Backup
Hi Please tell us how you execute the script. Before execute the script you must create a backup directory and it should specify on the script regards -- ___ Bipin Das Linux Administrator, Spectrum Softtech Solutions, Mahakavi G Road,Cochin-682011. Phone 0484 4082000. ___ 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 orr consulting for your OTRS system? = http://www.otrs.com/
RE: [otrs] Backup
I am running otrs on SUSE Linux. -Original Message- From: Jurgen de Wijs [mailto:[EMAIL PROTECTED] Sent: 18 May 2006 09:10 PM To: User questions and discussions about OTRS.org Subject: Re: [otrs] Backup Mamakwa M. Sefiri schreef: I have create a folder /backup under opt/otrs/sripts and it still gives me the error. Are you running OTRS on a Debian system by any chance? There is an error in the backup script as it is shipped with the Debian package. If you run Debian let me know. I can explain how to fix it. Regards, Jurgen de Wijs ___ 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 oder Consulting für Ihr OTRS System? = http://www.otrs.de/ ___ 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 oder Consulting für Ihr OTRS System? = http://www.otrs.de/
Re: [otrs] Backup
So did you create /backup? (not /opt/otrs/scripts/backup!) Richard Mamakwa M. Sefiri wrote: I am running otrs on SUSE Linux. ___ 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 oder Consulting für Ihr OTRS System? = http://www.otrs.de/
RE: [otrs] Backup
Yes I did -Original Message- From: Richard Hinkamp - BeSite [mailto:[EMAIL PROTECTED] Sent: 19 May 2006 08:12 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] Backup So did you create /backup? (not /opt/otrs/scripts/backup!) Richard Mamakwa M. Sefiri wrote: I am running otrs on SUSE Linux. ___ 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 oder Consulting für Ihr OTRS System? = http://www.otrs.de/ ___ 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 oder Consulting für Ihr OTRS System? = http://www.otrs.de/
[otrs] Backup
I am want to do backups the system everyday I read the manual on how to back and when I run this command line ./backup.pl -d /backup/ I get an error directory:/backup Thanks Mamakwa ___ 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 oder Consulting für Ihr OTRS System? = http://www.otrs.de/
Re: [otrs] Backup
Mamakwa M. Sefiri wrote: I am want to do backups the system everyday I read the manual on how to back and when I run this command line ./backup.pl -d /backup/ I get an error directory:/backup Did you create /backup? I guess not. Nils Breunese. ___ 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 oder Consulting für Ihr OTRS System? = http://www.otrs.de/
RE: [otrs] Backup
I have create a folder /backup under opt/otrs/sripts and it still gives me the error. -Original Message- From: Nils Breunese (Lemonbit Internet) [mailto:[EMAIL PROTECTED] Sent: 18 May 2006 11:29 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] Backup Mamakwa M. Sefiri wrote: I am want to do backups the system everyday I read the manual on how to back and when I run this command line ./backup.pl -d /backup/ I get an error directory:/backup Did you create /backup? I guess not. Nils Breunese. ___ 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 oder Consulting für Ihr OTRS System? = http://www.otrs.de/ ___ 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 oder Consulting für Ihr OTRS System? = http://www.otrs.de/
Re: [otrs] Backup
Dear Mamakwa, Thursday, May 18, 2006, 4:42:39 PM, you wrote: I have create a folder /backup under opt/otrs/sripts and it still gives me the error. -Original Message- From: Nils Breunese (Lemonbit Internet) [mailto:[EMAIL PROTECTED] Sent: 18 May 2006 11:29 AM To: User questions and discussions about OTRS.org Subject: Re: [otrs] Backup Mamakwa M. Sefiri wrote: I am want to do backups the system everyday I read the manual on how to back and when I run this command line ./backup.pl -d /backup/ I get an error directory:/backup Did you create /backup? I guess not. Probably you need to write perl backup.pl -d /backup/ -- Best regards, Alexander ___ 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 oder Consulting für Ihr OTRS System? = http://www.otrs.de/
Re: [otrs] Backup
Op 18-mei-2006, om 14:42 heeft Mamakwa M. Sefiri het volgende geschreven: I have create a folder /backup under opt/otrs/sripts and it still gives me the error. /backup is a folder under /, not under /opt/otrs/scripts, so what you're trying won't work. Where to you want to backup to? To /backup or /opt/otrs/scripts/backup (or maybe somewhere else)? Maybe you need to familiarize yourself with the difference between absolute and relative paths. Nils Breunese. ___ 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 oder Consulting für Ihr OTRS System? = http://www.otrs.de/
Re: [otrs] Backup
Mamakwa M. Sefiri schreef: I have create a folder /backup under opt/otrs/sripts and it still gives me the error. Are you running OTRS on a Debian system by any chance? There is an error in the backup script as it is shipped with the Debian package. If you run Debian let me know. I can explain how to fix it. Regards, Jurgen de Wijs ___ 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 oder Consulting für Ihr OTRS System? = http://www.otrs.de/
Re: [otrs] Backup on Windows
Saturday, February 18, 2006, 7:06:35 PM, you wrote: K Hi, this might seem a bit naive, but we work with OTRS 2.0.4 on a Win2003 Server. We K have a different win2003 server as our DC and IIS. I have 2 queries, any help would K be greatly appriciated K 1. How do we backup / restore OTRS on windows. I need to backup all tickets, and K also the configuration settings K 2. Has anyone tried using OTRS on a box that also runs IIS. K Thanks in anticipation K Ashutosh hello, a Mysql dump will save 99% of configuration and all tickets. Otrs web site can be backup as flat files The IIS configuration should also be backup (trough the systemstate if your backup solution is able to) Mathieu CHATEAU ___ 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 oder Consulting für Ihr OTRS System? = http://www.otrs.de/
[otrs] Backup on Windows
Hi, this might seem a bit naive, but we work with OTRS 2.0.4 on a Win2003 Server. We have a different win2003 server as our DC and IIS. I have 2 queries, any help would be greatly appriciated 1. How do we backup / restore OTRS on windows. I need to backup all tickets, and also the configuration settings 2. Has anyone tried using OTRS on a box that also runs IIS. Thanks in anticipation Ashutosh *** PAIN IS TEMPORARY, PRIDE FOREVER !! __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ 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 oder Consulting für Ihr OTRS System? = http://www.otrs.de/
[otrs] backup script not working
Hi All , When I try and run the backup.sh (2.0 manual still refers to it as backup.pl btw) script I get the following error: ./backup.sh -j -b /opt/otrs/bin -c /opt/otrs/Kernel/Config/ -d /backup backup.sh - a backup script for OTRS $Revision: 1.10 $ mkdir: cannot create directory `/backup/2005-10-03_16-38': No such file or directory Did create the backup dir with otrs as user. Not being a scripting guru or anything , didn't wanto to go fiddle in the actual script.Do u need to be logged in as otrs?Can I 'touch' a file and pint the script to that? TIA -- Regards , Danie Theron Systems Administrator Verpakt Management Services email : [EMAIL PROTECTED] tel: +2711 6020117 If you dislike change, you're going to dislike being irrelevant even more. Experience is a wonderful thing. It enables you to recognise a mistake when you make it again. -- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. -- ___ 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 oder Consulting für Ihr OTRS System? = http://www.otrs.de/
[otrs] backup
How do we take regular backup for this system In case the machine with the system crashes, is there a way we can use the backedup database and restore the system Ashutosh *** PAIN IS TEMPORARY, PRIDE FOREVER !! __ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com ___ 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 oder Consulting für Ihr OTRS System? = http://www.otrs.de/
RE: [otrs] backup
Title: RE: [otrs] backup From your previous forum post it looks like you are using Windows with OTRS and possibly Apache or IIS. A lot of this really depends on what database back end you have chosen or had chosen for you. Most likely MySQL from what I remember of the Windows package. What you will need to do is to back-up the MySQL database periodically using mysqlhotcopy or mysqldump (whichever seems more appropriate to your needs) to a folder that you can back up, documentation on this can be found on the MySQL website. These tools should be scriptable through batch language or _vbscript_ and subsequently run as a Windows Scheduled Task. You should then be able to use NTBackup.exe to selectively backup the directory structures you want, including the IIS or Apache. I would also recommend backing up the system state, a full system backup probably isn't required in this instance. I hope this is what you are after. Thanks, Brad West Network/Systems Engineer Spang Company [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Karkhanis Sent: Tuesday, September 13, 2005 10:47 AM To: User questions and discussions about OTRS.org Subject: [otrs] backup How do we take regular backup for this system In case the machine with the system crashes, is there a way we can use the backedup database and restore the system Ashutosh *** PAIN IS TEMPORARY, PRIDE FOREVER !! __ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com ___ 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 oder Consulting für Ihr OTRS System? = http://www.otrs.de/ ___ 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 oder Consulting für Ihr OTRS System? = http://www.otrs.de/
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
[otrs] Backup Procedure
Can anyone share a backup procedure for OTRS using MySQL on SUSE Linux 8.1? I keep putting it off and we're too far into using it now to have anything bad occur. :( ___ 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 Procedure
Hi Charles, On Tue, Jul 29, Charles R. Rusty Thompson wrote: Can anyone share a backup procedure for OTRS using MySQL on SUSE Linux 8.1? I keep putting it off and we're too far into using it now to have anything bad occur. :( You can use the MySQL documentation for the database backup. Have a look at http://www.mysql.com/doc/en/Backup.html To backup the OTRS config files is easy. Just use tar. take care Stefan -- Stefan Wintermeyer I love this planet. I've got wealth, fame, and access to the depths of sleaze that those things bring. (Bender) Futurama ___ 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 Procedure
OTRS also comes with a nicely prepackaged backup script: ~otrs/scripts/backup.sh This worked great on my Redhat 8 box. -Original Message- From: Stefan Wintermeyer [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 1:44 PM To: [EMAIL PROTECTED] Subject: Re: [otrs] Backup Procedure Hi Charles, On Tue, Jul 29, Charles R. Rusty Thompson wrote: Can anyone share a backup procedure for OTRS using MySQL on SUSE Linux 8.1? I keep putting it off and we're too far into using it now to have anything bad occur. :( You can use the MySQL documentation for the database backup. Have a look at http://www.mysql.com/doc/en/Backup.html To backup the OTRS config files is easy. Just use tar. take care Stefan -- Stefan Wintermeyer I love this planet. I've got wealth, fame, and access to the depths of sleaze that those things bring. (Bender) Futurama ___ 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
