[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