[horde] Setup Problem malformed sql request

[Carlos Bergero]

Mauricio:
                Thx for your advice, I did as you say, except for 
removing the debian packages, which shuldn't be an issue, but I'm still 
having problems. First off all I can't login as administrator or any 
user for that matter, like in the previous install I have a successfull 
login in the syslog files, but the horde dump me to the login screen 
back, this time I see no errors from sql which makes me believe that 
problem might be located in the way users are handle, the mail site is a 
virtual domain site with several virtual domains 5, base on cyrus 
postgres and postfix. Right now I can't manage to show the server drop 
down menu, in the IMP configuration file, so I'm not sure if I manage to 
do that I might get a log in. Probably not.
                In any case is kinda frustrating, I ended up in the same 
corner while using the tar files from the horde site, I downloaded the 
horde-webmail-1.2.2.tar.gz file.

                Thx,
                         Carlos Bergero

mtecles at biof.ufrj.br escribió:
> I had a Debian Etch instalation with 
> Horde/Imp/Ingo/Kronolith/Mnemo/Mimp working fine and I migrated it to 
> Lenny. It is straigth forward.
>
> If you are setting it up form scratch, forget the Horde Debian 
> packages (uninstall then). Download latest Horde/Imp/etc stable 
> packages from Horde site. Drop horde database (I use mysql). Read and 
> follow the INSTALL docs, I sugest untaring horde in /var/www.
>
> I will send you some more information.
>
> Mauricio
>
> Citando Carlos Bergero <rak at fcien.edu.uy>:
>
>> Dear list members:
>>                               I'm setting up Horde3 in the institution
>> I'm working for using package from Debian GNU/Linux Etch release, which
>> is Horde 3.1.3 and IMP as authentication application version 4.1.3 over
>> PHP 5, the authentication back end is imap in the local server, I fix
>> the dependency problems the original package had. I'm connecting to a
>> PostgreSQL DB, connection is fine. But when I try to loging there is
>> some error in the sql query that bring back the user preferences, table
>> is fine and is loaded properly with user and preferences, it was
>> created correctly while trying to log in. When I check the horde3.log I
>> get the loggin success message but with a few lines of sql errors. In
>> the browser, I enter user, password and site correctly, no login error
>> message, and I get dump to the login page back. The horde3.log lines
>> are like this ones:
>> Apr 29 17:48:51 HORDE [debug] [imp] SQL Query by Prefs_sql::retrieve():
>> SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE
>> pref_uid = ?  AND (pref_scope = ? OR pref_scope = 'horde') ORDER BY
>> pref_scope [on line 137 of "/usr/share/horde3/lib/Horde/Prefs/sql.php"]
>>
>> Apr 29 17:48:51 HORDE [debug] [imp] SQL Query by Prefs_sql::retrieve():
>> SELECT pref_scope, pref_name, pref_value FROM horde_prefs WHERE
>> pref_uid = ? AND (pref_scope = ? OR pref_scope = 'horde') ORDER BY
>> pref_scope [on line 137 of "/usr/share/horde3/lib/Horde/Prefs/sql.php"]
>>
>> Apr 29 17:48:52 HORDE [notice] [imp] Login success for
>> carlos.bergero.dinama.gub.uy [10.1.4.107] to {1.1.1.5:143} [on line 152
>> of  "/usr/share/horde3/imp/redirect.php"]
>>
>>
>>                               After checking the sql.php file it seams
>> to be a problem when the query is build and neither pref_uid nor
>> pref_scope is pass to the sql query.
>>
>>                               Any advice to fix this issue.
>>
>>                               Sincerely,
>>                                                     Carlos Bergero
>>
>> -- 
>> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
>> Frequently Asked Questions: http://horde.org/faq/
>> To unsubscribe, mail: horde-unsubscribe at lists.horde.org
>
>
>