Re: [SM-PLUGINS] Global Address book plugin

[Tomas K. <to...@us...>]

> Getting error message (translated) "could not contact the address book
> database", when activating the "address" field in sqm. Using sqm
> 1.4.3.a in a win 2003 environment (IIS 6), and with mysql v. 4.1.7
> (and latest php and pearl).
> Have configured $addrbook_dsn =
> '//sqmail:xxxxxxxx@localhost/rk_adresser'; (format:
> user:password@host/dbasename (using config.pl) and tried to follow the
> instructions in "install" and in "global_sql_addressbook" however
> unsure about the basic setup and maybe answering the follwing
> questions could help me troubleshoot;
>
> 1. should there be a dsn entry for the mysql database in the win
> servers odbc database (administrative tools)?
>
> 2. when creating a table (globaddress) in mysql, a file
> (globaddress.frm) is created in the mysql/database folder
> (rk_adresser), but the plugin install file says (line 40) that default
> location is in the personal address books location, which is in the
> sqmail data folder ? How (and where) do I configure the file location
> of the global address book ?
>
> 3. In the abook_global_database it is stated (line 15)
>  * An array with the following elements must be passed to
>  * the class constructor (elements marked ? are optional):
>  *    dsn       => database DNS (see PEAR for syntax)
>  *    table     => table to store addresses in (must exist)
>  *    owner     => current user (owner of address data)
>  *  ? writeable => set writeable flag (true/false)
> I have configured the dsn (as above) in config/config.php, assuming
> that this also takes care of passing the table and owner to the "class
> constructor" - do I need to configure any of these settings elsewhere
> ?
> 4. and from line 23;
>  * The table used should have the following columns:
>  * owner, nickname, firstname, lastname, email, label
>  * The pair (owner,nickname) should be unique (primary key).
> Where can I change/configure these parametres ?
>
> Any help with the above questions much appreciated :-)
> rgds

which version of global_sql_addressbook patch? have you tried 1.4.4cvs or
1.5.1cvs?

why you haven't set phptype/db backend name in DSN?

http://pear.php.net/manual/en/package.database.db.intro-dsn.php

table field names are hardcoded in functions/abook_global_database.php and
functions/abook_database.php.

-- 
Tomas