[freeside-users] Problems with new freeside installation (fixed)
ivan
ivan at 420.am
Sun Dec 4 22:05:19 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
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
More information about the freeside-users
mailing list