1 Topic by grepmaster

  • grepmaster
  • Member
  • Offline
  • Registered: 2010-09-30
  • Posts: 49

Topic: using both ldap & mysql address book

how do i use a squirrelmail's database from old server to get addresses from there but still be able to get global addressbook from ldap?

----

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

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,770

Re: using both ldap & mysql address book

You can add more address book in Roundcube. take a look its config file: roundcubemail-x.y.z/config/main.inc.php

3 Reply by grepmaster

  • grepmaster
  • Member
  • Offline
  • Registered: 2010-09-30
  • Posts: 49

Re: using both ldap & mysql address book

which one if you don't mind to point out?

i also found a sql command to (supposedly) do that 

mysql -u root -p -e 'INSERT INTO roundcubemail.contacts(
name,
firstname,
surname,
email,
user_id
)
SELECT nickname, firstname, lastname, email, '2'
FROM squirrelmail.address
WHERE owner = 'username'
ORDER BY lastname ASC;'

but no luck so far