Koozali.org: home of the SME Server

How to install Epiware on SME server 7.3

Offline jessica

  • 1
  • +0/-0
How to install Epiware on SME server 7.3
« on: December 04, 2008, 02:10:18 AM »
Can anyone show me step by step how to install Epiware on SME server 7.3?

Offline edform

  • *
  • 178
  • +0/-0
    • http://www.workgroupsolutions.co.uk
Re: How to install Epiware on SME server 7.3
« Reply #1 on: December 12, 2008, 03:29:26 AM »
Can anyone show me step by step how to install Epiware on SME server 7.3?

It's pretty easy, but there was one infuriating item that I couldn't solve until I tricked it to work. The way the program is set up by its install script, with the storage area in a folder called '/storage,' with 'binaries' and 'document_area' subfolders, produces an error when you first log in which says 'Either the directory '/storage/document_area' doesn't exist or the httpd user doesn't have permission to write to it. No matter what I did I couldn't solve this. Then it dawned on me that I should move the document storage area into the 'files' area of the ibay and the problem simply went away. Program looks very nice! Here's how to do it.

Because my server does lots of stuff, I couldn't place the php code in the primary ibay which would give a straightforward URL for the program in the form http://www.myserver.com/epi. Instead I had to place the code in a new ibay which I called 'epiware', and this gives the URL: http://www.myserver.com/epiware/epi - a bit clumsy. So I altered the install to get round this...

First create an ibay called 'epiware' with the kind of access you want and allow it to run CGI etc. For my trial I just chose to make it accessible on the local network with no password, but you could make it face the internet and protect it with a password - make it really strong.

Now log in to your server console and download the program with...

wget http://downloads.sourceforge.net/epiware/Epiware_4.8.6.tar.gz

Once the download is complete run...

tar -xvzf Epiware_4.8.6.tar.gz

...and you'll see the archive decompress with a long stream of filenames scrolling up the screen.

Now do...

cd Epiware_4.8.6

and then run...

./install

You'll get a set of instructions on the screen telling you to run...

mysql -u root -p < epi/project_db.sql

...do so. Then it says you should move the program's 'epi' folder to your htdocs directory. This is the first thing you need to vary. To avoid the clumsy URL problem described above, we don't want the 'epi' folder, only it's contents, so run...

