[otrs] Troubles viewing output on Customer GUI, MSSQL and charset

Hello everybody. I'll be starting from the latest problem I'm encountering, which is as follows: when I do a search in my Customer Database, I get the correct number of records, but they print out as blank/empty lines (look here: http://tinyurl.com/2cx44r2 ). Here the background and the setup: D

Re: [otrs] Troubles viewing output on Customer GUI, MSSQL and charset

Hello Mike and thanks for your quick feedback. > If your remote database is unicode, add this to your mapping. > >SourceCharset => 'utf-8', >DestCharset => 'utf-8', > > Actually, I'm not quite sure if DBD::Sybase would also return > Unicode, you might want to experiment

Re: [otrs] Troubles viewing output on Customer GUI, MSSQL and charset

Hello Mike, > No, you should actually include them in the Params section, > otherwise they're not used. OK, put them under the "Params", nothing changed... > Latin1_General is not a character set name, or at least not > one recognized by Perl's Encode, it's a MS SQL Server Collation name. > Pl

Re: [otrs] Troubles viewing output on Customer GUI, MSSQL and charset

Hello again Mike... > There's one thing to pay attention here: OTRS can cache the > results from the database query for a couple of minutes. This > means that if you search for 'jim', change your config and > again search for 'jim', you'll probably see cached results. > In that case, the confi

Re: [otrs] Troubles viewing output on Customer GUI, MSSQL and charset

Hello people... Anybody has any clues on how to proceed? Thanks, F. > -Original Message- > From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On > Behalf Of Boniforti Flavio > Sent: Wednesday, December 01, 2010 1:43 PM > To: User questions and discussions about

[otrs] ODCB on MSSQL, almost done

Hello everybody. Thanks to Frediano Ziglio (on the freeTDS mailing list), I've managed to connect my Debian Sid to my MSSQL server, by means of ODBC (FreeTDS). My Config.pm now looks like this (for the CustomerUser part): $Self->{CustomerUser} = { Name => 'Database clienti',

[otrs] Importing customers: some don't have email

Hello everybody. I'm back at OTRS, this time OTRS 3 on WinXP Pro. I will be exporting my existing customer db (MSSQL) and import it into mysql, but I have first to collect the correct data. One thing I noticed, is that many of our customers *do not* have any email address. This seems rather vita

Re: [otrs] Importing customers: some don't have email

> > > Try this http://www.youtube.com/watch?v=A1dp7QlMbts Really nice! Thanks! F. - OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs

[otrs] Accessing OTRS mySQL from LAN with mySQL Workbench

Hello all. I've installed OTRS 3 on a Windows 2003 Server and now I'd like to access it's database from my PC in LAN. Using mySQL Workbench, I only get error connecting to it. I get "Host mypc.domain.local is not allowed to connect to this MySQL server". So, how do I have to proceed to enable it

[otrs] Installed OTRS2, configured.. then error

error. What may be wrong? -- -- Boniforti Flavio Provincia del Verbano-Cusio-Ossola Ufficio Informatica Tecnoparco del Lago Maggiore Via dell'Industria, 25 28924 Verbania -- ___ OTRS ma

Re: [otrs] Email Attachement size 1.1 MB ?!

limits your emails. -- -- Boniforti Flavio Provincia del Verbano-Cusio-Ossola Ufficio Informatica Tecnoparco del Lago Maggiore Via dell'Industria, 25 28924 Verbania -- ___ OTRS ma

[otrs] Active Directory and OTRS2?

Hello list, is the integration with Active Directory still done as in version 1.3 on OTRS 2? Or is there any particular thing to do? Many thanks. -- -- Boniforti Flavio Provincia del Verbano-Cusio-Ossola Ufficio Informatica Tecnoparco del Lago Maggiore Via

Re: [otrs] Active Directory and OTRS2?

I miss it? -- -- Boniforti Flavio Provincia del Verbano-Cusio-Ossola Ufficio Informatica Tecnoparco del Lago Maggiore Via dell'Industria, 25 28924 Verbania -- ___ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http:/

Re: [otrs] Active Directory and OTRS2?

Boniforti Flavio ha scritto: That's good news, I'll try it asap. I just would like to read about it also in OTRS 2 docs... or did I miss it? OK, I missed it and now I'm reading about that. So here are some of my doubts and not-understandings: What do I have to put in

[otrs] LDAP and OTRS: getting closer

::LDAP::UID'} = 'sAMAccountName'; $Self->{'Customer::AuthModule::LDAP::SearchUserDN'} = 'CN=ldapuser,OU=Utenti-test,DC=provincia,DC=verbania,DC=it'; $Self->{'Customer::AuthModule::LDAP::SearchUserPw'} = 'ldap'; Meny thanks --

Re: [otrs] LDAP and OTRS: getting closer

Priyadarsan Roy ha scritto: Hi Boniforti, Are you using an OpenLDAP server for Authentication or a Windows AD. It's Windows 2000 AD. -- -- Boniforti Flavio Provincia del Verbano-Cusio-Ossola Ufficio Informatica Tecnoparco del Lago Maggiore Via dell'

[otrs] Going further: Customer interface "LOGO" and so on...

here do these parameters have to be set? -- ------ Boniforti Flavio Provincia del Verbano-Cusio-Ossola Ufficio Informatica Tecnoparco del Lago Maggiore Via dell'Industria, 25 28924 Verbania -- _

[otrs] LDAP: only "users" and no others, how to filter?

unts, too. Now I'd like still to refine the filter, so that disabled/inactive/expired users *don't* get shown. How may I do this? And I also would like to avoid catching "system users" like "IUSR" and so on. Any clues? Thanks, -- ---

Re: [otrs] Going further: Customer interface "LOGO" and so on...

Her, Andre ha scritto: Hello, Look into :~/otrs/Kernel/Output/HTML/Standard/CustomerHeader.dtl and CustomerFooter.dtl also something to find in css.dtl Thanks, that's it! -- -- Boniforti Flavio Provincia del Verbano-Cusio-Ossola Ufficio Informatica Tecno

[otrs] Error while accessing "Customer User - Groups"

Hello list! I get following error: CustomerGroupSupport needs to be activ in Kernel/Config.pm, read more about this feature in the documentation. Take care! How can I solve this? -- -- Boniforti Flavio Provincia del Verbano-Cusio-Ossola Ufficio Informatica

[otrs] Users and Customers mapped or not mapped

em also as Customers when they log in? -- ------ Boniforti Flavio Provincia del Verbano-Cusio-Ossola Ufficio Informatica Tecnoparco del Lago Maggiore Via dell'Industria, 25 28924 Verbania -- _

[otrs] logging on otrs.log instead of messages

t it to be logging *only* in /var/log/otrs.log, what am I missing? Thanks, -- -- Boniforti Flavio Provincia del Verbano-Cusio-Ossola Ufficio Informatica Tecnoparco del Lago Maggiore Via dell'Industria, 25 28924 Verbania -- __

Re: [otrs] logging on otrs.log instead of messages

Nils Breunese (Lemonbit Internet) ha scritto: Boniforti Flavio wrote: otrs.log file permissions are as follows: -rw-r--r-- 1 rootroot 0 2006-07-19 13:24 otrs.log I want it to be logging *only* in /var/log/otrs.log, what am I missing? The permissions don't look okay to m

[otrs] Customer on LDAP gets error

is missing? Thanks, -- -- Boniforti Flavio Provincia del Verbano-Cusio-Ossola Ufficio Informatica Tecnoparco del Lago Maggiore Via dell'Industria, 25 28924 Verbania -- ___ OTRS mailing

Re: [otrs] Customer on LDAP gets error

Boniforti Flavio ha scritto: Here the error I get when logging in with a customer with LDAP backend: Errore: Need CustomerID!!! OK, sorry. I answer myself: it was the missing "mail" attribute in the LDAP directory for that parti

Re: [otrs] list of customers wrong with LDAP

id you look at this one? CustomerUserSearchListLimit => 250, -- ------ Boniforti Flavio Provincia del Verbano-Cusio-Ossola Ufficio Informatica Tecnoparco del Lago Maggiore Via dell'Industria

[otrs] Customer limitations: just "New ticket"

x27; just the ability to create NEW TICKETS? No Prefs, no open ticket views, or similar... Thanks -- ------ Boniforti Flavio Provincia del Verbano-Cusio-Ossola Ufficio Informatica Tecnoparco del Lago Maggiore Via dell

Re: [otrs] Customer limitations: just "New ticket"

en an Agent takes care of them). Now, how may I be using automatic replies for my users? I mean something like: "Your inquiry has arrived" and then "your inquiry has been solved"... Thanks, -- ------ Boniforti Flavio Provincia del Verbano-Cusio-O

