On Wed, Mar 11, 2009 at 5:24 PM, Joe Atzberger <ohiocore@gmail.com> wrote:

Koha is not widely tested with mod_perl and I believe some of its dependencies are not mod_perl safe. So you should not expect a stable installation with it.

But it looks like you never finished the make install portion, perhaps because you haven't granted adequate permissions to the user in your KOHA_CONF file.

--Joe

On Wed, Mar 11, 2009 at 3:28 PM, Chris Alfano <calfano@scienceleadership.org> wrote:

Hi Everyone,

I just setup Koha on a Gentoo machine running Apache 2.2.10 / mod_perl 2.0.3-r2 / Perl 5.8.8-r5 / MySQL 5.0 plus all the CPAN modules reported by Makefile.PL

When I access the intranet URL to finish the setup, I am redirected to the install script and see:

production mode - trapped fatal error
/var/log/koha/koha-error_log says:

[Wed Mar 11 14:10:17 2009] [error] [client 170.235.0.111] [Wed Mar 11 14:10:17 2009] install.pl: DBD::mysql::st execute failed: Table 'koha.language_subtag_registry' doesn't exist at /usr/share/koha/lib/C4/Languages.pm line 178.
[Wed Mar 11 14:10:17 2009] [error] [client 170.235.0.111] [Wed Mar 11 14:10:17 2009] install.pl: DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/share/koha/lib/C4/Languages.pm line 179.
[Wed Mar 11 14:10:17 2009] [error] [client 170.235.0.111] [Wed Mar 11 14:10:17 2009] install.pl: DBD::mysql::db selectrow_array failed: Table 'koha.systempreferences' doesn't exist at /usr/share/koha/lib/C4/Context.pm line 479.
[Wed Mar 11 14:10:17 2009] [error] [client 170.235.0.111] [Wed Mar 11 14:10:17 2009] install.pl: Use of uninitialized value in string eq at /usr/share/koha/lib/C4/Context.pm line 45.
[Wed Mar 11 14:10:17 2009] [error] [client 170.235.0.111] [Wed Mar 11 14:10:17 2009] install.pl: Use of uninitialized value in string eq at /usr/share/koha/lib/C4/Context.pm line 45.
[Wed Mar 11 14:10:17 2009] [error] [client 170.235.0.111] [Wed Mar 11 14:10:17 2009] install.pl: Can't call method "id" on an undefined value at InstallAuth.pm line 278.

The installer is not creating any tables in the MySQL database. I used all default values for Makefile.PL except for the DB specifics and have confirmed the configuration by copying and pasting the DB values from /etc/koha/koha-conf.xml into the command line mysql client and was able to create and manipulate tables just fine. The fact that I am seeing table doesn't exist errors instead of access denied tells me that it is connecting to MySQL alright.

Where could I begin trying to debug this? Can I disable the error message suppression?

Thanks to anyone who can offer some insight.

Here is my intranet vhost configuration:
<VirtualHost *:80>
   ServerName koha.scienceleadership.org

   ServerAdmin calfano@scienceleadership.org
   DocumentRoot /usr/share/koha/intranet/htdocs
   ScriptAlias /cgi-bin/koha/ "/usr/share/koha/intranet/cgi-bin/"
   ScriptAlias /index.html "/usr/share/koha/intranet/cgi-bin/mainpage.pl"
   ScriptAlias /search "/usr/share/koha/intranet/cgi-bin/search.pl"

   <Directory "/usr/share/koha/intranet">
      Options Indexes
      AllowOverride None

      Order allow,deny
      Allow from all
   </Directory>

   ErrorLog /var/log/koha/koha-error_log
# TransferLog /var/log/koha/koha-access_log
   SetEnv KOHA_CONF "/etc/koha/koha-conf.xml"
   SetEnv PERL5LIB "/usr/share/koha/lib"
   Options +FollowSymLinks

   ErrorDocument 400 /cgi-bin/koha/errors/400.pl
   ErrorDocument 401 /cgi-bin/koha/errors/401.pl
   ErrorDocument 403 /cgi-bin/koha/errors/403.pl
   ErrorDocument 404 /cgi-bin/koha/errors/404.pl
   ErrorDocument 500 /cgi-bin/koha/errors/500.pl

   RewriteEngine On
# Uncomment to turn on rewrite logging
# RewriteLog /var/log/koha/koha-intranet-rewrite.log
# RewriteLogLevel 1

   RewriteCond %{QUERY_STRING} (.*?)(?:[A-Za-z0-9_-]+)=&(.*)
   RewriteRule (.+) $1?%1%2 [N,R,NE]
   RewriteRule ^/bib/([^\/]*)/?$ /cgi-bin/koha/detail\.pl?bib=$1 [PT]
   RewriteRule ^/isbn/([^\/]*)/?$ /search?q=isbn:$1 [PT]
   RewriteRule ^/issn/([^\/]*)/?$ /search?q=issn:$1 [PT]
</VirtualHost>

<VirtualHost *:80>
   ServerName library.scienceleadership.org
   ServerAdmin calfano@scienceleadership.org

   DocumentRoot /usr/share/koha/opac/htdocs

   ScriptAlias /cgi-bin/koha/ "/usr/share/koha/opac/cgi-bin/opac/"
   ScriptAlias /index.html "/usr/share/koha/opac/cgi-bin/opac/opac-main.pl"
   ScriptAlias /opac-search.pl "/usr/share/koha/opac/cgi-bin/opac/search"
   ScriptAlias /search "/usr/share/koha/opac/cgi-bin/opac/search"

   <Directory "/usr/share/koha/opac">
      Options Indexes
      AllowOverride None

      Order allow,deny
      Allow from all
   </Directory>

   ErrorLog /var/log/koha/koha-opac-error_log
# TransferLog /var/log/koha/koha-opac-access_log
   SetEnv KOHA_CONF "/etc/koha/koha-conf.xml"
   SetEnv PERL5LIB "/usr/share/koha/lib"
   Options +FollowSymLinks

   ErrorDocument 400 /cgi-bin/koha/errors/400.pl
   ErrorDocument 401 /cgi-bin/koha/errors/401.pl
   ErrorDocument 403 /cgi-bin/koha/errors/403.pl
   ErrorDocument 404 /cgi-bin/koha/errors/404.pl
   ErrorDocument 500 /cgi-bin/koha/errors/500.pl

# Rewrite Rules
   RewriteEngine On

# Uncomment to turn on rewrite logging
# RewriteLog /var/log/koha/koha-opac-rewrite.log
# RewriteLogLevel 1
   RewriteCond %{QUERY_STRING} (.*?)(?:[A-Za-z0-9_-]+)=&(.*)
   RewriteRule (.+) $1?%1%2 [N,R,NE]

   RewriteRule ^/bib/([^\/]*)/?$ /cgi-bin/koha/opac-detail\.pl?bib=$1 [PT]
   RewriteRule ^/isbn/([^\/]*)/?$ /search?q=isbn:$1 [PT]
   RewriteRule ^/issn/([^\/]*)/?$ /search?q=issn:$1 [PT]
</VirtualHost>

--
Best Regards,

Chris Alfano
Systems Administrator
Science Leadership Academy

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.