Hi Michiel,

Can't wait until the Beta is live.. ;-)

Thanks for pointing to the SQL topic. I now understand the complete performance problem with this support assessment.

I will also check this windows topic. I'm currently just testing what could be the best setup for us...

Thanks for your help!

Best regards,

Dave

On 24 nov 2009, at 22:16, Michiel Beijen wrote:

Dave,

The warning while creating the indexes is not going to affect you, you
can read here why:
http://bugs.otrs.org/show_bug.cgi?id=4126

for the front-end performance; it's not possible to run reliable
apache/mod_perl on Windows with StrawberryPerl. You can either set up
ActiveState Perl with mod_perl and Apache, or set up ActiveState Perl
with IIS; a howto is here:
http://afsharm.blogspot.com/2009/03/installing-otrs-active-perl-on-windows.html

We have just released an alpha version of the installer internally
that runs FastCGI/StrawberryPerl/Apache on Windows. So far the results
are promising, and we're planning to release a beta soon.

((enjoy))
-
Michiel Beijen
R&D

OTRS AG
Norsk-Data-Str 1.
61352 Bad Homburg
Germany

T: +31 (0) 6457 42418
F: +49 (0) 9421 56818-18
I:  http://www.otrs.com/

Business Location: Bad Homburg, Country Court: Bad Homburg, Commercial
register: 10751, Tax ID: 003 240
97505 Chairman of the Board: Burchard Steinbild, Managing Board: André
Mindermann (CEO), Martin Edenhofer

CU@ CeBIT 2010 in Hannover (Germany) and get to know more about OTRS
at booth no. C37, in hall 2 from March 2-6, 2010! http://bit.ly/7uyQfY

On Tue, Nov 24, 2009 at 9:29 PM, Dave Lageweg <Dave.Lageweg@tel.io> wrote:
Hi Michiel,
Thanks for you time to answer my questions!
OTRS on Windows was really straight forward and installation was really
easy.
After running the SQL scripts on the SQL Server i ran into two small
problems (unfortunately the SQL server has a german language and therefore
the german error messages):
"Warnung: Die maximale Schlüssellänge beträgt 900 Bytes. Der
'article_message_id'-Index hat eine maximale Länge von 3800 Bytes. Bei
einigen Kombinationen hoher Werte schlägt der INSERT-/UPDATE-Vorgang fehl.
Warnung: Die maximale Schlüssellänge beträgt 900 Bytes. Der
'article_search_message_id'-Index hat eine maximale Länge von 3800 Bytes.
Bei einigen Kombinationen hoher Werte schlägt der INSERT-/UPDATE-Vorgang
fehl."
A employee in my company who is located in Hamburg has made a small
workaround for this "problem" just to make sure that the server will run
reliable (if you want to know what he did i can ask it to him and post it
here).
The reason that i switched to Linux is the performance problems on windows.
It was really acting really slow and i could not accept the current
situation.
On Ubuntu last week it was working fine. The server was reaction quickly and
also all pages were working fine. After i tried a install of a specific
package i run into this error. The rest looks fins an reacts quickly.
I use FreeTDS as ODBC connection and will check if this is indeed a ODBC
which involves to act as a sybase client (have not yet checked this).
I'll check my DB for this XML messages and will post back my experience
here...
Best regards,
Dave

On 24 nov 2009, at 20:58, Michiel Beijen wrote:

Hi Dave,

So you have a Ubuntu machine pointing at Microsoft SQL Server? That is
always tricky. Do you use one of the commercial Unix ODBC solutions,
for instance Easysoft's driver?

Some ODBC solutions involve acting as a Sybase client, which works
sometimes because Sybase and Microsoft SQL server have a shared code
base - but that is more than 12 years ago. So this might lead to
trouble on modern MS-SQL databases.

OTRS stores add-on packages as XML in the database. It **looks** like
that XML is not completely stored, or maybe isn't completely
transfered over to your OTRS system. You can try and take a look with
a query analyzer if the XML is in tact in the database.

My suggestion is that if you'd like to go the way of Linux with an
Microsoft SQL Server database, that you'd also invest in a proper ODBC
driver, and maybe work with Easysoft - or whatever vendor - support to
floss out any issues.

And of course Linux with PostgreSQL or MySQL as the database works fine...

May I ask what kind of issues you ran into with OTRS on Windows? It is
really straight forward to configure access to MS-SQL server from a
Windows based web server.

((enjoy))
-
Michiel Beijen
R&D

OTRS AG
Norsk-Data-Str 1.
61352 Bad Homburg
Germany

T: +31 (0) 6457 42418
F: +49 (0) 9421 56818-18
I:  http://www.otrs.com/

Business Location: Bad Homburg, Country Court: Bad Homburg, Commercial
register: 10751, Tax ID: 003 240
97505 Chairman of the Board: Burchard Steinbild, Managing Board: André
Mindermann (CEO), Martin Edenhofer

