Re: [otrs] Enable CC ?

2013-03-28 Thread Ugo Bellavance
On 2012-06-18 13:24, Hussein E. Hijazi wrote: Yes in the customer interface. We asked OTRS because we couldn't find how to do it. They told us it needed custom development and it was out of our budget. Maybe it is now included in a recent release? ---

[otrs] Database Conversion from MySQL to PostgreSQL

2013-03-28 Thread aledr
Good day! I'm moving my otrs installation from MySQL to PostgreSQL. Almost everything went fine, except article_attachment table. Is there any available instructions on how to move that data? Thanks. -- [ ]'s Aledr - Alexandre -

Re: [otrs] Database Conversion from MySQL to PostgreSQL

2013-03-28 Thread Bogdan Iosif
Does OTRS have a tool that you used to move the data? On Thu, Mar 28, 2013 at 5:12 PM, aledr wrote: > Good day! > > I'm moving my otrs installation from MySQL to PostgreSQL. > Almost everything went fine, except article_attachment table. > > Is there any available instructions on how to move th

Re: [otrs] Database Conversion from MySQL to PostgreSQL

2013-03-28 Thread aledr
Used mysqldump for data only; Added 'set backslash_quote = on;' and 'set standard_conforming_strings = off;' in the header of the dump file. After that you need to create the PostgreSQL schema from OTRS scripts, import your data, run OTRS post database script and adjust sequences (you can generate

Re: [otrs] Database Conversion from MySQL to PostgreSQL

2013-03-28 Thread Bogdan Iosif
An interesting and ingenious method. I was thinking you're using some ETL tool. I'm strongly considering doing the same switch as you did but I'm wary of performance issues. Initially, I tried running OTRS on top of SQL Server but Perl's database interface implementation for this RDBMS is very wea

Re: [otrs] Enable CC ?

2013-03-28 Thread Gerald Young
It's a bit difficult to properly set this up. If it's consistent, you may want to use a Notification (Event) for that customer. On Thu, Mar 28, 2013 at 11:05 AM, Ugo Bellavance wrote: > On 2012-06-18 13:24, Hussein E. Hijazi wrote: > >> Yes in the customer interface. >> > We asked OTRS because

Re: [otrs] Database Conversion from MySQL to PostgreSQL

2013-03-28 Thread aledr
It seems faster, but we've made no performance tests at all. We moved fo the sake of simplicity (keeping just one RDBMS to maintain). On Thu, Mar 28, 2013 at 2:12 PM, Bogdan Iosif wrote: > An interesting and ingenious method. I was thinking you're using some ETL > tool. > > I'm strongly consideri

Re: [otrs] Database Conversion from MySQL to PostgreSQL

2013-03-28 Thread David Boyes
Did you run tests that showed PostgreSQL would be better performance-wise or, if not, why did you move? Oracle’s new licensing T&Cs for use of MySQL for business tasks in one big reason. The lawyers here think the new language implies that using MySQL with other applications that have a busin

Re: [otrs] Database Conversion from MySQL to PostgreSQL

2013-03-28 Thread Bogdan Iosif
I'll see your T&Cs and raise you window functions On Thu, Mar 28, 2013 at 9:22 PM, David Boyes wrote: > ** ** > > ** ** > > Did you run tests that showed PostgreSQL would be better performance-wise > or, if not, why did you move? > > ** ** > > Oracle’s new licensing T&Cs for use of MySQL f

Re: [otrs] Database Conversion from MySQL to PostgreSQL

2013-03-28 Thread David Boyes
I'll see your T&Cs and raise you window functions ?? window functions? Not sure I follow. - OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/

Re: [otrs] Database Conversion from MySQL to PostgreSQL

2013-03-28 Thread Bogdan Iosif
http://en.wikipedia.org/wiki/Window_functions Very useful for some queries used mostly with reports (e.g. when you need that Nth occurence in ticket_history) On Thu, Mar 28, 2013 at 9:46 PM, David Boyes wrote: > ** ** > > ** ** > > I'll see your T&Cs and raise you window functions > > **

Re: [otrs] Database Conversion from MySQL to PostgreSQL

2013-03-28 Thread Bogdan Iosif
Wrong link @ wikipedia but you can jump to the correct one from the top. Or use this here direct link http://en.wikipedia.org/wiki/Window_function_%28SQL%29#Window_functionSorry :) On Thu, Mar 28, 2013 at 9:51 PM, Bogdan Iosif wrote: > > http://en.wikipedia.org/wiki/Window_functions > > Very use

Re: [otrs] Database Conversion from MySQL to PostgreSQL

2013-03-28 Thread David Boyes
Neat. Hadn’t considered using something like that for reporting. From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Bogdan Iosif Sent: Thursday, March 28, 2013 3:51 PM To: User questions and discussions about OTRS. Subject: Re: [otrs] Database Conversion from MySQL to Postgr

Re: [otrs] Database Conversion from MySQL to PostgreSQL

2013-03-28 Thread Gerald Young
May I point out MariaDB while we're talking about MySQL? Just in case you want a different MySQL that isn't encumbered by Oracle, but is a drop-in replacement for MySQL. On Thu, Mar 28, 2013 at 4:02 PM, David Boyes wrote: > Neat. Hadn’t considered using something like th

Re: [otrs] Database Conversion from MySQL to PostgreSQL

2013-03-28 Thread Bogdan Iosif
MariaDB very recently entered my radar, mostly because the project is driven by MySQL's inventor. Don't know much about it beyond that. Have you seen it used in a production environment? Is it at the same performance / reliability level as MySQL? On Thu, Mar 28, 2013 at 10:11 PM, Gerald Young wr

Re: [otrs] Database Conversion from MySQL to PostgreSQL

2013-03-28 Thread Gerald Young
According to ZDNet , OpenSUSE, and Fedora are going to replace MySQL with MariaDB as part of their LAMP stack. Wikipedia, too , Performance, support, bug fixes at a better rate t

[otrs] CustomerCompanySupport and 3.2

2013-03-28 Thread Steven Carr
Hi list, We're in the process of planning upgrading from 3.1 to 3.2. We currently have a hack in place enabling CustomerCompanySupport in Config.pm to allow us to specify which company a customer belongs to which then allows customer users to see tickets from other users within the same company.

Re: [otrs] CustomerCompanySupport and 3.2

2013-03-28 Thread Gerald Young
Why is this a hack? It's exactly what it's for. Company Tickets = CustomerID On Thu, Mar 28, 2013 at 5:45 PM, Steven Carr wrote: > Hi list, > > We're in the process of planning upgrading from 3.1 to 3.2. We > currently have a hack in place enabling CustomerCompanySupport in > Config.pm to allow

Re: [otrs] CustomerCompanySupport and 3.2

2013-03-28 Thread Steven Carr
On 28 March 2013 22:20, Gerald Young wrote: > Why is this a hack? It's exactly what it's for. Company Tickets = CustomerID Well it originally was a hack as this was something that OTRS didn't do out of the box, you had to manually add an additional field into the database and modify some of the c

Re: [otrs] CustomerCompanySupport and 3.2

2013-03-28 Thread Steven Carr
On 28 March 2013 22:30, Steven Carr wrote: > I don't want to have to specify multiple ID values per user so they > can see each other's tickets, I just want anyone from the company to > be able to see all tickets for that company. > > Steve OK looks like some of the info in the database is causin

Re: [otrs] CustomerCompanySupport and 3.2

2013-03-28 Thread Gerald Young
Generic agent set CustomerID = company CustomerID (what the users have) for all tickets. On Thu, Mar 28, 2013 at 6:41 PM, Steven Carr wrote: > On 28 March 2013 22:30, Steven Carr wrote: > > I don't want to have to specify multiple ID values per user so they > > can see each other's tickets, I

[otrs] Please add a template list to output filter Kernel::Output::HTML::OutputFilterTextAutoLink

2013-03-28 Thread Steven Carr
Anyone got any idea what I am supposed to do to get rid of this error? Please add a template list to output filter Kernel::Output::HTML::OutputFilterTextAutoLink to improve performance. Use ALL if OutputFilter should modify all templates of the system (deprecated). I have no idea what it means my

Re: [otrs] Database Conversion from MySQL to PostgreSQL

2013-03-28 Thread David Boyes
Another good option. I haven't been all that impressed with it yet, but it's improving rapidly as they clean-room reimplement some of the stuff Oracle did on the performance front. It'd just be good for Oracle to get what's coming to them. From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.o

Re: [otrs] Please add a template list to output filter Kernel::Output::HTML::OutputFilterTextAutoLink

2013-03-28 Thread Gerald Young
Edit Config Settings in Framework -> Core::Web Frontend::Output::FilterText###OutputFilterTextAutoLink Defines a filter to process the text in the articles, in order to highlight predefined keywords. Defines a filter to process the text in the articles, in order to highlight predefin

Re: [otrs] Please add a template list to output filter Kernel::Output::HTML::OutputFilterTextAutoLink

2013-03-28 Thread Steven Carr
On 28 March 2013 23:31, Gerald Young wrote: > You can disable it from SysConfig... I know what and where it is, but that still doesn't answer how I fix the error. Is the only option to disable it? - OTRS mailing list: otrs - Webp

Re: [otrs] Please add a template list to output filter Kernel::Output::HTML::OutputFilterTextAutoLink

2013-03-28 Thread Steven Carr
On 28 March 2013 23:45, Steven Carr wrote: > On 28 March 2013 23:31, Gerald Young wrote: >> You can disable it from SysConfig... > > I know what and where it is, but that still doesn't answer how I fix > the error. Is the only option to disable it? Fixed it, looks like OTRS didn't migrate the co

[otrs] OTRS 3.2.3 on CentOS Linux Version 6.4 server edition

2013-03-28 Thread Kaushal Shriyan
Hi, I am migrating from the current live setup of OTRS Application Version 3.1.7 running on CentOS Linux Version 5.8 server to a new OTRS server running OTRS Application Version 3.2.3 hosted on CentOS 6.4. Any prerequisites i need to take care while migrating from one box to another box? I can t