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