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

Karl Hiramoto karl at hiramoto.org
Tue Jul 12 07:36:23 PDT 2005


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





-- 

---
Karl Hiramoto <karl at hiramoto.org>
US VOIP: (1) 603.966.4448
Spain Casa  (34) 952.827.554
Spain Mobil (34) 617.463.826
Yahoo_IM = karl_hiramoto   jabber.org=karl_hiramoto
------
-
printk("MASQUERADE: No route: Rusty's brain broke!\n");
        linux-2.4.3/net/ipv4/netfilter/ipt_MASQUERADE.c

-------------- next part --------------
A non-text attachment was scrubbed...
Name: karl.vcf
Type: text/x-vcard
Size: 202 bytes
Desc: not available
Url : http://420.am/pipermail/freeside-users/attachments/20050712/37ed2cf9/karl.vcf


More information about the freeside-users mailing list