Ok, I got it working. Stupid mistake, There was a use statement that had to be uncommented. I thought it was meant to be a comment. doh!
SO to confirm for others, I had changed the following in the /opt/otrs/scripts/apache2-perl-startup.pl file: Uncommented (and added my password): use Apache::DBI (); Apache::DBI->connect_on_init('DBI:mysql:otrs', 'otrs', 'yourpassword'); use DBI (); Then uncommented (as I am using mysql): # enable this if you use mysql use DBD::mysql (); use Kernel::System::DB::mysql; Man, what a nice change in speed of the web interface. Now I only hve the following 2 issues outstanding. ------- 2) I also installed the FAQ module. Where on earth can I remove the "default comment"? 3) I am using smtps (Core::Sendmail) for my mail server as it requires a TLS connection on port 587. I am pretty sure i set it up right. But when i use a function that requires mail (IE recover password), I get: Traceback: ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Tue Jan 5 14:26:12 2010 Message: Can't connect to smtp.xxxxxxxx.com: ! Traceback (19419): Module: Kernel::System::Email::SMTPS::Send (v1.2) Line: 92 Module: Kernel::System::Email::Send (v1.64) Line: 683 Module: Kernel::System::Web::InterfaceCustomer::Run (v1.41.2.1) Line: 457 Module: /opt/otrs/bin/cgi-bin/customer.pl (v1.42) Line: 48 - Now i can ping that hostname without issue from the server. I have all the required perl modules installed as well. I have (for settings): SendmailModule: SMTPS SendmailModule::CMD: (left as default) SendmailModule::Host: myhostname SendmailModule::AuthUser: full email address (as my server requires) SendmailModule::AuthPassword: *********** ------- But since i got mod_perl working, I noticed the traceback changed a bit for my smtp sending issue: Traceback: ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Wed Jan 6 10:45:06 2010 Message: Can't connect to smtp.xxxxxxxx.com: ! Traceback (2138): Module: Kernel::System::Email::SMTPS::Send (v1.2) Line: 92 Module: Kernel::System::Email::Send (v1.64) Line: 683 Module: Kernel::System::Web::InterfaceCustomer::Run (v1.41.2.1) Line: 457 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_customer_2epl::handler (unknown version) Line: 48 Module: (eval) (v1.42) Line: 204 Module: ModPerl::RegistryCooker::run (v1.42) Line: 204 Module: ModPerl::RegistryCooker::default_handler (v1.42) Line: 170 Module: ModPerl::Registry::handler (v1.99) Line: 31 So I guess if anyone has any additional info and sending email with SMTPS, and that dumb "default" comment in the FAQ module, that would be appreciated. D On 2010-01-06, at 9:28 AM, dnk wrote: > Do you mean: > > enable this if you use mysql > use DBD::mysql (); > use Kernel::System::DB::mysql; > > > Or do you mean: > > (under apache) > use DBI (); > > (under core modules) > use Kernel::System::DB; > > D > On 2010-01-06, at 9:12 AM, Marco Vannini wrote: > >> >> uncomment also >> >> use DBD... >> use Kernel::System::DB.... >> >> >> On Wed, Jan 6, 2010 at 6:05 PM, dnk <d.k.emailli...@gmail.com> wrote: >> Just to add to my previous post, >> >> What should be edited in: >> /opt/otrs/scripts/apache2-perl-startup.pl >> >> Just uncomment and modify: >> Apache::DBI->connect_on_init('DBI:mysql:otrs', 'otrs', 'some-pass'); ? >> >> D >> >> >> >> On 2010-01-06, at 8:42 AM, dnk wrote: >> >> > Hey there, >> > >> > 1) I had a look at all of that documentation (README.webserver), and it >> > was already setup. I had used the RPM for OTRS (I am on CentOS 5), and it >> > did the configuration and added a perl.conf and otrs.conf to my config.d >> > directory. Just for giggles, I added the load module directive to my >> > httpd.conf (As I knew Apache would load it only once - but give me >> > feedback if the other instance loaded) - so i can confirm my mod_perl was >> > being loaded. So I am still not sure why it is not being used by OTRS. >> > >> > 2) I can add and delete my FAQ just fine, but somewhere in the template, >> > there are the words "default comment". It appears above the FAQ >> > categories. For example: >> > >> > ----------------- >> > FAQ >> > >> > default comment <------------------------ This is what I want to get >> > rid of. >> > >> > Name / Comment SubCategories Article >> > Hardware >> > Hardware related FAQ for devices such as computers, cell phones, etc 1 >> > 0 >> > ----------------- >> > >> > It actually even shows up at http://faq.otrs.org in their (OTRS) own FAQ >> > instance. >> > >> > >> > 3) In the checkModule, I have all modules in there as OK. The one in >> > particular that you mentioned too. >> > o Net::SMTP......................ok (v2.31) >> > o Authen::SASL................ok (v2.12) >> > o Net::SMTP::SSL..............ok (v1.01) >> > >> > As for your request to have a look at the link: >> > http://yourserver/otrs/index.pl?Action=AdminMailAccount >> > - That is the admin area for incoming email. My issue is with outbound. IE >> > when as password request, etc. >> >> From this link (for config): >> >> http://yourserver/otrs/index.pl?Action=AdminSysConfig&Subaction=Edit&SysConfigSubGroup=Core::Sendmail&SysConfigGroup=Framework >> > >> > But in the adminlog, there were the following errors (nothing else >> > related) from when I requested as password: >> > >> > Tue Jan 5 13:51:19 2010 error OTRS-CGI-10 Can't connect to >> > smtp.xxxxxxxxxxx.com: ! >> > >> > >> > Any additional ideas? >> > >> > D >> > >> > >> > >> > On 2010-01-05, at 3:38 PM, Leonardo Certuche wrote: >> > >> >> Hi there, >> >> • About enabling mod_perl, please read /opt/otrs/README.webserver >> >> • If you're logged in as admin, you'll be able to delete any FAQ >> >> article opening it and clicking the Delete button >> >> (http://yourserver/otrs/index.pl?Action=AgentFAQ&Subaction=Delete&CategoryID=XX&ItemID=YY) >> >> • To make sure you have all modules installed, run >> >> /opt/otrs/bin/otrs.checkModules, particularly Net::SMTP::SSL, which is >> >> needed for SMTPS, besides that, share with us the corresponding log >> >> entries at http://yourserver/otrs/index.pl?Action=AdminLog after you >> >> click under "Run Now!" at >> >> http://yourserver/otrs/index.pl?Action=AdminMailAccount >> >> Greeetings, >> >> >> >> Leonardo Certuche >> >> >> >> On Tue, Jan 5, 2010 at 5:49 PM, dnk <d.k.emailli...@gmail.com> wrote: >> >> Hi there, >> >> >> >> I have just setup OTRS on CentOS 5.4, and all is going well thus far. >> >> >> >> I just have a few questions that my google searches have not yielded >> >> results for... >> >> >> >> >> >> >> >> 1) When using the support module to check if my system is optimized, I >> >> get: >> >> >> >> Check for CGI Accelerator. >> >> You should use FastCGI or mod_perl to increase your performance. >> >> >> >> - What do i need to do to enable that? It seems to be set up in my apache >> >> conf (mod_perl). >> >> >> >> 2) I also installed the FAQ module. Where on earth can I remove the >> >> "default comment"? >> >> >> >> 3) I am using smtps (Core::Sendmail) for my mail server as it requires a >> >> TLS connection on port 587. I am pretty sure i set it up right. But when >> >> i use a function that requires mail (IE recover password), I get: >> >> >> >> Traceback: ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Tue Jan 5 >> >> 14:26:12 2010 >> >> >> >> Message: Can't connect to smtp.xxxxxxxx.com: ! >> >> >> >> Traceback (19419): >> >> Module: Kernel::System::Email::SMTPS::Send (v1.2) Line: 92 >> >> Module: Kernel::System::Email::Send (v1.64) Line: 683 >> >> Module: Kernel::System::Web::InterfaceCustomer::Run (v1.41.2.1) Line: 457 >> >> Module: /opt/otrs/bin/cgi-bin/customer.pl (v1.42) Line: 48 >> >> >> >> - Now i can ping that hostname without issue from the server. I have all >> >> the required perl modules installed as well. >> >> >> >> I have (for settings): >> >> >> >> SendmailModule: SMTPS >> >> SendmailModule::CMD: (left as default) >> >> SendmailModule::Host: myhostname >> >> SendmailModule::AuthUser: full email address (as my server requires) >> >> SendmailModule::AuthPassword: *********** >> >> >> >> >> >> Thanks in advance. >> >> >> >> D >> >> --------------------------------------------------------------------- >> >> 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/ >> > >> > --------------------------------------------------------------------- >> > 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/ >> >> --------------------------------------------------------------------- >> 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/ --------------------------------------------------------------------- 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/