March 2013 - otrs - OTRS mailing lists

Re: [otrs] Error oracle + otrs
by Gerald Young 12 Mar '13

12 Mar '13

http://forums.otterhub.org/viewtopic.php?t=10699 On Tue, Mar 12, 2013 at 8:29 AM, Darshak Modi <darshak.modi(a)elitecore.com>wrote: > Checked**** > > ** ** > > **1. **My directory is pointed to /opt/otrs, which is not empty.**** > > **2. **Also had added in ld.so.conf.d the path of oracle lib.**** > > **3. **After ldconfig, i got warning but my files are there in lib > folder.**** > > ** ** > > Dont know how to solve, any other suggestion ???**** > > ** ** > > *From:* otrs-bounces(a)otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf > Of *Gerald Young > *Sent:* 12 March 2013 PM 05:17 > > *To:* User questions and discussions about OTRS. > *Subject:* Re: [otrs] Error oracle + otrs**** > > ** ** > > https://forums.oracle.com/forums/thread.jspa?messageID=9422842**** > > ** ** > > On Tue, Mar 12, 2013 at 7:39 AM, Darshak Modi <darshak.modi(a)elitecore.com> > wrote:**** > > Yes tried all.**** > > **** > > Like adding LD_LIBRABY_PATH,**** > > Chmod**** > > Chown**** > > **** > > failed: Can't load > '/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so' > for module DBD::Oracle: libclntsh.so.10.1: cannot open shared object file: > No such file or directory at > /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 230.\n > at (eval 100) line 3.\nCompilation failed in require at (eval 100) line > 3.\nPerhaps a required shared library or dll isn't installed where > expected\n at /opt/otrs//Kernel/System/DB.pm line 256.\n**** > > **** > > **** > > I have those files also.**** > > #locate libclntsh.so.10.1**** > > /u01/app/product/10.2.0/lib/libclntsh.so.10.1**** > > /u01/app/product/10.2.0/lib32/libclntsh.so.10.1**** > > **** > > **** > > All different tries.. but no success J**** > > **** > > **** > > **** > > *From:* otrs-bounces(a)otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf > Of *Gerald Young > *Sent:* 12 March 2013 PM 04:53 > *To:* User questions and discussions about OTRS. > *Subject:* Re: [otrs] Error oracle + otrs**** > > **** > > Did you try to use a popular search engine on the can't load error? **** > > On Mar 12, 2013 7:13 AM, "Darshak Modi" <darshak.modi(a)elitecore.com> > wrote:**** > > Can any one help ?**** > > **** > > **** > > nstall_driver(Oracle) failed: Can't load > '/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so' > for module DBD::Oracle: libclntsh.so.10.1: cannot open shared object file: > No such file or directory at > /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 230.\n > at (eval 100) line 3.\nCompilation failed in require at (eval 100) line > 3.\nPerhaps a required shared library or dll isn't installed where > expected\n at /opt/otrs//Kernel/System/DB.pm line 256.\n**** > > **** > > **** > > **** > > I have included ORACLE_HOME in otrs.conf, /etc/profile also.**** > > **** > > **** > > > --------------------------------------------------------------------- > 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**** > > > --------------------------------------------------------------------- > 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**** > > ** ** > > --------------------------------------------------------------------- > 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 >

2 1

Re: [otrs] Error oracle + otrs
by Steven Carr 12 Mar '13

12 Mar '13

On 12 March 2013 12:29, Darshak Modi <darshak.modi(a)elitecore.com> wrote: > Checked > > > > 1. My directory is pointed to /opt/otrs, which is not empty. > > 2. Also had added in ld.so.conf.d the path of oracle lib. > > 3. After ldconfig, i got warning but my files are there in lib folder. > > > > Dont know how to solve, any other suggestion ??? Can you connect to the oracle database from the linux commandline? have you got the SQL*Plus client installed? If you can't even connect then this isn't the right mailing list to ask, you need to ask on an Oracle list or contact Oracle support. Steve

