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