[OPEN-ILS-GENERAL] Wowbrary Script Error

[Justin Hopkins 📖]

Melissa,

You might try running the command by hand (the exact command you have
in cron) with the user who's crontab it is in. That user may not have
the same environment or database permissions as your user on the
system where it's working.

Justin

On Wed, Mar 16, 2016 at 11:20 AM, Melissa Ceraso <mceraso at biblio.org> wrote:
> Hello,
>
> We altered a Wowbrary SQL script to fix a few errors that were occurring for
> some of our Wowbrary subscribers. The amended script runs fine on our
> database server. Yet, since it has been applied to our utility server to run
> as a cron job, we are consistently receiving the following error message:
>
> 53: ERROR:  permission denied for relation record_sorter
>
> At this point, we cannot figure out why the script runs fine on the
> database, but fails during the cron job. Any thoughts, ideas or even a lead
> as to where I should start investigating further would be greatly
> appreciated! Also, if further information is needed, I can certainly provide
> more.
>
> All the best,
>
> Melissa
>
> Melissa Ceraso
> Evergreen Systems Manager
> Bibliomation, Inc.
> 24 Wooster Ave.
> Waterbury, CT 06708
> 203-577-4070 ext. 116



-- 
Regards,
Justin