[freeside-users] Problems with new freeside installation (fixed)

Sun Dec 4 21:29:33 PST 2005

You don't need to downgrade.
Just create the database and do:
SET default_with_oids = true;

Dan Roberts wrote:

>OK, so postgresql 8.1.0 has "oid" turned off by default and
>freeside-setup could not properly create the tables.
>
>I downgraded to postgresql 7.4.9 and now it works fine:  Thanks!!
>
>
>
>
>
>  
>
>>On Wed, Nov 16, 2005 at 10:03:51PM +0530, Shivkumar wrote:
>>    
>>
>>>I think its in the mailing list somewhere that you have to downgrade to
>>>HTML::Mason 1.28
>>>      
>>>
>>Only for RT (fixed in CVS and will be in 1.5.8).
>>
>>The error below is coming from Postgres and seems to indicate that the 
>>database doesn't exist at all,  Perhaps freeside-setup wasn't run or the 
>>connection settings are pointing to the wrong database.
>>
>>-- 
>>_ivan
>>
>>
>>    
>>
>>>Dan Roberts said the following:
>>>
>>>      
>>>
>>>>Hello
>>>>I have been trying for some time to get a freeside 1.5.7 installation
>>>>running.  Here's my lates effort:
>>>>
>>>>A freshly formatted hard drive with a clean install of Slackware 10.2.
>>>>Apache_1.3.33 with mod_ssl-2.8.24/openssl-0.9.8a and mod_perl-1.29,
>>>>running as a separate instance of httpd under the user freeside.
>>>>Postgresql-8.1.0 with DBD-Pg-1.43 ok.
>>>>DBI-1.48 and all other perl modules and dependencies carefully
>>>>        
>>>>
>installed.
>  
>
>>>>HTML::Mason version 1.3101
>>>>
>>>>After completing all of the installation procedures I can log in to the
>>>>web browser, go to the configuration page.
>>>>
>>>>But, when I try to access any .cgi pages (such as the next step in the
>>>>Administration instructions which is "View/Edit Service
>>>>        
>>>>
>definitions," an
>  
>
>>>>error message is returned:
>>>>
>>>>*****************************************************************
>>>>System error
>>>>error:  	ERROR: relation "part_virtual_field" does not exist
>>>>at /usr/lib/perl5/site_perl/5.8.7/FS/Record.pm line 1536
>>>>FS::Record::virtual_fields('FS::part_svc') called at
>>>>/usr/lib/perl5/site_perl/5.8.7/FS/Record.pm line 228
>>>>FS::Record::qsearch('part_svc', 'HASH(0x9b649cc)') called at
>>>>/var/www/freeside/browse/part_svc.cgi line 12
>>>>HTML::Mason::Commands::__ANON__() called at
>>>>/usr/lib/perl5/site_perl/5.8.7/HTML/Mason/Component.pm line 135
>>>>        
>>>>
>>HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x9c61d48)')
>>    
>>
>>>>called at /usr/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line
>>>>        
>>>>
>1255
>  
>
>>>>eval {...} called at
>>>>/usr/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 1249
>>>>HTML::Mason::Request::comp('undef', 'undef') called at
>>>>/usr/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 916
>>>>        
>>>>
>>HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x9c42548)')
>>    
>>
>>>>called at /var/www/freeside/autohandler line 1
>>>>HTML::Mason::Commands::__ANON__() called at
>>>>/usr/lib/perl5/site_perl/5.8.7/HTML/Mason/Component.pm line 135
>>>>        
>>>>
>>HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x9c42104)')
>>    
>>
>>>>called at /usr/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line
>>>>        
>>>>
>1250
>  
>
>>>>eval {...} called at
>>>>/usr/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 1249
>>>>HTML::Mason::Request::comp('undef', 'undef', 'undef') called at
>>>>/usr/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 461
>>>>eval {...} called at
>>>>/usr/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 461
>>>>eval {...} called at
>>>>/usr/lib/perl5/site_perl/5.8.7/HTML/Mason/Request.pm line 413
>>>>        
>>>>
>>HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x9c42548)')
>>    
>>
>>>>called at /usr/lib/perl5/site_perl/5.8.7/HTML/Mason/ApacheHandler.pm
>>>>line 167
>>>>        
>>>>
>>HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x9c42548)')
>>    
>>
>>>>called at /usr/lib/perl5/site_perl/5.8.7/HTML/Mason/ApacheHandler.pm
>>>>line 817
>>>>        
>>>>
>>HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x87a48e8)',
>>    
>>
>>>>'Apache=SCALAR(0x9aac87c)') called at
>>>>        
>>>>
>/usr/local/etc/freeside/handler.pl
>  
>
>>>>line 306
>>>>eval {...} called at /usr/local/etc/freeside/handler.pl line 306
>>>>HTML::Mason::handler('Apache=SCALAR(0x9aac87c)') called at
>>>>        
>>>>
>/dev/null line 0
>  
>
>>>>eval {...} called at /dev/null line 0
>>>>context:  	
>>>>...  	
>>>>266:  	# or simply report the caller's package (croak() and carp()),
>>>>respectively.
>>>>267:  	# confess() and croak() die, carp() and cluck() warn.
>>>>268:  	
>>>>269:  	sub croak { die shortmess @_ }
>>>>270:  	sub confess { die longmess @_ }
>>>>271:  	sub carp { warn shortmess @_ }
>>>>272:  	sub cluck { warn longmess @_ }
>>>>273:  	
>>>>274:  	1;
>>>>...  	
>>>>code stack:  	/usr/lib/perl5/5.8.7/Carp.pm:270
>>>>/usr/lib/perl5/site_perl/5.8.7/FS/Record.pm:1536
>>>>/usr/lib/perl5/site_perl/5.8.7/FS/Record.pm:228
>>>>/var/www/freeside/browse/part_svc.cgi:12
>>>>/var/www/freeside/autohandler:1
>>>>*****************************************************************
>>>>
>>>>other .cgi pages return similar errors, mostly starting with the
>>>>phrase--  relation "part_virtual_field" does not exist.
>>>>
>>>>Can you offer any help with this?  Much appreciated 
>>>>
>>>>        
>>>>
>>_______________________________________________
>>freeside-users mailing list
>>freeside-users at sisd.com
>>http://420.am/cgi-bin/mailman/listinfo/freeside-users
>>
>>
>>    
>>
>
>  
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://420.am/pipermail/freeside-users/attachments/20051205/29e02211/attachment.htm