[Koha] Installer not creating database tables

[Joe Atzberger]

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 at 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 at 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 at 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090311/89328265/attachment-0001.htm