[otrs] Time lapse SMTP polling?

Hello all. How frequently is the POP3 mail account read by OTRS? Where may I change that value? Regards, -- -- Boniforti Flavio Provincia del Verbano-Cusio-Ossola Ufficio Informatica Tecnoparco del Lago Maggiore Via dell'Industria, 25 28924 Ver

Re: [otrs] DefaultCharset

r, in fact. Every "new line" in my email ticket is ignored and I get all the text on one (wrapped of course) line. Any suggestions? -- -- Boniforti Flavio Provincia del Verbano-Cusio-Ossola Ufficio Informatica Tecnoparco del Lago Maggiore Via dell'

Re: [otrs] Is there a way to specify a queue when sending e-mail?

filter that one (it's just my guess!). Let us know how you achieved your solution! -- -- Boniforti Flavio Provincia del Verbano-Cusio-Ossola Ufficio Informatica Tecnoparco del Lago Maggiore Via dell'Industria, 25 2892

Re: [otrs] newbie question: how to change ticket 'subject', 'from' or 'status'

Duncan C White ha scritto: - the ticket state (obviously "close" closes it, etc) but how for instance could I (an agent) reopen a ticket after closing it in error? As I'm reading, I get to ask: where do I see the closed tickets? -- -- B

[otrs] Cron with error

ong? What's happening? Thanks... -- ------ Boniforti Flavio Provincia del Verbano-Cusio-Ossola Ufficio Informatica Tecnoparco del Lago Maggiore Via dell'Industria, 25 28924 Verbania -- ___

Re: [otrs] DefaultCharset

Boniforti Flavio ha scritto: Asfihani ha scritto: Helo, How to handle newline in new ticket which is submitted via email? I always got the following: From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: test \ntest\n\ntest\n\ntest\n\n\n\n Do you feel it's charset-relat