
I would like to be able to send my customers directly to the customer login page via helpdesk.domain.com without having to type /otrs/customer.pl at the end. How do I setup my vhost file to do that? I have it pointing to /opt/otrs/var/httpd/htdocs right now but that goes to the agent login. Ultimately, I want to have helpdesk.domain.com go to the customer login and hdagent.domain.com go to the agent login. Any thoughts? Thank you, Joe Fusco

hello all i am using redhat 9 .. i was just wondering if i can use postgres instead of mysql working ? if anyone has instructions on how to do that i would be very grate full... i got all of otr's working on my sql and apache on redhat but my manager if very picky and wants to use postgres instead of mysql database..... anyways if you can help me out with step by step con fig i would be realy great fully.

On 9/6/06, mohamad
i am using redhat 9 .. i was just wondering if i can use postgres instead of mysql working ? if anyone has instructions on how to do that i would be very grate full... i got all of otr's working on my sql and apache on redhat but my manager if very picky and wants to use postgres instead of mysql database..... anyways if you can help me out with step by step con fig i would be realy great fully.
You'll need to install PostgreSQL and DBD::Pg. You'll also need to know how to create a user and database, and setup access permissions, which is fairly well documented in the PostgreSQL docs. To setup OTRS to use PostgreSQL, you need to comment out the MySQL driver and uncomment the PostgreSQL driver in Config.pm, and use the PostgreSQL schema sql instead of the MySQL ones during install. That's pretty much all there is to it. Bryan

I am using FC5 and had to downgrade Postgresql to version 8.0.8 from
8.1.4and reconfigured the
config.pm to use postgres and everything went well. So if you have to
download the binaries I would read up on which version works/has the least
amount of problems with RH9.
visit postgresql.org and read the documentation on how to install. The site
is very well documented and there are also "user" comments at the bottom of
each page to help.
Good Luck.
Jeff
On 9/5/06, mohamad
hello all
i am using redhat 9 .. i was just wondering if i can use postgres instead of mysql working ? if anyone has instructions on how to do that i would be very grate full... i got all of otr's working on my sql and apache on redhat but my manager if very picky and wants to use postgres instead of mysql database..... anyways if you can help me out with step by step con fig i would be realy great fully. _______________________________________________ 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 Support orr consulting for your OTRS system? => http://www.otrs.com/

On 9/6/06, Jeff Lansidel
I am using FC5 and had to downgrade Postgresql to version 8.0.8 from 8.1.4 and reconfigured the config.pm to use postgres and everything went well. So if you have to download the binaries I would read up on which version works/has the least amount of problems with RH9.
Which version of OTRS are you using? What issues did you have with Postgresql 8.1.4? I ran into an issue with the DBUpgrade script for OTRS 2.1beta2 when using Postgresql 8.1.4, and I've submitted a bug report and patch. There may be similar issues with the inital database creation scripts, I haven't looked at them. Bryan

Bryan,
The scripts to create the initial tables never ran. I would always get an
error that it could not connect to the DB. I new I was running the most
current version of Postgres so on a whim I downgraded and it has worked like
a charm since then.
I didn't save the log files not knowing I would have to look back at them.
Interesting about the upgrade, I was looking at installing 2.1 when it came
out in a stable version. Since the DB is already created, does the upgrade
have to "modify/touch" the tables? Is that what I am reading into in your
email?
Jeff
On 9/6/06, Bryan Fullerton
On 9/6/06, Jeff Lansidel
wrote: I am using FC5 and had to downgrade Postgresql to version 8.0.8 from 8.1.4 and reconfigured the config.pm to use postgres and everything went well. So if you have to download the binaries I would read up on which version works/has the least amount of problems with RH9.
Which version of OTRS are you using? What issues did you have with Postgresql 8.1.4?
I ran into an issue with the DBUpgrade script for OTRS 2.1beta2 when using Postgresql 8.1.4, and I've submitted a bug report and patch. There may be similar issues with the inital database creation scripts, I haven't looked at them.
Bryan _______________________________________________ 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 Support orr consulting for your OTRS system? => http://www.otrs.com/

On 9/6/06, Jeff Lansidel
The scripts to create the initial tables never ran. I would always get an error that it could not connect to the DB. I new I was running the most current version of Postgres so on a whim I downgraded and it has worked like a charm since then.
I didn't save the log files not knowing I would have to look back at them.
Ah, no worries.
Interesting about the upgrade, I was looking at installing 2.1 when it came out in a stable version. Since the DB is already created, does the upgrade have to "modify/touch" the tables? Is that what I am reading into in your email?
Yes, there are DBUpgrade scripts for all major versions in the ~otrs/scripts directory. In your 2.0.x install you should see scripts for upgrading to 1.0, 1.1, 1.2, 1.3 and 2.0 from earlier versions. Modifications to the database are needed to support new features, and sometimes to fix bugs. Bryan

Hello. If, for example, you're using 'cPanel' on your webserver, you could set up a 'redirect'. It can also be used via a shell command in Unix, Linux, etc. that redirects one path to another. It's been a while since I've done it manually, but you could do a search on those websites to find the syntax. HTH. =====================================
From: "Joe Fusco"
Reply-To: "User questions and discussions about OTRS.org" To: Subject: [otrs] Go directly to customer login? Date: Tue, 5 Sep 2006 15:33:32 -0400 I would like to be able to send my customers directly to the customer login page via helpdesk.domain.com without having to type /otrs/customer.pl at the end. How do I setup my vhost file to do that? I have it pointing to /opt/otrs/var/httpd/htdocs right now but that goes to the agent login. Ultimately, I want to have helpdesk.domain.com go to the customer login and hdagent.domain.com go to the agent login. Any thoughts?
Thank you,
Joe Fusco
_______________________________________________ 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 Support orr consulting for your OTRS system? => http://www.otrs.com/
participants (5)
-
Bryan Fullerton
-
Jeff Lansidel
-
Joe Fusco
-
mohamad
-
s taylor