Re: [otrs] no change state ticket (new open)

2011-03-29 Thread Edlhuber Florian
Good morning, Von: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] Im Auftrag von DM_Julio Angulo > Good morning, I have a question, I would change the behavior of OTRS, the > following occurs: an agent and attended and confirmed with the client > completing a ticket, but after a while th

[otrs] itsm access level

2011-03-29 Thread Luis Daniel Lucio Quiroz
helo, just wondering if theres a way to control access in itsm 3. I mean that some agents can see some CI's and other agents other CI's. Thanks in advance, LD - OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http

Re: [otrs] trying to get OTRS 3 up with Postgres: bin/otrs.CheckDB.pl fails: permission denied for relation valid, SQL: 'SELECT * FROM valid'

2011-03-29 Thread Gerald Young
Message: ERROR: permission denied for relation valid, SQL: 'SELECT * FROM valid' You're heavily invested in postgresql ... your database admin should have been able to resolve this in a heartbeat. Short answer: you don't have select privileges on the table named "valid" so you should grant selec

Re: [otrs] no change state ticket (new open)

2011-03-29 Thread Gerald Young
http://www.google.com/search?q=site:forums.otrs.org+reopen+closed+ticket ACLs on the website can help prevent reopen, as well as SysConfig options. On Tue, Mar 29, 2011 at 12:35 PM, DM_Julio Angulo wrote: > Good morning,

[otrs] trying to get OTRS 3 up with Postgres: bin/otrs.CheckDB.pl fails: permission denied for relation valid, SQL: 'SELECT * FROM valid'

2011-03-29 Thread Aleksey Tsalolikhin
otrs.CheckDB.pl fails, it says permission denied for table "valid" - the table is there though. # /opt/otrs/bin/otrs.CheckDB.pl Trying to connect to database DSN: DBI:Pg:dbname=otrs;host=localhost; DatabaseUser: otrs DBD::Pg::st execute failed: ERROR: permission denied for relation valid at /op

Re: [otrs] Trouble installing OTRS 3.0.6 onto CentOS 5.5 / Postgres 8.4: otrs-initial_insert.postgresql.sql contains ISO 8859 data, but database encoding is UTF8

2011-03-29 Thread Aleksey Tsalolikhin
I ended up using "iconv -f ISO8859-1 -t UTF-8" on scripts/database/otrs-initial_insert.postgresql.sql Aleksey - OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http

Re: [otrs] Trouble installing OTRS 3.0.6 onto CentOS 5.5 / Postgres 8.4: otrs-initial_insert.postgresql.sql contains ISO 8859 data, but database encoding is UTF8

2011-03-29 Thread Aleksey Tsalolikhin
On Tue, Mar 29, 2011 at 2:33 PM, Muhammad El-Sergani wrote: > Why not use MySQL? Dear Muhammad, Our site is heavily invested in PostgreSQL. Best, Aleksey - OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://l

Re: [otrs] Trouble installing OTRS 3.0.6 onto CentOS 5.5 / Postgres 8.4: otrs-initial_insert.postgresql.sql contains ISO 8859 data, but database encoding is UTF8

2011-03-29 Thread Muhammad El-Sergani
Why not use MySQL? Best Regards, Muhammad El-Sergani. On Tue, Mar 29, 2011 at 11:10 PM, Aleksey Tsalolikhin < atsaloli.t...@gmail.com> wrote: > Hi. I'm trying to install OTRS 3.0.6, and, as the Web-based installer > does not support Postgres, > I am following README.database. > > My database

[otrs] Trouble installing OTRS 3.0.6 onto CentOS 5.5 / Postgres 8.4: otrs-initial_insert.postgresql.sql contains ISO 8859 data, but database encoding is UTF8

2011-03-29 Thread Aleksey Tsalolikhin
Hi. I'm trying to install OTRS 3.0.6, and, as the Web-based installer does not support Postgres, I am following README.database. My database is Postgres 8.4 (on CentOS 5.5). I've created the database: createdb --encoding=utf8 --owner=otrs otrs But when I run the initial insert file, it bombs

[otrs] no change state ticket (new open)

2011-03-29 Thread DM_Julio Angulo
Good morning, I have a question, I would change the behavior of OTRS, the following occurs: an agent and attended and confirmed with the client completing a ticket, but after a while the client sends a mail using the last post used by OTRS , which makes the ticket back to the open state and reset t

Re: [otrs] Mail download stopped due to Can't create PID PostMasterMailbox Error

2011-03-29 Thread Gerald Young
any chance you're simply downloading too often/fast? On Tue, Mar 29, 2011 at 8:06 AM, Saurabh Pande wrote: > Unfortunately my moment of triumph was short :( > > From the second cron run onwards we started seeing the same errors! Has > anyone any suggestions. > > I am going to now stop otrs and my

Re: [otrs] Mail download stopped due to Can't create PID PostMasterMailbox Error

2011-03-29 Thread Saurabh Pande
Unfortunately my moment of triumph was short :( From the second cron run onwards we started seeing the same errors! Has anyone any suggestions. I am going to now stop otrs and mysql, repair db and then restart services. Regards, Saurabh Pande. Original Message Subject: Re

Re: [otrs] How to use Import/Export Management to create links between config items

2011-03-29 Thread Martin Aigner
FYI: attached is the script that creates the links between conputers and monitors in OTRS. The script is (I hardly dare to say) documented inline. But it's not a big deal. Feel free to ask. cheers, Martin On Wednesday, March 16, 2011 11:26:53 AM Martin Aigner wrote: > Thanks Udo, > > you appr

Re: [otrs] Mail download stopped due to Can't create PID PostMasterMailbox Error

2011-03-29 Thread Muhammad El-Sergani
Thanks Saurabh, This should come in very handy... thanks for posting the solution as well. Best Regards, Muhammad El-Sergani. On Mon, Mar 28, 2011 at 6:55 PM, Saurabh Pande wrote: > Hi, > > After a lot of searching, I came across > http://lists.otrs.org/pipermail/otrs/2007-May/018895.html and

Re: [otrs] Type, service, SLA and LDAP clients

2011-03-29 Thread Ionel GARDAIS
Hi Florian, Thanks for your reply on the SLA/services. I'm not (yet) using the ITSM version of OTRS, only using the basic features. I do not see "additional ITSM fields" in a ticket view nor when searching the available system parameters. Ionel On 03/29/2011 09:54 AM, Edlhuber Florian wrote:

Re: [otrs] Type, service, SLA and LDAP clients

2011-03-29 Thread Edlhuber Florian
Hi Ionel, -Ursprüngliche Nachricht- Von: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] Im Auftrag von Ionel GARDAIS > All my clients are pulled from an ActiveDirectory. > How to add a client<->service mapping inside the Config.pm file ? > (i.e. not to modify by hand all the users

[otrs] Type, service, SLA and LDAP clients

2011-03-29 Thread Ionel GARDAIS
Hi all, All my clients are pulled from an ActiveDirectory. How to add a client<->service mapping inside the Config.pm file ? (i.e. not to modify by hand all the users to assign the services to them). Also, I activated the "Type" and "Service" support in Core::Ticket but I do not see menus to c