Hello people... Anybody has any clues on how to proceed? Thanks, F.
-----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Boniforti Flavio Sent: Wednesday, December 01, 2010 1:43 PM To: User questions and discussions about OTRS. Subject: 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 configuration change did not affect your results. Please remove the cache and/or change TTL to make sure this does not apply to you.
I don't know where to remove cache or change TTL, but for sure it's not "caching" what is disturbing: as I'm running OTRS on a Virtual Machine, and I reboot it when I reboot my PC, I feel it's no caching involved.
I understand you know a bit about SQL, therefore I'm bothering a bit further: would it change if I'd use ODBC connection instead of Sybase (like I'm doing now)? Would it be worth a try? If yes, I'd need some help because I already tried to connect via ODBC but keep getting failures (when testing with "isql" command). Instead, tsql command works pretty well!
Sure, that could help. I remember I used DBD::Sybase once for a customer database from Linux >> MS SQL Server successfully.
Could you eventually provide that configuration excerpt?
But DBD::ODBC plus an ODBC driver manager should also work. If you have issues, you can certainly try that.
Well, I'm having issues with ODBC connection using FreeTDS, would it help if I'd be posting my configs here?
Kind regards, Flavio Boniforti
PIRAMIDE INFORMATICA SAGL Via Ballerini 21 6600 Locarno Switzerland Phone: +41 91 751 68 81 Fax: +41 91 751 69 14 URL: http://www.piramide.ch E-mail: flavio@piramide.ch --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs