From: <su...@rk...> - 2004-11-22 20:35:24
|
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/ |