
Mabuhay! I am having trouble running the index.pl in /bin/cgi-bin. When viewed in the web, i have the following message: Software error: install_driver(mysql) failed: [Wed Sep 18 19:18:17 2002] index.pl: Can't locate DBD/mysql.pm in @INC (@INC contains: ../ ../../../ /usr/local/OpenTRS/bin/cgi-bin/../.. /usr/libdata/perl/5.00503/mach /usr/libdata/perl/5.00503 /usr/local/lib/perl5/site_perl/5.005/i386-freebsd /usr/local/lib/perl5/site_perl/5.005 .) at (eval 124) line 3. Perhaps the DBD::mysql perl module hasn't been fully installed, or perhaps the capitalisation of 'mysql' isn't right. Available drivers: ExampleP, Pg, Proxy. at /usr/local/OpenTRS/bin/cgi-bin/../../Kernel/System/DB.pm line 67 In the debugger, i have the following error: main::(index.pl:80): $CommonObject{LayoutObject} = Kernel::Output::HTML::Generic->new(%CommonObject); DB<1> n main::(index.pl:81): $CommonObject{DBObject} = Kernel::System::DB->new(%CommonObject); DB<1> n Content-type: text/html <H1>Software error:</H1> <CODE>install_driver(mysql) failed: [Wed Sep 18 19:29:40 2002] index.pl: Can't locate DBD/mysql.pm in @INC (@INC contains: ../ ../../../ /usr/local/OpenTRS/bin/cgi-bin/../.. /usr/libdata/perl/5.00503/mach /usr/libdata/perl/5.00503 /usr/local/lib/perl5/site_perl/5.005/i386-freebsd /usr/local/lib/perl5/site_perl/5.005 .) at (eval 143) line 3. Perhaps the DBD::mysql perl module hasn't been fully installed, or perhaps the capitalisation of 'mysql' isn't right. Available drivers: ExampleP, Pg, Proxy. at /usr/local/OpenTRS/bin/cgi-bin/../../Kernel/System/DB.pm line 67 </CODE> <P> For help, please send mail to this site's webmaster, giving this error message and the time and date of the error. [Wed Sep 18 19:29:40 2002] index.pl: install_driver(mysql) failed: [Wed Sep 18 19:29:40 2002] index.pl: Can't locate DBD/mysql.pm in @INC (@INC contains: ../ ../../../ /usr/local/OpenTRS/bin/cgi-bin/../.. /usr/libdata/perl/5.00503/mach /usr/libdata/perl/5.00503 /usr/local/lib/perl5/site_perl/5.005/i386-freebsd /usr/local/lib/perl5/site_perl/5.005 .) at (eval 143) line 3. [Wed Sep 18 19:29:40 2002] index.pl: Perhaps the DBD::mysql perl module hasn't been fully installed, [Wed Sep 18 19:29:40 2002] index.pl: or perhaps the capitalisation of 'mysql' isn't right. [Wed Sep 18 19:29:40 2002] index.pl: Available drivers: ExampleP, Pg, Proxy. [Wed Sep 18 19:29:40 2002] index.pl: at /usr/local/OpenTRS/bin/cgi-bin/../../Kernel/System/DB.pm line 67 Debugged program terminated. Use q to quit or R to restart, use O inhibit_exit to avoid stopping after program termination, h q, h R or h O to get additional info. DB<1> Im testing in a machine with the following specs: FreeBSD-4.4, Apache-1.3.26, PHP-4.2.1, Postgresql-7.1 with apache configure with a --without-mysql coz i want to use postgresql. Is there something in the config file that i've missed? Is otrs been proven to run using mysql? Please advise me if you know this thing.... Im new to otrs :-) Salamat Po! -Edwin ================================ If others think ten minutes ahead; Filipinos must think 10 years ahead; -- Edwin D. Vinas http://www.geocities.com/edwin_vinas ================================

Hi Edwin, On Wed, Sep 18, 2002 at 07:46:16PM +0800, =?iso-8859-1?Q?Edwin_D. _Vi=F1as?= wrote:
I am having trouble running the index.pl in /bin/cgi-bin. When viewed in the web, i have the following message: Software error: install_driver(mysql) failed: [Wed Sep 18 19:18:17 2002] index.pl: Can't locate DBD/mysql.pm [...]
Im testing in a machine with the following specs: FreeBSD-4.4, Apache-1.3.26, PHP-4.2.1, Postgresql-7.1 with apache configure with a --without-mysql coz i want to use postgresql.
Is there something in the config file that i've missed? Is otrs been proven to run using mysql? Please advise me if you know this thing.... Im new to otrs :-)
If you want to user postgresql, change the DatabaseDSN in Kernel/Config.pm [...] # (The database DSN for PostgrSQL ==> more: "man DBD::Pg") $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};"; [...] default is MySQL: [...] # (The database DSN for MySQL ==> more: "man DBD::mysql") $Self->{DatabaseDSN} = "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};"; [...] And of course you have to install a few perl modules (like DBI, DBD::Pg, MIME::Tools) from CPAN ("perl -MCPAN -e shell;"). If you need help with CPAN try http://www.cpan.org/ -=> FAQ. Or ask us.
Salamat Po! -Edwin [...] http://www.geocities.com/edwin_vinas
PS: Nice homepage! :) Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- nohl: 2:53pm up 4 days, 7:30, 4 users, load average: 0.13, 0.13, 0.04
participants (2)
-
Edwin D. Viñas
-
Martin Edenhofer