[OPEN-ILS-GENERAL] Wowbrary Script Error

[Melissa Ceraso]

Chris and Justin,

Thanks for the helpful tips! Much appreciated!

All the best,

Melissa

Melissa Ceraso
Evergreen Systems Manager
Bibliomation, Inc.
24 Wooster Ave.
Waterbury, CT 06708
203-577-4070 ext. 116

On Wed, Mar 16, 2016 at 12:31 PM, Justin Hopkins 📖 <
justin at mobiusconsortium.org> wrote:

> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20160316/6bb2e4de/attachment.html>