Web installer, database, Darwin (maybe other BSDs?), qx(), mysql
This is just a short note to let the list know that I've found a couple of problems with the installation process which affect at least Darwin, MacOS X installations and I wouldn't be surprised if other BSD-like systems had similar problems. Anyone managed to install successfully on one? 1. MARC::File::XML won't install under sudo perl -MCPAN. The make test step fails. Running as root works. Not sure why this is and I've no plans to debug it further. This had me mystified for far too long. 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. Galen has offered a few possible solutions (IPC::Open3, IPC::Cmd), I think I know some other possibles (DBIx modules and so on) and there's the solution I put in place last July that hdl rejected (pure DBI) if we get really stuck. I'll work through them until one works (starting with open3) unless anyone has a quick fix or sees a fatal flaw in any of them. I should have something coded in about 12 hours' time. Hope that helps someone, -- MJ Ray http://mjr.towers.org.uk/email.html tel:+44-844-4437-237 - Webmaster-developer, statistician, sysadmin, online shop builder, consumer and workers co-operative member http://www.ttllp.co.uk/ - Writing on koha, debian, sat TV, Kewstoke http://mjr.towers.org.uk/
Le 11 janv. 08 à 00:49, MJ Ray a écrit :
This is just a short note to let the list know that I've found a couple of problems with the installation process which affect at least Darwin, MacOS X installations and I wouldn't be surprised if other BSD-like systems had similar problems. Anyone managed to install successfully on one?
Works here on osx 10.5.1. Using MAMP (http://www.mamp.info) and a mixture of macports and direct install via CPAN.
1. MARC::File::XML won't install under sudo perl -MCPAN. The make test step fails. Running as root works. Not sure why this is and I've no plans to debug it further. This had me mystified for far too long.
What kind of probems do you get ?
sudo perl -MCPAN -e 'install MARC::File::XML'
worked for me.
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.
Didn't see this kind of problem. Tell me if there are things I can make to help you track theses issues. Best, Daniel
Bünzli Daniel <daniel.buenzli@erratique.ch> wrote:
Works here on osx 10.5.1. Using MAMP (http://www.mamp.info) and a mixture of macports and direct install via CPAN.
uname -a returns "Darwin hostname 8.10.1 Darwin Kernel Version 8.10.1: Wed May 23 16:33:00 PDT 2007; root:xnu-792.22.5~1/RELEASE_I386 i386 i386" and it's running a mixture of fink and CPAN install. I think it's an earlier 10.x. What's the uname for 10.5.1?
Le 11 janv. 08 à 00:49, MJ Ray a écrit :
1. MARC::File::XML won't install under sudo perl -MCPAN. The make test step fails. Running as root works. Not sure why this is and I've no plans to debug it further. This had me mystified for far too long.
What kind of probems do you get ?
Running make test PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/batch........ # Failed test 'use MARC::File::XML;' # at t/batch.t line 4. # Tried to use 'MARC::File::XML'. # Error: Unable to provide required features # Compilation failed in require at (eval 3) line 2. # BEGIN failed--compilation aborted at t/batch.t line 4. t/batch........NOK 1/23 t/batch........ok 2/23 Can't call method "parse_string" on unblessed reference at /Users/admin/.cpan/build/MARC-XML-0.88/blib/lib/MARC/File/XML.pm line 448. # Looks like you planned 23 tests but only ran 3. # Looks like you failed 1 test of 3 run. # Looks like your test died just after 3. t/batch........dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1, 4-23 Failed 21/23 tests, 8.70% okay [...] Failed Test Stat Wstat Total Fail List of Failed ------------------------------------------------------------------------------- t/batch.t 255 65280 23 41 1 4-23 t/encode.t 2 512 ?? ?? ?? t/escape.t 7 1792 10 7 1-4 8-10 t/namespace.t 255 65280 1 2 1 t/subfield0.t 255 65280 1 2 1 Failed 5/5 test scripts. 30/35 subtests failed. Files=5, Tests=35, 1 wallclock secs ( 0.42 cusr + 0.10 csys = 0.52 CPU) Failed 5/5 test programs. 30/35 subtests failed. make: *** [test_dynamic] Error 255 /usr/bin/make test -- NOT OK Running make install make test had returned bad status, won't install without force
sudo perl -MCPAN -e 'install MARC::File::XML' worked for me.
That's the same command I used. [...]
Tell me if there are things I can make to help you track theses issues.
Thanks for any help, -- MJ Ray http://mjr.towers.org.uk/email.html tel:+44-844-4437-237 - Webmaster-developer, statistician, sysadmin, online shop builder, consumer and workers co-operative member http://www.ttllp.co.uk/ - Writing on koha, debian, sat TV, Kewstoke http://mjr.towers.org.uk/
Le 11 janv. 08 à 11:17, MJ Ray a écrit :
I think it's an earlier 10.x.
According to this page [1] this must be 10.4.11
What's the uname for 10.5.1?
uname -a Darwin Heyho.local 9.1.0 Darwin Kernel Version 9.1.0: Wed Oct 31 17:48:21 PDT 2007; root:xnu-1228.0.2~1/RELEASE_PPC Power Macintosh
Running make test PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/batch........ [...]
No idea. Random thought, are you using libxml's sax parser as was suggested to me in this message [2]. Best, Daniel [1] http://en.wikipedia.org/wiki/Darwin_(operating_system) [2] http://lists.katipo.co.nz/public/koha/2008-January/012912.html
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.
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 -- View this message in context: http://www.nabble.com/Web-installer%2C-database%2C-Darwin-%28maybe-other-BSD... Sent from the Koha - Dev mailing list archive at Nabble.com.
On Feb 13, 2008 7:09 AM, custard <custard@westnet.com.au> 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
Chris Nighswonger wrote:
On Feb 13, 2008 7:09 AM, custard <custard@westnet.com.au> 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.
Is there anything I can do to help out with this problem? (I'm assuming that there's still a problem at this step) I'm no good at coding, but reasonable at testing things out, and have a little familarity with linux-esqe things so I can extract some informaiton about what's going on. custard -- View this message in context: http://www.nabble.com/Web-installer%2C-database%2C-Darwin-%28maybe-other-BSD... Sent from the Koha - Dev mailing list archive at Nabble.com.
participants (4)
-
Bünzli Daniel -
Chris Nighswonger -
custard -
MJ Ray