1 Topic by jsmith2500

  • jsmith2500
  • Member
  • Offline
  • Registered: 2021-03-31
  • Posts: 2

Topic: Script to update all email user personal address book.

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.4.0
- Deployed with iRedMail Easy or the downloadable installer? Downloadable
- Linux/BSD distribution name and version: Ubuntu 20.04.2 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): Maria/MySQL
- Web server (Apache or Nginx):Nginx
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
Hello,

I was hoping I could find some help. I plan on implementing a way to update all users Personal Address Book that have a mailbox. I am using SOGO. I have been able to access the database and find the sogo_quick_contact table using Heidi. Is there anything I should be aware of before I just go changing information directly in this table? Or even better, does anyone have a good method to do this already that they are willing to share? Thanks!

-Jason

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by jsmith2500

  • jsmith2500
  • Member
  • Offline
  • Registered: 2021-03-31
  • Posts: 2

Re: Script to update all email user personal address book.

Or is this something I should post on a Sogo forum?

3 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: Script to update all email user personal address book.

Didn't try to do it with raw SQL before, i suggest get some help or confirm from SOGo mailing list instead.