[OPEN-ILS-GENERAL] Wowbrary Script Error

[Chris Sharp]

Melissa,

Sounds like the database user for the cron script doesn't have the proper permissions for the record_sorter table.  You'll need to GRANT the proper perms to that user (see http://www.postgresql.org/docs/current/static/sql-grant.html - making sure to select the correct PostgreSQL version at the top of the page).

I hope that helps get you on the right path!

Chris

----- Original Message -----
> From: "Melissa Ceraso" <mceraso at biblio.org>
> To: "Evergreen Discussion Group" <open-ils-general at list.georgialibraries.org>
> Sent: Wednesday, March 16, 2016 12:20:29 PM
> Subject: [OPEN-ILS-GENERAL] Wowbrary Script Error
> 
> 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
> 

-- 
Chris Sharp
PINES System Administrator
Georgia Public Library Service
1800 Century Place, Suite 150
Atlanta, Georgia 30345
(404) 235-7147
csharp at georgialibraries.org
http://pines.georgialibraries.org/