Data in agent dashboard not updated !

Moderator: crythias

Locked
talu
Znuny newbie
Posts: 5
Joined: 23 Nov 2012, 11:17
Znuny Version: 3.1.9
Location: Brussels, Belgium

Data in agent dashboard not updated !

Post by talu »

I decided to put my mysql instance on a separate server.
I changed the config.pm to set the new settings :
# ---------------------------------------------------- #
# database settings #
# ---------------------------------------------------- #
# The database host
$Self->{'DatabaseHost'} = 'srv-otrs-dbm'; <== the new DB server

# The database name
$Self->{'Database'} = 'otrs_tech';


# The database DSN for MySQL ==> more: "perldoc DBD::mysql"
$Self->{DatabaseDSN} = "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};port=3307";


I restarted my otrs server with new config. The DB connection was OK.
I deleted the cache (otrs.DeleteCache.pl).
I opened a session in OTRS.
I created new tickets, updated old tickets. It seemed all was OK.
But it is a problem with updating the data in the dashboard.
The data in the dashboard seems as freezed. New tickets are not displayed.
Old tickets attributes are not updated in the dashboard.
The dashboard stats is not updated,....

Any idea ?
Thanks in advance,

My configuration is the following :

- server OTRS : Windows server 2008 R2 Datacenter SP1
OTRS Version 3.2.2
- DB server : Windows server2012 Datacenter
MySQL server 5.6
OTRS 3.1.9 sous Windows 2008 avec MySQL
ITSM 3.1.6, FAQ 2.1.3
ThorstenEckel
Znuny newbie
Posts: 24
Joined: 18 Dec 2013, 16:57
Znuny Version: *.*.*
Company: Znuny GmbH
Location: Berlin
Contact:

Re: Data in agent dashboard not updated !

Post by ThorstenEckel »

Hi talu,

thats kinda odd... The dashboard uses the same database connection as any other functionality in your OTRS. So you say everything in the dashboard is freezed or are some of the widgets updated propery? Did you already have deleted your browser cache? If not it would be worth a try...
How about your Webserver? are you running OTRS with mod_perl enabled? You should try to stop and start your webserver and see if its work.
Znuny4OTRS Extensions auf Github: https://github.com/znuny/
Znuny4OTRS - intl. Enterprise Services: https://znuny.com
Locked