Topic: Phreebooks install (accounting/ERP package)

[janet]

Charles2008

Use
nano -w filename

when editing to prevent unwanted line wrapping.
Incorrect line wrapping does make a BIG difference !

[janet]

Stefano

if tmp is a html's subdirectory, there's no reason to add its path

I'm not professing to be an expert on this topic & trailing slashes, but if a trailing slash is used I think you need to specify the subfolder seperately after the colon.

The last command I suggested did not use trailing slashes, so superfluous, but cautious.

This bug report is about a very similar issue (almost identical really) and the suggestion is to NOT use trailing slashes.
https://bugs.launchpad.net/ubuntu/+source/php5/+bug/701765

[Charles2008]

I did this and it wasn't clear what is was showing me (didn't seem any different than
 nano filename

Anyway I manually edited the line and finished with:

Code: [Select]

expand-template /etc/httpd/conf/httpd.conf
signal-event remoteaccess-update
It now looks like this:

Code: [Select]

# Set the sandbox within which PHP is confined to play
                my $basedir = $ibay->prop('PHPBaseDir')
                    || ("/home/e-smith/files/ibays/" . $ibay->key . "/");
                $OUT .= "    php_admin_value open_basedir $basedir\n";
                 my $tmpdir = $ibay->prop('PHPTmpDir')
                     || ("/home/e-smith/files/ibays/" . $ibay->key . "/tmp");
                   $OUT .= "    php_admin_value upload_tmp_dir $tmpdir\n";
                $OUT .= "</Directory>\n";
Still no change. I am nervously hoping I am carrying out your instructions correctly.
This should have worked. Correct?

Mary,

Have you and Stefano agreed that you proposal is ok or not? Should I impliment now. I am not going to rush ahead without confirmation.

Also - "Handisoft" - I have never heard of it. I had imagined it to be hand cream until I looked it up (or a new Microsoft app for Tradesmen). There must be an imposter! I do hope that he is polite and not giving me a bad name.

[guest22]

Just to make sure, close your browser completely to clear cache and can you try again?

[guest22]

What is the result of:

cat /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/95AddType00PHP2ibays

[Charles2008]

RequestedDeletion

PC restarted. No change.

Code: [Select]

cat /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/95AddType00PHP2ibays
{
    my $status = $php{status} || 'disabled';
    if ($status eq 'enabled')
    {
use esmith::AccountsDB;
my $adb = esmith::AccountsDB->open_ro();
foreach my $ibay ($adb->ibays)
{
    local $dynamicContent = $ibay->prop('CgiBin') || 'disabled';
    if ($dynamicContent eq 'enabled')
    {
$OUT .= "\n<Directory /home/e-smith/files/ibays/" . $ibay->key . "/html>\n";
$OUT .= "    AddType application/x-httpd-php .php .php3 .phtml\n";
$OUT .= "    AddType application/x-httpd-php-source .phps\n";

# Set the sandbox within which PHP is confined to play
my $basedir = $ibay->prop('PHPBaseDir')
    || ("/home/e-smith/files/ibays/" . $ibay->key . "/");
$OUT .= "    php_admin_value open_basedir $basedir\n";
                 my $tmpdir = $ibay->prop('PHPTmpDir')
                     || ("/home/e-smith/files/ibays/" . $ibay->key . "/tmp");
                   $OUT .= "    php_admin_value upload_tmp_dir $tmpdir\n";
$OUT .= "</Directory>\n";
    }
}
    }
}

Charles

[guest22]

where did you get this from ?

# Set the sandbox within which PHP is confined to play

Please remove that line from the custom template, expand signal modify and update remote access

[Charles2008]

RequestedDeletion

