
Hallo, Yesterday I installed OpenTRS BETA7 on FreeBSD 4.6.2-p2 with PostgreSQL. The install went fine once I got all the Perl modules installed, though I think I need to setup mod_perl to get the speed I'd like. Some comments/suggestions... - in the INSTALL document, step 2, it would be useful if you mentioned that the otrs user needs to be in the nogroup group to work properly later with SetPermissions.pl etc. - to get the initial PostgreSQL-specific schema file working I had to do the insert twice - the first time there were many errors about missing tables, but the second time it worked fine (I'm guessing because the tables were there from the first insert :). This should probably be documented, or the order of table creation changed around in the SQL. - I had to do a "chgrp -R www $HOME/var/article" to allow Apache to write copies of the messages sent. Maybe document this? - Most of the general otrs config seems to be in the Kernel/Config.pm file, which I'd assume is overwritten if I do an upgrade. Might be worth looking into something like Mailman or FreeBSD has, where the application has default settings which are overridden (if needed) by a file that's not included in the application tarball. Makes upgrades easier. :) I think that's it for now, just getting into setting up users/groups and queues now, so will probably have more to comment on later. :) Also, I can definitely host an FTP mirror in Canada if there's interest, and possibly a demo system depending what's needed for that... Thanks for the cool software! Bryan -- Bryan Fullerton http://bryanfullerton.com/ Core Competency uunet.ca!gts!cspace!bryanf Samurai Consulting Inc.

Hi Bryan, On Sat, Oct 12, 2002 at 09:03:40AM -0400, Bryan Fullerton wrote:
[...] like. Some comments/suggestions...
- in the INSTALL document, step 2, it would be useful if you mentioned that the otrs user needs to be in the nogroup group to work properly later with SetPermissions.pl etc.
Fixed.
- to get the initial PostgreSQL-specific schema file working I had to do the insert twice - the first time there were many errors about missing tables, but the second time it worked fine (I'm guessing because the tables were there from the first insert :). This should probably be documented, or the order of table creation changed around in the SQL.
I'll check this.
- I had to do a "chgrp -R www $HOME/var/article" to allow Apache to write copies of the messages sent. Maybe document this?
Did you use SetPermissions.pl?
- Most of the general otrs config seems to be in the Kernel/Config.pm file, which I'd assume is overwritten if I do an upgrade. Might be worth looking into something like Mailman or FreeBSD has, where the application has default settings which are overridden (if needed) by a file that's not included in the application tarball. Makes upgrades easier. :)
That's a nice idea. I put it on the todo list.
I think that's it for now, just getting into setting up users/groups and queues now, so will probably have more to comment on later. :)
Fine! Thanks again. :))
Bryan
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "There are two major products that come out of Berkeley: LSD and Unix. We don't believe this to be a coincidence." -- Jeremy S. Anderson

On Monday, October 14, 2002, at 06:15 AM, Martin Edenhofer wrote:
- I had to do a "chgrp -R www $HOME/var/article" to allow Apache to write copies of the messages sent. Maybe document this?
Did you use SetPermissions.pl?
Hmm, I'm sure I did, but I installed a couple of times, so I might have forgotten the second time. Or I might have given the wrong group. Looking at the script now, it should have solved that problem for me, so this one's probably my fault. :)
[easier config stuff]
That's a nice idea. I put it on the todo list.
Cool, thanks! Bryan

On Monday, October 14, 2002, at 05:08 PM, Bryan Fullerton wrote:
On Monday, October 14, 2002, at 06:15 AM, Martin Edenhofer wrote:
- I had to do a "chgrp -R www $HOME/var/article" to allow Apache to write copies of the messages sent. Maybe document this?
Did you use SetPermissions.pl?
Ok, time to revisit this. :) I ran bin/SetPermissions.pl, and it broke $HOME/var/article again. So this *does* need to be fixed in SetPermissions.pl. Looking at the script, the only things I see which affect $HOME/var/article are: chown -R $OTRSUSER.$OTRSGROUP $OTRSDEST/var/ chmod -R 2775 $OTRSDEST/var/article/ Which is wrong, unless your web user is in $OTRSGROUP. There should be something in there like: chgrp -R $WEBGROUP $HOME/var/article/ Otherwise, the web server can't write files into $HOME/var/article, which it tries to do each time you send an email response. Also, I note that SetPermissions.pl tries to do a 'chown $OTRSUSER.root' in several places, which won't work on FreeBSD (or any other OS without a root group). Perhaps something like 'chown $OTRSUSER.0' (0 should be root's numeric gid?). Didn't particularly break anything, but there's probably some reason you're trying to do that. Thanks, Bryan

Hi Bryan, On Thu, Oct 17, 2002 at 12:48:00PM -0400, Bryan Fullerton wrote:
I ran bin/SetPermissions.pl, and it broke $HOME/var/article again. So this *does* need to be fixed in SetPermissions.pl. Looking at the script, the only things I see which affect $HOME/var/article are:
chown -R $OTRSUSER.$OTRSGROUP $OTRSDEST/var/ chmod -R 2775 $OTRSDEST/var/article/
Which is wrong, unless your web user is in $OTRSGROUP. There should be something in there like:
chgrp -R $WEBGROUP $HOME/var/article/
Otherwise, the web server can't write files into $HOME/var/article, which it tries to do each time you send an email response.
Fixed.
Also, I note that SetPermissions.pl tries to do a 'chown $OTRSUSER.root' in several places, which won't work on FreeBSD (or any other OS without a root group). Perhaps something like 'chown $OTRSUSER.0' (0 should be root's numeric gid?). Didn't particularly break anything, but there's probably some reason you're trying to do that.
A good idea. I changed it. Thanks.
Bryan
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "Security is a process, not a product." - Bruce Schneider
participants (2)
-
Bryan Fullerton
-
Martin Edenhofer