[freeside-users] Freeside not displaying the web page..

Erreu Gedmon eg at keyway.net
Sun Oct 16 22:50:46 PDT 2016


I made some notes so that I could update the wiki (once I have access) after completing a successful 4.1 install on Debian 8.5, maybe they will help you.


# Installation notes
# Freeside 4.1 on Debian 8.5
#
# Refs.
# FAQ: http://www.freeside.biz/mediawiki/index.php/Freeside:Documentation:FAQ
# Freeside 4.1: http://www.freeside.biz/mediawiki/index.php/Freeside:4:Documentation:InstallingOnDebian8
# Debian 8.5: https://www.debian.org/releases/stable/amd64/index.html.en
#            https://www.debian.org/devel/debian-installer/

# Clean install of Debian 8

### EMAIL
#
apt install ssmtp
# ssmtp
cp -p /etc/ssmtp/ssmtp.conf /etc/ssmtp/ssmtp.conf.`date +%Y-%m-%d`
awk '{sub(/^#rewriteDomain=.*/,"#&\nrewriteDomain=EXAMPLE.COM"); \
      sub(/^mailhub=mail/,"#&\nmailhub=mail.EXAMPLE.COM:587"); \
      sub(/^#FromLineOverride=.*/,"#&\nFromLineOverride=YES"); \
      sub(/^root=postmaster/,"#&\nroot=YOU at EXAMPLE.COM"); \
    print}' /etc/ssmtp/ssmtp.conf.`date +%Y-%m-%d` > /etc/ssmtp/ssmtp.conf
cat >> /etc/ssmtp/ssmtp.conf << "EOF"
UseSTARTTLS=Yes
# Username/Password
#AuthUser=USERNAME
#AuthPass=PASSWORD
EOF
#test
echo -e "To: root\nFrom: test\nSubject:Test 1\n\nTest 1\n" | sendmail root


### DISABLE THE deb cdrom source
file="/etc/apt/sources.list"; stamp=`date +%Y-%m-%d`; cp $file $file.$stamp; \
awk '{sub(/^#?deb cdrom.*/,"#&\n");print}' $file.$stamp > $file ; diff $file $file.$stamp

apt-get install screen
screen
apt-get update
apt-get upgrade

### FREESIDE
# http://www.freeside.biz/mediawiki/index.php/Freeside:4:Documentation:InstallingOnDebian8

cat >> /etc/apt/sources.list << "EOF"
deb http://freeside.biz/~ivan/freeside-jessie/ ./
deb http://freeside.biz/~jeremyd/freeside4-jessie-stable/ ./
EOF

aptitude install freeside freeside-lib freeside-webui

    The following packages have unmet dependencies:
     freeside-webui : Conflicts: libev-perl but 4.18-1 is to be installed.
    The following actions will resolve these dependencies:

         Keep the following packages at their current version:
    1)     libev-perl [Not Installed]                        

         Leave the following dependencies unresolved:        
    2)     libmojolicious-perl recommends libev-perl         

    Accept this solution? [Y/n/q/?]y

    The following packages are RECOMMENDED but will NOT be installed:
      libev-perl
    0 packages upgraded, 394 newly installed, 0 to remove and 1 not upgraded.
    Need to get 743 MB of archives. After unpacking 1327 MB will be used.
    Do you want to continue? [Y/n/?] y

    WARNING: untrusted versions of the following packages will be installed!

    Untrusted packages could compromise your system's security.
    You should only proceed with the installation if you are certain that
    this is what you want to do.

      libbusiness-creditcard-perl libnet-domain-tld-perl freeside undersmtpd libnet-mac-vendor-perl libmap-splat-perl freeside-webui freeside-lib libdbix-dbschema-perl libparams-classify-perl

    Do you want to ignore this warning and proceed anyway?
    To continue, enter "Yes"; to abort, enter "No": Yes

more /var/log/aptitude

aptitude upgrade

    WARNING: untrusted versions of the following packages will be installed!

    Untrusted packages could compromise your system's security.
    You should only proceed with the installation if you are certain that
    this is what you want to do.

      libio-socket-ssl-perl

    Do you want to ignore this warning and proceed anyway?
    To continue, enter "Yes"; to abort, enter "No": yes

apt-mark hold freeside*

