[TYPO3-UG Muenchen] install auf anderen server moven ?

Sebastian Schubert basti-lists at sskm.de
Thu Aug 9 12:12:29 CEST 2007


hallo,

ich hab die website unserer feuerwehr (typo 3.7)  auf nen neuen server
gemoved.
alter server: php 4, mysql4.1 
neuer server: php 5.1, mysql 5.0.46
sonst gleiche distribution, die pfade sind a bisserl anders

nun kann ich mich nicht mehr anmelden im backend und auch das frontend
sagt mir das keine pages da wären
ich hab die sql statements mal mitgetraced und irgendwo scheint was nich
zu passen.
beim login im be fragt typo die datenbank nach dem user der sich
anmeldet und inserted dann dann direkt danach in die sys_log tabelle das
er den user name nicht gefunden hat ... :-/

sieht dann im mysql log so aus wie angehängt.

any ideas ? auch eine url zur richtigen google frage ist herzlich
willkommen ;)))

ciao
basti


-- 
"In god we trust, the Rest we Monitor"
Sebastian Schubert - RHCE
Stadtsparkasse Munich
Network and IT Security
--------------------------
basti-lists at sskm.de

Stadtsparkasse München | Anstalt des öffentlichen Rechts | Amtsgericht München I HRA 75459 | Sparkassenstr. 2, 80331 München
-------------- next part --------------
/usr/libexec/mysqld, Version: 5.0.46-log (Source distribution). started with:
Tcp port: 0  Unix socket: /var/lib/mysql/mysql.sock
Time                 Id Command    Argument
070808 22:08:43	      4 Connect     fffo at localhost on 
		      4 Init DB     ffforstenried
		      4 Query       DELETE FROM be_sessions
				WHERE
					ses_id = "1adee802421b4ac8cb17c7a375971199"
						AND ses_name = "be_typo_user"
		      4 Query       SELECT *
			FROM be_users
			WHERE
				pid IN (0) AND username="admin" AND be_users.pid=0  AND NOT be_users.disable AND NOT be_users.deleted AND (be_users.starttime<=1186603723) AND (be_users.endtime=0 OR be_users.endtime>1186603723)
		      4 Query       INSERT INTO sys_log
				(
					userid,
					type,
					action,
					error,
					details_nr,
					details,
					log_data,
					tablename,
					recuid,
					recpid,
					IP,
					tstamp,
					event_pid,
					NEWid
				) VALUES (
					"0",
					"255",
					"3",
					"3",
					"2",
					"Login-attempt from %s (%s), username \'%s\' not found!!",
					"a:3:{i:0;s:13:\"88.217.67.251\";i:1;N;i:2;s:5:\"admin\";}",
					"",
					"0",
					"0",
					"88.217.67.251",
					"1186603722",
					"-1",
					""
				)
		      4 Query       SELECT *
			FROM be_sessions,be_users
			WHERE
				be_sessions.ses_id = "1adee802421b4ac8cb17c7a375971199"
							AND be_sessions.ses_name = "be_typo_user"
							AND be_sessions.ses_userid = be_users.uid
							AND (
				be_sessions.ses_iplock="88.217.67.251"
				OR be_sessions.ses_iplock="[DISABLED]"
				)
							AND be_sessions.ses_hashlock=68475275
							AND be_users.pid=0  AND NOT be_users.disable AND NOT be_users.deleted AND (be_users.starttime<=1186603723) AND (be_users.endtime=0 OR be_users.endtime>1186603723)
		      4 Query       DELETE FROM be_sessions
				WHERE
					ses_id = "1adee802421b4ac8cb17c7a375971199"
						AND ses_name = "be_typo_user"
		     11 Connect     fffo at localhost on 
070808 22:08:57	     11 Init DB     ffforstenried
		     11 Query       SELECT *
			FROM fe_sessions,fe_users
			WHERE
				fe_sessions.ses_id = "8844e5b9ea"
							AND fe_sessions.ses_name = "fe_typo_user"
							AND fe_sessions.ses_userid = fe_users.uid
							AND (
				fe_sessions.ses_iplock="88.217"
				OR fe_sessions.ses_iplock="[DISABLED]"
				)
							AND fe_sessions.ses_hashlock=68475275
							 AND NOT fe_users.disable AND NOT fe_users.deleted AND (fe_users.starttime<=1186603737) AND (fe_users.endtime=0 OR fe_users.endtime>1186603737)
		     11 Query       DELETE FROM fe_sessions
				WHERE
					ses_id = "8844e5b9ea"
						AND ses_name = "fe_typo_user"
		     11 Query       SELECT *
			FROM fe_session_data
			WHERE
				hash="8844e5b9ea"
		     11 Query       SELECT *
			FROM be_sessions,be_users
			WHERE
				be_sessions.ses_id = "1adee802421b4ac8cb17c7a375971199"
							AND be_sessions.ses_name = "be_typo_user"
							AND be_sessions.ses_userid = be_users.uid
							AND (
				be_sessions.ses_iplock="88.217.67.251"
				OR be_sessions.ses_iplock="[DISABLED]"
				)
							AND be_sessions.ses_hashlock=68475275
							AND be_users.pid=0  AND NOT be_users.disable AND NOT be_users.deleted AND (be_users.starttime<=1186603737) AND (be_users.endtime=0 OR be_users.endtime>1186603737)
		     11 Query       DELETE FROM be_sessions
				WHERE
					ses_id = "1adee802421b4ac8cb17c7a375971199"
						AND ses_name = "be_typo_user"
		     11 Query       SELECT pages.uid,sys_domain.redirectTo,sys_domain.prepend_params
			FROM pages,sys_domain
			WHERE
				pages.uid=sys_domain.pid
						AND sys_domain.hidden=0
						AND (sys_domain.domainName="www.feuerwehr-forstenried.de" OR sys_domain.domainName="www.feuerwehr-forstenried.de/")  AND pages.deleted=0 AND pages.hidden=0 AND (pages.starttime<=1186603736) AND (pages.endtime=0 OR pages.endtime>1186603736)  AND doktype<200 AND fe_group IN (0,-1)
			LIMIT 1
		     11 Query       SELECT *
			FROM pages
			WHERE
				pid=0 AND pages.deleted=0 AND pages.hidden=0 AND (pages.starttime<=1186603736) AND (pages.endtime=0 OR pages.endtime>1186603736)  AND doktype<200 AND fe_group IN (0,-1)
			ORDER BY sorting
			LIMIT 1



More information about the TYPO3-muenchen mailing list