# Set the sandbox within which PHP is confined to play
is copied from this file:
/etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/95AddType00PHP2ibays    ...   which is my new 'custom-template'. Right? (BTW I didn't add it ).
Here, about 2/3 the way down:

Code: [Select]

{
    my $status = $php{status} || 'disabled';
    if ($status eq 'enabled')
    {
      use esmith::AccountsDB;
        my $adb = esmith::AccountsDB->open_ro();
        foreach my $ibay ($adb->ibays)
        {
            local $dynamicContent = $ibay->prop('CgiBin') || 'disabled';
            if ($dynamicContent eq 'enabled')
            {
              $OUT .= "\n<Directory /home/e-smith/files/ibays/" . $ibay->key . "/html>\n";
                $OUT .= "    AddType application/x-httpd-php .php .php3 .phtml\n";
                $OUT .= "    AddType application/x-httpd-php-source .phps\n";

                # Set the sandbox within which PHP is confined to play
                my $basedir = $ibay->prop('PHPBaseDir')
                    || ("/home/e-smith/files/ibays/" . $ibay->key . "/");
                $OUT .= "    php_admin_value open_basedir $basedir\n";
                 my $tmpdir = $ibay->prop('PHPTmpDir')
                     || ("/home/e-smith/files/ibays/" . $ibay->key . "/tmp");
                   $OUT .= "    php_admin_value upload_tmp_dir $tmpdir\n";
                $OUT .= "</Directory>\n";
            }
}
    }
}

I will remove the line as you suggest. However, should there be an empty line above it? I will leave the empty line there for now - unless you instruct me otherwise.

Code: [Select]

Please remove that line from the custom template, expand signal modify and update remote access   ...   done.

The problems still exist, including:
- can't save modifications to desktop
- can't 'print' reports to html, .pdf,
- doesn't copy ALL customer details across from 'Bill to' to 'Ship to' as it should with one click. It ONLY copies across customers name.
- no additional data field is created in the Sales Order when  'drop ship'  is selected.
- cannot create a stock item
- In the General Journal entry the input boxes are missing   ....   etc etc

I am sorry that this is dragging on for you. Thanks for being patient.
Charles

[janet]

3 chefs & a trainee cook all trying to bake a pie, hmmm, wonder what the completed pie will taste like !!???!

There are other errors in those log files that probably should not be ignored.
Charles comments potentially indicate the custom template already existed, so the server may have "red herrings" that the chefs were not expecting and could be impacting upon the result.

Charles can you advise if the custom template was already in existence before you followed advice provided here ?

What is the history of this server ?
Has some other technical sysadmin person been working on it ?

[Charles2008]

Hi Mary,

Yes, in retrospect I should have covered this in my opening post.

The SME8 is a fresh install. All I had done with it before the Phreedom attempted install was to install MySQL.

I hadn't make a custom-template (copying a 'template' to a new 'custom-template' file and modifying the code), but, after trawling the forums I had followed the instructions which were v similar to yours with the db and /:/tmp instructions (perhaps they were yours) - I detailed this in the OP.
Nobody else has played with this sever.

Fingers crossed for a souffle and not scrambled egg

Charles

[janet]

Charles2008

Well here is the original template fragment for 95AddType00PHP2ibays
which has the line hashed out
 # Set the sandbox within which PHP is confined to play
and that is OK & safe to have in there and answers RequestedDeletion query of where did it come from.




    {
        use esmith::AccountsDB;
        my $adb = esmith::AccountsDB->open_ro();
        foreach my $ibay ($adb->ibays)
        {
            local $dynamicContent = $ibay->prop('CgiBin') || 'disabled';
            if ($dynamicContent eq 'enabled')
            {
                $OUT .= "\n<Directory /home/e-smith/files/ibays/" . $ibay->key . "/html>\n";
                $OUT .= "    AddType application/x-httpd-php .php .php3 .phtml\n";
                $OUT .= "    AddType application/x-httpd-php-source .phps\n";

                # Set the sandbox within which PHP is confined to play
                my $basedir = $ibay->prop('PHPBaseDir')
                    || ("/home/e-smith/files/ibays/" . $ibay->key . "/");
                $OUT .= "    php_admin_value open_basedir $basedir\n";
                $OUT .= "</Directory>\n";
            }
        }
    }
}

[janet]

Charles2008

I did this and it wasn't clear what is was showing me (didn't seem any different than
 nano filename

FYI

nano
and
nano -w
both open the nano editor, but the -w switch tells nano NOT to limit the line length, and so therefore NOT to wrap long lines onto the next line,
That's the difference, it's not in what you "see" but how the end result is saved.

As a general rule always use nano -w and then there is no chance of creating files with inadvertantly wrapped lines.

at command prompt do
man nano

You can use man (short for manual) to look up many things
http://en.wikipedia.org/wiki/Man_page

[janet]

Charles2008

The problems still exist, including:
- can't save modifications to desktop
- can't 'print' reports to html, .pdf,
- doesn't copy ALL customer details across from 'Bill to' to 'Ship to' as it should with one click. It ONLY copies across customers name.
- no additional data field is created in the Sales Order when  'drop ship'  is selected.
- cannot create a stock item
- In the General Journal entry the input boxes are missing   ....   etc etc

Perhaps these user level issues are best taken to the Phreebooks forum
http://www.phreesoft.com/forum/index.php

[guest22]

@Charles2008

... All I had done with it before the Phreedom attempted install was to install MySQL.

Why did you install MySQL? It comes with SME8 by default.

[Charles2008]

Mary
Thank you for the explanation.

Re. Phreebooks forum - yes, you have a point. However, these problems are clearly a symptom of something amiss with the PB / SME install. I installed it on Debian and tested for 2 months without issue. I do think that there is a problem with the install.


RequestedDeletion

It was v late last night - I meant phpMyAdmin - sorry. To set up and administer the database.