I have verified the database user I am providing has full permissions.<br><br>When exactly should Koha be creating the database tables? During configure? make install? or when I visit the install script via the intranet site?<br>
<br><div class="gmail_quote">On Wed, Mar 11, 2009 at 5:24 PM, Joe Atzberger <span dir="ltr"><<a href="mailto:ohiocore@gmail.com">ohiocore@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
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. <br><br>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.<br>
<br>--Joe <br><div><div></div><div class="h5"><br><div class="gmail_quote">On Wed, Mar 11, 2009 at 3:28 PM, Chris Alfano <span dir="ltr"><<a href="mailto:calfano@scienceleadership.org" target="_blank">calfano@scienceleadership.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi Everyone,<br><br>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<br><br>When I access the intranet URL to finish the setup, I am redirected to the install script and see:<br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote"><p>production mode - trapped fatal error</p></blockquote>/var/log/koha/koha-error_log says:<br>
<br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">[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.<br>
[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.<br>[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.<br>
[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.<br>[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.<br>
[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.<br></blockquote><br><br>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.<br>
<br>Where could I begin trying to debug this? Can I disable the error message suppression?<br><br>Thanks to anyone who can offer some insight.<br><br>Here is my intranet vhost configuration:<br><blockquote style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;" class="gmail_quote">
<VirtualHost *:80><br> ServerName <a href="http://koha.scienceleadership.org" target="_blank">koha.scienceleadership.org</a><br><br> ServerAdmin <a href="mailto:calfano@scienceleadership.org" target="_blank">calfano@scienceleadership.org</a><br>
DocumentRoot /usr/share/koha/intranet/htdocs<br> ScriptAlias /cgi-bin/koha/ "/usr/share/koha/intranet/cgi-bin/"<br> ScriptAlias /index.html "/usr/share/koha/intranet/cgi-bin/mainpage.pl"<br> ScriptAlias /search "/usr/share/koha/intranet/cgi-bin/search.pl"<br>
<br> <Directory "/usr/share/koha/intranet"><br> Options Indexes<br> AllowOverride None<br><br> Order allow,deny<br> Allow from all<br> </Directory><br><br> ErrorLog /var/log/koha/koha-error_log<br>
# TransferLog /var/log/koha/koha-access_log<br> SetEnv KOHA_CONF "/etc/koha/koha-conf.xml"<br> SetEnv PERL5LIB "/usr/share/koha/lib"<br> Options +FollowSymLinks<br><br> ErrorDocument 400 /cgi-bin/koha/errors/400.pl<br>
ErrorDocument 401 /cgi-bin/koha/errors/401.pl<br> ErrorDocument 403 /cgi-bin/koha/errors/403.pl<br> ErrorDocument 404 /cgi-bin/koha/errors/404.pl<br> ErrorDocument 500 /cgi-bin/koha/errors/500.pl<br><br> RewriteEngine On<br>
# Uncomment to turn on rewrite logging<br># RewriteLog /var/log/koha/koha-intranet-rewrite.log<br># RewriteLogLevel 1<br><br> RewriteCond %{QUERY_STRING} (.*?)(?:[A-Za-z0-9_-]+)=&(.*)<br> RewriteRule (.+) $1?%1%2 [N,R,NE]<br>
RewriteRule ^/bib/([^\/]*)/?$ /cgi-bin/koha/detail\.pl?bib=$1 [PT]<br> RewriteRule ^/isbn/([^\/]*)/?$ /search?q=isbn:$1 [PT]<br> RewriteRule ^/issn/([^\/]*)/?$ /search?q=issn:$1 [PT]<br></VirtualHost><br><br>
<VirtualHost *:80><br> ServerName <a href="http://library.scienceleadership.org" target="_blank">library.scienceleadership.org</a><br> ServerAdmin <a href="mailto:calfano@scienceleadership.org" target="_blank">calfano@scienceleadership.org</a><br>
<br> DocumentRoot /usr/share/koha/opac/htdocs<br><br> ScriptAlias /cgi-bin/koha/ "/usr/share/koha/opac/cgi-bin/opac/"<br> ScriptAlias /index.html "/usr/share/koha/opac/cgi-bin/opac/opac-main.pl"<br>
ScriptAlias /opac-search.pl "/usr/share/koha/opac/cgi-bin/opac/search"<br> ScriptAlias /search "/usr/share/koha/opac/cgi-bin/opac/search"<br><br> <Directory "/usr/share/koha/opac"><br>
Options Indexes<br> AllowOverride None<br><br> Order allow,deny<br> Allow from all<br> </Directory><br><br> ErrorLog /var/log/koha/koha-opac-error_log<br># TransferLog /var/log/koha/koha-opac-access_log<br>
SetEnv KOHA_CONF "/etc/koha/koha-conf.xml"<br> SetEnv PERL5LIB "/usr/share/koha/lib"<br> Options +FollowSymLinks<br><br> ErrorDocument 400 /cgi-bin/koha/errors/400.pl<br> ErrorDocument 401 /cgi-bin/koha/errors/401.pl<br>
ErrorDocument 403 /cgi-bin/koha/errors/403.pl<br> ErrorDocument 404 /cgi-bin/koha/errors/404.pl<br> ErrorDocument 500 /cgi-bin/koha/errors/500.pl<br><br># Rewrite Rules<br> RewriteEngine On<br><br># Uncomment to turn on rewrite logging<br>
# RewriteLog /var/log/koha/koha-opac-rewrite.log<br># RewriteLogLevel 1<br> RewriteCond %{QUERY_STRING} (.*?)(?:[A-Za-z0-9_-]+)=&(.*)<br> RewriteRule (.+) $1?%1%2 [N,R,NE]<br><br> RewriteRule ^/bib/([^\/]*)/?$ /cgi-bin/koha/opac-detail\.pl?bib=$1 [PT]<br>
RewriteRule ^/isbn/([^\/]*)/?$ /search?q=isbn:$1 [PT]<br> RewriteRule ^/issn/([^\/]*)/?$ /search?q=issn:$1 [PT]<br></VirtualHost><br></blockquote><font color="#888888"><br><br>-- <br>Best Regards,<br><br>Chris Alfano<br>
Systems Administrator<br>
Science Leadership Academy</font><br></blockquote></div><br>
<br></div></div><font color="#888888">--
<br>This message has been scanned for viruses and
<br>dangerous content by
<a href="http://www.mailscanner.info/" target="_blank"><b>MailScanner</b></a>, and is
<br>believed to be clean.
</font></blockquote></div><br><br clear="all"><br>-- <br>Best Regards,<br><br>Chris Alfano<br>