[freeside-users] ERROR: permission denied for relation reg_code with apache2 mod_perl2

[Shivkumar]

methinks that you  forgot   to  do the  grant  thing (for  the  
freeside  user)  in  postgresql  when you upgraded  the  database  schema.
regards,
shiv

Karl Hiramoto said the following:

> My system I know is a little bleading edge, but was hoping someone 
> would know if this was a simple fix.
> I took my working DB from freeside 1.5.0pre6  and  followed the doc on 
> upgrading the db for freeside 1.5.7.
>
> The error is on the new system running FS 1.5.7
>
> Thanks
>
> My system.
> Apache/2.0.54 (Gentoo/Linux) mod_ssl/2.0.54 OpenSSL/0.9.7e PHP/4.3.11 
> mod_perl/2.0.1 Perl/v5.8.6
> HTML-Mason-1.29_02
>
> Most pages work correctly.  I have an error on the page  " View/Edit 
> agents"
> http://host.com/freeside/browse/agent.cgi
>
>
> System error
> error:      ERROR: permission denied for relation reg_code
> context:     ...     321:      my $self = shift;
> 322:      my $sth = dbh->prepare(
> 323:      "SELECT COUNT(*) FROM reg_code WHERE agentnum = ?"
> 324:      ) or die dbh->errstr;
> 325:      $sth->execute($self->agentnum) or die $sth->errstr;
> 326:      $sth->fetchrow_arrayref->[0];
> 327:      }
> 328:     329:      =item num_prepay_credit
> ...     code stack:      /usr/lib/perl5/site_perl/5.8.6/FS/agent.pm:325
> host/freeside/browse/agent.cgi:157
> host/freeside/autohandler:1
>
>
>
>
> ERROR:  permission denied for relation reg_code
>
>
> Trace begun at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Exceptions.pm 
> line 128
> HTML::Mason::Exceptions::rethrow_exception('ERROR:  permission denied 
> for relation reg_code^J') called at 
> /usr/lib/perl5/site_perl/5.8.6/FS/agent.pm line 325
> FS::agent::num_reg_code('FS::agent=HASH(0x9d81fcc)') called at 
> /karl/home/freeside/public_html/admin-freeside/browse/agent.cgi line 157
> HTML::Mason::Commands::__ANON__ at 
> /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Component.pm line 134
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x9d60a38)') 
> called at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line 1232
> eval {...} at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm 
> line 1226
> HTML::Mason::Request::comp(undef, undef) called at 
> /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line 898
> HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x9c72300)') 
> called at /karl/home/freeside/public_html/admin-freeside/autohandler 
> line 1
> HTML::Mason::Commands::__ANON__ at 
> /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Component.pm line 134
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x9d6f374)') 
> called at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line 1227
> eval {...} at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm 
> line 1226
> HTML::Mason::Request::comp(undef, undef, undef) called at 
> /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line 458
> eval {...} at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm 
> line 458
> eval {...} at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm 
> line 410
> HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x9c72300)') 
> called at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/ApacheHandler.pm 
> line 160
> HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x9c72300)') 
> called at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/ApacheHandler.pm 
> line 806
> HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x9b39090)', 
> 'Apache2::RequestRec=SCALAR(0x9bd4068)') called at 
> /usr/local/etc/freeside/handler.pl line 305
> eval {...} at /usr/local/etc/freeside/handler.pl line 305
> HTML::Mason::handler('Apache2::RequestRec=SCALAR(0x9bd4068)') called 
> at -e line 0
> eval {...} at -e line 0
>
>
>
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>freeside-users mailing list
>freeside-users at sisd.com
>http://420.am/cgi-bin/mailman/listinfo/freeside-users
>  
>