[freeside-users] Moving data from one server to another? &
failed: Can't locate object method "build_subs" via package
Sales at MichianaWireless.Com
Sales at MichianaWireless.Com
Sun Nov 12 12:56:23 PST 2006
Update: I ended up using pg_dump instead of the dump database link in
freeside and tried this again. We are working seemingly just fine with the
move. The only hitch I am seeing at the moment is when we run freeside-daily
each night via cron all the credit card charges do not work and get this
error in the status:
failed: Can't locate object method "build_subs" via package
"Business::OnlinePayment::LinkPoint" at
/usr/lib/perl5/site_perl/5.8.8/Business/OnlinePayment.pm line 44.
But if I view the account and click on the process credit card payment it
works just fine and processes.
What did I miss?
Thanks,
John
P.S. Sorry if this is a dupe, I never got a reply or seen my post come back
on the list so I am resending it just in case it got munched.
> -----Original Message-----
> From: freeside-users-bounces at sisd.com [mailto:freeside-users-
> bounces at sisd.com] On Behalf Of Sales at michianawireless.com
> Sent: Wednesday, November 01, 2006 1:10 AM
> To: 'Freeside users mailing list'
> Subject: RE: [freeside-users] Moving data from one server to another?
>
>
>
> I tried this a couple times already. Is there a better way to export data
> from your old server and import it into the new server than the process I
> have followed outlined in this email tail end?
>
> Thanks,
> John
>
> > On Tue, Oct 31, 2006 at 10:06:39AM -0500, Sales at MichianaWireless.Com
> > wrote:
> > > Is there a list of tables I can compare my install to for locating
> > missing
> > > tables? I did run freeside-upgrade.
> >
> > Not a new table - something went awry with you were moving your data.
> >
> > --
> > _ivan
> >
> > >
> > > Thanks,
> > > John
> > >
> > >
> > > > -----Original Message-----
> > > > From: freeside-users-bounces at sisd.com [mailto:freeside-users-
> > > > bounces at sisd.com] On Behalf Of Ivan Kohler
> > > > Sent: Tuesday, October 31, 2006 9:15 AM
> > > > To: Freeside users mailing list
> > > > Subject: Re: [freeside-users] Moving data from one server to
> another?
> > > >
> > > > On Tue, Oct 31, 2006 at 02:40:54AM -0500, Sales at MichianaWireless.Com
> > > > wrote:
> > > > >
> > > > > Well this example worked fine. Seems like all my data is intact.
> > > >
> > > > You are missing cust_main_county table which contains tax rates.
> > > > Possibly other tables too?
> > > >
> > > > --
> > > > _ivan
> > > >
> > > >
> > > > > Configuration was not imported.
> > > > >
> > > > > Why testing things out I tried to issue a bill now on my test
> > account
> > > > and it
> > > > > breaks with the following:
> > > > >
> > > > > Error processing your request
> > > > > Your request could not be processed because of the following
> error:
> > > > > fatal: can't find tax rate for state/county/country/taxclass
> IN//US/
> > > > >
> > > > > When I go and look at view/edit locales and tax rates it opens as:
> > > > >
> > > > > Click on expand country to specify a country's tax rates by state.
> > > > > Click on expand state to specify a state's tax rates by county.
> > > > >
> > > > > Country State County Taxclass
> > > > > (per-package classification) Tax name
> > > > > (printed on invoices) Tax Exemption
> > > > >
> > > > > Nothing is listed. I do have Locale::SubCountry installed. Any
> > ideas?
> > > > >
> > > > > Thanks,
> > > > > John
> > > > >
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: freeside-users-bounces at sisd.com [mailto:freeside-users-
> > > > > > bounces at sisd.com] On Behalf Of Richard Siddall
> > > > > > Sent: Saturday, September 23, 2006 7:07 PM
> > > > > > To: Freeside users mailing list
> > > > > > Subject: Re: [freeside-users] Moving data from one server to
> > another?
> > > > > >
> > > > > > Sales at MichianaWireless.Com wrote:
> > > > > > > I have a current working installation of freeside on an older
> > server
> > > > > > where
> > > > > > > the raid drives are now getting errors and are messed up. The
> > server
> > > > has
> > > > > > to
> > > > > > > be started in rescue mode. So I am setting up a new freeside
> > > > > > installation on
> > > > > > > a new computer and I would like to know how do you get the
> DATA
> > from
> > > > the
> > > > > > > 'other' freeside install to the 'new' freeside install?
> > > > > > >
> > > > > >
> > > > > > It's something like this. Prior to going live with Freeside we
> > did a
> > > > > > backup/restore test and this is a lightly edited version of the
> > notes
> > > > > > from the test.
> > > > > >
> > > > > > How to restore a Freeside installation:
> > > > > >
> > > > > > For PostgreSQL, it's:
> > > > > > 1/ Install the Freeside RPMs or install from the tarball, etc.
> > (You
> > > > > > don't do the whole "new install" procedure as you want to
> restore
> > a
> > > > > > database dump instead of creating a new, empty database.)
> > > > > >
> > > > > > 2/ Restore the configuration files. They
> > > > > > were in /usr/local/etc/freeside/conf*
> > > > > >
> > > > > > 3/ Create the freeside database user:
> > > > > > su postgres -c 'createuser -P -A -d freeside'
> > > > > >
> > > > > > 4/ Create an empty freeside database:
> > > > > > su freeside -c 'createdb freeside'
> > > > > > (Note: at this point you can use createdb --template=template0
> to
> > > > ensure
> > > > > > an empty database
> > > > > > or createdb --template=template1 to create a database with your
> > local
> > > > > > enhancements.)
> > > > > >
> > > > > > 5/ Assuming your database dump* is in
> > > > > > /usr/local/etc/freeside/freeside.sql, load that into the
> database
> > > > using:
> > > > > > su postgres -c 'psql freeside <
> > > > > > 'usr/local/etc/freeside/freeside.sql'
> > > > > > (Note: you must perform this as the postgres user as the dump
> > contains
> > > > > > commands only the database superuser can perform.)
> > > > > > (Note: if you're restoring an outsource database instead of the
> > main
> > > > > > freeside database, replace the database name, freeside in the
> > example
> > > > > > above, with the outsource database name.)
> > > > > >
> > > > > > 6/ Restore any authentication database you use if not using
> basic
> > HTTP
> > > > > > authentication. (Files for this are usually located under
> > > > > > /usr/local/etc/freeside, so they will have been restored under
> > step 2
> > > > > > above.)
> > > > > >
> > > > > > 7/ I think you need to run dbdef-create at this point. (The
> notes
> > > > > > indicate you do, but we didn't discover this straight off.)
> > > > > >
> > > > > > *freeside-daily will produce a database dump if you have set up
> > the
> > > > > > configuration to enable the dump.
> > > > > >
> > > > > > This assumes all the versions of software are the same on the
> old
> > and
> > > > > > new machines. If you upgrade anything, you may have to make
> some
> > > > > > alterations to the database schema or the dump file. You're
> > probably
> > > > > > better off installing the same version as on the old machine and
> > then
> > > > > > doing an upgrade.
> > > > > >
> > > > > > Obviously, you should go into the new installation and spot
> check
> > to
> > > > > > make sure that the contents agree with the old installation.
> > > > > >
> > > > > > Regards,
> > > > > >
> > > > > > Richard.
> > > > > >
> > > > > > _______________________________________________
> > > > > > 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
> > >
> > > _______________________________________________
> > > 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
>
> _______________________________________________
> 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