OTRS 5.1 taking too long to login

[JojoModjo]

Hi,

I have recently installed otrs 5.0.14 on a virtual Redhat linux server with the following specs:

4 cpu @ 2.4Ghz
4 GB RAM
100GB

MariaDB config file

[mysql]

# CLIENT #
port = 3306
socket = /var/lib/mysql/mysql.sock

[mysqld]

# GENERAL #
default-storage-engine = InnoDB
socket = /var/lib/mysql/mysql.sock
pid-file = /var/lib/mysql/mysql.pid

# MyISAM #
key-buffer-size = 32M
myisam-recover = FORCE,BACKUP

# SAFETY #
max-allowed-packet = 20M
max-connect-errors = 1000000

# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8


# MyISAM #
key-buffer-size = 1344M
myisam-recover = FORCE,BACKUP


# LOGGING #
log-error = /var/lib/mysql/mysql-error.log
log-queries-not-using-indexes = 1
slow-query-log = 1
slow-query-log-file = /var/lib/mysql/mysql-slow.log


# CACHES AND LIMITS #
tmp-table-size = 32M
max-heap-table-size = 32M
query-cache-type = 1
query-cache-size = 300M
max-connections = 500
thread-cache-size = 100
open-files-limit = 65535
table-definition-cache = 1024
table-open-cache = 100


# INNODB #
innodb-flush-method = O_DIRECT
innodb-log-files-in-group = 2
innodb-log-file-size = 256M
innodb-flush-log-at-trx-commit = 1
innodb-file-per-table = 1
innodb-buffer-pool-size = 2G

# LOGGING #
log-error = /var/lib/mysql/mysql-error.log


Now i have finished the installation but whenever i try to login after finishing the webinstaller it takes 13 minutes to bring up the dashboard screen.

INTERFACE REQUESTS MIN RESPONSE MAX RESPONSE AVERAGE RESPONSE
AgentDashboard 4 391s 780s 490.5s

I have tried this on several browsers still same result.
I have installed and uninstalled the database and otrs application several times still no change.

I have installed the necessary perl modules.

# sudo /opt/otrs/bin/otrs.CheckModules.pl
o Apache::DBI......................ok (v1.12)
o Apache2::Reload..................ok (v0.13)
o Archive::Tar.....................ok (v1.92)
o Archive::Zip.....................ok (v1.30)
o Crypt::Eksblowfish::Bcrypt.......Not installed! Use: 'yum install "perl(Crypt::Eksblowfish::Bcrypt)"' (optional - For strong password hashing.)
o Crypt::SSLeay....................ok (v0.64)
o Date::Format.....................ok (v2.24)
o DBI..............................ok (v1.627)
o DBD::mysql.......................ok (v4.023)
o DBD::ODBC........................Not installed! (optional - Required to connect to a MS-SQL database.)
o DBD::Oracle......................Not installed! (optional - Required to connect to a Oracle database.)
o DBD::Pg..........................Not installed! Use: 'yum install "perl(DBD::Pg)"' (optional - Required to connect to a PostgreSQL database.)
o Encode::HanExtra.................Not installed! Use: 'yum install "perl(Encode::HanExtra)"' (optional - Required to handle mails with several Chinese character sets.)
o IO::Socket::SSL..................ok (v1.94)
o JSON::XS.........................ok (v3.01)
o List::Util::XS...................ok (v1.27)
o LWP::UserAgent...................ok (v6.13)
o Mail::IMAPClient.................Not installed! Use: 'yum install "perl(Mail::IMAPClient)"' (optional - Required for IMAP TLS connections.)
o IO::Socket::SSL................ok (v1.94)
o ModPerl::Util....................ok (v2.000009)
o Net::DNS.........................ok (v0.72)
o Net::LDAP........................ok (v0.56)
o Template.........................ok (v2.24)
o Template::Stash::XS..............ok (undef)
o Text::CSV_XS.....................Not installed! Use: 'yum install "perl(Text::CSV_XS)"' (optional - Recommended for faster CSV handling.)
o Time::HiRes......................ok (v1.9725)
o Time::Piece......................ok (v1.20_01)
o XML::LibXML......................ok (v2.0018)
o XML::LibXSLT.....................ok (v1.80)
o XML::Parser......................ok (v2.41)
o YAML::XS.........................ok (v0.54)

Can anybody please tell me what is not happening, why is the system behaving like this .
Your guidance will be highly appreciated.

[jojo]

no internet connection and/or no working DNS might be the cause

[JojoModjo]

Hi Jojo,

Yes the server doesn't have an internet connection but the dns settings are okay, how is it that the internet could be affecting because this OTRS is only meant for local use within our domain.

[JojoModjo]

no internet connection and/or no working DNS might be the cause

Hi Jojo,

Yes the server doesn't have an internet connection but the dns settings are okay, how is it that the internet could be affecting because this OTRS is only meant for local use within our domain.

[jojo]

the Dashboard will connect to 2 services of OTRS group. You can switch them off via sysconfig

[JojoModjo]

the Dashboard will connect to 2 services of OTRS group. You can switch them off via sysconfig

Where exactly do i go to deactivate? i have given the server internet access right now and the performance has improved dramatically, logs in an instant.

[jojo]

have a look in Framework -> Frontend::Agent::Dashboard

[JojoModjo]

have a look in Framework -> Frontend::Agent::Dashboard

HI jojo thanks a lot your idea worked very well, now my system is responding greatly. Be blessed my brother.