Member Avatar for blud

I've posted this on cpanel's forums as well but I was hoping someone here might have a solution, I have a cpanel machine with horde, and when I try to add to the address book it seems that nothing gets added, the database exsists, there are no errors in horde.log file, I've already re-installed horde, droped-recreated the database, and it still is not adding. Anyone experienced this before?

***Ps: I hope this is the right forum, as there is not one for 'webmail clients' :rolleyes:

  • 2 Contributors
  • 2 Replies
  • 190 Views
  • 3 Weeks Discussion Span
  • Latest Post Latest Post by Dani

Dani AI

Generated

Short summary: thread was resolved when discovered the Horde MySQL user had no write privileges and could not insert address-book entries. This is a common cause: the web UI acts like it saved data but the DB silently rejects writes (and Horde logs don’t always show obvious SQL errors).

Quick checks and fix (replace names/placeholders as needed):

# view grants (run as a MySQL admin)
mysql -uroot -p -e "SHOW GRANTS FOR 'horde'@'localhost';"

# check the horde DB connection and tables
mysql -uhorde -p -D horde_db -e "SHOW TABLES;"

# grant minimal needed privileges (run as root/admin)
mysql -uroot -p -e "GRANT SELECT, INSERT, UPDATE, DELETE ON horde_db.* TO 'horde'@'localhost' IDENTIFIED BY 'horde_password'; FLUSH PRIVILEGES;"

Notes and common gotchas: cPanel often prefixes DB and user names with the account name—confirm the exact DB/user used in Horde’s config (conf files under Horde/imp/turba/backends). MySQL treats 'localhost' and '127.0.0.1' as different hosts, so grant against the host the PHP process actually uses. Verify table name/prefixes in Horde’s address-book backend settings. If changes are made, clear Horde caches and restart the webserver/PHP so new credentials take effect.

Other useful diagnostics: increase Horde/PHP error/debug logging to capture SQL errors, scan MySQL error log for denied connections, and check system security layers (AppArmor/SELinux/firewall) that could prevent PHP from reaching MySQL. Prefer a dedicated DB user with least privileges (no GLOBAL grants) and test write access from the command line before relying on the web UI.

Credit: resolved by ; thread marked solved by .

Member Avatar for blud

*15 hours later, 7 troubleshooting this issue* Ok, I'm stupid, I forgot to give the 'horde' user write priviliges to the database.

Member Avatar for Dani

I'm marking this thread as solved. No webmail client forum, but we do have a web hosting forum :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.