Forum for the Znuny LTS Fork and ((OTRS)) Community Edition

Hi Emin,

I was able to retrieve the size per year through a similar query
Thanks,
Manoj.

Hi Emin,

We store Articles in DB

Thanks,
Manoj.

Hi all,

Is there any way we could search the Ticket's size for an year.

Let say, if I wanted to know the Tickets for 2020. Can I get tickets size for that particular year from OTRS Admin interface or from cli.

Any help is appreciated.

Thanks,
Manoj.

Manoj, I just checked your post again and have some questions: 1.) You wrote "Also, I see /opt/otrs/var/article filled with all the attachments." and I assume the data was properly migrated. 2.) When you said "I noticed that the Article table was shrunk drastically but not the article_attachment." ...

Permissions should only be set with the otrs.SetPermissions.pl script unless you know you're doing. Don't change the Config.pm. Use the system configuration instead for these kinds of settings. StorageModule is for new articles. Even if set wrong, it wouldn't explain why the articles don't move whe...

Hi Manoj, What is the output if you just start migrating old tickets: bin/otrs.Console.pl Admin::Article::StorageSwitch --tickets-closed-before-days 1000 --target ArticleStorageFS --tolerant Please adjust the 1000 to a value what matches your system. - Roy Hi Roy, I have executed the script you men...

Thanks Emin for the response. I have 750 permissions on /opt/otrs/var with otrs as user and apache as the group On article folder I have sticky bit.. so seems like the permissions are fine. Like I mentioned earlier, the debug statement mentions ArticleStorageDB, though I have given ArticleStorageFS ...

Hi, I retried to move Article Storage from ArticleStorageDB to ArticleStorageFS using the following script by cleaning up the previously moved articles. shell> bin/otrs.Console.pl Admin::Article::StorageSwitch --target ArticleStorageFS. I have mentioned below modules in config.pm and the GUI sysconf...

Hello, I'm trying to migrate Article Storage from DB to FS and I ran the below script shell> bin/otrs.Console.pl Admin::Article::StorageSwitch --target ArticleStorageFS It took my almost half a day to get this script done. However, I noticed that, the Article table was shrunk drastically but not the...

Our current stack is as follows - CentOS 7.8 with Oracle 19c version. We had issues migrating from v5 to v6 and we fixed them for the migration to complete: 1. LOB extension 2. uncomment Timzone in /opt/otrs/scripts/DBUpdateTo6/TaskConfig/MigrateTimeZoneConfiguration.yml 3. rename triggers and seque...

Thank you. I was able to compile the DataTime::TimeZone but the perl modules still shows missing on the support data collector though I have cleaned the cache using bin/otrs.Console.pl Maint::Cache::Delete I have attached screenshots for ref where it shows I have everything needed on the box but sho...

Hello, I've recently installed OTRS V6. When I run the CheckModules.pl from the cli , I see all the required perl modules are installed but The support data collector on admin page shows missing perl modules though I have compiled modules and installed locally on the box. I suspect I'm missing some ...

Thanks Flo. That worked.

Hello Emin,

I tried installing and installing the FAQ Module but still throws an error even after running Cache Delete and Rebuild after uninstalling.

2. I dont have any SysConfig for FAQAcces/FAQ.

Please advice

Thanks,
M.

Hello, By any chance is there a way to change the MailAccountFetch Daemon execution time. I know its for every 10 minutes by default, but wanted it for every 5 minutes. And Also I noticed that it is not fetching emails which are arrived until 6th minute per execution period. For instance, if its bet...

I was missing including /usr/bin in envt variable under /etc/sysconfig/httpd for apache to access the OS Libraries.

Thanks everyone and sorry for updating so late.

Best,
M.

Hello Mano, Try to execute this command as the OTRS user: /opt/otrs/bin/otrs.Console.pl Maint::Config::Rebuild --cleanup and restart the web server. Best regards Emin Edit: Just saw that you're using OTRS 5. Try to remove the parameter. Hello Emin, I have tried using without parameter, but I still ...

Thanks for the response. Its still the same. I have ran the command and deleted the binary files that are being created by apache. But stilll I find that in logs. Is there anything else that I can try. FYI, command - bin/otrs.Console.pl Maint::Config::Rebuild --cleanup-user-config for V5 OTRS. Best,...

Hello, I wanted to completely get rid of FAQ Module so I have uninstalled FAQ Package from the admin page which also said that it deletes the tables. But, even after deleting the cache from otrs shell (bin/otrs.Console.pl Maint::Cache::Delete) and restarting the apache ,I still see the error in my o...

Hello, Im currently running OTRS 5 with SeLinux enabled on CentOS. When I visit Agents ,Groups, Roles I have this error popping up on the OTRS Admin page. Can't use an undefined value as a SCALAR reference at /opt/otrs//Kernel/Output/HTML/Layout.pm line 1651. and in the otrs logs I see this --> [Err...

Hello, I wanted to completely get rid of FAQ Module so I have uninstalled FAQ Package from the admin page which also said that it deletes the tables. But, even after deleting the cache from otrs shell (bin/otrs.Console.pl Maint::Cache::Delete) and restarting the apache ,I still see the error in my o...

Hello, Im currently running OTRS 5 with SeLinux enabled on CentOS7. When I visit Agents ,Groups, Roles I have this error popping up on the OTRS Admin page. Can't use an undefined value as a SCALAR reference at /opt/otrs//Kernel/Output/HTML/Layout.pm line 1651. and in the otrs logs I see this --> [Er...

Thanks for your response.

Hello,

When is OTRS v5 and OTRS v6 EOL ?

Thanks,
Manoj

Yes, under /opt/otrs , the directory permissions are 750 and files has 640 with otrs as an user and apache as a admin and webgroup. So, I think OTRS is happy with the permissions.

All I need is a solution for the use case mentioned above.

Thanks for the reply Emin. thats actually a good solution but Im setting up SeLinx labels: For, Home dir (/opt/otrs) it needs sys_content(read only) excluding some folders under /opt/otrs/var that needs rw_content and .pl files that need exec permissions. So, if I use skip-regex that would intent to...

Hello, I'm trying to develop a simple if condition clause for my otrs.SetPermissions.pl file so that it would set permissions for /opt/otrs/ exlucding or ignoring few paths i.e /opt/otrs/scripts /opt/otrs/var/tmp/Article /opt/otrs/var/tmp/Ticket .. .. or may be passing a variable that matches to ign...

Im using CentOS7 with SeLinux on permissive mode(dealing with Permissions to get it on enforcing mode simultaneously). Current folder permissions, drwxr-x---. otrs apache system_u:object_r:httpd_sys_content_t:s0 Custom drwxr-x---. otrs apache system_u:object_r:httpd_sys_content_t:s0 doc drwxr-x---. ...

Those two commands were able to execute from the shell. When I clicked on Support Data Collector from the OTRS Admin page, I see these logs on apache Can't exec "df": No such file or directory at /opt/otrs//Kernel/System/SupportDataCollector/Plugin/OS/DiskSpacePartitions.pm line 41. -e: Can't exec "...

Yes. But, how do we get that info from . Should we have some perl module or configure anything at OS level or within OTRS source code ? If so, where exactly should we do that to get that info

Hello,

How can we load Kernel Version in Operating System section for DataSupportCollector for OTRS v6? In other words, what part of the source code has to be manipulated to fetch Kernel Version details.

Thanks,
Manoj.