i installed roudcube on my centos 5.5 that also have squirrelmail 1.4.8

this squirrelmail have enabled its global addressbook. It's data is located in squirrelmail's database

how can i possibly make roundcube read squirrelmail's global address book?

i already asked in roundcube's forum but no output so far, which can be found at http://www.roundcubeforum.net/10-mis...roundcube.html

Hi,

What kind of addressbook you use for squirrelmail?
If you use the native squirrelmail's addressbook, that stores data in csv format, then I guess it can be done. I don't use roundcube, but according to this, you can transform a csv addressbook to vCard format and then insert it to roundcube.
Mind that using the csv to vCard converter, you have to replace "|" with "," and the 1st line must contain the field names, i.e.:
Hope that helps

it is using mysql database to store global address book

In that case you have to export the mysql table to csv format and use the converter to transform it into vCard
You can use the example here to export the mysql db to csv. Since only commas are needed to separate fields in the csv file, you can use the simpler:
Where:
exampleuser is the mysql user (default squirrelmail)
letmein is the password of the above user
Note that the above 2 must come right after the -u and -p options (specially the password), or it's not going to work
squirrelmail is the database name (default)
global_abook is the global addressbook table (default)

If you have not used the default names, change the mysql command accordingly.

Regards

firstly, thanks for the detailed solution. It might be useful someday.

but what i'm looking for is a way to use squirrelmail global addressbook that can also be accessed with roundcube's global addressbook. So if the admin added a new global address, it can be viewed both from squirrelmail and roundcube.

Unless both applications use the same database name, tables and fields, I don't think that it's possible to have a common addressbook database for both.

Regards