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

Tue Jan 4 19:38:58 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 1:29:37 PM
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>:

>
>
>
>
> ----- 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>
Temporarily changed to the SQL Authentication and left all default  settings.  
Re-ran that PHP script and it did show the users - but it  didn't delete any old 
information from the database.

I had to revert back to horde doing the authentication.  When using SQL  
authentication, the Horde login screen comes up.  After logging in, then  the 
imp login screen comes up - so you have to authenticate twice.
>>> 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).

Yes, that's the idea.

Jan.

Temporarily changed to the SQL Authentication and left all default  settings.  
Re-ran that PHP script and it did show the users - but it  didn't delete any old 
information from the database.

I had to revert back to horde doing the authentication.  When using SQL  
authentication, the Horde login screen comes up.  After logging in, then  the 
imp login screen comes up - so you have to authenticate twice.

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