[otrs] otrs:problem in recieving mail
344 views
Skip to first unread message
Karthick B
Sep 14, 2009, 6:24:20 AM9/14/09
to ot...@otrs.org
HI all/
i have installed otrs sucessfully.and i have a mail server with real domain. i want to fetch the mail from that domain. so i configured PostMasterMailAccount i have give the username and password of my mail server
TYPE:POP3
username:support
password:******
Host:10.20.30.7
now as per the doccument i copied the .fetchmailrc.dist to .fetclmail.rc
poll 10.20.30.7 protocol POP3 user support password ***** is sujeet
then i set the file permission as chmod 710 .fetchmailrc.
when i execute fetchmail -a command it showing error as
fetchmail:no mailservers has been specified
pls help me...
am literally going mad because of this ....
my domain is :lifespring.in and sujeet is a user in otrs and he belongs to a queue(Agent) he has admin rights also`
when people sends mail to sup...@lifespring.in using fetchmail i should fetch that mails and it should comes to otrs user(sujeet) .
--
Regards,
B.Karthick.
i have installed otrs sucessfully.and i have a mail server with real domain. i want to fetch the mail from that domain. so i configured PostMasterMailAccount i have give the username and password of my mail server
TYPE:POP3
username:support
password:******
Host:10.20.30.7
now as per the doccument i copied the .fetchmailrc.dist to .fetclmail.rc
poll 10.20.30.7 protocol POP3 user support password ***** is sujeet
then i set the file permission as chmod 710 .fetchmailrc.
when i execute fetchmail -a command it showing error as
fetchmail:no mailservers has been specified
pls help me...
am literally going mad because of this ....
my domain is :lifespring.in and sujeet is a user in otrs and he belongs to a queue(Agent) he has admin rights also`
when people sends mail to sup...@lifespring.in using fetchmail i should fetch that mails and it should comes to otrs user(sujeet) .
On Mon, Sep 14, 2009 at 1:18 PM, <otrs-r...@otrs.org> wrote:
Send otrs mailing list submissions to
ot...@otrs.org
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.otrs.org/cgi-bin/listinfo/otrs
or, via email, send a message with subject or body 'help' to
otrs-r...@otrs.org
You can reach the person managing the list at
otrs-...@otrs.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of otrs digest..."
Today's Topics:
1. Re: extrange error installing opennms plugin (Michiel Beijen)
2. Re: extrange error installing opennms plugin (Aquiles Cohen)
3. Re: otrs-incoming mails from mail server are not storing in
orts database (Kovacs Krisztian)
4. Error: After Upgrade from 2.3.4 to 2.4.4 -> Event based
Notification does not work (MM...@timocom.com)
5. Merge tickets with Customer (Hien HUYNH HUU)
----------------------------------------------------------------------
Message: 1
Date: Sun, 13 Sep 2009 21:55:46 +0200
From: Michiel Beijen <m...@otrs.org>
Subject: Re: [otrs] extrange error installing opennms plugin
To: "User questions and discussions about OTRS." <ot...@otrs.org>
Message-ID:
<9eda38a40909131255t315...@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
Hi Aquiles,
How have you installed those modules?
If you'd do it via the CPAN it **might** be that you have installed
them for the 'current user' only so they would not be accessible for
the web server user.
Please do the CPAN install only as 'root' or use your systems'
package manager.
Regards,
Michiel
On Sun, Sep 13, 2009 at 12:50 AM, Aquiles Cohen <aqc...@gmail.com> wrote:
> hi, i?m having troubles installing the opennms plugin in otrs.
>
> my otrs version es 2.4.4 with itsm 1.3.1
>
> i tried this using all package manager options.
>
> from local files and from online repo. allways got the same error.
>
> i installed the opennms 1.1.0 plugin downloaded from sf.net, and i all is
> ok. but when i try to upgrade to opennms 1.1.1 show me the same error as
> before install 1.1.0 from online repo.
>
> this is the error.
>
> Error: Sorry, can't install package, because module SOAP::Lite v0.1 is
> required and not[..]
>
> ERROR: OTRS-CGI-10 Perl: 5.10.0 OS: linux Time: Sat Sep 12 17:45:49 2009
>
> Message: Sorry, can't install package, because module SOAP::Lite v0.1 is
> required and not installed!
>
> Traceback (20293):
> ?? Module: Kernel::System::Package::_CheckModuleRequired (v1.106) Line: 2012
> ?? Module: Kernel::System::Package::PackageUpgrade (v1.106) Line: 584
> ?? Module: Kernel::Modules::AdminPackageManager::_UpgradeHandling (v1.81)
> Line: 1476
> ?? Module: Kernel::Modules::AdminPackageManager::Run (v1.81) Line: 689
> ?? Module: Kernel::System::Web::InterfaceAgent::Run (v1.43) Line: 819
> ?? Module:
> ModPerl::ROOT::ModPerl::Registry::usr_share_otrs_bin_cgi_2dbin_index_2epl::handler
> (unknown version) Line: 48
> ?? Module: (eval) (v1.88) Line: 204
> ?? Module: ModPerl::RegistryCooker::run (v1.88) Line: 204
> ?? Module: ModPerl::RegistryCooker::default_handler (v1.88) Line: 170
> ?? Module: ModPerl::Registry::handler (v1.99) Line: 31
>
>
> the most strange is that i have install the SOAP:Lite and SOAP::DateTime
> modules . i cheched the system using otrs.CheckModules script but it's seem
> that all is ok. but OTRS show me ahead error.? i restart remove the modules
> and installed again but it don't work.? Any clues?
>
>
> ?o CGI............................ok (v3.47)
> ?? o Date::Pcalc....................ok (v1.2)
> ?? o Date::Format...................ok (v2.22)
> ?? o DBI............................ok (v1.607)
> ?? o DBD::mysql.....................ok (v4.008)
> ?? o Digest::MD5....................ok (v2.36_01)
> ?? o Crypt::PasswdMD5...............ok (v1.3)
> ?? o LWP::UserAgent.................ok (v5.819)
> ?? o Encode::HanExtra...............ok (v0.23)
> ?? o IO::Scalar.....................ok (v2.110)
> ?? o IO::Wrap.......................ok (v2.110)
> ?? o MIME::Base64...................ok (v3.07_01)
> ?? o Mail::Internet.................ok (v2.04)
> ?? o MIME::Tools....................ok (v5.427)
> ?? o Net::DNS.......................ok (v0.63)
> ?? o Net::POP3......................ok (v2.29)
> ?? o Mail::POP3Client...............ok (v2.18 )
> ????? o IO::Socket::SSL.............ok (v1.18)
> ?? o Net::IMAP::Simple..............ok (v1.17)
> ????? o Net::IMAP::Simple::SSL......ok (v1.3)
> ?? o Net::SMTP......................ok (v2.31)
> ????? o Authen::SASL................ok (v2.12)
> ????? o Net::SMTP::SSL..............ok (v1.01)
> ?? o Net::LDAP......................ok (v0.39)
> ?? 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......................failed!!! Version 0.72.003 not
> supported! This version is broken and not useable, please upgrade to a
> higher version!
> ?? o SOAP::Lite.....................ok (v0.710.08)
> ?? o XML::Parser....................ok (v2.36)
>
>
>
> Aquiles Cohen.-
>
> Homepage : http://aqcohen.blogspot.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
>
> NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
> http://www.otrs.com/en/support/enterprise-subscription/
>
------------------------------
Message: 2
Date: Sun, 13 Sep 2009 19:53:07 -0500
From: Aquiles Cohen <aqc...@gmail.com>
Subject: Re: [otrs] extrange error installing opennms plugin
To: "User questions and discussions about OTRS." <ot...@otrs.org>
Message-ID:
<7290f0a60909131753l100...@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
i tried the two forms. the system its running ubuntu. with cpan i installed
using root. my otrs install is runnning as otrs user and www-data group.
Aquiles Cohen.-
Homepage : http://aqcohen.blogspot.com
On Sun, Sep 13, 2009 at 2:55 PM, Michiel Beijen <m...@otrs.org> wrote:
> Hi Aquiles,
>
> How have you installed those modules?
> If you'd do it via the CPAN it **might** be that you have installed
> them for the 'current user' only so they would not be accessible for
> the web server user.
>
> Please do the CPAN install only as 'root' or use your systems'
> package manager.
>
> Regards,
>
> Michiel
>
> On Sun, Sep 13, 2009 at 12:50 AM, Aquiles Cohen <aqc...@gmail.com> wrote:
> > hi, i?m having troubles installing the opennms plugin in otrs.
> >
> > my otrs version es 2.4.4 with itsm 1.3.1
> >
> > i tried this using all package manager options.
> >
> > from local files and from online repo. allways got the same error.
> >
> > i installed the opennms 1.1.0 plugin downloaded from sf.net, and i all
> is
> > ok. but when i try to upgrade to opennms 1.1.1 show me the same error as
> > before install 1.1.0 from online repo.
> >
> > this is the error.
> >
> > Error: Sorry, can't install package, because module SOAP::Lite v0.1 is
> > required and not[..]
> >
> > ERROR: OTRS-CGI-10 Perl: 5.10.0 OS: linux Time: Sat Sep 12 17:45:49 2009
> >
> > Message: Sorry, can't install package, because module SOAP::Lite v0.1 is
> > required and not installed!
> >
> > Traceback (20293):
> > Module: Kernel::System::Package::_CheckModuleRequired (v1.106) Line:
> 2012
> > Module: Kernel::System::Package::PackageUpgrade (v1.106) Line: 584
> > Module: Kernel::Modules::AdminPackageManager::_UpgradeHandling (v1.81)
> > Line: 1476
> > Module: Kernel::Modules::AdminPackageManager::Run (v1.81) Line: 689
> > Module: Kernel::System::Web::InterfaceAgent::Run (v1.43) Line: 819
> > Module:
> >
> ModPerl::ROOT::ModPerl::Registry::usr_share_otrs_bin_cgi_2dbin_index_2epl::handler
> > (unknown version) Line: 48
> > Module: (eval) (v1.88) Line: 204
> > Module: ModPerl::RegistryCooker::run (v1.88) Line: 204
> > Module: ModPerl::RegistryCooker::default_handler (v1.88) Line: 170
> > Module: ModPerl::Registry::handler (v1.99) Line: 31
> >
> >
> > the most strange is that i have install the SOAP:Lite and SOAP::DateTime
> > modules . i cheched the system using otrs.CheckModules script but it's
> seem
> > that all is ok. but OTRS show me ahead error. i restart remove the
> modules
> > and installed again but it don't work. Any clues?
> >
> >
> > o CGI............................ok (v3.47)
> > o Date::Pcalc....................ok (v1.2)
> > o Date::Format...................ok (v2.22)
> > o DBI............................ok (v1.607)
> > o DBD::mysql.....................ok (v4.008)
> > o Digest::MD5....................ok (v2.36_01)
> > o Crypt::PasswdMD5...............ok (v1.3)
> > o LWP::UserAgent.................ok (v5.819)
> > o Encode::HanExtra...............ok (v0.23)
> > o IO::Scalar.....................ok (v2.110)
> > o IO::Wrap.......................ok (v2.110)
> > o MIME::Base64...................ok (v3.07_01)
> > o Mail::Internet.................ok (v2.04)
> > o MIME::Tools....................ok (v5.427)
> > o Net::DNS.......................ok (v0.63)
> > o Net::POP3......................ok (v2.29)
> > o Mail::POP3Client...............ok (v2.18 )
> > o IO::Socket::SSL.............ok (v1.18)
> > o Net::IMAP::Simple..............ok (v1.17)
> > o Net::IMAP::Simple::SSL......ok (v1.3)
> > o Net::SMTP......................ok (v2.31)
> > o Authen::SASL................ok (v2.12)
> > o Net::SMTP::SSL..............ok (v1.01)
> > o Net::LDAP......................ok (v0.39)
> > 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......................failed!!! Version 0.72.003 not
> > supported! This version is broken and not useable, please upgrade to a
> > higher version!
> > o SOAP::Lite.....................ok (v0.710.08)
> > o XML::Parser....................ok (v2.36)
> >
> >
> >
> > Aquiles Cohen.-
> >
> > Homepage : http://aqcohen.blogspot.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
> >
> > 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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.otrs.org/pipermail/otrs/attachments/20090913/e4aee2cf/attachment-0001.html>
------------------------------
Message: 3
Date: Mon, 14 Sep 2009 08:15:49 +0200
From: Kovacs Krisztian <kovacs.k...@generalmedia.hu>
Subject: Re: [otrs] otrs-incoming mails from mail server are not
storing in orts database
To: "User questions and discussions about OTRS." <ot...@otrs.org>
Message-ID: <602522492.20...@generalmedia.hu>
Content-Type: text/plain; charset=iso-8859-1
You don't need fetchmail ! (or just in the case if you want store the mails in a local mailbox, but it's totally unnecessary).
1. for receiving emails (POP3, IMAP, etc.):
You can set up "fetchmail" like accounts in OTRS at:
Admin -> PostMaster Mail Account -> Add
You can specify a lot's of them here ...
2. for sending emails (SMTP):
Admin -> Sysconfig -> Framework (group) -> Core::Sendmail
Hope it helps ...
> HI am using otrs 2.4
> I configured smtp server and using fetchmail i'm, trying to fetch mail from mail server.as result am fetching mail from mail server,but i dont know where that mails are storing,its not storing in otrs database also..anyone can provide me the solution.
------------------------------
Message: 4
Date: Mon, 14 Sep 2009 08:47:33 +0200
From: MM...@timocom.com
Subject: [otrs] Error: After Upgrade from 2.3.4 to 2.4.4 -> Event
based Notification does not work
To: ot...@otrs.org
Message-ID:
<OF25E7E841.CC7E9F4C-ON002576...@timocom.com>
Content-Type: text/plain; charset="iso-8859-1"
Hey,
I have a problem with my OTRS 2.4.4. I had a test system running with otrs
2.4.3 and event based notifications. No problems in this version. After
that I updated my production system with the otrs 2.4.4 version. Now I have
a problem, cause the event based notification does?t work for me. I
discussed this issue in the german otrs list and the only event which is
working for me and for some other ppl ist the 'TicketCreate' event.
Can anybody held me out with a work around to get the event based
notifications to work?
Mit freundlichen Gr??en / Kind regards
Markus Moj
IT Infrastructure & Services
TimoCom Soft- und Hardware GmbH
In der Steele 2
D-40599 D?sseldorf
Tel: +49 211 88 26 80 14
Fax: +49 211 88 26 70 14
eMail: MM...@TimoCom.com
www.TimoCom.com
Gesch?ftsf?hrer: Jens Thiermann, Gunther Matzaitis
Amtsgericht D?sseldorf, HRB 34489
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.otrs.org/pipermail/otrs/attachments/20090914/a61d9ea4/attachment-0001.html>
------------------------------
Message: 5
Date: Mon, 14 Sep 2009 14:47:00 +0700
From: Hien HUYNH HUU <hie...@sbsc.com.vn>
Subject: [otrs] Merge tickets with Customer
To: "ot...@otrs.org" <ot...@otrs.org>
Message-ID:
<B77164F11BD5FB4D89898...@mail-srv.sbsc.com.vn>
Content-Type: text/plain; charset="us-ascii"
Dear all,
I used merge for new ticket with the old ticket. But the customer can't see old ticket . I want to let new customer can see their answer in the old ticket when their ticket is merged. Please help me to solve this issue . Best regards,
Huu Hien
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.otrs.org/pipermail/otrs/attachments/20090914/b251adac/attachment.html>
------------------------------
---------------------------------------------------------------------
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/
End of otrs Digest, Vol 12, Issue 60
************************************
--
Regards,
B.Karthick.
Kovacs Krisztian
Sep 14, 2009, 7:28:34 AM9/14/09
to User questions and discussions about OTRS.
You don't need fetchmail for OTRS!!!
(You can use it, but it's nothing to do with OTRS.)
Just use the built-in mail account feature of OTRS.
eg. Use the data which your internet provider is given to you.
And please, don't include the whole dialy digest in your mail !
Greets
Krisz
---------
HI all/
i have installed otrs sucessfully.and i have a mail server with real domain. i want to fetch the mail from that domain. so i configured PostMasterMailAccount i have give the username and password of my mail server
TYPE:POP3
username:support
password:******
Host:10.20.30.7
now as per the doccument i copied the .fetchmailrc.dist to .fetclmail.rc
poll 10.20.30.7 protocol POP3 user support password ***** is sujeet
then i set the file permission as chmod 710 .fetchmailrc.
when i execute fetchmail -a command it showing error as
fetchmail:no mailservers has been specified
pls help me...
am literally going mad because of this ....
my domain is :lifespring.in and sujeet is a user in otrs and he belongs to a queue(Agent) he has admin rights also`
when people sends mail to sup...@lifespring.in using fetchmail i should fetch that mails and it should comes to otrs user(sujeet) .
Karthick B
Sep 14, 2009, 9:18:45 AM9/14/09
to ot...@otrs.org
HI Kovacs Krisztian
thanks for your reply
I configured PostMasterMail account .when i run the script i'm getting the following errors.
ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Mon Sep 14 06:43:21 2009
Message: POP3: Auth for user support/10.20.30.7 failed!
Traceback (9050):
Module: Kernel::System::MailAccount::POP3::Fetch (v1.6) Line: 86
Module: Kernel::System::MailAccount::MailAccountFetch (v1.9) Line: 380
Module: Kernel::Modules::AdminMailAccount::Run (v1.7) Line: 62
Module: main::Fetch (v1.9) Line:180
Module: Kernel::System::Web::InterfaceAgent::Run (v1.43) Line: 819
Module: /opt/otrs/bin/cgi-bin/index.pl (v1.88) Line: 48
Module: ./bin/PostMasterMailbox.pl(v1.9)Line:94
--
Regards,
B.Karthick.
thanks for your reply
I configured PostMasterMail account .when i run the script i'm getting the following errors.
ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Mon Sep 14 06:43:21 2009
Message: POP3: Auth for user support/10.20.30.7 failed!
Traceback (9050):
Module: Kernel::System::MailAccount::POP3::Fetch (v1.6) Line: 86
Module: Kernel::System::MailAccount::MailAccountFetch (v1.9) Line: 380
Module: Kernel::Modules::AdminMailAccount::Run (v1.7) Line: 62
Module: main::Fetch (v1.9) Line:180
Module: Kernel::System::Web::InterfaceAgent::Run (v1.43) Line: 819
Module: ./bin/PostMasterMailbox.pl(v1.9)Line:94
On Mon, Sep 14, 2009 at 5:09 PM, <otrs-r...@otrs.org> wrote:
Send otrs mailing list submissions to
ot...@otrs.org
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.otrs.org/cgi-bin/listinfo/otrs
or, via email, send a message with subject or body 'help' to
otrs-r...@otrs.org
You can reach the person managing the list at
otrs-...@otrs.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of otrs digest..."
Today's Topics:
1. Re: otrs:problem in recieving mail (Kovacs Krisztian)
2. Re: Fw: perl migration script help (Emily Flynn)
3. begginers question - what ticket locking is? (Grzegorz Marsza?ek)
----------------------------------------------------------------------
Message: 1
Date: Mon, 14 Sep 2009 13:28:34 +0200
From: Kovacs Krisztian <kovacs.k...@generalmedia.hu>
Subject: Re: [otrs] otrs:problem in recieving mail
To: "User questions and discussions about OTRS." <ot...@otrs.org>
Message-ID: <662695859.20...@generalmedia.hu>
Content-Type: text/plain; charset=iso-8859-1
You don't need fetchmail for OTRS!!!
(You can use it, but it's nothing to do with OTRS.)
Just use the built-in mail account feature of OTRS.
eg. Use the data which your internet provider is given to you.
And please, don't include the whole dialy digest in your mail !
Greets
Krisz
---------
HI all/
i have installed otrs sucessfully.and i have a mail server with real domain. i want to fetch the mail from that domain. so i configured PostMasterMailAccount i have give the username and password of my mail server
TYPE:POP3
username:support
password:******
Host:10.20.30.7
now as per the doccument i copied the .fetchmailrc.dist to .fetclmail.rc
poll 10.20.30.7 protocol POP3 user support password ***** is sujeet
then i set the file permission as chmod 710 .fetchmailrc.
when i execute fetchmail -a command it showing error as
fetchmail:no mailservers has been specified
pls help me...
am literally going mad because of this ....
my domain is :lifespring.in and sujeet is a user in otrs and he belongs to a queue(Agent) he has admin rights also`
when people sends mail to sup...@lifespring.in using fetchmail i should fetch that mails and it should comes to otrs user(sujeet) .
------------------------------
Message: 2
Date: Mon, 14 Sep 2009 12:29:46 +0100
From: Emily Flynn <emily...@zurichbank.com>
Subject: Re: [otrs] Fw: perl migration script help
To: "User questions and discussions about OTRS." <ot...@otrs.org>
Message-ID:
<OF25E43C81.EC22723F-ON802576...@email.zurich.com>
Content-Type: text/plain; charset="iso-8859-1"
Many thanks for your help Rory... silly I should have thought of trying
that.
Got it working using command line anyways, thanks again!
From:
Rory <rcle...@gmail.com>
To:
"User questions and discussions about OTRS." <ot...@otrs.org>
Date:
11/09/2009 18:59
Subject:
Re: [otrs] Fw: perl migration script help
Sent by:
otrs-b...@otrs.org
MySQL thinks the DBUpdate-to-2.4.pl is an sql file and is trying to
run it as such. Its not qsl rho so that's why you're getting the
"error in you SQL syntax" response. You need to run the file from the
command line.
Try this,
perl DBUpdate-to-2.4.pl
You might need to use the full path to the perl.exe if its not in your
path.
Once that's run log back into your mysql and run the
DBUpdate-to-2.4-post.mysql.sql the same as the first .sql script.
Hopefully that will get the DB updated for you.
Rory
Support my 365 Challenge in aid of the Irish Cancer Society
www.365challenge.ie
2009/9/11 Emily Flynn <emily...@zurichbank.com>
>
> Hiya,
>
> Thanks a million for your reply.. I'm still having a problem and I
suspect it is to do with something else. Here is what I input into MySQL
Query Browser, logged in as root to otrs:
>
> use otrs;
> source "C:\Program Files\OTRS\OTRS\scripts\DBUpdate-to-2.4.pl";
>
> and this is what I get no matter what I type in..
>
> You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near "'C:\Program
Files\OTRS\OTRS\scripts\DBUpdate-to-2.4.pl'" at line 1
>
> I have tried a couple of variations on the code but still no luck :(
>
> Emily
>
>
>
>
>
> From: Rory <rcle...@gmail.com>
> To:
> "User questions and discussions about OTRS." <ot...@otrs.org>
> Date: 11/09/2009 14:45
> Subject: Re: [otrs] Fw: perl migration script help
> Sent by: otrs-b...@otrs.org
> ________________________________
>
>
> Hi,
>
> Yes, $HOME_OTRS should be the full path to the OTRS directory. On my
> windows machine this is C:\Program Files\OTRS\OTRS
> You could either use quotation marks around the entire path e.g.
> source "C:\Program Files\OTRS\OTRS\scripts\DBUpdate-to-2.4.mysql.sql";
>
> The perl script should run just fine as you have to have a perl
> interpreter to run otrs in the first place.
> I'm not sure if it will work on Windows tho as I think the upgrade
> scripts were written for Linux based machines.
>
> Take it easy,
> Rory
>
> Support my 365 Challenge in aid of the Irish Cancer Society
>
> www.365challenge.ie
>
>
> 2009/9/11 Emily Flynn <emily...@zurichbank.com>
> >
> > Sorry, just bumping this... really need the help!
> > ________________________________
> >
> >
> >
> > Hiya,
> >
> > Sorry I'm doing this on an XP box just to test the upgrade process...
prod box is on Windows Server 2003.
> >
> > I am using MySQL Query Browser to run these scripts, I log into it
using root, and then I can browse to the actual SQL script to run that and
that is ok...
> >
> > But as far as the Perl script goes, I don't know what to do with that
as MySQL Query Browser won't run Perl... and I have no Perl experience so
am really not sure how to go about it!
> >
> > On a side... below where you write source
$HOME_OTRS/scripts/DBUpdate-to-2.4.mysql.sql; do you mean me to paste that
directly into the browser or do I amend $HOME_OTRS to the actual path, and
if so, what it the best way to write this, i.e, the 'program files' bit?
> >
> > Apologies for my silly questions and thanks.
> >
> > Emily
> >
> >
> >
> >
> > MM...@timocom.com
> > Sent by: otrs-b...@otrs.org
> >
> > 09/09/2009 17:55
> >
> > Please respond to
> > "User questions and discussions about OTRS." <ot...@otrs.org>
> >
> > To
> > "User questions and discussions about OTRS." <ot...@otrs.org>
> > cc
> > Subject
> > Re: [otrs] perl migration script help
> >
> >
> >
> >
> >
> >
> > Hey,
> >
> > just login into your mysql as 'root' and then do the following.
> >
> > use otrs;
> >
> > source $HOME_OTRS/scripts/DBUpdate-to-2.4.mysql.sql;
> >
> > source $HOME_OTRS/scripts/DBUpdate-to-2.4.pl;
> > Here you?ll get some error?s just ignore them and go on with the
following command.
> >
> > source $HOME_OTRS/scripts/DBUpdate-to-2.4-post.mysql.sql;
> >
> > Then you can quit from mysql and restart the services. Now just login
into your OTRS System with an administrators account, go to the Admin
panel and click on the sysconfig.
> >
> > Have fun ;)
> >
> > Mit freundlichen Gr??en / Kind regards
> > Markus Moj
> > IT Infrastructure & Services
> >
> > TimoCom Soft- und Hardware GmbH
> > In der Steele 2
> > D-40599 D?sseldorf
> > Tel: +49 211 88 26 80 14
> > Fax: +49 211 88 26 70 14
> > eMail: MM...@TimoCom.com
> > www.TimoCom.com
> > Gesch?ftsf?hrer: Jens Thiermann, Gunther Matzaitis
> > Amtsgericht D?sseldorf, HRB 34489
> >
> > Emily Flynn ---09.09.2009 18:48:07---Hello! I am trying to upgrade
from 2.3.4 to 2.4.3, and I'm a bit lost on what to
> > From:
> > Emily Flynn <emily...@zurichbank.com>
> > To:
> > ot...@otrs.org
> > Date:
> > 09.09.2009 18:48
> > Subject:
> > [otrs] perl migration script help
> > Sent by:
> > otrs-b...@otrs.org
> >
> > ________________________________
> >
> >
> >
> > Hello!
> >
> > I am trying to upgrade from 2.3.4 to 2.4.3, and I'm a bit lost on what
to do for running the perl migration script
> >
> >
http://faq.otrs.org/otrs/public.pl?Action=PublicFAQ&Subaction=Print&CategoryID=5&ItemID=351
> >
> > I have MySQL Tools installed and so have used MySQL Admin to backup
and restore, and MySQL Query Browser to run the first upgrade script
(DBUpdate-to-2.4.mysql.sql ). I am not sure how to run the Perl migration
script, can someone please give me a couple of pointers?
> >
> > Thanks in advance
> >
> >
Emily---------------------------------------------------------------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.otrs.org/pipermail/otrs/attachments/20090914/47a3f2a2/attachment-0001.html>
------------------------------
Message: 3
Date: Mon, 14 Sep 2009 13:28:24 +0200
From: Grzegorz Marsza?ek <gr...@post.pl>
Subject: [otrs] begginers question - what ticket locking is?
To: ot...@otrs.org
Message-ID: <C50D46D4-3B6A-44C9...@post.pl>
Content-Type: text/plain; charset=ISO-8859-2; format=flowed; delsp=yes
Hello,
I'm begginer in otrs, moving from request tracker. I have problems
with concept of locking tickets - what it is for? how typical workflow
with locking should be?
It seems that locked tickets "disappears" from queue and only person
who locked it can see it. It's not what I need (or I think it's not :)
- I want all agents see all tickets, and especially bosses of agnet to
see what's going on with all tickets.
Cheers
---
Grzegorz Marsza?ek
gr...@post.pl
------------------------------
---------------------------------------------------------------------
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/
End of otrs Digest, Vol 12, Issue 62
************************************
--
Regards,
B.Karthick.
Marco Vannini
Sep 14, 2009, 9:23:39 AM9/14/09
to User questions and discussions about OTRS.
Just for debugging purposes if you are sure that the password is right.
from your otrs host:
telnet 10.20.30.7 110
(wait for promt)
user support
(wait for answer)
pass *****
If anything goes wrong here is the same reason for otrs.
Reply all
Reply to author
Forward
0 new messages