Connect: Unable to determine enabled services from ldap

[odiecoranes]

Hi everyone,

Encountered this error after installing patch-888

Zimbra Version: Release 8.8.8_GA_2009.RHEL7_64_20180322150747 RHEL7_64 FOSS edition.

Host localhost
Connect: Unable to determine enabled services from ldap.
Unable to determine enabled services. Cache is out of date or doesn't exist.

I noticed that host mail.mydomain.com have changed to Host localhost

[DualBoot]

Hello,

did you change any else ? (/etc/hosts or DNS record)
Try to start zimbra ldap alone and check if it works.

Regards,

[odiecoranes]

Hi Dualboot,

Didn't touch anything..

ldap is running

[zimbra@mail ~]$ ldap start
Started slapd: pid 9415
[zimbra@mail ~]$ ldap status
slapd running pid: 9415


[zimbra@mail ~]$ zmcontrol start
Host localhost
Connect: Unable to determine enabled services from ldap.
Unable to determine enabled services. Cache is out of date or doesn't exist.
[zimbra@mail ~]$ zmcontrol status
Connect: Unable to determine enabled services from ldap.
Unable to determine enabled services. Cache is out of date or doesn't exist.



Here's my hosts and DNS configuration

cat /etc/hosts
#127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
#::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

127.0.0.1 localhost.localdomain localhost
172.16.20.2 mail.mydomain.com mail



cat /etc/resolv.conf
# Generated by NetworkManager
search mydomain.com
nameserver 172.16.20.2
nameserver 8.8.8.8


dig mydomain.com mx

; <<>> DiG 9.9.4-RedHat-9.9.4-61.el7 <<>> mydomain.com mx
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 36751
;; flags: qr aa rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 1, ADDITIONAL: 3

;; OPT PSEUDOSECTION:
; EDNS: version: 0, flags:; udp: 4096
;; QUESTION SECTION:
;mydomain.com. IN MX

;; ANSWER SECTION:
mydomain.com. 86400 IN MX 0 mail.mydomain.com.

;; AUTHORITY SECTION:
mydomain.com. 86400 IN NS ns1.mydomain.com.

;; ADDITIONAL SECTION:
mail.mydomain.com. 86400 IN A 172.16.20.2
ns1.mydomain.com. 86400 IN A 172.16.20.2

;; Query time: 0 msec
;; SERVER: 172.16.20.2#53(172.16.20.2)
;; WHEN: Thu Sep 20 20:35:01 +08 2018
;; MSG SIZE rcvd: 114


nslookup mail.mydomain.com
Server: 172.16.20.2
Address: 172.16.20.2#53

Name: mail.mydomain.com
Address: 172.16.20.2

[DualBoot]

I think you should recreate the certificate authority and redeploy self-signed certificates and check the service after zmcontrol restart.
If you have signed certificate, backup /opt/zimbra/ssl and redploy it again after the first redeployment.

Regards

[odiecoranes]

Fix my host name "localhost" issue by changing the name of the local zimbra server

1. Stop ldap
2. /opt/zimbra/libexec/zmsetservername -n <servername>
3. recreate the certificate authority and redeploy self-signed certificates

Now I've got some services running, mysql is running but appears to be not running. Tried to stop and restart services but still not working found out that
zimbra user can't connect to database in mailbox.log below. How can I fix this issue? Do I need to change mysql password?


[zimbra@mail ~]$ mysql.server status
mysql is running with pid 21373

[zimbra@mail ~]$ zmcontrol status
Host mail.allcard.com.ph
amavis Running
antispam Running
antivirus Running
ldap Running
logger Running
mailbox Stopped
mysql.server is not running.
memcached Running
mta Running
opendkim Running
proxy Running
service webapp Stopped
mysql.server is not running.
snmp Running
spell Running
stats Stopped
zimbra webapp Stopped
mysql.server is not running.
zimbraAdmin webapp Stopped
mysql.server is not running.
zimlet webapp Stopped
mysql.server is not running.
zmconfigd Running

here's mysql_error.log

[root@mail ~]# tail /opt/zimbra/log/mysql_error.log
2018-09-21 1:37:20 139771642496896 [Note] InnoDB: Completed initialization of buffer pool
2018-09-21 1:37:20 139771642496896 [Note] InnoDB: Highest supported file format is Barracuda.
2018-09-21 1:37:21 139771642496896 [Note] InnoDB: 128 rollback segment(s) are active.
2018-09-21 1:37:21 139771642496896 [Note] InnoDB: Waiting for purge to start
2018-09-21 1:37:21 139771642496896 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 27344702626
2018-09-21 1:37:21 139768857503488 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-09-21 1:37:21 139771642496896 [Note] Plugin 'FEEDBACK' is disabled.
2018-09-21 1:37:21 139771642496896 [Note] Server socket created on IP: '127.0.0.1'.
2018-09-21 1:37:21 139771642496896 [Note] /opt/zimbra/common/sbin/mysqld: ready for connections.
Version: '10.1.25-MariaDB' socket: '/opt/zimbra/data/tmp/mysql/mysql.sock' port: 7306 Zimbra MariaDB binary distribution


mailbox.log

[root@mail ~]# tail /opt/zimbra/log/mailbox.log
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
at com.zimbra.cs.db.DbPool.getConnection(DbPool.java:341)
... 56 more
Caused by: org.mariadb.jdbc.internal.common.QueryException: Could not connect: Access denied for user 'zimbra'@'localhost' (using password: YES)
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.checkErrorPacket(MySQLProtocol.java:558)
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.connect(MySQLProtocol.java:500)
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.connect(MySQLProtocol.java:709)
at org.mariadb.jdbc.internal.mysql.MySQLProtocol.<init>(MySQLProtocol.java:280)
at org.mariadb.jdbc.Driver.connect(Driver.java:111)
... 64 more

[DualBoot]

I do not understand your "localhost issue".
Your /etc/hosts should look like :
127.0.0.1 localhost.localdomain localhost
your_IP your_fqdn your_short_name

Why did you change change your server name ?