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

[Dan Roberts]

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
> 
> 

--