Hello, arround two years ago I had already asked this, but now it is more or less urgent. I run IBM eServer with a bunchof Apache VHosts and several customers. With OTRS it is not possibel, to run one VHost and have e.g. three differnt targets like "abuse", "support" and "info" like http://support.customer1.com/abuse/ /info/ /support/ http://support.customer2.com/abuse/ /info/ /support/ ... Also it is not possibel to have more then one customer on a server, because OTRS enforce to use ONE database instead one database per customer and target. Then I modified OTRS to support the two things above, but now I get the hell of mySQL performance and it crash all the time Does someone know a more suitable RequestTracker for this kind of usage? Also it should support PostgreSQL and use PHP5 or PHP6 The servers are IBM eServer x345 with Xeon DualCore 3GHz, 8 GByte memory and 6x 147 GByte U320/15k SCSI Drives (Raid-5 + Hotfix) Thanks, Greetings and nice Day/Evening Michelle Konzack -- ##################### Debian GNU/Linux Consultant ###################### Development of Intranet and Embedded Systems with Debian GNU/Linux itsystems@tdnet France EURL itsystems@tdnet UG (limited liability) Owner Michelle Konzack Owner Michelle Konzack Apt. 917 (homeoffice) 50, rue de Soultz Kinzigstraße 17 67100 Strasbourg/France 77694 Kehl/Germany Tel: +33-6-61925193 mobil Tel: +49-177-9351947 mobil Tel: +33-9-52705884 fix http://www.itsystems.tamay-dogan.net/ http://www.flexray4linux.org/ http://www.debian.tamay-dogan.net/ http://www.can4linux.org/ Jabber linux4michelle@jabber.ccc.de Linux-User #280138 with the Linux Counter, http://counter.li.org/
With OTRS it is not possibel, to run one VHost and have e.g. three differnt targets like "abuse", "support" and "info" like
http://support.customer1.com/abuse/ /info/ /support/ http://support.customer2.com/abuse/ /info/ /support/
Why do you not think this is possible? And what will going to /abuse/ do? or /info/ or /support/? These aren't native to OTRS.
Also it is not possibel to have more then one customer on a server, because OTRS enforce to use ONE database instead one database per customer and target.
I don't understand this, either. Of course OTRS supports more than one customer. What does "support more than one customer" mean to you?
You don't have to have an entirely different MySQL instance to run multiple instances of OTRS, either. Further, why are you asking on the OTRS mailing list to tell you of another product? If we can help, we'll try. If your mind is made up, I'm sure you can find something.http://www.google.com/search?sourceid=chrome&ie=UTF-8&q=php+postgres+ticketi... How, specifically, may we help you?
Hello Gerald Young, Am 2011-02-10 18:10:59, hacktest Du folgendes herunter:
http://support.customer1.com/abuse/ /info/ /support/ http://support.customer2.com/abuse/ /info/ /support/ Why do you not think this is possible? And what will going to /abuse/ do? or /info/ or /support/? These aren't native to OTRS.
Someone has pointed me to "multi-hosting" on 1.3 but I have not found a similar thing on 2.4.9 which does not accept the settings. So I have installed otrs 2.4.9 in the /target/ direcories directly (because the differnt config files), but this does not work because it breaks all links...
I don't understand this, either. Of course OTRS supports more than one customer. What does "support more than one customer" mean to you?
I am selling Internet Services so I have generaly more then one customer on one Machine and the have e.g. a <support> VHost like http://support.customer1.com/ http://support.customer2.com/
You don't have to have an entirely different MySQL instance to run multiple instances of OTRS, either.
But otrs can only use ONE database and this is a security violation because my customers have Database-Access and I do not want, that one customer read the data of an other customer.
Further, why are you asking on the OTRS mailing list to tell you of another product?
I am searching for a product which support maybe 25 customers and each of them with its own targets. The problem is that you can have only one database and if you have a Server where you host different domains from different customers, the database is shared.
If we can help, we'll try. If your mind is made up, I'm sure you can find something.http://www.google.com/search?sourceid=chrome&ie=UTF-8&q=php+postgres+ticketi...
How, specifically, may we help you?
I run Debian Squeeze/6.0 and used otrs 2.4.9, but it enforce to install mySQL even if I have already a full blown PostgreSQl installed I do not know why, but since Debian Sarge/3.1 mySQL blows-up any systems which are runing PostgreSQL already (mySQL is consuming any free memory and try to kick-off any other programs running) Thanks, Greetings and nice Day/Evening Michelle Konzack -- ##################### Debian GNU/Linux Consultant ###################### Development of Intranet and Embedded Systems with Debian GNU/Linux itsystems@tdnet France EURL itsystems@tdnet UG (limited liability) Owner Michelle Konzack Owner Michelle Konzack Apt. 917 (homeoffice) 50, rue de Soultz Kinzigstraße 17 67100 Strasbourg/France 77694 Kehl/Germany Tel: +33-6-61925193 mobil Tel: +49-177-9351947 mobil Tel: +33-9-52705884 fix http://www.itsystems.tamay-dogan.net/ http://www.flexray4linux.org/ http://www.debian.tamay-dogan.net/ http://www.can4linux.org/ Jabber linux4michelle@jabber.ccc.de ICQ #328449886 Linux-User #280138 with the Linux Counter, http://counter.li.org/
Currently, I am running OTRS 2.4 and 3.0 on the same box.
The concepts should apply, more or less, to virtual hosts.
Also, Postgresql is able to be used if you want to install from source.
stuff to add to the vhost directives. You may wish to use variables or
mod_macro http://www.cri.ensmp.fr/~coelho/mod_macro/
# --
# added for OTRS (http://otrs.org/)
# $Id: apache2-httpd-new.include.conf,v 1.5 2008/11/10 11:08:55 ub Exp $
# --
# agent, admin and customer frontend
ScriptAlias /otrs/ "/path/to/customer1/otrs/bin/cgi-bin/"
Alias /otrs-web/ "/path/to/customer1/otrs/var/httpd/htdocs/"
# if mod_perl is used
<IfModule mod_perl.c>
# load all otrs modules
Perlrequire /path/to/customer1/otrs/scripts/apache2-perl-startup.pl
# Apache::Reload - Reload Perl Modules when Changed on Disk
PerlModule Apache2::Reload
PerlInitHandler Apache2::Reload
PerlModule Apache2::RequestRec
# set mod_perl2 options
participants (2)
-
Gerald Young -
Michelle Konzack