### Backed up, compressed, snapshotted drive.

### Initializing Freeside installation

su - postgres
createuser -P -d freeside

# create database
su - freeside
createdb -E UTF8 freeside

# initialize database
freeside-setup -d EXAMPLE.COM
# lots of output, no significant errors (some minor Use of uninitialized value stuff)
# Ref. http://www.freeside.biz/pipermail/freeside-users/2016-May/006485.html
# This error goes away after running "cpan JSON::XS", but I have not tested in production yet.

# RT
/opt/rt3/sbin/rt-setup-database --action schema
    # enter password from postgres step above when prompted, output:
        Working with:
        Type:   Pg
        Host:
        Port:
        Name:   freeside
        User:   freeside
        DBA:    freeside
        Now populating database schema.
        Done.
/opt/rt3/sbin/rt-setup-database --action coredata
    # enter password from above when prompted, output:
        Working with:
        Type:   Pg
        Host:
        Port:
        Name:   freeside
        User:   freeside
        DBA:    freeside
        Now inserting RT core system objects.
        Done.
/opt/rt3/sbin/rt-setup-database --action insert --datafile /opt/rt3/etc/initialdata
    # enter password from above when prompted, output:
        Type:   Pg
        Host:
        Port:
        Name:   freeside
        User:   freeside
        DBA:    freeside
        Now inserting data.
        [921] [Sat Sep 17 00:40:16 2016] [error]: Action 'Notify Other Recipients' not found (/opt/rt3/lib/RT/Handle.pm:1234)
        Done inserting data.
        Done.

