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
Data in agent dashboard not updated !
Moderator: crythias
-
- Znuny newbie
- Posts: 5
- Joined: 23 Nov 2012, 11:17
- Znuny Version: 3.1.9
- Location: Brussels, Belgium
Data in agent dashboard not updated !
OTRS 3.1.9 sous Windows 2008 avec MySQL
ITSM 3.1.6, FAQ 2.1.3
ITSM 3.1.6, FAQ 2.1.3
-
- 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 !
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.
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
Znuny4OTRS - intl. Enterprise Services: https://znuny.com