Re: [Koha-devel] Web installer, database, Darwin (maybe other BSDs?), qx(), mysql

[Chris Nighswonger]

On Feb 13, 2008 7:09 AM, custard <address@hidden> wrote:
>
> I've just hit something that looks a lot like this bit.
>
>
>
> MJ Ray-2 wrote:
> >
> > 2. the web installer can't invoke the mysql command-line client. The
> > error is like "sh: line 1: -u: command not found" and appears once for
> > each SQL file.  I think this is the portability problem described in
> > man perlop under the qx subheading.  It's very similar to a problem in
> > the 2.x installer.
> >

This issue exists when running the installer on Win32 as well. I ran across the
same documentation mentioned by MJ. IMHO the import section of the installer
needs to be refactored to use DBI calls to handle all db schema/data imports.
Or perhaps there is another yet better way.

>
> I'm at step3 ("GET
> /cgi-bin/koha/installer/install.pl?step=3&op=importdatastructure HTTP/1.1"
> 200 1791) on the web installer. The screen reads :
>
> The following error occcurred while importing the database structure:
> sh: mysql: command not found
> Please contact your system administrator
>
> and the Koha-errors.log says:
>
> [Wed Feb 13 20:39:07 2008] [error] [client 192.168.14.5] [Wed Feb 13
> 20:39:07 2008] Output.pm: Useless use of private variable in void context at
> /usr/share/koha/lib/C4/Output.pm line 160., referer:
> http://192.168.14.5:8080/cgi-bin/koha/installer/install.pl?step=3
> [Wed Feb 13 20:39:07 2008] [error] [client 192.168.14.5] [Wed Feb 13
> 20:39:07 2008] install.pl: DBD::mysql::st execute failed: Table
> 'koha.language_subtag_registry' doesn't exist at
> /usr/share/koha/lib/C4/Languages.pm line 163., referer:
> http://192.168.14.5:8080/cgi-bin/koha/installer/install.pl?step=3
> [Wed Feb 13 20:39:07 2008] [error] [client 192.168.14.5] [Wed Feb 13
> 20:39:07 2008] install.pl: DBD::mysql::st fetchrow_hashref failed: fetch()
> without execute() at /usr/share/koha/lib/C4/Languages.pm line 164., referer:
> http://192.168.14.5:8080/cgi-bin/koha/installer/install.pl?step=3
>
> (which looks an awful lot like what it has on transition to every previous
> page.) There are not additional notes in the apache logs.
>
> custard
> Darwin Kernel Version 9.2.0

Not sure about the error thrown by Output.pm, but those related to Languages.pm
are *routine* during installation.


Regards,
Chris

-- 
Chris Nighswonger
Faculty Member
Network & Systems Director
Foundations Bible College & Seminary
www.foundations.edu
www.fbcradio.org