[freeside-users] Problems with new freeside installation (fixed)
Dan Roberts
dan at eastsierra.net
Mon Dec 5 17:52:15 PST 2005
> What is it about the CREATE TABLE statements freeside-setup generates
> that requires OIDs and is incompatible with Pg 8.1? What is the exact
> error message?
>
> --
> _ivan
... I posted the complete output from attempting to run freeside-setup
last month, at:
http://www.sisd.com/pipermail/freeside-users/2005-November/004895.html
--Dan
>
>
> On Mon, Dec 05, 2005 at 07:29:33AM +0200, Victor wrote:
> > 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
> > >>
> > >>
> > >>
> > >>
> > >
> > >
> > >
> >
>
> > _______________________________________________
> > freeside-users mailing list
> > freeside-users at sisd.com
> > http://420.am/cgi-bin/mailman/listinfo/freeside-users
>
>
> --
> _ivan
> _______________________________________________
> freeside-users mailing list
> freeside-users at sisd.com
> http://420.am/cgi-bin/mailman/listinfo/freeside-users
>
>
--
More information about the freeside-users
mailing list