Re: [otrs] Backup and Restore pearl script - success? failure?

2013-06-10 Thread Steven Carr
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?

2013-06-10 Thread Paul Simons
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?

2013-06-10 Thread Steven Carr
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

2012-07-25 Thread Susan Dittmar
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

2012-07-24 Thread Steve Clark

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

2012-07-24 Thread Gerald Young
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

2012-07-24 Thread Adi Ariyanto
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

2012-07-24 Thread Gerald Young
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

2012-07-24 Thread Adi Ariyanto
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

2012-07-24 Thread Gerald Young
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

2012-07-24 Thread Adi Ariyanto
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

2009-10-27 Thread as as
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

2009-05-05 Thread Frans Stekelenburg
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

2009-05-05 Thread Maurício Ramos
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

2009-05-05 Thread Stefano Coletta
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

2009-05-05 Thread Stefano Coletta
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

2009-05-05 Thread Maurice James
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

2009-05-05 Thread Maurice James
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

2008-06-04 Thread Lars Jørgensen
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

2008-03-25 Thread Nils Breunese (Lemonbit)

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

2008-03-25 Thread DAVAUT Benoit
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

2008-03-25 Thread Nils Breunese (Lemonbit)

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

2008-03-25 Thread DAVAUT Benoit
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

2008-02-07 Thread swood
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

2007-11-13 Thread Andy Lubel
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

2007-11-13 Thread Swearsky, Robert
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

2007-08-22 Thread Nils Breunese (Lemonbit)

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

2007-08-22 Thread Peter Hoogkamer
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

2007-08-22 Thread Nils Breunese (Lemonbit)

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

2007-08-22 Thread Peter Hoogkamer
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

2007-08-22 Thread Nils Breunese (Lemonbit)

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

2007-08-22 Thread Peter Hoogkamer
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

2007-08-22 Thread Nils Breunese (Lemonbit)

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

2007-08-22 Thread Ron DeFulio
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

2007-08-22 Thread Peter Hoogkamer
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

2007-08-22 Thread Ron DeFulio
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

2006-10-02 Thread Peter van Beugen








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

2006-07-06 Thread Mamakwa M. Sefiri
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

2006-07-06 Thread Bipin

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

2006-05-19 Thread Mamakwa M. Sefiri
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

2006-05-19 Thread Richard Hinkamp - BeSite

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

2006-05-19 Thread Mamakwa M. Sefiri
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

2006-05-18 Thread Nils Breunese (Lemonbit Internet)

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

2006-05-18 Thread Mamakwa M. Sefiri
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

2006-05-18 Thread Alexander Kardailsky
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

2006-05-18 Thread Nils Breunese (Lemonbit Internet)
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

2006-05-18 Thread Jurgen de Wijs

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

2006-02-19 Thread Mathieu CHATEAU

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

2005-09-13 Thread West, Bradley G.
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'

2003-09-15 Thread jerome




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'

2003-09-15 Thread Robert Kehl
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'

2003-09-14 Thread Robert Kehl
- 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

2003-07-29 Thread Stefan Wintermeyer
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

2003-07-29 Thread Covert, Jake
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