cp -r epi/* /home/e-smith/files/ibays/epiware/html

When that's done we need to change the ownership of the files...

chown -R www:www /home/e-smith/files/ibays/epiware/html

Now for the second variation from their way of doing things: the install routine created a folder '/storage' which contains subfolders 'binaries' and 'document_area'; leave the 'binaries' folder alone but delete the 'document_area' folder...

rm -r /storage/document_area

Now we need to tell the program where it's going to store it's files, and one or two other items of configuration information, so we need to edit the file 'config.inc.php'...

cd /home/e-smith/files/ibays/epiware/html

[I've assumed you are a linux newby, so slap my wrist for the next command if you are a time-seved maven who swims about in the editor vi for fun - I *hate* it.]

mcedit config.inc.php

This gets you a nice text editor with the configuration file loaded. You need to make the following changes...

On the first two lines with a pink 'define' at the beginning, change 'www.mycompany.com' to your own domain URL and change the email address to something like 'doc-admin@yourdomain.com'.

Skip down to the series of lines at the bottom...

  define("DOCUMENT_DIRECTORY","/storage/document_area");
  define("CALENDAR_ATTACHMENT_DIRECTORY","/storage/attachments");
  define("IMAGE_GALLERY_PATH","/storage/document_area");
  define("ERROR_LOG_PATH", "/storage/document_area");
  //a document area for wiki-group banners - unlike document area, this cannot be changed w/o moving all files at a later date
  define("EPI_BANNER_DIRECTORY","/storage/document_area");

...and change all the directory settings to '/home/e-smith/files/ibays/epiware/files' - that's 4 '/storage/document_area' settings and 1 '/storage/attachment' setting.

When you've done all the editing check it carefully to be sure you haven't mistyped anything, then hit F2 and confirm you want to save the file and hit F10 to leave the editor. You can log out of the server console also.

Now go to a workstation and type http://www.yourserver.com/epiware into the browser and you should get your first login prompt - you need to enter a bunch of stuff about yourself and give a username and password and the next time you go in you'll only get asked for username and password.

Enjoy.

Ed Form
« Last Edit: December 12, 2008, 03:34:29 AM by edform »

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: How to install Epiware on SME server 7.3
« Reply #2 on: December 12, 2008, 12:40:13 PM »
Here's how to do it.
Please also post this in the wiki in the Category:Howto
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline edform

  • *
  • 178
  • +0/-0
    • http://www.workgroupsolutions.co.uk
Re: How to install Epiware on SME server 7.3
« Reply #3 on: December 14, 2008, 12:08:52 AM »
Please also post this in the wiki in the Category:Howto

I've created the page...

http://wiki.contribs.org/Category:Howto/Epiware

What do I do next?

Offline e[nt]e

  • *
  • 172
  • +0/-0
Re: How to install Epiware on SME server 7.3
« Reply #4 on: December 14, 2008, 01:19:29 AM »
I've created the page...

http://wiki.contribs.org/Category:Howto/Epiware

What do I do next?
Please also post this in the wiki in the Category:Howto

That shouldn't mean that you would create a new subpage but to create a new page which you would then categorize as a Howto to have it appear on the category page.
But never mind, thanks for the effort anyway.
It seems I can't move a subpage of the category, let's have cactus have a look at this :D
1984 wasn't meant to be a manual.

Offline janet

  • *****
  • 4,812
  • +0/-0
Re: How to install Epiware on SME server 7.3
« Reply #5 on: December 14, 2008, 08:19:41 AM »
edform

The original page has been copied to
http://wiki.contribs.org/Epiware

Perhaps an admin can delete the original at
http://wiki.contribs.org/Category:Howto/Epiware

« Last Edit: December 14, 2008, 09:15:50 AM by mary »
Please search before asking, an answer may already exist.
The Search & other links to useful information are at top of Forum.

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: How to install Epiware on SME server 7.3
« Reply #6 on: December 14, 2008, 09:11:24 AM »
It seems I can't move a subpage of the category, let's have cactus have a look at this :D
Of course, as always.

Perhaps an admin can delete the original at
http://wiki.contribs.org/Category:Howto/Epiware
Done.
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline e[nt]e

  • *
  • 172
  • +0/-0
1984 wasn't meant to be a manual.

Offline edform

  • *
  • 178
  • +0/-0
    • http://www.workgroupsolutions.co.uk
Re: How to install Epiware on SME server 7.3
« Reply #8 on: December 14, 2008, 02:28:43 PM »
That shouldn't mean that you would create a new subpage but to create a new page which you would then categorize as a Howto to have it appear on the category page.

Do I take it that the correct method for creating a Howto is to produce a page at...

http://wiki.contribs.org/NewHowtoSubject

...and then add the single line...

Category: Difficulty|Howto

...at the end of the Howto text?

I searched for quite a while and found no instructions on how to do this - there were several documents on how to format wiki text, most of which were seriously confusing, so I just cheated and cut-and-pasted the text of a well-formatted Howto into my new page then overlaid my text on that formatting - what I did not find was a simple: 'Howto add a Howto to the SME wiki.' Perhaps someone should add a second sticky to the top of the contribs forum like the comprehensive one on creating and uploading new contribs.

Ed Form
« Last Edit: December 14, 2008, 02:52:41 PM by edform »

Offline e[nt]e

  • *
  • 172
  • +0/-0
Re: How to install Epiware on SME server 7.3
« Reply #9 on: December 14, 2008, 03:17:43 PM »
Do I take it that the correct method for creating a Howto is to produce a page at...

http://wiki.contribs.org/NewHowtoSubject

...and then add the single line...

Category: Difficulty|Howto

...at the end of the Howto text?
Nearly :)
It's correct that a new Howto should be created as a seperate page like http://wiki.contribs.org/NewHowtoSubject

[[Category:Howto]] adds the page to the Howto Category which means it will be shown at http://wiki.contribs.org/Category:Howto.
For more information on categories you could read this page: http://wiki.contribs.org/Help:Categories

{{Level|Medium}} (in this case) adds the Skill template on top off the page and makes sure that the page is allocated to the Medium Category. (For more information read this: http://wiki.contribs.org/Template:Level)

I searched for quite a while and found no instructions on how to do this - there were several documents on how to format wiki text, most of which were seriously confusing, so I just cheated and cut-and-pasted the text of a well-formatted Howto into my new page then overlaid my text on that formatting - what I did not find was a simple: 'Howto add a Howto to the SME wiki.' Perhaps someone should add a second sticky to the top of the contribs forum like the comprehensive one on creating and uploading new contribs.
You're right AFAIK there is no 'Howto add a Howto to the SME wiki' but there is this page which is a overview of the things you may need to know for contributing to the wiki.
I don't know if a sticky post in the contribs forum would be the right place for this maybe let's do it like on http://wiki.contribs.org/Category:Contrib where on the talk page is a outline for new contribs wiki pages.
But generally you're starting point with copying another page is absolutely right. You just copied it to the wrong place ;)

Regards,
Niklas
1984 wasn't meant to be a manual.

Offline manegar

  • **
  • 24
  • +0/-0
Re: How to install Epiware on SME server 7.3
« Reply #10 on: January 06, 2010, 01:57:11 PM »
Hi,
      Thanks for the Epiware Howto, well I have one small issue in Epiware. I have installed new server-only SME 7.4 and installed Epiware as per your howto but I am not able to upload any files (no error is also shown). Can you please help me out with this issue.

With Regards,

Avi

Offline edform

  • *
  • 178
  • +0/-0
    • http://www.workgroupsolutions.co.uk
Re: How to install Epiware on SME server 7.3
« Reply #11 on: January 06, 2010, 07:13:51 PM »
Hi,
      Thanks for the Epiware Howto, well I have one small issue in Epiware. I have installed new server-only SME 7.4 and installed Epiware as per your howto but I am not able to upload any files (no error is also shown). Can you please help me out with this issue.

Hi Avi,

I'm not going to be much help, I'm afraid; I don't actually use this program. I only got involved and wrote the HowTo because a forum member wanted help. What I do remember is that my HowTo works because I wrote it as I did it, point by point. My guess is your problem is a permissions issue or a mistype in one of the directory lines that have to be changed.

Did you carry out the Chown command...

         chown -R www:www /home/e-smith/files/ibays/epiware/html ?

And have you checked the 5 changed lines in config.inc.php?

I don't have a running server at the moment because I'm moving offices and the bad weather has put a crimp in my schedule. I'll try to redo this install on my own server when I get it up again, but please don't hold your breathe.

Ed Form


Offline manegar

  • **
  • 24
  • +0/-0
Re: How to install Epiware on SME server 7.3
« Reply #12 on: January 07, 2010, 08:50:34 AM »
Hi Avi,

I'm not going to be much help, I'm afraid; I don't actually use this program. I only got involved and wrote the HowTo because a forum member wanted help. What I do remember is that my HowTo works because I wrote it as I did it, point by point. My guess is your problem is a permissions issue or a mistype in one of the directory lines that have to be changed.

Did you carry out the Chown command...

         chown -R www:www /home/e-smith/files/ibays/epiware/html ?

And have you checked the 5 changed lines in config.inc.php?

I don't have a running server at the moment because I'm moving offices and the bad weather has put a crimp in my schedule. I'll try to redo this install on my own server when I get it up again, but please don't hold your breathe.

Ed Form

Hey Ed,
   Thanks for the reply, I have installed and followed exactly the same way from your how to. I have double, triple checked, rechecked the configuration from the how to and it exactly reflects the same on my machine also, but I am not able to find why I cannot upload any files.
   Any way I have also raised a ticket for this issue to Epiware support and waiting for their reply.
Thanks again for the reply and I hope you get time to redo this installation and post your results back (take your time and I’ll not hold my breath  :lol: )
Little late though but belated New Year Wishes from all of us here.

Thanks & Regards,
Avi

Offline manegar

  • **
  • 24
  • +0/-0
Re: How to install Epiware on SME server 7.3
« Reply #13 on: January 07, 2010, 01:38:27 PM »
Update:
   I have done some modifications according to PHP how to (http://wiki.contribs.org/PHP) that is

db accounts setprop eroom PHPBaseDir /home/e-smith/files/ibays/eroom/html/

signal-event ibay-modify eroom

(before applying the above command, PHPBaseDir was blank)

now when I am trying to upload the files it throws an error “Error, cannot to write to directory /home/e-smith/files/ibays/eroom/files” I have applied chown to all the folders available in the “eroom” ibay

[root@dms eroom]# ls -ls
total 44
 4 drwxrws---   2 www www  4096 Oct 14  2008 cgi-bin
 4 drwxrws---   3 www www  4096 Jan  7 16:26 files
36 drwxrws---  19 www www 36864 Jan  7 17:40 html

I also found some error in /var/log/httpd/error_log :
Thu Jan 07 16:44:21 2010] [error] [client 192.x.x.x] File does not exist: /home/e-smith/files/ibays/eroom/html/undefined, referer: http://192.x.x.x/eroom/index_library.php

[Thu Jan 07 16:48:50 2010] [error] [client 192.x.x.x] File does not exist: /home/e-smith/files/ibays/eroom/html/undefined, referer: http://192.x.x.x/eroom/index_library.php

[Thu Jan 07 16:49:32 2010] [error] [client 192.x.x.x] File does not exist: /home/e-smith/files/ibays/eroom/html/undefined, referer: http://192.x.x.x/eroom/index_library.php

[Thu Jan 07 16:51:21 2010] [error] [client 192.x.x.x] File does not exist: /home/e-smith/files/ibays/eroom/html/undefined, referer: http://192.x.x.x/eroom/index_library.php

[Thu Jan 07 16:51:21 2010] [error] [client 192.x.x.x] File does not exist: /home/e-smith/files/ibays/eroom/html/undefined, referer: http://192.x.x.x/eroom/index_library.php

Anyone worked on Epiware with SME, please do help me to resolve this issue.

Thanks & Regards,
Avi


Offline Joeg1484

  • **
  • 35
  • +0/-0
Re: How to install Epiware on SME server 7.3
« Reply #14 on: May 15, 2010, 05:39:33 AM »
I, too, am getting these errors and I have chmod 777 all dirs as a test.

Is there some kind of file upload blockage in SME server for PHP that is not in the templets? I am also unable to upload files from multiple web applications, not just Epi.

Thanks in advance for any assistance.

Joe