# System users
freeside-adduser -g 1 fs_queue
    Subroutine JSON::XS::Boolean::(++ redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(-- redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(0+ redefined at /usr/share/perl/5.20/overload.pm line 50.
    FS::part_event::Condition::payby is disabled; skipping
freeside-adduser -g 1 fs_daily
    Subroutine JSON::XS::Boolean::(-- redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(0+ redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(++ redefined at /usr/share/perl/5.20/overload.pm line 50.
    FS::part_event::Condition::payby is disabled; skipping
freeside-adduser -g 1 fs_selfservice
    Subroutine JSON::XS::Boolean::(-- redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(0+ redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(++ redefined at /usr/share/perl/5.20/overload.pm line 50.
    FS::part_event::Condition::payby is disabled; skipping
freeside-adduser -g 1 fs_api
    Subroutine JSON::XS::Boolean::(-- redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(0+ redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(++ redefined at /usr/share/perl/5.20/overload.pm line 50.
    FS::part_event::Condition::payby is disabled; skipping

# employees

freeside-adduser -g 1 YOURUSERNAME YOURPASSWORD
    Subroutine JSON::XS::Boolean::(0+ redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(-- redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(++ redefined at /usr/share/perl/5.20/overload.pm line 50.
    FS::part_event::Condition::payby is disabled; skipping

# I believe this is deprecated? htpasswd does not exist on 4.1 appliance
#htpasswd /usr/local/etc/freeside/htpasswd sysadmin
# failed with: htpasswd: cannot modify file /usr/local/etc/freeside/htpasswd; use '-c' to create it
#htpasswd -c /usr/local/etc/freeside/htpasswd sysadmin
#    New password:
#    Re-type new password:
#    Adding password for user sysadmin

/etc/init.d/freeside restart
    Stopping freeside-queued: done.
    Stopping freeside-sqlradius-radacctd: /etc/init.d/freeside: 109: kill: No such process

    done.
    Stopping freeside-prepaidd: /etc/init.d/freeside: 115: kill: No such process

    done.
    Stopping freeside-cdrd: /etc/init.d/freeside: 121: kill: No such process

    done.
    Stopping freeside-cdrrewrited: /etc/init.d/freeside: 127: kill: No such process

    done.
    Stopping freeside-cdrrated: /etc/init.d/freeside: 133: kill: No such process

    done.
    Stopping freeside-torrus-srvderive: /etc/init.d/freeside: 139: kill: No such process

    done.
    Stopping freeside-xmlrpcd: /etc/init.d/freeside: 151: kill: No such process

    done.
    Stopping freeside-selfservice-xmlrpcd: /etc/init.d/freeside: 193: kill: No such process

    done.
    Starting freeside-selfservice-xmlrpcd: selfservice-xmlrpcd started with pid 5850
    done.
    Starting freeside-xmlrpcd: FS::part_event::Condition::payby is disabled; skipping
    FS::part_event::Condition::payby is disabled; skipping
    xmlrpcd started with pid 5854
    done.
    Starting freeside-queued: freeside-queued started with pid 5858
    done.
    Starting freeside-sqlradius-radacctd: Subroutine JSON::XS::Boolean::(0+ redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(-- redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(++ redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(-- redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(++ redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(0+ redefined at /usr/share/perl/5.20/overload.pm line 50.
    FS::part_event::Condition::payby is disabled; skipping
    FS::part_event::Condition::payby is disabled; skipping
    freeside-sqlradius-radacctd started with pid 5862
    done.
    Starting freeside-prepaidd: Subroutine JSON::XS::Boolean::(-- redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(0+ redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(++ redefined at /usr/share/perl/5.20/overload.pm line 50.
    FS::part_event::Condition::payby is disabled; skipping
    freeside-prepaidd started with pid 5877
    done.
    Starting freeside-cdrrewrited: freeside-cdrrewrited started with pid 5880
    done.
    Starting freeside-cdrd: Subroutine JSON::XS::Boolean::(0+ redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(++ redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(-- redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(++ redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(0+ redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(-- redefined at /usr/share/perl/5.20/overload.pm line 50.
    FS::part_event::Condition::payby is disabled; skipping
    FS::part_event::Condition::payby is disabled; skipping
    freeside-cdrd started with pid 5884
    done.
    Starting freeside-cdrrated: Subroutine JSON::XS::Boolean::(-- redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(0+ redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(++ redefined at /usr/share/perl/5.20/overload.pm line 50.
    FS::part_event::Condition::payby is disabled; skipping
    freeside-cdrrated started with pid 5887
    done.
    Starting freeside-torrus-srvderive: torrus-srvderive started with pid 5890
    done.
    root at fs:~# Subroutine JSON::XS::Boolean::(0+ redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(-- redefined at /usr/share/perl/5.20/overload.pm line 50.
    Subroutine JSON::XS::Boolean::(++ redefined at /usr/share/perl/5.20/overload.pm line 50.
    FS::part_event::Condition::payby is disabled; skipping


### APACHE & GUI

file=" /etc/apache2/envvars"; stamp=`date +%Y-%m-%d`; cp $file $file.$stamp; \
awk '{sub(/^#?export APACHE_RUN_USER.*/,"#&\nexport APACHE_RUN_USER=freeside"); \
      sub(/^#?export APACHE_RUN_GROUP.*/,"#&\nexport APACHE_RUN_GROUP=freeside");print}' \
     $file.$stamp > $file ; diff $file $file.$stamp

a2enconf freeside-base2
    ERROR: Conf freeside-base2 does not exist!
    root at fs:~# a2enconf              
    Your choices are: apache2-doc charset freeside-base2.4 freeside-rt freeside-torrus javascript-common localized-error-pages other-vhosts-access-log security serve-cgi-bin
    Which conf(s) do you want to enable (wildcards ok)?

a2enconf freeside-base2.4
    To activate the new configuration, you need to run:
      service apache2 reload

a2enconf freeside-rt
    Enabling conf freeside-rt.
    To activate the new configuration, you need to run:
      service apache2 reload

a2dismod mpm_event
    Module mpm_event disabled.
    To activate the new configuration, you need to run:
      service apache2 restart

a2enmod mpm_prefork
    Considering conflict mpm_event for mpm_prefork:
    Considering conflict mpm_worker for mpm_prefork:
    Enabling module mpm_prefork.
    To activate the new configuration, you need to run:
      service apache2 restart

a2enmod rewrite

chown freeside /var/lock/apache2

# enable SSL
# See /usr/share/doc/apache2/README.Debian.gz on how to configure SSL and create self-signed certificates.
a2enmod ssl
a2ensite default-ssl
service apache2 restart

reboot

###################################################SNAPSHOT##############################################################################

#Done.


Erreu Gedmon

--
"You see persons and things not as they but as you are."
        -- Anthony De Mello

On 10/16/2016 10:00 PM, Jason Green wrote:
> Hi,
>  I completed the following
>
> root at ookifreeside:/home/freeside# sudo apt-get check
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> root at ookifreeside:/home/freeside# sudo apt-get install --fix-missing
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> 0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded.
> root at ookifreeside:/home/freeside#
>
> So obviously no change.
>
>
> Kind regards,
>
> Jason Green.
> Director
>
>
> Mobile:     0417 295 660
> Helpdesk: 1300 858 295
>
>
>
> This e-mail, any attachments and the information contained therein ("this message") are confidential and intended solely for the use of the addressee(s). If you have received this message in error please send it back to the sender and delete it. Unauthorized publication, use, dissemination or disclosure of this message, either in whole or in part is strictly prohibited.  OOKI have taken all required measures to ensure this email is free from any virus, trojan or malware.
>
> -----Original Message-----
> From: freeside-users [mailto:freeside-users-bounces at freeside.biz] On Behalf Of freeside-users-request at freeside.biz
> Sent: Monday, 17 October 2016 6:00 AM
> To: freeside-users at freeside.biz
> Subject: freeside-users Digest, Vol 131, Issue 3
>
> Send freeside-users mailing list submissions to
> 	freeside-users at freeside.biz
>
> To subscribe or unsubscribe via the World Wide Web, visit
> 	http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users
> or, via email, send a message with subject or body 'help' to
> 	freeside-users-request at freeside.biz
>
> You can reach the person managing the list at
> 	freeside-users-owner at freeside.biz
>
> When replying, please edit your Subject line so it is more specific than "Re: Contents of freeside-users digest..."
>
>
> Today's Topics:
>
>    1. Re: Freeside 4.1 on Debian 8 (John Wilson)
>    2. Re: Freeside Appliance (John Wilson)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sun, 16 Oct 2016 18:03:35 +0000
> From: John Wilson <johnwilson1969 at gmail.com>
> To: Freeside users mailing list <freeside-users at freeside.biz>
> Subject: Re: [freeside-users] Freeside 4.1 on Debian 8
> Message-ID:
> 	<CAK2OcwX9VJUMppFBuoP_LAAR_Pkcbh_yEDwPp1T_z0vKMGhwOQ at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Any errors when installing of packages? Might be missing mod-perl.
>
> sudo apt-get check
>
> or
>
> sudo apt-get install --fix-missing
>
> On Sun, Oct 16, 2016 at 2:09 AM Jason Green <jason.green at ooki.com.au> wrote:
>
>> Hi,
>>
>> I have been all the way through the instructions 10 times.. Rebuilt 
>> the server from scratch 8 times..
>>
>>
>>
>> I get the following when I connect to the server.. Can someone tell me 
>> what I have done wrong please
>>
>>
>>
>> <%init>my $debug = $cgi->param('debug'); % warn time.": header.html\n" 
>> if $debug; % <& /elements/header.html, mt('Billing Main') &> % warn time.":
>> dashboard-install_welcome.html\n" if $debug; % <& 
>> /elements/dashboard-install_welcome.html &> % warn time.":
>> dashboard-toplist.html\n" if $debug; % <& 
>> /elements/dashboard-toplist.html &> % my $curuser = 
>> $FS::CurrentUser::CurrentUser; % my $numcust = 
>> $curuser->option('dashboard_customers'); % $numcust ||= 10 unless 
>> $numcust =~ /^\s*0+\s*$/; % if ( $numcust ) { % % warn time.": 
>> fetching recently changed customers\n" if $debug; % % my $sth = 
>> dbh->prepare( % #"SELECT DISTINCT custnum FROM h_cust_main JOIN 
>> cust_main USING ( custnum ) % "SELECT custnum FROM h_cust_main JOIN 
>> cust_main USING ( custnum ) % WHERE ( history_action = 'insert' OR 
>> history_action = 'replace_new' ) % AND ( history_usernum = ? OR 
>> history_user = ? ) % AND ". $curuser->agentnums_sql( 
>> table=>'cust_main' ). % " ORDER BY history_date desc LIMIT 1000" # 
>> LIMIT 10 % ) or die dbh->errstr; % % % $sth->execute( 
>> $curuser->usernum, $curuser->username ) or die $sth->errstr; % % my 
>> %saw = (); % my @custnums = grep { !$saw{$_}++ } map $_->[0], @{ 
>> $sth->fetchall_arrayref }; % % @custnums = splice(@custnums, 0, 
>> $numcust); % % if ( @custnums ) { % warn
>> time.": displaying recently changed customers\n" if $debug; <& 
>> /elements/table-grid.html &> % my $bgcolor1 = '#eeeeee'; % my 
>> $bgcolor2 = '#ffffff'; % my $bgcolor = $bgcolor2; <% mt('Customers I 
>> recently added or
>> modified') |h %> % foreach my $custnum ( @custnums ) { % my $cust_main 
>> = qsearchs('cust_main', { 'custnum' => $custnum } ); % next unless 
>> $cust_main;  <% $cust_main->display_custnum %>: <% $cust_main->name |h 
>> %> 
>> <http://172.18.1.34/freeside/view/cust_main.cgi?%3C%25%20$custnum%20%2
>> 5%3E>  % if ( $bgcolor eq $bgcolor1 ) { % $bgcolor = $bgcolor2; % } 
>> else { % $bgcolor = $bgcolor1; % } % % } % } % } <& 
>> /elements/footer.html &>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> *Kind regards,*
>>
>>
>>
>> *Jason Green.*
>>
>> *Director*
>>
>>
>>
>>
>>
>> Mobile:*     0417 295 660*
>>
>> Helpdesk:* 1300 858 295*
>>
>> *[image: OOKI website]* <http://www.ooki.com.au/>
>>
>>
>>
>>
>>
>> This e-mail, any attachments and the information contained therein 
>> ("this
>> message") are confidential and intended solely for the use of the 
>> addressee(s). If you have received this message in error please send 
>> it back to the sender and delete it. Unauthorized publication, use, 
>> dissemination or disclosure of this message, either in whole or in 
>> part is strictly prohibited.  OOKI have taken all required measures to 
>> ensure this email is free from any virus, trojan or malware.
>>
>>
>> _______________________________________________
>> freeside-users mailing list
>> freeside-users at freeside.biz
>> http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users
>>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://freeside.biz/pipermail/freeside-users/attachments/20161016/aba13e31/attachment-0001.html>
>
> ------------------------------
>
> Message: 2
> Date: Sun, 16 Oct 2016 18:16:05 +0000
> From: John Wilson <johnwilson1969 at gmail.com>
> To: Freeside users mailing list <freeside-users at freeside.biz>
> Subject: Re: [freeside-users] Freeside Appliance
> Message-ID:
> 	<CAK2OcwVNjuhiw_X2DfQnkN_TiPsxOXouYCEtNWSEQJ+q_ez7+g at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> The appliance is the full version, guest user can sudo to root. You can then configure it however you like.
>
>
> On Sat, Oct 15, 2016 at 9:57 PM Jason Green <jason.green at ooki.com.au> wrote:
>
>> Hi,
>>
>> The freeside appliance only seems to be a demo..
>>
>> Is there a working appliance downloadable?
>>
>> Or a way to make the demo a full version..
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> *Kind regards,*
>>
>>
>>
>> *Jason Green.*
>>
>> *Director*
>>
>>
>>
>>
>>
>> Mobile:*     0417 295 660*
>>
>> Helpdesk:* 1300 858 295*
>>
>> *[image: OOKI website]* <http://www.ooki.com.au/>
>>
>>
>>
>>
>>
>> This e-mail, any attachments and the information contained therein 
>> ("this
>> message") are confidential and intended solely for the use of the 
>> addressee(s). If you have received this message in error please send 
>> it back to the sender and delete it. Unauthorized publication, use, 
>> dissemination or disclosure of this message, either in whole or in 
>> part is strictly prohibited.  OOKI have taken all required measures to 
>> ensure this email is free from any virus, trojan or malware.
>>
>>
>> _______________________________________________
>> freeside-users mailing list
>> freeside-users at freeside.biz
>> http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users
>>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://freeside.biz/pipermail/freeside-users/attachments/20161016/83ab5113/attachment-0001.html>
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> freeside-users mailing list
> freeside-users at freeside.biz
> http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users
>
>
> ------------------------------
>
> End of freeside-users Digest, Vol 131, Issue 3
> **********************************************
> _______________________________________________
> freeside-users mailing list
> freeside-users at freeside.biz
> http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users



More information about the freeside-users mailing list