Ok, let me first say I WANT OTRS! This is the best thing since sliced bread (really!) when it comes to online CRMs (especially FREE ones!). I'm still kinda figuring out the capabilities of my hosted service. I'm hoping that OTRS will run in our environment. Webserver: Apache 1.3.26 (Unix) Operating System: FreeBSD 3.4-RELEASE Complier: GCC 2.7.2.3 Database: MySQL 3.23.32-log Perl 5.00503 PHP 4.2.2 PHP3 3.0.18 Sendmail 8.9.3 I also found out that I'm allowed one cron task, which will run at 3am every night and must be called crontask.cgi. What that means, I don't know, but I found it out anyway. I also do NOT have telnet or shell access. I use FTP for file managing, a PHP admin script for managing databases, and a text editor as well as using FrontPage for the site management, etc. So, that gets me stuck on step one (create user) of the installation (haha). shell> useradd -d /opt/OpenTRS/ otrs shell> cd /opt/ shell> tar -xzvf otrs-xxxx-xx.tar.gz shell> chown -r /opt/OpenTRS/* otrs Ok I understand that if I had the access, I'd pass those commands to the server. But can someone explain what exactly that does so that I can figure out the equivelant to getting it done. Is this setting up a mailbox? So I just need to create a otrs@heartlevelministries.org? Or if I want it to be info@heartlevelministries.org, is that gonna affect any files that maybe looking for "otrs"? Also, file structure - cgi files are enabled only in /cgi-bin. So I'm assuming I should extract the entire tar file into the /cgi-bin folder. It's the only place where scripts, etc. can be executed. Should that cause any problems with the program? I noticed that you have "/opt/OpenTRS" but for me I think it would need to be "/cgi-bin/OpenTRS" and what affect will that have? Note: Since I don't have telnet/shell access, I used WinZip to extract the files into a temp folder and then FTP'd them to their places. The bug was that when it aborts the extract because there is an "install" folder and an "INSTALL" file. Just thought you'd like to know. The only way around it is to extract everything except the INSTALL file since that's just a readme anyway. I did manage to setup the database just fine and completed the initial insert, but I TOTALLY get lost with the webserver steps. What exactly needs to be done (in non-programmer language). I am on a hosted server and can't modify the actual server itself. But I can set up user access to certain directories with an .htaccess file. Is this the same thing, and what would I need to do? Ok, I think that's enough questions for now, but there are plenty more to come :) If anyone is up for the challenge and wanted to help over AIM, I'd greatly appreciate your time. We're a non-profit receiving a LOT of emails and really need this system to be more efficient. Best Regards, Chris Day
Hi Chris, On Fri, Oct 25, 2002 at 11:39:21AM -0400, Chris Day wrote:
Ok, let me first say I WANT OTRS! This is the best thing since sliced bread (really!) when it comes to online CRMs (especially FREE ones!).
I'm still kinda figuring out the capabilities of my hosted service. I'm hoping that OTRS will run in our environment. [...] Webserver: Apache 1.3.26 (Unix) I also found out that I'm allowed one cron task, which will run at 3am every night and must be called crontask.cgi. What that means, I don't know, but I found it out anyway.
I also do NOT have telnet or shell access. I use FTP for file managing, a PHP admin script for managing databases, and a text editor as well as using FrontPage for the site management, etc.
So, that gets me stuck on step one (create user) of the installation (haha).
shell> useradd -d /opt/OpenTRS/ otrs shell> cd /opt/ shell> tar -xzvf otrs-xxxx-xx.tar.gz shell> chown -r /opt/OpenTRS/* otrs [...]
Did you say (http://lists.otrs.org/pipermail/otrs/2002-October/000389.html) that you can login? You did the installation without shell? :-o Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "Security is a process, not a product." - Bruce Schneider
Yeah, maybe that's the problem. I was able to install the entire program,
even saw the intial "welcome" ticket and closed it. The only problem is
that it doesn't pull in the emails, which I'm beginning to think may have
something to do with the fact that I can only run one cron task at 3am?
Because I don't have shell access, creating databases, etc. I just copied
the .sql into a text file and then pasted it into the sql executer that my
host provides and it created the tables and did the initial insert just
fine.
Instead of doing the extraction command, I had to manually extract all the
files first and upload them via FTP into their respective folders, etc.
That's why I'm trying to figure out reasons and purposes behind some of
these commands so I know what alternatives I have to do to make it work
without shell (which by the way, I don't even know what that is, I just know
I don't have it cus the FAQ answers that.)
Also, it's not in the root directory or even a web of its own, I'm uploading
it into our cgi-bin so that the path would be
heartlevelministries.org/cgi-bin/OpenTRS.....
So does this mean I'm trying something new??
Chris
Chris
----- Original Message -----
From: "Martin Edenhofer"
Hi Chris,
On Fri, Oct 25, 2002 at 11:39:21AM -0400, Chris Day wrote:
Ok, let me first say I WANT OTRS! This is the best thing since sliced bread (really!) when it comes to online CRMs (especially FREE ones!).
I'm still kinda figuring out the capabilities of my hosted service. I'm hoping that OTRS will run in our environment. [...] Webserver: Apache 1.3.26 (Unix) I also found out that I'm allowed one cron task, which will run at 3am every night and must be called crontask.cgi. What that means, I don't know, but I found it out anyway.
I also do NOT have telnet or shell access. I use FTP for file managing, a PHP admin script for managing databases, and a text editor as well as using FrontPage for the site management, etc.
So, that gets me stuck on step one (create user) of the installation (haha).
shell> useradd -d /opt/OpenTRS/ otrs shell> cd /opt/ shell> tar -xzvf otrs-xxxx-xx.tar.gz shell> chown -r /opt/OpenTRS/* otrs [...]
Did you say (http://lists.otrs.org/pipermail/otrs/2002-October/000389.html) that you can login?
You did the installation without shell? :-o
Martin
-- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "Security is a process, not a product." - Bruce Schneider
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Hi Chris, On Fri, Oct 25, 2002 at 03:05:20PM -0400, Chris Day wrote:
Yeah, maybe that's the problem. I was able to install the entire program, even saw the intial "welcome" ticket and closed it. The only problem is that it doesn't pull in the emails, which I'm beginning to think may have something to do with the fact that I can only run one cron task at 3am?
No.
Because I don't have shell access, creating databases, etc. I just copied the .sql into a text file and then pasted it into the sql executer that my host provides and it created the tables and did the initial insert just fine.
Instead of doing the extraction command, I had to manually extract all the files first and upload them via FTP into their respective folders, etc. That's why I'm trying to figure out reasons and purposes behind some of these commands so I know what alternatives I have to do to make it work without shell (which by the way, I don't even know what that is, I just know I don't have it cus the FAQ answers that.)
Also, it's not in the root directory or even a web of its own, I'm uploading it into our cgi-bin so that the path would be heartlevelministries.org/cgi-bin/OpenTRS.....
That's not so nice! Security... so everybody can execute the OpenTRS/bin/* commands. Or read some stuff from OpenTRS/var/*.
So does this mean I'm trying something new??
I think so! :) Ok, I want to help you. My suggestion would be to setup a local Linux box with OTRS (in your own lan). Of course, all agent need access to this lan. Fetch your needed email accounts (e. g. POP3) via fetchmail to the local linux box. The way to the customer could be SMTP. Done. If you need a "working" but insecure solution, how can you access the email of your webserver? mbox? Or is there fetchmail installed?
Chris
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- Old programmers never die. They just branch to a new address.
Ok, it does have to be in the cgi-bin but I can secure the OpenTRS folders
with permissions no problem leaving the public out in the cold :) So is
that what the first set of commands is doing? Just setting up permissions?
I can do that with an .htaccess file.
As far as Linux, I don't really know anything about it (yet) and don't own
my own server, but from what I've learned so far, I could install a
"mini-version" of Linux on my Windows PC and run a partition of my computer
as a server to make our own LAN? And how would for example my assistant who
works from her home across town be able to access it via internet? Would I
also need to install Linux on her machine?
Chris
----- Original Message -----
From: "Martin Edenhofer"
Hi Chris,
On Fri, Oct 25, 2002 at 03:05:20PM -0400, Chris Day wrote:
Yeah, maybe that's the problem. I was able to install the entire program, even saw the intial "welcome" ticket and closed it. The only problem is that it doesn't pull in the emails, which I'm beginning to think may have something to do with the fact that I can only run one cron task at 3am?
No.
Because I don't have shell access, creating databases, etc. I just copied the .sql into a text file and then pasted it into the sql executer that my host provides and it created the tables and did the initial insert just fine.
Instead of doing the extraction command, I had to manually extract all the files first and upload them via FTP into their respective folders, etc. That's why I'm trying to figure out reasons and purposes behind some of these commands so I know what alternatives I have to do to make it work without shell (which by the way, I don't even know what that is, I just know I don't have it cus the FAQ answers that.)
Also, it's not in the root directory or even a web of its own, I'm uploading it into our cgi-bin so that the path would be heartlevelministries.org/cgi-bin/OpenTRS.....
That's not so nice! Security... so everybody can execute the OpenTRS/bin/* commands. Or read some stuff from OpenTRS/var/*.
So does this mean I'm trying something new??
I think so! :)
Ok, I want to help you. My suggestion would be to setup a local Linux box with OTRS (in your own lan). Of course, all agent need access to this lan.
Fetch your needed email accounts (e. g. POP3) via fetchmail to the local linux box. The way to the customer could be SMTP. Done.
If you need a "working" but insecure solution, how can you access the email of your webserver? mbox? Or is there fetchmail installed?
Chris
Martin
-- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- Old programmers never die. They just branch to a new address.
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Hi Chris, On Sat, Oct 26, 2002 at 08:26:00AM -0400, Chris Day wrote:
Ok, it does have to be in the cgi-bin but I can secure the OpenTRS folders with permissions no problem leaving the public out in the cold :) So is that what the first set of commands is doing? Just setting up permissions? I can do that with an .htaccess file.
As far as Linux, I don't really know anything about it (yet) and don't own my own server, but from what I've learned so far, I could install a "mini-version" of Linux on my Windows PC and run a partition of my computer as a server to make our own LAN? And how would for example my assistant who works from her home across town be able to access it via internet? Would I also need to install Linux on her machine?
No, that's is no good idea (mini linux on you workstation). Ok, if you want to use OTRS on your shared webspace, I need to know, you can access emails on your webspace via programmes on the webspace? The frontend is working (you can login), now we need to get the "backen" (PostMaster.pl) working. The PostMaster.pl needs emails (pipes emails into the OTRS database).
Chris
-- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- nohl: 2:24pm up 4 days, 16:57, 6 users, load average: 0.08, 0.08, 0.05
participants (2)
-
Chris Day -
Martin Edenhofer