[Koha] Installer not creating database tables
Chris Alfano
calfano at scienceleadership.org
Sun Mar 22 10:16:31 NZDT 2009
I have verified the database user I am providing has full permissions.
When exactly should Koha be creating the database tables? During configure?
make install? or when I visit the install script via the intranet site?
On Wed, Mar 11, 2009 at 5:24 PM, Joe Atzberger <ohiocore at 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 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
>>
>
>
> --
> This message has been scanned for viruses and
> dangerous content by *MailScanner* <http://www.mailscanner.info/>, and is
> believed to be clean.
--
Best Regards,
Chris Alfano
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090321/2cc4869e/attachment.htm
More information about the Koha
mailing list