Support Assessment Notices in OTRS Dashboard

Hi, I see failure and critical notices in Support Assessment. do i need to run any script to fix it after attending the notices. Is there a way to make it reflect on the Support Assessment Dashboard? I have restarted OTRS and httpd and MySQL services. Any clue? Failed Check "max_allowed_packet" setting. "max_allowed_packet" should be higher than 7 MB (it's 1 MB). Any config file to be edited? Critical Check "query_cache_size" setting. The setting "query_cache_size" should be used. Any config file to be edited? Check if root@localhost account has the default password. Critical Change the password or invalidate the account 'root@localhost'. Failed Check if the configured FQDN is valid. Invalid FQDN 'otrsexample'. Please suggest. Regards, Kaushal

max_allowed_packet setting is in your my.ini configuration of MySQL.
query_cache_size, same
root@localhost password within OTRS, Agents
FQDN otrsexample see/search sysconfig within OTRS
Edit Config Settings in Framework -> Core
On Thu, Aug 2, 2012 at 10:21 PM, Kaushal Shriyan
Hi,
I see failure and critical notices in Support Assessment. do i need to run any script to fix it after attending the notices. Is there a way to make it reflect on the Support Assessment Dashboard? I have restarted OTRS and httpd and MySQL services. Any clue?
Failed Check "max_allowed_packet" setting.
"max_allowed_packet" should be higher than 7 MB (it's 1 MB). Any config file to be edited?
Critical Check "query_cache_size" setting.
The setting "query_cache_size" should be used. Any config file to be edited?
Check if root@localhost account has the default password.
Critical Change the password or invalidate the account 'root@localhost '.
Failed Check if the configured FQDN is valid.
Invalid FQDN 'otrsexample'.
Please suggest.
Regards,
Kaushal --------------------------------------------------------------------- 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

So max_allowed_packet and query_cache_size are mysql variables, default
installs usually have query_cache turned off and aren't tuned at all. Ask
your DBA to configure/tune your MySQL server, if you are the DBA then
Google is your friend.
"Critical Change the password or invalidate the account 'root@localhost'."
= change the password for the root account in OTRS
"Failed Check if the configured FQDN is valid." = check the FQDN setting in
Sysconfig -> Framework -> Core -> FQDN - this needs to be the fully
qualified domain name of the system.
Steve
On 3 August 2012 03:21, Kaushal Shriyan
Hi,
I see failure and critical notices in Support Assessment. do i need to run any script to fix it after attending the notices. Is there a way to make it reflect on the Support Assessment Dashboard? I have restarted OTRS and httpd and MySQL services. Any clue?
Failed Check "max_allowed_packet" setting.
"max_allowed_packet" should be higher than 7 MB (it's 1 MB). Any config file to be edited?
Critical Check "query_cache_size" setting.
The setting "query_cache_size" should be used. Any config file to be edited?
Check if root@localhost account has the default password.
Critical Change the password or invalidate the account 'root@localhost '.
Failed Check if the configured FQDN is valid.
Invalid FQDN 'otrsexample'.
Please suggest.
Regards,
Kaushal --------------------------------------------------------------------- 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

On Fri, Aug 3, 2012 at 8:07 PM, Steven Carr
So max_allowed_packet and query_cache_size are mysql variables, default installs usually have query_cache turned off and aren't tuned at all. Ask your DBA to configure/tune your MySQL server, if you are the DBA then Google is your friend.
"Critical Change the password or invalidate the account 'root@localhost'." = change the password for the root account in OTRS
"Failed Check if the configured FQDN is valid." = check the FQDN setting in Sysconfig -> Framework -> Core -> FQDN - this needs to be the fully qualified domain name of the system.
Steve
On 3 August 2012 03:21, Kaushal Shriyan
wrote: Hi,
I see failure and critical notices in Support Assessment. do i need to run any script to fix it after attending the notices. Is there a way to make it reflect on the Support Assessment Dashboard? I have restarted OTRS and httpd and MySQL services. Any clue?
Failed Check "max_allowed_packet" setting.
"max_allowed_packet" should be higher than 7 MB (it's 1 MB). Any config file to be edited?
Critical Check "query_cache_size" setting.
The setting "query_cache_size" should be used. Any config file to be edited?
Check if root@localhost account has the default password.
Critical Change the password or invalidate the account 'root@localhost'.
Failed Check if the configured FQDN is valid.
Invalid FQDN 'otrsexample'.
Please suggest.
Regards,
Kaushal --------------------------------------------------------------------- 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
--------------------------------------------------------------------- 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
Hi, Thanks Gerald,Steven It worked like a charm and also i do get "You have more error log entries: No such /etc/ssl/certs!, No such /etc/ssl/certs!," in Support Assessment and also is there a way to set http://myotrs.company.com/otrs/index.pl to http://myotrs.company.com/? Regards, Kaushal
participants (3)
-
Gerald Young
-
Kaushal Shriyan
-
Steven Carr