[Koha] Export Data tool fails (only tool that fails)- ver 23.11.06

[David Nind]

Hi Evan.

Glad you managed to get the export working with the command line script!

Hopefully, others will help troubleshoot why the export tool in the staff
interface is not working - whether Apache config settings need changing, if
it is something else, or if it is a bug that needs fixing.

David Nind

On Sat, 20 Jul 2024 at 10:46, Evan Stewart <evanstewart406 at gmail.com> wrote:

> Update,
>
> I was able to export a .mrc file using the koha-shell. I needed to change
> the directory I was in when I entered the shell. In case someone else tries
> this method, I did:
>
>
>    - sudo koha-shell instanceName
>    - cd ~
>       - this will get back to koha-shell's home directory
>    - /usr/share/koha/bin/export_records.pl --format marc --record-type
>    bibs --filename my-file-name.mrc
>       - After several minutes the export completed.
>    - exit
>    - ls /var/lib/koha/instanceName/
>       - the file was found in this directory
>
> The front end Export tool is still failing, but I'll see if I can use the
> terminal export for a work around.
>
> -Evan
>
> On Fri, Jul 19, 2024 at 4:27 PM Evan Stewart <evanstewart406 at gmail.com>
> wrote:
>
>> All,
>>
>> I checked the Apache config settings. I have:
>>
>> Timeout 300 (seconds)
>> KeepAlive On
>> MaxKeepAliveRequests 100
>> KeepAliveTimeout 5 (seconds)
>>
>> -Evan
>>
>>
>> On Fri, Jul 19, 2024 at 4:18 PM Evan Stewart <evanstewart406 at gmail.com>
>> wrote:
>>
>>> HI David,
>>>
>>> Thank you. I'll look into the Apache settings as well. That reminds me
>>> of a similar issue I had with a PHP application and the problem was PHP
>>> execution time settings.
>>>
>>> Also, I located an error message in the log. Looks like I'm getting a
>>> permission denied error for exports.pl.
>>>
>>> *[cgid:error] [pid 554389:tid 554389] (13)Permission denied: [client
>>> 172.56.200.129:42349 <http://172.56.200.129:42349>] AH01257: stderr from
>>> /usr/share/koha/intranet/cgi-bin/tools/export.pl <http://export.pl>: unable
>>> to connect to cgi daemon after multiple tries, referer:
>>> http://Ipaddress:8081/cgi-bin/koha/tools/inventory.pl
>>> <http://Ipaddress:8081/cgi-bin/koha/tools/inventory.pl>*
>>>
>>> When I checked the permission for the file, they are the same as other
>>> files in the "... /cgi-bin/tools" directory. The file inventory.pl
>>> permissions are the same as export.pl. The inventory page works on the
>>> front end.
>>>
>>> -Evan
>>>
>>> On Fri, Jul 19, 2024 at 3:50 PM David Nind <david at davidnind.com> wrote:
>>>
>>>> Hi Evan.
>>>>
>>>> It's a long time since I've dealt with Apache server errors and the 503
>>>> error you are getting, but here are some things to look at:
>>>>
>>>> - As you have tried with plenty of server memory, it's not likely to be
>>>> that. It may be something to do with how Apache is configured - including
>>>> settings like the Timeout, KeepAlive, MaxKeepAliveRequests,
>>>> KeepAliveTimeout settings.
>>>>
>>>> - I would look at the Apache server logs to see if there is something
>>>> more in there about the cause of the issue.
>>>>
>>>> - If your server is behind a firewall, proxy servers, or caches
>>>> (something I don't know much about) then that may be contributing as well.
>>>>
>>>> It may also be a Koha bug, but 63,000 items is not that large, and I
>>>> couldn't find a bug about performance issues when exporting the catalog.
>>>>
>>>> For running the misc/export_records.pl script from the command line,
>>>> then outputting to the terminal instead of saving to the file, this may be
>>>> a file permission error (well, that's what my searching says).
>>>>
>>>> In my local development environment testing, it was saving the file to
>>>> where I ran the command line from. So maybe changing the path of the file
>>>> to somewhere where the user you are running the command with has permission
>>>> may work.
>>>>
>>>> I'm not a system admin, so hopefully more experienced Koha system
>>>> administrators can share what they would try to troubleshoot the issues you
>>>> are having.
>>>>
>>>> David Nind
>>>> New Zealand
>>>>
>>>