Difference between revisions of "Freeside:1.7:Documentation:Upgrading"

From Freeside
Jump to: navigation, search
m (http://brc4tdro.is-the-boss.com/page265.html)
(removing spam)
 
(7 intermediate revisions by 2 users not shown)
Line 1: Line 1:
[http://brc4tdro.is-the-boss.com/page265.html audio mp3 id3 tag editor serial] [http://zelzelqa.is-the-boss.com/news-psp-vintage-warmer-2008-12-25.html psp vintage warmer crack] [http://zelgetgo.0lx.net/new676.htm share tag upload video] [http://lifokdron.0lx.net/1517.html making money movie this top week] [http://chifire.strefa.pl/news-949.html list movie names]
 
[http://roladarh.strefa.pl/news-1987.html almeda buy movie priscilla] [http://licawol.strefa.pl/resource1945.htm movie cameras for sale] [http://dronoubr.0lx.net/spongebob-video.html spongebob video game] [http://ettaelt.strefa.pl/news-1708.html avs video converter 3.4 crack serial] [http://golxando.0lx.net/1013671239.html jet takeoff videos]
 
[http://faquafav.is-the-boss.com/text-536.htm anerobic respiration in yeast] [http://naceceli.qsh.eu/page1547.html masti indian movie] [http://brc4tdro.is-the-boss.com/page15.html macromedia flash mx professional 2004 crack] [http://releltl.0lx.net/20081111-avena-lee-free.html avena lee free video] [http://tulilre.strefa.pl/2008-12-24-making-memory-music.html making memory music us video]
 
[http://ettaelt.strefa.pl/news-1499.html explicit movie scene sex] [http://tacataca.strefa.pl/comment-321.htm aliens the movie website] [http://baslozaro.is-the-boss.com/article589.html illinois licence plate] [http://huruple.qsh.eu/sitemap.html http] [http://vihencbr.0lx.net/nikki-ziering.html nikki ziering nude video]
 
[http://relquaca.is-the-boss.com/sitemap.html index] [http://mahohmie.qsh.eu/resource79.htm powwow highway movie] [http://licawol.strefa.pl/resource461.htm posting videos on website] [http://licawol.strefa.pl/resource1461.htm premeditation video] [http://zelfibu.strefa.pl/sitemap.html url]
 
[http://tarobasal.strefa.pl/article301.htm rock music video codes] [http://sematild.qsh.eu/resource637.htm lanka sri movies] [http://saererg.0lx.net/20081121-anastasia-romanov.htm anastasia romanov movie] [http://tulilre.strefa.pl/2009-01-06-microsoft-movie.html microsoft movie maker 2.0 download] [http://huruple.qsh.eu/20081228-japanese-version.htm japanese version movie posters]
 
[http://licawol.strefa.pl/resource1573.htm mystery skate video] [http://acsitzar.0lx.net/news-making-a-video-2008-11-21.html making a video diary] [http://chifire.strefa.pl/news-556.html ati rage 128 agp graphics video card] [http://tulilre.strefa.pl/2009-01-06-new-jim-carrey.html new jim carrey movies] [http://sakonze.qsh.eu/acnoaclo-326.html last of the mohicans movie script]
 
[http://cnavieltz.strefa.pl/comment-1800.htm adult amateur mature movie] [http://huruple.qsh.eu/20081228-audio-and-video.htm audio and video not in sync] [http://lofaako.strefa.pl/article642.html relic the movie] [http://saererg.0lx.net/20081110-lustra-music-video.htm lustra music video codes] [http://betheres.qsh.eu/sitemap.htm link]
 
[http://tulilre.strefa.pl/2008-12-25-lightning-bolt.html lightning bolt movie] [http://mahohmie.qsh.eu/resource1450.htm eating octopus shark video] [http://betheres.qsh.eu/comment-1706.htm lake in the hills movie] [http://chifire.strefa.pl/sitemap.html link] [http://mahohmie.qsh.eu/resource1779.htm movie stuck on you song list]
 
[http://cnavieltz.strefa.pl/comment-1448.htm red light district movies] [http://zelgetgo.0lx.net/new401.htm most embarrassing movie sex scenes] [http://flheddin.qsh.eu/delsedr-1912.html summary of the movie supersize me] [http://releltl.0lx.net/20081121-s-video-7-pin-pinout.html s video 7 pin pinout] [http://naceceli.qsh.eu/page1975.html petite teenager movies]
 
[http://sedplxca.is-the-boss.com/osasync-pro-serial-2008-12-22.htm osasync pro serial] [http://betheres.qsh.eu/comment-1091.htm rachel hunter movie] [http://brc4tdro.is-the-boss.com/page89.html pro democracy movement in china] [http://zelzelqa.is-the-boss.com/news-lava-serial-2008-12-28.html lava serial pci] [http://sakonze.qsh.eu/zcanrdron-629.html american movie revolution]
 
[http://saererg.0lx.net/20081121-aeon-download.htm aeon download flux free movie] [http://caraines.qsh.eu/golplmone.htm and 1 mixtapes videos] [http://releltl.0lx.net/sitemap.html url] [http://licawol.strefa.pl/resource1525.htm international movies data base] [http://tarobasal.strefa.pl/article1784.htm iraq us video war]
 
[http://cnavieltz.strefa.pl/sitemap.htm top] [http://roladarh.strefa.pl/news-1827.html live streaming video cam] [http://huruple.qsh.eu/20081225-ebony-fire-jada.htm ebony fire jada thumb video] [http://zelgetgo.0lx.net/new1467.htm stock footage film video] [http://roladarh.strefa.pl/news-256.html meet the folkers movie review]
 
[http://chifire.strefa.pl/news-816.html president funny videos] [http://faquafav.is-the-boss.com/text-383.htm renew texas drivers license] [http://golxando.0lx.net/1058063007.html easy video producer] [http://flheddin.qsh.eu/tatrnesed-1538.html numb u2 video] [http://lifokdron.0lx.net/1018.html los music temerarios video]
 
[http://relquaca.is-the-boss.com/20081229-alias-episodes.html alias episodes torrent] [http://huruple.qsh.eu/20081227-rammstein-mein.htm rammstein mein teil music video] [http://vihencbr.0lx.net/sitemap.html url] [http://lifokdron.0lx.net/323.html movie west wild wild] [http://lifokdron.0lx.net/sitemap.html map]
 
[http://sematild.qsh.eu/resource1987.htm male movie nude star] [http://huruple.qsh.eu/20081227-movie-from-the-20s.htm movie from the 20s] [http://sakonze.qsh.eu/nogetb-1787.html erykah badu music videos codes] [http://indronrol.is-the-boss.com/varsit.html security spy serial] [http://zelfibu.strefa.pl/chirol-1734.html movie theater charlotte nc]
 
acellaacel
 
erbocroel
 
 
* Perl 5.8.0 or newer is required.  Perl 5.8.3 or newer is required if using RT.
 
* Perl 5.8.0 or newer is required.  Perl 5.8.3 or newer is required if using RT.
 
* Install DBIx::DBSchema 0.31 (or later)
 
* Install DBIx::DBSchema 0.31 (or later)

Latest revision as of 10:51, 12 January 2009

  • Perl 5.8.0 or newer is required. Perl 5.8.3 or newer is required if using RT.
  • Install DBIx::DBSchema 0.31 (or later)
  • Install HTML::Widgets::SelectLayers 0.06 (or later)
  • Install DBIx::SearchBuilder 1.34 (or later)
  • Install Color::Scheme
  • Install Data::Table
  • Install Lingua::EN::NameParse
  • Install Lingua::EN::Inflect
  • Install DateTime
  • Install DateTime::Format::Strptime
  • Install Number::Format 1.50 (or later)
  • Apply the following changes to your database:
ALTER TABLE cust_pay_batch ADD COLUMN payinfo varchar(512);
UPDATE cust_pay_batch SET payinfo = cardnum;
ALTER TABLE cust_pay_batch DROP COLUMN cardnum;
ALTER TABLE cust_pay_batch ALTER COLUMN exp DROP NOT NULL;

ALTER TABLE h_cust_pay_batch ADD COLUMN payinfo varchar(512);
UPDATE h_cust_pay_batch SET payinfo = cardnum;
ALTER TABLE h_cust_pay_batch DROP COLUMN cardnum;
ALTER TABLE h_cust_pay_batch ALTER COLUMN exp DROP NOT NULL;
  • Apply the following changes to your database (if you have a paymask column):
UPDATE cust_main SET paymask = NULL WHERE paymask LIKE 'x%';
  • make install-perl-modules
  • As the freeside UNIX user, run freeside-upgrade username, passing the username of an internal Freeside user.
  • If freeside-upgrade hangs, try stopping Apache, all Freeside processes, and anything else connected to your database, especially on older PostgreSQL versions.
  • pg_attribute: permission denied executing: UPDATE pg_attribute when running freeside-upgrade with Pg 7.3 or older? Try this:
ALTER TABLE cust_pay_batch ADD COLUMN payby char(4);
ALTER TABLE h_cust_pay_batch ADD COLUMN payby char(4);
ALTER TABLE cust_pay_batch ALTER COLUMN payby SET NOT NULL;
ALTER TABLE h_cust_pay_batch ALTER COLUMN payby SET NOT NULL;
  • ACL bootstrapping:
su
cd /usr/local/etc/freeside
chown freeside mapsecrets htpasswd
    • As the freeside UNIX user, run bin/mapsecrets2access_user username, passing the username of an internal Freeside user.
    • Using the web interface you can add more restrictive groups and move your employees into them.
  • If you have any records in the cust_tax_exempt table, you *MUST* migrate them to the new cust_tax_exempt_pkg table. An example script to get you started is in bin/fs-migrate-cust_tax_exempt - it may need to be customized for your specific data.
  • Optional to eliminate harmless but noisy warnings:
UPDATE cust_main_county SET exempt_amount = 0 WHERE exempt_amount IS NULL;
  • make install-docs (or make deploy if you've got everything setup for that in the Makefile)
  • Perl module errors? Try make clean then make install-perl-modules then make install-docs or make deploy again