[turba] DB Not Found

[Michael Rubinsky]

Quoting "Douglas W. Palme" <dpalme at cwtruck.com>:

> The authentication is via IMAP so it is not direct with the database.
>
> Here is the relevant part of the sources.php file.
>
> $cfgSources['mysql'] = array(
>     'title' => _("My Address Book"),
>     'type' => 'sql',
>     // The default connection details are pulled from the Horde-wide SQL
>     // connection configuration.
>     'params' => array_merge($GLOBALS['conf']['sql'], array('table' =>
> 'turba_objects')),
>     // Using two tables as datasource.
>     // 'params' => array_merge($GLOBALS['conf']['sql'],
>     //                         array('table' => 'leaddetails LEFT JOIN
> leadaddress ON leaddetails.leadid = leadaddress.leadaddressid',
>     //                               'filter' => 'leaddetails.converted =
> 0')),
>     'map' => array(
>         '__key' => 'object_id',
>         '__owner' => 'owner_id',
>         '__type' => 'object_type',
>         '__members' => 'object_members',
>         '__uid' => 'object_uid',
>         'firstname' => 'object_firstname',
>         'lastname' => 'object_lastname',
>         'middlenames' => 'object_middlenames',
>         'namePrefix' => 'object_nameprefix',
>         'nameSuffix' => 'object_namesuffix',
>         'name' => array('fields' => array('namePrefix', 'firstname',
>                                           'middlenames', 'lastname',
>
>
> Here is a copy of the conf.php file:
>
> <?php
> /* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
> // $Horde: horde/config/conf.xml,v 1.74.2.88 2009-09-02 08:21:46 jan Exp $
> $conf['vhosts'] = false;
> $conf['debug_level'] = E_ALL & ~E_NOTICE;
> $conf['max_exec_time'] = 0;
> $conf['compress_pages'] = true;
> $conf['secret_key'] = 'e12e48a1d5f2ced21ce70567639d6109aa856be5';
> $conf['umask'] = 077;
> $conf['use_ssl'] = 2;
> $conf['server']['name'] = $_SERVER['SERVER_NAME'];
> $conf['server']['port'] = $_SERVER['SERVER_PORT'];
> $conf['urls']['token_lifetime'] = 30;
> $conf['urls']['hmac_lifetime'] = 30;
> $conf['urls']['pretty'] = false;
> $conf['safe_ips'] = array();
> $conf['session']['name'] = 'Horde';
> $conf['session']['use_only_cookies'] = true;
> $conf['session']['cache_limiter'] = 'nocache';
> $conf['session']['timeout'] = 0;
> $conf['cookie']['domain'] = $_SERVER['SERVER_NAME'];
> $conf['cookie']['path'] = '/horde';
> $conf['sql']['phptype'] = false;
> $conf['auth']['admins'] = array('BrettFavre');
> $conf['auth']['checkip'] = true;
> $conf['auth']['checkbrowser'] = true;
> $conf['auth']['alternate_login'] = false;
> $conf['auth']['redirect_on_logout'] = false;
> $conf['auth']['list_users'] = 'list';
> $conf['auth']['params']['hostspec'] = 'localhost';
> $conf['auth']['params']['port'] = 143;
> $conf['auth']['params']['protocol'] = 'imap';
> $conf['auth']['params']['imapconfig'] = 'separate';
> $conf['auth']['driver'] = 'imap';
> $conf['signup']['allow'] = false;
> $conf['log']['enabled'] = false;
> $conf['log_accesskeys'] = false;
> $conf['prefs']['driver'] = 'session';
> $conf['alarms']['driver'] = false;
> $conf['datatree']['driver'] = 'null';
> $conf['group']['driver'] = 'datatree';
> $conf['group']['cache'] = false;
> $conf['perms']['driver'] = 'datatree';
> $conf['share']['no_sharing'] = false;
> $conf['share']['any_group'] = false;
> $conf['share']['cache'] = false;
> $conf['share']['driver'] = 'datatree';
> $conf['cache']['default_lifetime'] = 86400;
> $conf['cache']['params']['sub'] = 0;
> $conf['cache']['driver'] = 'file';
> $conf['lock']['driver'] = 'none';
> $conf['token']['driver'] = 'none';
> $conf['mailer']['params']['sendmail_path'] = '/usr/lib/sendmail';
> $conf['mailer']['params']['sendmail_args'] = '-oi';
> $conf['mailer']['type'] = 'sendmail';
> $conf['mailformat']['brokenrfc2231'] = false;
> $conf['vfs']['type'] = 'none';
> $conf['sessionhandler']['type'] = 'none';
> $conf['sessionhandler']['memcache'] = false;
> $conf['problems']['email'] = 'webmaster at example.com';
> $conf['problems']['maildomain'] = 'example.com';
> $conf['problems']['tickets'] = false;
> $conf['problems']['attachments'] = true;
> $conf['menu']['apps'] = array();
> $conf['menu']['always'] = false;
> $conf['menu']['links']['help'] = 'all';
> $conf['menu']['links']['options'] = 'authenticated';
> $conf['menu']['links']['problem'] = 'all';
> $conf['menu']['links']['login'] = 'all';
> $conf['menu']['links']['logout'] = 'authenticated';
> $conf['hooks']['permsdenied'] = false;
> $conf['hooks']['username'] = false;
> $conf['hooks']['preauthenticate'] = false;
> $conf['hooks']['postauthenticate'] = false;
> $conf['hooks']['authldap'] = false;
> $conf['hooks']['groupldap'] = false;
> $conf['portal']['fixed_blocks'] = array();
> $conf['accounts']['driver'] = 'null';
> $conf['user']['verify_from_addr'] = false;
> $conf['imsp']['enabled'] = false;
> $conf['kolab']['enabled'] = false;
> $conf['memcache']['enabled'] = false;
> /* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */
>
>
>
>>
>> Quoting "Douglas W. Palme" <dpalme at cwtruck.com>:
>>
>>> I know this is going to be a simple answer, but I have literally spent
>>> four hours on this and still do not have it working.
>>>
>>> I have looked through the archives and none of this "source" makes
>>> sense.
>>>
>>> I have installed the turba package in the horde framework.  I ran the
>>> turba.sql against my mysql server (using the horde database)
>>>
>>> I have set the sources.php to everything from horde to localsql to mysql
>>> to localhost, etc.  None of it works and I always get the DB Not found.
>>>
>>> I have set it both in admin section of horde and the sources.php file,
>>> to
>>> no avail.
>>>
>>> Any and all help would be appreciated.
>>>
>>> What the heck am I doing wrong?
>>
>> Is the database working normally in other areas, like pref storage or
>> authentication? It would probably help if you could provide your
>> sources.php file and horde/config/conf.php file - with sensitive
>> information removed, of course.
>>
>> --
>> Mike
>>
>> --
>> The Horde Project (www.horde.org)
>> mrubinsk at horde.org
>>
>> "Reality is merely an illusion, albeit a very persistent one." - A.
>> Einstein
>> --
>> Turba mailing list - Join the hunt: http://horde.org/bounties/#turba
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: turba-unsubscribe at lists.horde.org
>>

Please keep responses on the mailing list.

You have told turba to use the globally defined horde database  
connection, but have not actually configured any  
($conf['sql']['phptype'] = false).  You should configure a database  
using the administration interface (Admin->Setup->Horde->Database).

-- 
Mike

--
The Horde Project (www.horde.org)
mrubinsk at horde.org

"Reality is merely an illusion, albeit a very persistent one." - A. Einstein