[otrs] spam
I have setup the PostMaster Filter to send spam email to the junk queue, and it does not work. Please advise ___ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? = http://www.otrs.com/
FW: [otrs] spam
I have set the Match for Heater 1 to X-Spam-Flag: and the Value to Yes, and se the Set header 1 to X-OTRS-Queue: and value to Junk From: Mamakwa M. Sefiri Sent: 26 September 2006 12:05 PM To: User questions and discussions about OTRS.org Subject: [otrs] spam I have setup the PostMaster Filter to send spam email to the junk queue, and it does not work. Please advise ___ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? = http://www.otrs.com/___ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? = http://www.otrs.com/
[otrs] database migration
Hi all, I want to know whether it is possible to migrate an OTRS running with MySQL to Oracle. I know that I can install it with Oracle using otrs-schema-post.oracle.sql. But can I migrate an existing installation or do I have to install a new one? Thanks Jörg smime.p7s Description: S/MIME cryptographic signature ___ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? = http://www.otrs.com/
[otrs] Cron with error
Hello list! I got cron telling me many times an hour following: DBI::db=HASH(0x8c1b6c0)-disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at /usr/share/otrs/Kernel/System/DB.pm line 219, DATA line 225. What is wrong? What's happening? Thanks... -- -- Boniforti Flavio Provincia del Verbano-Cusio-Ossola Ufficio Informatica Tecnoparco del Lago Maggiore Via dell'Industria, 25 28924 Verbania -- ___ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? = http://www.otrs.com/
[otrs] Backup and restore OTRS on windows 2003
Hi, I need to move (migrate) OTRS and database to a new server and did not see any documentation for this processfor windows server. Any help would be greatly appreciated. Thank You, David Young___ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? = http://www.otrs.com/
Re: [otrs] Cron with error
Hello, On Di, Sep 26, 2006 at 10:40:30 +0200, Boniforti Flavio wrote: I got cron telling me many times an hour following: DBI::db=HASH(0x8c1b6c0)-disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at /usr/share/otrs/Kernel/System/DB.pm line 219, DATA line 225. This is a well known issue with the recent version of DBD::MySQL (version 3.0004). See also Bug#1231: http://bugs.otrs.org/show_bug.cgi?id=1231 Best regards Henning -- Henning Oschwald ((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 1862 760 :: Fax: +49 (0) 9421 1862 769 http://www.otrs.com/ :: Communication with success! pgpGEekr68NAt.pgp Description: PGP signature ___ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? = http://www.otrs.com/
[otrs] How to change sorting order for QUEUE in Customer Create Ticket Interface
Hi, I'm currently making some minor customisations to the OTRS system used in our organization. One of the current modifications I'm trying to make is in the sorting order of QUEUE (i.e. the To: string) on the Customer's Create New Ticket interface. The current sorting order is ASC, I would like to change it to DESC. I've been searching high and low and have tried changing quite a number of parameters but none of them has worked for me. Please help, thanks. Ivy Send instant messages to your online friends http://uk.messenger.yahoo.com ___ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? = http://www.otrs.com/
[otrs] Limiting Number of Tickets Listed in Customer Interface
Dear All, Our organization has just recentlyintroduced the customer interface to our customers. As the customers all have agreat numberof tickets in the database, we would like to limit the number of tickets listed to those created since they log on to the customer interface for the first time.Please advise on the probable avenues to achieve this, thanks ! Ivy Send instant messages to your online friends http://uk.messenger.yahoo.com ___ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? = http://www.otrs.com/
Re: [otrs] How to change sorting order for QUEUE in Customer Create Ticket Interface
Hi Ivy, It must be in the sql bridge (lack of a better word). In java we call that object mapping I don't know what perl calls it or what package otrs is using to do data access. Looks like perl-DBI So this option will be some where in the data access configuration. I'm am new to otrs but I find it very useful. Hope this helps, Philip On 9/26/06, Ivy Giam [EMAIL PROTECTED] wrote: Hi, I'm currently making some minor customisations to the OTRS system used in our organization. One of the current modifications I'm trying to make is in the sorting order of QUEUE (i.e. the To: string) on the Customer's Create New Ticket interface. The current sorting order is ASC, I would like to change it to DESC. I've been searching high and low and have tried changing quite a number of parameters but none of them has worked for me. Please help, thanks. Ivy Send instant messages to your online friends http://uk.messenger.yahoo.com ___ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? = http://www.otrs.com/ -- Philip Donaghy donaghy.blogspot.com del.icio.us/donaghy/philip Skype: philipmarkdonaghy Office: +33 5 56 60 88 02 Mobile: +33 6 20 83 22 62 ___ OTRS 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] How to change sorting order for QUEUE in Customer Create Ticket Interface
Hi Philip,I understand it should be somewhere in the data access config, but I'm afraid I need very specific module or pm file where I need to make the change.IvyPhilip Mark Donaghy [EMAIL PROTECTED] wrote: Hi Ivy,It must be in the sql bridge (lack of a better word). In java we callthat object mapping I don't know what perl calls it or what packageotrs is using to do data access. Looks like perl-DBISo this option will be some where in the data access configuration.I'm am new to otrs but I find it very useful. Hope this helps,PhilipOn 9/26/06, Ivy Giam <[EMAIL PROTECTED]>wrote: Hi, I'm currently making some minor customisations to the OTRS system used in our organization. One of the current modifications I'm trying to make is in the sorting order of QUEUE (i.e. the To: string) on the Customer's Create New Ticket interface. The current sorting order is ASC, I would like to change it to DESC. I've been searching high and low and have tried changing quite a number of parameters but none of them has worked for me. Please help, thanks. Ivy Send instant messages to your online friends http://uk.messenger.yahoo.com ___ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? = http://www.otrs.com/-- Philip Donaghydonaghy.blogspot.com del.icio.us/donaghy/philipSkype: philipmarkdonaghyOffice: +33 5 56 60 88 02Mobile: +33 6 20 83 22 62___OTRS mailing list: otrs - Webpage: http://otrs.org/Archive: http://lists.otrs.org/pipermail/otrsTo unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrsSupport orr consulting for your OTRS system?= http://www.otrs.com/ Send instant messages to your online friends http://uk.messenger.yahoo.com ___ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? = http://www.otrs.com/
[otrs] faqs
I have looked everywhere and Im having a hard time figuring out where to build the faqs. Im a newbie and Im sorry to bug the group. Joey Horne Salisbury.Net / Internet America 704-638- [EMAIL PROTECTED] ___ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? = http://www.otrs.com/
[otrs] Updating ticket from email
Hello all, Does anyone know how to update a ticket from an email. That is, if a user send an email to OTRS, the system checks to see if that ticket is an existing ticket, if so, add the email to the ticket as part of the history (and maybe send a notification to owner of the ticket). Regards,Robert Bui ___ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? = http://www.otrs.com/
[otrs-de] Markus Hebauf ist außer Haus.
Ich werde ab 26.09.2006 nicht im Büro sein. Ich kehre zurück am 02.10.2006. I will be out of the office starting 26.09.2006 and will not return until 02.10.2006. Bitte wenden Sie sich in dringenden Fällen an meinen Vertreter, Herrn Amin Abu-Es-Soud (-360) In dringenden Fällen wenden Sie sich bitte an / In urgent cases, please contact: Amin Abu Es Soud, Tel.: 069/27117-360, E-Mail: [EMAIL PROTECTED] # Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail (inklusive aller Anhänge). Bitte fertigen Sie keine Kopien an oder bringen den Inhalt anderen Personen zur Kenntnis. E-Mails sind anfällig für Datenverfälschungen, können abgefangen werden und Computerviren verbreiten. Außer für Vorsatz und grobe Fahrlässigkeit lehnen wir jede Verantwortung für derartige Vorgänge ab. This e-mail is confidential and may contain legally privileged information. If you have received it by mistake, please inform us by reply e-mail and then delete it (including any attachments) from your system. You should not copy it or in any other way disclose its content to anyone. E-mail is susceptible to data corruption, interception, unauthorised amendment, tampering and virus infection. We do not accept liability for such actions or the consequences thereof. # ___ OTRS Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/
[otrs-de] sync-ldap2db.pl um die ADS Daten aus Windows 2000 per ldap ins OTRS zu importieren
Hallo.
Wir sind nun kurz vor OTRS 2.1 Produktivstart und ich sitze noch an einer
harten Nuss.
Kennt sich jemand mit dem script aus sync-ldap2db.pl um die ADS Daten aus
Windows 2000 per ldap ins OTRS zu importieren ?
Wenn ich linuxseitig folgendes aufrufe :
ldapsearch -d 255 -h 172.18.5.1 -W -b
ou=langenfeld,dc=msnet,dc=strauss1902,dc=de -D
cn=schulze,ou=verwaltung,ou=langenfeld,dc=msnet,dc=strauss1902,dc=de -x
klappt die LDAP Anbindung wunderbar, aber über das Script passiert nix. Dieses
wurde angepasst und sieht wie folgt aus :
--
#!/usr/bin/perl -w
# --
# scripts/tools/sync-ldap2db.pl - sync a ldap directory to database # Copyright
(C) 2001-2005 Martin Edenhofer [EMAIL PROTECTED] # -- # $Id:
sync-ldap2db.pl,v 1.1 2005/03/05 07:53:31 martin Exp $ # -- # This program is
free software; you can redistribute it and/or modify # it under the terms of
the GNU General Public License as published by # the Free Software Foundation;
either version 2 of the License, or # (at your option) any later version.
#
# This program is distributed in the hope that it will be useful, # but WITHOUT
ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS
FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more
details.
#
# You should have received a copy of the GNU General Public License # along
with this program; if not, write to the Free Software # Foundation, Inc., 59
Temple Place, Suite 330, Boston, MA 02111-1307 USA # --
# use ../ as lib location
use File::Basename;
use FindBin qw($RealBin);
use lib dirname($RealBin). /../;
use lib dirname($RealBin)./../Kernel/cpan-lib;
use strict;
use vars qw($VERSION);
$VERSION = '$Revision: 1.1 $';
$VERSION =~ s/^\$.*:\W(.*)\W.+?$/$1/;
use Net::LDAP;
use Kernel::Config;
use Kernel::System::Log;
use Kernel::System::DB;
use Kernel::System::Encode;
# --
# create common objects
# --
my %CommonObject = ();
$CommonObject{ConfigObject} = Kernel::Config-new(); $CommonObject{LogObject} =
Kernel::System::Log-new(
LogPrefix = 'OTRS-sync-ldap2db',
%CommonObject,
);
$CommonObject{EncodeObject} = Kernel::System::Encode-new(
%CommonObject,
);
$CommonObject{DBObject} = Kernel::System::DB-new(
%CommonObject,
);
my $UidLDAP = 'uid';
my $UidDB = 'login';
my %Map = (
# db = ldap
email = 'mail',
customer_id = 'mail',
first_name = 'sn',
last_name = 'givenname',
pw = 'test',
#comments = 'description',
comments = 'postaladdress',
);
my $LDAPHost = '172.18.5.1';
my %LDAPParams = ();
my $LDAPBaseDN = 'ou=langenfeld,dc=msnet,dc=strauss1902,dc=de';
my $LDAPBindDN =
'cn=schulze,ou=verwaltung,ou=langenfeld,dc=msnet,dc=strauss1902,dc=de';
my $LDAPBindPW = 'kennwort von schulze';
my $LDAPScope = 'sub';
my $LDAPCharset = 'utf-8';
#my $LDAPFilter = '';
my $LDAPFilter = '(ObjectClass=*)';
my $DBCharset = 'iso-8859-1';
my $DBTable = 'customer_user';
# ldap connect and bind (maybe with SearchUserDN and SearchUserPw) my $LDAP =
Net::LDAP-new($LDAPHost, %LDAPParams) or die $@; if (!$LDAP-bind(dn =
$LDAPBindDN, password = $LDAPBindPW)) {
$CommonObject{LogObject}-Log(
Priority = 'error',
Message = Bind failed!,
);
exit 1;
}
# split request of all accounts
foreach (qw(0 1 2 3 4 5 6 7 8 9 a b c d e f g h i j k l m n o p q r s t u v w x
y z)) {
my $Filter = ($UidLDAP=$_*);
if ($LDAPFilter) {
$Filter = ($LDAPFilter$Filter);
}
# perform user search
my $Result = $LDAP-search(
base = $LDAPBaseDN,
scope = $LDAPScope,
filter = $Filter,
);
#print F: ($UidLDAP=$_*)\n;
foreach my $entry ($Result-all_entries) {
my $UID = $entry-get_value($UidLDAP);
if ($UID) {
# check if uid existsis in db
my $Insert = 1;
$CommonObject{DBObject}-Prepare(
SQL = SELECT $UidDB FROM $DBTable WHERE $UidDB =
'.$CommonObject{DBObject}-Quote($UID).',
Limit = 1,
);
while (my @Row = $CommonObject{DBObject}-FetchrowArray()) {
$Insert = 0;
}
my $SQLPre = '';
my $SQLPost = '';
my $Type = '';
if ($Insert) {
$Type = 'INSERT';
}
else {
$Type = 'UPDATE';
}
foreach (keys %Map) {
my $Value =
$CommonObject{DBObject}-Quote(_ConvertTo($entry-get_value($Map{$_})) || '');
if ($Type eq 'UPDATE') {
if ($SQLPre) {
$SQLPre .= , ;
}
$SQLPre .= $_ = '$Value';
}
else {
if ($SQLPre) {
$SQLPre .= , ;
}
[otrs-de] Filemaker und otrs
Wir benuetzen momentan OTRS fuer unseren support bereich. Kunden daten werden abe rin filemaker gefuehrt Heist alle unden die auch support vertrag haben muessen wir leider dopplet fuehren. Einmal in filemaker einmal in otrs Gibt es eine halbwegs vernuenftige loesung entweder A) daten von filemaker zu otrs (mysql) zu senden B) mit otrs evtl auf die filemaker datenbank zuzugreifen Danke schon mal Christian ___ OTRS Mailingliste: otrs-de - Webpage: http://otrs.org/ Archiv: http://lists.otrs.org/pipermail/otrs-de/ Listenabo verwalten: http://lists.otrs.org/cgi-bin/listinfo/otrs-de/ Support oder Consulting fuer Ihr OTRS System? = http://www.otrs.com/
