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