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.lage...@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.lage...@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-i...@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-i...@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/