otrs on linux + MSSQL, which linux distro?
Hello there, I've been trying to connect my OTRS on linux to a MSSQL database without success. After reading http://www.savelono.com/linux/how-to-configure-linux-odbc-connections-for-ms... http://www.linuxjournal.com/article/6636, it's clear that I need freetds and unixodbc in order to configure the ODBC but I also need perl-DBI and perl-DBD-ODBC in order to allow OTRS to actually use the mentioned ODBC. I've tried with fedora 11 in which the freeTDS part works great but the perl-DBD-ODBC does not. On the other hand I tried with opensuse 10.3 in which the per-DBD part is working but the freetds is not. I just want advice on which linux distro use in order to easily accomplish this setup. I'm willing to compile from source anything, I just want some directions from people who have successfully accomplished this kind of connection. Thanks in advance for your help, Leonardo Certuche 301 284 6250 460 0727 ext 5559 leonardo.certuche@itcon-ltda.com www.itcon-ltda.com Cra 31 # 54-10 TECNOSOFT Medellín, Colombia
Need assistance again if possible. I have 6 departments. Each department wants to be able to view the tickets of those people in that department through the use of the My Company Tickets. I did the following: 1. To use company tickets a new column has to be added to the customer_user table in the OTRS database. In this new column the IDs of the customers are stored that tickets need to be accessed. 2. Now the new column has to be added to the MAP array in Kernel/Config.pm:: (actually edited default.pm) # var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly [...] [ 'UserCustomerIDs', 'CustomerIDs', 'customer_ids', 1, 0, 'var', '', 0 ], I numbered the departments 1-6. The customer_ids field shows up in the customer account.... So, I just added 1 for all the customers in group 1 Added 2 for all the customers in group 2, And so on and so forth. It is my understanding that now the my Company tickets would show all the tickets associated with the department. Am I wrong? Did I do something wrong? Help? Jason Dupuy IT Manager Global Products Inc. Earth City, MO 63045 636-939-1622 Phone 636-939-1623 Fax
Hi Jason, For some reason my OTRS install already had columns for customer_id and customer_user_id. You put the Department code into customer_id (eg; "ACCOUNTS") and then an individual user tag in customer_user_id. James. From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Jason Dupuy Sent: Friday, 30 October 2009 8:15 AM To: User questions and discussions about OTRS. Subject: [otrs] Company Tickets Need assistance again if possible. I have 6 departments. Each department wants to be able to view the tickets of those people in that department through the use of the My Company Tickets. I did the following: 1. To use company tickets a new column has to be added to the customer_user table in the OTRS database. In this new column the IDs of the customers are stored that tickets need to be accessed. 2. Now the new column has to be added to the MAP array in Kernel/Config.pm:: (actually edited default.pm) # var, frontend, storage, shown (1=always,2=lite), required, storage-type, http-link, readonly [...] [ 'UserCustomerIDs', 'CustomerIDs', 'customer_ids', 1, 0, 'var', '', 0 ], I numbered the departments 1-6. The customer_ids field shows up in the customer account.... So, I just added 1 for all the customers in group 1 Added 2 for all the customers in group 2, And so on and so forth. It is my understanding that now the my Company tickets would show all the tickets associated with the department. Am I wrong? Did I do something wrong? Help? Jason Dupuy IT Manager Global Products Inc. Earth City, MO 63045 636-939-1622 Phone 636-939-1623 Fax
On 29.10.09 15:54, Leonardo Certuche wrote:
Hello there, I've been trying to connect my OTRS on linux to a MSSQL database without success. After reading [1]http://www.savelono.com/linux/how-to-configure-linux-odbc-connection s-for-ms-sql.html and [2]http://www.linuxjournal.com/article/6636, it's clear that I need freetds and unixodbc in order to configure the ODBC but I also need perl-DBI and perl-DBD-ODBC in order to allow OTRS to actually use the mentioned ODBC. I've tried with fedora 11 in which the freeTDS part works great but the perl-DBD-ODBC does not. On the other hand I tried with opensuse 10.3 in which the per-DBD part is working but the freetds is not. I just want advice on which linux distro use in order to easily accomplish this setup. I'm willing to compile from source anything, I just want some directions from people who have successfully accomplished this kind of connection. Thanks in advance for your help, Leonardo Certuche
I'm with CentOS but I'm not using the distro packaged Perl extensions, I installed with perl shell and CPAN as suggested here: http://doc.otrs.org/2.4/en/html/x531.html#installation-of-perl-modules Worth noticing I'm not using ODBC but might be a good change for you try out the perl modules in CPAN. Mariano
participants (4)
-
James Morgan -
Jason Dupuy -
Leonardo Certuche -
Mariano Mara