2 1

Re: [otrs] Error oracle + otrs
by Gerald Young 12 Mar '13

12 Mar '13

https://forums.oracle.com/forums/thread.jspa?messageID=9422842 On Tue, Mar 12, 2013 at 7:39 AM, Darshak Modi <darshak.modi(a)elitecore.com>wrote: > Yes tried all.**** > > ** ** > > Like adding LD_LIBRABY_PATH,**** > > Chmod**** > > Chown**** > > ** ** > > failed: Can't load > '/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so' > for module DBD::Oracle: libclntsh.so.10.1: cannot open shared object file: > No such file or directory at > /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 230.\n > at (eval 100) line 3.\nCompilation failed in require at (eval 100) line > 3.\nPerhaps a required shared library or dll isn't installed where > expected\n at /opt/otrs//Kernel/System/DB.pm line 256.\n**** > > ** ** > > ** ** > > I have those files also.**** > > #locate libclntsh.so.10.1**** > > /u01/app/product/10.2.0/lib/libclntsh.so.10.1**** > > /u01/app/product/10.2.0/lib32/libclntsh.so.10.1**** > > ** ** > > ** ** > > All different tries.. but no success J**** > > ** ** > > ** ** > > ** ** > > *From:* otrs-bounces(a)otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf > Of *Gerald Young > *Sent:* 12 March 2013 PM 04:53 > *To:* User questions and discussions about OTRS. > *Subject:* Re: [otrs] Error oracle + otrs**** > > ** ** > > Did you try to use a popular search engine on the can't load error? **** > > On Mar 12, 2013 7:13 AM, "Darshak Modi" <darshak.modi(a)elitecore.com> > wrote:**** > > Can any one help ?**** > > **** > > **** > > nstall_driver(Oracle) failed: Can't load > '/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so' > for module DBD::Oracle: libclntsh.so.10.1: cannot open shared object file: > No such file or directory at > /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 230.\n > at (eval 100) line 3.\nCompilation failed in require at (eval 100) line > 3.\nPerhaps a required shared library or dll isn't installed where > expected\n at /opt/otrs//Kernel/System/DB.pm line 256.\n**** > > **** > > **** > > **** > > I have included ORACLE_HOME in otrs.conf, /etc/profile also.**** > > **** > > **** > > > --------------------------------------------------------------------- > 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**** > > --------------------------------------------------------------------- > 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 >

2 1

Stop SLA Clock
by Yousef Hamad 12 Mar '13

12 Mar '13

Hi steve, How can to prevent the SLA from continuing its time when ticket is pending. Thanks, Yousef. _______________________________________________________________________________________________________________________________________________________________________________________________________________ This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secured or error-free, as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Employees of Aspire Infotech are expressly required not to make defamatory statements and not to infringe or authorize any infringement of copyright or any other legal right by email communications. Aspire Infotech, 130 Queen Rania Street, PO Box 840098 Amman 11181 Jordan

2 1

Re: [otrs] Error oracle + otrs
by Gerald Young 12 Mar '13

12 Mar '13

Did you try to use a popular search engine on the can't load error? On Mar 12, 2013 7:13 AM, "Darshak Modi" <darshak.modi(a)elitecore.com> wrote: > Can any one help ?**** > > ** ** > > ** ** > > nstall_driver(Oracle) failed: Can't load > '/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so' > for module DBD::Oracle: libclntsh.so.10.1: cannot open shared object file: > No such file or directory at > /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 230.\n > at (eval 100) line 3.\nCompilation failed in require at (eval 100) line > 3.\nPerhaps a required shared library or dll isn't installed where > expected\n at /opt/otrs//Kernel/System/DB.pm line 256.\n**** > > ** ** > > ** ** > > ** ** > > I have included ORACLE_HOME in otrs.conf, /etc/profile also.**** > > ** ** > > ** ** > > --------------------------------------------------------------------- > 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 >

2 1

Error oracle + otrs
by Darshak Modi 12 Mar '13

12 Mar '13

