Re: [otrs] cron daemon problem (OTRS 2.4.7 and ITSM 1.3.2)

29 Mar 2010

      Hi,

Do /etc/init.d/otrs restart to load your cron modifications.

Le 25/03/2010 18:06, Raul Orav a écrit :
...
Hi,
I have installed OTRS 2.4.7 and ITSM 1.3.2 on Linux Debian Vserver 
machine. Everything works very well but i have some problems 
assosiated with cron.
I think i have not enough knowledge to make something about it – maybe 
someone could help. Thank you!
Because some reasons i receive e-maisl from Cron Daemon:
Subject: Cron  test -x $HOME/bin/PostMasterPOP3.pl && 
$HOME/bin/PostMasterPOP3.pl > /dev/null
And content:
DBI connect('database=otrs;host=localhost;port=3306;','otrs',...) 
failed: Access denied for user 'otrs'@'localhost' (using password: NO) 
at /usr/share/otrs/Kernel/System/DB.pm line 203
ERROR: OTRS-PM3-10 Perl: 5.8.8 OS: linux Time: Thu Mar 25 18:50:01 2010
Message: Access denied for user 'otrs'@'localhost' (using password: NO)
Traceback (3082):
Module: Kernel::System::DB::new (v1.75.2.1) Line: 180
Module: /usr/share/otrs/bin/PostMasterPOP3.pl (v1.25) Line: 73
Got no DBObject! at /usr/share/otrs/Kernel/System/PID.pm line 69, 
<PRODUCT> line 4.
And similar e-mails with subject like „Cron  test -x 
$HOME/bin/DeleteSessionIDs.pl && $HOME/bin/DeleteSessionIDs.pl 
--expired > /dev/null“ and.... „........ test -x 
$HOME/bin/GenericAgent.pl && $HOME/bin/GenericAgent.pl -c db > /dev/null“
I have commented out cron jobs from /opt/otrs/var/cron files (i saw no 
need for them at the moment) and i have restarted Cron.sh with otrs 
user privileges, and also done with root privilegesx /etc/init.d/cron 
restart – but somehow emails doesn’t stop coming J. Also I have 
restarted this vserver (vserver otrs restart) several times – just in 
case J
*Cron infomation(down this email is modules info also):*
otrs:/opt/otrs/bin# su otrs
otrs:/opt/otrs/bin$ crontab -l
# --
# cron/aaa_base - base crontab package
# Copyright (C) 2001-2009 OTRS AG, http://otrs.org/
# --
# $Id: aaa_base.dist,v 1.7 2009/02/16 20:35:25 tr Exp $
# --
# This software comes with ABSOLUTELY NO WARRANTY. For details, see
# the enclosed file COPYING for license information (AGPL). If you
# did not receive this file, see http://www.gnu.org/licenses/agpl.txt.
# --
# Who gets the cron emails?
MAILTO="info@visioline.ee"
# --
# cron/fetchmail - fetchmail cron of the OTRS
# Copyright (C) 2001-2009 OTRS AG, http://otrs.org/
# --
# $Id: fetchmail.dist,v 1.10 2009/02/16 20:53:10 tr Exp $
# --
# This software comes with ABSOLUTELY NO WARRANTY. For details, see
# the enclosed file COPYING for license information (AGPL). If you
# did not receive this file, see http://www.gnu.org/licenses/agpl.txt.
# --
# fetch every 5 minutes emails via fetchmail
#*/5 * * * * [ -x /usr/bin/fetchmail ] && /usr/bin/fetchmail -a >> 
/dev/null
#*/5 * * * *    /usr/bin/fetchmail -a --ssl >> /var/log/otrs_fetchmail.log
# --
# cron/generic_agent - GenericAgent.pl cron of the OTRS
# Copyright (C) 2001-2009 OTRS AG, http://otrs.org/
# --
# $Id: generic_agent.dist,v 1.12 2009/02/16 20:53:10 tr Exp $
# --
# This software comes with ABSOLUTELY NO WARRANTY. For details, see
# the enclosed file COPYING for license information (AGPL). If you
# did not receive this file, see http://www.gnu.org/licenses/agpl.txt.
# --
# start generic agent every 20 minutes
# see oskab töid ringi jaotada
#*/20 * * * *    $HOME/bin/GenericAgent.pl >> 
/var/log/otrs_GenericAgent.log
#
# example to execute GenericAgent.pl on 23:00 with
# Kernel::Config::GenericAgentMove job file
#0 23 * * * $HOME/bin/GenericAgent.pl -c 
"Kernel::Config::GenericAgentMove" >> /var/log/otrs_GenericAgent23.log
#
# --
# cron/generic_agent - GenericAgent.pl cron of the OTRS
# Copyright (C) 2001-2009 OTRS AG, http://otrs.org/
# --
# $Id: generic_agent-database.dist,v 1.8 2009/02/16 20:55:11 tr Exp $
# --
# This software comes with ABSOLUTELY NO WARRANTY. For details, see
# the enclosed file COPYING for license information (AGPL). If you
# did not receive this file, see http://www.gnu.org/licenses/agpl.txt.
# --
#
# start generic agent every 10 minutes
# see oskab töid ringi jaotada
#*/10 * * * *    $HOME/bin/GenericAgent.pl -c db >> 
/var/log/otrs_GenericAgent-database.log
#
# --
# cron/pending_jobs - pending_jobs cron of the OTRS
# Copyright (C) 2001-2009 OTRS AG, http://otrs.org/
# --
# $Id: pending_jobs.dist,v 1.11 2009/02/16 20:55:11 tr Exp $
# --
# This software comes with ABSOLUTELY NO WARRANTY. For details, see
# the enclosed file COPYING for license information (AGPL). If you
# did not receive this file, see http://www.gnu.org/licenses/agpl.txt.
# --
# check every 120 min the pending jobs
#45 */2 * * *    $HOME/bin/PendingJobs.pl >> /var/log/otrs_PendingJobs.log
#
# --
# cron/postmaster - postmaster cron of the OTRS
# Copyright (C) 2001-2009 OTRS AG, http://otrs.org/
# --
# $Id: postmaster.dist,v 1.9 2009/02/16 20:55:11 tr Exp $
# --
# This software comes with ABSOLUTELY NO WARRANTY. For details, see
# the enclosed file COPYING for license information (AGPL). If you
# did not receive this file, see http://www.gnu.org/licenses/agpl.txt.
# --
# check daily the spool directory of OTRS
#10 0 * * * * [ -e /etc/init.d/otrs ] && /etc/init.d/otrs cleanup >> 
/dev/null; [ -e /etc/rc.d/init.d/otrs ] && /etc/rc.d/init.d/otrs 
cleanup >> /dev/null
#10 0 * * *  $HOME/bin/otrs.cleanup >> /var/log/otrs_postmaster.log
# --
# cron/postmaster_mailbox - postmaster_mailbox cron of the OTRS
# Copyright (C) 2001-2009 OTRS AG, http://otrs.org/
# --
# $Id: postmaster_mailbox.dist,v 1.2 2009/02/16 20:55:11 tr Exp $
# --
# This software comes with ABSOLUTELY NO WARRANTY. For details, see
# the enclosed file COPYING for license information (AGPL). If you
# did not receive this file, see http://www.gnu.org/licenses/agpl.txt.
# --
# fetch emails every 10 minutes
*/1 * * * *    $HOME/bin/PostMasterMailbox.pl >> 
/var/log/otrs_PostMasterMailbox.log
# --
# cron/rebuild_ticket_index - rebuild ticket index for OTRS
# Copyright (C) 2001-2009 OTRS AG, http://otrs.org/
# --
# $Id: rebuild_ticket_index.dist,v 1.9 2009/02/16 20:55:11 tr Exp $
# --
# This software comes with ABSOLUTELY NO WARRANTY. For details, see
# the enclosed file COPYING for license information (AGPL). If you
# did not receive this file, see http://www.gnu.org/licenses/agpl.txt.
# --
# just every day
# 01 01 * * * $HOME/bin/RebuildTicketIndex.pl >> 
/var/log/otrs_RebuildTicketIndex.log
# --
# cron/session - delete old session ids of the OTRS
# Copyright (C) 2001-2009 OTRS AG, http://otrs.org/
# --
# $Id: session.dist,v 1.11 2009/02/16 20:55:11 tr Exp $
# --
# This software comes with ABSOLUTELY NO WARRANTY. For details, see
# the enclosed file COPYING for license information (AGPL). If you
# did not receive this file, see http://www.gnu.org/licenses/agpl.txt.
# --
# delete every 120 minutes old/idle session ids
# 55 */2 * * *    $HOME/bin/DeleteSessionIDs.pl --expired >> 
/var/log/otrs_DeleteSessionIDs.log
# --
# cron/unlock - unlock old locked ticket of the OTRS
# Copyright (C) 2001-2009 OTRS AG, http://otrs.org/
# --
# $Id: unlock.dist,v 1.10 2009/02/16 20:55:11 tr Exp $
# --
# This software comes with ABSOLUTELY NO WARRANTY. For details, see
# the enclosed file COPYING for license information (AGPL). If you
# did not receive this file, see http://www.gnu.org/licenses/agpl.txt.
# --
# unlock every hour old locked tickets
# 35 * * * *  $HOME/bin/UnlockTickets.pl --timeout >> 
/var/log/otrs_UnlockTickets.log
otrs:/opt/otrs/bin$
*Modules info:*
otrs:/opt/otrs/bin$ ./otrs.checkModules
o CGI............................ok (v3.49)
o Date::Pcalc....................ok (v1.2)
o Date::Format...................ok (v2.22)
o DBI............................ok (v1.609)
o DBD::mysql.....................ok (v4.013)
o Digest::MD5....................ok (v2.39)
o Crypt::PasswdMD5...............ok (v1.3)
o LWP::UserAgent.................ok (v5.834)
o Encode::HanExtra...............Not installed! (Optional - 
Required to handle mails with several Chinese character sets.)
o IO::Scalar.....................ok (v2.110)
o IO::Wrap.......................ok (v2.110)
o MIME::Base64...................ok (v3.09)
o Mail::Internet.................ok (v2.04)
o MIME::Tools....................ok (v5.427)
o Net::DNS.......................ok (v0.66)
o Net::POP3......................ok (v2.29)
o Mail::POP3Client...............ok (v2.18 )
o IO::Socket::SSL.............Not installed! (Optional - for 
POP3 SSL connections)
o Net::IMAP::Simple..............ok (v1.17)
o Net::IMAP::Simple::SSL......Not installed! (Optional - 
Required for SSL connections.)
o Net::SMTP......................ok (v2.31)
o Authen::SASL................ok (v2.12)
o Net::SMTP::SSL..............Not installed! (Optional - 
Required for SSL/SMTPS connections.)
o Net::LDAP......................ok (v0.40)
o GD.............................ok (v2.39)
o GD::Text....................ok (v0.86)
o GD::Graph...................ok (v1.44)
o GD::Graph::lines............ok (v1.15)
o GD::Text::Align.............ok (v1.18)
o PDF::API2......................ok (v0.73)
o Compress::Zlib..............ok (v2.024)
o SOAP::Lite.....................Not installed! (Optional - 
Required for the SOAP interface.)
o XML::Parser....................ok (v2.36)
Thank you!
Regards,
Raul
---------------------------------------------------------------------
OTRS 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/
-- 
Guillaume REHM
Centre de Ressources Informatiques
Responsable Sécurité du Syste`me d'Information (RSSI)

Bibliothe`que Nationale et Universitaire de Strasbourg
5 rue du Maréchal Joffre
BP 51029
67070 Strasbourg

tél: 03 88 25 28 23
fax: 03 88 25 28 03
mail: guillaume.rehm@bnu.fr
web: http://www.bnu.fr

Re: [otrs] cron daemon problem (OTRS 2.4.7 and ITSM 1.3.2)

Guillaume Rehm