Search

I'm trying to install Symphony 2.3.1 on a Mac OS X Mountain Lion server. After installing MySQL 5.6 the Symphony installation has gone fine and I get the default web page come up.

However, when I try to log in to the admin page (/symphony/) I get the login window, enter my username and password and then straight back to the login window.

When I check the Web server's error_log I see the message below.

Any ideas?

TIA, Steve Ball

[Tue Feb 19 18:02:06 2013] [error] [client 192.168.0.107] PHP Fatal error:  Uncaught exception 'DatabaseException' with message 'MySQL Error (1406): Data too long for column 'session' at row 1 in query: INSERT INTO `sym_sessions` (`session`, `session_expires`, `session_data`) VALUES ('9fd6jlkqesuol3dthtd1d9gmgiem11kmk4qfo33p9545nlvt2q1ddi7mlnd1glvkl3fnolaov25bhhepbt4jpbcev4501q4kqkipd61', '1361257326', 'sym-|a:2:{s:8:\"username\";s:5:\"myusername\";s:4:\"pass\";s:92:\"PBKDF2v1|10000|0dfb8e2ddf1b6f182220|rUrZqTbT+feuj6jiRoJa1gBl6/hySmapk+7ygxnzrFk38XGwwPdUXA==\";}') ON DUPLICATE KEY UPDATE  `session` = '9fd6jlkqesuol3dthtd1d9gmgiem11kmk4qfo33p9545nlvt2q1ddi7mlnd1glvkl3fnolaov25bhhepbt4jpbcev4501q4kqkipd61', `session_expires` = '1361257326', `session_data` = 'sym-|a:2:{s:8:\"username\";s:5:\"myusername\";s:4:\"pass\";s:92:\"PBKDF2v1|10000|0dfb8e2ddf1b6f182220|rUrZqTbT+feuj6jiRoJa1gBl6/hySmapk+7ygxnzrFk38XGwwPdUXA==\";}'' in /Library/Server/Web/Data/Sites/www8888/symphony/lib/toolkit/class.mysql.php:807nStack trace:n#0 /Library/Server/Web/Data/Sites/www8888/symphony/lib/toolkit/class.mysql.php(45 in /Library/Server/Web/Data/Sites/www8888/symphony/lib/toolkit/class.mysql.php on line 807, referer: http://www.explain.com.au:8888/symphony/

Odd! The session column is usually set to a VARCHAR(100), but in your example, the session ID is 103 characters long. Increasing this column length to something higher will fix your issue.

Do you have any PHP security modules installed or what not? I'll have a read around too, I'm not sure what causes the session length to vary.

That makes sense. I'll look at modifying the installation to allow a larger limit on session IDs.

Success!

I changed line 263 of install/includes/install.sql to:

> `session` varchar(256) COLLATE utf8_unicode_ci NOT NULL,

basically changing the field from size 100 to 256.

Hi,

I've got the same trouble, but modifying session varchar(256) doesn't change anything, it straight back to the login window.

Any suggestions ?

Server info:

PHP Version 5.3.16 System :Linux web257.240.ha.ovh.net 3.2.42-uid-limit2-mutu-grs-ipv6-64 #2 SMP Wed May 15 18:28:22 CEST 2013 x86_64 Server API : CGI/FastCGI Virtual Directory : Support disabled

Are you receiving an error message at all @grg?

Hello @brendo,

No, Symphony don't send any error message; also when i try to retrieve password, nothing append :(

The install seems to be ok, the tables was created on base and i've saw the home page of Symphony (index.php) before attempt to log (www.mysite/symphony).

A detail, my base is'nt empty, i've let 5 tables containing data; it should not cause any problem ?

ps: can we avoid momentarily the login to see if the rest of the intallation Symphony working properly?

thank's

maybe an "allow overwrite" issue, meens apache can't rewrite?

Create an account or sign in to comment.

Symphony • Open Source XSLT CMS

Server Requirements

  • PHP 5.3-5.6 or 7.0-7.3
  • PHP's LibXML module, with the XSLT extension enabled (--with-xsl)
  • MySQL 5.5 or above
  • An Apache or Litespeed webserver
  • Apache's mod_rewrite module or equivalent

Compatible Hosts

Sign in

Login details