Hi all,
FYI, this matter was resolved thanks to Zdenek Salvet from the DMSU:
https://ggus.eu/index.php?mode=ticket_info&ticket_id=142425
________________________________________
From: LHC Computer Grid - Rollout [[log in to unmask]] on behalf of Yuri P. Ivanov [[log in to unmask]]
Sent: 25 July 2019 13:23
To: [log in to unmask]
Subject: [LCG-ROLLOUT] CREAM-CE at CentOS 7: could not create connection to database server
Dear all,
During years we had no problems with CREAM-CE server under SL6 configured
with YAIM. But now everybody is moving to CentOS7. So now I'm trying also
to setup CREAM-CE at CentOS7. To configure it I used Puppet module
https://forge.puppet.com/infnpd/creamce
Puppet 'creamce' configurator runs without errors. And it looks that most
of CREAM components work properly. But as far as CREAM service tries to
connect to CREAM databases ('mariadb' is used as MySQL) it fails with
error message like
25 Jul 2019 13:45:29,846 ERROR org.glite.ce.commonj.db.DatasourceManager
- Cannot create PoolableConnectionFactory
(Could not create connection to database server. Attempted reconnect 3 times. Giving up.)
I did all tests I could invent:
1. Verify that service 'mariadb' is up and running;
2. All CREAM users are defined and have proper access rights:
MariaDB [(none)]> SELECT Host, User FROM mysql.user;
+-----------------+-------------+
| Host | User |
+-----------------+-------------+
| 127.0.0.1 | root |
| ::1 | root |
| lgdce01.jinr.ru | cream |
| lgdce01.jinr.ru | minprivuser |
| lgdce01.jinr.ru | root |
| localhost | cream |
| localhost | minprivuser |
| localhost | root |
+-----------------+-------------+
8 rows in set (0.00 sec)
3. All 'glite' services are running
# systemctl status glite-services.target
● glite-services.target - Master service for CREAM CE
Loaded: loaded (/usr/lib/systemd/system/glite-services.target; static; vendor preset: disabled)
Active: active since Thu 2019-07-25 13:37:40 MSK; 20min ago
Jul 25 13:37:40 lgdce01.jinr.ru systemd[1]: Reached target Master service for CREAM CE.
4. All database properties (including 'username' and 'password') are
correctly defined in '/etc/glite-ce-cream/cream-config.xml':
5. I even wrote small Java program which tries to open 'creamdb'
database as user 'cream' with correct password. And it works!
But despite all that CREAM services still can't connect to MariaDB. I put
in attachment file glite-ce-logs.tar.gz which contains some log files
/var/log/cream/glite-ce-bnotifier.log
/var/log/cream/glite-ce-bupdater.log
/var/log/cream/glite-ce-cream.log
Erros on failed attemps to connect to database are in glite-ce-cream.log.
Does anybody have any idea what can be wrong? What one can check/verify ?
With the best wishes,
Yuri Ivanov
########################################################################
To unsubscribe from the LCG-ROLLOUT list, click the following link:
https://www.jiscmail.ac.uk/cgi-bin/webadmin?SUBED1=LCG-ROLLOUT&A=1
########################################################################
To unsubscribe from the LCG-ROLLOUT list, click the following link:
https://www.jiscmail.ac.uk/cgi-bin/webadmin?SUBED1=LCG-ROLLOUT&A=1
|