Hello,
I have a question:
Im testing the "fast" (speed wise) way to install OTRS and I have
everything working but I cant help but feel that I have either
overlooked something in the documentation or it just isnt there.
I have gotten to the part:
=====================================
You may want to use a mod_perl startup script. Compiled modules on
startup
(speed!)! Use the mod_perl startup script which comes with otrs
(scripts/apache-perl-startup.pl).
- Change the default startup script location of your httpd to
$OTRS_HOME/scripts/apache-perl-startup.pl in httpd.conf
[...]
# load all otrs modules
Perlrequire /opt/otrs/scripts/apache-perl-startup.pl
[...]
Edit the scripts/apache-perl-startup.pl script:
- Establish datababase connections on process startup (httpd).
[...]
use Apache ();
use Apache::DBI ();
Apache::DBI->connect_on_init('DBI:mysql:otrs', 'otrs',
'some-pass');
# Apache::DBI->connect_on_init($data_source, $username, $auth,
\%attr)
[...]
======================================
Now, heres my apache-perl-startup.pl (establish database connections on
process startup section only)
======================================
use Apache ();
use Apache::DBI ();
Apache::DBI->connect_on_init('DBI:mysql:otrs_dev', 'otrs',
'somepassthatiwontpaste');
use DBI ();
use DBD::mysql ();
======================================
Do I need to comment out some lines from the Kernel/Config.pm now? I
have 2 database connection strings and would prefer that they be loaded
from the startup.pl file. When I comment out the database connection
lines in the Kernel/Config.pm file, I get errors connecting to the
database. In fact I have set the Apache::DBI username to something that
doesn't even have privs on the database but cant see where it actually
uses that Apache::DBI "preloaded" connection(I don't get errors).
Theoretically my apache-perl-startup.pl should look like this if I use
the preload function (but im not sure how to call it with
Kernel/Config.pm though, hence the email):
======================================
use Apache ();
use Apache::DBI ();
Apache::DBI->connect_on_init('DBI:mysql:otrs_dev', 'otrs',
'somepassthatiwontpaste');
#use DBI ();
#use DBD::mysql ();
======================================
Shouldn't I be able to edit the Kernel/Config.pm file to use the
Apache::DBI as opposed to making a new DBD::mysql connection?
Thanks in advance to anyone who can help me understand this option!
Andy Lubel
OTRS 2.04 / MAC OSX 10.4.6
_______________________________________________
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
Support orr consulting for your OTRS system?
=> http://www.otrs.com/
