[TYPO3-english] Cannot login anymore

[Ronald Wiplinger (Lists)]

Valter Rodrigues wrote:
> Hi,
> You could reset a backend password using phpMyAdmin in table be_users. 
> Put a known hash in password field.
>   

I came closer to the problem, but don't know how to solve it!!!

The webhoster has a limit of 100 MB on the database.
The table cache_pages has a size of 143.8 MB  (and totally 148.1 MB what
is bigger than allowed).

I believe, that because each login will be logged, but cannot anymore be
logged due to the missing allowance, typo3 decided not to let me in anymore.

HOW can I clear the table cache_pages, sothat no further damages will occur?

(I have also asked the webhoster to increase the limit, but have not get
any respond from them,...)

bye

Ronald

> Regards,
> Valter
>
> O/H Ronald Wiplinger (Lists) ??????:
>   
>> I start a new thread with it, ...
>>
>> I have installed two wec modules which were not working. After that I
>> got logged out (time out) and now I cannot log in anymore.
>>
>> NO user/admin can login
>> "Your login attempt did not succeed. Make sure to spell your username
>> and password correctly, including upper/lowercase characters."
>>
>> I activated the Install tool and tried to add a new admin and it gives
>> me an error:
>> Error: *INSERT command denied to user '*****'@'*****' for table 'be_users'
>> (some lines above it says:  **Connected to SQL database successfully)
>>
>> The pages are displayed correctly.
>>
>> I have removed the wec_ entries in localconf.php, so that it looks like:
>>
>> **cat localconf.php
>> <?php
>> $TYPO3_CONF_VARS['SYS']['sitename'] = 'New TYPO3 site';
>>
>>     // Default password is "joh316" :
>> $TYPO3_CONF_VARS['BE']['installToolPassword'] = '*******************';
>>
>> $TYPO3_CONF_VARS['EXT']['extList'] =
>> 'tsconfig_help,context_help,extra_page_cm_options,impexp,sys_note,tstemplate,tstemplate_ceditor,tstemplate_info,tstemplate_objbrowser,tstemplate_analyzer,func_wizards,wizard_crpages,wizard_sortpages,lowlevel,install,belog,beuser,aboutmodules,setup,taskcenter,info_pagetsconfig,viewpage,rtehtmlarea,css_styled_content,t3skin';
>>
>> $typo_db_extTableDef_script = 'extTables.php';
>>
>> ## INSTALL SCRIPT EDIT POINT TOKEN - all lines after this points may be
>> changed by the install script!
>>
>> $typo_db_username = '***********';    //  Modified or inserted by TYPO3
>> Install Tool.
>> $typo_db_password = '***********';    //  Modified or inserted by TYPO3
>> Install Tool.
>> $typo_db_host = '**************';    //  Modified or inserted by TYPO3
>> Install Tool.
>> $TYPO3_CONF_VARS['SYS']['encryptionKey'] = '*****************';    // 
>> Modified or inserted by TYPO3 Install Tool.
>> $TYPO3_CONF_VARS['SYS']['compat_version'] = '4.2';    //  Modified or
>> inserted by TYPO3 Install Tool.
>> $typo_db = '***********';    //  Modified or inserted by TYPO3 Install Tool.
>> $TYPO3_CONF_VARS['BE']['installToolPassword'] = '**************';    // 
>> Modified or inserted by TYPO3 Install Tool.
>> $TYPO3_CONF_VARS['SYS']['sitename'] = 'Taipei International Church';   
>> //  Modified or inserted by TYPO3 Install Tool.
>> $TYPO3_CONF_VARS['GFX']['im_combine_filename'] = 'composite';    // 
>> Modified or inserted by TYPO3 Install Tool.
>> $TYPO3_CONF_VARS['GFX']['im_version_5'] = 'im5';    //  Modified or
>> inserted by TYPO3 Install Tool.
>> $TYPO3_CONF_VARS['GFX']['TTFdpi'] = '96';    //  Modified or inserted by
>> TYPO3 Install Tool.
>> $TYPO3_CONF_VARS['SYS']['curlUse'] = '1';    //  Modified or inserted by
>> TYPO3 Install Tool.
>> $TYPO3_CONF_VARS['FE']['disableNoCacheParameter'] = '0';    //  Modified
>> or inserted by TYPO3 Install Tool.
>> // Updated by TYPO3 Install Tool 13-09-08 03:31:13
>> $TYPO3_CONF_VARS['EXT']['extList'] =
>> 'css_styled_content,tsconfig_help,context_help,extra_page_cm_options,impexp,sys_note,tstemplate,tstemplate_ceditor,tstemplate_info,tstemplate_objbrowser,tstemplate_analyzer,func_wizards,wizard_crpages,wizard_sortpages,lowlevel,install,belog,beuser,aboutmodules,setup,taskcenter,info_pagetsconfig,viewpage,rtehtmlarea,t3skin,automaketemplate,tt_news,newloginbox,cal,date2cal';   
>> // Modified or inserted by TYPO3 Extension Manager.
>> $TYPO3_CONF_VARS['EXT']['extConf']['tt_news'] =
>> 'a:12:{s:13:"useStoragePid";s:1:"1";s:13:"noTabDividers";s:1:"0";s:25:"l10n_mode_prefixLangTitle";s:1:"1";s:22:"l10n_mode_imageExclude";s:1:"1";s:20:"hideNewLocalizations";s:1:"0";s:13:"prependAtCopy";s:1:"1";s:5:"label";s:5:"title";s:9:"label_alt";s:0:"";s:10:"label_alt2";s:0:"";s:15:"label_alt_force";s:1:"0";s:21:"categorySelectedWidth";s:1:"0";s:17:"categoryTreeWidth";s:1:"0";}';   
>> //  Modified or inserted by TYPO3 Extension Manager.
>> $TYPO3_CONF_VARS['EXT']['extConf']['date2cal'] =
>> 'a:8:{s:11:"calendarCSS";s:6:"t3skin";s:8:"firstDay";s:1:"1";s:7:"doCache";s:1:"1";s:13:"natLangParser";s:1:"1";s:8:"datetime";s:1:"1";s:18:"secOptionsAlwaysOn";s:1:"1";s:6:"calImg";s:29:"EXT:date2cal/res/calendar.png";s:7:"helpImg";s:29:"EXT:date2cal/res/helpIcon.gif";}';   
>> //  Modified or inserted by TYPO3 Extension Manager.
>> // Updated by TYPO3 Extension Manager 10-10-08 09:07:37
>> ?>
>>
>>
>> I have deleted all typo3conf/temp_CACHE* files
>>
>> I don't get access on that webhoster to the log files, but they gave me
>> a php code which I could include in my php codes to get a logfile, ...
>> out of question to do that for ME!!!
>>
>>
>> What can I do now?
>>
>> bye
>>
>> Ronald
>>  
>> *
>>     
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>