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 <[email protected]> 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 <[email protected]> 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/