[horde] MySQL session handler problems with Horde 2.2

[Ethan Weinstein]

Ok, I fixed that one.. It was a merely a typo in config/horde.php. I 
apologize =)
But, I have found another problem in upgrading from Horde 2.1 to 2.2:

Redirection to SSL-only ($conf['use_ssl'] = 1;) is no longer working.
Using Horde 2.1, https uri's are always generated.  After upgrading,
The browser gives an error if one goes to http://horde/url

Apache logs this:

[Wed Jan 22 17:02:25 2003] [error] [client 1.2.3.4] Invalid method in 
request €L

[Wed Jan 22 17:02:28 2003] [error] [client 1.2.3.4] Invalid method in 
request €L

[Wed Jan 22 17:10:26 2003] [error] [client 1.2.3.4] Invalid method in 
request €C

[Wed Jan 22 17:10:32 2003] [error] [client 1.2.3.4] Invalid method in 
request €C


Which looks to me like https spoken on http only port.
Is there perhaps a problem in the redirection or rewriting code ?

https://horde/url works fine, which leads me to this conclusion.  Horde 
2.1 did not need the https, it rewrote to it automatically.

-Ethan Weinstein

Ethan Weinstein wrote:
> I installed horde 2.2, and am attempting to use the mysql session
> handler.  I'm getting these errors while trying to login:
> 
> Jan 22 11:55:42 spicymeatball HORDE[1966]: [horde] SQL Query by
> SessionHandler_mysql::read(): query = "SELECT session_data FROM
> mysql_sessionhandler WHERE session_id =
> f36fabe85b2e0c576b6b6943fcc06276" [on line 96 of
> "/usr/local/apache2/htdocs/horde2/lib/SessionHandler/mysql.php"]
> Jan 22 11:55:42 spicymeatball HORDE[1966]: [horde] Error retrieving
> session data (id = f36fabe85b2e0c576b6b6943fcc06276) [on line 104 of
> "/usr/local/apache2/htdocs/horde2/lib/SessionHandler/mysql.php"]
> Jan 22 11:55:42 spicymeatball \177ÿêx\177ÿê|[1966]: [horde] SQL Query by
> SessionHandler_mysql::write(): query = "REPLACE INTO
> mysql_sessionhandler (session_id, session_data, session_lastmodified)
> VALUES (f36fabe85b2e0c576b6b6943fcc06276,
> prefs_cache|a:1:{s:7:\"_filled\";a:0:{}}hordeMessageStacks|a:1:{s:6:\"status\";a:0:{}}, 
> 
> 1043254542)" [on line 124 of
> "/usr/local/apache2/htdocs/horde2/lib/SessionHandler/mysql.php"]
> Jan 22 11:55:42 spicymeatball \177ÿêx\177ÿê|[1966]: [horde] Error
> writing session data [on line 128 of
> "/usr/local/apache2/htdocs/horde2/lib/SessionHandler/mysql.php"]
> 
> The mysql_sessionhandler table does exist within the horde db, the
> permissions and username+password are definately correct..  Here's what
> I have in horde.php:
> 
> $conf['sessionhandler']['type'] = 'mysql';
> 
> // Database or other drivers might require configuration parameters
> // here.
> $conf['sessionhandler']['params'] = array();
> $conf['sessionhandler']['params']['phptype'] = 'mysql';
> $conf['sessionhandler']['params']['hostspec'] = 'localhost';
> $conf['sessionhandler']['params']['username'] = 'horde';
> $conf['sessionhandler']['params']['password'] = 'password_deleted';
> $conf['sessionhandler']['params']['database'] = 'horde2';
> $conf['sessionhandler']['params']['table'] = 'mysql_sessionhandler';
> 
> What gives?  and what's with the bizarre syslog messages
> "\177ÿêx\177ÿê|[1966]:" ?? Did I forget a param?
> 
> I was using a custom mysql sessionhandler with horde 2.1 and it worked
> quite well.
> 
> thanks,
> 
> 
> Ethan Weinstein
> 
> 
>