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

Tue Jan 4 19:05:22 UTC 2011

----- Original Message ----
From: Jan Schneider <jan at horde.org>
To: Brian Spraker <spraker at yahoo.com>
Cc: horde at lists.horde.org
Sent: Tue, January 4, 2011 12:07:29 PM
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 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.
> 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?

The first one looks more correct to me, but please not that those are  
user-contributed scripts.

Jan.

I used the first script - which is a PHP script.  It told me that there was only 
"1 active users" and "21 data user found".  This cannot be right because I know 
there are at least 10 users active at this point.

I've modified the bash script - which is the second one on the page - to include 
several other checks/deletions - including kronolith_shares, mnemo_shares, 
turba_shares, nag_shares, horde_histories, and ingo_lists.  Maybe this will work 
- but this script requires you to run it with the user's login as a parameter - 
whereas the first script is suppose to delete all old information.

The IMAP server I'm using is dovecot and it uses MySQL to pull the 
username/password from the horde_users table.  Basically I'm using the 
horde_users like a single-sign-on system with pulling usernames/passwords for 
accounts.

Does this mean I would actually need to change the authentication driver on the 
"Authentication" tab of Horde to "SQL Authentication"?  I believe I've done this 
before leaving all of the settings as default - but it broke something in the 
process (like logging in seemed to be a problem).

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