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

Tue Jan 4 17:54:11 UTC 2011

I apologize for that.

When I first responded, I only responded directly to you and didn't add the 
horde at lists.horde.org onto the e-mail.  So I then replied again but made it go 
to just the list.

I see that there is a script that says it will cleanup a database:

http://wiki.horde.org/DatabaseCleanup

Do both of those need to be run or only one of them?

Brian S.

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

Please don't top-post.

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

> ----- 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...
>>> 
> 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?

You need an IMAP server that supports listing mailboxes, and configure it in 
imp/config/servers.php. Or you need to authenticate against the same 
authentication backend that your IMAP server uses.
Or you need to use the Horde API method to clean up user data (removeUserData).

> 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.

True. You can generate a list of those from the horde_prefs table.

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