[SM-PLUGINS] Re: Global Address book plugin

[<su...@rk...>]

Im using Plugins - MySQL Global AddressBook Backend v. 0.0.1 - I have
tried copying abook_global_database.php and both the versions of 1.4.3
diff patches (writeable/non-writeable) as instructed in install line
10-16, but havent tried the cvs patches you mention - have looked in
the "Browse cvs/plugins" section - however cant find them ? Not sure
how to apply the patches other than the "copy method" as mentioned?

Thks for the supplied link on intro to DSN - havent seen this, but
looking at example 26-1 - think it looks exactly like the syntax ive
been using (see below) ... what do you mean by phptype ?

Regarding hardcoded dbase fields - guess this means that I have to
construct the table exactly as the suggested layout, ie. even also
with the same combination of primary keys - otherwise it will fail ?
(with the below mentioned error message?)

Basicly - in regards to the dsn, if I configure a system dsn in the
odbc applet under admin tools, I need only supply a valid dsn name in
the config.php like $addrbook_dsn='valid_name' and not the whole
string like:
$addrbook_dsn='//sqmail:xxpasswordxx@localhost/rk_adresser'
is this correct ?

rgds
Jakob



On Mon, 22 Nov 2004 20:16:45 +0200 (EET), "Tomas Kuliavas"
<to...@us...> wrote:

>
>> 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
>
>
>-------------------------------------------------------
>SF email is sponsored by - The IT Product Guide
>Read honest & candid reviews on hundreds of IT Products from real users.
>Discover which products truly live up to the hype. Start reading now. 
>http://productguide.itmanagersjournal.com/