[otrs] Chinese characters displayed as garbage

[Arlene Wu]

Hi,

I have some tickets from our clients, which are in Chinese. I guess they 
are using GB2312 encoding or something like that. In both notification 
email and zoom view of OTRS, those contents are always displayed as 
garbage no matter what encoding is applied. But I can view them by 
opening the HTML-Attachment.


Is that a bug of OTRS, or any setting for this?

Thanks a lot,
Arlene
-
OTRS 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] Auto response with Customer Username & Password

[Amanpreet Singh]

hi to all,

i am new to Otrs , using Otrs 2.2 on a Debian system,
my auto response to customer working fine,
but i want to send him the Username & Password along with URL(customer.pl)
so that customer can check the status of ticket.

how should i pass these fields to customer in auto response.
Plz  help.
thanks

-- 
regards:
Amanpreet Singh
-
OTRS 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

[Maurice James]

Do you know if the backup script has a size limit or a timeout setting? I
did gzip -cd DatabaseBackup.sql.gz | grep 'CREATE TABLE' on my failed
restore and it only displayed 4 tables article, article_attachment,
article_plain, article_flag

 

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

# 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

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

# 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

[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] Change queue without being owner

[Javier Barroso]

On Fri, May 1, 2009 at 2:47 PM, Lars Jørgensen  wrote:
> Den 24/02/2009 kl. 14.09 skrev Javier Barroso:
>
> Response to [1] (I can't reply from gmail :( now )
> Ticket::Frontend::MoveSetState:  did the trick
>
> [1] http://lists.otrs.org/pipermail/otrs/2009-January/025447.html
> 
>
> I tried changing it, but I'm still not able to move tickets I don't own.

This option is for not taking owner the ticket when you are changing
it from a queue to another. (Or at least I think so)

Regards,
-
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/

Re: [otrs] Backup/Restore

[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

[Frans Stekelenburg]

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/

Re: [otrs] Backup/Restore

[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

[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('');

5.   Recreate otrs database

mysql> create database otrs;

6.   Perform restore

linux> /opt/otrs/scripts/restore.pl -b  -d /opt/otrs
Where  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] Installation Error in Ubuntu 9.04

[Ravi Kumar]

Please help me...
:( :(

On Mon, May 4, 2009 at 10:25 AM,  wrote:

> Hi
>
> I tried to install otrs2 in ubuntu
> I got below error msg, Please help me
>
> r...@serveross:/home/ravi# apt-get install otrs2
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> otrs2 is already the newest version.
> The following packages were automatically installed and are no longer
> required:
> pwgen mythtv-common mobile-broadband-provider-info gnome-themes-selected
> tango-icon-theme python-pkg-resources odt2txt python-rdflib
> Use 'apt-get autoremove' to remove them.
> 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
> 1 not fully installed or removed.
> After this operation, 0B of additional disk space will be used.
> Setting up otrs2 (2.3.2-2) ...
> dbconfig-common: writing config to /etc/dbconfig-common/otrs2.conf
> *** WARNING: ucf was run from a maintainer script that uses debconf, but
> the script did not pass --debconf-ok to ucf. The maintainer
> script should be fixed to not stop debconf before calling ucf,
> and pass it this parameter. For now, ucf will revert to using
> old-style, non-debconf prompting. Ugh!
>
> Please inform the package maintainer about this problem.
> Replacing config file /etc/otrs/database.pm with new version
> granting access to database otrs2 for o...@localhost: already exists.
> creating database otrs2: success.
> verifying database otrs2 exists: success.
> populating database via sql... done.
> dbconfig-common: flushing administrative password
> Module perl already enabled
> ERROR: Module rewrite not properly enabled:
> /etc/apache2/mods-enabled/rewrite.load is a real file, not touching it
> dpkg: error processing otrs2 (--configure):
> subprocess post-installation script returned error exit status 1
> Errors were encountered while processing:
> otrs2
> E: Sub-process /usr/bin/dpkg returned an error code (1)
> r...@serveross:/home/ravi#
>
>
>
> Thanks,
> Ravi
-
OTRS 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

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

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