[freeside-users] Problems with new freeside installation (fixed)
ivan
ivan at 420.am
Tue Dec 6 14:33:03 PST 2005
On Mon, Dec 05, 2005 at 08:52:15PM -0500, Dan Roberts wrote:
>
>
> > 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
I see, the exact error message is at the end:
DBD::Pg::st execute failed: ERROR: column "oid" does not exist
DBD::Pg::st execute failed: ERROR: relation "cust_main_county" does not exist
ERROR: relation "cust_main_county" does not exist
The error results not from table creation, but from the attempt to
insert data into the tables (and the subsequent attempt to retreive the
primary key of a newly-inserted row). I fixed this by using the Pg
CURRVAL() function instead of DBD::Pg's "pg_oid_status" attribute.
1.5.8 should work with Pg 8.1+ with OIDs turned off.
--
_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
> > > >>>>
> > > >>>>
> > > >>>>
More information about the freeside-users
mailing list