[turba] DB Not Found
Douglas W. Palme
dpalme at cwtruck.com
Tue Mar 30 15:00:28 UTC 2010
Apparently squirrelmail is not picking up the correct email addresses, so
my apologies to Mike for sending this to him and not the list:
My apologies, I flat out missed that.
One additional thing, I can now add an address but I get two messages, one
says it was added successfully and then
# MessageThe contact you requested does not exist.
When I display the addresses it shows the name but when I click on it, it
tells me that it cannot find the requested address.
Ideas?
>
> 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
>
More information about the turba
mailing list