-----Ursprüngliche Nachricht----- Von: otrs-admin@otrs.org [mailto:otrs-admin@otrs.org]Im Auftrag von Stefan Wintermeyer Gesendet: Samstag, 26. Oktober 2002 16:49

Just to be sure. You did copy the /etc/sysconfig/otrs.rpmnew to the /etc/sysconfig/otrs and after that you edit it? With "rpm -Uvh otrs.rpm"

Sure I took the new files and edit them :-) but I used rpm -U otrs.rpm for update. Volker

Hi Martin,

...

[...] Did some tests. OK. everything looks good... ... but don't know about the dbscript errors ?!?

Don't worry about the error messages, you can update all previous version with this script and in the most cases your database has already the most changes!

I thought this... (...)

Volker, can you try this with an other browser (e. g. Mozilla)!? I need to know if this is not working with IE. Or with any browser.

OK, I patched EmailSend.pm - now the test: Browser: Opera 6.05 Win The testfile ist E:\Daten\Test.zip Sending from the ticket: In the ticket the atachments appear as: file-0 Test.zip sendig a second mail with attachment is OK. Download the file from ticket is OK but a second empty browserwindow is left with the following URL: http://myhost/otrs/index.pl?Action=AgentAttachment&ArticleID=209&File=Test.z ip The received e-mail in MS Outlook has the file with correct name! Browser: Netscape 7.0 win same as Opera Browser: MS IExplorer 5.00.3502.1000 The testfile ist E:\Daten\Test.zip Sending from the ticket: In the ticket the atachments appear as: E:\Daten\Test.zip file-0 sendig a second mail with attachment is OK. Download the file from ticket: In the dialog box the filename appears as: index the type as: -Dokument The downloads works, the file (index) on disk is OK, a second browser window is left with an errormessage and the following URL: http://myhost/otrs/index.pl?Action=AgentAttachment&ArticleID=211&File=E:\Dat en\Test.zip The download of the same file from the ticket with Opera is with correct filename although the file in the ticket is shown different!!! The download of the same file with Netscape 7.0 is with following filename: E--Daten-Test.zip Looks like a real MS-shit :-(

...

OK, that's all for now. (I have some truble with euro sign. But later...)

Really? You need to use iso-8859-15 for the euro sign. There is also a test email with euro sign.

shell> cat /usr/share/doc/packages/otrs/test-email-7-euro-iso-8859-15.box | /opt/OpenTRS/bin/PostMaster.pl

OK, I tried this. After use there was a line: you have new mail Subject: Cron $HOME/bin/UnlockTickets.pl --timeout >> /dev/null X-Cron-Env: X-Cron-Env: X-Cron-Env: X-Cron-Env: X-Cron-Env: DBI->connect(database=otrs;host=localhost;) failed: Can't connect to local MySQL server through socket '/var/l ib/mysql/mysql.sock' (2) at /opt/OpenTRS/bin/..//Kernel/System/DB.pm line 67 [Mon Oct 28 22:00:03 2002] Use of uninitialized value in concatenation (.) or string at /opt/OpenTRS/bin/..//Kernel/System/Log/SysLog.pm line 74. [OTRS-UnlockTickets-10628][Error][1:][Line:49] [OTRS-UnlockTickets-10628][Error][0:Kernel::System::DB::new][Line:45] Can't connect to local MySQL server thro ugh socket '/var/lib/mysql/mysql.sock' (2) Got no DBObject! at /opt/OpenTRS/bin/..//Kernel/System/Queue.pm line 34. what's this ?? OK, there's a new ticket from the testscript. Euro and umlaut are OK but... oh shit, only in netscape and Opera !!! in MS IExplorer is there a black rectangle. When I write a mail with outlook the eurosign is shown as a black rectangle in MS IExplorer AND in Opera. In netscape there is a questionmark instead !! OK, that's all for now :-))) Volker

Hi Volker, On Mon, Oct 28, 2002 at 11:17:52PM +0100, Volker Vo?kamper wrote:

...

Volker, can you try this with an other browser (e. g. Mozilla)!? I need to know if this is not working with IE. Or with any browser.

OK, I patched EmailSend.pm - now the test:

Browser: Opera 6.05 Win [...] Looks like a real MS-shit :-(

I'll do some tests...

...

...

OK, that's all for now. (I have some truble with euro sign. But later...)

...

Really? You need to use iso-8859-15 for the euro sign. There is also a test email with euro sign.

...

shell> cat /usr/share/doc/packages/otrs/test-email-7-euro-iso-8859-15.box | /opt/OpenTRS/bin/PostMaster.pl

OK, I tried this. After use there was a line: you have new mail

This comes not from your cat and pipe! This was a cronjob.

Subject: Cron $HOME/bin/UnlockTickets.pl --timeout >> /dev/null [...] DBI->connect(database=otrs;host=localhost;) failed: Can't connect to local MySQL server through socket '/var/l ib/mysql/mysql.sock' (2) at /opt/OpenTRS/bin/..//Kernel/System/DB.pm line 67 [Mon Oct 28 22:00:03 2002] [...] what's this ??

This is the UnlockTickets cron job. At this moment (Mon Oct 28 22:00:03 2002) the database was down and you got this error message. This cronjobs will be started/stoped via rcotrs start/stop.

OK, there's a new ticket from the testscript. Euro and umlaut are OK but... oh shit, only in netscape and Opera !!! in MS IExplorer is there a black rectangle.

When I write a mail with outlook the eurosign is shown as a black rectangle in MS IExplorer AND in Opera. In netscape there is a questionmark instead !!

I'll do some tests with IE, attachments and euros. Please send a demo email with Outlook and euros to contact at otrs.org so I can check this...

Volker

Thanks for your help. Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "There are two major products that come out of Berkeley: LSD and Unix. We don't believe this to be a coincidence." -- Jeremy S. Anderson