[horde] MDB2 Error: unknown error - When Attempting to Create Calendar, Address Book, Memo, or Task

Tue Jan 4 16:06:23 UTC 2011

Hi Jan -

Thank you for the reply.

Unfortunately in my horde configuration - if I go to Administration and then to 
Users, nothing shows up.  I get this noticed (and one other one):

Your authentication backend does not support adding users. If you wish  to use 
Horde to administer user accounts, you must use a different  authentication 
backend.

In the Horde configuration, I have this set for the authentication backend:
'Let a Horde application handle authentication'

I then have 'Imp' chosen in the box below that.

Is there another setting I need to change to get the users to show up?

In addition - I have deleted users previously by just going to the horde_users 
table and removing the line from the database - so I fear there is a lot of old 
users I've deleted with stuff in the databases still.

Brian S.

----- Original Message ----
From: Jan Schneider <jan at horde.org>
To: horde at lists.horde.org
Sent: Tue, January 4, 2011 8:24:59 AM
Subject: Re: [horde] MDB2 Error: unknown error - When Attempting to Create 
Calendar, Address Book, Memo, or Task

Zitat von Brian Spraker <spraker at yahoo.com>:

> No more ideas on what to check or look for?
> 
> I've set Horde to use PHP 5.2.14 in FastCGI mode (since PHP 5.3.2 is the 
module
> install for Apache).  Everything is working normally - but as you can imagine,
> PHP running in FastCGI mode is much more processor-intensive and it has to 
open
> the configuration file and all extensions everytime a PHP page is parsed.

The opposite is actually true, using FastCGI for PHP usually scales much better, 
and beside *not* having to load the configuration and the extensions on every 
request, you *additionally* save the PHP startup.

> While a completely different subject -
> 
> When you need to fully delete a user account, how can you be sure you delete 
>the
> user account and all settings that are stored in the horde database - address
> books, preferences, history, calendars, etc?  I've noticed that whenever I
> "delete" users - which is just deleting their mailbox and the row in the
> horde_users table, all of their preferences and such still remain.

Use Horde to delete (or at least reset) users.

> Brian S.
> http://www.bsntech.com
> 
> 
> 
> ----- Original Message ----
> From: Michael J Rubinsky <mrubinsk at horde.org>
> To: Brian Spraker <spraker at yahoo.com>
> Cc: "horde at lists.horde.org" <horde at lists.horde.org>
> Sent: Sun, January 2, 2011 12:33:04 PM
> Subject: Re: [horde] MDB2 Error: unknown error - When Attempting to Create
> Calendar, Address Book, Memo, or Task
> 
> 
> On Jan 2, 2011, at 12:19 PM, Brian Spraker <spraker at yahoo.com> wrote:
> 
>> OK - so Horde doesn't have issues with PHP 5.3.x.  However, what about the
>> other
>> 
>> applications - turba, kronolith, nmemo, etc?
> 
> Sorry, that is what I meant.  I am running Horde 3 and Horde 4 on the exact 
>same
> version of PHP, on ubuntu, without any problems.
> 
> I am assuming that you have installed separate php-mysql extensions for each 
>php
> version you are running and have ensured each version is using the correct
> extensions?
> 
> 
>> 
>> Horde does work without problems with PHP 5.3.x, but the other applications
>> throw the MDB2 error.
>> 
>> I've turned off E_DEPRECATED errors and ensured that pear MDB2,  MDB2/mysql,
>> MDB2/mysqli and MDB2_Schema are installed.  The problem  persists.
>> 
>> But, the moment that I change to using PHP 5.2.14, everything works.
>> 
>> Brian S.
>> 
>> 
>> ----- Original Message ----
>> From: Michael J Rubinsky <mrubinsk at horde.org>
>> To: horde at lists.horde.org
>> Sent: Sun, January 2, 2011 10:56:17 AM
>> Subject: Re: [horde] MDB2 Error: unknown error - When Attempting to Create
>> Calendar, Address Book, Memo, or Task
>> 
>> 
>> 
>> On Jan 2, 2011, at 11:30 AM, Brian Spraker <spraker at yahoo.com> wrote:
>> 
>>> Hello all,
>>> 
>>> I began to recently receive the error message:
>>> 
>>> MDB2 Error:  unknown error
>>> 
>>> When attempting to create a new calendar, address book, memo pad, or task 
pad
> 
>>> in
>>> 
>>> Horde.
>>> 
>>> I have the very latest versions of all software for Horde.
>>> 
>>> Here is the catch that I've found.
>>> 
>>> I recently updated the Ubuntu server from PHP 5.2.x to PHP 5.3.2 with a
>>> distribution upgrade.  I also have installed PHP 4.2.14 in FastCGI mode so I
>>> can
>>> 
>>> run both versions of PHP simultaneously depending upon one extra 
>configuration
>> 
>> 
>>> setting in the VirtualHosts in Apache.
>>> 
>>> Ever since the upgrade to PHP 5.3.2, this error message occurs.  If I add 
the
> 
>>> configuration line in the Apache config to have the VirtualHost use PHP 
>>5.2.14,
>>> 
>>> 
>>> the error does not happen and the object is created without a problem.
>>> 
>>> Has anyone heard of potential problems with PHP 5.3.x with Horde 
applications
> 
>>> and any solutions?  Really would prefer to use PHP 5.3.2 with Horde instead 
>of
>> 
>> 
>>> downgrading to PHP 5.2.14 for the VirtualHost.
>> 
>> There are no issues with Horde and PHP 5.3.x.
>> 
>> 
>>> 
>>> In the Horde.log:
>>> 
>>> [pid 8202 on line 1053 of
>>> "/home/bsntech-com/www/webmail/lib/Horde/Share/sql.php"]
>>> Jan 02 10:09:51 HORDE [error] [kronolith] MDB2 Error: unknown error: 
>_execute:
>> 
>> 
>>> [Error message: Unable to execute statement]
>>> [Last executed query: INSERT INTO kronolith_shares (share_name, share_owner,
>>> attribute_name, attribute_desc, perm_creator, perm_default, perm_guest,
>>> share_flags, share_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)]
>>> [Native code: 0]
>>> [pid 8283 on line 1053 of
>>> "/home/bsntech-com/www/webmail/lib/Horde/Share/sql.php"]
>>> 
>>> 
>>> Thank you for any help you can provide!
>>> 
>>> Brian Spraker -- BsnTech Networks
>>> http://www.bsntech.com
>> 
>> Check that both instances of PHP have the same database extensions installed,
>> and both have the needed PEAR MDB2 drivers installed...
>> 
>> --
>> Mike
>> Sent from my iPad...
> 
> 
> 
> 
> --
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
> 

Jan.

--Do you need professional PHP or Horde consulting?
http://horde.org/consulting/

--Horde mailing list
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: horde-unsubscribe at lists.horde.org