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

[Karl Hiramoto]

Yes,   I dropped my DB, and recreated from scratch and it works..    I 
have about 20 users now i need to reimport..

So seems to work with apache2 and mod_perl2 so far.



Shivkumar wrote:

> 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
>>  
>>
> _______________________________________________
> freeside-users mailing list
> freeside-users at sisd.com
> http://420.am/cgi-bin/mailman/listinfo/freeside-users
>


-- 

---
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
------
-
I have a theory that it's impossible to prove anything, but I can't prove it.

-------------- 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/f3bff072/karl.vcf