CU@ CeBIT 2010 in Hannover (Germany) and get to know more about OTRS
at booth no. C37, in hall 2 from March 2-6, 2010! http://bit.ly/7uyQfY


On Mon, Nov 23, 2009 at 12:30 PM, Dave Lageweg <Dave.Lageweg@tel.io> wrote:

Hi All,

Because I had problems on my windows installation i installed a clean Ubuntu

server and installed all modules and OTRS 2.4.5 on it.

My OTRS is pointing to a MSSQL database and everything looked fine last

week. Package Manager under admin was working but it did not showed me the

ITSM modules unfortunately.

I know i tried a install of package but can't remember now which one (i had

to help a customer the rest of the week and could not go further...).

When i now go to admin and then to package manager i get the following

software error:

Software error: not properly closed tag 'File'

Does anybody have any idea how to solve this?

Thanks in advance!

Best,

Dave

________________________________

Telio Nederland B.V. | Veemkade 540 | 1019 HE Amsterdam | Netherlands

Tel: 0320 750400 | E-Mail: nl-info@tel.io | Website: www.tel.io

--------------------------------------------------------------------------------

This electronic message contains information from Telio Nederland BV which

may be privileged or confidential. The information is intended to be for the

use of the individual(s) or entity named above. If you are not the intended

recipient be aware that any disclosure, copying, distribution or use of the

contents of this information is prohibited. If you have received this

electronic message in error, please notify us by telephone or email (to the

numbers or address above) immediately.

Diese Email enthaelt Informationen der Telio Nederland BV. Diese sind

moeglicherweise vertraulich und ausschliesslich fuer den Adressaten

bestimmt. Jeglicher Zugriff auf diese Email durch andere Personen als den

Adressaten ist untersagt. Sollten Sie nicht der fuer diese Email bestimmte

Adressat sein, ist Ihnen jede Veroeffentlichung, Vervielfaeltigung oder

Weitergabe wie auch das Ergreifen oder Unterlassen von Massnahmen im

Vertrauen auf erlangte Information untersagt. Sollten Sie diese

elektronische Nachricht irrtuemlicherweise erhalten haben, so informieren

Sie uns bitte unverzueglich telefonisch oder per Email (Kontaktdaten

obenstehend).

---------------------------------------------------------------------

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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!

http://www.otrs.com/en/support/enterprise-subscription/

---------------------------------------------------------------------
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/

________________________________
Telio Nederland B.V. | Veemkade 540 | 1019 HE Amsterdam | Netherlands
Tel: 0320 750400 | E-Mail: nl-info@tel.io | Website: www.tel.io

--------------------------------------------------------------------------------
This electronic message contains information from Telio Nederland BV which
may be privileged or confidential. The information is intended to be for the
use of the individual(s) or entity named above. If you are not the intended
recipient be aware that any disclosure, copying, distribution or use of the
contents of this information is prohibited. If you have received this
electronic message in error, please notify us by telephone or email (to the
numbers or address above) immediately.

Diese Email enthaelt Informationen der Telio Nederland BV. Diese sind
moeglicherweise vertraulich und ausschliesslich fuer den Adressaten
bestimmt. Jeglicher Zugriff auf diese Email durch andere Personen als den
Adressaten ist untersagt. Sollten Sie nicht der fuer diese Email bestimmte
Adressat sein, ist Ihnen jede Veroeffentlichung, Vervielfaeltigung oder
Weitergabe wie auch das Ergreifen oder Unterlassen von Massnahmen im
Vertrauen auf erlangte Information untersagt. Sollten Sie diese
elektronische Nachricht irrtuemlicherweise erhalten haben, so informieren
Sie uns bitte unverzueglich telefonisch oder per Email (Kontaktdaten
obenstehend).

---------------------------------------------------------------------
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/

---------------------------------------------------------------------
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/







Telio Nederland B.V. | Veemkade 540 | 1019 HE Amsterdam | Netherlands
Tel: 0320 750400 | E-Mail: nl-info@tel.io | Website: www.tel.io

--------------------------------------------------------------------------------
This electronic message contains information from Telio Nederland BV which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately.

Diese Email enthaelt Informationen der Telio Nederland BV. Diese sind moeglicherweise vertraulich und ausschliesslich fuer den Adressaten bestimmt. Jeglicher Zugriff auf diese Email durch andere Personen als den Adressaten ist untersagt. Sollten Sie nicht der fuer diese Email bestimmte Adressat sein, ist Ihnen jede Veroeffentlichung, Vervielfaeltigung oder Weitergabe wie auch das Ergreifen oder Unterlassen von Massnahmen im Vertrauen auf erlangte Information untersagt. Sollten Sie diese elektronische Nachricht irrtuemlicherweise erhalten haben, so informieren Sie uns bitte unverzueglich telefonisch oder per Email (Kontaktdaten obenstehend).