Can any one help ? nstall_driver(Oracle) failed: Can't load '/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/Oracle/ Oracle.so' for module DBD::Oracle: libclntsh.so.10.1: cannot open shared object file: No such file or directory at /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 230.\n at (eval 100) line 3.\nCompilation failed in require at (eval 100) line 3.\nPerhaps a required shared library or dll isn't installed where expected\n at /opt/otrs//Kernel/System/DB.pm line 256.\n I have included ORACLE_HOME in otrs.conf, /etc/profile also.

1 0

Installing with Apache, Oracle
by Darshak Modi 12 Mar '13

12 Mar '13

Hello, I am trying to install with Apache, Oracle on linux. I have included otrs.conf in httpd.conf file. But I get following error in http log. Attempt to serve directory: /opt/otrs/bin/cgi-bin/ I am trying to access http://localhist/otrs, but the above error occurs.

1 0

Agent statistic error message when I turn on this option. - Please help
by Zsolt Hajduk 12 Mar '13

12 Mar '13

Dear All, I just read the following instruction, which tell how can I activate the agent statistic. I got an error message when I want to activate this option: Framework -> Frontend::Agent::Stats => Stats::UseAgentElementInStats = yes Would you anyone help me about it? This message apear when I turn the options to yes. The Error message is the following: "Oops! An Error occurred.Error Message: Can't write ConfigItem! You can or go back to the previous page<https://otrs.profis.hu/otrs/index.pl>. Error Details Backend ERROR: OTRS-CGI-10 Perl: 5.10.1 OS: linux Time: Wed Mar 6 10:11:05 2013 Message: Can't write ConfigItem! Traceback (1774): Module: Kernel::Modules::AdminSysConfig::Run (v1.119.2.1) Line: 174 Module: Kernel::System::Web::InterfaceAgent::Run (v1.64) Line: 868 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 46 Module: (eval) (v1.90) Line: 204 Module: ModPerl::RegistryCooker::run (v1.90) Line: 204 Module: ModPerl::RegistryCooker::default_handler (v1.90) Line: 170 Module: ModPerl::Registry::handler (v1.99) Line: 31 " Best regards, Zsolt

2 1

Hierarchical Dynamic Fields
by Marty Hillman 12 Mar '13

12 Mar '13

I am looking to utilize two dynamic fields for ticket entry where the dropdown in field 2 is dependent upon the entry in field 1. For example, in field 1 the user can select Problem or Request. If they select Problem, field 2 gives them a choice of email, printing phone, etc. If they select Request, they are offered website, login or other. I actually need to extend this a bit further with a primary field, but if someone can tell me how to create field 2 properly, I can work out the logic for the overly complicated scenario. I have been reading the documentation cover to cover but have not been able to figure out how to do this. Anyone have any ideas or suggestions for better initial setup documentation? Thanks! Marty

3 3

Move
by Luchtman, Kurt 11 Mar '13

11 Mar '13

I am at the end of my rope and am ready to hand this issue over to the E.O.D. to blow it up. I am trying to move from a physical server to a virtual server. I have installed the same version of OTRS (3.1.11) on the destination system. The only difference is the old system is CentOS 5.8 and the new system is 6.3. I have backed up the sql db and imported it. I can see that the data goes over with no problem. I can't log in to the unit to save my blood pressure. I even copied /opt/otrs to the new system to get the Config.pm and log in with my domain login and still nothing. What else can I do to get this transferred over? Kurt -------------------------------------------- Kurt Luchtman NC FAST Desktop Support Manager 3724 National Drive #200 Raleigh NC 27612 919-707-4198 ________________________________ Email correspondence to and from this address is subject to the North Carolina Public Records Law and may be disclosed to third parties by an authorized State official. Unauthorized disclosure of juvenile, health, legally privileged, or otherwise confidential information, including confidential information relating to an ongoing State procurement effort, is prohibited by law. If you have received this e-mail in error, please notify the sender immediately and delete all records of this e-mail.

4 9