[Typo3-linux] Can not log in to backend.

[Andrew Healey]

I was able to solve the problem.  I went in MySQL and changed the default value
to "NULL" (thus, setting "NOT NULL" to 0).

So, its fixed but is there a downside to setting this to something different
than its defaults?  Is there a reason it is set to "NOT NULL" to begin with?


--- Andrew Healey <drewhealey at yahoo.com> wrote:

> I installed the dummy and source tar packages onto my webserver.  Everything
> works great.  The install tool worked.  It created the database on my dB
> server.  The problem now is that I can not log into the backend.
>  
>  When I try with "admin" and "password", I get the error: Your login attempt
> did not succeed. Make sure to spell your username and password correctly,
> including upper/lowercase characters.
>  
>  So, I set up ethereal to see if anything fishy was going on and to see what
> the Error Code from MySQL is.  I got this: Response Error Code: 554.  The
> payload states: Field 'ses_data' doesn't have a default value.  Huh?
>  
>  So, I went back to the Install Tool and to the Database Analyser.  I
> selected the option to "create 'admin' user".  I entered the new username and
> password and selected Write To Database.  Typo says "User Created".  Upon
> further investigation, that is not true.  There are no new entries in the
> be_users table.  So, I set up ethereal to capture the traffic between my web
> and dB servers.  It is getting this error: Response Error Code: 554.  The
> payload states: Field 'usergroup' doesn't have a default value.
>  
>  Different field, same error.  So, do you think these errors could be the
> reason I am not able to either enter a new admin user or log into the backend
> with the default user account?  Any other ideas?  Anybody know how to fix
> these errors?
>  
>  Thanks!
>  Drew
>  
>  
>   Here are my vitals.  Fedora Core 3, PHP 4.3.11, MySQL 5.0.15, Apache
> 2.0.53, Typo 3.8.0.
>  
>  ### DEBUG SYSTEM INFORMATION - START ###
>  HTTP_HOST           : 149.60.156.90
>  TYPO3_HOST_ONLY     : 149.60.156.90
>  TYPO3_PORT          : 
>  PATH_INFO           : 
>  QUERY_STRING        : TYPO3_INSTALL[type]=phpinfo
>  REQUEST_URI         : /typo3/install/index.php?TYPO3_INSTALL[type]=phpinfo
>  HTTP_REFERER        :
> http://149.60.156.90/typo3/install/index.php?TYPO3_INSTALL[type]=database
>  TYPO3_REQUEST_HOST  : http://149.60.156.90
>  TYPO3_REQUEST_URL   :
> http://149.60.156.90/typo3/install/index.php?TYPO3_INSTALL[type]=phpinfo
>  TYPO3_REQUEST_SCRIPT: http://149.60.156.90/typo3/install/index.php
>  TYPO3_REQUEST_DIR   : http://149.60.156.90/typo3/install/
>  TYPO3_SITE_URL      : http://149.60.156.90/
>  TYPO3_SITE_SCRIPT   : typo3/install/index.php?TYPO3_INSTALL[type]=phpinfo
>  TYPO3_SSL           : 
>  SCRIPT_NAME         : /typo3/install/index.php
>  TYPO3_DOCUMENT_ROOT : /var/www/html
>  SCRIPT_FILENAME     : /var/www/html/typo3/install/index.php
>  REMOTE_ADDR         : 149.60.156.90
>  REMOTE_HOST         : 
>  HTTP_USER_AGENT     : Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.12)
> Gecko/20050922 Fedora/1.0.7-1.1.fc3 Firefox/1.0.7
>  HTTP_ACCEPT_LANGUAGE: en-us,en;q=0.5
>  CONST: PHP_OS       : Linux
>  CONST: TYPO3_OS     : 
>  CONST: PATH_thisScri: /var/www/html/typo3/install/index.php
>  CONST: php_sapi_name: apache2handler
>  OTHER: TYPO3_VERSION: 3.8.0
>  OTHER: PHP_VERSION  : 4.3.11
>  imagecreatefromgif(): 1
>  imagecreatefrompng(): 1
>  imagecreatefromjpeg(: 1
>  imagegif()          : 1
>  imagepng()          : 1
>  imagejpeg()         : 1
>  imagettftext()      : 1
>  OTHER: IMAGE_TYPES  : 15
>  OTHER: memory_limit : 64M
>  SERVER: SERVER_PORT : 80
>  SERVER: SERVER_SOFTW: Apache/2.0.53 (Fedora)
>  SERVER: GATEWAY_INTE: CGI/1.1
>  SERVER: SCRIPT_NAME : /typo3/install/index.php
>  SERVER: PATH_TRANSLA: /var/www/html/typo3/install/index.php
>  T3CV_GFX: image_proc: 1
>  T3CV_GFX: gdlib     : 1
>  T3CV_GFX: gdlib_png : 1
>  T3CV_GFX: gdlib_2   : 1
>  T3CV_GFX: im        : 1
>  T3CV_GFX: im_path   : /usr/bin/
>  T3CV_GFX: im_path_lz: /usr/bin/
>  T3CV_GFX: im_version: 1
>  T3CV_GFX: im_negate_: 1
>  T3CV_GFX: im_imvMask: 0
>  T3CV_GFX: im_combine: composite
>  ### DEBUG SYSTEM INFORMATION - END ###
>  
> > _______________________________________________
> Typo3-linux mailing list
> Typo3-linux at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-linux