Search found 13 matches

by turnip
16 Apr 2018, 08:50
Forum: Developers
Topic: FAQ DB schema
Replies: 2
Views: 36287

Re: FAQ DB schema

Thanks Emin.
by turnip
15 Apr 2018, 01:45
Forum: Developers
Topic: FAQ DB schema
Replies: 2
Views: 36287

FAQ DB schema

I'm trying to verify the DB schema of my current database for the FAQ module.

Where is the code that creates the FAQ tables such as faq_item etc.?

Is there a FAQ schema similar to scripts\database\otrs-schema.xml?

Thanks!
by turnip
01 May 2015, 04:43
Forum: General
Topic: Installing OTRS 4.0.7 on Windows Server 2012 R2, IIS 8.5
Replies: 9
Views: 13251

Re: Installing OTRS 4.0.7 on Windows Server 2012 R2, IIS 8.5

(continued) Performance Generally, it takes time for perl.exe to load itself and OTRS modules. However, with FastCGI, instances of perl.exe remain in memory to handle multiple web requests, which speeds up the things greatly. Note that there will be a delay when a new instance is loaded (for example...
by turnip
01 May 2015, 04:15
Forum: General
Topic: Installing OTRS 4.0.7 on Windows Server 2012 R2, IIS 8.5
Replies: 9
Views: 13251

Re: Installing OTRS 4.0.7 on Windows Server 2012 R2, IIS 8.5

(continued) 24. Edit C:\opt\otrs\bin\otrs.Scheduler4win.pl: - Change "notice" to "debug": ... Priority => 'notice', Message => "Scheduler Service status request! PID $SchedulerPID{PID}", ... - Comment out the check related to Win32::IsAdminUser(). In our setup, it's not...
by turnip
01 May 2015, 04:02
Forum: General
Topic: Installing OTRS 4.0.7 on Windows Server 2012 R2, IIS 8.5
Replies: 9
Views: 13251

Re: Installing OTRS 4.0.7 on Windows Server 2012 R2, IIS 8.5

(continued) 15. In IIS Manager, add the following virtual directories to the website: otrs -> c:\opt\otrs\bin\fcgi-bin otrs-web -> c:\opt\otrs\var\httpd\htdocs 16. Edit %windir%\system32\inetsrv\config\applicationHost.config to add/modify the following section: <fastCgi> <application fullPath="...
by turnip
01 May 2015, 02:35
Forum: General
Topic: Installing OTRS 4.0.7 on Windows Server 2012 R2, IIS 8.5
Replies: 9
Views: 13251

Re: Installing OTRS 4.0.7 on Windows Server 2012 R2, IIS 8.5

(continued) 14. If you need POP3S/POP3TLS/SMTPS/SMTPTLS: The availability of POP3S and POP3TLS protocols displayed by C:\opt\otrs\bin\fcgi-bin\installer.pl (wich uses C:\opt\otrs\Kernel\Modules\Installer.pm) is determined by Kernel::System::MailAccount::MailAccountBackendList() which tries to load m...
by turnip
01 May 2015, 01:35
Forum: General
Topic: Installing OTRS 4.0.7 on Windows Server 2012 R2, IIS 8.5
Replies: 9
Views: 13251

Re: Installing OTRS 4.0.7 on Windows Server 2012 R2, IIS 8.5

Below is how I moved OTRS 4.0.7 from CentOS/MySQL to Windows Server 2012 R2/IIS 8.5/SQL Server Express 2014. Install the IIS CGI role. Create an IIS website running the "MyAppPool" application pool with the "ApplicationPoolIdentity". Install 64-bit Perl from strawberryperl.com to...
by turnip
01 May 2015, 00:41
Forum: General
Topic: Installing OTRS 4.0.7 on Windows Server 2012 R2, IIS 8.5
Replies: 9
Views: 13251

Re: Installing OTRS 4.0.7 on Windows Server 2012 R2, IIS 8.5

By the way, what did you mean by "Mails can only be handled by direct smtp", the lack of sendmail? In my setup, OTRS sends emails to the local (the same machine) Microsoft SMTP Server, the latter then forwards mail to Google Mail Relay for actual delivery.
by turnip
01 May 2015, 00:36
Forum: General
Topic: Installing OTRS 4.0.7 on Windows Server 2012 R2, IIS 8.5
Replies: 9
Views: 13251

Re: Installing OTRS 4.0.7 on Windows Server 2012 R2, IIS 8.5

No stable setup for Apache + mod_perl To my personal taste, IIS is more pleasant to deal with, even after I used Apache for OTRS/phpBB for the last 7 years. PerlEx (needs Active State Perl Licence) for IIS seems EOL Yes, Active Perl is expensive, but I used free Strawberry Perl. PerlEx is not neede...
by turnip
28 Apr 2015, 01:54
Forum: Howtos
Topic: Migrate OTRS from MySQL to MSSQL (Microsoft SQL Server 2008
Replies: 9
Views: 68254

Re: Migrate OTRS from MySQL to MSSQL (Microsoft SQL Server 2008

I recently went through the process of migrating from MySQL to SQL Server. I used "Migrate Data" in SSMA without "Convert Schema". One of the problems was that SSMA refused to migrate from LONGBLOB to nvarchar, which I solved as follows: In SQL Management Studio, change the desti...
by turnip
28 Apr 2015, 01:37
Forum: General
Topic: Installing OTRS 4.0.7 on Windows Server 2012 R2, IIS 8.5
Replies: 9
Views: 13251

Installing OTRS 4.0.7 on Windows Server 2012 R2, IIS 8.5

I've been using OTRS on CentOS/Apache for 7 years until last month. I got tired of Linux and the need to maintain two separate VMs (Linux & Windows), so I decided to move OTRS, phpBB and as my main .NET website to Windows Server 2012 R2 running IIS 8.5. I was disappointed to learn that otrs.com ...
by turnip
22 Aug 2010, 08:55
Forum: Help
Topic: Upgrading 2.2.5 to latest 2.4.7 on a new server
Replies: 3
Views: 2252

Re: Upgrading 2.2.5 to latest 2.4.7 on a new server

Thank you. Are you saying that all settings and tickets are stored in the database, and I don't need any files from a previous version?
by turnip
20 Aug 2010, 04:58
Forum: Help
Topic: Upgrading 2.2.5 to latest 2.4.7 on a new server
Replies: 3
Views: 2252

Upgrading 2.2.5 to latest 2.4.7 on a new server

Hello, I would like to transfer all tickets and [if possible] settings from my current OTRS 2.2.5 to latest 2.4.7 which I am going to install on a new separate server. I understand that I can upgrade 2.2.5 > 2.3 > 2.4, back it up and then restore to 2.4.7 on the other server. Is there an easier way ...